TXW_VEXAV SAP (EXTRASTAT / VAR Export/Import) Structure details

Dictionary Type: Structure
Description: EXTRASTAT / VAR Export/Import




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




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

TXW_VEXAV 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 "EXTRASTAT / VAR Export/Import" 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_TXW_VEXAV TYPE TXW_VEXAV.

The TXW_VEXAV table consists of various fields, each holding specific information or linking keys about EXTRASTAT / VAR Export/Import data available in SAP. These include DATUMJAHR (Reporting year of declaration to authorities), DATUMMONA (Reporting month of declaration to authorities), ARRIVDEPA (Indicator: Goods direction for declarations to authorities), LFDNRVEIA (Sequential no.for Extrastat declaration).. 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: Can be enhanced (character-type)


SAP TXW_VEXAV 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 TXW_RECHNWEAKCHAR16
RECHNWEEHCurrency Key WAERSCUKY5TCURCWAERSFWS
GRENZWEAKStatistical value TXW_GRENZWEAKCHAR16
GRENZWEEHCurrency Key WAERSCUKY5TCURCWAERSFWS
EIGENMAAKTare mass TXW_EIGENMAAKCHAR16
EIGENMAEHWeight Unit GEWEIUNIT3T006CUNITMEINS
BESONMAAKSpecial unit of measure TXW_BESONMAAKCHAR16
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

Key field Non-key field



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

As TXW_VEXAV 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 TXW_VEXAV as there is no data to select.

How to access SAP table TXW_VEXAV

Within an ECC or HANA version of SAP you can also view further information about TXW_VEXAV 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!