I_PURHUBCOMMODITYFORMULANEW

CDS View
27 Fields 1 CDS Views

Purchase hub commodity formula sCPE

I_PURHUBCOMMODITYFORMULANEW is a CDS View in S/4HANA. Purchase hub commodity formula sCPE. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PurHubCmmdtyFormulaUnion view_entity from COMPOSITE Union Layer purchase hub cmmdty formula

Fields (27)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 1
KEY ConditionSequentialNumberShort ConditionSequentialNumberShort 1
_CommodityCndnMapping _CommodityCndnMapping 1
_CommodityCodeMapping _CommodityCodeMapping 1
_CommodityPricingFormulaText _CommodityPricingFormulaText 1
_OriginSystem _OriginSystem 1
_PrcgCndnFmlaCmmdtyQtyUnit _PrcgCndnFmlaCmmdtyQtyUnit 1
_PrcgCndnFormulaAmountCurrency _PrcgCndnFormulaAmountCurrency 1
_PrcgCndnFormulaRateCurrency _PrcgCndnFormulaRateCurrency 1
_PrcgCndnFormulaRateQtyUnit _PrcgCndnFormulaRateQtyUnit 1
_PurgPrcgCndnType _PurgPrcgCndnType 1
ConditionType ConditionType 1
DocItemCommodityPricingUUID DocItemCommodityPricingUUID 1
OriginSystem OriginSystem 1
PrcgCndnFmlaCmmdtyQuantityUnit PrcgCndnFmlaCmmdtyQuantityUnit 1
PrcgCndnFmlaCombinationRoutine PrcgCndnFmlaCombinationRoutine 1
PrcgCndnFmlaCombnRoutineSubMdl PrcgCndnFmlaCombnRoutineSubMdl 1
PrcgCndnFmlaCommodityQuantity PrcgCndnFmlaCommodityQuantity 1
PrcgCndnFmlaEvaluationDateTime PrcgCndnFmlaEvaluationDateTime 1
PrcgCndnFmlaEvaluationModule PrcgCndnFmlaEvaluationModule 1
PrcgCndnFmlaValdtyStrtDateTime PrcgCndnFmlaValdtyStrtDateTime 1
PrcgCndnFormulaAmountCurrency PrcgCndnFormulaAmountCurrency 1
PrcgCndnFormulaRateCurrency PrcgCndnFormulaRateCurrency 1
PrcgCndnFormulaRateQtyUnit PrcgCndnFormulaRateQtyUnit 1
PrcgCndnFormulaRateQuantity PrcgCndnFormulaRateQuantity 1
PrcgConditionFormulaInputUUID PrcgConditionFormulaInputUUID 1
PricingConditionFormulaKey PricingConditionFormulaKey 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.

-- Purchase hub commodity formula sCPE
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURHUBCOMMODITYFORMULANEW (
    CONDITIONRECORD,
    CONDITIONSEQUENTIALNUMBERSHORT,
    _COMMODITYCNDNMAPPING,
    _COMMODITYCODEMAPPING,
    _COMMODITYPRICINGFORMULATEXT,
    _ORIGINSYSTEM,
    _PRCGCNDNFMLACMMDTYQTYUNIT,
    _PRCGCNDNFORMULAAMOUNTCURRENCY,
    _PRCGCNDNFORMULARATECURRENCY,
    _PRCGCNDNFORMULARATEQTYUNIT,
    _PURGPRCGCNDNTYPE,
    CONDITIONTYPE,
    DOCITEMCOMMODITYPRICINGUUID,
    ORIGINSYSTEM,
    PRCGCNDNFMLACMMDTYQUANTITYUNIT,
    PRCGCNDNFMLACOMBINATIONROUTINE,
    PRCGCNDNFMLACOMBNROUTINESUBMDL,
    PRCGCNDNFMLACOMMODITYQUANTITY,
    PRCGCNDNFMLAEVALUATIONDATETIME,
    PRCGCNDNFMLAEVALUATIONMODULE,
    PRCGCNDNFMLAVALDTYSTRTDATETIME,
    PRCGCNDNFORMULAAMOUNTCURRENCY,
    PRCGCNDNFORMULARATECURRENCY,
    PRCGCNDNFORMULARATEQTYUNIT,
    PRCGCNDNFORMULARATEQUANTITY,
    PRCGCONDITIONFORMULAINPUTUUID,
    PRICINGCONDITIONFORMULAKEY,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONSEQUENTIALNUMBERSHORT)
);

Learn More