CACS_TGAGR

Transparent Table Application Table

Target Agreements: Individual Rules for Target Agreements

CACS_TGAGR is an SAP database table in S/4HANA. Target Agreements: Individual Rules for Target Agreements. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CommsnContrTargetAgreement view_entity from BASIC Target Agreement

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY appl cacsappl Commission Appl
KEY ctrtbu_id cacs_ctrtbu_id Contract Number
KEY stcagr_id cacs_stcagr_id StdAgrmt No.
KEY tgtagr_id cacs_tgtagr_id Counter Ind.TgtAgmts
KEY version cacsversion Version
agrlock cacs_tgtlockind Lock Indicator

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.

-- Target Agreements: Individual Rules for Target Agreements
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CACS_TGAGR (
    MANDT,      -- Client [mandt]
    APPL,       -- Commission Appl [cacsappl]
    CTRTBU_ID,  -- Contract Number [cacs_ctrtbu_id]
    STCAGR_ID,  -- StdAgrmt No. [cacs_stcagr_id]
    TGTAGR_ID,  -- Counter Ind.TgtAgmts [cacs_tgtagr_id]
    VERSION,    -- Version [cacsversion]
    AGRLOCK,    -- Lock Indicator [cacs_tgtlockind]
    PRIMARY KEY (MANDT, APPL, CTRTBU_ID, STCAGR_ID, TGTAGR_ID, VERSION)
);