SAP ABAP Table /J7L/BI_DCL_TD (REA Extraction Structure for Declarations)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ IS-REA-COR (Application Component) Recycling Administration Core Functions
     ⤷ /J7L/BI (Package) REA BI Interface

Basic Data

Table Category	INTTAB	Structure
Structure	/J7L/BI_DCL_TD	Table Relationship Diagram
Short Description	REA Extraction Structure for Declarations

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	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
2	VBELN	☐	J_7LVNR_A	VBELN	CHAR	10	0	REA Declaration: Document Number	*
3	POSNR	☐	J_7LRPOS_A	NUMC6	NUMC	6	0	REA Declaration: Line Item
4	UEPOS	☐	J_7LUEPOS	NUMC6	NUMC	6	0	REA Declaration: Higher-Level Line Item
5	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
6	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
7	BLTYP	☐	J_7LVBTYP	J_7LRVBTYP	CHAR	1	0	REA Document Category
8	BLART	☐	J_7LBLART	J_7LBLART	CHAR	4	0	Document Type for Recycling Partner	*
9	XBLNR	☐	XBLNR_V	XBLNR	CHAR	16	0	Reference Document Number
10	SVBLN	☐	J_7LSVBLN	VBELN	CHAR	10	0	REA Declaration: Document of Canceled Declaration	*
11	ENTNR	☐	J_7LRENT	LIFNR	CHAR	10	0	Recycling Partner	*
12	ENTNA	☐	J_7LENTNAM	J_7LENTNAM	CHAR	6	0	Recycling Partner	*
13	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
14	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
15	ZNEHM	☐	J_7LZNEHM	J_7LZNEH	CHAR	12	0	Licensee, Customer Number with Recycling Partner REA
16	DATAB	☐	J_7LRDATAB	DATS	DATS	8	0	REA Settlement Period - Start
17	DATBI	☐	J_7LRDATBI	DATS	DATS	8	0	REA Settlement Period, End
18	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
19	NETWR	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
20	BERWR	☐	J_7LBERWR	J_7LWERTVX	CURR	17	2	Calculated Value in Document Currency (Output Value Formula)
21	PBERWR	☐	J_7LPBERWR	J_7LWERTVX	CURR	17	2	Calculated Value in Document Currency (Initial Value PF)
22	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
23	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
24	POSAR	☐	J_7LPOSAR	J_7LPOSAR	CHAR	1	0	Declaration Item Type
25	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
26	VARIANTE	☐	J_7LAVARIANTE	J_7LVARIANTE	CHAR	18	0	Variant of Article
27	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
28	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
29	GRUPPE	☐	J_7LGRUPPE	J_7LGRUPPE	CHAR	4	0	Grouping of Characteristics in MM	*
30	PGAAWR	☐	J_7LPGAAWR	J_7LWERTVX	CURR	17	2	Total Value Absolute Article in Doc.Crcy from Price Formula
31	PKPEIN	☐	J_7LKPEIN	J_7LKPEIN	DEC	9	0	Condition Pricing Unit
32	PREISB	☐	J_7LRSTPB	J_7LWERTVX	CURR	17	2	Price in Document Currency
33	KPEIN	☐	J_7LKPEIN	J_7LKPEIN	DEC	9	0	Condition Pricing Unit
34	VRPNR	☐	J_7LVRP	MATNR	CHAR	18	0	Packaging	*
35	VVARIANTE	☐	J_7LVVARIANTE	J_7LVARIANTE	CHAR	18	0	Variant of Packaging
36	VPEBENE	☐	J_7LVEBENE	J_7LVEBENE	NUMC	2	0	Packaging Level	*
37	KPEINV	☐	J_7LRKPEIN	KPEIN	DEC	5	0	Number of Sales Units in Packaging Bill of Material
38	VPARTG	☐	J_7LVPARTG	J_7LRVPART	NUMC	2	0	Packaging Type Weight-Dependent Fee	*
39	VPARTS	☐	J_7LVPARTS	J_7LRVPART	NUMC	2	0	Packaging Type Item-Dependent Fee	*
40	VRPKT	☐	J_7LVRPKT	J_7LVRPKT	CHAR	5	0	Packaging Category Fraction	*
41	FKIMP	☐	J_7LMNGP	J_7LDEC	DEC	17	6	Proportional Quantity (Sales / Entry Unit
42	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
43	STOFE	☐	J_7LRSTOFE	J_7LSTOFFE	CHAR	6	0	Partner Fraction	*
44	STOFP	☐	J_7LRSTOFP	J_7LSTOFFE	CHAR	6	0	Fraction Price: Recycling Partner	*
45	STGEW	☐	J_7LRGEW	J_7LMENGV17_6	QUAN	17	6	Fraction Weight
46	STGEWFF	☐	J_7LRGEW	J_7LMENGV17_6	QUAN	17	6	Fraction Weight
47	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
48	STGEWM	☐	J_7LRGEW	J_7LMENGV17_6	QUAN	17	6	Fraction Weight
49	GEWEIM	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
50	FMENGV	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
51	MEINSV	☐	KMPME	MEINS	UNIT	3	0	Component Unit of Measure	*
52	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
53	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
54	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
55	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
56	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
57	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	*
58	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
59	LLAND	☐	LLAND	LAND1	CHAR	3	0	Destination Country	*
60	INFOK	☐	J_7LINFOK	J_7LINFOK	CHAR	5	0	Additional Info Key	*
61	FUELLG	☐	J_7LFUELLG	J_7LFUELLG	CHAR	5	0	Content ID Key	*
62	HDLST	☐	J_7LHDLST	J_7LHDLST	NUMC	5	0	Trade Level	*
63	VLFLK	☐	J_7LVFLKL	J_7LRVFLKL	CHAR	6	0	Volume/Area Class	*
64	VFLST	☐	J_7LVFLST	J_7LMENGV17_6	QUAN	17	6	Number of Pieces for Volume and Area Classes
65	VRPST	☐	J_7LVRPST	J_7LMENGV17_6	QUAN	17	6	Number of Pieces, Packaging
66	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
67	KPROZH	☐	J_7LKPROZH	DECV3_2	DEC	5	2	Trade Level Valuation Percentage
68	KPROZHF	☐	J_7LKPROZHF	DECV3_2	DEC	5	2	Valuation Percentage for Trade Level Fraction
69	EXPORTKZ	☐	J_7LKZEXP	XFELD	CHAR	1	0	Indicator: Show Exports in Quantity Flow of Rec.Declaration
70	IMPORTKZ	☐	J_7LKZIMP	XFELD	CHAR	1	0	Indicator: Show Imports in Quantity Flow of Recyc. Declarat.
71	INLANDKZ	☐	J_7LKZINL	XFELD	CHAR	1	0	Indicator: Filter Out Domestic Purchases in Declaration
72	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On

History

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