Page tree
Skip to end of metadata
Go to start of metadata

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 ).

 (lightbulb) 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.

(info) 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

 

  • No labels