VEXAV

EXTRASTAT / VAR Export/Import | #transactional | Component: Basic Functions
Column Name Description
MANDT FK Client
DATUMJAHR Reporting year of declaration to authorities
DATUMMONA Reporting month of declaration to authorities
ARRIVDEPA Direction (Receipt, Dispatch) Show values
LFDNRVEIA Sequential no.for Extrastat declaration
Column Name Description
💲 Currency Key (RECHNWEEH):
RECHNWEAK Invoice value
💲 Currency Key (GRENZWEEH):
GRENZWEAK Statistical value
Column Name Description
📏 Weight Unit (EIGENMAEH):
EIGENMAAK Tare mass
📏 Weight Unit (BESONMAEH):
BESONMAAK Special unit of measure
Column Name Description
SATZERDAT Date on which the record was created
FAKTDATUM Billing Date
Column Name Description
ARRIVDEPA Direction (Receipt, Dispatch) Show values
VERSENDER Importer HQ / Exporter HQ Show values
CONTAINER ID: Goods cross border in a container Show values
RUECKERST Reimbursement code (Confederation Helvetica) Show values
BEWIPFLIC License requirement (CH only) Show values
RETOURCOD Returns ID for official declarations Show values
THIERISCH Creation Type Show values
BELEGIDEN SD Document Category Show values
GENES Data Origin Indicator Show values
P_LANDKEY Country/Region key Show values
FLAGEUROC Declarations to the authorities: Ind. for decl. crcy = Euro Show values
ISESSIONE Indicator for normal business transactions and correction Show values
Column Name Description Domain name
USERNNAME Name of Person Responsible for Creating the Object USNAM
BELEGNUMR Document number VBELN
HAUPTPOSI Item POSNR
MATERIALN EXTRASTAT material no. for decl. to auth. for Foreign Trade EXMNR
FIRMENNUM Company no. EXTRASTAT for declar. to auth. for Foreign Trade EXFNR
URSPRSREG Region of origin REGIO
EIGENMASS Tare mass in kilograms NUMC15
BESONMASS Supplementary unit NUMC15
GRENZWERT Statistical value NUMC15
RECHNWERT Invoice value NUMC15
VERAMONAT Processing month (Switzerland) CHAR01
BEWINUMME Approval number BEWINUMME
POSTLEITZ Postal Code PSTLZ
BESTIREGI Destination region REGIO
IREFBELEG Reference document VBELN
IREFPOSIT Reference item POSNR
IREFMONAT Reference month for correction IREFMONAT
IREFEJAHR Reference year for correction GJAHR
KUNDEUINR VAT Registration Number STCEG
EIGENUINR VAT Registration Number STCEG
WARENORTE Description TEXT20
SPANIENID Indicator: Domestic / Foreign CHAR01
PLISO Declarations to Authorities: ISO Country Code of BP INTCA
DOMCODENR Overseas areas France (DoM) CHAR1
ORDPA Classification Key for Periodic Declarations in For. Trade CHAR10
ZOLLVERFA Procedure EXPRF
Master Data Relations Join Conditions
Foreign Key: Business Type
  • ?
  • Client
  • Business Transaction Type
  • VEXAV.[column in domain "/ECRS/RPCTY"] == T605.LAND1
  • VEXAV.MANDT == T605.MANDT
  • VEXAV.ARTGESCHA == T605.EXART
Foreign Key: Unit of Measure of Special Unit of Measure
  • VEXAV.MANDT == T006.MANDT
  • VEXAV.BESONMAEH == T006.MSEHI
Foreign Key: Country of Destination
  • Destination Country/Region of Material
  • Client
  • VEXAV.BESTILAND == T005.LAND1
  • VEXAV.MANDT == T005.MANDT
Foreign Key: Issuing Country of Declaration
  • Country of Export Declaration
  • Client
  • VEXAV.CNTRYDECLN == T005.LAND1
  • VEXAV.MANDT == T005.MANDT
Foreign Key: Unit of Measure of Tare Mass
  • VEXAV.MANDT == T006.MANDT
  • VEXAV.EIGENMAEH == T006.MSEHI
Foreign Key: Purchasing Organization
  • VEXAV.MANDT == T024E.MANDT
  • VEXAV.EINKAUFOR == T024E.EKORG
Foreign Key: Office of Exit
  • Customs Office: Office of Exit/Entry for Foreign Trade
  • ?
  • Client
  • VEXAV.EINLADFGH == T615.ZOLLA
  • VEXAV.[column in domain "LAND1"] == T615.LAND1
  • VEXAV.MANDT == T615.MANDT
Foreign Key: Country of Departure/Destination
  • EU Country of Departure/Destination
  • Client
  • VEXAV.EUBELAND == T005.LAND1
  • VEXAV.MANDT == T005.MANDT
Foreign Key: Currency of Statistical Value
  • VEXAV.MANDT == TCURC.MANDT
  • VEXAV.GRENZWEEH == TCURC.WAERS
Foreign Key: Trading Country
  • Trading country
  • Client
  • VEXAV.HANDELSLD == T005.LAND1
  • VEXAV.MANDT == T005.MANDT
Foreign Key: Domestic Mode of Transport
  • ?
  • Domestic Mode of Transport for Foreign Trade
  • VEXAV.MANDT == T618.MANDT
  • VEXAV.[column in domain "/ECRS/RPCTY"] == T618.LAND1
  • VEXAV.INLAIEVER == T618.EXPVZ
Foreign Key: Invoice Currency
  • VEXAV.MANDT == TCURC.MANDT
  • VEXAV.INVOICECY == TCURC.WAERS
Foreign Key: Customer Master
  • VEXAV.MANDT == KNA1.MANDT
  • VEXAV.KUNNR == KNA1.KUNNR
Foreign Key: Incoterms
  • Incoterms (Part 1)
  • Client
  • VEXAV.LIEFERBED == TINC.INCO1
  • VEXAV.MANDT == TINC.MANDT
Foreign Key: Vendor Master
  • VEXAV.MANDT == LFA1.MANDT
  • VEXAV.LIFNR == LFA1.LIFNR
Foreign Key: Client VEXAV.MANDT == T000.MANDT
Foreign Key: Material Master
  • Material Number
  • Client
  • VEXAV.MATNR == MARA.MATNR
  • VEXAV.MANDT == MARA.MANDT
Foreign Key: Company Code
  • VEXAV.MANDT == T001.MANDT
  • VEXAV.NUMMBUKRS == T001.BUKRS
Foreign Key: Plant
  • VEXAV.MANDT == T001W.MANDT
  • VEXAV.NUMMWERKS == T001W.WERKS
Check Preference Code
  • ?
  • Preference code for foreign trade (decl.to author., import)
  • VEXAV.MANDT == T604C.MANDT
  • VEXAV.[column in domain "LAND1"] == T604C.LAND1
  • VEXAV.PREFPACOD == T604C.PREFPACOD
Foreign Key: Currency of Invoice Value
  • VEXAV.MANDT == TCURC.MANDT
  • VEXAV.RECHNWEEH == TCURC.WAERS
Foreign Key: Country of Means of Transport
  • Country of Origin of the Means of Transport at Departure
  • Client
  • VEXAV.STAATSABG == T005.LAND1
  • VEXAV.MANDT == T005.MANDT
Foreign Key: Country of Means of Transport
  • Origin of Means of Transport when Crossing the Border
  • Client
  • VEXAV.STAATSZUG == T005.LAND1
  • VEXAV.MANDT == T005.MANDT
Foreign Key: Commodity Code
  • ?
  • Commodity Code
  • Client
  • VEXAV.[column in domain "LAND1"] == T604.LAND1
  • VEXAV.STATWAREN == T604.STAWN
  • VEXAV.MANDT == T604.MANDT
Foreign Key: Country of Origin
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • VEXAV.URSPRSLND == T005.LAND1
  • VEXAV.MANDT == T005.MANDT
Foreign Key: Export Procedure
  • ?
  • Procedure
  • Client
  • VEXAV.[column in domain "/ECRS/RPCTY"] == T616.LAND1
  • VEXAV.VERFAHREN == T616.EXPRF
  • VEXAV.MANDT == T616.MANDT
Foreign Key: Sales Organization
  • VEXAV.MANDT == TVKO.MANDT
  • VEXAV.VERKAUFOR == TVKO.VKORG
Foreign Key: Mode of Transport
  • ?
  • Mode of Transport at the Border (Intrastat)
  • VEXAV.MANDT == T618.MANDT
  • VEXAV.[column in domain "/ECRS/RPCTY"] == T618.LAND1
  • VEXAV.VERKEHRZW == T618.EXPVZ
Foreign Key: Country of Departure
  • Country of dispatch
  • Client
  • VEXAV.VERSENDLD == T005.LAND1
  • VEXAV.MANDT == T005.MANDT
Foreign Key: Country of (Delivering) Plant
  • Declaration to authorities: Country of Plant
  • Client
  • VEXAV.WERKSLAND == T005.LAND1
  • VEXAV.MANDT == T005.MANDT