VEIAV

INTRASTAT Receipt/Dispatch | #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 number for Intrastat declaration
Column Name Description
💲 Currency Key (RECHNWEEH):
RECHNWEAK Invoice value
💲 Currency Key (GRENZWEEH):
GRENZWEAK Statistical value
💲 Currency Key (IFREMDWEH):
IFREMDWAK Invoice value in foreign currency
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
FI_DATE Field of type DATS
Column Name Description
ARRIVDEPA Direction (Receipt, Dispatch) Show values
VERSENDER Importer HQ / Exporter HQ Show values
BELEGIDEN SD Document Category Show values
RETOURCOD Returns ID for official declarations Show values
THIERISCH Creation Type Show values
ISESSIONE Indicator for normal business transactions and correction Show values
ICORFORTZ Plus/minus for value field in correction 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
SERVICEITEM Periodic Message: Service Item Ind. Show values
SUPPLY_CODE Italy - Type of Delivery with Services Show values
PAYMENT_CODE Italy - Payment Method for Services Show values
Column Name Description Domain name
USERNNAME Name of Person Responsible for Creating the Object USNAM
EIGENUINR ID number of trader STCEG
EIGENBLND Federal State of Tax Office HERBL
BELEGNUMR Document number VBELN
HAUPTPOSI Item POSNR
MATERIALN Material Number CHAR6
BESTIREGI Destination region REGIO
URSPRSREG Region of origin REGIO
EIGENMASS Tare mass in kilograms NUMC15
BESONMASS Supplementary unit NUMC15
RECHNWERT Invoice value NUMC15
KUNDEUINR Customer VAT Registration Number STCEG
LIEFRUINR Supplier VAT Registration Number STCEG
GRENZWERT Statistical value NUMC15
SPANIENID Indicator: Domestic / Foreign CHAR01
ZUSATZNUM Foreign Trade: Additional no. for decl. to authorities NUM03
NLDBOCODE BOE code (only relevant for The Netherlands) NUM02
GESAMANZA Total number of items in a declaration NUM05
IFREMDWER Invoice value in foreign currency NUMC15
IREFMONAT Reference month for correction IREFMONAT
IREFEJAHR Reference year for correction GJAHR
IREFBELEG Reference document VBELN
IREFPOSIT Reference item POSNR
ORDPA Classification Key for Periodic Declarations in For. Trade CHAR10
FI_NUMBER Italy - Number of Financial Accounting Document CHAR15
SERVICE_CODE Italy - Code Number of Service INTRA_SERVICE_CODE
PAYER_COUNTRY Country or Region of the payer LAND1
PROT_NO Sequence Number of Intrastat Declaration in this Period NUMC6
PROG_NO Foreign Trade: Periodic Declarations: Sequence Number NUMC6
Master Data Relations Join Conditions
Foreign Key: Business Transaction Type
  • ?
  • Client
  • Business Transaction Type
  • VEIAV.[column in domain "/ECRS/RPCTY"] == T605.LAND1
  • VEIAV.MANDT == T605.MANDT
  • VEIAV.ARTGESCHA == T605.EXART
Foreign Key: Unit of Measure of Special Unit of Measure
  • VEIAV.MANDT == T006.MANDT
  • VEIAV.BESONMAEH == T006.MSEHI
Foreign Key: Destination Country
  • Destination Country/Region of Material
  • Client
  • VEIAV.BESTILAND == T005.LAND1
  • VEIAV.MANDT == T005.MANDT
Foreign Key: Unit of Measure of Tare Mass
  • VEIAV.MANDT == T006.MANDT
  • VEIAV.EIGENMAEH == T006.MSEHI
Foreign Key: Purchasing Organization
  • VEIAV.MANDT == T024E.MANDT
  • VEIAV.EINKAUFOR == T024E.EKORG
Foreign Key: Airport of Loading
  • Customs Office: Office of Exit/Entry for Foreign Trade
  • ?
  • Client
  • VEIAV.EINLADFGH == T615.ZOLLA
  • VEIAV.[column in domain "LAND1"] == T615.LAND1
  • VEIAV.MANDT == T615.MANDT
Foreign Key: Currency of Statistical Value
  • VEIAV.MANDT == TCURC.MANDT
  • VEIAV.GRENZWEEH == TCURC.WAERS
Foreign Key: Currency of Invoice Value in Foreign Currency
  • VEIAV.MANDT == TCURC.MANDT
  • VEIAV.IFREMDWEH == TCURC.WAERS
Foreign Key: Reference Plant
  • VEIAV.MANDT == T001W.MANDT
  • VEIAV.IREFWERKS == T001W.WERKS
Foreign Key: Customer Master
  • VEIAV.MANDT == KNA1.MANDT
  • VEIAV.KUNNR == KNA1.KUNNR
Foreign Key: Incoterms 1
  • Incoterms (Part 1)
  • Client
  • VEIAV.LIEFERBED == TINC.INCO1
  • VEIAV.MANDT == TINC.MANDT
Foreign Key: Currency
  • VEIAV.MANDT == TCURC.MANDT
  • VEIAV.LIEFERWAE == TCURC.WAERS
Foreign Key: Vendor Master
  • VEIAV.MANDT == LFA1.MANDT
  • VEIAV.LIFNR == LFA1.LIFNR
Foreign Key: Client VEIAV.MANDT == T000.MANDT
Foreign Key: Material Master
  • Material Number
  • Client
  • VEIAV.MATNR == MARA.MATNR
  • VEIAV.MANDT == MARA.MANDT
Foreign Key: Company Code
  • VEIAV.MANDT == T001.MANDT
  • VEIAV.NUMMBUKRS == T001.BUKRS
Foreign Key: Delivering Plant
  • VEIAV.MANDT == T001W.MANDT
  • VEIAV.NUMMWERKS == T001W.WERKS
Check Preference Code
  • ?
  • Preference code for foreign trade (decl.to author., import)
  • VEIAV.MANDT == T604C.MANDT
  • VEIAV.[column in domain "LAND1"] == T604C.LAND1
  • VEIAV.PREFPACOD == T604C.PREFPACOD
Foreign Key: Currency of Invoice Value
  • VEIAV.MANDT == TCURC.MANDT
  • VEIAV.RECHNWEEH == TCURC.WAERS
Foreign Key: Commodity Code
  • ?
  • Commodity Code
  • Client
  • VEIAV.[column in domain "LAND1"] == T604.LAND1
  • VEIAV.STATWAREN == T604.STAWN
  • VEIAV.MANDT == T604.MANDT
Foreign Key: Country of Origin
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • VEIAV.URSPRSLND == T005.LAND1
  • VEIAV.MANDT == T005.MANDT
Foreign key: Process
  • ?
  • Procedure
  • Client
  • VEIAV.[column in domain "/ECRS/RPCTY"] == T616.LAND1
  • VEIAV.VERFAHREN == T616.EXPRF
  • VEIAV.MANDT == T616.MANDT
Foreign key: Sales Organization
  • VEIAV.MANDT == TVKO.MANDT
  • VEIAV.VERKAUFOR == TVKO.VKORG
Foreign key: Mode of Transport
  • ?
  • Mode of Transport at the Border (Intrastat)
  • VEIAV.MANDT == T618.MANDT
  • VEIAV.[column in domain "/ECRS/RPCTY"] == T618.LAND1
  • VEIAV.VERKEHRZW == T618.EXPVZ
Foreign key: Country of Plant
  • Declaration to authorities: Country of Plant
  • Client
  • VEIAV.WERKSLAND == T005.LAND1
  • VEIAV.MANDT == T005.MANDT