LSMW Direct Input Method

[Former Member]

Hi,

I need to upload files in CS01 transaction, two different files(header,Item) in one LSMW .But its giving error for Conversion Step.Do we need to rule or map the CS01 transaction also in Mapping ? Its giving Error: For type "C", a maximum length specification of 65535 is allowed.Pls help me to solve .

[Former Member]

Ok here are the steps to do this ...

In all steps I have copied fields and values from SAP screen using Ctrl Y key

After each step you can compare your screen with the values I gave..

I should be easy if you follow these steps

Step 1

Maintian Object attributes

Use standard Batch / Direct Input

Object 0030 Material BOM

Method 0001 Create

Program Name RCSBI010

Program Type B Batch Input

Step 2

Maintain Source structure

Create BOM Header and create Bom details as a child to Bom Header

should look like this...BOM details is assigned as a child to BOM Header

BOM_CREATE1 - BOM_CREATE - BOM_CREATE BOM_CREATE1

Source Structures

BOM_HEADER Header Data for Bill of Material

BOM_DETAILS Bom details

Step 3

Maintain source fields..

Create a field called "IDENT" field type C and length 1....give value to IDENT in both places

Give IDENT= 1 for header and IDENT=2 for item details

below are sample fields that I used,

compare you screen with following

BOM_CREATE1 - BOM_CREATE - BOM_CREATE BOM_CREATE1

Source Fields

BOM_HEADER Header Data for Bill of Material

IDENT C(001) Ident

Identifing Field Content: 1

WERKS C(004) Plant

MATNR C(018) Material Number

STLAL C(002) Alternative BOM

SPACE1 C(003) space1

BMENG C(001) Base quantity

STLAN C(013) BOM Usage

BOM_DETAILS Bom details

IDENT C(001) ident

Identifing Field Content: 2

POSNR C(004) BOM Item Number

IDNRK C(018) BOM component

MENGE C(013) Component quantity

MEINS C(003) Component unit of measure

AUSCH C(005) Component scrap in percent

AVOAU C(005) Operation scrap in percent

SANKA C(001) Indicator for relevancy to costing

NLFZT C(003) Lead-time offset

LGORT C(004) Issue location for production order

POSTP C(001) Item Category (Bill of Material)

SORTF C(010) Sort String

REKRS C(001) Indicator: recursiveness allowed

NETAU C(001) Indicator: Net scrap

INTRM C(018) Phantom material

Step 4

Maintain source structure as shown below

Just assign BOM header to all structures...

you screen should look like below

BOM_CREATE1 - BOM_CREATE - BOM_CREATE BOM_CREATE1

Structure Relations

BGR00 Batch Input Structure for Session Data <<<< BOM_HEADER Header Data for Bill of Material

Select Target Structure BGR00 .

BICSK Batch Input Structure for BOM Header Data <<<< BOM_HEADER Header Data for Bill of Material

Select Target Structure BICSK .

BICSP Batch Input Structure for BOM Item Data <<<< BOM_DETAILS Bom details

Select Target Structure BICSP .

BICSU Batch Input Structure for BOM Sub-Item Data

Step 5

Maintain field mapping ..

make sure you maintained transaction CS01

Step 6 Specify files

For BOM header

File &#61664; Point to a text file where you are storing BOM info

File content &#61664;select data for multiple source structures(Seq File)

Select &#61664;tabular

Leave remaining as is.

Check if your screen looks similar to this shown below

BOM_CREATE1 - BOM_CREATE - BOM_CREATE BOM_CREATE1

Files

Legacy Data On the PC (Frontend)

Bom header C:\bom.txt

Data for Multiple Source Structures (Sequential Files)

Separator Tabulator

Field Order Matches Source Structure Definition

With Record End Indicator (Text File)

Code Page ASCII

Legacy Data On the R/3 server (application server)

Imported Data File for Imported Data (Application Server)

Imported Data BOM_CREATE.lsmw.read

Converted Data File for Converted Data (Application Server)

Converted Data BOM_CREATE1_.lsmw.conv

Logical Path C:\bom.txt

Logical File bom.txt

Wildcard Value Value for Wildcard '*' in File Name

Step 7

Assign same file to header and item structure as we are using sequence file

Your screen will look as shown below

BOM_CREATE1 - BOM_CREATE - BOM_CREATE BOM_CREATE1

Source Structures and Files

BOM_HEADER Header Data for Bill of Material

Bom header C:\ bom.txt

BOM_DETAILS Bom details

Bom header C:\ bom.txt

Test file format

1 PLT1 Material1 1 1 1

2 0010 Comp1 0.198 FT3 0 0 X 0 0020 L

2 0020 Comp2 0.045 FT3 0 0 X 0 0020 L

2 0030 Comp3 0.195 FT3 0 0 X 0 0020 L

1 PLT1 Material2 1 1 1

2 0010 Comp1 0.114 FT3 0 0 X 0 0020 L

1 PLT1 Material3 1 1 1

2 0010 Comp1 0.061 FT3 0 0 X 0 0020 L

Here inorder to get this file format…

You might need a query to download this data from your old system if it is an earlier version of SAP

Use CMC logical data base to build your query

Best of luck

[Former Member]

Thanks a lot its working fine.

[Former Member]

Please reward points if my response was useful.

Thanks

Prashanth

[Former Member]

while mapping to the standard structure in STEP 5Maintain Field Mapping and Conversion Rule . this IDENT C(001) should be mapped to which field in the standard structure..plz do reply ...

[former_member41806]

Thanks friend, very good post. It works.

[Former Member]

Hi Prashanth, I tried your method but only the header data gets created in the batch input session.

Any idea??