VESED SAP (SED / AERP Export) Table details

Dictionary Type: Table
Description: SED / AERP Export




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




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

VESED is a standard SAP Table which is used to store SED / AERP Export data and is available within R/3 SAP systems depending on the version and release level.

The VESED table consists of various fields, each holding specific information or linking keys about SED / AERP Export 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 number for Intrastat 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VESED table 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 MANDTCLNT3Assigned to domainMANDT
DATUMJAHRReporting year of declaration to authorities DATUMJAHRNUMC4GJAHRGJAHRGJR
DATUMMONAReporting month of declaration to authorities DATUMMONANUMC2MONAT
ARRIVDEPAIndicator: Goods direction for declarations to authorities VEREINUMC1VEREI
LFDNRVEIASequential number for Intrastat declaration LFDNR_VEIANUMC7NUM07
USERNNAMEName of Person who Created the Object ERNAMCHAR12USNAM
SATZERDATDate on Which Record Was Created ERDATDATS8DATUM
NUMMBUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
VERKAUFORSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
EIGENUINRVAT Registration Number STCEGCHAR20STCEG
EIGENBLNDState of manufacture HERBLCHAR2HERBL
BELEGNUMRBilling Document VBELN_VFCHAR10Assigned to domainALPHAVBELNVF
HAUPTPOSIBilling item POSNR_VFNUMC6Assigned to domainPOSNR
MATERIALNMaterial Number MATNR_INTRCHAR6CHAR6
FAKTDATUMBilling date for billing index and printout FKDATDATS8DATUM
VERSENDERImporter HQ / Exporter HQ VERSENDERCHAR1VERSENDER
BESTILANDCountry of destination of material BESTILANDCHAR3Assigned to domainLAND1LND
BESTIREGIDestination region BESTIREGICHAR3Assigned to domainREGIO
ARTGESCHABusiness Transaction Type for Foreign Trade EXARTCHAR2Assigned to domainEXARTEXA
VERKEHRZWMode of Transport for Foreign Trade EXPVZCHAR1Assigned to domainEXPVZ
EINLADFGHCustoms Office: Office of Exit/Entry for Foreign Trade DZOLLSCHAR6Assigned to domainZOLLS
STATWARENCommodity Code/Import Code Number for Foreign Trade STAWNCHAR17Assigned to domainSTAWN
URSPRSLNDCountry Key LAND1CHAR3Assigned to domainLAND1LND
URSPRSREGRegion of origin of material (non-preferential origin) HERKRCHAR3Assigned to domainREGIO
VERFAHRENExport/Import Procedure for Foreign Trade EXPRFCHAR8Assigned to domainEXPRF
EIGENMASSTare mass in kilograms EIGENMASSNUMC15NUMC15
BESONMASSSupplementary unit BESONMASSNUMC15NUMC15
BESOEINHESupplementary unit BEMEHUNIT3Assigned to domainCUNITMEINS
BRUTTOGEWDeclaration to the Authority: Gross weight BRUTTOGEWNUMC15NUMC15
EIGENEINHWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
RECHNWERTInvoice value RECHNWERTNUMC15NUMC15
GRENZWERTStatistical value GRENZWERTNUMC15NUMC15
VERBUNDFICompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
CONTAINERID: Goods cross border in a container CONTACHAR1CONTA
AUSLADFGHCustoms office: Office of destination for foreign trade DZOLLBCHAR6Assigned to domainZOLLS
GENEHMIDEAERP/SED: Relevance for AERP/SED message, NAFTA SEDSPCHAR1XFELD
SPECIIDFISED: Special record ID for transmitting to customs SPECIIDFICHAR2SPECIIDFI
MEXICOSTAExport declaration: description of region (Mexico) MEXICOSTACHAR3Assigned to domainREGIO
AIRCARCODSED: Air Carrier Code AIRCARCODCHAR4AIRCARCOD
FTZNUMEROExport control: Membership of an economic area INDWRCHAR6CHAR6
ECCNNUMERExport control class according the legal reg. for legal ctrl ALNUMCHAR14Assigned to domainALNUMALN
EXGENEHMNExternal license number EXGENCHAR20EXGENEGN
POSTLEITZPostal Code PSTLZCHAR10PSTLZ
FIRMAUTHOSED: Official ID for export companies (S.A.S.) FIRMAUTHOCHAR2FIRMAUTHO
BEFOERLNDCountry of Origin of the Means of Transport at Departure STABECHAR3Assigned to domainLAND1LND
AUSGALANDDeparture country (country from which the goods are sent) ALANDCHAR3Assigned to domainLAND1VAL
INTRANSITSED: ID for export in transit INTRANSITCHAR1INTRANSIT
FHAUSLANDDelivering country HLANDCHAR3Assigned to domainLAND1VAL
VESSELNAMIndicator for the means of transport at departure KZABECHAR30KZABE
EINKAUFORPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
BELEGIDENSD document category VBTYPCHAR1VBTYP
RETOURCODReturns ID for official declarations RETOURCODCHAR1XFELD
SERVAGENTNAFTA: Definition of data record for exporter/fwd. agent SERVAGENTCHAR1SERVAGENT
AIRWAYBILMeans of Transport ID TRAIDCHAR20TRAID
STATWAERSStatistics currency STWAECUKY5Assigned to domainWAERS
BESTIAERPSED: Country of destination BESTI_SEDCHAR5USC05
ALANDAERPSED: Delivery country ALAND_SEDCHAR5USC05
HLANDAERPSED: Base country HLAND_SEDCHAR5USC05
URSPRAERPSED: Country of origin for USA declaration LAND1_SEDCHAR5USC05
GENEHMCODAERP/SED: Official code for type of control master record SEDIMCHAR4CHAR4
NUMMWERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
WERKSLANDDeclaration to authorities: Country of Plant WERKSLANDCHAR3Assigned to domainLAND1LND
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
ORDPAClassification Key for Periodic Declarations in For. Trade ORDPACHAR10CHAR10
THIERISCHID type for creating records THIERISCHCHAR1THIERISCH
ISESSIONEIndicator for normal business transactions and correction ISESSIONECHAR1ISESSIONE

Key field Non-key field



How do I retrieve data from SAP table VESED using ABAP code

The following ABAP code Example will allow you to do a basic selection on VESED to SELECT all data from the table
DATA: WA_VESED TYPE VESED.

SELECT SINGLE *
FROM VESED
INTO CORRESPONDING FIELDS OF WA_VESED
WHERE...

How to access SAP table VESED

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