_COMMSNRTNTNAGREEMENT

6 Fields

_COMMSNRTNTNAGREEMENT is an SAP database table in S/4HANA. It contains 6 fields.

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CommsnAgrmtEffctvFrmDteTme CommsnAgrmtEffctvFrmDteTme 1
CommissionVersionIsInvalid CommissionVersionIsInvalid 1
CommsnAgrmtEffctvToDteTme CommsnAgrmtEffctvToDteTme 1
CommsnAgrmtMaxRetentionAmount CommsnAgrmtMaxRetentionAmount 1
CommsnAgrmtRetentionPercent CommsnAgrmtRetentionPercent 1
CommsnContrRtntnThldAmount CommsnContrRtntnThldAmount 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _COMMSNRTNTNAGREEMENT (
    COMMSNAGRMTEFFCTVFRMDTETME,
    COMMISSIONVERSIONISINVALID,
    COMMSNAGRMTEFFCTVTODTETME,
    COMMSNAGRMTMAXRETENTIONAMOUNT,
    COMMSNAGRMTRETENTIONPERCENT,
    COMMSNCONTRRTNTNTHLDAMOUNT,
    PRIMARY KEY (COMMSNAGRMTEFFCTVFRMDTETME)
);

Learn More