SAP table GLP0 (Local Logical General Ledger Plan Line Items)

SAP table GLP0 has 14 primary key fields being RCLNT,RLDNR,RRCTY,RVERS,BUKRS,RYEAR,RACCT,RBUSA,RTCUR,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
BUKRS Company Code CHAR 4 0 T001 BUKRS
RYEAR Fiscal Year NUMC 4 0 GJAHR
RACCT Account Number CHAR 10 0 RACCT
RBUSA Business Area CHAR 4 0 TGSB GSBER
RTCUR Currency Key CUKY 5 0 TCURC RTCUR
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 Document Number of an Accounting Document CHAR 10 0 BELNR_D
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
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
DOCTY FI-SL Document Type CHAR 2 0 T889 DOCTY
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

GLP0 foreign key relationships

Table Field Check Table Check Field
0 GLP0 BUKRS T001 Company Codes BUKRS
1 GLP0 DOCTY T889 FI-SL Document Types MANDT
1 GLP0 DOCTY T889 FI-SL Document Types DOCTY
0 GLP0 RBUSA TGSB Business Areas MANDT
0 GLP0 RBUSA TGSB Business Areas GSBER
1 GLP0 RCLNT T000 Clients MANDT
0 GLP0 RLDNR T881 Ledger Master MANDT
1 GLP0 RTCUR TCURC Currency Codes MANDT
1 GLP0 RTCUR TCURC Currency Codes WAERS
0 GLP0 RVERS T894 FI-SL and FI-LC Versions MANDT
0 GLP0 RVERS T894 FI-SL and FI-LC Versions RLDNR
0 GLP0 RVERS T894 FI-SL and FI-LC Versions RVERS