CACS_STMRU

Transparent Table Application Table
24 Fields 1 CDS Views

Individual Settlement Rule

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CommsnContrSettlmtAgreement view_entity from BASIC Settlement Agreement

Fields (24)

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
busi_begin CACS_BUSITIME_B Effective from
busi_end CACS_BUSITIME_E Effective Until
tech_begin CACS_TECHTIME_B Tech. Valid Fr.
tech_end CACS_TECHTIME_E Techn. Valid To
flg_cancel_obj CACSCANCOBJ Invalid object
flg_cancel_vers CACSCANCVERS Invalid Version
chg_tcode CACSCDTC Transaction
chg_usr CACSCHUSR Changed By
tri_meth_typ CACSTRIMETHTYP Method
tri_meth_target CACSTRIMETHTAR Processng Targ.
status_version CACSSTATUSVERS Version status
status_work CACSSTATUSWORK Process status

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]
    BUSI_BEGIN,       -- Effective from [CACS_BUSITIME_B]
    BUSI_END,         -- Effective Until [CACS_BUSITIME_E]
    TECH_BEGIN,       -- Tech. Valid Fr. [CACS_TECHTIME_B]
    TECH_END,         -- Techn. Valid To [CACS_TECHTIME_E]
    FLG_CANCEL_OBJ,   -- Invalid object [CACSCANCOBJ]
    FLG_CANCEL_VERS,  -- Invalid Version [CACSCANCVERS]
    CHG_TCODE,        -- Transaction [CACSCDTC]
    CHG_USR,          -- Changed By [CACSCHUSR]
    TRI_METH_TYP,     -- Method [CACSTRIMETHTYP]
    TRI_METH_TARGET,  -- Processng Targ. [CACSTRIMETHTAR]
    STATUS_VERSION,   -- Version status [CACSSTATUSVERS]
    STATUS_WORK,      -- Process status [CACSSTATUSWORK]
    PRIMARY KEY (MANDT, APPL, CTRTBU_ID, STMAGR_ID, STMRU_ID, VERSION)
);

Learn More