INVOICEPRICEVARIANCE

17 Fields

INVOICEPRICEVARIANCE is an SAP database table in S/4HANA. It contains 17 fields.

Fields (17)

KeyField CDS FieldsUsed in Views
KEY MaterialDocument Invoice,MaterialDocument 2
KEY MaterialDocumentItem MaterialDocumentItem 2
KEY MaterialDocumentYear MaterialDocumentYear 2
KEY PurchaseOrder PurchaseOrder 2
KEY PurchaseOrderItem PurchaseOrderItem 2
CompanyCode CompanyCode 1
Currency Currency 2
DisplayCurrency DisplayCurrency 1
Material Material 1
MaterialGroup MaterialGroup 1
OrderPriceUnit OrderPriceUnit 2
Plant Plant 1
PostingDate InvoiceDate,PostingDate 2
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 2
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
Supplier Supplier 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE INVOICEPRICEVARIANCE (
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    COMPANYCODE,
    CURRENCY,
    DISPLAYCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    ORDERPRICEUNIT,
    PLANT,
    POSTINGDATE,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    PRIMARY KEY (MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR, PURCHASEORDER, PURCHASEORDERITEM)
);

Learn More