P_ACMCONTRACTOPTION

CDS View

Basic View on Contract Optionality

P_ACMCONTRACTOPTION is a CDS View in S/4HANA. Basic View on Contract Optionality. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ACMContractOption view from BASIC Basic View on Contract Optionality
I_ACMTrdgContrOptntyDets view from BASIC Trading Contract Item Optionality
I_ACMTrdgContrOptntyInfo view from BASIC Trading Contract Item Optionality

Fields (14)

KeyField CDS FieldsUsed in Views
KEY OPNLTY_ID ACMContractOptionsID 2
KEY SEQ_NO ACMContractOptionsSequenceNmbr 2
KEY TKONN TradingContractNumber 2
KEY TPOSN TradingContractItem 2
KEY VALUE_TYP ACMContractOptionsValueType 2
CURRENCY ACMContractOptionsPremDiscCrcy 2
OPNLTY_TYP ACMTradingContractOptionsType 2
OPTN_VAL ACMContractOptionsValue 2
PER_UOM ACMContractOptionsPremDiscQty 2
PREM_DISC ACMContractOptionsPremDiscAmt 2
TYPE ACMContractOptionsPremDiscType 2
UOM ACMContractOptionsUnit 2
UOM_PD ACMContractOptionsPremDiscUnit 2
UOM_TIME_UNIT ACMContractOptionsTimeUnit 2

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.

-- Basic View on Contract Optionality
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ACMCONTRACTOPTION (
    OPNLTY_ID,
    SEQ_NO,
    TKONN,
    TPOSN,
    VALUE_TYP,
    CURRENCY,
    OPNLTY_TYP,
    OPTN_VAL,
    PER_UOM,
    PREM_DISC,
    TYPE,
    UOM,
    UOM_PD,
    UOM_TIME_UNIT,
    PRIMARY KEY (OPNLTY_ID, SEQ_NO, TKONN, TPOSN, VALUE_TYP)
);