PRICEVARIANCE

PRICEVARIANCE is an SAP database table in S/4HANA. It contains 6 fields.

Fields (6)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 4
KEY PurchaseOrderItem PurchaseOrderItem 4
MaterialGroup MaterialGroup 3
PurchasingCategory PurchasingCategory 6
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingOrganization PurchasingOrganization 7

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRICEVARIANCE (
    PURCHASEORDER,
    PURCHASEORDERITEM,
    MATERIALGROUP,
    PURCHASINGCATEGORY,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGORGANIZATION,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM)
);