I_PRICINGCONDITIONRECORD

CDS View
42 Fields 6 CDS Views

Condition Record for Pricing

I_PRICINGCONDITIONRECORD is a CDS View in S/4HANA. Condition Record for Pricing. It contains 42 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_PurgInfoRecdCndnMassUpdt view inner CONSUMPTION Mass Changes to PIR Pricing Conditions
I_CntrlPurContrHdrCndnAmount view from COMPOSITE Central Purchase Contract Hdr Condition
I_CntrlPurContrItmCndnAmount view from COMPOSITE Central Purchase Contract Item Condition
I_PurContrHdrCndnAmount view from COMPOSITE Contract Header Condition amount
I_PurContrItemCndnAmount view from COMPOSITE Purchase Ctr Item Condition Amount
I_SchedgAgrmtItmCndnAmount view from COMPOSITE Scheduling Agrmt Item Condition Amount

Fields (42)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 5
KEY ConditionSequentialNumber ConditionSequentialNumber,ConditionSequentialNumberShort 6
AdditionalValueDays AdditionalValueDays 5
BaseUnit BaseUnit 6
CndnMaxNumberOfSalesOrders CndnMaxNumberOfSalesOrders 5
ConditionAlternativeCurrency ConditionAlternativeCurrency 5
ConditionApplication ConditionApplication 2
ConditionCalculationType ConditionCalculationType,ConditionCalculationTypeShort 6
ConditionChangeReason ConditionChangeReason 4
ConditionCurrency ConditionCurrency 5
ConditionExclusion ConditionExclusion 5
ConditionIsDeleted ConditionIsDeleted 5
ConditionLowerLimit ConditionLowerLimit 5
ConditionLowerLimitAmount ConditionLowerLimitAmount 2
ConditionLowerLimitRatio ConditionLowerLimitRatio 2
ConditionQuantity ConditionQuantity 6
ConditionQuantityUnit ConditionQuantityUnit 6
ConditionRateAmount ConditionRateAmount 4
ConditionRateRatio ConditionRateRatio 4
ConditionRateRatioUnit ConditionRateRatioUnit 4
ConditionRateValue ConditionRateValue 6
ConditionRateValueUnit ConditionRateValueUnit 6
ConditionReleaseStatus ConditionReleaseStatus 5
ConditionScaleAmount ConditionScaleAmount 4
ConditionScaleAmountCurrency ConditionScaleAmountCurrency 4
ConditionScaleQuantity ConditionScaleQuantity 4
ConditionScaleQuantityUnit ConditionScaleQuantityUnit 4
ConditionTextID ConditionTextID 5
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr 6
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr 6
ConditionType ConditionType 6
ConditionUpperLimit ConditionUpperLimit 5
ConditionUpperLimitAmount ConditionUpperLimitAmount 2
ConditionUpperLimitRatio ConditionUpperLimitRatio 2
FixedValueDate FixedValueDate 5
MaximumConditionAmount MaximumConditionAmount 5
MaximumConditionBasisValue MaximumConditionBasisValue 5
MinimumConditionBasisValue MinimumConditionBasisValue 5
PaymentTerms PaymentTerms 5
PricingScaleBasis PricingScaleBasis 4
PricingScaleLine PricingScaleLine 4
PricingScaleType PricingScaleType 4

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.

-- Condition Record for Pricing
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRICINGCONDITIONRECORD (
    CONDITIONRECORD,
    CONDITIONSEQUENTIALNUMBER,
    ADDITIONALVALUEDAYS,
    BASEUNIT,
    CNDNMAXNUMBEROFSALESORDERS,
    CONDITIONALTERNATIVECURRENCY,
    CONDITIONAPPLICATION,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCHANGEREASON,
    CONDITIONCURRENCY,
    CONDITIONEXCLUSION,
    CONDITIONISDELETED,
    CONDITIONLOWERLIMIT,
    CONDITIONLOWERLIMITAMOUNT,
    CONDITIONLOWERLIMITRATIO,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATEAMOUNT,
    CONDITIONRATERATIO,
    CONDITIONRATERATIOUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRATEVALUEUNIT,
    CONDITIONRELEASESTATUS,
    CONDITIONSCALEAMOUNT,
    CONDITIONSCALEAMOUNTCURRENCY,
    CONDITIONSCALEQUANTITY,
    CONDITIONSCALEQUANTITYUNIT,
    CONDITIONTEXTID,
    CONDITIONTOBASEQTYDNMNTR,
    CONDITIONTOBASEQTYNMRTR,
    CONDITIONTYPE,
    CONDITIONUPPERLIMIT,
    CONDITIONUPPERLIMITAMOUNT,
    CONDITIONUPPERLIMITRATIO,
    FIXEDVALUEDATE,
    MAXIMUMCONDITIONAMOUNT,
    MAXIMUMCONDITIONBASISVALUE,
    MINIMUMCONDITIONBASISVALUE,
    PAYMENTTERMS,
    PRICINGSCALEBASIS,
    PRICINGSCALELINE,
    PRICINGSCALETYPE,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONSEQUENTIALNUMBER)
);

Learn More