I_PURGPRCGCNDNRECORDSCALE

CDS View

Pricing Scale in Purchasing

I_PURGPRCGCNDNRECORDSCALE is a CDS View in S/4HANA. Pricing Scale in Purchasing. It contains 15 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
A_PurgPrcgCndnRecordScale view from BASIC Pricing Scales
A_PurInfoRecdPrcgCndnScale view from BASIC Pricing Condition Scales
I_CntrlPurContrHdrCndnScales view from COMPOSITE CCTR Hdr Condition Scales Basic Data
I_CntrlPurContrItmCndnScales view from COMPOSITE CCTR Item Condition Scales Basic View
I_PurContrHdrCndnScale view from COMPOSITE Header Condition Scales Basic Data
I_PurContrItmCndnScales view from COMPOSITE Purchase contract item condition scales
P_PurgInfoRecdCndScalesMassUpd view from COMPOSITE
R_SrcgProjQtnItmCndnScale view from COMPOSITE Condition Scale for Itm in Srcg Proj Qtn

Fields (15)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 5
KEY ConditionScaleLine ConditionScaleLine 5
KEY ConditionSequentialNumber ConditionSequentialNumber,ConditionSequentialNumberShort 5
_PurgPrcgCndnRecdSuplmnt _PurgPrcgCndnRecdSuplmnt 1
_PurgPrcgConditionRecord _PurgPrcgConditionRecord 1
ConditionCurrency ConditionCurrency 5
ConditionRateAmount ConditionRateAmount 5
ConditionRateRatio ConditionRateRatio 5
ConditionRateRatioUnit ConditionRateRatioUnit 5
ConditionRateValue ConditionRateValue 5
ConditionRateValueUnit ConditionRateValueUnit 5
ConditionScaleAmount ConditionScaleAmount 5
ConditionScaleAmountCurrency ConditionScaleAmountCurrency 5
ConditionScaleQuantity ConditionScaleQuantity 5
ConditionScaleQuantityUnit ConditionScaleQuantityUnit 5

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.

-- Pricing Scale in Purchasing
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURGPRCGCNDNRECORDSCALE (
    CONDITIONRECORD,
    CONDITIONSCALELINE,
    CONDITIONSEQUENTIALNUMBER,
    _PURGPRCGCNDNRECDSUPLMNT,
    _PURGPRCGCONDITIONRECORD,
    CONDITIONCURRENCY,
    CONDITIONRATEAMOUNT,
    CONDITIONRATERATIO,
    CONDITIONRATERATIOUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRATEVALUEUNIT,
    CONDITIONSCALEAMOUNT,
    CONDITIONSCALEAMOUNTCURRENCY,
    CONDITIONSCALEQUANTITY,
    CONDITIONSCALEQUANTITYUNIT,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONSCALELINE, CONDITIONSEQUENTIALNUMBER)
);