SAP ABAP Table J_7LMSBELEG_CUST1 (REA Declaration: Generic Document for Cust. Dev.)

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_CUST1	Table Relationship Diagram
Short Description	REA Declaration: Generic Document for Cust. Dev.

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	MELDUNGSTEXT	☐	J_7LMELDUNGSTEXT	J_7LCHAR90	CHAR	90	0	Text That Appears on a Form
4	ENTNA	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
5	UNAME	☐	CHAR80	CHAR80	CHAR	80	0	Char 80
6	ZNEHMNAME	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
7	KPROZ	☐	J_7LKPROZ	DECV3_3	DEC	6	3	Percentage for Valuation Share (Price List Item/Trade Level)
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	Address Management: Company Data
45	MANDTRPA	☐	MANDT	MANDT	CLNT	3	0	Client	T000
46	ADRNRRPA	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
47	NATIORPA	☐	INTER	NATION	CHAR	1	0	International address version ID	*
48	ANREDRPA	☐	ANRED	TEXT15	CHAR	15	0	Title
49	NAME1RPA	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
50	NAME2RPA	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
51	NAME3RPA	☐	NAME3_BAS	NAME	CHAR	35	0	Name 3
52	NAME4RPA	☐	NAME4_BAS	NAME	CHAR	35	0	Name 4
53	PSTLZRPA	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
54	ORT01RPA	☐	ORT01_GP	TEXT35	CHAR	35	0	City
55	ORT02RPA	☐	ORT02_BAS	TEXT35	CHAR	35	0	District
56	PSTL2RPA	☐	PSTL2_BAS	PSTLZ	CHAR	10	0	PO Box postal code
57	PFACHRPA	☐	PFACH_BAS	PFACH	CHAR	10	0	PO box
58	STRASRPA	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
59	STRS2RPA	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
60	HAUSNRPA	☐	HAUSN_BAS	CHAR6	CHAR	6	0	House number
61	STOCKRPA	☐	STOCK	STOCK	CHAR	6	0	Floor
62	LAND1RPA	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
63	SORTLRPA	☐	SORTL_BAS	CHAR10	CHAR	10	0	Sort field
64	SORT2RPA	☐	SORT20	CHAR20	CHAR	20	0	Sort field
65	SPRASRPA	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
66	LZONERPA	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
67	REGIORPA	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
68	PSTBZRPA	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
69	TELF1RPA	☐	TLFNR	TEXT30	CHAR	30	0	Addresses: telephone no.
70	FLAGRPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
71	TELFXRPA	☐	TELFX_BAS	TEXT31	CHAR	31	0	Fax number
72	FLAG2RPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
73	TELTXRPA	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
74	FLAG3RPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
75	TELX1RPA	☐	TELX1	TEXT30	CHAR	30	0	Telex number
76	FLAG4RPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
77	MAIADRPA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
78	MAILNRPA	☐	OBJ_NAM	DOC_NAM	CHAR	12	0	Addresses: Document name
79	STDKORPA	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
80	STDCOMRPA	☐	COM_ART	COM_ART	CHAR	3	0	Addresses: Communication type
81	DBNAMERPA	☐	SYM_DST	CHAR10	CHAR	10	0	Addresses: System ID
82	KLASSERPA	☐	SO_KLASSE	KLASSE	CHAR	18	0	Addresses: class assigned to an address
83	ANREKRPA	☐	ANREK	ANREK	CHAR	2	0	Addresses: Form of address key
84	CRNAMRPA	☐	CR_NAM	USERNAME	CHAR	12	0	Addresses: Created by
85	CRDATRPA	☐	CR_DAT	DATUM	DATS	8	0	Addresses: Creation date
86	CRTIMRPA	☐	CR_TIM	UZEIT	TIMS	6	0	Addresses: Creation time
87	CHNAMRPA	☐	CH_NAM	USERNAME	CHAR	12	0	Addresses: Changed by
88	CHDATRPA	☐	CH_DAT	DATUM	DATS	8	0	Addresses: Change date
89	CHTIMRPA	☐	CH_TIM	UZEIT	TIMS	6	0	Addresses: Changed at
90	DUEFLRPA	☐	DUEFL_BAS	DUEFL_BAS	CHAR	1	0	Status of data transfer into subsequent release
91	TXJCDRPA	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
92	PFORTRPA	☐	PFORT_ADRS	TEXT40	CHAR	40	0	PO Box city
93	TZONERPA	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
94	KONTO_TVK	☐	KONTO	KTO16	CHAR	16	0	Account number
95	KOSTL_TVK	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
96	NETWR_TVK	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
97	GSBER_GESAMT	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
98	KONTO_MWST	☐	KONTO	KTO16	CHAR	16	0	Account number
99	MWST	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
100	KONTO_DSD	☐	KONTO	KTO16	CHAR	16	0	Account number
101	DSD_GESAMT	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
102	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
103	TVK_FAKTOR	☐	J_7LKPROZ	DECV3_3	DEC	6	3	Percentage for Valuation Share (Price List Item/Trade Level)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_7LMSBELEG_CUST1	LAND1RPA	T005	LAND1	REF	1	CN
2	J_7LMSBELEG_CUST1	LZONERPA	TZONE	ZONE1	REF	1	CN
3	J_7LMSBELEG_CUST1	MANDTRPA	T000	MANDT	KEY	1	CN
4	J_7LMSBELEG_CUST1	REGIORPA	T005S	BLAND	REF	1	CN
5	J_7LMSBELEG_CUST1	SPRASRPA	T002	SPRAS	REF	1	CN
6	J_7LMSBELEG_CUST1	TZONERPA	TTZZ	TZONE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in