SAP VESED SED / AERP Export Table data and field list

VESED is a standard SAP Table which is used to store SED / AERP Export data in SAP systems, such as SAP R/3, S/4HANA, 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. .

VESED table Technical Details:

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VESED table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
DATUMJAHR	Reporting year of declaration to authorities	DATUMJAHR	NUMC	4		GJAHR	GJAHR	GJR
DATUMMONA	Reporting month of declaration to authorities	DATUMMONA	NUMC	2			MONAT
ARRIVDEPA	Indicator: Goods direction for declarations to authorities	VEREI	NUMC	1			VEREI
LFDNRVEIA	Sequential number for Intrastat declaration	LFDNR_VEIA	NUMC	7			NUM07
USERNNAME	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
SATZERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
NUMMBUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
VERKAUFOR	Sales Organization	VKORG	CHAR	4	Assigned to domain		VKORG	VKO	C_VKORG
EIGENUINR	VAT Registration Number	STCEG	CHAR	20			STCEG
EIGENBLND	State of manufacture	HERBL	CHAR	2			HERBL
BELEGNUMR	Billing Document	VBELN_VF	CHAR	10	Assigned to domain	ALPHA	VBELN	VF
HAUPTPOSI	Billing item	POSNR_VF	NUMC	6	Assigned to domain		POSNR
MATERIALN	Material Number	MATNR_INTR	CHAR	6			CHAR6
FAKTDATUM	Billing date for billing index and printout	FKDAT	DATS	8			DATUM
VERSENDER	Importer HQ / Exporter HQ	VERSENDER	CHAR	1			VERSENDER
BESTILAND	Country of destination of material	BESTILAND	CHAR	3	Assigned to domain		LAND1	LND
BESTIREGI	Destination region	BESTIREGI	CHAR	3	Assigned to domain		REGIO
ARTGESCHA	Business Transaction Type for Foreign Trade	EXART	CHAR	2	Assigned to domain		EXART	EXA
VERKEHRZW	Mode of Transport for Foreign Trade	EXPVZ	CHAR	1	Assigned to domain		EXPVZ
EINLADFGH	Customs Office: Office of Exit/Entry for Foreign Trade	DZOLLS	CHAR	6	Assigned to domain		ZOLLS
STATWAREN	Commodity Code/Import Code Number for Foreign Trade	STAWN	CHAR	17	Assigned to domain		STAWN
URSPRSLND	Country Key	LAND1	CHAR	3	Assigned to domain		LAND1	LND
URSPRSREG	Region of origin of material (non-preferential origin)	HERKR	CHAR	3	Assigned to domain		REGIO
VERFAHREN	Export/Import Procedure for Foreign Trade	EXPRF	CHAR	8	Assigned to domain		EXPRF
EIGENMASS	Tare mass in kilograms	EIGENMASS	NUMC	15			NUMC15
BESONMASS	Supplementary unit	BESONMASS	NUMC	15			NUMC15
BESOEINHE	Supplementary unit	BEMEH	UNIT	3	Assigned to domain	CUNIT	MEINS
BRUTTOGEW	Declaration to the Authority: Gross weight	BRUTTOGEW	NUMC	15			NUMC15
EIGENEINH	Weight Unit	GEWEI	UNIT	3	Assigned to domain	CUNIT	MEINS
RECHNWERT	Invoice value	RECHNWERT	NUMC	15			NUMC15
GRENZWERT	Statistical value	GRENZWERT	NUMC	15			NUMC15
VERBUNDFI	Company ID of trading partner	RASSC	CHAR	6	Assigned to domain	ALPHA	RCOMP	PGS
CONTAINER	ID: Goods cross border in a container	CONTA	CHAR	1			CONTA
AUSLADFGH	Customs office: Office of destination for foreign trade	DZOLLB	CHAR	6	Assigned to domain		ZOLLS
GENEHMIDE	AERP/SED: Relevance for AERP/SED message, NAFTA	SEDSP	CHAR	1			XFELD
SPECIIDFI	SED: Special record ID for transmitting to customs	SPECIIDFI	CHAR	2			SPECIIDFI
MEXICOSTA	Export declaration: description of region (Mexico)	MEXICOSTA	CHAR	3	Assigned to domain		REGIO
AIRCARCOD	SED: Air Carrier Code	AIRCARCOD	CHAR	4			AIRCARCOD
FTZNUMERO	Export control: Membership of an economic area	INDWR	CHAR	6			CHAR6
ECCNNUMER	Export control class according the legal reg. for legal ctrl	ALNUM	CHAR	14	Assigned to domain		ALNUM	ALN
EXGENEHMN	External license number	EXGEN	CHAR	20			EXGEN	EGN
POSTLEITZ	Postal Code	PSTLZ	CHAR	10			PSTLZ
FIRMAUTHO	SED: Official ID for export companies (S.A.S.)	FIRMAUTHO	CHAR	2			FIRMAUTHO
BEFOERLND	Country of Origin of the Means of Transport at Departure	STABE	CHAR	3	Assigned to domain		LAND1	LND
AUSGALAND	Departure country (country from which the goods are sent)	ALAND	CHAR	3	Assigned to domain		LAND1	VAL
INTRANSIT	SED: ID for export in transit	INTRANSIT	CHAR	1			INTRANSIT
FHAUSLAND	Delivering country	HLAND	CHAR	3	Assigned to domain		LAND1	VAL
VESSELNAM	Indicator for the means of transport at departure	KZABE	CHAR	30			KZABE
EINKAUFOR	Purchasing Organization	EKORG	CHAR	4	Assigned to domain		EKORG	EKO
BELEGIDEN	SD document category	VBTYP	CHAR	1			VBTYP
RETOURCOD	Returns ID for official declarations	RETOURCOD	CHAR	1			XFELD
SERVAGENT	NAFTA: Definition of data record for exporter/fwd. agent	SERVAGENT	CHAR	1			SERVAGENT
AIRWAYBIL	Means of Transport ID	TRAID	CHAR	20			TRAID
STATWAERS	Statistics currency	STWAE	CUKY	5	Assigned to domain		WAERS
BESTIAERP	SED: Country of destination	BESTI_SED	CHAR	5			USC05
ALANDAERP	SED: Delivery country	ALAND_SED	CHAR	5			USC05
HLANDAERP	SED: Base country	HLAND_SED	CHAR	5			USC05
URSPRAERP	SED: Country of origin for USA declaration	LAND1_SED	CHAR	5			USC05
GENEHMCOD	AERP/SED: Official code for type of control master record	SEDIM	CHAR	4			CHAR4
NUMMWERKS	Plant	WERKS_D	CHAR	4	T001W		WERKS	WRK	H_T001W_C
WERKSLAND	Declaration to authorities: Country of Plant	WERKSLAND	CHAR	3	Assigned to domain		LAND1	LND
RECHNWEAK	Invoice value	RECHNWEAK	CURR	15(2)			WERTV8
RECHNWEEH	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
GRENZWEAK	Statistical value	GRENZWEAK	CURR	13(2)			WERTV7
GRENZWEEH	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
EIGENMAAK	Tare mass	EIGENMAAK	QUAN	13(3)			MENG13
EIGENMAEH	Weight Unit	GEWEI	UNIT	3	T006	CUNIT	MEINS
BESONMAAK	Special unit of measure	BESONMAAK	QUAN	13(3)			MENG13
BESONMAEH	Weight Unit	GEWEI	UNIT	3	T006	CUNIT	MEINS
IREFBELEG	Reference document	IREFBELEG	CHAR	10	Assigned to domain	ALPHA	VBELN
IREFPOSIT	Reference item	IREFPOSIT	NUMC	6	Assigned to domain		POSNR
IREFMONAT	Reference month for correction	IREFMONAT	NUMC	2			IREFMONAT
IREFEJAHR	Reference year for correction	IREFEJAHR	NUMC	4		GJAHR	GJAHR
ORDPA	Classification Key for Periodic Declarations in For. Trade	ORDPA	CHAR	10			CHAR10
THIERISCH	ID type for creating records	THIERISCH	CHAR	1			THIERISCH
ISESSIONE	Indicator for normal business transactions and correction	ISESSIONE	CHAR	1			ISESSIONE

Key field

Non-key field

< VESCHS - Change Document Structure; Generated by RSSCD000 VESEDVB - Posting structure for table VESED >

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).