‎2007 Jun 11 8:14 AM
Hello,
I have to 2 files (header_data.txt and item_data.txt) to upload of sales order transcation and we decided to use direct input method using LSMW. Now I have few doubts
1) How can I relate the header_data record to the item_data record ?
2) if possible please send me the document/ppt/..etc for creation LSMW using the direct input method ?
Thanks a lot in advance
‎2007 Jun 11 11:37 AM
Hi,
You need two files in this case.
The First one will have Header Details. The second one will have Item details.
You need Key fields linking both the files.
The files are then mapped to corresponding structures.
If you are creating a document by recording, you may have to adopt slightly different approach. The creation of the document with first line item in first step. this is done in CREATE mode. In the second step you add the line items in CHANGE mode.
) Source structure definition
I define several structures (head level / line level)
ART_HEAD Article E1BPE1MATHEAD
5 ART_SITE Logistic view source E1BPE1MARCRT
ART_MBEW Article Valuation E1BPE1MBEWRT
(Sorry, can't see correctly the copy, but art_site is below art_head and can contain several sites for one article)
2) Maintain source fields
Group your fields into header and line values. In both strucutes one identifier is needed:
ART_HEAD Article E1BPE1MATHEAD
IDENT C(010) Structure Identifier 1
Identifing Field Content: HEAD
HEAD_MATERIAL C(018) Article number
Assign all needed fields, double click on field IDENT, you will see attribute 'Identifying field content'.
3) Maintain Structure relations
Header fields of BAPI (or whatever method you use) your head-structure has to be assigned, line (tables) input has to be assigned to line-structure.
4) Field mapping: quite normal
5) Import file example (tabulator separated text file):
HEAD 1000014 20050706 OR
LINE 5334667 15 ST 23,15 EUR
LINE 5334669 20 ST 15,89 EUR
HEAD ....
LINE ....
LINE ....
LINE .... and so one
Please read thro' the LSMW online documentation which explains in detail.
Hope this helps you.
*Reward points
Regards