CSLA

Transparent Table Application Table
24 Fields 6 CDS Views

Activity master

CSLA is an SAP database table in S/4HANA. Activity master. It contains 24 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
ESH_N_ACTIVITY_TYPE_CSLA view from Activity master
I_CostCenterActivityType view from BASIC Cost Center Activity Type
I_CostCenterActivityTypeDetail view from BASIC Cost Center Activity Type Detail
P_CostCenterActivityType view from BASIC
P_ONRKL view left_outer BASIC
VFCO_CSLA_SHPV view from Activity master

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kokrs KOKRS CO Area
KEY lstar LSTAR Activity Type
KEY datbi DATBI Valid To
datab DATAB Valid From
leinh LEINH Activity Unit
latyp LATYP ATyp category
latypi LATYPI ATyp Cat. Act.
ersda ERFDT Entered On
usnam ERFNM Created By
kstty KSTTY CCtr Categories
auseh AUSEH Output Unit
ausfk AUSFK Output factor
vksta VKSTA Alloc. CElem
lark1 LARK1 Comp.relev. CO
lark2 LARK2 Comp.relev. HR
sprkz SPRKZ Lock indicator
hrkft HRKFT Origin Group
fixvo CO_FIXVO PreDistFixCosts
tarkz TARKZ Price indicator
yrate CO_YRATE Average price
tarkz_i CO_TARKZ_I Act. price ind.
manist CO_MANIST Actual qty set
manplan CO_MANPLAN Plan qty set

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.

-- Activity master
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CSLA (
    MANDT,    -- Client [MANDT]
    KOKRS,    -- CO Area [KOKRS]
    LSTAR,    -- Activity Type [LSTAR]
    DATBI,    -- Valid To [DATBI]
    DATAB,    -- Valid From [DATAB]
    LEINH,    -- Activity Unit [LEINH]
    LATYP,    -- ATyp category [LATYP]
    LATYPI,   -- ATyp Cat. Act. [LATYPI]
    ERSDA,    -- Entered On [ERFDT]
    USNAM,    -- Created By [ERFNM]
    KSTTY,    -- CCtr Categories [KSTTY]
    AUSEH,    -- Output Unit [AUSEH]
    AUSFK,    -- Output factor [AUSFK]
    VKSTA,    -- Alloc. CElem [VKSTA]
    LARK1,    -- Comp.relev. CO [LARK1]
    LARK2,    -- Comp.relev. HR [LARK2]
    SPRKZ,    -- Lock indicator [SPRKZ]
    HRKFT,    -- Origin Group [HRKFT]
    FIXVO,    -- PreDistFixCosts [CO_FIXVO]
    TARKZ,    -- Price indicator [TARKZ]
    YRATE,    -- Average price [CO_YRATE]
    TARKZ_I,  -- Act. price ind. [CO_TARKZ_I]
    MANIST,   -- Actual qty set [CO_MANIST]
    MANPLAN,  -- Plan qty set [CO_MANPLAN]
    PRIMARY KEY (MANDT, KOKRS, LSTAR, DATBI)
);

Learn More