SAP ABAP Table J_7LMS (REA Periodical Declaration Communication Structure)

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_7LMS	Table Relationship Diagram
Short Description	REA Periodical Declaration Communication Structure

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	ENTNR	☐	J_7LRENT	LIFNR	CHAR	10	0	Recycling Partner	*
3	FMGRP	☐	J_7LFMGRP	J_7LFMGRP	CHAR	6	0	Form Group	*
4	FMGRP_V1K	☐	J_7LFMGRP	J_7LFMGRP	CHAR	6	0	Form Group	*
5	ENTNA	☐	J_7LENTNAM	J_7LENTNAM	CHAR	6	0	Recycling Partner	J_7LE00
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	J_7LC02
7	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	J_7LC10
8	BLART	☐	J_7LBLART	J_7LBLART	CHAR	4	0	Document Type for Recycling Partner	*
9	BLTYP	☐	J_7LVBTYP	J_7LRVBTYP	CHAR	1	0	REA Document Category
10	BLTYP_KOPF	☐	J_7LVBTYP	J_7LRVBTYP	CHAR	1	0	REA Document Category
11	FBGRP	☐	J_7LFBGRP	J_7LFBGRP	NUMC	3	0	Consecutive Document Type Group	J_7LE11
12	PERIO	☐	J_7LRPERIO	J_7LRPERIO	CHAR	1	0	REA Declaration Periodicity
13	PERIO_GELD	☐	J_7LRPERIO	J_7LRPERIO	CHAR	1	0	REA Declaration Periodicity
14	DATAB	☐	J_7LRDATAB	DATS	DATS	8	0	REA Settlement Period - Start
15	DATBI	☐	J_7LRDATBI	DATS	DATS	8	0	REA Settlement Period, End
16	PERINR	☐	J_7LPERINR	J_7LPERINR	NUMC	2	0	Period Number
17	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
18	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
19	DATPE	☐	J_7LRDATPE	DATUM	DATS	8	0	Key Date for Periodical Declaration REA
20	TLKNZ	☐	J_7LTLKNZ	CHAR1_X	CHAR	1	0	REA Indicator for Test Run
21	WAERU	☐	J_7LREWAER	WAERS	CUKY	5	0	Recycling Partner Currency	TCURC
22	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
23	KURSD	☐	KURSD	DATUM	DATS	8	0	Exchange rate date
24	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
25	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
26	PLVRS	☐	J_7LRPLVRS	J_7LRPLVRS	CHAR	6	0	Price List Version	*
27	KPROZ	☐	J_7LKPROZ	DECV3_3	DEC	6	3	Percentage for Valuation Share (Price List Item/Trade Level)
28	KZPRAD	☐	J_7LKZPRAD	XFELD	CHAR	1	0	Indicator for Price List Discount on Line Item, Additive
29	KORWE	☐	J_7LRKORWE	J_7LWERTVX	CURR	17	2	Adjustment Amount in Recycling Partner Crcy (REA Settlement)
30	KORWR	☐	J_7LRKORWR	J_7LWERTVX	CURR	17	2	Adjustment Amount in Document Currency (REA Settlement)
31	KORWH	☐	J_7LRKORWH	J_7LWERTVX	CURR	17	2	Adjustment Amount in Doc. Currency Calc. from Header Record
32	MWSKR	☐	J_7LMWSKB	J_7LWERTVX	CURR	17	2	Tax Adjustment Amount in Document Currency
33	MWSKE	☐	J_7LMWSKE	J_7LWERTVX	CURR	17	2	Tax Adjustment Amount in Recycling Partner Currency
34	MWSKH	☐	J_7LMWSKH	J_7LWERTVX	CURR	17	2	Tax Adjust. Amount in Doc.Currency Calculated fr.Header Rec.
35	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
36	SPLD	☐	RSPOPNAME	RSPOPNAME	CHAR	4	0	Spool: Output device	TSP03
37	PROTKZ	☐	J_7LPROTKZ	XFELD	CHAR	1	0	Indicator: Single Record Log for Productive Declaration
38	PROT_FORMAT	☐	J_7LPROT_FORMAT	XFELD	CHAR	1	0	REA Declaration: Format of Single Record Log (x= Multirow)
39	DTAKZ	☐	J_7LDTAKZ	CHAR1_X	CHAR	1	0	Indicator for Data Medium Exchange
40	DTA_STKZ	☐	J_7LFMGRP	J_7LFMGRP	CHAR	6	0	Form Group	*
41	PATHLOCAL	☐	LOCALFILE	LOCALFILE	CHAR	128	0	Local file for upload/download
42	PATHEXTERN	☐	PATHEXTERN	PATHEXTERN	CHAR	200	0	Physical path name
43	SUBRC	☐	SYSUBRC	SYST_SHORT	INT4	10	0	Return Code
44	MSATZ	☐	MSATZ_F05L	PRZ43V	DEC	7	3	Tax rate
45	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
46	RUNDG	☐	J_7LRUNDG	J_7LRUNDG	CHAR	1	0	Rounding Type for Item-Dependent Fee
47	ZART	☐	J_7LZART	J_7LZART	CHAR	1	0	Payment Type
48	EVENT	☐	J_7LEVENT	J_7LEVENT	CHAR	4	0	Time of Call
49	SAVKZ	☐	J_7LSAVKZ	XFELD	CHAR	1	0	Save Indicator
50	ANZKZ	☐	J_7LANZKZ	XFELD	CHAR	1	0	Display Indicator
51	SUNKZ	☐	J_7LSUNKZ	CHAR1_X	CHAR	1	0	Save Impossible
52	DUNKZ	☐	J_7LDUNKZ	CHAR1_X	CHAR	1	0	Print and Display Impossible
53	SAVEDKZ	☐	J_7LSAVEDKZ	CHAR1_X	CHAR	1	0	Indicator that Declaration Has Already Been Saved
54	FCODE	☐	SYUCOMM	SYCHAR70	CHAR	70	0	Function Code
55	FONAM	☐	J_7LMSMDF	CHAR020	CHAR	20	0	REA Declaration system: Name of MDF file for Jetform
56	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
57	SMARTFORM_KZ	☐	J_7LSMARTFORM_KZ	XFELD	CHAR	1	0	Indicator: User Smart Forms for Form Display
58	SAPSCRIPT	☐	TDFORM	TDFORM	CHAR	16	0	Form name
59	SMARTFONAM	☐	TDSFNAME	TDSFNAME	CHAR	30	0	Smart Forms: Form Name	*
60	D_FORM_NAME	☐	FPWBFORMNAME	FPNAME	CHAR	30	0	PDF-Based Forms: Form Name
61	APPEND_MODUS	☐	J_7LAPPEND_MODUS	J_7LAPPEND_MODUS	CHAR	1	0	REA Declaration System: Spool Control
62	JET_TERMINAL_KZ	☐	J_7LTERMINAL_KZ	CHAR1_X	CHAR	1	0	REA Indicator: Use of Terminal Name by Jetform Communication
63	JET_DOM_SUFFIX	☐	J_7LDOMAIN_SUFFIX	CHAR80	CHAR	80	0	REA: Suffix of a Network Domain
64	HITYP	☐	HITYP	CHAR4	CHAR	4	0	Superior Object Type
65	HISTUNR	☐	HISTUNR	NUM2	NUMC	2	0	Level number within hierarchy
66	HREKU	☐	J_7LHREKU	XFELD	CHAR	1	0	REA: Indicator that Customer Is Not in Hierarchy
67	VRSIO	☐	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
68	.INCLU-BAL	☐				0	0	Application Log: APPL_LOG_WRITE_MESSAGES interface
69	MSGTYBAL	☐	SYMSGTY	SYCHAR01	CHAR	1	0	Message Type
70	MSGIDBAL	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
71	MSGNOBAL	☐	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
72	MSGV1BAL	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
73	MSGV2BAL	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
74	MSGV3BAL	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
75	MSGV4BAL	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
76	ALTEXTBAL	☐	BALTEXT	CHAR28	CHAR	28	0	Application log: Standard text
77	USEREXITPBAL	☐	BALUEP	PROGNAME	CHAR	40	0	Application Log: Callback: Program name
78	USEREXITFBAL	☐	BALUEF	CHAR30	CHAR	30	0	Application Log: Callback: Routine name
79	DETLEVELBAL	☐	BALLEVEL	BALLEVEL	CHAR	1	0	Application Log: Level of detail
80	PROBCLASSBAL	☐	BALPROBCL	BALPROBCL	CHAR	1	0	Application log: Message problem class
81	ALSORTBAL	☐	BALSORT	CHAR3	CHAR	3	0	Application log: Sort criterion/grouping
82	.INCLU-CAT	☐				0	0	REA Periodical Declaration Catalog Structure
83	LOESCHENCAT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_7LMS	BUKRS	J_7LC02	BUKRS
2	J_7LMS	ENTNA	J_7LE00	ENTNA
3	J_7LMS	FBGRP	J_7LE11	FBGRP
4	J_7LMS	LAND1	J_7LC10	LAND1
5	J_7LMS	SPLD	TSP03	PADEST
6	J_7LMS	WAERK	TCURC	WAERS
7	J_7LMS	WAERU	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in