I_SLSCONTRITEMPRICINGELEMENT

CDS View

Sales Contract Item Pricing Element

I_SLSCONTRITEMPRICINGELEMENT is a CDS View in S/4HANA. Sales Contract Item Pricing Element. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SlsContrItemPricingElementTP view_entity from TRANSACTIONAL Pricing Elemnt for Sls Contr Item - TP

Fields (32)

KeyField CDS FieldsUsed in Views
KEY PricingProcedureCounter PricingProcedureCounter 1
KEY PricingProcedureStep PricingProcedureStep 1
KEY SalesContract SalesContract 1
KEY SalesContractItem SalesContractItem 1
_ConditionApplication _ConditionApplication 1
_ConditionCalculationType _ConditionCalculationType 1
_ConditionClass _ConditionClass 1
_ConditionCurrency _ConditionCurrency 1
_ConditionInactiveReason _ConditionInactiveReason 1
_ConditionOrigin _ConditionOrigin 1
_ConditionQuantityUnit _ConditionQuantityUnit 1
_Currency _TransactionCurrency 1
_PricingConditionType _PricingConditionType 1
ConditionAmount ConditionAmount 1
ConditionApplication ConditionApplication 1
ConditionBaseAmount ConditionBaseAmount 1
ConditionBaseQuantity ConditionBaseQuantity 1
ConditionCalculationType ConditionCalculationType 1
ConditionClass ConditionClass 1
ConditionCurrency ConditionCurrency 1
ConditionInactiveReason ConditionInactiveReason 1
ConditionIsForStatistics ConditionIsForStatistics 1
ConditionIsManuallyChanged ConditionIsManuallyChanged 1
ConditionOrigin ConditionOrigin 1
ConditionQuantity ConditionQuantity 1
ConditionQuantityUnit ConditionQuantityUnit 1
ConditionRateAmount ConditionRateAmount 1
ConditionRateRatio ConditionRateRatio 1
ConditionRateRatioUnit ConditionRateRatioUnit 1
ConditionType ConditionType 1
PriceConditionDeterminationDte PriceConditionDeterminationDte 1
TransactionCurrency TransactionCurrency 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.

-- Sales Contract Item Pricing Element
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SLSCONTRITEMPRICINGELEMENT (
    PRICINGPROCEDURECOUNTER,
    PRICINGPROCEDURESTEP,
    SALESCONTRACT,
    SALESCONTRACTITEM,
    _CONDITIONAPPLICATION,
    _CONDITIONCALCULATIONTYPE,
    _CONDITIONCLASS,
    _CONDITIONCURRENCY,
    _CONDITIONINACTIVEREASON,
    _CONDITIONORIGIN,
    _CONDITIONQUANTITYUNIT,
    _CURRENCY,
    _PRICINGCONDITIONTYPE,
    CONDITIONAMOUNT,
    CONDITIONAPPLICATION,
    CONDITIONBASEAMOUNT,
    CONDITIONBASEQUANTITY,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCLASS,
    CONDITIONCURRENCY,
    CONDITIONINACTIVEREASON,
    CONDITIONISFORSTATISTICS,
    CONDITIONISMANUALLYCHANGED,
    CONDITIONORIGIN,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATEAMOUNT,
    CONDITIONRATERATIO,
    CONDITIONRATERATIOUNIT,
    CONDITIONTYPE,
    PRICECONDITIONDETERMINATIONDTE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (PRICINGPROCEDURECOUNTER, PRICINGPROCEDURESTEP, SALESCONTRACT, SALESCONTRACTITEM)
);