SAP table GLP2 (Global Special Purpose Ledger Plan Line Item Table)

SAP table GLP2 has 25 primary key fields being RCLNT,RLDNR,RRCTY,RVERS,RCOMP,RYEAR,RACCT,RBUSA,RLEVL,DOCTY,RSUBD,RMVCT,RASSC,SBUSA,RYACQ,RPACQ,OCLNT,OBUKR,RTCUR,RUNIT,DRCRK,RPMAX,DOCCT,DOCNR,DOCLN.

Field Description Data Type Length Decimals Checktable Data Element
RCLNT Client CLNT 3 0 T000 MANDT
RLDNR Ledger CHAR 2 0 T881 RLDNR
RRCTY Record Type CHAR 1 0 RRCTY
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
5 Year-End Closing Posting
RVERS Version CHAR 3 0 T894 RVERS
RCOMP Company CHAR 6 0 T880 RCOMP_D
RYEAR Fiscal Year NUMC 4 0 GJAHR
RACCT Account Number CHAR 10 0 RACCT
RBUSA Business Area CHAR 4 0 TGSB GSBER
RLEVL Posting level CHAR 1 0 RLEVL
1 Standardizing entries to one company
2 Eliminating entries by company pair
3 Subgroup-dependent consolidating entries (partner in subgrp)
4 Subgroup-dependent consolidating entries (ext.trdng partner)
DOCTY FI-SL Document Type CHAR 2 0 T889 DOCTY
RSUBD Subgroup CHAR 3 0 T852 RSUBD
RMVCT Transaction type CHAR 3 0 T856 RMVCT
RASSC Company ID of Trading Partner CHAR 6 0 T880 RASSC
SBUSA Trading partner's business area CHAR 4 0 TGSB PARGB
RYACQ Year of acquisition CHAR 4 0 RYACQ
RPACQ Period of Acquisition NUMC 3 0 RPACQ
OCLNT Original client NUMC 3 0 OCLNT
OBUKR Original company code CHAR 4 0 T001 OBUKR
RTCUR Currency Key CUKY 5 0 TCURC RTCUR
RUNIT Base Unit of Measure UNIT 3 0 T006 MEINS
DRCRK Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
RPMAX Period NUMC 3 0 RPMAX
DOCCT Document Category CHAR 1 0 DOCCT
* Any document type
A Documents with assigned document no. of receiver application
B Documents from accounting
C Documents from currency translation
G Documents from FI-SL for global postings
J Documents from Joint Venture
K Documents from CO
L Documents from FI-SL for local postings
M Consolidation documents (EC-MC)
P Documents from manual planning
R Rollup documents
S Documents for which FI-SL assigns document numbers
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
W Documents from the FI/CO doc
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
DOCNR Doc. Number CHAR 10 0 DOCNR
DOCLN Document line CHAR 3 0 DOCLN
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
USNAM User Name CHAR 12 0 USNAM
TSLVT Balance carried forward in transaction currency CURR 23 2 TSLVT
TSL01 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL02 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL03 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL04 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL05 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL06 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL07 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL08 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL09 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL10 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL11 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL12 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL13 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL14 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL15 Total transactions of the period in transaction currency CURR 23 2 TSLXX
TSL16 Total transactions of the period in transaction currency CURR 23 2 TSLXX
HSLVT Balance carried forward in local currency (currency 2) CURR 23 2 HSLVT
HSL01 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL02 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL03 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL04 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL05 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL06 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL07 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL08 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL09 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL10 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL11 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL12 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL13 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL14 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL15 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
HSL16 Total transactions in the period in local currency (curr 2) CURR 23 2 HSLXX
KSLVT Balance carried forward in group currency (currency 3) CURR 23 2 KSLVT
KSL01 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL02 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL03 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL04 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL05 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL06 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL07 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL08 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL09 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL10 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL11 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL12 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL13 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL14 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL15 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
KSL16 Total transactions in the period in group currency (curr 3) CURR 23 2 KSLXX
MSLVT Balance carried forward of quantity QUAN 15 3 MSLVT
MSL01 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL02 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL03 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL04 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL05 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL06 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL07 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL08 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL09 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL10 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL11 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL12 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL13 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL14 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL15 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
MSL16 Total of the transactions of period in units of measure QUAN 15 3 MSLXX
ASLVT Balance carried forward of additional quantity QUAN 15 3 ASLVT
ASL01 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL02 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL03 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL04 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL05 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL06 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL07 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL08 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL09 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL10 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL11 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL12 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL13 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL14 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL15 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
ASL16 Total of transactions of period in additional quantities QUAN 15 3 ASLXX
AUNIT Additional unit of measure UNIT 3 0 T006 AUNIT
SGTXT Item Text CHAR 50 0 SGTXT
AUTOM Indicator: Automatic posting lines CHAR 1 0 AUTOM
ACTIV Business Transaction CHAR 4 0 GLVOR
REFDOCNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
REFRYEAR Fiscal Year NUMC 4 0 GJAHR
REFDOCLN Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
REFDOCCT Document Category CHAR 1 0 DOCCT
* Any document type
A Documents with assigned document no. of receiver application
B Documents from accounting
C Documents from currency translation
G Documents from FI-SL for global postings
J Documents from Joint Venture
K Documents from CO
L Documents from FI-SL for local postings
M Consolidation documents (EC-MC)
P Documents from manual planning
R Rollup documents
S Documents for which FI-SL assigns document numbers
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
W Documents from the FI/CO doc
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV Business Transaction CHAR 4 0 GLVOR
AWTYP Reference procedure CHAR 5 0 AWTYP
AWORG Reference Organizational Units CHAR 10 0 AWORG
LOGSYS Logical system CHAR 10 0 LOGSYS

GLP2 foreign key relationships

Table Field Check Table Check Field
0 GLP2 DOCTY T889 FI-SL Document Types MANDT
0 GLP2 DOCTY T889 FI-SL Document Types DOCTY
1 GLP2 OBUKR T001 Company Codes BUKRS
0 GLP2 RASSC T880 Global Company Data (for KONS Ledger) MANDT
0 GLP2 RASSC T880 Global Company Data (for KONS Ledger) RCOMP
1 GLP2 RBUSA TGSB Business Areas MANDT
1 GLP2 RBUSA TGSB Business Areas GSBER
0 GLP2 RCLNT T000 Clients MANDT
1 GLP2 RCOMP T880 Global Company Data (for KONS Ledger) MANDT
1 GLP2 RCOMP T880 Global Company Data (for KONS Ledger) RCOMP
0 GLP2 RLDNR T881 Ledger Master MANDT
1 GLP2 RMVCT T856 Transaction Types MANDT
1 GLP2 RMVCT T856 Transaction Types TRTYP
0 GLP2 RSUBD T852 Subgroups MANDT
1 GLP2 RTCUR TCURC Currency Codes MANDT
1 GLP2 RTCUR TCURC Currency Codes WAERS
0 GLP2 RUNIT T006 Units of Measurement MSEHI
1 GLP2 RVERS T894 FI-SL and FI-LC Versions MANDT
1 GLP2 RVERS T894 FI-SL and FI-LC Versions RLDNR
1 GLP2 RVERS T894 FI-SL and FI-LC Versions RVERS
0 GLP2 SBUSA TGSB Business Areas MANDT
0 GLP2 SBUSA TGSB Business Areas GSBER