_MATLINVTRYPRICE

14 Fields

_MATLINVTRYPRICE is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 1
CompanyCodeName CompanyCodeName 1
Currency Currency 1
InventoryValuationType InventoryValuationType 1
Ledger Ledger 1
LedgerName LedgerName 1
LegalCurrencyRole LegalCurrencyRole 1
LegalCurrencyRoleName LegalCurrencyRoleName 1
Material Material 1
MaterialName MaterialName 1
MaterialStatusText MaterialStatusText 1
Plant Plant 1
PlantName PlantName 1
ValuationQuantityUnit ValuationQuantityUnit 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 _MATLINVTRYPRICE (
    COMPANYCODE,
    COMPANYCODENAME,
    CURRENCY,
    INVENTORYVALUATIONTYPE,
    LEDGER,
    LEDGERNAME,
    LEGALCURRENCYROLE,
    LEGALCURRENCYROLENAME,
    MATERIAL,
    MATERIALNAME,
    MATERIALSTATUSTEXT,
    PLANT,
    PLANTNAME,
    VALUATIONQUANTITYUNIT
);

Learn More