cancel
Showing results for 
Search instead for 
Did you mean: 

LSMW Direct Input Method

Former Member
0 Kudos
1,118

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 .

Accepted Solutions (0)

Answers (4)

Answers (4)

sameer_gemini
Explorer
0 Kudos

Similar kind of issue was resolved by myself maintianing the exact data type for the field where the issue is coming

use the table /SAPDMC/LSGBDC and change the record as required.

Former Member
0 Kudos

Dear All,

I have done all the steps from 1 to 12,

but in step 13 "Create Batch Input Session" , i got error message "E29 811 Transaction not supported"

Is there any solution for this problem?

Really need help for this

Regards,

Marufat

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

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
0 Kudos

Thanks a lot its working fine.

Former Member
0 Kudos

Please reward points if my response was useful.

Thanks

Prashanth

Former Member
0 Kudos

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
Discoverer
0 Kudos

Thanks friend, very good post. It works.

Former Member
0 Kudos

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

Any idea??

former_member184655
Active Contributor
0 Kudos

Dear Geetha,

Are you using Recording method or Direct Input method?

Maintain the T code CS01 as constant in the 5th step Field Mapping & Conversion

Rules.

I would suggest you to post the same query under ABAP session,so that you will

get a good response from the forum members.

Please dont think I'm discouraging you.

Regards

Mangal

former_member184655
Active Contributor
0 Kudos

Dear Geetha,

Mostly BDC's are used for uploading BOM's.

Instead of using LSMW for BOM header as well as BOM items,

use T code SHDB - Transaction Recorder for uploading BOM's for material.

you will be required the same 2 files in this case also,one for BOM header & one

for BOM items.

Get the help from ABAP 'ers.

Regards

Mangal

Former Member
0 Kudos

Hi,

I need to use only LSMW as its mandatory.cannot use BDC recording.

Pls help abt the error .