CACS_STMRU

Transparent Table Application Table
12 Fields 1 CDS Views

Individual Settlement Rule

CACS_STMRU is an SAP database table in S/4HANA. Individual Settlement Rule. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CommsnContrSettlmtAgreement view_entity from BASIC Settlement agreement

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY appl cacsappl Commission Appl
KEY ctrtbu_id cacs_ctrtbu_id Contract Number
KEY stmagr_id cacs_stmagr_id IndivSettlAgrmt
KEY stmru_id cacs_stmru_id IndivSettlAgrmt
KEY version cacsversion Version
payee_hr pernr_d Personnel No.
payee_fi lifnr Supplier
payee_iscd cacspayeeiscd Payee
payee_other cacs_payee_other Recipient
payee_fica cacspayeefica Payee
stmtype_id cacs_stmtype_id Settlement Type

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.

-- Individual Settlement Rule
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CACS_STMRU (
    MANDT,        -- Client [mandt]
    APPL,         -- Commission Appl [cacsappl]
    CTRTBU_ID,    -- Contract Number [cacs_ctrtbu_id]
    STMAGR_ID,    -- IndivSettlAgrmt [cacs_stmagr_id]
    STMRU_ID,     -- IndivSettlAgrmt [cacs_stmru_id]
    VERSION,      -- Version [cacsversion]
    PAYEE_HR,     -- Personnel No. [pernr_d]
    PAYEE_FI,     -- Supplier [lifnr]
    PAYEE_ISCD,   -- Payee [cacspayeeiscd]
    PAYEE_OTHER,  -- Recipient [cacs_payee_other]
    PAYEE_FICA,   -- Payee [cacspayeefica]
    STMTYPE_ID,   -- Settlement Type [cacs_stmtype_id]
    PRIMARY KEY (MANDT, APPL, CTRTBU_ID, STMAGR_ID, STMRU_ID, VERSION)
);

Learn More