Purpose
The purpose of this page is to clarify how the foreign trade header (EIKP) and item (EIPO) data are determined in SD/MM documents.
Overview
When creating SD (delivery and invoice) and MM documents (purchase order) the foreign trade data are determined if the document qualifies as export/import relevant, as outlined in the related page How to analyse foreign trade data determination in a delivery or billing document. Following are the most important fields of the foreign trade data tables (EIKP - header FT data and EIPO - item FT data) listed along with the logic for their determination.
Determination of EIKP data
Central function modules:
EXPORT_GENERAL_DATA_PROPOSE SD documents (delivery / invoice)
IMPORT_GENERAL_DATA_PROPOSE MM documents (purchase order)
Key data:
MANDT Client
= SY-MANDT
EXNUM Internal key
continuously assigned internal number, determined from number range
Data:
ALAND Delivering country
SD: delivery: country of the shipping point = TVST-ALAND
invoice: country of the delivering plant = VBRP-ALAND
(in case of intercompany process VBRP-ALAND = country of the delivering company code!)
MM: country of the receiving plant = EKKO-LANDS
EXPVZ Mode of Transport
SD: determined from the route (LIKP-ROUTE) = TVRO-EXKVZ 0VTC
if no mode of transport can be determined from the route, then from the default values set in customizing: T617-EXPVZ VI95
MM: from vendor master / purchasing org. level = LFM1-EXPVZ XD03
if no mode of transport can be determined from the vendor master, then from the default values set in customizing T617-EXPVZ VI95
IEVER Domestic Mode of Transport
SD: determined from the default values set in customizing = T617-IEVER VI95
if nothing is set there, then determined from the route (LIKP-ROUTE): TVRO-EXKVZ 0VTC
(i.e. = identical to EIKP-EXPVZ)
MM: determined from the default values set in customizing = T617-IEVER VI95
if nothing is set there, then determined from the vendor master / purchasing org. level: LFM1-EXPVZ XD03
ZOLLA Customs Office: Office of Exit (SD) / Entry (MM)
SD: determined from the route (LIKP-ROUTE):
the crossroads of the route marked as border crossing are checked: if the country of the crossroad is = EIKP-ALAND, then: TVKN-ZOLLS 0VTC
if no customs office of exit can be determined from the route, then determined from the default values set in customizing: T617-ZOLLA VI95
MM: from vendor master / purchasing oranization level = LFM1-ZOLLA XD03
if no customs office of entry can be determined from the vendor master, then determined from the default values set in customizing: T617-ZOLLA VI95
ZOLLB Customs office: office of destination (SD) / departure (MM)
SD: determined from the route (LIKP-ROUTE):
the crossroads of the route marked as border crossing are checked: if the country of the crossroad is = KUWEV-LAND1 (country of the ship-to party), then: TVKN-ZOLLS 0VTC
if no customs office of destination can be determined from the route, then determined from the default values set in customizing: T617-ZOLLB VI95
MM: from vendor master / purchasing org. level = LFM1-ZOLLA XD03
ZOLL1 Further customs offices
to ...
ZOLL6 ...
SD: determined from the route (LIKP-ROUTE):
the crossroads of the route marked as border crossing are checked: if the country of the crossroad is not equal EIKP-ALAND and not equal KUWEV-LAND1, then:
TVKN-ZOLLS 0VTC
if no further customs offices can be determined from the route, then determined from the default values set in customizing: T617-ZOLL1...6 VI95
MM: not used
LAZL1 Coutry of further customs offices
to ...
LAZL6 ...
SD: determined from the route (LIKP-ROUTE):
the crossroads of the route marked as border crossing are checked: if the country of the crossroad is not equal EIKP-ALAND and not equal KUWEV-LAND1, then:
TVROKN-LAND1 0VTC
if no further customs offices can be determined from the route, then determined from the default values set in customizing: T617-LAZL1...6 VI95
MM: not used
AUSOK Status: Document data in FT complete
Set by the system ( ‚ ‚ or ‚X’), depending on whether the foreign trade data are complete based on the incompletion check.
EIOKW Status: Complete document data in FT (document changed manually)
in standard initial, can be set to ‚X‘.
Can be set manually on the FT-header screen (button „Set“). Serves as an indicator for the document user that the FT data have been set/changed manually.
AHBAS Basis document category
SD: = ‚2LI’ FT data determined during delivery creation
= ‚2FA’ FT data determined during invoice creation
= ‚1LA’ Inbound delivery; FT data copied from the purchase order
MM: = ‚1BE’ FT data determined during purchase order creation
= ‚1WE’ Goods receipt; FT data copied from the purchase order
Determination of EIPO data
Central function modules:
EXPORT_ITEM_DATA_PROPOSE SD documents (delivery / invoice)
IMPORT_ITEM_DATA_PROPOSE MM documents (purchase order)
Key data:
MANDT Client
= SY-MANDT
EXNUM Internal key
= EIKP-EXNUM
EXPOS Internal item number
SD: delivery: = LIPS-POSNR (delivery item number)
invoice: = VBRP-POSNR (invoice item number)
Exception: if EIPO data are created with reference to delivery -> Customizing): = LIPS-POSNR (delivery item number)
MM: = EKPO-EBELN (PO item number)
Data:
STAWN Commodity Code/Import Code Number
= MARC-STAWN (material master) MM03
MARC accessed with:
SD: delivering plant = LIPS-WERKS /
= VBRP-WERKS
MM: receiving plant = EKPO-WERKS
EXPRF Export/Import Procedure
SD: determined from default data set in customizing: T616Z-EXPRF OVE7
depending on: country (country of dispatch) / sales organisation / distribution channel / division / export material group (MARC-MTVER) / item category --> recursive, generic access
MM: determined from purchasing info record: EINE-EXPRF ME13
except for stock transfer order: T161W-EXPRF
EXART Business Transaction Type
SD: determined from default data set in customizing: T605Z-EXART OVE5
depending on: country (EIPO-VERLD)/ sales organisation (VBRK-VKORG)/ distribution channel (VBRK-VTWEG)/ item category (VBRP-PSTYV)
--> recursive, generic access
MM: determined from customizing: T161B-EXART OMG5
depending on document category / document type / item category / receiving country
HERKL Country of origin of the material
SD: batch item?
yes: = MCHA-HERKL batch master MSC3N
(if not maintained in the batch master, then from the material master)
no: = MARC-HERKL material master MM03
MM: determined from the purchasing info record: EINA-URZLA ME13
HERKR Region of origin (SD) / destination (MM) of material
SD: batch item?
yes: = MCHA-HERKL batch master MSC3N
no: = MARC-HERKL material master MM03
MM: = T001W-REGIO (of the receiving plant) SE16
GRWRT Statistical value
Value is taken from the price determination!
Prerequisite of the take-over :
In the calculation procedure used ( V/08 and M/08 ) the relevant line must have in the colomn „Subotal“ the value „C“.
The take-over happens in the fuction module:
EXPIMP_ITEM_VALUE_MAINTAIN
The GRWRT amount is stored in the home currency (= currency of the company code for which the document was created = T001-WAERS). If the document currency differs from the home currency, a conversion is necessary. The home currency can be found in the document header: EIKP-GRWCU.
SD: In the delivery no price determination is active. The field GRWRT in the delivery is filled only when the delivery item is invoiced and a price determination takes place. The update of the GRWRT value from the invoice into the delivery happens irrespective of the value of the copy indicator in customizig ( VTFL ).
Additional informations:
The pricing condition for foreign trade is statistical condition GRWR.
At billing time the value is populated into the field EIPO-GRWRT and this can be viewed in the foreign trade TAB of the item under (Statistical value)
All entries in VK11 must be maintained with a key of the Incoterms.
The value for the authorities is dependent on the incoterms of the item.
In the pricing procedure for the condition GRWR the field SUB TO must have a value of C = carry over value to KOMP-GKWRT (statistical value) with the requirement 8
for export business.
Statistical Value Condition GRWR
Transaction V/08: Pricing procedure relevant settings:
- Condition GRWR Flag ‘Stat’
- ‘C’ in Sub To get the stat. Value from the conditions to the EIPO-GRWRT in the FT-Dynpro of the invoice. (Carry over value to KOMP-KZWI3).
- Requirement ‘8’ in Rect. Export Business
- create the condition with transaction VK11: Condition Type GRWR:
- Rate for example between 98 % and 102 % it depends on the incoterms ....
- If you have saved the condition GRWR, you should have the condition in your pricing. You will have the value in the FT-tables EIPO if you create the invoice.
It is also important to have in the Transaction VOV7: Business data: Statistical value must have
PREFPACOD Preference code
no automatic determination
SEGAL Exclusion/Inclusion indicator for declartion to authorities
manually or via user-exit: EXIT_SAPLV50E_003 (SD documents)
EXIT_SAPLV50E_004 (MM documents)
VERLD Country of dispatch
SD: country of delivering plant T001W-LAND1
MM: country of supplying vendor (EKKO-LLIEF) LFA1-LAND1
HANLD Trading country
SD: not filled
MM: country of vendor (EKKO-LIFNR) LFA1-LAND1
COIMP Import code number (in plant country)
determined depending on the commodity code (Feld STAWN) and the indicator „Additional information“ in T604 (for more information on this see Note 607675).
SD: not filled (Exception: STAWN with „Add.inf.“ = ‚1’, then = MARC-STAWN)
MM: = MARC-STAWN (Exception: STAWN with „Add.inf.“ = ‚2’, then conversion through customizing T604U VI45) - access twice with plant country)
COBLD Import code number (in destination country)
no automatic determination
AUSOK Status: Document data in FT complete
Set by the system ( ‚ ‚ or ‚X’), depending on whether the foreign trade data are complete based on the incompletion check.
EIOKW Status: Complete document data in FT (document changed manually)
in standard initial, can be set to ‚X‘.
Can be set manually on the FT-header screen (button „Set“) . Serves as an indicator for the document user that the FT data have been set/changed manually.
Related Content
Related Documents
How to analyse foreign trade data determination in a delivery or billing document