STO / SO delivery tables

[Former Member]

Hi,

I need to extract STOs and SOs in a separate file on an application server.

The criteria are:

Check deliver completed indicator = X for all STO line items. Here we need not extract for STOu2019s for which delivery is created irrespective of the status.

Check Reason of rejection not equal to blank for all line items of SO. Here we need not extract for SOu2019s for which delivery is created irrespective of the status.

My question is "How to check if delivery is created for STO or an SO ?? I mean I want to know the table names & corresponding fields to know if delivery is created for STO or SO??"

Please help... Thanks!!

[Former Member]

Hi,

Go to u201Cse16nu201D and feed the following tables and explore to get all fields :

u201CLIKPu201D for Delivery Header Data

u201CLIPSu201D for Delivery: Item data

Also visit the link to explore more w.r.t tables and links:

http://www.erpgenie.com/sap/abap/tables_sd.htm

Also you can select the feild and press "F1" and go to technical view for the same you can get the table and field details.

Regards

DSR