SAP Table GLP0

Local Logical General Ledger Plan Line Items

GLP0 (Local Logical General Ledger Plan Line Items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link GLP0 to other SAP tables.

Source: GLP0 (Local Logical General Ledger Plan Line Items)

GLP0 table fields

Field Data element Checktable Datatype Length Decimals
RCLNT Client MANDT T000 CLNT 3 0
RLDNR Ledger RLDNR T881 CHAR 2 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version RVERS T894 CHAR 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
RYEAR Fiscal Year GJAHR NUMC 4 0
RACCT Account Number RACCT CHAR 10 0
RBUSA Business Area GSBER TGSB CHAR 4 0
RTCUR Currency Key RTCUR TCURC CUKY 5 0
DRCRK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
RPMAX Period RPMAX NUMC 3 0
DOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
DOCNR Accounting Document Number BELNR_D CHAR 10 0
DOCLN Document line DOCLN CHAR 3 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
USNAM User name USNAM CHAR 12 0
TSLVT Balance carried forward in transaction currency TSLVT CURR 15 2
TSL01 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL02 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL03 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL04 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL05 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL06 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL07 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL08 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL09 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL10 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL11 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL12 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL13 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL14 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL15 Total transactions of the period in transaction currency TSLXX CURR 15 2
TSL16 Total transactions of the period in transaction currency TSLXX CURR 15 2
HSLVT Balance carried forward in local currency (currency 2) HSLVT CURR 15 2
HSL01 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL02 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL03 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL04 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL05 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL06 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL07 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL08 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL09 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL10 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL11 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL12 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL13 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL14 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL15 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
HSL16 Total transactions in the period in local currency (curr 2) HSLXX CURR 15 2
KSLVT Balance carried forward in group currency (currency 3) KSLVT CURR 15 2
KSL01 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL02 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL03 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL04 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL05 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL06 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL07 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL08 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL09 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL10 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL11 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL12 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL13 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL14 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL15 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
KSL16 Total transactions in the period in group currency (curr 3) KSLXX CURR 15 2
AUNIT Additional unit of measure AUNIT T006 UNIT 3 0
SGTXT Item Text SGTXT CHAR 50 0
AUTOM Indicator: Automatic posting lines AUTOM CHAR 1 0
DOCTY FI-SL Document Type DOCTY T889 CHAR 2 0
ACTIV Business Transaction GLVOR CHAR 4 0
REFDOCNR Accounting Document Number BELNR_D CHAR 10 0
REFRYEAR Fiscal Year GJAHR NUMC 4 0
REFDOCLN Number of Line Item Within Accounting Document BUZEI NUMC 3 0
REFDOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV Business Transaction GLVOR CHAR 4 0
AWTYP Reference Transaction AWTYP CHAR 5 0
AWORG Reference Organizational Units AWORG CHAR 10 0
LOGSYS Logical system LOGSYS CHAR 10 0

GLP0 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
GLP0 AUNIT GLP0 RCLNT T006 Units of Measurement MANDT
GLP0 AUNIT GLP0 AUNIT T006 Units of Measurement MSEHI
GLP0 BUKRS GLP0 RCLNT T001 Company Codes MANDT
GLP0 BUKRS GLP0 BUKRS T001 Company Codes BUKRS
GLP0 DOCTY GLP0 RCLNT T889 FI-SL Document Types MANDT
GLP0 DOCTY GLP0 DOCTY T889 FI-SL Document Types DOCTY
GLP0 RBUSA GLP0 RCLNT TGSB Business Areas MANDT
GLP0 RBUSA GLP0 RBUSA TGSB Business Areas GSBER
GLP0 RCLNT GLP0 RCLNT T000 Clients MANDT
GLP0 RLDNR GLP0 RCLNT T881 Ledger Master MANDT
GLP0 RLDNR GLP0 RLDNR T881 Ledger Master RLDNR
GLP0 RTCUR GLP0 RCLNT TCURC Currency Codes MANDT
GLP0 RTCUR GLP0 RTCUR TCURC Currency Codes WAERS
GLP0 RVERS GLP0 RCLNT T894 FI-SL and FI-LC Versions MANDT
GLP0 RVERS GLP0 RLDNR T894 FI-SL and FI-LC Versions RLDNR
GLP0 RVERS GLP0 RVERS T894 FI-SL and FI-LC Versions RVERS