SAP TABLES | Sales and Distribution | Foreign Trade | Basic Functions(SD-FT-PRO) SAP SD

VEXAV SAP EXTRASTAT / VAR Export/Import Table and data







VEXAV is a standard SAP Table which is used to store EXTRASTAT / VAR Export/Import data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP VEXAV Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Allowed

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP VEXAV Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
DATUMJAHRDATUMJAHRNUMC4 Reporting year of declaration to authoritiesGJAHR
DATUMMONADATUMMONANUMC2 Reporting month of declaration to authorities
ARRIVDEPAVEREINUMC1 Indicator: Goods direction for declarations to authorities
LFDNRVEIALFDNR_VEEANUMC7 Sequential no.for Extrastat declaration
NUMMBUKRSBUKRSCHAR4 T001Company Code
USERNNAMEERNAMCHAR12 Name of Person who Created the Object
SATZERDATERDATDATS8 Date on Which Record Was Created
VERKAUFORVKORGCHAR4 TVKOSales Organization
BELEGNUMRBELEGNUMRCHAR10
*
Document numberALPHA
HAUPTPOSIHAUPTPOSINUMC6
*
Item
MATERIALNEXMNRCHAR6 EXTRASTAT material no. for decl. to auth. for Foreign Trade
FIRMENNUMEXFNRCHAR7 Company no. EXTRASTAT for declar. to auth. for Foreign Trade
VERSENDERVERSENDERCHAR1 Importer HQ / Exporter HQ
HANDELSLDHANDELSLDCHAR3 T005Trading country
BESTILANDBESTILANDCHAR3 T005Country of destination of material
CONTAINERCONTACHAR1 ID: Goods cross border in a container
STAATSZUGSTGBECHAR3 T005Origin of Means of Transport when Crossing the Border
ARTGESCHAEXARTCHAR2 T605Business Transaction Type for Foreign Trade
VERKEHRZWEXPVZCHAR1 T618Mode of Transport for Foreign Trade
EINLADFGHDZOLLSCHAR6 T615Customs Office: Office of Exit/Entry for Foreign Trade
STATWARENSTAWNCHAR17 T604Commodity Code/Import Code Number for Foreign Trade
URSPRSLNDHERKLCHAR3 T005Country of origin of the material
URSPRSREGURSPRSREGCHAR3
*
Region of origin
VERFAHRENEXPRFCHAR8 T616Export/Import Procedure for Foreign Trade
EIGENMASSEIGENMASSNUMC15 Tare mass in kilograms
BESONMASSBESONMASSNUMC15 Supplementary unit
GRENZWERTGRENZWERTNUMC15 Statistical value
RECHNWERTRECHNWERTNUMC15 Invoice value
VERAMONATVERAMONATCHAR1 Processing month (Switzerland)
RUECKERSTRUECKERSTNUMC1 Reimbursement code (Confederation Helvetica)
BEWIPFLICBEWIPFLICNUMC1 License requirement (CH only)
BEWINUMMEBEWINUMMENUMC5 Approval number
RETOURCODRETOURCODCHAR1 Returns ID for official declarations
POSTLEITZPSTLZCHAR10 Postal Code
NUMMWERKSWERKS_DCHAR4 T001WPlant
WERKSLANDWERKSLANDCHAR3 T005Declaration to authorities: Country of Plant
INLAIEVERIEVERCHAR1 T618Domestic Mode of Transport for Foreign Trade
LIEFERBEDINCO1CHAR3 TINCIncoterms (Part 1)


BESTIREGIBESTIREGICHAR3
*
Destination region
VERSENDLDVERSENDLDCHAR3 T005Country of dispatch
EINKAUFOREKORGCHAR4 T024EPurchasing Organization
FAKTDATUMFKDATDATS8 Billing date for billing index and printout
PREFPACODPREFPACODCHAR3 T604CPreference code for foreign trade (decl.to author., import)
THIERISCHTHIERISCHCHAR1 ID type for creating records
RECHNWEAKRECHNWEAKCURR15(2) Invoice value
RECHNWEEHWAERSCUKY5 TCURCCurrency Key
GRENZWEAKGRENZWEAKCURR13(2) Statistical value
GRENZWEEHWAERSCUKY5 TCURCCurrency Key
EIGENMAAKEIGENMAAKQUAN13(3) Tare mass
EIGENMAEHGEWEIUNIT3 T006Weight UnitCUNIT
BESONMAAKBESONMAAKQUAN13(3) Special unit of measure
BESONMAEHGEWEIUNIT3 T006Weight UnitCUNIT
IREFBELEGIREFBELEGCHAR10
*
Reference documentALPHA
IREFPOSITIREFPOSITNUMC6
*
Reference item
IREFMONATIREFMONATNUMC2 Reference month for correction
IREFEJAHRIREFEJAHRNUMC4 Reference year for correctionGJAHR
BELEGIDENVBTYPCHAR1 SD document category
GENESGENESCHAR1 Data origin indicator for declarations to the authorities
P_LANDKEYP_LANDKEYCHAR1 Country key
FLAGEUROCFTEURCHAR1 Declarations to the authorities: Ind. for decl. crcy = Euro
KUNDEUINRSTCEGCHAR20 VAT Registration Number
EIGENUINRSTCEGCHAR20 VAT Registration Number
WARENORTEBEZEI20CHAR20 Description
STAATSABGSTABECHAR3 T005Country of Origin of the Means of Transport at Departure
SPANIENIDINAUKZCHAR1 Indicator: Domestic / Foreign
PLISOFTPLISOCHAR2 Periodic Declarations: ISO country code of business partner
DOMCODENRDOMCODECHAR1 Overseas areas France (DoM)
MATNRMATNRCHAR18 MARAMaterial NumberMATN1
LIFNRLIFNRCHAR10 LFA1Account Number of Vendor or CreditorALPHA
KUNNRKUNNRCHAR10 KNA1Customer NumberALPHA
ORDPAORDPACHAR10 Classification Key for Periodic Declarations in For. Trade
ISESSIONEISESSIONECHAR1 Indicator for normal business transactions and correction
CNTRYDECLNCODECLCHAR3 T005Country of Export Declaration
EUBELANDEUBELANDCHAR3 T005EU Country of Departure/Destination
INVOICECYINVOICECYCUKY5 TCURCInvoice Currency
ZOLLVERFAEXPRFCHAR8
*
Export/Import Procedure for Foreign Trade



Key field
Non-key field