I_CurrentMaterialValuations

DDL: I_CURRENTMATERIALVALUATIONS SQL: IMATVALMANAGEC Type: view COMPOSITE

Current Material Valuations

I_CurrentMaterialValuations is a Composite CDS View that provides data about "Current Material Valuations" in SAP S/4HANA. It reads from 10 data sources and exposes 271 fields with key fields CostEstimate, LedgerValuationCurrencyRole, LedgerValuationCurrencyRole. It has 7 associations to related views.

10 data source(s) 271 fields

Data Sources (10)

SourceAliasJoin Type
P_Matval_Manage_Bal_Split bal left_outer
P_Matval_Manage_Ckml ckml inner
P_Matval_Manage_Ckml ckml left_outer
P_Matval_Manage_Md2 md from
P_Matval_Manage_Md2 md union_all
P_MATVAL_MANAGE_MD_FMLT md union_all
P_Matval_Manage_Pnv_Pre mx left_outer
R_MatlPriceDataMigrationStatus tf inner
R_MatlPriceDataMigrationStatus tf inner
R_MatlPriceDataMigrationStatus tf inner

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Plant _Plant $projection.ValuationArea = _Plant.Plant
[0..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
[0..1] I_MaterialLedgerPrice _STDPR _STDPR.CostEstimate = md.CostEstimate and _STDPR.Ledger = md.Ledger and _STDPR.CurrencyRole = md.CurrencyRole and _STDPR.MaterialPriceType = 'STDPR' and _STDPR.MaterialPriceSubtype = '' and _STDPR.MatlPrcValdtyEndFsclYearPeriod = '9999012' and _STDPR.Material = md.Material and _STDPR.CompanyCode = md.CompanyCode and _STDPR.ValuationArea = md.ValuationArea
[0..1] I_MaterialLedgerPrice _ACT _ACT.CostEstimate = md.CostEstimate and _ACT.CurrencyRole = md.CurrencyRole and _ACT.Ledger = md.Ledger and _ACT.MaterialPriceType = 'ACT' and _ACT.MaterialPriceSubtype = 'ACT' and _ACT.MatlPrcValdtyEndFsclYearPeriod = '9999012' and _ACT.Material = md.Material and _ACT.CompanyCode = md.CompanyCode and _ACT.ValuationArea = md.ValuationArea
[0..1] I_MaterialLedgerPrice _MAP _MAP.CostEstimate = md.CostEstimate and _MAP.CurrencyRole = md.CurrencyRole and _MAP.Ledger = md.Ledger and _MAP.MaterialPriceType = 'MAP' and _MAP.MaterialPriceSubtype = '' and _MAP.MatlPrcValdtyEndFsclYearPeriod = '9999012' and _MAP.Material = md.Material and _MAP.Material = md.Material and _MAP.CompanyCode = md.CompanyCode and _MAP.ValuationArea = md.ValuationArea
[0..1] I_MaterialLedgerPrice _FSTDCE _FSTDCE.CostEstimate = md.CostEstimate and _FSTDCE.CurrencyRole = md.CurrencyRole and _FSTDCE.Ledger = md.Ledger and _FSTDCE.MaterialPriceType = 'FSTDCE' and _FSTDCE.MaterialPriceSubtype = '' and _FSTDCE.Material = md.Material and _FSTDCE.Material = md.Material and _FSTDCE.CompanyCode = md.CompanyCode and _FSTDCE.ValuationArea = md.ValuationArea and _FSTDCE.MatlPrcValidityStartFiscalYear = md.CurrentFiscalYear and _FSTDCE.MatlPrcValdtyStartFiscalPeriod = md.CurrentFiscalPeriod

Annotations (9)

NameValueLevelField
EndUserText.label Current Material Valuations view
AbapCatalog.sqlViewName IMATVALMANAGEC view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (271)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate P_MATVAL_MANAGE_MD_FMLT CostEstimate
KEY LedgerValuationCurrencyRole lvcr LedgerValuationCurrencyRole
LegalCurrencyRole lvcr LegalCurrencyRole
Ledger P_MATVAL_MANAGE_MD_FMLT Ledger
AccountingValuationView lvcr AccountingValuationView
AccountingValuationSubview lvcr AccountingValuationSubview
CurrencyRole lvcr CurrencyRole
LegalCurrencyRoleName lvcr LegalCurrencyRoleName
AccountingValuationViewName lvcr AccountingValuationViewName
AccountingValuationSubviewName lvcr AccountingValuationSubviewName
AcctgValnVwSubviewCombinedName lvcr AcctgValnVwSubviewCombinedName
LedgerName P_MATVAL_MANAGE_MD_FMLT LedgerName
Material P_MATVAL_MANAGE_MD_FMLT Material
ValuationArea P_MATVAL_MANAGE_MD_FMLT ValuationArea
InventoryValuationType P_MATVAL_MANAGE_MD_FMLT InventoryValuationType
ControllingArea _CompanyCode ControllingArea
InvtryValnSpecialStockType P_Matval_Manage_Ckml InvtryValnSpecialStockType
SalesOrder P_Matval_Manage_Ckml SalesOrder
SalesOrderItem P_Matval_Manage_Ckml SalesOrderItem
Supplier P_Matval_Manage_Ckml Supplier
WBSElementInternalID P_Matval_Manage_Ckml WBSElementInternalID
WBSElementExternalID P_Matval_Manage_Ckml WBSElementExternalID
FuturePrice P_Matval_Manage_Ckml FuturePrice
FuturePriceValidityStartDate P_Matval_Manage_Ckml FuturePriceValidityStartDate
FuturePlannedPrice P_Matval_Manage_Ckml FuturePlannedPrice
TotalVltdStockQuantity
AmountInCompanyCodeCurrency
MaterialPriceControl P_Matval_Manage_Ckml MaterialPriceControl
PriceDeterminationControl P_Matval_Manage_Ckml PriceDeterminationControl
MovingAveragePrice P_Matval_Manage_Ckml MovingAveragePrice
StandardPrice P_Matval_Manage_Ckml StandardPrice
MaterialPriceUnitQty P_Matval_Manage_Ckml MaterialPriceUnitQty
CompanyCode P_MATVAL_MANAGE_MD_FMLT CompanyCode
Currency P_MATVAL_MANAGE_MD_FMLT Currency
CompanyCodeCurrency P_MATVAL_MANAGE_MD_FMLT CompanyCodeCurrency
BaseUnit P_MATVAL_MANAGE_MD_FMLT BaseUnit
ValuationQuantityUnit P_MATVAL_MANAGE_MD_FMLT ValuationQuantityUnit
MaterialGroup P_MATVAL_MANAGE_MD_FMLT MaterialGroup
MaterialType P_MATVAL_MANAGE_MD_FMLT MaterialType
PlntMatlIsMarkedForDeletion P_MATVAL_MANAGE_MD_FMLT PlntMatlIsMarkedForDeletion
AssemblyScrapPercent P_MATVAL_MANAGE_MD_FMLT AssemblyScrapPercent
MaterialProcurementCategory P_MATVAL_MANAGE_MD_FMLT MaterialProcurementCategory
MaterialProcurementProfile P_MATVAL_MANAGE_MD_FMLT MaterialProcurementProfile
ProfitCenter P_MATVAL_MANAGE_MD_FMLT ProfitCenter
HasProductionVersion P_MATVAL_MANAGE_MD_FMLT HasProductionVersion
AlternativeBillOfMaterial P_MATVAL_MANAGE_MD_FMLT AlternativeBillOfMaterial
BillOfMaterialVariantUsage P_MATVAL_MANAGE_MD_FMLT BillOfMaterialVariantUsage
TaskListGroup P_MATVAL_MANAGE_MD_FMLT TaskListGroup
TaskListGroupCounter P_MATVAL_MANAGE_MD_FMLT TaskListGroupCounter
CostingLotSize P_MATVAL_MANAGE_MD_FMLT CostingLotSize
CostingMatProcurementProfile P_MATVAL_MANAGE_MD_FMLT CostingMatProcurementProfile
IsCoProduct P_MATVAL_MANAGE_MD_FMLT IsCoProduct
ComponentScrapInPercent P_MATVAL_MANAGE_MD_FMLT ComponentScrapInPercent
IsBulkMaterial P_MATVAL_MANAGE_MD_FMLT IsBulkMaterial
BillOfOperationsType P_MATVAL_MANAGE_MD_FMLT BillOfOperationsType
CostingProductionVersion P_MATVAL_MANAGE_MD_FMLT CostingProductionVersion
IsFixedPriceCoProduct P_MATVAL_MANAGE_MD_FMLT IsFixedPriceCoProduct
IsBlockedForCosting P_MATVAL_MANAGE_MD_FMLT IsBlockedForCosting
IsMatlOfValnTypeMarkedForDeltn P_MATVAL_MANAGE_MD_FMLT IsMatlOfValnTypeMarkedForDeltn
MaterialUsabilityProfile P_MATVAL_MANAGE_MD_FMLT MaterialUsabilityProfile
MaterialValuationClass P_MATVAL_MANAGE_MD_FMLT MaterialValuationClass
ValuationClassInPrevPeriod P_MATVAL_MANAGE_MD_FMLT ValuationClassInPrevPeriod
ValuationClassInPrevYear P_MATVAL_MANAGE_MD_FMLT ValuationClassInPrevYear
CurrentFiscalYear P_MATVAL_MANAGE_MD_FMLT CurrentFiscalYear
CurrentFiscalPeriod P_MATVAL_MANAGE_MD_FMLT CurrentFiscalPeriod
PreviousFiscalPeriodFiscalYear P_MATVAL_MANAGE_MD_FMLT PreviousFiscalPeriodFiscalYear
PreviousFiscalPeriod P_MATVAL_MANAGE_MD_FMLT PreviousFiscalPeriod
PreviousFiscalYear P_MATVAL_MANAGE_MD_FMLT PreviousFiscalYear
PreviousFiscalYearPeriod P_MATVAL_MANAGE_MD_FMLT PreviousFiscalYearPeriod
InventoryValuationCategory P_MATVAL_MANAGE_MD_FMLT InventoryValuationCategory
PriceLastChangeDate P_MATVAL_MANAGE_MD_FMLT PriceLastChangeDate
TaxPricel1InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT TaxPricel1InCoCodeCrcy
CommercialPrice1InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT CommercialPrice1InCoCodeCrcy
TaxPrice3InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT TaxPrice3InCoCodeCrcy
CommercialPrice3InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT CommercialPrice3InCoCodeCrcy
PlannedPriceInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT PlannedPriceInCoCodeCrcy
PlannedPrice1InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT PlannedPrice1InCoCodeCrcy
PlannedPrice2InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT PlannedPrice2InCoCodeCrcy
PlannedPrice3InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT PlannedPrice3InCoCodeCrcy
FuturePlndPrice1ValdtyDate P_MATVAL_MANAGE_MD_FMLT FuturePlndPrice1ValdtyDate
FuturePlndPrice2ValdtyDate P_MATVAL_MANAGE_MD_FMLT FuturePlndPrice2ValdtyDate
FuturePlndPrice3ValdtyDate P_MATVAL_MANAGE_MD_FMLT FuturePlndPrice3ValdtyDate
HasStdCostEstForFuturePeriod P_MATVAL_MANAGE_MD_FMLT HasStdCostEstForFuturePeriod
HasStdCostEstForCurrentPeriod P_MATVAL_MANAGE_MD_FMLT HasStdCostEstForCurrentPeriod
HasStdCostEstForPreviousPeriod P_MATVAL_MANAGE_MD_FMLT HasStdCostEstForPreviousPeriod
IsLIFOAndFIFORelevant P_MATVAL_MANAGE_MD_FMLT IsLIFOAndFIFORelevant
LIFOValuationPoolNumber P_MATVAL_MANAGE_MD_FMLT LIFOValuationPoolNumber
CommercialPrice2InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT CommercialPrice2InCoCodeCrcy
TaxPrice2InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT TaxPrice2InCoCodeCrcy
DevaluationYearCount P_MATVAL_MANAGE_MD_FMLT DevaluationYearCount
MaintenanceStatus P_MATVAL_MANAGE_MD_FMLT MaintenanceStatus
FutrCostEstValuationVariant P_MATVAL_MANAGE_MD_FMLT FutrCostEstValuationVariant
CurCostEstValuationVariant P_MATVAL_MANAGE_MD_FMLT CurCostEstValuationVariant
PrevCostEstValuationVariant P_MATVAL_MANAGE_MD_FMLT PrevCostEstValuationVariant
FutureCostEstCostingVersion P_MATVAL_MANAGE_MD_FMLT FutureCostEstCostingVersion
CurrentCostEstCostingVersion P_MATVAL_MANAGE_MD_FMLT CurrentCostEstCostingVersion
PreviousCostEstCostingVersion P_MATVAL_MANAGE_MD_FMLT PreviousCostEstCostingVersion
CostOriginGroup P_MATVAL_MANAGE_MD_FMLT CostOriginGroup
CostingOverheadGroup P_MATVAL_MANAGE_MD_FMLT CostingOverheadGroup
FutureCostEstimateFiscalPeriod P_MATVAL_MANAGE_MD_FMLT FutureCostEstimateFiscalPeriod
CurrentCostEstFiscalPeriod P_MATVAL_MANAGE_MD_FMLT CurrentCostEstFiscalPeriod
PreviousCostEstFiscalPeriod P_MATVAL_MANAGE_MD_FMLT PreviousCostEstFiscalPeriod
FutureCostEstFiscalYear P_MATVAL_MANAGE_MD_FMLT FutureCostEstFiscalYear
CurrentCostEstFiscalYear P_MATVAL_MANAGE_MD_FMLT CurrentCostEstFiscalYear
PreviousCostEstFiscalYear P_MATVAL_MANAGE_MD_FMLT PreviousCostEstFiscalYear
IsMaterialCostedWithQtyStruc P_MATVAL_MANAGE_MD_FMLT IsMaterialCostedWithQtyStruc
PreviousPlanPriceInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT PreviousPlanPriceInCoCodeCrcy
CurrentPlanPriceInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT CurrentPlanPriceInCoCodeCrcy
TotStkValAtSlsPrcInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT TotStkValAtSlsPrcInCoCodeCrcy
IsMaterialRelatedOrigin P_MATVAL_MANAGE_MD_FMLT IsMaterialRelatedOrigin
PhysicalInventoryBlockInd P_MATVAL_MANAGE_MD_FMLT PhysicalInventoryBlockInd
DateOfLastPostedCntUnRstrcdStk P_MATVAL_MANAGE_MD_FMLT DateOfLastPostedCntUnRstrcdStk
InventoryForCycleCountInd P_MATVAL_MANAGE_MD_FMLT InventoryForCycleCountInd
ValuationMargin P_MATVAL_MANAGE_MD_FMLT ValuationMargin
FxdPortnOfPlanPrcInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT FxdPortnOfPlanPrcInCoCodeCrcy
FxdPortOfPrevPlPrcInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT FxdPortOfPrevPlPrcInCoCodeCrcy
FxdPortnOfFutPlPrcInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT FxdPortnOfFutPlPrcInCoCodeCrcy
CurPlanProjSlsOrdValnStrategy P_MATVAL_MANAGE_MD_FMLT CurPlanProjSlsOrdValnStrategy
PrevPlanProjSlsOrdValnStrategy P_MATVAL_MANAGE_MD_FMLT PrevPlanProjSlsOrdValnStrategy
FutrPlanProjSlsOrdValnStrategy P_MATVAL_MANAGE_MD_FMLT FutrPlanProjSlsOrdValnStrategy
ValuationClassSalesOrderStock P_MATVAL_MANAGE_MD_FMLT ValuationClassSalesOrderStock
ProjectStockValuationClass P_MATVAL_MANAGE_MD_FMLT ProjectStockValuationClass
ProductUsageType P_MATVAL_MANAGE_MD_FMLT ProductUsageType
ProductOriginType P_MATVAL_MANAGE_MD_FMLT ProductOriginType
IsProducedInhouse P_MATVAL_MANAGE_MD_FMLT IsProducedInhouse
ValnIsBsdOnBatchSpecificUnit P_MATVAL_MANAGE_MD_FMLT ValnIsBsdOnBatchSpecificUnit
TaxBasedPricesPriceUnitQty P_MATVAL_MANAGE_MD_FMLT TaxBasedPricesPriceUnitQty
ValnClsForSpclStkAtVndr P_MATVAL_MANAGE_MD_FMLT ValnClsForSpclStkAtVndr
FiscalPeriodEndDate fpi FiscalPeriodEndDate
NextFiscalPeriodStartDate
ControllingValuationType lvcr AccountingValuationView
MaterialName _MaterialText MaterialName
CompanyCodeName _CompanyCode CompanyCodeName
Plant _Plant Plant
PlantName _Plant PlantName
CostEstimate
KEY LedgerValuationCurrencyRole lvcr LedgerValuationCurrencyRole
LegalCurrencyRole lvcr LegalCurrencyRole
Ledger P_MATVAL_MANAGE_MD_FMLT Ledger
AccountingValuationView lvcr AccountingValuationView
AccountingValuationSubview lvcr AccountingValuationSubview
CurrencyRole lvcr CurrencyRole
LegalCurrencyRoleName lvcr LegalCurrencyRoleName
AccountingValuationViewName lvcr AccountingValuationViewName
AccountingValuationSubviewName lvcr AccountingValuationSubviewName
AcctgValnVwSubviewCombinedName lvcr AcctgValnVwSubviewCombinedName
LedgerName P_MATVAL_MANAGE_MD_FMLT LedgerName
Material P_MATVAL_MANAGE_MD_FMLT Material
ValuationArea P_MATVAL_MANAGE_MD_FMLT ValuationArea
InventoryValuationType P_MATVAL_MANAGE_MD_FMLT InventoryValuationType
ControllingArea _CompanyCode ControllingArea
InvtryValnSpecialStockType P_Matval_Manage_Ckml InvtryValnSpecialStockType
SalesOrder P_Matval_Manage_Ckml SalesOrder
SalesOrderItem P_Matval_Manage_Ckml SalesOrderItem
Supplier P_Matval_Manage_Ckml Supplier
WBSElementInternalID P_Matval_Manage_Ckml WBSElementInternalID
WBSElementExternalID P_Matval_Manage_Ckml WBSElementExternalID
FuturePrice P_Matval_Manage_Ckml FuturePrice
FuturePriceValidityStartDate P_Matval_Manage_Ckml FuturePriceValidityStartDate
FuturePlannedPrice P_Matval_Manage_Ckml FuturePlannedPrice
TotalVltdStockQuantity
AmountInCompanyCodeCurrency
MaterialPriceControl P_Matval_Manage_Ckml MaterialPriceControl
PriceDeterminationControl P_Matval_Manage_Ckml PriceDeterminationControl
MovingAveragePrice P_Matval_Manage_Ckml MovingAveragePrice
StandardPrice P_Matval_Manage_Ckml StandardPrice
MaterialPriceUnitQty P_Matval_Manage_Ckml MaterialPriceUnitQty
CompanyCode P_MATVAL_MANAGE_MD_FMLT CompanyCode
Currency P_MATVAL_MANAGE_MD_FMLT Currency
CompanyCodeCurrency P_MATVAL_MANAGE_MD_FMLT CompanyCodeCurrency
BaseUnit P_MATVAL_MANAGE_MD_FMLT BaseUnit
ValuationQuantityUnit P_MATVAL_MANAGE_MD_FMLT ValuationQuantityUnit
MaterialGroup P_MATVAL_MANAGE_MD_FMLT MaterialGroup
MaterialType P_MATVAL_MANAGE_MD_FMLT MaterialType
PlntMatlIsMarkedForDeletion P_MATVAL_MANAGE_MD_FMLT PlntMatlIsMarkedForDeletion
AssemblyScrapPercent P_MATVAL_MANAGE_MD_FMLT AssemblyScrapPercent
MaterialProcurementCategory P_MATVAL_MANAGE_MD_FMLT MaterialProcurementCategory
MaterialProcurementProfile P_MATVAL_MANAGE_MD_FMLT MaterialProcurementProfile
ProfitCenter P_MATVAL_MANAGE_MD_FMLT ProfitCenter
HasProductionVersion P_MATVAL_MANAGE_MD_FMLT HasProductionVersion
AlternativeBillOfMaterial P_MATVAL_MANAGE_MD_FMLT AlternativeBillOfMaterial
BillOfMaterialVariantUsage P_MATVAL_MANAGE_MD_FMLT BillOfMaterialVariantUsage
TaskListGroup P_MATVAL_MANAGE_MD_FMLT TaskListGroup
TaskListGroupCounter P_MATVAL_MANAGE_MD_FMLT TaskListGroupCounter
CostingLotSize P_MATVAL_MANAGE_MD_FMLT CostingLotSize
CostingMatProcurementProfile P_MATVAL_MANAGE_MD_FMLT CostingMatProcurementProfile
IsCoProduct P_MATVAL_MANAGE_MD_FMLT IsCoProduct
ComponentScrapInPercent P_MATVAL_MANAGE_MD_FMLT ComponentScrapInPercent
IsBulkMaterial P_MATVAL_MANAGE_MD_FMLT IsBulkMaterial
BillOfOperationsType P_MATVAL_MANAGE_MD_FMLT BillOfOperationsType
CostingProductionVersion P_MATVAL_MANAGE_MD_FMLT CostingProductionVersion
IsFixedPriceCoProduct P_MATVAL_MANAGE_MD_FMLT IsFixedPriceCoProduct
IsBlockedForCosting P_MATVAL_MANAGE_MD_FMLT IsBlockedForCosting
IsMatlOfValnTypeMarkedForDeltn P_MATVAL_MANAGE_MD_FMLT IsMatlOfValnTypeMarkedForDeltn
MaterialUsabilityProfile P_MATVAL_MANAGE_MD_FMLT MaterialUsabilityProfile
MaterialValuationClass P_MATVAL_MANAGE_MD_FMLT MaterialValuationClass
ValuationClassInPrevPeriod P_MATVAL_MANAGE_MD_FMLT ValuationClassInPrevPeriod
ValuationClassInPrevYear P_MATVAL_MANAGE_MD_FMLT ValuationClassInPrevYear
CurrentFiscalYear P_MATVAL_MANAGE_MD_FMLT CurrentFiscalYear
CurrentFiscalPeriod P_MATVAL_MANAGE_MD_FMLT CurrentFiscalPeriod
PreviousFiscalPeriodFiscalYear P_MATVAL_MANAGE_MD_FMLT PreviousFiscalPeriodFiscalYear
PreviousFiscalPeriod P_MATVAL_MANAGE_MD_FMLT PreviousFiscalPeriod
PreviousFiscalYear P_MATVAL_MANAGE_MD_FMLT PreviousFiscalYear
PreviousFiscalYearPeriod P_MATVAL_MANAGE_MD_FMLT PreviousFiscalYearPeriod
InventoryValuationCategory P_MATVAL_MANAGE_MD_FMLT InventoryValuationCategory
PriceLastChangeDate P_MATVAL_MANAGE_MD_FMLT PriceLastChangeDate
TaxPricel1InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT TaxPricel1InCoCodeCrcy
CommercialPrice1InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT CommercialPrice1InCoCodeCrcy
TaxPrice3InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT TaxPrice3InCoCodeCrcy
CommercialPrice3InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT CommercialPrice3InCoCodeCrcy
PlannedPriceInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT PlannedPriceInCoCodeCrcy
PlannedPrice1InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT PlannedPrice1InCoCodeCrcy
PlannedPrice2InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT PlannedPrice2InCoCodeCrcy
PlannedPrice3InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT PlannedPrice3InCoCodeCrcy
FuturePlndPrice1ValdtyDate P_MATVAL_MANAGE_MD_FMLT FuturePlndPrice1ValdtyDate
FuturePlndPrice2ValdtyDate P_MATVAL_MANAGE_MD_FMLT FuturePlndPrice2ValdtyDate
FuturePlndPrice3ValdtyDate P_MATVAL_MANAGE_MD_FMLT FuturePlndPrice3ValdtyDate
HasStdCostEstForFuturePeriod P_MATVAL_MANAGE_MD_FMLT HasStdCostEstForFuturePeriod
HasStdCostEstForCurrentPeriod P_MATVAL_MANAGE_MD_FMLT HasStdCostEstForCurrentPeriod
HasStdCostEstForPreviousPeriod P_MATVAL_MANAGE_MD_FMLT HasStdCostEstForPreviousPeriod
IsLIFOAndFIFORelevant P_MATVAL_MANAGE_MD_FMLT IsLIFOAndFIFORelevant
LIFOValuationPoolNumber P_MATVAL_MANAGE_MD_FMLT LIFOValuationPoolNumber
CommercialPrice2InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT CommercialPrice2InCoCodeCrcy
TaxPrice2InCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT TaxPrice2InCoCodeCrcy
DevaluationYearCount P_MATVAL_MANAGE_MD_FMLT DevaluationYearCount
MaintenanceStatus P_MATVAL_MANAGE_MD_FMLT MaintenanceStatus
FutrCostEstValuationVariant P_MATVAL_MANAGE_MD_FMLT FutrCostEstValuationVariant
CurCostEstValuationVariant P_MATVAL_MANAGE_MD_FMLT CurCostEstValuationVariant
PrevCostEstValuationVariant P_MATVAL_MANAGE_MD_FMLT PrevCostEstValuationVariant
FutureCostEstCostingVersion P_MATVAL_MANAGE_MD_FMLT FutureCostEstCostingVersion
CurrentCostEstCostingVersion P_MATVAL_MANAGE_MD_FMLT CurrentCostEstCostingVersion
PreviousCostEstCostingVersion P_MATVAL_MANAGE_MD_FMLT PreviousCostEstCostingVersion
CostOriginGroup P_MATVAL_MANAGE_MD_FMLT CostOriginGroup
CostingOverheadGroup P_MATVAL_MANAGE_MD_FMLT CostingOverheadGroup
FutureCostEstimateFiscalPeriod P_MATVAL_MANAGE_MD_FMLT FutureCostEstimateFiscalPeriod
CurrentCostEstFiscalPeriod P_MATVAL_MANAGE_MD_FMLT CurrentCostEstFiscalPeriod
PreviousCostEstFiscalPeriod P_MATVAL_MANAGE_MD_FMLT PreviousCostEstFiscalPeriod
FutureCostEstFiscalYear P_MATVAL_MANAGE_MD_FMLT FutureCostEstFiscalYear
CurrentCostEstFiscalYear P_MATVAL_MANAGE_MD_FMLT CurrentCostEstFiscalYear
PreviousCostEstFiscalYear P_MATVAL_MANAGE_MD_FMLT PreviousCostEstFiscalYear
IsMaterialCostedWithQtyStruc P_MATVAL_MANAGE_MD_FMLT IsMaterialCostedWithQtyStruc
PreviousPlanPriceInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT PreviousPlanPriceInCoCodeCrcy
CurrentPlanPriceInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT CurrentPlanPriceInCoCodeCrcy
TotStkValAtSlsPrcInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT TotStkValAtSlsPrcInCoCodeCrcy
IsMaterialRelatedOrigin P_MATVAL_MANAGE_MD_FMLT IsMaterialRelatedOrigin
PhysicalInventoryBlockInd P_MATVAL_MANAGE_MD_FMLT PhysicalInventoryBlockInd
DateOfLastPostedCntUnRstrcdStk P_MATVAL_MANAGE_MD_FMLT DateOfLastPostedCntUnRstrcdStk
InventoryForCycleCountInd P_MATVAL_MANAGE_MD_FMLT InventoryForCycleCountInd
ValuationMargin P_MATVAL_MANAGE_MD_FMLT ValuationMargin
FxdPortnOfPlanPrcInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT FxdPortnOfPlanPrcInCoCodeCrcy
FxdPortOfPrevPlPrcInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT FxdPortOfPrevPlPrcInCoCodeCrcy
FxdPortnOfFutPlPrcInCoCodeCrcy P_MATVAL_MANAGE_MD_FMLT FxdPortnOfFutPlPrcInCoCodeCrcy
CurPlanProjSlsOrdValnStrategy P_MATVAL_MANAGE_MD_FMLT CurPlanProjSlsOrdValnStrategy
PrevPlanProjSlsOrdValnStrategy P_MATVAL_MANAGE_MD_FMLT PrevPlanProjSlsOrdValnStrategy
FutrPlanProjSlsOrdValnStrategy P_MATVAL_MANAGE_MD_FMLT FutrPlanProjSlsOrdValnStrategy
ValuationClassSalesOrderStock P_MATVAL_MANAGE_MD_FMLT ValuationClassSalesOrderStock
ProjectStockValuationClass P_MATVAL_MANAGE_MD_FMLT ProjectStockValuationClass
ProductUsageType P_MATVAL_MANAGE_MD_FMLT ProductUsageType
ProductOriginType P_MATVAL_MANAGE_MD_FMLT ProductOriginType
IsProducedInhouse P_MATVAL_MANAGE_MD_FMLT IsProducedInhouse
ValnIsBsdOnBatchSpecificUnit P_MATVAL_MANAGE_MD_FMLT ValnIsBsdOnBatchSpecificUnit
TaxBasedPricesPriceUnitQty P_MATVAL_MANAGE_MD_FMLT TaxBasedPricesPriceUnitQty
ValnClsForSpclStkAtVndr P_MATVAL_MANAGE_MD_FMLT ValnClsForSpclStkAtVndr
FiscalPeriodEndDate fpi FiscalPeriodEndDate
NextFiscalPeriodStartDate
ControllingValuationType lvcr AccountingValuationView
MaterialName _MaterialText MaterialName
CompanyCodeName _CompanyCode CompanyCodeName
Plant _Plant Plant
PlantName _Plant PlantName
_ControllingArea _CompanyCode _ControllingArea 
@EndUserText.label: 'Current Material Valuations'
@AbapCatalog.sqlViewName: 'IMATVALMANAGEC'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

define view I_CurrentMaterialValuations
  as select from           P_Matval_Manage_Md2            as md
    inner join             R_MatlPriceDataMigrationStatus as tf   on(
        tf.MatlPriceDataMigrationStatus                                                             = 'X'
      )
                                                                  or(
                                                                    tf.MatlPriceDataMigrationStatus = 'R'
                                                                  )
    left outer to one join P_Matval_Manage_Pnv_Pre        as mx   on  mx.CostEstimate                = md.CostEstimate
                                                                  and mx.ValuationArea               = md.ValuationArea
                                                                  and mx.LedgerValuationCurrencyRole = md.LedgerValuationCurrencyRole
                                                                  and mx.period_type                 = 'LF'
    inner join             P_Matval_Manage_Ckml           as ckml on  ckml.CostEstimate                = mx.CostEstimate
                                                                  and ckml.FiscalYearPeriod            = mx.MaxFiscPerCKMLPP
                                                                  and ckml.LedgerValuationCurrencyRole = md.LedgerValuationCurrencyRole
                                                                  and ckml.ValuationArea               = md.ValuationArea
                                                                  and ckml.Material                    = md.Material
    left outer to one join P_Matval_Manage_Bal            as bal  on  bal.CostEstimate  = md.CostEstimate
                                                                  and bal.Ledger        = md.Ledger
                                                                  and bal.period_type   = 'LF'
                                                                  and bal.CompanyCode   = md.CompanyCode
                                                                  and bal.ValuationArea = md.ValuationArea
    left outer to one join I_FiscalYearPeriodForCmpnyCode as fpi  on  fpi.CompanyCode  = md.CompanyCode
                                                                  and fpi.FiscalYear   = md.CurrentFiscalYear
                                                                  and fpi.FiscalPeriod = md.CurrentFiscalPeriod
    left outer to one join R_LedgerValuationCrcyRole      as lvcr on md.LedgerValuationCurrencyRole = lvcr.LedgerValuationCurrencyRole

  association [0..1] to I_CompanyCode  as _CompanyCode  on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_Plant        as _Plant        on  $projection.ValuationArea = _Plant.Plant
  association [0..1] to I_MaterialText as _MaterialText on  $projection.Material   = _MaterialText.Material
                                                        and _MaterialText.Language = $session.system_language
{
  key       md.CostEstimate,
            // replaced keyfield: LedgerValuationCurrencyRole instead of CurrencyRole

            @UI.hidden: true
  key       lvcr.LedgerValuationCurrencyRole,

            // three semantic keyfields representing the UI-hidden _LedgerValuationCrcyRole.LedgerValuationCurrencyRole

            lvcr.LegalCurrencyRole,
            md.Ledger,
            lvcr.AccountingValuationView, //cast ( coalesce( lvcr.AccountingValuationView, '0' ) as fins_valutyp_wo_cogm ) as AccountingValuationView,

            lvcr.AccountingValuationSubview,

            @UI.hidden: true
            lvcr.CurrencyRole,
            lvcr.LegalCurrencyRoleName,
            lvcr.AccountingValuationViewName,
            lvcr.AccountingValuationSubviewName,
            lvcr.AcctgValnVwSubviewCombinedName,
            md.LedgerName,

            md.Material,
            md.ValuationArea,
            md.InventoryValuationType,

            _CompanyCode.ControllingArea,

            ckml.InvtryValnSpecialStockType,
            ckml.SalesOrder,
            ckml.SalesOrderItem,
            ckml.Supplier,
            ckml.WBSElementInternalID,
            ckml.WBSElementExternalID,
            ckml.FuturePrice,
            ckml.FuturePriceValidityStartDate,
            ckml.FuturePlannedPrice,

            cast(coalesce(bal.TotalVltdStockQuantity, 0) as fin_qtyval)         as TotalVltdStockQuantity,
            case md.rcolumn when 'H' then coalesce(cast(bal.AmountInCompanyCodeCurrency as salk3), 0)
                            when 'K' then coalesce(cast(bal.AmountInGroupCurrency as salk3), 0)
                            when 'O' then coalesce(cast(bal.AmountInFreeDefinedCurrency1 as salk3), 0)
                            when 'V' then coalesce(cast(bal.AmountInFreeDefinedCurrency2 as salk3), 0)
                            when 'B' then coalesce(cast(bal.AmountInFreeDefinedCurrency3 as salk3), 0)
                            when 'C' then coalesce(cast(bal.AmountInFreeDefinedCurrency4 as salk3), 0)
                            when 'D' then coalesce(cast(bal.AmountInFreeDefinedCurrency5 as salk3), 0)
                            when 'E' then coalesce(cast(bal.AmountInFreeDefinedCurrency6 as salk3), 0)
                            when 'F' then coalesce(cast(bal.AmountInFreeDefinedCurrency7 as salk3), 0)
                            when 'G' then coalesce(cast(bal.AmountInFreeDefinedCurrency8 as salk3), 0)
                            else cast(0 as salk3)
            end                                                                 as TotalValuatedStockAmount,

            cast (coalesce(bal.AmountInCompanyCodeCurrency, 0) as fins_vhcur12) as AmountInCompanyCodeCurrency,

            ckml.MaterialPriceControl,
            ckml.PriceDeterminationControl,
            ckml.MovingAveragePrice,
            ckml.StandardPrice,
            ckml.MaterialPriceUnitQty,

            md.CompanyCode,
            md.Currency,
            md.CompanyCodeCurrency,

            md.BaseUnit,
            md.ValuationQuantityUnit,
            md.MaterialGroup,
            md.MaterialType,

            md.PlntMatlIsMarkedForDeletion,
            md.AssemblyScrapPercent,
            md.MaterialProcurementCategory,
            md.MaterialProcurementProfile,
            md.ProfitCenter,
            md.HasProductionVersion,
            md.AlternativeBillOfMaterial,
            md.BillOfMaterialVariantUsage,
            md.TaskListGroup,
            md.TaskListGroupCounter,
            md.CostingLotSize,
            md.CostingMatProcurementProfile,
            md.IsCoProduct,
            md.ComponentScrapInPercent,
            md.IsBulkMaterial,
            md.BillOfOperationsType,
            md.CostingProductionVersion,
            md.IsFixedPriceCoProduct,
            md.IsBlockedForCosting,
            md.IsMatlOfValnTypeMarkedForDeltn,
            md.MaterialUsabilityProfile,
            md.MaterialValuationClass,
            md.ValuationClassInPrevPeriod,
            md.ValuationClassInPrevYear,
            md.CurrentFiscalYear,
            md.CurrentFiscalPeriod,
            md.PreviousFiscalPeriodFiscalYear,
            md.PreviousFiscalPeriod,
            md.PreviousFiscalYear,
            md.PreviousFiscalYearPeriod,
            md.InventoryValuationCategory,
            md.PriceLastChangeDate,
            //            md.FuturePriceInCoCodeCrcy,

            //            md.FuturePriceValidityStartDate,

            md.TaxPricel1InCoCodeCrcy,
            md.CommercialPrice1InCoCodeCrcy,
            md.TaxPrice3InCoCodeCrcy,
            md.CommercialPrice3InCoCodeCrcy,
            md.PlannedPriceInCoCodeCrcy,
            md.PlannedPrice1InCoCodeCrcy,
            md.PlannedPrice2InCoCodeCrcy,
            md.PlannedPrice3InCoCodeCrcy,
            md.FuturePlndPrice1ValdtyDate,
            md.FuturePlndPrice2ValdtyDate,
            md.FuturePlndPrice3ValdtyDate,
            md.HasStdCostEstForFuturePeriod,
            md.HasStdCostEstForCurrentPeriod,
            md.HasStdCostEstForPreviousPeriod,
            md.IsLIFOAndFIFORelevant,
            md.LIFOValuationPoolNumber,
            md.CommercialPrice2InCoCodeCrcy,
            md.TaxPrice2InCoCodeCrcy,
            md.DevaluationYearCount,
            md.MaintenanceStatus,
            md.FutrCostEstValuationVariant,
            md.CurCostEstValuationVariant,
            md.PrevCostEstValuationVariant,
            md.FutureCostEstCostingVersion,
            md.CurrentCostEstCostingVersion,
            md.PreviousCostEstCostingVersion,
            md.CostOriginGroup,
            md.CostingOverheadGroup,
            md.FutureCostEstimateFiscalPeriod,
            md.CurrentCostEstFiscalPeriod,
            md.PreviousCostEstFiscalPeriod,
            md.FutureCostEstFiscalYear,
            md.CurrentCostEstFiscalYear,
            md.PreviousCostEstFiscalYear,
            md.IsMaterialCostedWithQtyStruc,
            md.PreviousPlanPriceInCoCodeCrcy,
            md.CurrentPlanPriceInCoCodeCrcy,
            md.TotStkValAtSlsPrcInCoCodeCrcy,
            md.IsMaterialRelatedOrigin,
            md.PhysicalInventoryBlockInd,
            md.DateOfLastPostedCntUnRstrcdStk,
            md.InventoryForCycleCountInd,
            md.ValuationMargin,
            md.FxdPortnOfPlanPrcInCoCodeCrcy,
            md.FxdPortOfPrevPlPrcInCoCodeCrcy,
            md.FxdPortnOfFutPlPrcInCoCodeCrcy,
            md.CurPlanProjSlsOrdValnStrategy,
            md.PrevPlanProjSlsOrdValnStrategy,
            md.FutrPlanProjSlsOrdValnStrategy,
            md.ValuationClassSalesOrderStock,
            md.ProjectStockValuationClass,
            md.ProductUsageType,
            md.ProductOriginType,
            md.IsProducedInhouse,
            md.ValnIsBsdOnBatchSpecificUnit,
            md.TaxBasedPricesPriceUnitQty,
            md.ValnClsForSpclStkAtVndr,
            //            md.IsPrepaidInvtryMatValnTypeSgmt,


            fpi.FiscalPeriodEndDate,
            DATS_ADD_DAYS(fpi.FiscalPeriodEndDate, 1, 'INITIAL')                as NextFiscalPeriodStartDate,

            lvcr.AccountingValuationView                                        as ControllingValuationType,

            @Semantics.text: true
            _MaterialText.MaterialName,

            @Semantics.text: true
            _CompanyCode.CompanyCodeName,

            @ObjectModel.text.element: 'PlantName'
            _Plant.Plant,
            @Semantics.text: true
            _Plant.PlantName,

            // associations

            _CompanyCode._ControllingArea
            //            _FiscalPeriodStartDate

}

union all // for split-valuated materials add the header segment


select from              P_Matval_Manage_Md2            as md
  inner join             R_MatlPriceDataMigrationStatus as tf   on(
      tf.MatlPriceDataMigrationStatus                                                             = 'X'
    )
                                                                or(
                                                                  tf.MatlPriceDataMigrationStatus = 'R'
                                                                )
  left outer join        P_Matval_Manage_Pnv_Pre        as mx   on  mx.CostEstimate                = md.CostEstimate
                                                                and mx.ValuationArea               = md.ValuationArea
                                                                and mx.LedgerValuationCurrencyRole = md.LedgerValuationCurrencyRole
                                                                and mx.period_type                 = 'LF'
  left outer join        P_Matval_Manage_Ckml           as ckml on  ckml.CostEstimate                = md.CostEstimate
                                                                and ckml.LedgerValuationCurrencyRole = md.LedgerValuationCurrencyRole
                                                                and ckml.ValuationArea               = md.ValuationArea
                                                                and ckml.Material                    = md.Material
  left outer join        P_Matval_Manage_Bal_Split      as bal  on  bal.CostEstimate  = md.CostEstimate
                                                                and bal.Ledger        = md.Ledger
                                                                and bal.period_type   = 'LF'
                                                                and bal.CompanyCode   = md.CompanyCode
                                                                and bal.ValuationArea = md.ValuationArea
  left outer to one join I_FiscalYearPeriodForCmpnyCode as fpi  on  fpi.CompanyCode  = md.CompanyCode
                                                                and fpi.FiscalYear   = md.CurrentFiscalYear
                                                                and fpi.FiscalPeriod = md.CurrentFiscalPeriod
  left outer to one join R_LedgerValuationCrcyRole      as lvcr on md.LedgerValuationCurrencyRole = lvcr.LedgerValuationCurrencyRole

association [0..1] to I_CompanyCode  as _CompanyCode  on  $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_Plant        as _Plant        on  $projection.ValuationArea = _Plant.Plant
association [0..1] to I_MaterialText as _MaterialText on  $projection.Material   = _MaterialText.Material
                                                      and _MaterialText.Language = $session.system_language
{
  key       md.CostEstimate,
            @UI.hidden: true
  key       lvcr.LedgerValuationCurrencyRole,

            // four semantic keyfields representing the UI-hidden _LedgerValuationCrcyRole.LedgerValuationCurrencyRole

            lvcr.LegalCurrencyRole,
            md.Ledger,
            lvcr.AccountingValuationView,
            lvcr.AccountingValuationSubview,

            lvcr.CurrencyRole,
            lvcr.LegalCurrencyRoleName,
            lvcr.AccountingValuationViewName,
            lvcr.AccountingValuationSubviewName,
            lvcr.AcctgValnVwSubviewCombinedName,
            md.LedgerName,

            md.Material,
            md.ValuationArea,
            md.InventoryValuationType,

            _CompanyCode.ControllingArea,

            ckml.InvtryValnSpecialStockType,
            ckml.SalesOrder,
            ckml.SalesOrderItem,
            ckml.Supplier,
            ckml.WBSElementInternalID,
            ckml.WBSElementExternalID,
            ckml.FuturePrice,
            ckml.FuturePriceValidityStartDate,
            ckml.FuturePlannedPrice,

            coalesce(bal.TotalVltdStockQuantity, 0)                             as TotalVltdStockQuantity,
            case md.rcolumn when 'H' then coalesce(cast(bal.AmountInCompanyCodeCurrency as salk3), 0)
                            when 'K' then coalesce(cast(bal.AmountInGroupCurrency as salk3), 0)
                            when 'O' then coalesce(cast(bal.AmountInFreeDefinedCurrency1 as salk3), 0)
                            when 'V' then coalesce(cast(bal.AmountInFreeDefinedCurrency2 as salk3), 0)
                            when 'B' then coalesce(cast(bal.AmountInFreeDefinedCurrency3 as salk3), 0)
                            when 'C' then coalesce(cast(bal.AmountInFreeDefinedCurrency4 as salk3), 0)
                            when 'D' then coalesce(cast(bal.AmountInFreeDefinedCurrency5 as salk3), 0)
                            when 'E' then coalesce(cast(bal.AmountInFreeDefinedCurrency6 as salk3), 0)
                            when 'F' then coalesce(cast(bal.AmountInFreeDefinedCurrency7 as salk3), 0)
                            when 'G' then coalesce(cast(bal.AmountInFreeDefinedCurrency8 as salk3), 0)
                            else cast(0 as salk3)
            end                                                                 as TotalValuatedStockAmount,

            cast (coalesce(bal.AmountInCompanyCodeCurrency, 0) as fins_vhcur12) as AmountInCompanyCodeCurrency,

            ckml.MaterialPriceControl,
            ckml.PriceDeterminationControl,
            ckml.MovingAveragePrice,
            ckml.StandardPrice,
            ckml.MaterialPriceUnitQty,

            md.CompanyCode,
            md.Currency,
            md.CompanyCodeCurrency,

            md.BaseUnit,
            md.ValuationQuantityUnit,
            md.MaterialGroup,
            md.MaterialType,

            md.PlntMatlIsMarkedForDeletion,
            md.AssemblyScrapPercent,
            md.MaterialProcurementCategory,
            md.MaterialProcurementProfile,
            md.ProfitCenter,
            md.HasProductionVersion,
            md.AlternativeBillOfMaterial,
            md.BillOfMaterialVariantUsage,
            md.TaskListGroup,
            md.TaskListGroupCounter,
            md.CostingLotSize,
            md.CostingMatProcurementProfile,
            md.IsCoProduct,
            md.ComponentScrapInPercent,
            md.IsBulkMaterial,
            md.BillOfOperationsType,
            md.CostingProductionVersion,
            md.IsFixedPriceCoProduct,
            md.IsBlockedForCosting,
            md.IsMatlOfValnTypeMarkedForDeltn,
            md.MaterialUsabilityProfile,
            md.MaterialValuationClass,
            md.ValuationClassInPrevPeriod,
            md.ValuationClassInPrevYear,
            md.CurrentFiscalYear,
            md.CurrentFiscalPeriod,
            md.PreviousFiscalPeriodFiscalYear,
            md.PreviousFiscalPeriod,
            md.PreviousFiscalYear,
            md.PreviousFiscalYearPeriod,
            md.InventoryValuationCategory,
            md.PriceLastChangeDate,
            //            md.FuturePriceInCoCodeCrcy,

            //            md.FuturePriceValidityStartDate,

            md.TaxPricel1InCoCodeCrcy,
            md.CommercialPrice1InCoCodeCrcy,
            md.TaxPrice3InCoCodeCrcy,
            md.CommercialPrice3InCoCodeCrcy,
            md.PlannedPriceInCoCodeCrcy,
            md.PlannedPrice1InCoCodeCrcy,
            md.PlannedPrice2InCoCodeCrcy,
            md.PlannedPrice3InCoCodeCrcy,
            md.FuturePlndPrice1ValdtyDate,
            md.FuturePlndPrice2ValdtyDate,
            md.FuturePlndPrice3ValdtyDate,
            md.HasStdCostEstForFuturePeriod,
            md.HasStdCostEstForCurrentPeriod,
            md.HasStdCostEstForPreviousPeriod,
            md.IsLIFOAndFIFORelevant,
            md.LIFOValuationPoolNumber,
            md.CommercialPrice2InCoCodeCrcy,
            md.TaxPrice2InCoCodeCrcy,
            md.DevaluationYearCount,
            md.MaintenanceStatus,
            md.FutrCostEstValuationVariant,
            md.CurCostEstValuationVariant,
            md.PrevCostEstValuationVariant,
            md.FutureCostEstCostingVersion,
            md.CurrentCostEstCostingVersion,
            md.PreviousCostEstCostingVersion,
            md.CostOriginGroup,
            md.CostingOverheadGroup,
            md.FutureCostEstimateFiscalPeriod,
            md.CurrentCostEstFiscalPeriod,
            md.PreviousCostEstFiscalPeriod,
            md.FutureCostEstFiscalYear,
            md.CurrentCostEstFiscalYear,
            md.PreviousCostEstFiscalYear,
            md.IsMaterialCostedWithQtyStruc,
            md.PreviousPlanPriceInCoCodeCrcy,
            md.CurrentPlanPriceInCoCodeCrcy,
            md.TotStkValAtSlsPrcInCoCodeCrcy,
            md.IsMaterialRelatedOrigin,
            md.PhysicalInventoryBlockInd,
            md.DateOfLastPostedCntUnRstrcdStk,
            md.InventoryForCycleCountInd,
            md.ValuationMargin,
            md.FxdPortnOfPlanPrcInCoCodeCrcy,
            md.FxdPortOfPrevPlPrcInCoCodeCrcy,
            md.FxdPortnOfFutPlPrcInCoCodeCrcy,
            md.CurPlanProjSlsOrdValnStrategy,
            md.PrevPlanProjSlsOrdValnStrategy,
            md.FutrPlanProjSlsOrdValnStrategy,
            md.ValuationClassSalesOrderStock,
            md.ProjectStockValuationClass,
            md.ProductUsageType,
            md.ProductOriginType,
            md.IsProducedInhouse,
            md.ValnIsBsdOnBatchSpecificUnit,
            md.TaxBasedPricesPriceUnitQty,
            md.ValnClsForSpclStkAtVndr,

            fpi.FiscalPeriodEndDate,
            DATS_ADD_DAYS(fpi.FiscalPeriodEndDate, 1, 'INITIAL')                as NextFiscalPeriodStartDate,

            lvcr.AccountingValuationView                                        as ControllingValuationType,

            @Semantics.text: true
            _MaterialText.MaterialName,

            @Semantics.text: true
            _CompanyCode.CompanyCodeName,

            @ObjectModel.text.element: 'PlantName'
            _Plant.Plant,
            @Semantics.text: true
            _Plant.PlantName,

            // associations

            _CompanyCode._ControllingArea
            //            _FiscalPeriodStartDate

}
where
  (
        md.InventoryValuationType  =  ''
    and InventoryValuationCategory <> ''
  )


union all select from    P_MATVAL_MANAGE_MD_FMLT        as md
  inner join             R_MatlPriceDataMigrationStatus as tf    on(
       tf.MatlPriceDataMigrationStatus = 'F'
     )
  left outer to one join I_MaterialLedgerPrice          as INVPR on  md.CostEstimate                      = INVPR.CostEstimate
                                                                 and md.Ledger                            = INVPR.Ledger
                                                                 and md.CurrencyRole                      = INVPR.CurrencyRole
                                                                 and md.CompanyCode                       = INVPR.CompanyCode
                                                                 and md.ValuationArea                     = INVPR.ValuationArea
                                                                 and INVPR.MaterialPriceType              = 'INVPR'
                                                                 and INVPR.MaterialPriceSubtype           = ''
                                                                 and INVPR.MatlPrcValdtyEndFsclYearPeriod = '9999012'
                                                                 and INVPR.Material                       = md.Material
                                                                 and INVPR.CompanyCode                    = md.CompanyCode
                                                                 and INVPR.ValuationArea                  = md.ValuationArea
  left outer to one join R_MatlLedgerValnCrcyRole       as lvcr  on  md.Ledger       = lvcr.Ledger
                                                                 and md.CurrencyRole = lvcr.CurrencyRole
                                                                 and md.CompanyCode  = lvcr.CompanyCode
  left outer to one join P_Matval_Manage_Baltab         as bal   on  bal.CostEstimate  = INVPR.CostEstimate
                                                                 and bal.Ledger        = INVPR.Ledger
                                                                 and bal.CompanyCode   = INVPR.CompanyCode
                                                                 and bal.ValuationArea = INVPR.ValuationArea
                                                                 and bal.Material      = INVPR.Material
                                                                 and bal.period_type   = 'LF'
  left outer to one join I_FiscalYearPeriodForLedger    as fpi   on  fpi.CompanyCode  = md.CompanyCode
                                                                 and fpi.Ledger       = md.Ledger
                                                                 and fpi.FiscalYear   = md.CurrentFiscalYear
                                                                 and fpi.FiscalPeriod = md.CurrentFiscalPeriod
  left outer to one join I_Plant                        as plt   on plt.ValuationArea = md.ValuationArea

association [0..1] to I_MaterialLedgerPrice as _STDPR        on  _STDPR.CostEstimate                   = md.CostEstimate
                                                             and _STDPR.Ledger                         = md.Ledger
                                                             and _STDPR.CurrencyRole                   = md.CurrencyRole
                                                             and _STDPR.MaterialPriceType              = 'STDPR'
                                                             and _STDPR.MaterialPriceSubtype           = ''
                                                             and _STDPR.MatlPrcValdtyEndFsclYearPeriod = '9999012'
                                                             and _STDPR.Material                       = md.Material
                                                             and _STDPR.CompanyCode                    = md.CompanyCode
                                                             and _STDPR.ValuationArea                  = md.ValuationArea

association [0..1] to I_MaterialLedgerPrice as _ACT          on  _ACT.CostEstimate                   = md.CostEstimate
                                                             and _ACT.CurrencyRole                   = md.CurrencyRole
                                                             and _ACT.Ledger                         = md.Ledger
                                                             and _ACT.MaterialPriceType              = 'ACT'
                                                             and _ACT.MaterialPriceSubtype           = 'ACT'
                                                             and _ACT.MatlPrcValdtyEndFsclYearPeriod = '9999012'
                                                             and _ACT.Material                       = md.Material
                                                             and _ACT.CompanyCode                    = md.CompanyCode
                                                             and _ACT.ValuationArea                  = md.ValuationArea

association [0..1] to I_MaterialLedgerPrice as _MAP          on  _MAP.CostEstimate                   = md.CostEstimate
                                                             and _MAP.CurrencyRole                   = md.CurrencyRole
                                                             and _MAP.Ledger                         = md.Ledger
                                                             and _MAP.MaterialPriceType              = 'MAP'
                                                             and _MAP.MaterialPriceSubtype           = ''
                                                             and _MAP.MatlPrcValdtyEndFsclYearPeriod = '9999012'
                                                             and _MAP.Material                       = md.Material
                                                             and _MAP.Material                       = md.Material
                                                             and _MAP.CompanyCode                    = md.CompanyCode
                                                             and _MAP.ValuationArea                  = md.ValuationArea

association [0..1] to I_MaterialLedgerPrice as _FSTDCE       on  _FSTDCE.CostEstimate                   = md.CostEstimate
                                                             and _FSTDCE.CurrencyRole                   = md.CurrencyRole
                                                             and _FSTDCE.Ledger                         = md.Ledger
                                                             and _FSTDCE.MaterialPriceType              = 'FSTDCE'
                                                             and _FSTDCE.MaterialPriceSubtype           = ''
//                                                             and _FSTDCE.MatlPrcValdtyEndFsclYearPeriod = '9999012'

                                                             and _FSTDCE.Material                       = md.Material
                                                             and _FSTDCE.Material                       = md.Material
                                                             and _FSTDCE.CompanyCode                    = md.CompanyCode
                                                             and _FSTDCE.ValuationArea                  = md.ValuationArea
                                                             and _FSTDCE.MatlPrcValidityStartFiscalYear = md.CurrentFiscalYear
                                                             and _FSTDCE.MatlPrcValdtyStartFiscalPeriod = md.CurrentFiscalPeriod

association [0..1] to I_CompanyCode         as _CompanyCode  on  $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_MaterialText        as _MaterialText on  $projection.Material   = _MaterialText.Material
                                                             and _MaterialText.Language = $session.system_language
{
  key       md.CostEstimate,
            @UI.hidden: true
  key       lvcr.LedgerValuationCurrencyRole,

            lvcr.LegalCurrencyRole,
            lvcr.Ledger,
            lvcr.AccountingValuationView,
            lvcr.AccountingValuationSubview,

            @UI.hidden: true
            lvcr.CurrencyRole,
            lvcr.LegalCurrencyRoleName,
            lvcr.AccountingValuationViewName,
            lvcr.AccountingValuationSubviewName,
            lvcr.AcctgValnVwSubviewCombinedName,
            lvcr.LedgerName,

            md.Material,
            md.ValuationArea,
            md.InventoryValuationType,

            _CompanyCode.ControllingArea,

            md.InvtryValnSpecialStockType,
            md.SalesOrder,
            md.SalesOrderItem,
            md.Supplier,
            md.WBSElementInternalID,
            md.WBSElementExternalID,
            md.FuturePrice,
            md.FuturePriceValidityStartDate,
            _FSTDCE.MaterialPrice                                               as FuturePlannedPrice,

            cast(coalesce(bal.TotalVltdStockQuantity, 0) as fin_qtyval)         as TotalVltdStockQuantity,
            case lvcr.JrnlEntrItemCrcyRolePosition
                            when 'H' then coalesce(cast(bal.AmountInCompanyCodeCurrency as salk3), 0)
                            when 'K' then coalesce(cast(bal.AmountInGroupCurrency as salk3), 0)
                            when 'O' then coalesce(cast(bal.AmountInFreeDefinedCurrency1 as salk3), 0)
                            when 'V' then coalesce(cast(bal.AmountInFreeDefinedCurrency2 as salk3), 0)
                            when 'B' then coalesce(cast(bal.AmountInFreeDefinedCurrency3 as salk3), 0)
                            when 'C' then coalesce(cast(bal.AmountInFreeDefinedCurrency4 as salk3), 0)
                            when 'D' then coalesce(cast(bal.AmountInFreeDefinedCurrency5 as salk3), 0)
                            when 'E' then coalesce(cast(bal.AmountInFreeDefinedCurrency6 as salk3), 0)
                            when 'F' then coalesce(cast(bal.AmountInFreeDefinedCurrency7 as salk3), 0)
                            when 'G' then coalesce(cast(bal.AmountInFreeDefinedCurrency8 as salk3), 0)
                            else cast(0 as salk3)
            end                                                                 as TotalValuatedStockAmount,

            cast (coalesce(bal.AmountInCompanyCodeCurrency, 0) as fins_vhcur12) as AmountInCompanyCodeCurrency,

            INVPR.MaterialPriceControl,
            md.PriceDeterminationControl,
            case INVPR.MaterialPriceControl
              when 'S'
                  then case md.PriceDeterminationControl
                      when '2' then coalesce(_MAP.MaterialPrice,0)
                      when '3' then coalesce(_ACT.MaterialPrice,0)
                  end
              when 'V'
                  then coalesce(INVPR.MaterialPrice,0)
              end                                                               as MovingAveragePrice,

            case INVPR.MaterialPriceControl
              when 'S' then coalesce(INVPR.MaterialPrice,0)
              else coalesce(_STDPR.MaterialPrice,0)
              end                                                               as StandardPrice,
            md.MaterialPriceUnitQty,
            md.CompanyCode,
            lvcr.Currency,
            cast(_CompanyCode.Currency as fis_hwaer)                            as CompanyCodeCurrency,

            md.BaseUnit,
            md.ValuationQuantityUnit,
            md.MaterialGroup,
            md.MaterialType,

            md.PlntMatlIsMarkedForDeletion,
            md.AssemblyScrapPercent,
            md.MaterialProcurementCategory,
            md.MaterialProcurementProfile,
            md.ProfitCenter,
            md.HasProductionVersion,
            md.AlternativeBillOfMaterial,
            md.BillOfMaterialVariantUsage,
            md.TaskListGroup,
            md.TaskListGroupCounter,
            md.CostingLotSize,
            md.CostingMatProcurementProfile,
            md.IsCoProduct,
            md.ComponentScrapInPercent,
            md.IsBulkMaterial,
            md.BillOfOperationsType,
            md.CostingProductionVersion,
            md.IsFixedPriceCoProduct,
            md.IsBlockedForCosting,
            md.IsMatlOfValnTypeMarkedForDeltn,
            md.MaterialUsabilityProfile,
            md.MaterialValuationClass,
            md.ValuationClassInPrevPeriod,
            md.ValuationClassInPrevYear,
            md.CurrentFiscalYear,
            md.CurrentFiscalPeriod,
            md.PreviousFiscalPeriodFiscalYear,
            md.PreviousFiscalPeriod,
            md.PreviousFiscalYear,
            md.PreviousFiscalYearPeriod,
            md.InventoryValuationCategory,
            md.PriceLastChangeDate,
            md.TaxPricel1InCoCodeCrcy,
            md.CommercialPrice1InCoCodeCrcy,
            md.TaxPrice3InCoCodeCrcy,
            md.CommercialPrice3InCoCodeCrcy,
            md.PlannedPriceInCoCodeCrcy,
            md.PlannedPrice1InCoCodeCrcy,
            md.PlannedPrice2InCoCodeCrcy,
            md.PlannedPrice3InCoCodeCrcy,
            md.FuturePlndPrice1ValdtyDate,
            md.FuturePlndPrice2ValdtyDate,
            md.FuturePlndPrice3ValdtyDate,
            md.HasStdCostEstForFuturePeriod,
            md.HasStdCostEstForCurrentPeriod,
            md.HasStdCostEstForPreviousPeriod,
            md.IsLIFOAndFIFORelevant,
            md.LIFOValuationPoolNumber,
            md.CommercialPrice2InCoCodeCrcy,
            md.TaxPrice2InCoCodeCrcy,
            md.DevaluationYearCount,
            md.MaintenanceStatus,
            md.FutrCostEstValuationVariant,
            md.CurCostEstValuationVariant,
            md.PrevCostEstValuationVariant,
            md.FutureCostEstCostingVersion,
            md.CurrentCostEstCostingVersion,
            md.PreviousCostEstCostingVersion,
            md.CostOriginGroup,
            md.CostingOverheadGroup,
            md.FutureCostEstimateFiscalPeriod,
            md.CurrentCostEstFiscalPeriod,
            md.PreviousCostEstFiscalPeriod,
            md.FutureCostEstFiscalYear,
            md.CurrentCostEstFiscalYear,
            md.PreviousCostEstFiscalYear,
            md.IsMaterialCostedWithQtyStruc,
            md.PreviousPlanPriceInCoCodeCrcy,
            md.CurrentPlanPriceInCoCodeCrcy,
            md.TotStkValAtSlsPrcInCoCodeCrcy,
            md.IsMaterialRelatedOrigin,
            md.PhysicalInventoryBlockInd,
            md.DateOfLastPostedCntUnRstrcdStk,
            md.InventoryForCycleCountInd,
            md.ValuationMargin,
            md.FxdPortnOfPlanPrcInCoCodeCrcy,
            md.FxdPortOfPrevPlPrcInCoCodeCrcy,
            md.FxdPortnOfFutPlPrcInCoCodeCrcy,
            md.CurPlanProjSlsOrdValnStrategy,
            md.PrevPlanProjSlsOrdValnStrategy,
            md.FutrPlanProjSlsOrdValnStrategy,
            md.ValuationClassSalesOrderStock,
            md.ProjectStockValuationClass,
            md.ProductUsageType,
            md.ProductOriginType,
            md.IsProducedInhouse,
            md.ValnIsBsdOnBatchSpecificUnit,
            md.TaxBasedPricesPriceUnitQty,
            md.ValnClsForSpclStkAtVndr,

            fpi.FiscalPeriodEndDate,
            DATS_ADD_DAYS(fpi.FiscalPeriodEndDate, 1, 'INITIAL')                as NextFiscalPeriodStartDate,

            lvcr.AccountingValuationView                                        as ControllingValuationType,

            @Semantics.text: true
            _MaterialText.MaterialName,

            @Semantics.text: true
            _CompanyCode.CompanyCodeName,

            @ObjectModel.text.element: 'PlantName'
            plt.Plant,
            @Semantics.text: true
            plt.PlantName,

            // associations

            _CompanyCode._ControllingArea
}
where
        md.InventoryValuationType     <> ''
  or(
        md.InventoryValuationType     =  ''
    and md.InventoryValuationCategory =  ''
  )


union all select from    P_MATVAL_MANAGE_MD_FMLT        as md
  inner join             R_MatlPriceDataMigrationStatus as tf    on(
       tf.MatlPriceDataMigrationStatus = 'F'
     )
  left outer to one join I_MaterialLedgerPrice          as INVPR on  md.CostEstimate                      = INVPR.CostEstimate
                                                                 and md.Ledger                            = INVPR.Ledger
                                                                 and md.CurrencyRole                      = INVPR.CurrencyRole
                                                                 and md.CompanyCode                       = INVPR.CompanyCode
                                                                 and md.ValuationArea                     = INVPR.ValuationArea
                                                                 and INVPR.MaterialPriceType              = 'INVPR'
                                                                 and INVPR.MaterialPriceSubtype           = ''
                                                                 and INVPR.MatlPrcValdtyEndFsclYearPeriod = '9999012'
                                                                 and INVPR.Material                       = md.Material
                                                                 and INVPR.CompanyCode                    = md.CompanyCode
                                                                 and INVPR.ValuationArea                  = md.ValuationArea
  left outer to one join R_MatlLedgerValnCrcyRole       as lvcr  on  md.Ledger       = lvcr.Ledger
                                                                 and md.CurrencyRole = lvcr.CurrencyRole
                                                                 and md.CompanyCode  = lvcr.CompanyCode
  left outer to one join P_Matval_Manage_Bal_Split      as bal   on  bal.CostEstimate  = md.CostEstimate
                                                                 and bal.Ledger        = md.Ledger
                                                                 and bal.CompanyCode   = md.CompanyCode
                                                                 and bal.ValuationArea = md.ValuationArea
                                                                 and bal.Material      = md.Material
                                                                 and bal.period_type   = 'LF'
  left outer to one join I_FiscalYearPeriodForLedger    as fpi   on  fpi.CompanyCode  = md.CompanyCode
                                                                 and fpi.Ledger       = md.Ledger
                                                                 and fpi.FiscalYear   = md.CurrentFiscalYear
                                                                 and fpi.FiscalPeriod = md.CurrentFiscalPeriod
  left outer to one join I_Plant                        as plt   on plt.ValuationArea = md.ValuationArea

association [0..1] to I_MaterialLedgerPrice as _STDPR        on  _STDPR.CostEstimate                   = md.CostEstimate
                                                             and _STDPR.Ledger                         = md.Ledger
                                                             and _STDPR.CurrencyRole                   = md.CurrencyRole
                                                             and _STDPR.MaterialPriceType              = 'STDPR'
                                                             and _STDPR.MaterialPriceSubtype           = ''
                                                             and _STDPR.MatlPrcValdtyEndFsclYearPeriod = '9999012'
                                                             and _STDPR.Material                       = md.Material
                                                             and _STDPR.CompanyCode                    = md.CompanyCode
                                                             and _STDPR.ValuationArea                  = md.ValuationArea

association [0..1] to I_MaterialLedgerPrice as _ACT          on  _ACT.CostEstimate                   = md.CostEstimate
                                                             and _ACT.CurrencyRole                   = md.CurrencyRole
                                                             and _ACT.Ledger                         = md.Ledger
                                                             and _ACT.MaterialPriceType              = 'ACT'
                                                             and _ACT.MaterialPriceSubtype           = 'ACT'
                                                             and _ACT.MatlPrcValdtyEndFsclYearPeriod = '9999012'
                                                             and _ACT.Material                       = md.Material
                                                             and _ACT.CompanyCode                    = md.CompanyCode
                                                             and _ACT.ValuationArea                  = md.ValuationArea

association [0..1] to I_MaterialLedgerPrice as _MAP          on  _MAP.CostEstimate                   = md.CostEstimate
                                                             and _MAP.CurrencyRole                   = md.CurrencyRole
                                                             and _MAP.Ledger                         = md.Ledger
                                                             and _MAP.MaterialPriceType              = 'MAP'
                                                             and _MAP.MaterialPriceSubtype           = ''
                                                             and _MAP.MatlPrcValdtyEndFsclYearPeriod = '9999012'
                                                             and _MAP.Material                       = md.Material
                                                             and _MAP.CompanyCode                    = md.CompanyCode
                                                             and _MAP.ValuationArea                  = md.ValuationArea

association [0..1] to I_MaterialLedgerPrice as _FSTDCE       on  _FSTDCE.CostEstimate                   = md.CostEstimate
                                                             and _FSTDCE.CurrencyRole                   = md.CurrencyRole
                                                             and _FSTDCE.Ledger                         = md.Ledger
                                                             and _FSTDCE.MaterialPriceType              = 'FSTDCE'
                                                             and _FSTDCE.MaterialPriceSubtype           = ''
//                                                             and _FSTDCE.MatlPrcValdtyEndFsclYearPeriod = '9999012'

                                                             and _FSTDCE.Material                       = md.Material
                                                             and _FSTDCE.Material                       = md.Material
                                                             and _FSTDCE.CompanyCode                    = md.CompanyCode
                                                             and _FSTDCE.ValuationArea                  = md.ValuationArea
                                                             and _FSTDCE.MatlPrcValidityStartFiscalYear = md.CurrentFiscalYear
                                                             and _FSTDCE.MatlPrcValdtyStartFiscalPeriod = md.CurrentFiscalPeriod


association [0..1] to I_CompanyCode         as _CompanyCode  on  $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_MaterialText        as _MaterialText on  $projection.Material   = _MaterialText.Material
                                                             and _MaterialText.Language = $session.system_language
{
  key       md.CostEstimate,
            @UI.hidden: true
  key       lvcr.LedgerValuationCurrencyRole,

            lvcr.LegalCurrencyRole,
            lvcr.Ledger,
            lvcr.AccountingValuationView,
            lvcr.AccountingValuationSubview,

            @UI.hidden: true
            lvcr.CurrencyRole,
            lvcr.LegalCurrencyRoleName,
            lvcr.AccountingValuationViewName,
            lvcr.AccountingValuationSubviewName,
            lvcr.AcctgValnVwSubviewCombinedName,
            lvcr.LedgerName,

            md.Material,
            md.ValuationArea,
            md.InventoryValuationType,

            _CompanyCode.ControllingArea,

            md.InvtryValnSpecialStockType,
            md.SalesOrder,
            md.SalesOrderItem,
            md.Supplier,
            md.WBSElementInternalID,        
            md.WBSElementExternalID,
            md.FuturePrice,
            md.FuturePriceValidityStartDate,
            _FSTDCE.MaterialPrice                                               as FuturePlannedPrice,

            cast(coalesce(bal.TotalVltdStockQuantity, 0) as fin_qtyval)         as TotalVltdStockQuantity,
            case lvcr.JrnlEntrItemCrcyRolePosition
                            when 'H' then coalesce(cast(bal.AmountInCompanyCodeCurrency as salk3), 0)
                            when 'K' then coalesce(cast(bal.AmountInGroupCurrency as salk3), 0)
                            when 'O' then coalesce(cast(bal.AmountInFreeDefinedCurrency1 as salk3), 0)
                            when 'V' then coalesce(cast(bal.AmountInFreeDefinedCurrency2 as salk3), 0)
                            when 'B' then coalesce(cast(bal.AmountInFreeDefinedCurrency3 as salk3), 0)
                            when 'C' then coalesce(cast(bal.AmountInFreeDefinedCurrency4 as salk3), 0)
                            when 'D' then coalesce(cast(bal.AmountInFreeDefinedCurrency5 as salk3), 0)
                            when 'E' then coalesce(cast(bal.AmountInFreeDefinedCurrency6 as salk3), 0)
                            when 'F' then coalesce(cast(bal.AmountInFreeDefinedCurrency7 as salk3), 0)
                            when 'G' then coalesce(cast(bal.AmountInFreeDefinedCurrency8 as salk3), 0)
                            else cast(0 as salk3)
            end                                                                 as TotalValuatedStockAmount,

            cast (coalesce(bal.AmountInCompanyCodeCurrency, 0) as fins_vhcur12) as AmountInCompanyCodeCurrency,

            INVPR.MaterialPriceControl,
            md.PriceDeterminationControl,
            case INVPR.MaterialPriceControl
              when 'S'
                  then case md.PriceDeterminationControl
                      when '2' then coalesce(_MAP.MaterialPrice,0)
                      when '3' then coalesce(_ACT.MaterialPrice,0)
                  end
              when 'V'
                  then coalesce(INVPR.MaterialPrice,0)
              end                                                               as MovingAveragePrice,

            case INVPR.MaterialPriceControl
              when 'S' then coalesce(INVPR.MaterialPrice,0)
              else coalesce(_STDPR.MaterialPrice,0)
              end                                                               as StandardPrice,
            md.MaterialPriceUnitQty,
            md.CompanyCode,
            lvcr.Currency,
            cast(_CompanyCode.Currency as fis_hwaer)                            as CompanyCodeCurrency,

            md.BaseUnit,
            md.ValuationQuantityUnit,
            md.MaterialGroup,
            md.MaterialType,

            md.PlntMatlIsMarkedForDeletion,
            md.AssemblyScrapPercent,
            md.MaterialProcurementCategory,
            md.MaterialProcurementProfile,
            md.ProfitCenter,
            md.HasProductionVersion,
            md.AlternativeBillOfMaterial,
            md.BillOfMaterialVariantUsage,
            md.TaskListGroup,
            md.TaskListGroupCounter,
            md.CostingLotSize,
            md.CostingMatProcurementProfile,
            md.IsCoProduct,
            md.ComponentScrapInPercent,
            md.IsBulkMaterial,
            md.BillOfOperationsType,
            md.CostingProductionVersion,
            md.IsFixedPriceCoProduct,
            md.IsBlockedForCosting,
            md.IsMatlOfValnTypeMarkedForDeltn,
            md.MaterialUsabilityProfile,
            md.MaterialValuationClass,
            md.ValuationClassInPrevPeriod,
            md.ValuationClassInPrevYear,
            md.CurrentFiscalYear,
            md.CurrentFiscalPeriod,
            md.PreviousFiscalPeriodFiscalYear,
            md.PreviousFiscalPeriod,
            md.PreviousFiscalYear,
            md.PreviousFiscalYearPeriod,
            md.InventoryValuationCategory,
            md.PriceLastChangeDate,
            md.TaxPricel1InCoCodeCrcy,
            md.CommercialPrice1InCoCodeCrcy,
            md.TaxPrice3InCoCodeCrcy,
            md.CommercialPrice3InCoCodeCrcy,
            md.PlannedPriceInCoCodeCrcy,
            md.PlannedPrice1InCoCodeCrcy,
            md.PlannedPrice2InCoCodeCrcy,
            md.PlannedPrice3InCoCodeCrcy,
            md.FuturePlndPrice1ValdtyDate,
            md.FuturePlndPrice2ValdtyDate,
            md.FuturePlndPrice3ValdtyDate,
            md.HasStdCostEstForFuturePeriod,
            md.HasStdCostEstForCurrentPeriod,
            md.HasStdCostEstForPreviousPeriod,
            md.IsLIFOAndFIFORelevant,
            md.LIFOValuationPoolNumber,
            md.CommercialPrice2InCoCodeCrcy,
            md.TaxPrice2InCoCodeCrcy,
            md.DevaluationYearCount,
            md.MaintenanceStatus,
            md.FutrCostEstValuationVariant,
            md.CurCostEstValuationVariant,
            md.PrevCostEstValuationVariant,
            md.FutureCostEstCostingVersion,
            md.CurrentCostEstCostingVersion,
            md.PreviousCostEstCostingVersion,
            md.CostOriginGroup,
            md.CostingOverheadGroup,
            md.FutureCostEstimateFiscalPeriod,
            md.CurrentCostEstFiscalPeriod,
            md.PreviousCostEstFiscalPeriod,
            md.FutureCostEstFiscalYear,
            md.CurrentCostEstFiscalYear,
            md.PreviousCostEstFiscalYear,
            md.IsMaterialCostedWithQtyStruc,
            md.PreviousPlanPriceInCoCodeCrcy,
            md.CurrentPlanPriceInCoCodeCrcy,
            md.TotStkValAtSlsPrcInCoCodeCrcy,
            md.IsMaterialRelatedOrigin,
            md.PhysicalInventoryBlockInd,
            md.DateOfLastPostedCntUnRstrcdStk,
            md.InventoryForCycleCountInd,
            md.ValuationMargin,
            md.FxdPortnOfPlanPrcInCoCodeCrcy,
            md.FxdPortOfPrevPlPrcInCoCodeCrcy,
            md.FxdPortnOfFutPlPrcInCoCodeCrcy,
            md.CurPlanProjSlsOrdValnStrategy,
            md.PrevPlanProjSlsOrdValnStrategy,
            md.FutrPlanProjSlsOrdValnStrategy,
            md.ValuationClassSalesOrderStock,
            md.ProjectStockValuationClass,
            md.ProductUsageType,
            md.ProductOriginType,
            md.IsProducedInhouse,
            md.ValnIsBsdOnBatchSpecificUnit,
            md.TaxBasedPricesPriceUnitQty,
            md.ValnClsForSpclStkAtVndr,

            fpi.FiscalPeriodEndDate,
            DATS_ADD_DAYS(fpi.FiscalPeriodEndDate, 1, 'INITIAL')                as NextFiscalPeriodStartDate,

            lvcr.AccountingValuationView                                        as ControllingValuationType,

            @Semantics.text: true
            _MaterialText.MaterialName,

            @Semantics.text: true
            _CompanyCode.CompanyCodeName,

            @ObjectModel.text.element: 'PlantName'
            plt.Plant,
            @Semantics.text: true
            plt.PlantName,

            // associations

            _CompanyCode._ControllingArea
}
where
      md.InventoryValuationType     =  ''
  and md.InventoryValuationCategory <> ''

Learn More