SAP VESED SED / AERP Export Table
Overview
VESED is a standard SAP S/4HANA table that stores SED / AERP Export data. There are total 77 fields in the VESED table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VESED belongs to Basic Functions (SD-FT-PRO) module and is located in the package Application development R/3 foreign trade (VEI).
In addition, following links provide an overview of foreign key relationships, if any, that link VESED to other SAP tables and standard CDS views available based on VESED table in S/4HANA 2020.
Techincal Settings of VESED
Below are technical details of the table VESED
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VESED Fields
The following table gives you an overview of the fields available in VESED
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| DATUMJAHR | Reporting year of declaration to authorities | DATUMJAHR | NUMC | 4 | |
| DATUMMONA | Reporting month of declaration to authorities | DATUMMONA | NUMC | 2 | |
| ARRIVDEPA | Direction (Receipt Dispatch) | VEREI | NUMC | 1 | |
| LFDNRVEIA | Sequential number for Intrastat declaration | LFDNR_VEIA | NUMC | 7 | |
| USERNNAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| SATZERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| NUMMBUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| VERKAUFOR | Sales Organization | VKORG | * | CHAR | 4 |
| EIGENUINR | VAT Registration Number | STCEG | CHAR | 20 | |
| EIGENBLND | State of manufacture | HERBL | CHAR | 2 | |
| BELEGNUMR | Billing Document | VBELN_VF | * | CHAR | 10 |
| HAUPTPOSI | Billing Item | POSNR_VF | * | NUMC | 6 |
| MATERIALN | Material Number | MATNR_INTR | CHAR | 6 | |
| FAKTDATUM | Billing Date | FKDAT | DATS | 8 | |
| VERSENDER | Importer HQ / Exporter HQ | VERSENDER | CHAR | 1 | |
| BESTILAND | Country of destination of material | BESTILAND | * | CHAR | 3 |
| BESTIREGI | Destination region | BESTIREGI | * | CHAR | 3 |
| ARTGESCHA | Business Transaction Type | EXART | CHAR | 2 | |
| VERKEHRZW | Mode of Transport at the Border (Intrastat) | EXPVZ | CHAR | 1 | |
| EINLADFGH | Customs Office: Office of Exit/Entry for Foreign Trade | DZOLLS | * | CHAR | 6 |
| STATWAREN | Commodity Code | STAWN | CHAR | 17 | |
| URSPRSLND | Country/Region Key | LAND1 | * | CHAR | 3 |
| URSPRSREG | Region of Origin of Material (Non-Preferential Origin) | HERKR | * | CHAR | 3 |
| VERFAHREN | Procedure | EXPRF | CHAR | 8 | |
| EIGENMASS | Tare mass in kilograms | EIGENMASS | NUMC | 15 | |
| BESONMASS | Supplementary unit | BESONMASS | NUMC | 15 | |
| BESOEINHE | Supplementary Unit | BEMEH | * | UNIT | 3 |
| BRUTTOGEW | Declaration to the Authority: Gross weight | BRUTTOGEW | NUMC | 15 | |
| EIGENEINH | Weight Unit | GEWEI | * | UNIT | 3 |
| RECHNWERT | Invoice value | RECHNWERT | NUMC | 15 | |
| GRENZWERT | Statistical value | GRENZWERT | NUMC | 15 | |
| VERBUNDFI | Company ID of Trading Partner | RASSC | * | CHAR | 6 |
| CONTAINER | ID: Goods cross border in a container | CONTA | CHAR | 1 | |
| AUSLADFGH | Customs office: Office of destination for foreign trade | DZOLLB | * | CHAR | 6 |
| GENEHMIDE | AERP/SED: Relevance for AERP/SED message NAFTA | SEDSP | CHAR | 1 | |
| SPECIIDFI | SED: Special record ID for transmitting to customs | SPECIIDFI | CHAR | 2 | |
| MEXICOSTA | Export declaration: description of region (Mexico) | MEXICOSTA | * | CHAR | 3 |
| AIRCARCOD | SED: Air Carrier Code | AIRCARCOD | CHAR | 4 | |
| FTZNUMERO | Export control: Membership of an economic area | INDWR | CHAR | 6 | |
| ECCNNUMER | Export control class according the legal reg. for legal ctrl | ALNUM | * | CHAR | 14 |
| EXGENEHMN | External license number | EXGEN | CHAR | 20 | |
| POSTLEITZ | Postal Code | PSTLZ | CHAR | 10 | |
| FIRMAUTHO | SED: Official ID for export companies (S.A.S.) | FIRMAUTHO | CHAR | 2 | |
| BEFOERLND | Country of Origin of the Means of Transport at Departure | STABE | * | CHAR | 3 |
| AUSGALAND | Departure country (country from which the goods are sent) | ALAND | * | CHAR | 3 |
| INTRANSIT | SED: ID for export in transit | INTRANSIT | CHAR | 1 | |
| FHAUSLAND | Delivering country | HLAND | * | CHAR | 3 |
| VESSELNAM | Identification for the Means of Transport Inland | KZABE | CHAR | 30 | |
| EINKAUFOR | Purchasing organization | EKORG | * | CHAR | 4 |
| BELEGIDEN | SD Document Category | VBTYPL | CHAR | 4 | |
| RETOURCOD | Returns ID for official declarations | RETOURCOD | CHAR | 1 | |
| SERVAGENT | NAFTA: Definition of data record for exporter/fwd. agent | SERVAGENT | CHAR | 1 | |
| AIRWAYBIL | Means of Transport ID | TRAID | CHAR | 20 | |
| STATWAERS | Statistics Currency | STWAE | * | CUKY | 5 |
| BESTIAERP | SED: Country of destination | BESTI_SED | CHAR | 5 | |
| ALANDAERP | SED: Delivery country | ALAND_SED | CHAR | 5 | |
| HLANDAERP | SED: Base country | HLAND_SED | CHAR | 5 | |
| URSPRAERP | SED: Country of origin for USA declaration | LAND1_SED | CHAR | 5 | |
| GENEHMCOD | AERP/SED: Official code for type of control master record | SEDIM | CHAR | 4 | |
| NUMMWERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| WERKSLAND | Declaration to authorities: Country of Plant | WERKSLAND | * | CHAR | 3 |
| RECHNWEAK | Invoice value | RECHNWEAK | CURR | 15 | |
| RECHNWEEH | Currency Key | WAERS | TCURC | CUKY | 5 |
| GRENZWEAK | Statistical value | GRENZWEAK | CURR | 13 | |
| GRENZWEEH | Currency Key | WAERS | TCURC | CUKY | 5 |
| EIGENMAAK | Tare mass | EIGENMAAK | QUAN | 13 | |
| EIGENMAEH | Weight Unit | GEWEI | T006 | UNIT | 3 |
| BESONMAAK | Special unit of measure | BESONMAAK | QUAN | 13 | |
| BESONMAEH | Weight Unit | GEWEI | T006 | UNIT | 3 |
| IREFBELEG | Reference document | IREFBELEG | * | CHAR | 10 |
| IREFPOSIT | Reference item | IREFPOSIT | * | NUMC | 6 |
| IREFMONAT | Reference month for correction | IREFMONAT | NUMC | 2 | |
| IREFEJAHR | Reference year for correction | IREFEJAHR | NUMC | 4 | |
| ORDPA | Classification Key for Periodic Declarations in For. Trade | ORDPA | CHAR | 10 | |
| THIERISCH | Creation Type | THIERISCH | CHAR | 1 | |
| ISESSIONE | Indicator for normal business transactions and correction | ISESSIONE | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VESED
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VESED | BESONMAEH | 1: CN | T006 |
| VESED | EIGENMAEH | 1: CN | T006 |
| VESED | GRENZWEEH | 1: CN | TCURC |
| VESED | NUMMBUKRS | 1: CN | T001 |
| VESED | NUMMWERKS | 1: CN | T001W |
| VESED | RECHNWEEH | 1: CN | TCURC |