SAP ABAP Table J_7LMSBELEG_SPV1 (REA Declaration: Final Annual Declaration SPV)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ IS-REA-COR (Application Component) Recycling Administration Core Functions
     ⤷ J7LR (Package) REA Core Functionality

Basic Data

Table Category	INTTAB	Structure
Structure	J_7LMSBELEG_SPV1	Table Relationship Diagram
Short Description	REA Declaration: Final Annual Declaration SPV

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	MELDUNGSTITEL	☐	J_7LMELDUNGSTITEL	J_7LCHAR90	CHAR	90	0	Title That Appears on a Form
2	MELDUNGSTITEL2	☐	J_7LMELDUNGSTITEL	J_7LCHAR90	CHAR	90	0	Title That Appears on a Form
3	GJAHR_PRE	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
5	MSATZ	☐	MSATZ_F05L	PRZ43V	DEC	7	3	Tax rate
6	ENTNA	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
7	KPROZ	☐	J_7LKPROZ	DECV3_3	DEC	6	3	Percentage for Valuation Share (Price List Item/Trade Level)
8	STENRRPA	☐	STENR	CHAR18	CHAR	18	0	Tax Number at Responsible Tax Authority
9	STCEGRPA	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
10	.INCLU-KOP	☐				0	0	REA Declaration: Header Data Fields
11	FIRMAKOP	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
12	ANREDKOP	☐	ANRED	TEXT15	CHAR	15	0	Title
13	NAME1KOP	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
14	NAME2KOP	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
15	NAME3KOP	☐	NAME3_BAS	NAME	CHAR	35	0	Name 3
16	NAME4KOP	☐	NAME4_BAS	NAME	CHAR	35	0	Name 4
17	STRASKOP	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
18	PSTLZKOP	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
19	LAND1KOP	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
20	ORT01KOP	☐	ORT01	TEXT25	CHAR	25	0	City
21	REGIOKOP	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
22	REGIO_BEZEIKOP	☐	BEZEI20	TEXT20	CHAR	20	0	Description
23	TELF1KOP	☐	TLFNR	TEXT30	CHAR	30	0	Addresses: telephone no.
24	TELFXKOP	☐	TELFX_BAS	TEXT31	CHAR	31	0	Fax number
25	SMTP_ADDRKOP	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
26	ZNEHMKOP	☐	J_7LZNEHM	J_7LZNEH	CHAR	12	0	Licensee, Customer Number with Recycling Partner REA
27	LFDNRKOP	☐	J_7LLFDNR	J_7LLFDNR	NUMC	10	0	REA Declaration: Sequence Number for DSD Document Type
28	MMKNZKOP	☐	J_7LCBMMKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Monthly Declaration
29	QMKNZKOP	☐	J_7LCBQMKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Quarterly Declaration
30	JMKNZKOP	☐	J_7LCBJMKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Annual Declaration
31	JAKNZKOP	☐	J_7LCBJAKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Final Annual Declaration
32	PERIO_TEXTKOP	☐	J_7LPERIO_TEXT	J_7LPERIO_TEXT	CHAR	30	0	REA Declaration: Periodicity in Words
33	PERINRKOP	☐	J_7LPERIONR	CHAR02	CHAR	2	0	REA Declaration: Period Number
34	GJAHRKOP	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
35	STCEGKOP	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
36	STENRKOP	☐	STENR	CHAR18	CHAR	18	0	Tax Number at Responsible Tax Authority
37	STCD1KOP	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
38	STCD2KOP	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
39	ZARTKOP	☐	J_7LZART	J_7LZART	CHAR	1	0	Payment Type
40	TLKNZKOP	☐	J_7LTLKNZ	CHAR1_X	CHAR	1	0	REA Indicator for Test Run
41	BUDATKOP	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
42	TESTTEXTKOP	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
43	PREVIEWKOP	☐	J_7LMSPREVIEW	CHAR1_X	CHAR	1	0	Indicator for Screen Preview
44	HOSTIDKOP	☐	J_7LMSHOSTID	CHAR255	CHAR	255	0	TCP/IP Address in Character
45	FONAMKOP	☐	J_7LMSMDF	CHAR020	CHAR	20	0	REA Declaration system: Name of MDF file for Jetform
46	.INCLU-RPA	☐				0	0	Address Management: Company Data
47	MANDTRPA	☐	MANDT	MANDT	CLNT	3	0	Client	T000
48	ADRNRRPA	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
49	NATIORPA	☐	INTER	NATION	CHAR	1	0	International address version ID	*
50	ANREDRPA	☐	ANRED	TEXT15	CHAR	15	0	Title
51	NAME1RPA	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
52	NAME2RPA	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
53	NAME3RPA	☐	NAME3_BAS	NAME	CHAR	35	0	Name 3
54	NAME4RPA	☐	NAME4_BAS	NAME	CHAR	35	0	Name 4
55	PSTLZRPA	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
56	ORT01RPA	☐	ORT01_GP	TEXT35	CHAR	35	0	City
57	ORT02RPA	☐	ORT02_BAS	TEXT35	CHAR	35	0	District
58	PSTL2RPA	☐	PSTL2_BAS	PSTLZ	CHAR	10	0	PO Box postal code
59	PFACHRPA	☐	PFACH_BAS	PFACH	CHAR	10	0	PO box
60	STRASRPA	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
61	STRS2RPA	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
62	HAUSNRPA	☐	HAUSN_BAS	CHAR6	CHAR	6	0	House number
63	STOCKRPA	☐	STOCK	STOCK	CHAR	6	0	Floor
64	LAND1RPA	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
65	SORTLRPA	☐	SORTL_BAS	CHAR10	CHAR	10	0	Sort field
66	SORT2RPA	☐	SORT20	CHAR20	CHAR	20	0	Sort field
67	SPRASRPA	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
68	LZONERPA	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
69	REGIORPA	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
70	PSTBZRPA	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
71	TELF1RPA	☐	TLFNR	TEXT30	CHAR	30	0	Addresses: telephone no.
72	FLAGRPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
73	TELFXRPA	☐	TELFX_BAS	TEXT31	CHAR	31	0	Fax number
74	FLAG2RPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
75	TELTXRPA	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
76	FLAG3RPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
77	TELX1RPA	☐	TELX1	TEXT30	CHAR	30	0	Telex number
78	FLAG4RPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
79	MAIADRPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
80	MAILNRPA	☐	OBJ_NAM	DOC_NAM	CHAR	12	0	Addresses: Document name
81	STDKORPA	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
82	STDCOMRPA	☐	COM_ART	COM_ART	CHAR	3	0	Addresses: Communication type
83	DBNAMERPA	☐	SYM_DST	CHAR10	CHAR	10	0	Addresses: System ID
84	KLASSERPA	☐	SO_KLASSE	KLASSE	CHAR	18	0	Addresses: class assigned to an address
85	ANREKRPA	☐	ANREK	ANREK	CHAR	2	0	Addresses: Form of address key
86	CRNAMRPA	☐	CR_NAM	USERNAME	CHAR	12	0	Addresses: Created by
87	CRDATRPA	☐	CR_DAT	DATUM	DATS	8	0	Addresses: Creation date
88	CRTIMRPA	☐	CR_TIM	UZEIT	TIMS	6	0	Addresses: Creation time
89	CHNAMRPA	☐	CH_NAM	USERNAME	CHAR	12	0	Addresses: Changed by
90	CHDATRPA	☐	CH_DAT	DATUM	DATS	8	0	Addresses: Change date
91	CHTIMRPA	☐	CH_TIM	UZEIT	TIMS	6	0	Addresses: Changed at
92	DUEFLRPA	☐	DUEFL_BAS	DUEFL_BAS	CHAR	1	0	Status of data transfer into subsequent release
93	TXJCDRPA	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
94	PFORTRPA	☐	PFORT_ADRS	TEXT40	CHAR	40	0	PO Box city
95	TZONERPA	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
96	COUNTY_CODERPA	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county	*
97	COUNTYRPA	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
98	TOWNSHIP_CODERPA	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township	*
99	TOWNSHIPRPA	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
100	.INCLU-SUM	☐				0	0	REA Declaration: Subtotal Result
101	SUM1SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
102	SUM2SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
103	SUM3SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
104	SUM4SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
105	SUM5SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
106	SUM6SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
107	SUM7SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
108	SUM8SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
109	SUM9SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
110	SUM10SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
111	SUM11SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
112	SUM12SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
113	SUM13SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
114	SUM14SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
115	SUM15SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
116	SUM16SUM	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
117	.INCLU-USR	☐				0	0	REA Declar.: Personal Data for Communication Structure Doc.
118	.INCLU-USR	☐				0	0	User address data
119	MANDTUSR	☐	MANDT	MANDT	CLNT	3	0	Client	T000
120	BNAMEUSR	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
121	NAME1USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
122	NAME2USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
123	NAME3USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
124	NAME4USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
125	SALUTUSR	☐	XUSALUT	XUSALUT	CHAR	15	0	Form of address for letters
126	ABTLGUSR	☐	XUABTEI	ABTEI	CHAR	12	0	Department
127	KOSTLUSR	☐	XUKOSTL	CHAR8	CHAR	8	0	Cost center
128	BUINRUSR	☐	XUBUINR	XUBUINR	CHAR	6	0	Building number
129	ROONRUSR	☐	XUROONR	XUROONR	CHAR	6	0	Room number
130	STRASUSR	☐	XUSTRAS	TEXT30	CHAR	30	0	Street and House Number
131	PFACHUSR	☐	XUPFACH	XUPFACH	CHAR	10	0	PO box
132	PSTLZUSR	☐	XUPSTLZ	XUPSTLZ	CHAR	10	0	Postal code
133	ORT01USR	☐	XUORT01	TEXT25	CHAR	25	0	Location
134	REGIOUSR	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
135	LAND1USR	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
136	SPRASUSR	☐	XUSPRAS	SPRAS	LANG	1	0	Language Key	T002
137	TELPRUSR	☐	XUTELPR	XUTELNR	CHAR	16	0	Telephone number (private)
138	TELNRUSR	☐	XUTELNR	XUTELNR	CHAR	16	0	Telephone number (work)
139	TEL01USR	☐	XUTEL01	TEL01	CHAR	5	0	Telephone number
140	TEL02USR	☐	XUTEL01	TEL01	CHAR	5	0	Telephone number
141	TELX1USR	☐	XUTELX1	TEXT30	CHAR	30	0	Telex number
142	TELFXUSR	☐	XUTELFX	TEXT31	CHAR	31	0	Fax Number
143	TELTXUSR	☐	XUTELTX	TEXT30	CHAR	30	0	Teletex number
144	ORT02USR	☐	XUORT02	TEXT25	CHAR	25	0	Location
145	PSTL2USR	☐	XUPSTL2	XUPSTLZ	CHAR	10	0	District Postal Code
146	TZONEUSR	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
147	UNAMEUSR	☐	CHAR80	CHAR80	CHAR	80	0	Char 80
148	FUNCTIONUSR	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
149	SMTP_ADDRUSR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
150	.INCLU-CUS	☐				0	0	REA Declaration: Customer Data Fields
151	FELD_KUNNRCUS	☐	J_7LFELDBZ	CHAR25	CHAR	25	0	REA Declaration: Field label on document
152	KUNNRCUS	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
153	FELD_HAENDLERNRCUS	☐	J_7LFELDBZ	CHAR25	CHAR	25	0	REA Declaration: Field label on document
154	HAENDLERNRCUS	☐	J_7LZNEHM_KUNDE	J_7LZNEH	CHAR	12	0	Licensee Number of Customer Number with Recycling Partner
155	FELD_CONTRACTNRCUS	☐	J_7LFELDBZ	CHAR25	CHAR	25	0	REA Declaration: Field label on document
156	CONTRACTNRCUS	☐	J_7LCONTRACTNR	J_7LZNEH	CHAR	12	0	REA Declar.: Optional Contract No.Between Licensee + Re.Part
157	FIRMACUS	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
158	STRASCUS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
159	PSTLZCUS	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
160	LAND1CUS	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
161	ORT01CUS	☐	ORT01	TEXT25	CHAR	25	0	City
162	REGIOCUS	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
163	REGIO_BEZEICUS	☐	BEZEI20	TEXT20	CHAR	20	0	Description
164	TELF1CUS	☐	TLFNR	TEXT30	CHAR	30	0	Addresses: telephone no.
165	TELFXCUS	☐	TELFX_BAS	TEXT31	CHAR	31	0	Fax number
166	SMTP_ADDRCUS	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
167	ZNEHMCUS	☐	J_7LZNEHM	J_7LZNEH	CHAR	12	0	Licensee, Customer Number with Recycling Partner REA
168	LFDNRCUS	☐	J_7LLFDNR	J_7LLFDNR	NUMC	10	0	REA Declaration: Sequence Number for DSD Document Type
169	MMKNZCUS	☐	J_7LCBMMKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Monthly Declaration
170	QMKNZCUS	☐	J_7LCBQMKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Quarterly Declaration
171	JMKNZCUS	☐	J_7LCBJMKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Annual Declaration
172	JAKNZCUS	☐	J_7LCBJAKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Final Annual Declaration
173	PERIO_TEXTCUS	☐	J_7LPERIO_TEXT	J_7LPERIO_TEXT	CHAR	30	0	REA Declaration: Periodicity in Words
174	PERINRCUS	☐	J_7LPERIONR	CHAR02	CHAR	2	0	REA Declaration: Period Number
175	GJAHRCUS	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
176	STCEGCUS	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
177	STENRCUS	☐	STENR	CHAR18	CHAR	18	0	Tax Number at Responsible Tax Authority
178	BUDATCUS	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_7LMSBELEG_SPV1	LAND1RPA	T005	LAND1	REF	1	CN
2	J_7LMSBELEG_SPV1	LAND1USR	T005	LAND1
3	J_7LMSBELEG_SPV1	LZONERPA	TZONE	ZONE1	REF	1	CN
4	J_7LMSBELEG_SPV1	MANDTRPA	T000	MANDT	KEY	1	CN
5	J_7LMSBELEG_SPV1	MANDTUSR	T000	MANDT	KEY	1	CN
6	J_7LMSBELEG_SPV1	REGIORPA	T005S	BLAND	REF	1	CN
7	J_7LMSBELEG_SPV1	REGIOUSR	T005S	BLAND
8	J_7LMSBELEG_SPV1	SPRASRPA	T002	SPRAS	REF	1	CN
9	J_7LMSBELEG_SPV1	SPRASUSR	T002	SPRAS	KEY	1	CN
10	J_7LMSBELEG_SPV1	TZONERPA	TTZZ	TZONE	REF	1	CN
11	J_7LMSBELEG_SPV1	TZONEUSR	TTZZ	TZONE

History

Last changed by/on	SAP	20130529
SAP Release Created in