1. Home
  2. Resources
  3. SAP Tables
  4. VEIAVVB - Posting structure for table VEIAV

SAP Table VEIAVVB

Posting structure for table VEIAV

VEIAVVB (Posting structure for table VEIAV) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VEIAVVB to other SAP tables.

Source: VEIAVVB (Posting structure for table VEIAV)

VEIAVVB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DATUMJAHR Reporting year of declaration to authorities DATUMJAHR NUMC 4 0
DATUMMONA Reporting month of declaration to authorities DATUMMONA NUMC 2 0
ARRIVDEPA Indicator: Goods direction for declarations to authorities VEREI NUMC 1 0
1 Receipt / Import
2 Dispatch / Export
LFDNRVEIA Sequential number for Intrastat declaration LFDNR_VEIA NUMC 7 0
USERNNAME Name of Person who Created the Object ERNAM CHAR 12 0
SATZERDAT Date on Which Record Was Created ERDAT DATS 8 0
NUMMBUKRS Company Code BUKRS T001 CHAR 4 0
VERKAUFOR Sales Organization VKORG TVKO CHAR 4 0
EIGENUINR ID number of trader EIGENUINR CHAR 20 0
EIGENBLND Federal state of tax office EIGENBLND CHAR 2 0
BELEGNUMR Document number BELEGNUMR CHAR 10 0
HAUPTPOSI Item HAUPTPOSI NUMC 6 0
MATERIALN Material Number MATNR_INTR CHAR 6 0
FAKTDATUM Billing date for billing index and printout FKDAT DATS 8 0
VERSENDER Importer HQ / Exporter HQ VERSENDER CHAR 1 0
1 Importer/Exporter in Hamburg
3 Importer/Exporter in Bremen
4 From a warehouse in Bremen (special trade)
5 Exporter in Bremen (general commodity trade)
6 Importer in Berlin
7 Importer in the Saarland/Exporter in Lübeck
8 Importer in Lübeck
BESTILAND Country of destination of material BESTILAND T005 CHAR 3 0
BESTIREGI Destination region BESTIREGI CHAR 3 0
LIEFERBED Incoterms (Part 1) INCO1 TINC CHAR 3 0
ARTGESCHA Business Transaction Type for Foreign Trade EXART T605 CHAR 2 0
VERKEHRZW Mode of Transport for Foreign Trade EXPVZ T618 CHAR 1 0
EINLADFGH Customs Office: Office of Exit/Entry for Foreign Trade DZOLLS T615 CHAR 6 0
STATWAREN Commodity Code/Import Code Number for Foreign Trade STAWN T604 CHAR 17 0
URSPRSLND Country of origin of the material HERKL T005 CHAR 3 0
URSPRSREG Region of origin URSPRSREG CHAR 3 0
VERFAHREN Export/Import Procedure for Foreign Trade EXPRF T616 CHAR 8 0
EIGENMASS Tare mass in kilograms EIGENMASS NUMC 15 0
BESONMASS Supplementary unit BESONMASS NUMC 15 0
RECHNWERT Invoice value RECHNWERT NUMC 15 0
KUNDEUINR Customer VAT registration number KUNDEUINR CHAR 20 0
LIEFRUINR Vendor VAT registration number LIEFRUINR CHAR 20 0
GRENZWERT Statistical value GRENZWERT NUMC 15 0
SPANIENID Indicator: Domestic / Foreign INAUKZ CHAR 1 0
LIEFERWAE Declarations to the authorities: Currency key of the vendor LIEFERWAE TCURC CUKY 5 0
ZUSATZNUM Foreign Trade: Additional no. for decl. to authorities INZNR NUMC 3 0
NLDBOCODE BOE code (only relevant for The Netherlands) NLDBOCODE NUMC 2 0
EINKAUFOR Purchasing Organization EKORG T024E CHAR 4 0
BELEGIDEN SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
RETOURCOD Returns ID for official declarations RETOURCOD CHAR 1 0
X Yes
NULL No
GESAMANZA Total number of items in a declaration GESAMANZA NUMC 5 0
NUMMWERKS Plant WERKS_D T001W CHAR 4 0
WERKSLAND Declaration to authorities: Country of Plant WERKSLAND T005 CHAR 3 0
THIERISCH ID type for creating records THIERISCH CHAR 1 0
NULL Record created automatically by selection program
M Record created automatically and changed manually
F Record added manually in change transaction
IFREMDWER Invoice value in foreign currency IFREMDWER NUMC 15 0
ISESSIONE Indicator for normal business transactions and correction ISESSIONE CHAR 1 0
1 Section 1
2 Section 2
3 Section 3
4 Section 4
IREFMONAT Reference month for correction IREFMONAT NUMC 2 0
IREFEJAHR Reference year for correction IREFEJAHR NUMC 4 0
ICORFORTZ Plus/minus for value field in correction ICORFORTZ CHAR 1 0
+ Positive sign
- Negative sign
IREFBELEG Reference document IREFBELEG CHAR 10 0
IREFPOSIT Reference item IREFPOSIT NUMC 6 0
IREFWERKS Reference plant IREFWERKS T001W CHAR 4 0
PREFPACOD Preference code for foreign trade (decl.to author., import) PREFPACOD T604C CHAR 3 0
RECHNWEAK Invoice value RECHNWEAK CURR 15 2
RECHNWEEH Currency Key WAERS TCURC CUKY 5 0
GRENZWEAK Statistical value GRENZWEAK CURR 13 2
GRENZWEEH Currency Key WAERS TCURC CUKY 5 0
EIGENMAAK Tare mass EIGENMAAK QUAN 13 3
EIGENMAEH Weight Unit GEWEI T006 UNIT 3 0
BESONMAAK Special unit of measure BESONMAAK QUAN 13 3
BESONMAEH Weight Unit GEWEI T006 UNIT 3 0
IFREMDWAK Invoice value in foreign currency IFREMDWAK CURR 15 2
IFREMDWEH Currency Key WAERS TCURC CUKY 5 0
GENES Data origin indicator for declarations to the authorities GENES CHAR 1 0
NULL Data origin unchanged
1 Entry created in MM in dispatch/export data extract
2 Entry created in SD in receipt/import IV data extract
3 Entry created in SD in receipt/import data extract
P_LANDKEY Country key P_LANDKEY CHAR 1 0
X Yes
NULL No
FLAGEUROC Declarations to the authorities: Ind. for decl. crcy = Euro FTEUR CHAR 1 0
X Yes
NULL No
MATNR Material Number MATNR MARA CHAR 18 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
ORDPA Classification Key for Periodic Declarations in For. Trade ORDPA CHAR 10 0
SERVICEITEM Periodic Message: Service Item Ind. SERVICEITEM CHAR 1 0
X Yes
NULL No
FI_NUMBER Italy - Number of Financial Accounting Document INTRA_FI_NUMBER CHAR 15 0
FI_DATE Field of type DATS DATS DATS 8 0
SERVICE_CODE Italy - Code Number of Service INTRA_SERVICE_CODE CHAR 6 0
SUPPLY_CODE Italy - Type of Delivery with Services INTRA_SUPPLY_CODE CHAR 1 0
I Sometimes
R Repetitive
PAYMENT_CODE Italy - Payment Method for Services INTRA_PAYMENT_CODE CHAR 1 0
A Credit
B Bank Transfer
X Miscellaneous
PAYER_COUNTRY Country of the payer PLARG CHAR 3 0
PROT_NO Sequence Number of Intrastat Declaration in this Period EXDANUMD NUMC 6 0
PROG_NO Foreign Trade: Periodic Declarations: Sequence Number FTLFDNR NUMC 6 0
UPDKZ Update indicator UPDKZ_D CHAR 1 0

VEIAVVB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VEIAVVB ARTGESCHA VEIAVVB ARTGESCHA T605 Foreign Trade: Business Transaction Type EXART
VEIAVVB ARTGESCHA T001W LAND1 T605 Foreign Trade: Business Transaction Type LAND1
VEIAVVB ARTGESCHA VEIAVVB MANDT T605 Foreign Trade: Business Transaction Type MANDT
VEIAVVB BESONMAEH VEIAVVB BESONMAEH T006 Units of Measurement MSEHI
VEIAVVB BESONMAEH VEIAVVB MANDT T006 Units of Measurement MANDT
VEIAVVB BESTILAND VEIAVVB BESTILAND T005 Countries LAND1
VEIAVVB BESTILAND VEIAVVB MANDT T005 Countries MANDT
VEIAVVB EIGENMAEH VEIAVVB EIGENMAEH T006 Units of Measurement MSEHI
VEIAVVB EIGENMAEH VEIAVVB MANDT T006 Units of Measurement MANDT
VEIAVVB EINKAUFOR VEIAVVB EINKAUFOR T024E Purchasing Organizations EKORG
VEIAVVB EINKAUFOR VEIAVVB MANDT T024E Purchasing Organizations MANDT
VEIAVVB EINLADFGH T001W LAND1 T615 Foreign Trade: Customs Offices LAND1
VEIAVVB EINLADFGH VEIAVVB MANDT T615 Foreign Trade: Customs Offices MANDT
VEIAVVB EINLADFGH VEIAVVB EINLADFGH T615 Foreign Trade: Customs Offices ZOLLA
VEIAVVB GRENZWEEH VEIAVVB MANDT TCURC Currency Codes MANDT
VEIAVVB GRENZWEEH VEIAVVB GRENZWEEH TCURC Currency Codes WAERS
VEIAVVB IFREMDWEH VEIAVVB MANDT TCURC Currency Codes MANDT
VEIAVVB IFREMDWEH VEIAVVB IFREMDWEH TCURC Currency Codes WAERS
VEIAVVB IREFWERKS VEIAVVB MANDT T001W Plants/Branches MANDT
VEIAVVB IREFWERKS VEIAVVB IREFWERKS T001W Plants/Branches WERKS
VEIAVVB KUNNR VEIAVVB MANDT KNA1 General Data in Customer Master MANDT
VEIAVVB KUNNR VEIAVVB KUNNR KNA1 General Data in Customer Master KUNNR
VEIAVVB LIEFERBED VEIAVVB MANDT TINC Customers: Incoterms MANDT
VEIAVVB LIEFERBED VEIAVVB LIEFERBED TINC Customers: Incoterms INCO1
VEIAVVB LIEFERWAE VEIAVVB LIEFERWAE TCURC Currency Codes WAERS
VEIAVVB LIEFERWAE VEIAVVB MANDT TCURC Currency Codes MANDT
VEIAVVB LIFNR VEIAVVB LIFNR LFA1 Vendor Master (General Section) LIFNR
VEIAVVB LIFNR VEIAVVB MANDT LFA1 Vendor Master (General Section) MANDT
VEIAVVB MANDT VEIAVVB MANDT T000 Clients MANDT
VEIAVVB MATNR VEIAVVB MATNR MARA General Material Data MATNR
VEIAVVB MATNR VEIAVVB MANDT MARA General Material Data MANDT
VEIAVVB NUMMBUKRS VEIAVVB NUMMBUKRS T001 Company Codes BUKRS
VEIAVVB NUMMBUKRS VEIAVVB MANDT T001 Company Codes MANDT
VEIAVVB NUMMWERKS VEIAVVB NUMMWERKS T001W Plants/Branches WERKS
VEIAVVB NUMMWERKS VEIAVVB MANDT T001W Plants/Branches MANDT
VEIAVVB PREFPACOD VEIAVVB PREFPACOD T604C Preference: Preference Procedure Code PREFPACOD
VEIAVVB PREFPACOD T001W LAND1 T604C Preference: Preference Procedure Code LAND1
VEIAVVB PREFPACOD VEIAVVB MANDT T604C Preference: Preference Procedure Code MANDT
VEIAVVB RECHNWEEH VEIAVVB MANDT TCURC Currency Codes MANDT
VEIAVVB RECHNWEEH VEIAVVB RECHNWEEH TCURC Currency Codes WAERS
VEIAVVB STATWAREN T001W LAND1 T604 Foreign Trade: Commodity Code / Import Code Number LAND1
VEIAVVB STATWAREN VEIAVVB STATWAREN T604 Foreign Trade: Commodity Code / Import Code Number STAWN
VEIAVVB STATWAREN VEIAVVB MANDT T604 Foreign Trade: Commodity Code / Import Code Number MANDT
VEIAVVB URSPRSLND VEIAVVB URSPRSLND T005 Countries LAND1
VEIAVVB URSPRSLND VEIAVVB MANDT T005 Countries MANDT
VEIAVVB VERFAHREN VEIAVVB MANDT T616 Foreign Trade: Procedure MANDT
VEIAVVB VERFAHREN T001W LAND1 T616 Foreign Trade: Procedure LAND1
VEIAVVB VERFAHREN VEIAVVB VERFAHREN T616 Foreign Trade: Procedure EXPRF
VEIAVVB VERKAUFOR VEIAVVB VERKAUFOR TVKO Organizational Unit: Sales Organizations VKORG
VEIAVVB VERKAUFOR VEIAVVB MANDT TVKO Organizational Unit: Sales Organizations MANDT
VEIAVVB VERKEHRZW VEIAVVB VERKEHRZW T618 Foreign Trade: Modes of Transport EXPVZ
VEIAVVB VERKEHRZW VEIAVVB MANDT T618 Foreign Trade: Modes of Transport MANDT
VEIAVVB VERKEHRZW T001W LAND1 T618 Foreign Trade: Modes of Transport LAND1
VEIAVVB WERKSLAND VEIAVVB WERKSLAND T005 Countries LAND1
VEIAVVB WERKSLAND VEIAVVB MANDT T005 Countries MANDT