INVPR

17 Fields

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

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CostEstimate CostEstimate 2
KEY CurrencyRole CurrencyRole 2
KEY Ledger Ledger 2
AccountingValuationView AccountingValuationView,ControllingValuationType 1
BaseUnit ValuationQuantityUnit 2
CompanyCode CompanyCode 1
Currency Currency 2
InventoryPrice InventoryPrice 1
InventoryValuationType InventoryValuationType 1
LedgerName LedgerName 2
LegalCurrencyRole LegalCurrencyRole 2
LegalCurrencyRoleName LegalCurrencyRoleName 2
Material Material 2
MaterialPrice InventoryPrice 1
MaterialPriceControl MaterialPriceControl 1
MaterialPriceUnitQty MaterialPriceUnitQty 2
ValuationArea Plant,ValuationArea 2

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 INVPR (
    COSTESTIMATE,
    CURRENCYROLE,
    LEDGER,
    ACCOUNTINGVALUATIONVIEW,
    BASEUNIT,
    COMPANYCODE,
    CURRENCY,
    INVENTORYPRICE,
    INVENTORYVALUATIONTYPE,
    LEDGERNAME,
    LEGALCURRENCYROLE,
    LEGALCURRENCYROLENAME,
    MATERIAL,
    MATERIALPRICE,
    MATERIALPRICECONTROL,
    MATERIALPRICEUNITQTY,
    VALUATIONAREA,
    PRIMARY KEY (COSTESTIMATE, CURRENCYROLE, LEDGER)
);

Learn More