SAP ABAP Table J_7LMSBELEG_GEN1 (REA Declaration: Generic Document for Different Re.Partners)

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_GEN1	Table Relationship Diagram
Short Description	REA Declaration: Generic Document for Different Re.Partners

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

History

Last changed by/on	SAP	20130529
SAP Release Created in