P_MATVAL_MANAGE_MD2

CDS View
106 Fields 4 CDS Views

P_MATVAL_MANAGE_MD2 is a CDS View in S/4HANA. It contains 106 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CurrentMaterialValuations view from COMPOSITE Current Material Valuations
I_CurrentMaterialValuations view union_all COMPOSITE Current Material Valuations
I_MaterialValuationsByPeriods view inner COMPOSITE Material Valuations by Currtp/Period
P_MaterialValuation view union_all COMPOSITE

Fields (106)

KeyField CDS FieldsUsed in Views
KEY CostEstimate CostEstimate 1
KEY CurrencyRole CurrencyRole 1
KEY Ledger Ledger 2
KEY ValuationArea ValuationArea 3
AlternativeBillOfMaterial AlternativeBillOfMaterial 1
AssemblyScrapPercent AssemblyScrapPercent 1
BaseUnit BaseUnit 2
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
BillOfOperationsType BillOfOperationsType 1
CommercialPrice1InCoCodeCrcy CommercialPrice1InCoCodeCrcy 1
CommercialPrice2InCoCodeCrcy CommercialPrice2InCoCodeCrcy 1
CommercialPrice3InCoCodeCrcy CommercialPrice3InCoCodeCrcy 1
CompanyCode CompanyCode 3
CompanyCodeCurrency CompanyCodeCurrency 1
ComponentScrapInPercent ComponentScrapInPercent 1
CostingLotSize CostingLotSize 1
CostingMatProcurementProfile CostingMatProcurementProfile 1
CostingOverheadGroup CostingOverheadGroup 1
CostingProductionVersion CostingProductionVersion 1
CostOriginGroup CostOriginGroup 1
CurCostEstValuationVariant CurCostEstValuationVariant 1
CurPlanProjSlsOrdValnStrategy CurPlanProjSlsOrdValnStrategy 1
Currency Currency 3
CurrentCostEstCostingVersion CurrentCostEstCostingVersion 1
CurrentCostEstFiscalPeriod CurrentCostEstFiscalPeriod 1
CurrentCostEstFiscalYear CurrentCostEstFiscalYear 1
CurrentFiscalPeriod CurrentFiscalPeriod 1
CurrentFiscalYear CurrentFiscalYear 1
CurrentPlanPriceInCoCodeCrcy CurrentPlanPriceInCoCodeCrcy 1
DateOfLastPostedCntUnRstrcdStk DateOfLastPostedCntUnRstrcdStk 1
DevaluationYearCount DevaluationYearCount 1
FutrCostEstValuationVariant FutrCostEstValuationVariant 1
FutrPlanProjSlsOrdValnStrategy FutrPlanProjSlsOrdValnStrategy 1
FutureCostEstCostingVersion FutureCostEstCostingVersion 1
FutureCostEstFiscalYear FutureCostEstFiscalYear 1
FutureCostEstimateFiscalPeriod FutureCostEstimateFiscalPeriod 1
FuturePlndPrice1ValdtyDate FuturePlndPrice1ValdtyDate 1
FuturePlndPrice2ValdtyDate FuturePlndPrice2ValdtyDate 1
FuturePlndPrice3ValdtyDate FuturePlndPrice3ValdtyDate 1
FxdPortnOfFutPlPrcInCoCodeCrcy FxdPortnOfFutPlPrcInCoCodeCrcy 1
FxdPortOfPrevPlPrcInCoCodeCrcy FxdPortOfPrevPlPrcInCoCodeCrcy 1
HasProductionVersion HasProductionVersion 1
HasStdCostEstForCurrentPeriod HasStdCostEstForCurrentPeriod 1
HasStdCostEstForFuturePeriod HasStdCostEstForFuturePeriod 1
HasStdCostEstForPreviousPeriod HasStdCostEstForPreviousPeriod 1
InventoryForCycleCountInd InventoryForCycleCountInd 1
InventoryValuationCategory InventoryValuationCategory 3
InventoryValuationType InventoryValuationType 2
InvtryValnSpecialStockType InventorySpecialStockType 1
IsBlockedForCosting IsBlockedForCosting 1
IsBulkMaterial IsBulkMaterial 1
IsCoProduct IsCoProduct 1
IsFixedPriceCoProduct IsFixedPriceCoProduct 1
IsLIFOAndFIFORelevant IsLIFOAndFIFORelevant 1
IsMaterialCostedWithQtyStruc IsMaterialCostedWithQtyStruc 1
IsMaterialRelatedOrigin IsMaterialRelatedOrigin 1
IsMatlOfValnTypeMarkedForDeltn IsMatlOfValnTypeMarkedForDeltn 1
IsProducedInhouse IsProducedInhouse 1
LedgerName LedgerName 1
LIFOValuationPoolNumber LIFOValuationPoolNumber 1
MaintenanceStatus MaintenanceStatus 1
Material Material 3
MaterialGroup MaterialGroup 1
MaterialProcurementCategory MaterialProcurementCategory 1
MaterialProcurementProfile MaterialProcurementProfile 1
MaterialType MaterialType 1
MaterialUsabilityProfile MaterialUsabilityProfile 1
MaterialValuationClass MaterialValuationClass 2
PhysicalInventoryBlockInd PhysicalInventoryBlockInd 1
PlannedPrice1InCoCodeCrcy PlannedPrice1InCoCodeCrcy 1
PlannedPrice2InCoCodeCrcy PlannedPrice2InCoCodeCrcy 1
PlannedPrice3InCoCodeCrcy PlannedPrice3InCoCodeCrcy 1
PlannedPriceInCoCodeCrcy PlannedPriceInCoCodeCrcy 1
PlntMatlIsMarkedForDeletion PlntMatlIsMarkedForDeletion 1
PrevCostEstValuationVariant PrevCostEstValuationVariant 1
PreviousCostEstCostingVersion PreviousCostEstCostingVersion 1
PreviousCostEstFiscalPeriod PreviousCostEstFiscalPeriod 1
PreviousCostEstFiscalYear PreviousCostEstFiscalYear 1
PreviousFiscalPeriod PreviousFiscalPeriod 1
PreviousFiscalPeriodFiscalYear PreviousFiscalPeriodFiscalYear 1
PreviousFiscalYear PreviousFiscalYear 1
PreviousFiscalYearPeriod PreviousFiscalYearPeriod 1
PreviousPlanPriceInCoCodeCrcy PreviousPlanPriceInCoCodeCrcy 1
PrevPlanProjSlsOrdValnStrategy PrevPlanProjSlsOrdValnStrategy 1
PriceDeterminationControl PriceDeterminationControl 1
PriceLastChangeDate PriceLastChangeDate 1
ProductOriginType ProductOriginType 1
ProductUsageType ProductUsageType 1
ProfitCenter ProfitCenter 1
ProjectStockValuationClass ProjectStockValuationClass 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
Supplier Supplier 1
TaskListGroup TaskListGroup 1
TaskListGroupCounter TaskListGroupCounter 1
TaxBasedPricesPriceUnitQty TaxBasedPricesPriceUnitQty 1
TaxPrice2InCoCodeCrcy TaxPrice2InCoCodeCrcy 1
TaxPrice3InCoCodeCrcy TaxPrice3InCoCodeCrcy 1
TaxPricel1InCoCodeCrcy TaxPricel1InCoCodeCrcy 1
ValnClsForSpclStkAtVndr ValnClsForSpclStkAtVndr 1
ValnIsBsdOnBatchSpecificUnit ValnIsBsdOnBatchSpecificUnit 1
ValuationClassInPrevPeriod ValuationClassInPrevPeriod 1
ValuationClassInPrevYear ValuationClassInPrevYear 1
ValuationClassSalesOrderStock ValuationClassSalesOrderStock 1
ValuationMargin ValuationMargin 1
ValuationQuantityUnit BaseUnit,ValuationQuantityUnit 3

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 P_MATVAL_MANAGE_MD2 (
    COSTESTIMATE,
    CURRENCYROLE,
    LEDGER,
    VALUATIONAREA,
    ALTERNATIVEBILLOFMATERIAL,
    ASSEMBLYSCRAPPERCENT,
    BASEUNIT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFOPERATIONSTYPE,
    COMMERCIALPRICE1INCOCODECRCY,
    COMMERCIALPRICE2INCOCODECRCY,
    COMMERCIALPRICE3INCOCODECRCY,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    COMPONENTSCRAPINPERCENT,
    COSTINGLOTSIZE,
    COSTINGMATPROCUREMENTPROFILE,
    COSTINGOVERHEADGROUP,
    COSTINGPRODUCTIONVERSION,
    COSTORIGINGROUP,
    CURCOSTESTVALUATIONVARIANT,
    CURPLANPROJSLSORDVALNSTRATEGY,
    CURRENCY,
    CURRENTCOSTESTCOSTINGVERSION,
    CURRENTCOSTESTFISCALPERIOD,
    CURRENTCOSTESTFISCALYEAR,
    CURRENTFISCALPERIOD,
    CURRENTFISCALYEAR,
    CURRENTPLANPRICEINCOCODECRCY,
    DATEOFLASTPOSTEDCNTUNRSTRCDSTK,
    DEVALUATIONYEARCOUNT,
    FUTRCOSTESTVALUATIONVARIANT,
    FUTRPLANPROJSLSORDVALNSTRATEGY,
    FUTURECOSTESTCOSTINGVERSION,
    FUTURECOSTESTFISCALYEAR,
    FUTURECOSTESTIMATEFISCALPERIOD,
    FUTUREPLNDPRICE1VALDTYDATE,
    FUTUREPLNDPRICE2VALDTYDATE,
    FUTUREPLNDPRICE3VALDTYDATE,
    FXDPORTNOFFUTPLPRCINCOCODECRCY,
    FXDPORTOFPREVPLPRCINCOCODECRCY,
    HASPRODUCTIONVERSION,
    HASSTDCOSTESTFORCURRENTPERIOD,
    HASSTDCOSTESTFORFUTUREPERIOD,
    HASSTDCOSTESTFORPREVIOUSPERIOD,
    INVENTORYFORCYCLECOUNTIND,
    INVENTORYVALUATIONCATEGORY,
    INVENTORYVALUATIONTYPE,
    INVTRYVALNSPECIALSTOCKTYPE,
    ISBLOCKEDFORCOSTING,
    ISBULKMATERIAL,
    ISCOPRODUCT,
    ISFIXEDPRICECOPRODUCT,
    ISLIFOANDFIFORELEVANT,
    ISMATERIALCOSTEDWITHQTYSTRUC,
    ISMATERIALRELATEDORIGIN,
    ISMATLOFVALNTYPEMARKEDFORDELTN,
    ISPRODUCEDINHOUSE,
    LEDGERNAME,
    LIFOVALUATIONPOOLNUMBER,
    MAINTENANCESTATUS,
    MATERIAL,
    MATERIALGROUP,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALPROCUREMENTPROFILE,
    MATERIALTYPE,
    MATERIALUSABILITYPROFILE,
    MATERIALVALUATIONCLASS,
    PHYSICALINVENTORYBLOCKIND,
    PLANNEDPRICE1INCOCODECRCY,
    PLANNEDPRICE2INCOCODECRCY,
    PLANNEDPRICE3INCOCODECRCY,
    PLANNEDPRICEINCOCODECRCY,
    PLNTMATLISMARKEDFORDELETION,
    PREVCOSTESTVALUATIONVARIANT,
    PREVIOUSCOSTESTCOSTINGVERSION,
    PREVIOUSCOSTESTFISCALPERIOD,
    PREVIOUSCOSTESTFISCALYEAR,
    PREVIOUSFISCALPERIOD,
    PREVIOUSFISCALPERIODFISCALYEAR,
    PREVIOUSFISCALYEAR,
    PREVIOUSFISCALYEARPERIOD,
    PREVIOUSPLANPRICEINCOCODECRCY,
    PREVPLANPROJSLSORDVALNSTRATEGY,
    PRICEDETERMINATIONCONTROL,
    PRICELASTCHANGEDATE,
    PRODUCTORIGINTYPE,
    PRODUCTUSAGETYPE,
    PROFITCENTER,
    PROJECTSTOCKVALUATIONCLASS,
    SALESORDER,
    SALESORDERITEM,
    SUPPLIER,
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER,
    TAXBASEDPRICESPRICEUNITQTY,
    TAXPRICE2INCOCODECRCY,
    TAXPRICE3INCOCODECRCY,
    TAXPRICEL1INCOCODECRCY,
    VALNCLSFORSPCLSTKATVNDR,
    VALNISBSDONBATCHSPECIFICUNIT,
    VALUATIONCLASSINPREVPERIOD,
    VALUATIONCLASSINPREVYEAR,
    VALUATIONCLASSSALESORDERSTOCK,
    VALUATIONMARGIN,
    VALUATIONQUANTITYUNIT,
    PRIMARY KEY (COSTESTIMATE, CURRENCYROLE, LEDGER, VALUATIONAREA)
);

Learn More