SAP Table VEXAV - EXTRASTAT / VAR Export/Import

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
DATUMJAHR X DATUMJAHR NUMC 3 4 0 Reporting year of declaration to authorities
DATUMMONA X DATUMMONA NUMC 7 2 0 Reporting month of declaration to authorities
ARRIVDEPA X VEREI NUMC 9 1 0 Indicator: Goods direction for declarations to authorities
LFDNRVEIA X LFDNR_VEEA NUMC 10 7 0 Sequential no.for Extrastat declaration
NUMMBUKRS BUKRS CHAR 17 4 0 T001 Company Code
USERNNAME ERNAM CHAR 21 12 0 Name of Person who Created the Object
SATZERDAT ERDAT DATS 33 8 0 Date on Which Record Was Created
VERKAUFOR VKORG CHAR 41 4 0 TVKO Sales Organization
BELEGNUMR BELEGNUMR CHAR 45 10 0 Document number
HAUPTPOSI HAUPTPOSI NUMC 55 6 0 Item
MATERIALN EXMNR CHAR 61 6 0 EXTRASTAT material no. for decl. to auth. for Foreign Trade
FIRMENNUM EXFNR CHAR 67 7 0 Company no. EXTRASTAT for declar. to auth. for Foreign Trade
VERSENDER VERSENDER CHAR 74 1 0 Importer HQ / Exporter HQ
HANDELSLD HANDELSLD CHAR 75 3 0 T005 Trading country
BESTILAND BESTILAND CHAR 78 3 0 T005 Country of destination of material
CONTAINER CONTA CHAR 81 1 0 ID: Goods cross border in a container
STAATSZUG STGBE CHAR 82 3 0 T005 Origin of Means of Transport when Crossing the Border
ARTGESCHA EXART CHAR 85 2 0 T605 Business Transaction Type for Foreign Trade
VERKEHRZW EXPVZ CHAR 87 1 0 T618 Mode of Transport for Foreign Trade
EINLADFGH DZOLLS CHAR 88 6 0 T615 Customs Office: Office of Exit/Entry for Foreign Trade
STATWAREN STAWN CHAR 94 17 0 T604 Commodity Code/Import Code Number for Foreign Trade
URSPRSLND HERKL CHAR 111 3 0 T005 Country of origin of the material
URSPRSREG URSPRSREG CHAR 114 3 0 T005S Region of origin
VERFAHREN EXPRF CHAR 117 8 0 T616 Export/Import Procedure for Foreign Trade
EIGENMASS EIGENMASS NUMC 125 15 0 Tare mass in kilograms
BESONMASS BESONMASS NUMC 140 15 0 Supplementary unit
GRENZWERT GRENZWERT NUMC 155 15 0 Statistical value
RECHNWERT RECHNWERT NUMC 170 15 0 Invoice value
VERAMONAT VERAMONAT CHAR 185 1 0 Processing month (Switzerland)
RUECKERST RUECKERST NUMC 186 1 0 Reimbursement code (Confederation Helvetica)
BEWIPFLIC BEWIPFLIC NUMC 187 1 0 License requirement (CH only)
BEWINUMME BEWINUMME NUMC 188 5 0 Approval number
RETOURCOD RETOURCOD CHAR 193 1 0 Returns ID for official declarations
POSTLEITZ PSTLZ CHAR 194 10 0 Postal Code
NUMMWERKS WERKS_D CHAR 204 4 0 T001W Plant
WERKSLAND WERKSLAND CHAR 208 3 0 T005 Declaration to authorities: Country of Plant
INLAIEVER IEVER CHAR 211 1 0 T618 Domestic Mode of Transport for Foreign Trade
LIEFERBED INCO1 CHAR 212 3 0 TINC Incoterms (Part 1)
BESTIREGI BESTIREGI CHAR 215 3 0 T005S Destination region
VERSENDLD VERSENDLD CHAR 218 3 0 T005 Country of dispatch
EINKAUFOR EKORG CHAR 221 4 0 T024E Purchasing Organization
FAKTDATUM FKDAT DATS 225 8 0 Billing date for billing index and printout
PREFPACOD PREFPACOD CHAR 233 3 0 T604C Preference code for foreign trade (decl.to author., import)
THIERISCH THIERISCH CHAR 236 1 0 ID type for creating records
RECHNWEAK RECHNWEAK CURR 237 15 2 Invoice value
RECHNWEEH WAERS CUKY 245 5 0 TCURC Currency Key
GRENZWEAK GRENZWEAK CURR 250 13 2 Statistical value
GRENZWEEH WAERS CUKY 257 5 0 TCURC Currency Key
EIGENMAAK EIGENMAAK QUAN 262 13 3 Tare mass
EIGENMAEH GEWEI UNIT 269 3 0 T006 Weight Unit
BESONMAAK BESONMAAK QUAN 272 13 3 Special unit of measure
BESONMAEH GEWEI UNIT 279 3 0 T006 Weight Unit
IREFBELEG IREFBELEG CHAR 282 10 0 Reference document
IREFPOSIT IREFPOSIT NUMC 292 6 0 Reference item
IREFMONAT IREFMONAT NUMC 298 2 0 Reference month for correction
IREFEJAHR IREFEJAHR NUMC 300 4 0 Reference year for correction
BELEGIDEN VBTYP CHAR 304 1 0 SD document category
GENES GENES CHAR 305 1 0 Data origin indicator for declarations to the authorities
P_LANDKEY P_LANDKEY CHAR 306 1 0 Country key
FLAGEUROC FTEUR CHAR 307 1 0 Declarations to the authorities: Ind. for decl. crcy = Euro
KUNDEUINR STCEG CHAR 308 20 0 VAT Registration Number
EIGENUINR STCEG CHAR 328 20 0 VAT Registration Number
WARENORTE BEZEI20 CHAR 348 20 0 Description
STAATSABG STABE CHAR 368 3 0 T005 Country of Origin of the Means of Transport at Departure
SPANIENID INAUKZ CHAR 371 1 0 Indicator: Domestic / Foreign
PLISO FTPLISO CHAR 372 2 0 Periodic Declarations: ISO country code of business partner
DOMCODENR DOMCODE CHAR 374 1 0 Overseas areas France (DoM)
MATNR MATNR CHAR 375 18 0 MARA Material Number
LIFNR LIFNR CHAR 393 10 0 LFA1 Account Number of Vendor or Creditor
KUNNR KUNNR CHAR 403 10 0 KNA1 Customer Number
ORDPA ORDPA CHAR 413 10 0 Classification Key for Periodic Declarations in For. Trade
ISESSIONE ISESSIONE CHAR 423 1 0 Indicator for normal business transactions and correction

851943Separate country codes for Serbia, Montenegro and Kosovo
810014DART Version 2.4