Skip to end of metadata
Go to start of metadata

Purpose:

To provide an insight into how to analyse a case where unexpected, incorrect or missing foreign trade data arises in the generation of a sales and distribution delivery document  or a billing document

Overview:

As outlined in a related page the foreign trade data in the documents is always derived from either the material master data or from the foreign trade customizing. In a situation where it is not clear where or why a value is determined below you find the main touch points and analysis points you can use to check the origin of the data further with some hints on how you can check the foreign trade data in the database tables or debug the creation of a delivery or a billing document to further analyse the origin and root cause of the incorrect data..

Foreign trade data determination:

Check the document links and tables

The delivery header table is LIKP and the Foreign trade header table is EIKP both tables share the same EXNUM key LIKP-EXNUM = EIKP-EXNUM. to confirm the table entries for a document go to LIKP with the delivery number and confirm the LIKP-EXNUM value then you can use that to check the foreign trade tables EIKP, EIPO or EIUV as required

The same rational applies to the billing document via field VBRK-EXNUM. Whether or not theLIKP-EXNUM KEY and the VBRK-EXNUM are the same as well is dependent on the copy control setting, so you check each document individually until this is established

Delivery creation

The export indicator LIKP-EXPKZ gets filled here when the delivery is created. From VL01n or VL10* you can check this here:

Program: SAPFV50K, FORM LIKP_EXPORT_BESTIMMEN         

...

IF LIKP-VSTEL NE SPACE.

    IF   TVST-ALAND  NE KUWEV-LAND1 and

      not tvst-aland  is initial     and

       not kuwev-land1 is initial.

 

Once a delivery header has been flagged as an export relevant document (LIKP-EXPKZ)

Function modules EXPORT_GENERAL_DATA_PROPOSE for the header data and function module EXPORT_ITEM_DATA_PROPOSE for item data are always used to determine the foreign trade data in the delivery and often in the creation of the billing document (depending on the copy control setting)

The Foreign trade tables are populated with the relevant information

EIKP       Header table  

EIPO      Item table

EIUV     Holds any incomplete entries detected

All relevant information is under the delivery header under header > foreign trade. In the organization tab you find the EXNUM field In the billing document the foreign trade data itself is determined in function modules EXPORT_GENERAL_DATA_PROPOSE and EXPORT_ITEM_DATA_PROPOSE when the copy control setting is either 'A' or 'B' In a case where the copy control setting in VTFL is ' ' the data is copied from the delivery is done so using function 'EXPIMP_GENERAL_DATA_READ' 

 


 

Related Documents:

Related Notes and KBA's: