VEXAVVB SAP (Posting structure for table VEXAV) Structure details

Dictionary Type: Structure
Description: Posting structure for table VEXAV




ABAP Code to SELECT data from VEXAVVB
Related tables to VEXAVVB
Access table VEXAVVB




Structure field list including key, data, relationships and ABAP select examples

VEXAVVB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Posting structure for table VEXAV" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_VEXAVVB TYPE VEXAVVB.

The VEXAVVB table consists of various fields, each holding specific information or linking keys about Posting structure for table VEXAV data available in SAP. These include MANDT (Client), DATUMJAHR (Reporting year of declaration to authorities), DATUMMONA (Reporting month of declaration to authorities), ARRIVDEPA (Indicator: Goods direction for declarations to authorities).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP VEXAVVB structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
DATUMJAHRReporting year of declaration to authorities DATUMJAHRNUMC4GJAHRGJAHRGJR
DATUMMONAReporting month of declaration to authorities DATUMMONANUMC2MONAT
ARRIVDEPAIndicator: Goods direction for declarations to authorities VEREINUMC1VEREI
LFDNRVEIASequential no.for Extrastat declaration LFDNR_VEEANUMC7NUM07
NUMMBUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
USERNNAMEName of Person who Created the Object ERNAMCHAR12USNAM
SATZERDATDate on Which Record Was Created ERDATDATS8DATUM
VERKAUFORSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
BELEGNUMRDocument number BELEGNUMRCHAR10Assigned to domainALPHAVBELN
HAUPTPOSIItem HAUPTPOSINUMC6Assigned to domainPOSNR
MATERIALNEXTRASTAT material no. for decl. to auth. for Foreign Trade EXMNRCHAR6EXMNR
FIRMENNUMCompany no. EXTRASTAT for declar. to auth. for Foreign Trade EXFNRCHAR7EXFNR
VERSENDERImporter HQ / Exporter HQ VERSENDERCHAR1VERSENDER
HANDELSLDTrading country HANDELSLDCHAR3T005LAND1LND
BESTILANDCountry of destination of material BESTILANDCHAR3T005LAND1LND
CONTAINERID: Goods cross border in a container CONTACHAR1CONTA
STAATSZUGOrigin of Means of Transport when Crossing the Border STGBECHAR3T005LAND1LND
ARTGESCHABusiness Transaction Type for Foreign Trade EXARTCHAR2T605EXARTEXA
VERKEHRZWMode of Transport for Foreign Trade EXPVZCHAR1T618EXPVZ
EINLADFGHCustoms Office: Office of Exit/Entry for Foreign Trade DZOLLSCHAR6T615ZOLLS
STATWARENCommodity Code/Import Code Number for Foreign Trade STAWNCHAR17T604STAWN
URSPRSLNDCountry of origin of the material HERKLCHAR3T005LAND1LND
URSPRSREGRegion of origin URSPRSREGCHAR3Assigned to domainREGIO
VERFAHRENExport/Import Procedure for Foreign Trade EXPRFCHAR8T616EXPRF
EIGENMASSTare mass in kilograms EIGENMASSNUMC15NUMC15
BESONMASSSupplementary unit BESONMASSNUMC15NUMC15
GRENZWERTStatistical value GRENZWERTNUMC15NUMC15
RECHNWERTInvoice value RECHNWERTNUMC15NUMC15
VERAMONATProcessing month (Switzerland) VERAMONATCHAR1CHAR01
RUECKERSTReimbursement code (Confederation Helvetica) RUECKERSTNUMC1RUECKERST
BEWIPFLICLicense requirement (CH only) BEWIPFLICNUMC1BEWIPFLIC
BEWINUMMEApproval number BEWINUMMENUMC5BEWINUMME
RETOURCODReturns ID for official declarations RETOURCODCHAR1XFELD
POSTLEITZPostal Code PSTLZCHAR10PSTLZ
NUMMWERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
WERKSLANDDeclaration to authorities: Country of Plant WERKSLANDCHAR3T005LAND1LND
INLAIEVERDomestic Mode of Transport for Foreign Trade IEVERCHAR1T618EXPVZ
LIEFERBEDIncoterms (Part 1) INCO1CHAR3TINCINCO1
BESTIREGIDestination region BESTIREGICHAR3Assigned to domainREGIO
VERSENDLDCountry of dispatch VERSENDLDCHAR3T005LAND1
EINKAUFORPurchasing Organization EKORGCHAR4T024EEKORGEKO
FAKTDATUMBilling date for billing index and printout FKDATDATS8DATUM
PREFPACODPreference code for foreign trade (decl.to author., import) PREFPACODCHAR3T604CPREFPACOD
THIERISCHID type for creating records THIERISCHCHAR1THIERISCH
RECHNWEAKInvoice value RECHNWEAKCURR15(2) WERTV8
RECHNWEEHCurrency Key WAERSCUKY5TCURCWAERSFWS
GRENZWEAKStatistical value GRENZWEAKCURR13(2) WERTV7
GRENZWEEHCurrency Key WAERSCUKY5TCURCWAERSFWS
EIGENMAAKTare mass EIGENMAAKQUAN13(3) MENG13
EIGENMAEHWeight Unit GEWEIUNIT3T006CUNITMEINS
BESONMAAKSpecial unit of measure BESONMAAKQUAN13(3) MENG13
BESONMAEHWeight Unit GEWEIUNIT3T006CUNITMEINS
IREFBELEGReference document IREFBELEGCHAR10Assigned to domainALPHAVBELN
IREFPOSITReference item IREFPOSITNUMC6Assigned to domainPOSNR
IREFMONATReference month for correction IREFMONATNUMC2IREFMONAT
IREFEJAHRReference year for correction IREFEJAHRNUMC4GJAHRGJAHR
BELEGIDENSD document category VBTYPCHAR1VBTYP
GENESData origin indicator for declarations to the authorities GENESCHAR1GENES
P_LANDKEYCountry key P_LANDKEYCHAR1XFELD
FLAGEUROCDeclarations to the authorities: Ind. for decl. crcy = Euro FTEURCHAR1XFELD
KUNDEUINRVAT Registration Number STCEGCHAR20STCEG
EIGENUINRVAT Registration Number STCEGCHAR20STCEG
WARENORTEDescription BEZEI20CHAR20TEXT20
STAATSABGCountry of Origin of the Means of Transport at Departure STABECHAR3T005LAND1LND
SPANIENIDIndicator: Domestic / Foreign INAUKZCHAR1CHAR01
PLISOPeriodic Declarations: ISO country code of business partner FTPLISOCHAR2INTCA
DOMCODENROverseas areas France (DoM) DOMCODECHAR1CHAR1
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
ORDPAClassification Key for Periodic Declarations in For. Trade ORDPACHAR10CHAR10
ISESSIONEIndicator for normal business transactions and correction ISESSIONECHAR1ISESSIONE
CNTRYDECLNCountry of Export Declaration CODECLCHAR3T005LAND1
EUBELANDEU Country of Departure/Destination EUBELANDCHAR3T005LAND1
INVOICECYInvoice Currency INVOICECYCUKY5TCURCWAERS
ZOLLVERFAExport/Import Procedure for Foreign Trade EXPRFCHAR8Assigned to domainEXPRF
UPDKZUpdate indicator UPDKZ_DCHAR1UPDKZ

Key field Non-key field



How do I retrieve data from SAP structure VEXAVVB using ABAP code?

As VEXAVVB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VEXAVVB as there is no data to select.

How to access SAP table VEXAVVB

Within an ECC or HANA version of SAP you can also view further information about VEXAVVB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!