Replaced in S/4HANA
This table is replaced by ACDOCA

GLT0 totals table eliminated. All totals computed on-the-fly from ACDOCA.

View all S/4HANA migration mappings →

GLT0

63 Fields 1 CDS Views

Generated Table for View

GLT0 is an SAP database table in S/4HANA. Generated Table for View. It contains 63 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ent12006_view view from General Ledger - G/L Account - Transaction Figure

Fields (63)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt MANDT Client
KEY rldnr RLDNR Ledger
KEY rrcty RRCTY Record Type
KEY rvers RVERS Version
KEY bukrs BUKRS Company Code
KEY ryear GJAHR_POS G/L Fiscal Year
KEY racct RACCT Account Number
KEY rbusa GSBER Business Area
KEY rtcur FINS_CURRT Bal. Transac. Crcy
KEY drcrk SHKZG Debit/Credit
KEY rpmax RPMAX Period
tslvt TSLVT Transactn curr.
tsl01 TSLXX Transactn curr.
tsl02 TSLXX Transactn curr.
tsl03 TSLXX Transactn curr.
tsl04 TSLXX Transactn curr.
tsl05 TSLXX Transactn curr.
tsl06 TSLXX Transactn curr.
tsl07 TSLXX Transactn curr.
tsl08 TSLXX Transactn curr.
tsl09 TSLXX Transactn curr.
tsl10 TSLXX Transactn curr.
tsl11 TSLXX Transactn curr.
tsl12 TSLXX Transactn curr.
tsl13 TSLXX Transactn curr.
tsl14 TSLXX Transactn curr.
tsl15 TSLXX Transactn curr.
tsl16 TSLXX Transactn curr.
hslvt HSLVT Local Currency
hsl01 HSLXX Total transactions in the period in local currency (curr 2)
hsl02 HSLXX Total transactions in the period in local currency (curr 2)
hsl03 HSLXX Total transactions in the period in local currency (curr 2)
hsl04 HSLXX Total transactions in the period in local currency (curr 2)
hsl05 HSLXX Total transactions in the period in local currency (curr 2)
hsl06 HSLXX Total transactions in the period in local currency (curr 2)
hsl07 HSLXX Total transactions in the period in local currency (curr 2)
hsl08 HSLXX Total transactions in the period in local currency (curr 2)
hsl09 HSLXX Total transactions in the period in local currency (curr 2)
hsl10 HSLXX Total transactions in the period in local currency (curr 2)
hsl11 HSLXX Total transactions in the period in local currency (curr 2)
hsl12 HSLXX Total transactions in the period in local currency (curr 2)
hsl13 HSLXX Total transactions in the period in local currency (curr 2)
hsl14 HSLXX Total transactions in the period in local currency (curr 2)
hsl15 HSLXX Total transactions in the period in local currency (curr 2)
hsl16 HSLXX Total transactions in the period in local currency (curr 2)
cspred CSPRED Distr. key currency
kslvt KSLVT Group currency
ksl01 KSLXX Amount
ksl02 KSLXX Amount
ksl03 KSLXX Amount
ksl04 KSLXX Amount
ksl05 KSLXX Amount
ksl06 KSLXX Amount
ksl07 KSLXX Amount
ksl08 KSLXX Amount
ksl09 KSLXX Amount
ksl10 KSLXX Amount
ksl11 KSLXX Amount
ksl12 KSLXX Amount
ksl13 KSLXX Amount
ksl14 KSLXX Amount
ksl15 KSLXX Amount
ksl16 KSLXX Amount

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GLT0 (
    RCLNT,   -- Client [MANDT]
    RLDNR,   -- Ledger [RLDNR]
    RRCTY,   -- Record Type [RRCTY]
    RVERS,   -- Version [RVERS]
    BUKRS,   -- Company Code [BUKRS]
    RYEAR,   -- G/L Fiscal Year [GJAHR_POS]
    RACCT,   -- Account Number [RACCT]
    RBUSA,   -- Business Area [GSBER]
    RTCUR,   -- Bal. Transac. Crcy [FINS_CURRT]
    DRCRK,   -- Debit/Credit [SHKZG]
    RPMAX,   -- Period [RPMAX]
    TSLVT,   -- Transactn curr. [TSLVT]
    TSL01,   -- Transactn curr. [TSLXX]
    TSL02,   -- Transactn curr. [TSLXX]
    TSL03,   -- Transactn curr. [TSLXX]
    TSL04,   -- Transactn curr. [TSLXX]
    TSL05,   -- Transactn curr. [TSLXX]
    TSL06,   -- Transactn curr. [TSLXX]
    TSL07,   -- Transactn curr. [TSLXX]
    TSL08,   -- Transactn curr. [TSLXX]
    TSL09,   -- Transactn curr. [TSLXX]
    TSL10,   -- Transactn curr. [TSLXX]
    TSL11,   -- Transactn curr. [TSLXX]
    TSL12,   -- Transactn curr. [TSLXX]
    TSL13,   -- Transactn curr. [TSLXX]
    TSL14,   -- Transactn curr. [TSLXX]
    TSL15,   -- Transactn curr. [TSLXX]
    TSL16,   -- Transactn curr. [TSLXX]
    HSLVT,   -- Local Currency [HSLVT]
    HSL01,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL02,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL03,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL04,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL05,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL06,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL07,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL08,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL09,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL10,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL11,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL12,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL13,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL14,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL15,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    HSL16,   -- Total transactions in the period in local currency (curr 2) [HSLXX]
    CSPRED,  -- Distr. key currency [CSPRED]
    KSLVT,   -- Group currency [KSLVT]
    KSL01,   -- Amount [KSLXX]
    KSL02,   -- Amount [KSLXX]
    KSL03,   -- Amount [KSLXX]
    KSL04,   -- Amount [KSLXX]
    KSL05,   -- Amount [KSLXX]
    KSL06,   -- Amount [KSLXX]
    KSL07,   -- Amount [KSLXX]
    KSL08,   -- Amount [KSLXX]
    KSL09,   -- Amount [KSLXX]
    KSL10,   -- Amount [KSLXX]
    KSL11,   -- Amount [KSLXX]
    KSL12,   -- Amount [KSLXX]
    KSL13,   -- Amount [KSLXX]
    KSL14,   -- Amount [KSLXX]
    KSL15,   -- Amount [KSLXX]
    KSL16,   -- Amount [KSLXX]
    PRIMARY KEY (RCLNT, RLDNR, RRCTY, RVERS, BUKRS, RYEAR, RACCT, RBUSA, RTCUR, DRCRK, RPMAX)
);

Learn More