I_MatlValnSemKeyMappg

DDL: I_MATLVALNSEMKEYMAPPG Type: view_entity BASIC Package: FINS_ML_VDM
12 Fields 1 Data Sources

Material Valuation Semantic Key Mapping

I_MatlValnSemKeyMappg is a Basic CDS View that provides data about "Material Valuation Semantic Key Mapping" in SAP S/4HANA. It reads from 1 data source (P_CKMLHD) and exposes 12 fields with key field CostEstimate. Part of development package FINS_ML_VDM.

Data Sources (1)

SourceAliasJoin Type
P_CKMLHD P_CKMLHD from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Material Valuation Semantic Key Mapping view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate kalnr ProdCostEst.No.
PriceDeterminationControl mlast Price Determ.
Material matnr Vehicle Model
ValuationArea bwkey Valuation Area
InventoryValuationType bwtar Valuation Type
InventorySpecialStockValnType kzbws Valuation
IsSupplierStockValuation xobew Vendor stk val.
InventorySpecialStockType sobkz Special Stock
SalesOrder vbeln SD Sched. Agmt
SalesOrderItem posnr WBS Element
WBSElementInternalID WBS Element
Supplier lifnr Vendor no.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MatlValnSemKeyMappg.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_MatlValnSemKeyMappg AS
SELECT
  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
FROM P_CKMLHD
;

Learn More