SAP ABAP Table J_7LMSBELEG_ERA3 (REA Declaration: Re. Partner ERA Document 3)

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_ERA3	Table Relationship Diagram
Short Description	REA Declaration: Re. Partner ERA Document 3

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	SUM1	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
2	SUM2	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
3	SUM3	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
4	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
5	UNAME	☐	CHAR80	CHAR80	CHAR	80	0	Char 80
6	MONAT	☐	J_7LPERIONR	CHAR02	CHAR	2	0	REA Declaration: Period Number
7	QUARTAL	☐	J_7LPERIONR	CHAR02	CHAR	2	0	REA Declaration: Period Number
8	MSATZ	☐	MSATZ_F05L	PRZ43V	DEC	7	3	Tax rate
9	XBLNR	☐	XBLNR_V	XBLNR	CHAR	16	0	Reference Document Number
10	VBELN	☐	J_7LVNR_A	VBELN	CHAR	10	0	REA Declaration: Document Number	*
11	PLVRS_DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
12	.INCLU-KOP	☐				0	0	REA Declaration: Header Data Fields
13	FIRMAKOP	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
14	ANREDKOP	☐	ANRED	TEXT15	CHAR	15	0	Title
15	NAME1KOP	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
16	NAME2KOP	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
17	NAME3KOP	☐	NAME3_BAS	NAME	CHAR	35	0	Name 3
18	NAME4KOP	☐	NAME4_BAS	NAME	CHAR	35	0	Name 4
19	STRASKOP	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
20	PSTLZKOP	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
21	LAND1KOP	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
22	ORT01KOP	☐	ORT01	TEXT25	CHAR	25	0	City
23	REGIOKOP	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
24	REGIO_BEZEIKOP	☐	BEZEI20	TEXT20	CHAR	20	0	Description
25	TELF1KOP	☐	TLFNR	TEXT30	CHAR	30	0	Addresses: telephone no.
26	TELFXKOP	☐	TELFX_BAS	TEXT31	CHAR	31	0	Fax number
27	SMTP_ADDRKOP	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
28	ZNEHMKOP	☐	J_7LZNEHM	J_7LZNEH	CHAR	12	0	Licensee, Customer Number with Recycling Partner REA
29	LFDNRKOP	☐	J_7LLFDNR	J_7LLFDNR	NUMC	10	0	REA Declaration: Sequence Number for DSD Document Type
30	MMKNZKOP	☐	J_7LCBMMKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Monthly Declaration
31	QMKNZKOP	☐	J_7LCBQMKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Quarterly Declaration
32	JMKNZKOP	☐	J_7LCBJMKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Annual Declaration
33	JAKNZKOP	☐	J_7LCBJAKNZ	CHAR1_X	CHAR	1	0	REA Declaration: Checkbox for Final Annual Declaration
34	PERIO_TEXTKOP	☐	J_7LPERIO_TEXT	J_7LPERIO_TEXT	CHAR	30	0	REA Declaration: Periodicity in Words
35	PERINRKOP	☐	J_7LPERIONR	CHAR02	CHAR	2	0	REA Declaration: Period Number
36	GJAHRKOP	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
37	STCEGKOP	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
38	STENRKOP	☐	STENR	CHAR18	CHAR	18	0	Tax Number at Responsible Tax Authority
39	STCD1KOP	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
40	STCD2KOP	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
41	ZARTKOP	☐	J_7LZART	J_7LZART	CHAR	1	0	Payment Type
42	TLKNZKOP	☐	J_7LTLKNZ	CHAR1_X	CHAR	1	0	REA Indicator for Test Run
43	BUDATKOP	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
44	TESTTEXTKOP	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
45	PREVIEWKOP	☐	J_7LMSPREVIEW	CHAR1_X	CHAR	1	0	Indicator for Screen Preview
46	HOSTIDKOP	☐	J_7LMSHOSTID	CHAR255	CHAR	255	0	TCP/IP Address in Character
47	FONAMKOP	☐	J_7LMSMDF	CHAR020	CHAR	20	0	REA Declaration system: Name of MDF file for Jetform
48	.INCLU-USR	☐				0	0	REA Declar.: Personal Data for Communication Structure Doc.
49	.INCLU-USR	☐				0	0	User address data
50	MANDTUSR	☐	MANDT	MANDT	CLNT	3	0	Client	T000
51	BNAMEUSR	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
52	NAME1USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
53	NAME2USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
54	NAME3USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
55	NAME4USR	☐	XUNAME1	XUNAME1	CHAR	30	0	Name of user within the company
56	SALUTUSR	☐	XUSALUT	XUSALUT	CHAR	15	0	Form of address for letters
57	ABTLGUSR	☐	XUABTEI	ABTEI	CHAR	12	0	Department
58	KOSTLUSR	☐	XUKOSTL	CHAR8	CHAR	8	0	Cost center
59	BUINRUSR	☐	XUBUINR	XUBUINR	CHAR	6	0	Building number
60	ROONRUSR	☐	XUROONR	XUROONR	CHAR	6	0	Room number
61	STRASUSR	☐	XUSTRAS	TEXT30	CHAR	30	0	Street and House Number
62	PFACHUSR	☐	XUPFACH	XUPFACH	CHAR	10	0	PO box
63	PSTLZUSR	☐	XUPSTLZ	XUPSTLZ	CHAR	10	0	Postal code
64	ORT01USR	☐	XUORT01	TEXT25	CHAR	25	0	Location
65	REGIOUSR	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
66	LAND1USR	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
67	SPRASUSR	☐	XUSPRAS	SPRAS	LANG	1	0	Language Key	T002
68	TELPRUSR	☐	XUTELPR	XUTELNR	CHAR	16	0	Telephone number (private)
69	TELNRUSR	☐	XUTELNR	XUTELNR	CHAR	16	0	Telephone number (work)
70	TEL01USR	☐	XUTEL01	TEL01	CHAR	5	0	Telephone number
71	TEL02USR	☐	XUTEL01	TEL01	CHAR	5	0	Telephone number
72	TELX1USR	☐	XUTELX1	TEXT30	CHAR	30	0	Telex number
73	TELFXUSR	☐	XUTELFX	TEXT31	CHAR	31	0	Fax Number
74	TELTXUSR	☐	XUTELTX	TEXT30	CHAR	30	0	Teletex number
75	ORT02USR	☐	XUORT02	TEXT25	CHAR	25	0	Location
76	PSTL2USR	☐	XUPSTL2	XUPSTLZ	CHAR	10	0	District Postal Code
77	TZONEUSR	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
78	UNAMEUSR	☐	CHAR80	CHAR80	CHAR	80	0	Char 80
79	FUNCTIONUSR	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
80	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_ERA3	LAND1USR	T005	LAND1
2	J_7LMSBELEG_ERA3	MANDTUSR	T000	MANDT	KEY	1	CN
3	J_7LMSBELEG_ERA3	REGIOUSR	T005S	BLAND
4	J_7LMSBELEG_ERA3	SPRASUSR	T002	SPRAS	KEY	1	CN
5	J_7LMSBELEG_ERA3	TZONEUSR	TTZZ	TZONE

History

Last changed by/on	SAP	20130529
SAP Release Created in	510