Extract Data from Batch Input Session created by LSMW

[Former Member]

Hi All,

I have created a LSMW to upload material data, and created 3 Batch Input Session for different materials.

Now advice me to how to get the data from the Batch Input Session which is in T-CODE: SM35

Regards,

Rohini.

[jrg_wulf]

Hi Rohini,

can you elaborate your request?

When you create a Batch Input Session and have your data ready in SM35, do you want to know how to process the data? Do you want to retrieve data from your BI-Group?

The most obvious guess for me is, that you are looking for means to process the data, so that it is stored in your material db.

I assume, you recorded the LSMW and provided the proper T-Code. In this case all you have to do is to select the respective group, press F8 (Process) and  choose from the following dialogue the processing mode.

Regards

Jörg

[Former Member]

Hi Jörg Wulf :

Thanks for you reply, but I know how to process the LSMW so that the data is stored in material db. But my requirement is how to retrieve the data from the batch input session created through LSMW. I want to get back the txt data which i upload in LSMW 7th step.

[jrg_wulf]

Hi Rohini,

there's a simple way to retrieve the data from a BI-Session.

In SM35 select your Session and then from the utilities menu select export session. On most systems however, this might not be possible due to restricted permissions.

Then there's always the hard way:

All BI-Session data is stored in tables APQI and APQD, linked by field QID (Queue ID in SM35)

The trick here is to resolve the contents of the field vardata, since it is an unstructured field, containing next to everything.

The best aproach would be to examine a session with well known contents and find your way from there.

Best regards

Jörg