Extract structures of 08: Shipment

[Former Member]

I need to extract data from Shipment.

Executed the Setup then RSA3 for the five DataSources of 2LIS_08.

Data is OK for Shipment Costs.

But I want to bring TKNUM (shipment number), TSNUM (stage of transport number) and other fields for the three DSs of LES Transport (TRTK, TRTLP and TRTS).

So I went to tc LBWE (LO Cockpit), opened the Structure Maintenance of these DSs and passed the fields from the right column (Pool) to the left column. Then saved the Structures and the DSs.

It seems that it worked well, I can see the new fields through RSA6 and display the DSs. Also changed to do not hide the new fields.

PROBLEM:

The problem is that I execute the Setup (tc VTBW) and when test the DSs (tc RSA3) they do not select any record.

The other DSs (TRFKP and TRFKZ), wich I didn't change, still work well. I execute the Setup (tc VIFBW) and when test the DSs they select correctly the records.

Any help will be very appreciated.

César Menezes

[former_member188011]

Hi César:

Go to Transaction Code LBWE and make sure the DataSources 2LIS_08TRTK, 2LIS_08TRTS and 2LIS_08TRTLP are active (the three of them must have the green light), if not, activate them and fill the Setup Table again.

Regards,

Francisco Milán.

[Former Member]

Thanks Milán, but all three are active.

I discovered something else.

After I changed the three extract structures, when I execute Setup (tc VTBW) the Setup Tables are not filled.

MC08TR0TLPSETUP

MC08TR0TSSETUP

MC08TR0TKSETUP

Tc SE11 shows them with zero records.

At the same time, when I execute Setup for shipment costs (tc VIFBW) the Setup Tables are filled with records.

MC08TR0FKPSETUP

MC08TR0FKZSETUP.

Tc NPRT does not show any log, so I don't know what happened during setup processes.

Tables VFKP, VTTK and VTTS have records.

I went to tc LBWE and changed the three extract strucutures, put them back to the original position (which means, unmade the changes). Then saved and activated DataSources.

But Setup (tc VTBW) still does not fill the Setup tables.

I'd appreciate your help.

César Menezes

[former_member188011]

Hi César:

Use Transaction code SE11 or SE16 on R/3 to make sure the underlying tables used by the 2LIS_08TRTK, 2LIS_08TRTS and 2LIS_08TRTLP Extractors contain data. The main tables are:

VTTK - Shipment Header

VTTS - Stage of Shipment

VTTP - Shipment Item

LIKP - SD Document: Delivery Header Data

LIPS - SD document: Delivery: Item data

For the relations among the Tables take a look at the paper by Christopher Solomon "SAP Tables Relations", just google it to download a copy of the PDF file.

One more thing, to validate the data on the R/3 side you can use the Transaction codes below.

VT20 - Overall Shipment Status Monitor

VT14 - Select Shipments: Utilization

VT12 - Shipment List: Shipment Completion

Regards,

Francisco Milán.

P.S. Please be aware that not all the contents of the VTTK table are returned by the Shipment Standard Extractors. The SAP Note 573470 explains why the 2LIS_08TRTK Extractor only retrieves the data with values 5, 6 or 7 ("Shipment completion", "Shipment start" or "Shipment end" respectively) in the Overall Status field (VTTK-STTRG).

Edited by: Francisco Milan on Nov 5, 2010 9:15 AM