I_SUPLREVALVARIANCESCOREINFO

CDS View
18 Fields 6 CDS Views

Purchasing Document Supplier Scores Enhanced

I_SUPLREVALVARIANCESCOREINFO is a CDS View in S/4HANA. Purchasing Document Supplier Scores Enhanced. It contains 18 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_PriceVarianceOpsSE view from CONSUMPTION Price Variance Stack for Operational SE
P_PriceVarianceOpsSE view union_all CONSUMPTION Price Variance Stack for Operational SE
P_PriceVarianceScorePreCalcd view from CONSUMPTION Scheduled Purchase Orders
P_PriceVarianceScorePreCalcd view union_all CONSUMPTION Scheduled Purchase Orders
P_PurgDocQtyScoreDocType view from CONSUMPTION PD Quantity Variance Score Union for Document Types
P_PurgDocQtyScoreDocType view union_all CONSUMPTION PD Quantity Variance Score Union for Document Types

Fields (18)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocument PurchaseOrder,PurchasingDocument 2
KEY PurchasingDocumentItem PurchaseOrderItem,PurchasingDocumentItem 2
AnalyticalReportingCurrency AnalyticalReportingCurrency,DisplayCurrency 2
AnalyticalReportingCurrency2 AnalyticalReportingCurrency2 2
DocumentCurrency Currency,DocumentCurrency 3
GoodsReceiptQuantity GoodsReceiptQuantity 1
OrderedQuantity OrderedQuantity 1
OrderPriceUnit OrderPriceUnit 1
OrderQuantityUnit OrderQuantityUnit,PurchaseOrderQuantityUnit 2
PurDocItmFinalGRPostingDate PurDocItmFinalGRPostingDate 1
PurDocItmFirstGRPostingDate PurDocItmFirstGRPostingDate 1
QtyInPurchaseOrderPriceUnit deliveredquantity 1
QtyVarcAmountInDocCrcy QtyVarcAmountInDocCrcy 1
QtyVarcAmountInReportingCrcy QtyVarcAmountInReportingCrcy 1
QtyVarcAmountInReportingCrcy2 QtyVarcAmountInReportingCrcy2 1
QuantityVarianceInOrdUnit QuantityVarianceInOrdUnit 1
QuantityVarianceInPct QuantityVarianceInPct 1
QuantityVarianceScore QuantityVarianceScore 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.

-- Purchasing Document Supplier Scores Enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPLREVALVARIANCESCOREINFO (
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    ANALYTICALREPORTINGCURRENCY,
    ANALYTICALREPORTINGCURRENCY2,
    DOCUMENTCURRENCY,
    GOODSRECEIPTQUANTITY,
    ORDEREDQUANTITY,
    ORDERPRICEUNIT,
    ORDERQUANTITYUNIT,
    PURDOCITMFINALGRPOSTINGDATE,
    PURDOCITMFIRSTGRPOSTINGDATE,
    QTYINPURCHASEORDERPRICEUNIT,
    QTYVARCAMOUNTINDOCCRCY,
    QTYVARCAMOUNTINREPORTINGCRCY,
    QTYVARCAMOUNTINREPORTINGCRCY2,
    QUANTITYVARIANCEINORDUNIT,
    QUANTITYVARIANCEINPCT,
    QUANTITYVARIANCESCORE,
    PRIMARY KEY (PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More