SAP ABAP Table J_7LMSBELEG_EEF2 (REA Declaration: Partial Annual Doc./Balance Eco Emballages)

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_EEF2	Table Relationship Diagram
Short Description	REA Declaration: Partial Annual Doc./Balance Eco Emballages

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in