SAP ABAP Table V50GALV8 (Declarations to authorities: ALV: INTRASTAT 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	V50GALV8	Table Relationship Diagram
Short Description	Declarations to authorities: ALV: INTRASTAT 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	INTRASTAT Receipt/Dispatch
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
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	TVKO
11	EIGENUINR	☐	EIGENUINR	STCEG	CHAR	20	0	ID number of trader
12	EIGENBLND	☐	EIGENBLND	HERBL	CHAR	2	0	Federal state of tax office
13	BELEGNUMR	☐	BELEGNUMR	VBELN	CHAR	10	0	Document number	*
14	HAUPTPOSI	☐	HAUPTPOSI	POSNR	NUMC	6	0	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	T005
19	BESTIREGI	☐	BESTIREGI	REGIO	CHAR	3	0	Destination region	*
20	LIEFERBED	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
21	ARTGESCHA	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	T605
22	VERKEHRZW	☐	EXPVZ	EXPVZ	CHAR	1	0	Mode of Transport for Foreign Trade	T618
23	EINLADFGH	☐	DZOLLS	ZOLLS	CHAR	6	0	Customs Office: Office of Exit/Entry for Foreign Trade	T615
24	STATWAREN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
25	URSPRSLND	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
26	URSPRSREG	☐	URSPRSREG	REGIO	CHAR	3	0	Region of origin	*
27	VERFAHREN	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	T616
28	EIGENMASS	☐	EIGENMASS	NUMC15	NUMC	15	0	Tare mass in kilograms
29	BESONMASS	☐	BESONMASS	NUMC15	NUMC	15	0	Supplementary unit
30	RECHNWERT	☐	RECHNWERT	NUMC15	NUMC	15	0	Invoice value
31	KUNDEUINR	☐	KUNDEUINR	STCEG	CHAR	20	0	Customer VAT registration number
32	LIEFRUINR	☐	LIEFRUINR	STCEG	CHAR	20	0	Vendor VAT registration number
33	GRENZWERT	☐	GRENZWERT	NUMC15	NUMC	15	0	Statistical value
34	SPANIENID	☐	INAUKZ	CHAR01	CHAR	1	0	Indicator: Domestic / Foreign
35	LIEFERWAE	☐	LIEFERWAE	WAERS	CUKY	5	0	Declarations to the authorities: Currency key of the vendor	TCURC
36	ZUSATZNUM	☐	INZNR	NUM03	NUMC	3	0	Foreign Trade: Additional no. for decl. to authorities
37	NLDBOCODE	☐	NLDBOCODE	NUM02	NUMC	2	0	BOE code (only relevant for The Netherlands)
38	EINKAUFOR	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
39	BELEGIDEN	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
40	RETOURCOD	☐	RETOURCOD	XFELD	CHAR	1	0	Returns ID for official declarations
41	GESAMANZA	☐	GESAMANZA	NUM05	NUMC	5	0	Total number of items in a declaration
42	NUMMWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
43	WERKSLAND	☐	WERKSLAND	LAND1	CHAR	3	0	Declaration to authorities: Country of Plant	T005
44	THIERISCH	☐	THIERISCH	THIERISCH	CHAR	1	0	ID type for creating records
45	IFREMDWER	☐	IFREMDWER	NUMC15	NUMC	15	0	Invoice value in foreign currency
46	ISESSIONE	☐	ISESSIONE	ISESSIONE	CHAR	1	0	Indicator for normal business transactions and correction
47	IREFMONAT	☐	IREFMONAT	IREFMONAT	NUMC	2	0	Reference month for correction
48	IREFEJAHR	☐	IREFEJAHR	GJAHR	NUMC	4	0	Reference year for correction
49	ICORFORTZ	☐	ICORFORTZ	ICORFORTZ	CHAR	1	0	Plus/minus for value field in correction
50	IREFBELEG	☐	IREFBELEG	VBELN	CHAR	10	0	Reference document	*
51	IREFPOSIT	☐	IREFPOSIT	POSNR	NUMC	6	0	Reference item	*
52	IREFWERKS	☐	IREFWERKS	WERKS	CHAR	4	0	Reference plant	T001W
53	PREFPACOD	☐	PREFPACOD	PREFPACOD	CHAR	3	0	Preference code for foreign trade (decl.to author., import)	T604C
54	RECHNWEAK	☐	RECHNWEAK	WERTV8	CURR	15	2	Invoice value
55	RECHNWEEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
56	GRENZWEAK	☐	GRENZWEAK	WERTV7	CURR	13	2	Statistical value
57	GRENZWEEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
58	EIGENMAAK	☐	EIGENMAAK	MENG13	QUAN	13	3	Tare mass
59	EIGENMAEH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
60	BESONMAAK	☐	BESONMAAK	MENG13	QUAN	13	3	Special unit of measure
61	BESONMAEH	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
62	IFREMDWAK	☐	IFREMDWAK	WERTV8	CURR	15	2	Invoice value in foreign currency
63	IFREMDWEH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
64	GENES	☐	GENES	GENES	CHAR	1	0	Data origin indicator for declarations to the authorities
65	P_LANDKEY	☐	P_LANDKEY	XFELD	CHAR	1	0	Country key
66	FLAGEUROC	☐	FTEUR	XFELD	CHAR	1	0	Declarations to the authorities: Ind. for decl. crcy = Euro
67	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
68	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
69	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
70	ORDPA	☐	ORDPA	CHAR10	CHAR	10	0	Classification Key for Periodic Declarations in For. Trade
71	SERVICEITEM	☐	SERVICEITEM	XFELD	CHAR	1	0	Periodic Message: Service Item Ind.
72	FI_NUMBER	☐	INTRA_FI_NUMBER	CHAR15	CHAR	15	0	Italy - Number of Financial Accounting Document
73	FI_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
74	SERVICE_CODE	☐	INTRA_SERVICE_CODE	INTRA_SERVICE_CODE	CHAR	6	0	Italy - Code Number of Service
75	SUPPLY_CODE	☐	INTRA_SUPPLY_CODE	INTRA_SUPPLY_CODE	CHAR	1	0	Italy - Type of Delivery with Services
76	PAYMENT_CODE	☐	INTRA_PAYMENT_CODE	INTRA_PAYMENT_CODE	CHAR	1	0	Italy - Payment Method for Services
77	PAYER_COUNTRY	☐	PLARG	LAND1	CHAR	3	0	Country of the payer	*
78	PROT_NO	☐	EXDANUMD	NUMC6	NUMC	6	0	Sequence Number of Intrastat Declaration in this Period
79	PROG_NO	☐	FTLFDNR	NUMC6	NUMC	6	0	Foreign Trade: Periodic Declarations: Sequence Number
80	LFDNR	☐	ORDPA	CHAR10	CHAR	10	0	Classification Key for Periodic Declarations in For. Trade
81	BELNR	☐	BELEGNUMR	VBELN	CHAR	10	0	Document number	*
82	POSNR	☐	HAUPTPOSI	POSNR	NUMC	6	0	Item	*
83	MORED	☐	FTMORED	CHAR8	CHAR	8	0	Foreign Trade: Periodic Declarations: Aggregated Entries
84	TABIX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
85	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	V50GALV8	ARTGESCHA	T605	EXART	REF	1	CN
2	V50GALV8	BESONMAEH	T006	MSEHI	REF	1	CN
3	V50GALV8	BESTILAND	T005	LAND1	REF	1	CN
4	V50GALV8	EIGENMAEH	T006	MSEHI	REF	1	CN
5	V50GALV8	EINKAUFOR	T024E	EKORG	REF	C	CN
6	V50GALV8	EINLADFGH	T615	ZOLLA	REF	1	CN
7	V50GALV8	GRENZWEEH	TCURC	WAERS	REF	1	CN
8	V50GALV8	IFREMDWEH	TCURC	WAERS	REF	1	CN
9	V50GALV8	IREFWERKS	T001W	WERKS	REF	1	CN
10	V50GALV8	KUNNR	KNA1	KUNNR
11	V50GALV8	LIEFERBED	TINC	INCO1	REF	1	CN
12	V50GALV8	LIEFERWAE	TCURC	WAERS	REF	1	CN
13	V50GALV8	LIFNR	LFA1	LIFNR
14	V50GALV8	MANDT	T000	MANDT	KEY	1	CN
15	V50GALV8	MATNR	MARA	MATNR
16	V50GALV8	NUMMBUKRS	T001	BUKRS	REF	1	CN
17	V50GALV8	NUMMWERKS	T001W	WERKS	REF	1	CN
18	V50GALV8	PREFPACOD	T604C	PREFPACOD		1	CN
19	V50GALV8	RECHNWEEH	TCURC	WAERS	REF	1	CN
20	V50GALV8	STATWAREN	T604	STAWN	REF	1	CN
21	V50GALV8	URSPRSLND	T005	LAND1	REF	1	CN
22	V50GALV8	VERFAHREN	T616	EXPRF	REF	1	CN
23	V50GALV8	VERKAUFOR	TVKO	VKORG	REF	1	CN
24	V50GALV8	VERKEHRZW	T618	EXPVZ	REF	1	CN
25	V50GALV8	WERKSLAND	T005	LAND1	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in