_MATERIALVALUATION

24 Fields

_MATERIALVALUATION is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
KEY CostEstimate CostEstimate 1
CompanyCode CompanyCode 1
Currency Currency 1
InventoryAmtInCCCrcy InventoryAmtInCCCrcy 1
InventoryValuationCategory InventoryValuationCategory 3
InventoryValuationType InventoryValuationType 1
LedgerValuationCurrencyRole LedgerValuationCurrencyRole 1
Material Material 1
MaterialConsumptionQty MaterialConsumptionQty 1
MaterialConsumptionValue MaterialConsumptionValue 1
MaterialName MaterialName 1
MaterialProcurementType MaterialProcurementType 1
MaterialType MaterialType 1
MaterialTypeName MaterialTypeName 1
MaterialValuationClass MaterialValuationClass 5
Plant Plant 1
ProfitCenter ProfitCenter 1
ProfitCenterMD ProfitCenterMD 1
SalesDocument SalesDocument 1
Supplier Supplier 1
ValuationArea ValuationArea 1
ValuationClass ValuationClass 1
ValuationQuantity ValuationQuantity 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 _MATERIALVALUATION (
    COSTESTIMATE,
    COMPANYCODE,
    CURRENCY,
    INVENTORYAMTINCCCRCY,
    INVENTORYVALUATIONCATEGORY,
    INVENTORYVALUATIONTYPE,
    LEDGERVALUATIONCURRENCYROLE,
    MATERIAL,
    MATERIALCONSUMPTIONQTY,
    MATERIALCONSUMPTIONVALUE,
    MATERIALNAME,
    MATERIALPROCUREMENTTYPE,
    MATERIALTYPE,
    MATERIALTYPENAME,
    MATERIALVALUATIONCLASS,
    PLANT,
    PROFITCENTER,
    PROFITCENTERMD,
    SALESDOCUMENT,
    SUPPLIER,
    VALUATIONAREA,
    VALUATIONCLASS,
    VALUATIONQUANTITY,
    VALUATIONQUANTITYUNIT,
    PRIMARY KEY (COSTESTIMATE)
);

Learn More