header and item data in LSMW

[Former Member]

How to distinguish between the header and item data from the given legacy excel file, so that I can correctly extract the Sales Order header and item level data while doing LSMW? Do we need to do any extra coding for doing that?

[Former Member]

Raj,

How can this community tell you that how to distinguish from your File from legacy ?

Ask your legacy team and please don't post these type of weird questions in future ..

BR,

Diwakar

[Former Member]

Hi Diwakar,

I know that I can distinguih the file by seeing it. But my question is: how to do that programming logic while doing LSMW. Try to understand the question first. Dont think that you know everything in th eworld.

Others pls, In my legacy file, it contains Sales order details. But the header level data is repeating for every item numbers. Since I am new to SAP, I not sure how to do the program logic in LSMW. Anyone, please help me..

[Former Member]

Raj,

You Can't/Shouldn't/Needn't distinguish the File data by seeing it. You just need to have the mapping file (or something like that) from your legacy team which denotes that which are values are for which fields.

Then, you or some functional person is to decide that which is relevant header or item data, their mapping with SAP fields and then you need to start your question stating the details that which function/recording you are using in your LSMW and what problem you are facing.

Don't get offended with my remark. Nobody knows everything in this world

But, please respect the time of others which bother to try helping others but get to find absurd questions.

BR,

Diwakar

[Former Member]

Hi Diwakar,

Please read below. This is the way to do it. It resolved my issue.

-

---

Hi, I think you can use 1 file but with the record type identifier, the field will appear in all source strictures, in the Maintain Source Fields step amend field (double click) on it and point Identifying Field Content to appropriate level, e.g. 1 for header 2 for item. Your input file will look like:

REC_TYPE….. FIELDS

1 only fields relevant for the header and blanks for line items

2 only fields relevant for the item data blanks for header fields

2 …

2 …

1 Next record header

2 next record item 1

2 next record item 2

1

2

2

2

2

1

2

-

---

Diwakar,

Please dont be oversmart and dont mislead people and hurt others by making nasty comments.

Thanks,

Raj.

[Former Member]

Raj,

Please don't get that much HURT that you are not able to focus on your work rather

Good that you solved your problem but I still share the same feeling that it was not really possible to help you with the details in your question. Rather than remembering the hurt, please make a point to give as much details as possible when you post.

BR,

Diwakar

[Former Member]

Ok Diwakar. Thank you for your time.

[sreeramkumar_madisetty]

Raj,

For which Tcode , you are trying to loading the data using LSMW?

First go thru that tcode using some test data so that ur self will able to distinguish the Header and Item level data based on the fields u can show in that tcode screens.

Regards,

Sreeram