I_COMONAVG_AGG

CDS View
14 Fields 1 CDS Views

Weighted relevance calculation

I_COMONAVG_AGG is a CDS View in S/4HANA. Weighted relevance calculation. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ContractRelevance view from COMPOSITE Purchase Contract Relevance Calculations

Fields (14)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PurchaseContract 1
AmountFulfillmentPercent AmountFulfillmentPercent 1
ContractConsumptionInPct ContractConsumptionInPct 1
CreatedByUser CreatedByUser 1
DocumentCurrency DocumentCurrency 1
OverdueToEndPercent OverdueToEndPercent 1
PurchaseContractClassification PurchaseContractClassification 1
PurchaseContractConsumedAmount PurchaseContractConsumedAmount,PurContrConsumedVal 1
PurchaseContractTargetAmount PurchaseContractTargetAmount 1
PurchaseContractType PurchaseContractType 1
QuantityFulfillmentPercent QuantityFulfillmentPercent 1
TimeVarianceInDays TimeVarianceInDays 1
ValidityEndDate ValidityEndDate 1
WeightedRelevance WeightedRelevance 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.

-- Weighted relevance calculation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COMONAVG_AGG (
    PURCHASECONTRACT,
    AMOUNTFULFILLMENTPERCENT,
    CONTRACTCONSUMPTIONINPCT,
    CREATEDBYUSER,
    DOCUMENTCURRENCY,
    OVERDUETOENDPERCENT,
    PURCHASECONTRACTCLASSIFICATION,
    PURCHASECONTRACTCONSUMEDAMOUNT,
    PURCHASECONTRACTTARGETAMOUNT,
    PURCHASECONTRACTTYPE,
    QUANTITYFULFILLMENTPERCENT,
    TIMEVARIANCEINDAYS,
    VALIDITYENDDATE,
    WEIGHTEDRELEVANCE,
    PRIMARY KEY (PURCHASECONTRACT)
);

Learn More