P_MATVAL_MANAGE_MD_FMLT
P_MATVAL_MANAGE_MD_FMLT is a CDS View in S/4HANA. It contains 102 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CurrentMaterialValuations | view | union_all | COMPOSITE | Current Material Valuations |
Fields (102)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CostEstimate | CostEstimate | 1 |
| AlternativeBillOfMaterial | AlternativeBillOfMaterial | 1 | |
| AssemblyScrapPercent | AssemblyScrapPercent | 1 | |
| BaseUnit | BaseUnit | 1 | |
| BillOfMaterialVariantUsage | BillOfMaterialVariantUsage | 1 | |
| BillOfOperationsType | BillOfOperationsType | 1 | |
| CommercialPrice1InCoCodeCrcy | CommercialPrice1InCoCodeCrcy | 1 | |
| CommercialPrice2InCoCodeCrcy | CommercialPrice2InCoCodeCrcy | 1 | |
| CommercialPrice3InCoCodeCrcy | CommercialPrice3InCoCodeCrcy | 1 | |
| CompanyCode | CompanyCode | 1 | |
| 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 | 1 | |
| 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 | |
| FxdPortnOfPlanPrcInCoCodeCrcy | FxdPortnOfPlanPrcInCoCodeCrcy | 1 | |
| FxdPortOfPrevPlPrcInCoCodeCrcy | FxdPortOfPrevPlPrcInCoCodeCrcy | 1 | |
| HasProductionVersion | HasProductionVersion | 1 | |
| HasStdCostEstForCurrentPeriod | HasStdCostEstForCurrentPeriod | 1 | |
| HasStdCostEstForFuturePeriod | HasStdCostEstForFuturePeriod | 1 | |
| HasStdCostEstForPreviousPeriod | HasStdCostEstForPreviousPeriod | 1 | |
| InventoryForCycleCountInd | InventoryForCycleCountInd | 1 | |
| InventoryValuationCategory | InventoryValuationCategory | 1 | |
| InventoryValuationType | InventoryValuationType | 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 | |
| Ledger | Ledger | 1 | |
| LedgerName | LedgerName | 1 | |
| LIFOValuationPoolNumber | LIFOValuationPoolNumber | 1 | |
| MaintenanceStatus | MaintenanceStatus | 1 | |
| Material | Material | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| MaterialProcurementCategory | MaterialProcurementCategory | 1 | |
| MaterialProcurementProfile | MaterialProcurementProfile | 1 | |
| MaterialType | MaterialType | 1 | |
| MaterialUsabilityProfile | MaterialUsabilityProfile | 1 | |
| MaterialValuationClass | MaterialValuationClass | 1 | |
| 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 | |
| PriceLastChangeDate | PriceLastChangeDate | 1 | |
| ProductOriginType | ProductOriginType | 1 | |
| ProductUsageType | ProductUsageType | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectStockValuationClass | ProjectStockValuationClass | 1 | |
| TaskListGroup | TaskListGroup | 1 | |
| TaskListGroupCounter | TaskListGroupCounter | 1 | |
| TaxBasedPricesPriceUnitQty | TaxBasedPricesPriceUnitQty | 1 | |
| TaxPrice2InCoCodeCrcy | TaxPrice2InCoCodeCrcy | 1 | |
| TaxPrice3InCoCodeCrcy | TaxPrice3InCoCodeCrcy | 1 | |
| TaxPricel1InCoCodeCrcy | TaxPricel1InCoCodeCrcy | 1 | |
| TotStkValAtSlsPrcInCoCodeCrcy | TotStkValAtSlsPrcInCoCodeCrcy | 1 | |
| ValnClsForSpclStkAtVndr | ValnClsForSpclStkAtVndr | 1 | |
| ValnIsBsdOnBatchSpecificUnit | ValnIsBsdOnBatchSpecificUnit | 1 | |
| ValuationArea | ValuationArea | 1 | |
| ValuationClassInPrevPeriod | ValuationClassInPrevPeriod | 1 | |
| ValuationClassInPrevYear | ValuationClassInPrevYear | 1 | |
| ValuationClassSalesOrderStock | ValuationClassSalesOrderStock | 1 | |
| ValuationMargin | ValuationMargin | 1 | |
| ValuationQuantityUnit | ValuationQuantityUnit | 1 |
@AbapCatalog.sqlViewName: 'PMATVALMGMMDF'
@VDM.private: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_MATVAL_MANAGE_MD_FMLT
as select from I_MaterialLedgerPrice as fmlt
left outer to one join P_Matval_Manage_Xbew as xb on xb.CostEstimate = fmlt.CostEstimate
and xb.ValuationArea = fmlt.ValuationArea
and xb.Material = fmlt.Material
and xb.InventoryValuationType = fmlt.InventoryValuationType
left outer to one join P_MatlCtrlRecdLdgrFiscalPeriod as marvld on marvld.CompanyCode = fmlt.CompanyCode
and marvld.Ledger = fmlt.Ledger
left outer to one join mara as ma on ma.matnr = fmlt.Material
left outer to one join marc as mc on mc.matnr = fmlt.Material
and mc.werks = fmlt.ValuationArea
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on xb.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
{
key fmlt.CostEstimate,
key fmlt.Ledger,
key fmlt.CurrencyRole,
key fmlt.Material,
key fmlt.ValuationArea,
fmlt.CompanyCode,
fmlt.InventoryValuationType,
fmlt.MaterialPriceUnitQty,
fmlt.ValuationQuantityUnit,
fmlt.MaterialPrice as FuturePrice,
fmlt.MaterialPriceValidityStartDate as FuturePriceValidityStartDate,
xb.InvtryValnSpecialStockType,
xb.SalesOrder,
xb.SalesOrderItem,
xb.Supplier,
_WBSElementBasicData.WBSElementInternalID as WBSElementInternalID,
_WBSElementBasicData.WBSElementExternalID as WBSElementExternalID,
// MARA fields
ma.meins as BaseUnit,
ma.matkl as MaterialGroup,
ma.mtart as MaterialType,
// MARC fields
mc.lvorm as PlntMatlIsMarkedForDeletion,
mc.mmsta as MaterialUsabilityProfile,
mc.ausss as AssemblyScrapPercent,
mc.beskz as MaterialProcurementCategory,
mc.sobsl as MaterialProcurementProfile,
mc.prctr as ProfitCenter,
mc.verkz as HasProductionVersion,
mc.stlal as AlternativeBillOfMaterial,
mc.stlan as BillOfMaterialVariantUsage,
mc.plnnr as TaskListGroup,
mc.aplal as TaskListGroupCounter,
mc.losgr as CostingLotSize,
mc.sobsk as CostingMatProcurementProfile,
mc.kausf as ComponentScrapInPercent,
mc.kzkup as IsCoProduct,
mc.schgt as IsBulkMaterial,
mc.plnty as BillOfOperationsType,
mc.fvidk as CostingProductionVersion,
mc.fxpru as IsFixedPriceCoProduct,
mc.ncost as IsBlockedForCosting,
xb.PriceDeterminationControl,
xb.IsMatlOfValnTypeMarkedForDeltn,
xb.MaterialValuationClass,
xb.ValuationClassInPrevPeriod,
xb.ValuationClassInPrevYear,
marvld.CurrentFiscalYear as CurrentFiscalYear,
marvld.CurrentFiscalPeriod as CurrentFiscalPeriod,
marvld.PreviousFiscalPeriodFiscalYear as PreviousFiscalPeriodFiscalYear,
marvld.PreviousFiscalPeriod as PreviousFiscalPeriod,
marvld.PreviousFiscalYear as PreviousFiscalYear,
marvld.PrevFiscalYearLastFiscalPeriod as PreviousFiscalYearPeriod,
xb.InventoryValuationCategory,
xb.PriceLastChangeDate,
xb.TaxPricel1InCoCodeCrcy,
xb.CommercialPrice1InCoCodeCrcy,
xb.TaxPrice3InCoCodeCrcy,
xb.CommercialPrice3InCoCodeCrcy,
xb.PlannedPriceInCoCodeCrcy,
xb.PlannedPrice1InCoCodeCrcy,
xb.PlannedPrice2InCoCodeCrcy,
xb.PlannedPrice3InCoCodeCrcy,
xb.FuturePlndPrice1ValdtyDate,
xb.FuturePlndPrice2ValdtyDate,
xb.FuturePlndPrice3ValdtyDate,
xb.HasStdCostEstForFuturePeriod,
xb.HasStdCostEstForCurrentPeriod,
xb.HasStdCostEstForPreviousPeriod,
xb.IsLIFOAndFIFORelevant,
xb.LIFOValuationPoolNumber,
xb.CommercialPrice2InCoCodeCrcy,
xb.TaxPrice2InCoCodeCrcy,
xb.DevaluationYearCount,
xb.MaintenanceStatus,
xb.FutrCostEstValuationVariant,
xb.CurCostEstValuationVariant,
xb.PrevCostEstValuationVariant,
xb.FutureCostEstCostingVersion,
xb.CurrentCostEstCostingVersion,
xb.PreviousCostEstCostingVersion,
xb.CostOriginGroup,
xb.CostingOverheadGroup,
xb.FutureCostEstimateFiscalPeriod,
xb.CurrentCostEstFiscalPeriod,
xb.PreviousCostEstFiscalPeriod,
xb.FutureCostEstFiscalYear,
xb.CurrentCostEstFiscalYear,
xb.PreviousCostEstFiscalYear,
xb.IsMaterialCostedWithQtyStruc,
xb.PreviousPlanPriceInCoCodeCrcy,
xb.CurrentPlanPriceInCoCodeCrcy,
xb.TotStkValAtSlsPrcInCoCodeCrcy,
xb.IsMaterialRelatedOrigin,
xb.PhysicalInventoryBlockInd,
xb.DateOfLastPostedCntUnRstrcdStk,
xb.InventoryForCycleCountInd,
xb.ValuationMargin,
xb.FxdPortnOfPlanPrcInCoCodeCrcy,
xb.FxdPortOfPrevPlPrcInCoCodeCrcy,
xb.FxdPortnOfFutPlPrcInCoCodeCrcy,
xb.CurPlanProjSlsOrdValnStrategy,
xb.PrevPlanProjSlsOrdValnStrategy,
xb.FutrPlanProjSlsOrdValnStrategy,
xb.ValuationClassSalesOrderStock,
xb.ProjectStockValuationClass,
xb.ProductUsageType,
xb.ProductOriginType,
xb.IsProducedInhouse,
xb.ValnIsBsdOnBatchSpecificUnit,
xb.TaxBasedPricesPriceUnitQty,
xb.ValnClsForSpclStkAtVndr
}
where
fmlt.MaterialPriceType = 'FUTURE' // including mother segment
// and fmlt.MaterialPriceSubtype = ''
// and fmlt.MatlPrcValdtyEndFsclYearPeriod = '9999012'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALLEDGERPRICE",
"I_WBSELEMENTBASICDATA",
"P_MATLCTRLRECDLDGRFISCALPERIOD",
"P_MATVAL_MANAGE_XBEW",
"MARA",
"MARC"
],
"ASSOCIATED":
[
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/