I_MATLVALNSEMKEYMAPPG

CDS View

Material Valuation Semantic Key Mapping

I_MATLVALNSEMKEYMAPPG is a CDS View in S/4HANA. Material Valuation Semantic Key Mapping. It contains 11 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 11 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_MaterialValuationBatchVH view from COMPOSITE Inventory Valuation Batch Value Help
P_CURRENTMATLVALNPRICE view_entity inner COMPOSITE Material Valuation Prices - Current/Previous/PrevYear Period
P_CURRENTMATLVALNPRICEDEX view_entity inner COMPOSITE Material Valuation Prices - Current/Previous/PrevYear Period
P_Matval_Manage_Ckml view_entity left_outer COMPOSITE Base View for Mat.Val., CKML* tables
R_InventoryPriceByKeyDate view_entity inner COMPOSITE Inventory Price by key date

Fields (11)

KeyField CDS FieldsUsed in Views
InventorySpecialStockType InventorySpecialStockType,InvtryValnSpecialStockType 3
InventorySpecialStockValnType InventorySpecialStockValnType 4
InventoryValuationType InventoryValuationType 3
IsSupplierStockValuation IsSupplierStockValuation 3
Material Material 3
PriceDeterminationControl PriceDeterminationControl 4
SalesOrder SalesOrder 4
SalesOrderItem SalesOrderItem 4
Supplier Supplier 4
ValuationArea ValuationArea 3
WBSElementInternalID WBSElementInternalID 3 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED 
@EndUserText.label: 'Material Valuation Semantic Key Mapping'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #M,
  dataClass: #MIXED
}
define view entity I_MatlValnSemKeyMappg 
  as select from P_CKMLHD
{
  key kalnr as CostEstimate,
      mlast as PriceDeterminationControl,
      matnr as Material,
      bwkey as ValuationArea,
      bwtar as InventoryValuationType,
      kzbws as InventorySpecialStockValnType,
      xobew as IsSupplierStockValuation,
      sobkz as InventorySpecialStockType,
      vbeln as SalesOrder,
      posnr as SalesOrderItem,
      cast( pspnr as fis_wbsint_no_conv preserving type ) as WBSElementInternalID,
      lifnr as Supplier
 }

Learn More