SAP ABAP Table V50GALV7 (Declarations to authorities: ALV: SED issue list)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VEI (Package) Application development R/3 foreign trade

Basic Data

Table Category	INTTAB	Structure
Structure	V50GALV7	Table Relationship Diagram
Short Description	Declarations to authorities: ALV: SED issue list

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	SED / AERP Export
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	DATUMJAHR	☐	DATUMJAHR	GJAHR	NUMC	4	0	Reporting year of declaration to authorities
4	DATUMMONA	☐	DATUMMONA	MONAT	NUMC	2	0	Reporting month of declaration to authorities
5	ARRIVDEPA	☐	VEREI	VEREI	NUMC	1	0	Indicator: Goods direction for declarations to authorities
6	LFDNRVEIA	☐	LFDNR_VEIA	NUM07	NUMC	7	0	Sequential number for Intrastat declaration
7	USERNNAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	SATZERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	NUMMBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	VERKAUFOR	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
11	EIGENUINR	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
12	EIGENBLND	☐	HERBL	HERBL	CHAR	2	0	State of manufacture
13	BELEGNUMR	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
14	HAUPTPOSI	☐	POSNR_VF	POSNR	NUMC	6	0	Billing item	*
15	MATERIALN	☐	MATNR_INTR	CHAR6	CHAR	6	0	Material Number
16	FAKTDATUM	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
17	VERSENDER	☐	VERSENDER	VERSENDER	CHAR	1	0	Importer HQ / Exporter HQ
18	BESTILAND	☐	BESTILAND	LAND1	CHAR	3	0	Country of destination of material	*
19	BESTIREGI	☐	BESTIREGI	REGIO	CHAR	3	0	Destination region	*
20	ARTGESCHA	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	*
21	VERKEHRZW	☐	EXPVZ	EXPVZ	CHAR	1	0	Mode of Transport for Foreign Trade	*
22	EINLADFGH	☐	DZOLLS	ZOLLS	CHAR	6	0	Customs Office: Office of Exit/Entry for Foreign Trade	*
23	STATWAREN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	*
24	URSPRSLND	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
25	URSPRSREG	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	*
26	VERFAHREN	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	*
27	EIGENMASS	☐	EIGENMASS	NUMC15	NUMC	15	0	Tare mass in kilograms
28	BESONMASS	☐	BESONMASS	NUMC15	NUMC	15	0	Supplementary unit
29	BESOEINHE	☐	BEMEH	MEINS	UNIT	3	0	Supplementary unit	*
30	BRUTTOGEW	☐	BRUTTOGEW	NUMC15	NUMC	15	0	Declaration to the Authority: Gross weight
31	EIGENEINH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
32	RECHNWERT	☐	RECHNWERT	NUMC15	NUMC	15	0	Invoice value
33	GRENZWERT	☐	GRENZWERT	NUMC15	NUMC	15	0	Statistical value
34	VERBUNDFI	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
35	CONTAINER	☐	CONTA	CONTA	CHAR	1	0	ID: Goods cross border in a container
36	AUSLADFGH	☐	DZOLLB	ZOLLS	CHAR	6	0	Customs office: Office of destination for foreign trade	*
37	GENEHMIDE	☐	SEDSP	XFELD	CHAR	1	0	AERP/SED: Relevance for AERP/SED message, NAFTA
38	SPECIIDFI	☐	SPECIIDFI	SPECIIDFI	CHAR	2	0	SED: Special record ID for transmitting to customs
39	MEXICOSTA	☐	MEXICOSTA	REGIO	CHAR	3	0	Export declaration: description of region (Mexico)	*
40	AIRCARCOD	☐	AIRCARCOD	AIRCARCOD	CHAR	4	0	SED: Air Carrier Code
41	FTZNUMERO	☐	INDWR	CHAR6	CHAR	6	0	Export control: Membership of an economic area
42	ECCNNUMER	☐	ALNUM	ALNUM	CHAR	14	0	Export control class according the legal reg. for legal ctrl	*
43	EXGENEHMN	☐	EXGEN	EXGEN	CHAR	20	0	External license number
44	POSTLEITZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
45	FIRMAUTHO	☐	FIRMAUTHO	FIRMAUTHO	CHAR	2	0	SED: Official ID for export companies (S.A.S.)
46	BEFOERLND	☐	STABE	LAND1	CHAR	3	0	Country of Origin of the Means of Transport at Departure	*
47	AUSGALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	*
48	INTRANSIT	☐	INTRANSIT	INTRANSIT	CHAR	1	0	SED: ID for export in transit
49	FHAUSLAND	☐	HLAND	LAND1	CHAR	3	0	Delivering country	*
50	VESSELNAM	☐	KZABE	KZABE	CHAR	30	0	Indicator for the means of transport at departure
51	EINKAUFOR	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
52	BELEGIDEN	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
53	RETOURCOD	☐	RETOURCOD	XFELD	CHAR	1	0	Returns ID for official declarations
54	SERVAGENT	☐	SERVAGENT	SERVAGENT	CHAR	1	0	NAFTA: Definition of data record for exporter/fwd. agent
55	AIRWAYBIL	☐	TRAID	TRAID	CHAR	20	0	Means-of-transport ID
56	STATWAERS	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	*
57	BESTIAERP	☐	BESTI_SED	USC05	CHAR	5	0	SED: Country of destination
58	ALANDAERP	☐	ALAND_SED	USC05	CHAR	5	0	SED: Delivery country
59	HLANDAERP	☐	HLAND_SED	USC05	CHAR	5	0	SED: Base country
60	URSPRAERP	☐	LAND1_SED	USC05	CHAR	5	0	SED: Country of origin for USA declaration
61	GENEHMCOD	☐	SEDIM	CHAR4	CHAR	4	0	AERP/SED: Official code for type of control master record
62	NUMMWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
63	WERKSLAND	☐	WERKSLAND	LAND1	CHAR	3	0	Declaration to authorities: Country of Plant	*
64	RECHNWEAK	☐	RECHNWEAK	WERTV8	CURR	15	2	Invoice value
65	RECHNWEEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
66	GRENZWEAK	☐	GRENZWEAK	WERTV7	CURR	13	2	Statistical value
67	GRENZWEEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
68	EIGENMAAK	☐	EIGENMAAK	MENG13	QUAN	13	3	Tare mass
69	EIGENMAEH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
70	BESONMAAK	☐	BESONMAAK	MENG13	QUAN	13	3	Special unit of measure
71	BESONMAEH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
72	IREFBELEG	☐	IREFBELEG	VBELN	CHAR	10	0	Reference document	*
73	IREFPOSIT	☐	IREFPOSIT	POSNR	NUMC	6	0	Reference item	*
74	IREFMONAT	☐	IREFMONAT	IREFMONAT	NUMC	2	0	Reference month for correction
75	IREFEJAHR	☐	IREFEJAHR	GJAHR	NUMC	4	0	Reference year for correction
76	ORDPA	☐	ORDPA	CHAR10	CHAR	10	0	Classification Key for Periodic Declarations in For. Trade
77	THIERISCH	☐	THIERISCH	THIERISCH	CHAR	1	0	ID type for creating records
78	ISESSIONE	☐	ISESSIONE	ISESSIONE	CHAR	1	0	Indicator for normal business transactions and correction
79	LFDNR	☐	ORDPA	CHAR10	CHAR	10	0	Classification Key for Periodic Declarations in For. Trade
80	BELNR	☐	BELEGNUMR	VBELN	CHAR	10	0	Document number	*
81	POSNR	☐	HAUPTPOSI	POSNR	NUMC	6	0	Item	*
82	MORED	☐	FTMORED	CHAR8	CHAR	8	0	Foreign Trade: Periodic Declarations: Aggregated Entries
83	TABIX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
84	EIGENMAAK_DEC6	☐	EIGENMAAK_DEC6	MENG13_6	QUAN	14	6	Tare mass

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V50GALV7	BESONMAEH	T006	MSEHI	REF	1	CN
2	V50GALV7	EIGENMAEH	T006	MSEHI	REF	1	CN
3	V50GALV7	GRENZWEEH	TCURC	WAERS	REF	1	CN
4	V50GALV7	NUMMBUKRS	T001	BUKRS	REF	1	CN
5	V50GALV7	NUMMWERKS	T001W	WERKS	REF	1	CN
6	V50GALV7	RECHNWEEH	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in