VESED - SED / AERP Export

SED / AERP Export information is stored in SAP table VESED.
It is part of development package VEI in software component SD-FT-PRO. This development package consists of objects that can be grouped under "Application development R/3 foreign trade".

Fields for table VESED

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
DATUMJAHR	Reporting year of declaration to authorities	X	DATUMJAHR	NUMC	8
DATUMMONA	Reporting month of declaration to authorities	X	DATUMMONA	NUMC	4
ARRIVDEPA	Direction (Receipt, Dispatch)	X	VEREI	NUMC	2
LFDNRVEIA	Sequential number for Intrastat declaration	X	LFDNR_VEIA	NUMC	14
USERNNAME	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
SATZERDAT	Date on which the record was created		ERDAT	DATS	16
NUMMBUKRS	Company Code		BUKRS	CHAR	8	T001
VERKAUFOR	Sales Organization		VKORG	CHAR	8	*
EIGENUINR	VAT Registration Number		STCEG	CHAR	40
EIGENBLND	State of manufacture		HERBL	CHAR	4
BELEGNUMR	Billing Document		VBELN_VF	CHAR	20	*
HAUPTPOSI	Billing Item		POSNR_VF	NUMC	12	*
MATERIALN	Material Number		MATNR_INTR	CHAR	12
FAKTDATUM	Billing Date		FKDAT	DATS	16
VERSENDER	Importer HQ / Exporter HQ		VERSENDER	CHAR	2
BESTILAND	Destination Country/Region of Material		BESTILAND	CHAR	6	*
BESTIREGI	Destination region		BESTIREGI	CHAR	6	*
ARTGESCHA	Business Transaction Type		EXART	CHAR	4
VERKEHRZW	Mode of Transport at the Border (Intrastat)		EXPVZ	CHAR	2
EINLADFGH	Customs Office: Office of Exit/Entry for Foreign Trade		DZOLLS	CHAR	12	*
STATWAREN	Commodity Code		STAWN	CHAR	34
URSPRSLND	Country/Region Key		LAND1	CHAR	6	*
URSPRSREG	Region of Origin of Material (Non-Preferential Origin)		HERKR	CHAR	6	*
VERFAHREN	Procedure		EXPRF	CHAR	16
EIGENMASS	Tare mass in kilograms		EIGENMASS	NUMC	30
BESONMASS	Supplementary unit		BESONMASS	NUMC	30
BESOEINHE	Supplementary Unit		BEMEH	UNIT	6	*
BRUTTOGEW	Declaration to the Authority: Gross weight		BRUTTOGEW	NUMC	30
EIGENEINH	Weight Unit		GEWEI	UNIT	6	*
RECHNWERT	Invoice value		RECHNWERT	NUMC	30
GRENZWERT	Statistical value		GRENZWERT	NUMC	30
VERBUNDFI	Company ID of Trading Partner		RASSC	CHAR	12	*
CONTAINER	ID: Goods cross border in a container		CONTA	CHAR	2
AUSLADFGH	Customs office: Office of destination for foreign trade		DZOLLB	CHAR	12	*
GENEHMIDE	AERP/SED: Relevance for AERP/SED message, NAFTA		SEDSP	CHAR	2
SPECIIDFI	SED: Special record ID for transmitting to customs		SPECIIDFI	CHAR	4
MEXICOSTA	Export declaration: description of region (Mexico)		MEXICOSTA	CHAR	6	*
AIRCARCOD	SED: Air Carrier Code		AIRCARCOD	CHAR	8
FTZNUMERO	Export control: Membership of an economic area		INDWR	CHAR	12
ECCNNUMER	Export control class according the legal reg. for legal ctrl		ALNUM	CHAR	28	*
EXGENEHMN	External license number		EXGEN	CHAR	40
POSTLEITZ	Postal Code		PSTLZ	CHAR	20
FIRMAUTHO	SED: Official ID for export companies (S.A.S.)		FIRMAUTHO	CHAR	4
BEFOERLND	Country of Origin of the Means of Transport at Departure		STABE	CHAR	6	*
AUSGALAND	Departure Country/Region (from which the goods are sent)		ALAND	CHAR	6	*
INTRANSIT	SED: ID for export in transit		INTRANSIT	CHAR	2
FHAUSLAND	Delivering country		HLAND	CHAR	6	*
VESSELNAM	Identification for the Means of Transport Inland		KZABE	CHAR	60
EINKAUFOR	Purchasing organization		EKORG	CHAR	8	*
BELEGIDEN	SD Document Category		VBTYPL	CHAR	8
RETOURCOD	Returns ID for official declarations		RETOURCOD	CHAR	2
SERVAGENT	NAFTA: Definition of data record for exporter/fwd. agent		SERVAGENT	CHAR	2
AIRWAYBIL	Means of Transport ID		TRAID	CHAR	40
STATWAERS	Statistics Currency		STWAE	CUKY	10	*
BESTIAERP	SED: Country of destination		BESTI_SED	CHAR	10
ALANDAERP	SED: Delivery country		ALAND_SED	CHAR	10
HLANDAERP	SED: Base country		HLAND_SED	CHAR	10
URSPRAERP	SED: Country of origin for USA declaration		LAND1_SED	CHAR	10
GENEHMCOD	AERP/SED: Official code for type of control master record		SEDIM	CHAR	8
NUMMWERKS	Plant		WERKS_D	CHAR	8	T001W
WERKSLAND	Declaration to authorities: Country of Plant		WERKSLAND	CHAR	6	*
RECHNWEAK	Invoice value		RECHNWEAK	CURR	8
RECHNWEEH	Currency Key		WAERS	CUKY	10	TCURC
GRENZWEAK	Statistical value		GRENZWEAK	CURR	7
GRENZWEEH	Currency Key		WAERS	CUKY	10	TCURC
EIGENMAAK	Tare mass		EIGENMAAK	QUAN	7
EIGENMAEH	Weight Unit		GEWEI	UNIT	6	T006
BESONMAAK	Special unit of measure		BESONMAAK	QUAN	7
BESONMAEH	Weight Unit		GEWEI	UNIT	6	T006
IREFBELEG	Reference document		IREFBELEG	CHAR	20	*
IREFPOSIT	Reference item		IREFPOSIT	NUMC	12	*
IREFMONAT	Reference month for correction		IREFMONAT	NUMC	4
IREFEJAHR	Reference year for correction		IREFEJAHR	NUMC	8
ORDPA	Classification Key for Periodic Declarations in For. Trade		ORDPA	CHAR	20
THIERISCH	Creation Type		THIERISCH	CHAR	2
ISESSIONE	Indicator for normal business transactions and correction		ISESSIONE	CHAR	2