P_MaterialLedgerHeaderData

DDL: P_MATERIALLEDGERHEADERDATA Type: view_entity BASIC Package: FCML4H_DISPLAY
13 Fields 1 Data Sources 2 Associations

Material Ledger Header Data

P_MaterialLedgerHeaderData is a Basic CDS View that provides data about "Material Ledger Header Data" in SAP S/4HANA. It reads from 1 data source (ckmlhd) and exposes 13 fields with key field CostEstimate. It has 2 associations to related views. Part of development package FCML4H_DISPLAY.

Data Sources (1)

SourceAliasJoin Type
ckmlhd ckmlhd from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
[0..1] I_InventorySpecialStockType _InventorySpecialStockType $projection.InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate kalnr ProdCostEst.No.
Material Vehicle Model
ValuationArea Valuation Area
PriceDeterminationControl mlast Price Determ.
InventoryValuationType Valuation Type
InventorySpecialStockValnType Valuation
SalesOrder SD Sched. Agmt
SalesOrderItem posnr WBS Element
InventorySpecialStockType sobkz Special Stock
InventorySpecialStockTypeName
WBSElementInternalID
Supplier ckmlhd lifnr Vendor no.
_WBSElementBasicData _WBSElementBasicData

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 P_MaterialLedgerHeaderData.
-- 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 P_MaterialLedgerHeaderData AS
SELECT
  kalnr AS CostEstimate,
  cast( matnr as matnr preserving type ) AS Material,
  cast( bwkey as bwkey preserving type ) AS ValuationArea,
  mlast AS PriceDeterminationControl,
  cast( bwtar as bwtar_d preserving type ) AS InventoryValuationType,
  cast( kzbws as kzbws preserving type ) AS InventorySpecialStockValnType,
  cast( vbeln as vbeln preserving type ) AS SalesOrder,
  posnr AS SalesOrderItem,
  sobkz AS InventorySpecialStockType,
  _InventorySpecialStockType._Text[1: Language = $session.system_language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  cast( ckmlhd.pspnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  ckmlhd.lifnr AS Supplier
FROM ckmlhd
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
;

Learn More