SAP ABAP Table PCRRETAILP (Plan line items table)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-RL (Application Component) Retail Ledger
     ⤷ WRTL (Package) Retail Ledger

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PCRRETAILP	Table Relationship Diagram
Short Description	Plan line items table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	RCLNT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	GL_SIRID	☑	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
3	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
4	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
5	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
6	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
8	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
9	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
10	RPMAX	☐	RPMAX	RPMAX	NUMC	3	0	Period
11	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
12	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
13	DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
14	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
16	RPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
17	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
18	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
19	RASAREA_7	☐	ASAREA_7	ASAREA_7	CHAR	18	0	Assortment Area
20	RWBSE_7	☐	WBSE_7	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
21	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
22	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
23	STAGR	☐	STAGR	STAGR	CHAR	6	0	Statistical key figure	*
24	TSLVT	☐	TSLVT9	WERTV9	CURR	17	2	Balance carried forward in transaction currency
25	TSL01	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
26	TSL02	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
27	TSL03	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
28	TSL04	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
29	TSL05	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
30	TSL06	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
31	TSL07	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
32	TSL08	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
33	TSL09	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
34	TSL10	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
35	TSL11	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
36	TSL12	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
37	TSL13	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
38	TSL14	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
39	TSL15	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
40	TSL16	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
41	HSLVT	☐	HSLVT9	WERTV9	CURR	17	2	Balance carried forward in local currency
42	HSL01	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
43	HSL02	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
44	HSL03	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
45	HSL04	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
46	HSL05	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
47	HSL06	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
48	HSL07	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
49	HSL08	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
50	HSL09	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
51	HSL10	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
52	HSL11	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
53	HSL12	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
54	HSL13	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
55	HSL14	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
56	HSL15	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
57	HSL16	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
58	KSLVT	☐	KSLVT9	WERTV9	CURR	17	2	Balance carried forward in group currency
59	KSL01	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
60	KSL02	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
61	KSL03	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
62	KSL04	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
63	KSL05	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
64	KSL06	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
65	KSL07	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
66	KSL08	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
67	KSL09	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
68	KSL10	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
69	KSL11	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
70	KSL12	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
71	KSL13	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
72	KSL14	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
73	KSL15	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
74	KSL16	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
75	MSLVT	☐	MSLVT	MENGV8	QUAN	15	3	Balance carried forward of quantity
76	MSL01	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
77	MSL02	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
78	MSL03	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
79	MSL04	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
80	MSL05	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
81	MSL06	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
82	MSL07	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
83	MSL08	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
84	MSL09	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
85	MSL10	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
86	MSL11	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
87	MSL12	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
88	MSL13	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
89	MSL14	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
90	MSL15	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
91	MSL16	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
92	ASLVT	☐	ASLVT	MENGV8	QUAN	15	3	Balance carried forward of additional quantity
93	ASL01	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
94	ASL02	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
95	ASL03	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
96	ASL04	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
97	ASL05	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
98	ASL06	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
99	ASL07	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
100	ASL08	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
101	ASL09	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
102	ASL10	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
103	ASL11	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
104	ASL12	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
105	ASL13	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
106	ASL14	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
107	ASL15	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
108	ASL16	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
109	AUNIT	☐	AUNIT	MEINS	UNIT	3	0	Additional unit of measure	T006
110	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
111	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
112	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
113	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
114	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
115	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
116	REFRYEAR	☐	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
117	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
118	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
119	REFACTIV	☐	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
120	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
121	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
122	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
123	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
124	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PCRRETAILP	AUNIT	T006	MSEHI	REF	C	CN
2	PCRRETAILP	AWTYP	TTYP	AWTYP	REF	C	CN
3	PCRRETAILP	DOCTY	T889	DOCTY	REF	C	CN
4	PCRRETAILP	LOGSYS	TBDLS	LOGSYS	REF	C	CN
5	PCRRETAILP	RBUKRS	T001	BUKRS	REF	C	CN
6	PCRRETAILP	RCLNT	T000	MANDT	KEY	1	CN
7	PCRRETAILP	RFAREA	TFKB	FKBER	REF	C	CN
8	PCRRETAILP	RLDNR	T881	RLDNR	REF	C	CN
9	PCRRETAILP	RTCUR	TCURC	WAERS	REF	C	CN
10	PCRRETAILP	RUNIT	T006	MSEHI	REF	C	CN
11	PCRRETAILP	RVERS	T894	RVERS	REF	C	CN

History

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