BOMS uload using LSMW Direct Input

[Former Member]

Hello

I have used LSMW Direct method to upload Material master and recording for Customer master records

but when i am tring to upload BOMs using direct input the ways it works is

MATNR WERKS STLAN POSTP_01 POSTP_02 IDNRK_01 IDNRK_02 MENGE_01 MENGE_02

100113 C001 1 L L 100107 100110 0.5 0.5

it is creating alternate BOM for Material 100113 however this is not what i want

In what way do the fiels needs to be assigned so that i can see and BOM 100113 with two or more components (100107 &100110)

Thanks

Any help is greatly appreciated

[Former Member · Accepted solution]

Sherly,

I think its better to use Batch input program instead of DI in lsmw i guess... V used the BI in lsmw and successfully loaded the data

program name: RCSBI010

Object: 0030

Method: 0001

type : B

Try to map with this method u may get the correct results

[Former Member · Accepted solution]

thanks for the response i am using the same but

could you tell me what the are fields you used and mapped it to what all field coz when i used them instead of creating a BOM material with two components it is creating alternate BOM with one component each

Let me explain it with an eg :

I Would like to see it this way

Material BOM = BOX

Component 1 = PEN 2

Component 2 = PENCIL 5

but now it is showing as

Material BOM = BOX

Component 1 = PEN 2

Alternate Material BOM=BOX

Component 1 = PENCIL 5

[Former Member · Accepted solution]

here r the list of fields v used n mapped

LOAD_TABLE_HEADER Load table_header

AENNR C(012) Change Number

MATNR C(018) Header Material

WERKS C(004) Plant

STLAN C(001) BoM usage

STLAL C(002) BoM Alternative

BMENG C(015) Base Quantity

BMEIN C(003) Base Unit of Measure

STKTX C(040) Alternative BOM Text

LOAD_TABLE_ITEMS Load table Items

MATNR C(018) Material number

STLAL C(002) BoM Alternative

STLAN C(002) BoM Usage

IDNRK C(018) BoM Component

MENGE AMT3(015) Component quantity

POSTP C(010) Item category

POSNR C(010) Item number

MEINS C(003) Unit of measure for component quantity

ALPGR C(010) Alternative item: group

AUSCH AMT3(006) Component Scrap in %

SANKA C(001) Indicator for costing relevancy

KZKUP C(001) Indicator: co-product

REKRS C(001) Recursiveness Allowed

NETAU C(001) Indicator: Net scrap

ALPST C(001) Alternative item: Strategy

EWAHR C(003) Alternative item: usage probability in percent

PRVBE C(010) Supply Area

LGORT C(004) Issue location for production order

VERTI C(004) Distribution key for component consumption

POTX1 C(040) BOM item text (line 1)

NLFZT C(003) Follow-up time (BTCI)

ALPRF C(002) Alternative item: ranking order

FMENG C(001) Fixed Quantity

WERKS C(004) Issuing Plant

SORTF C(004) sort string

v took one seperate file for header data and seperate file for item data... and processed..

[Former Member · Accepted solution]

Does this mean that you had two structures and assigned one to each

or

loaded the header using the CS01 first

And than loaded the components using CS02

Could you please give me a example with sample data for just one BOM record item with atleast two components

Thanks a lot

[Former Member · Accepted solution]

ya

i used 2 differnet structures for header and items and mapped

header to the BGR00 and BICSK in BI and

item to BICSP

thats it

I got the header details in one file and items in another file

[Former Member · Accepted solution]

I will try this to do this afternoon and let u know how it went thanks

For your help

this can be done in one load right

I dont need to load it two times right ?

[Former Member · Accepted solution]

I TRIED USING THIS GETTING AN ERROR MESSAGE "Formatting error in the field RC29N-MATNR; see next message"

Could you please help me solve this

[Former Member · Accepted solution]

what is the exact message you are getting?

and in which step u r getting this error message?

[Former Member · Accepted solution]

i was getting this error in the last step

But i kinda figured it out why and what was the error related to

there was a blank line in the end of the text file

There is a new problem here now

In the 2nd last step where you "Create Batch Input Session"

after clicking the process and running in the background

and than when i go to the last step i do not see the batch file created

Am i doing something worng here while creating a batch file

thanks

[Former Member · Accepted solution]

did u check the option keep batch input folders in the last before step?

check that option and c now

[Former Member · Accepted solution]

Naveen

Thankyou for your help

i was able to create BOMs

I even tested for multiple Items and with multiple subitems

Thanks again

i have rewarded you the points