SAP table VEIAVVB (Posting structure for table VEIAV)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
DATUMJAHR Reporting year of declaration to authorities NUMC 4 0 DATUMJAHR
DATUMMONA Reporting month of declaration to authorities NUMC 2 0 DATUMMONA
ARRIVDEPA Direction (Receipt, Dispatch) NUMC 1 0 VEREI
1 Receipt
2 Dispatch
LFDNRVEIA Sequential number for Intrastat declaration NUMC 7 0 LFDNR_VEIA
USERNNAME Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
SATZERDAT Date on which the record was created DATS 8 0 ERDAT
NUMMBUKRS Company Code CHAR 4 0 T001 BUKRS
VERKAUFOR Sales Organization CHAR 4 0 TVKO VKORG
EIGENUINR ID number of trader CHAR 20 0 EIGENUINR
EIGENBLND Federal State of Tax Office CHAR 2 0 EIGENBLND
BELEGNUMR Document number CHAR 10 0 BELEGNUMR
HAUPTPOSI Item NUMC 6 0 HAUPTPOSI
MATERIALN Material Number CHAR 6 0 MATNR_INTR
FAKTDATUM Billing Date DATS 8 0 FKDAT
VERSENDER Importer HQ / Exporter HQ CHAR 1 0 VERSENDER
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 Destination Country/Region of Material CHAR 3 0 T005 BESTILAND
BESTIREGI Destination region CHAR 3 0 * BESTIREGI
LIEFERBED Incoterms (Part 1) CHAR 3 0 TINC INCO1
ARTGESCHA Business Transaction Type CHAR 2 0 T605 EXART
VERKEHRZW Mode of Transport at the Border (Intrastat) CHAR 1 0 T618 EXPVZ
EINLADFGH Customs Office: Office of Exit/Entry for Foreign Trade CHAR 6 0 T615 DZOLLS
STATWAREN Commodity Code CHAR 17 0 T604 STAWN
URSPRSLND Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 T005 HERKL
URSPRSREG Region of origin CHAR 3 0 * URSPRSREG
VERFAHREN Procedure CHAR 8 0 T616 EXPRF
EIGENMASS Tare mass in kilograms NUMC 15 0 EIGENMASS
BESONMASS Supplementary unit NUMC 15 0 BESONMASS
RECHNWERT Invoice value NUMC 15 0 RECHNWERT
KUNDEUINR Customer VAT Registration Number CHAR 20 0 KUNDEUINR
LIEFRUINR Supplier VAT Registration Number CHAR 20 0 LIEFRUINR
GRENZWERT Statistical value NUMC 15 0 GRENZWERT
SPANIENID Indicator: Domestic / Foreign CHAR 1 0 INAUKZ
LIEFERWAE Declarations to the authorities: Currency key of the vendor CUKY 5 0 TCURC LIEFERWAE
ZUSATZNUM Foreign Trade: Additional no. for decl. to authorities NUMC 3 0 INZNR
NLDBOCODE BOE code (only relevant for The Netherlands) NUMC 2 0 NLDBOCODE
EINKAUFOR Purchasing organization CHAR 4 0 T024E EKORG
BELEGIDEN SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
RETOURCOD Returns ID for official declarations CHAR 1 0 RETOURCOD
GESAMANZA Total number of items in a declaration NUMC 5 0 GESAMANZA
NUMMWERKS Plant CHAR 4 0 T001W WERKS_D
WERKSLAND Declaration to authorities: Country of Plant CHAR 3 0 T005 WERKSLAND
THIERISCH Creation Type CHAR 1 0 THIERISCH
Automatically Created Item
F Manually Created Item
M Automatically Created Item, Changed Manually
IFREMDWER Invoice value in foreign currency NUMC 15 0 IFREMDWER
ISESSIONE Indicator for normal business transactions and correction CHAR 1 0 ISESSIONE
1 Section 1
2 Section 2
3 Section 3
4 Section 4
IREFMONAT Reference month for correction NUMC 2 0 IREFMONAT
IREFEJAHR Reference year for correction NUMC 4 0 IREFEJAHR
ICORFORTZ Plus/minus for value field in correction CHAR 1 0 ICORFORTZ
+ Positive sign
- Negative sign
IREFBELEG Reference document CHAR 10 0 IREFBELEG
IREFPOSIT Reference item NUMC 6 0 IREFPOSIT
IREFWERKS Reference plant CHAR 4 0 T001W IREFWERKS
PREFPACOD Preference code for foreign trade (decl.to author., import) CHAR 3 0 T604C PREFPACOD
RECHNWEAK Invoice value CURR 15 2 RECHNWEAK
RECHNWEEH Currency Key CUKY 5 0 TCURC WAERS
GRENZWEAK Statistical value CURR 13 2 GRENZWEAK
GRENZWEEH Currency Key CUKY 5 0 TCURC WAERS
EIGENMAAK Tare mass QUAN 13 3 EIGENMAAK
EIGENMAEH Weight Unit UNIT 3 0 T006 GEWEI
BESONMAAK Special unit of measure QUAN 13 3 BESONMAAK
BESONMAEH Weight Unit UNIT 3 0 T006 GEWEI
IFREMDWAK Invoice value in foreign currency CURR 15 2 IFREMDWAK
IFREMDWEH Currency Key CUKY 5 0 TCURC WAERS
GENES Data Origin Indicator CHAR 1 0 GENES
Dispatches in Sales and Receipts in Purchasing
1 Returns to Supplier in Purchasing
2 Receipts and Returns to Supplier in Intercompany Sales
3 Customer Returns in Sales
4 Receipts and Returns to Supplier in Distance Selling
P_LANDKEY Country/Region key CHAR 1 0 P_LANDKEY
FLAGEUROC Declarations to the authorities: Ind. for decl. crcy = Euro CHAR 1 0 FTEUR
MATNR Material Number CHAR 40 0 MARA MATNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
ORDPA Classification Key for Periodic Declarations in For. Trade CHAR 10 0 ORDPA
SERVICEITEM Periodic Message: Service Item Ind. CHAR 1 0 SERVICEITEM
FI_NUMBER Italy - Number of Financial Accounting Document CHAR 15 0 INTRA_FI_NUMBER
FI_DATE Field of type DATS DATS 8 0 DATS
SERVICE_CODE Italy - Code Number of Service CHAR 6 0 INTRA_SERVICE_CODE
SUPPLY_CODE Italy - Type of Delivery with Services CHAR 1 0 INTRA_SUPPLY_CODE
I Sometimes
R Repetitive
PAYMENT_CODE Italy - Payment Method for Services CHAR 1 0 INTRA_PAYMENT_CODE
A Credit
B Bank Transfer
X Miscellaneous
PAYER_COUNTRY Country or Region of the payer CHAR 3 0 * PLARG
PROT_NO Sequence Number of Intrastat Declaration in this Period NUMC 6 0 EXDANUMD
PROG_NO Foreign Trade: Periodic Declarations: Sequence Number NUMC 6 0 FTLFDNR
UPDKZ Update indicator CHAR 1 0 UPDKZ_D

VEIAVVB foreign key relationships

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