P_MATVAL_MANAGE_MD2

CDS View

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

Used by 3 CDS view(s) 8 fields

CDS Views using this table (3)

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

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ValuationArea ValuationArea 1
BaseUnit BaseUnit 1
CompanyCode CompanyCode 1
Currency Currency 1
InventoryValuationCategory InventoryValuationCategory 1
InventoryValuationType InventoryValuationType 1
Material Material 1
ValuationQuantityUnit ValuationQuantityUnit 1 
@AbapCatalog.sqlViewName: 'PMATVALMGMMD2'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_Matval_Manage_Md2
  as select from P_Matval_Manage_Md           as md
    inner join   I_CompanyCode                as cc             on  cc.CompanyCode = md.CompanyCode
    inner join   I_Ledger                     as _LeadingLedger on _LeadingLedger.IsLeadingLedger = 'X'
    inner join   I_MatlLedgerValnCrcyRoleName as mlcurr         on mlcurr.CompanyCode = md.CompanyCode

{
  key   CostEstimate,
  key   mlcurr.LedgerValuationCurrencyRole,
  key   Material,
  key   md.ValuationArea,  
  key   InventoryValuationType,
  
        InvtryValnSpecialStockType,
        SalesOrder,
        SalesOrderItem,
        Supplier,
        md.WBSElementInternalID,
        md.WBSElement,

        md.CompanyCode,

        // currency information

        mlcurr.Currency,
        cast(cc.Currency as fis_hwaer) as CompanyCodeCurrency,
        mlcurr.Ledger,
        mlcurr.LedgerName,
        mlcurr.JrnlEntrItemCrcyRolePosition as rcolumn,

        // MARA fields

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

        // Valuation UOM for Catch Weight Management

        md.ValuationQuantityUnit,
        md./cwm/xcwmat,

        // MARC fields

        md.PlntMatlIsMarkedForDeletion,
        md.MaterialUsabilityProfile,
        //        md.mmstd,

        md.AssemblyScrapPercent,
        md.MaterialProcurementCategory,
        md.MaterialProcurementProfile,
        md.ProfitCenter,
        md.HasProductionVersion,
        md.AlternativeBillOfMaterial,
        md.BillOfMaterialVariantUsage,
        md.TaskListGroup,
        md.TaskListGroupCounter,
        md.CostingLotSize,
        md.CostingMatProcurementProfile,
        md.ComponentScrapInPercent,
        md.IsCoProduct,
        //        md.awsls,

        //        md.stdpd,

        md.IsBulkMaterial,
        md.BillOfOperationsType,
        md.CostingProductionVersion,
        md.IsFixedPriceCoProduct,
        md.IsBlockedForCosting,

        IsMatlOfValnTypeMarkedForDeltn,
        MaterialValuationClass,
        ValuationClassInPrevPeriod,
        ValuationClassInPrevYear,
        md.CurrentFiscalYear,
        md.CurrentFiscalPeriod,
        md.PreviousFiscalPeriodFiscalYear,
        md.PreviousFiscalPeriod,
        md.PreviousFiscalYear,
        md.PreviousFiscalYearPeriod,
        InventoryValuationCategory,
        PriceLastChangeDate,
        //      mb.timestamp, ???

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

        ValnClsForSpclStkAtVndr,

        _LeadingLedger.Ledger                as LeadingLedger,
        md.mlmaa
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_LEDGER",
"I_MATLLEDGERVALNCRCYROLENAME",
"P_MATVAL_MANAGE_MD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More