P_MaterialLedgerHeaderData

DDL: P_MATERIALLEDGERHEADERDATA Type: view_entity BASIC Package: FCML4H_DISPLAY

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.

1 data source(s) 13 fields

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
Material
ValuationArea
PriceDeterminationControl mlast
InventoryValuationType
InventorySpecialStockValnType
SalesOrder
SalesOrderItem posnr
InventorySpecialStockType sobkz
InventorySpecialStockTypeName
WBSElementInternalID
Supplier ckmlhd lifnr
_WBSElementBasicData _WBSElementBasicData 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
    serviceQuality: #A,
    sizeCategory: #L,
    dataClass: #MASTER
}
@VDM: {
  viewType: #BASIC,
  private: true
}
define view entity P_MaterialLedgerHeaderData
  as select from ckmlhd
  association [0..1] to I_WBSElementBasicData       as _WBSElementBasicData       on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
  association [0..1] to I_InventorySpecialStockType as _InventorySpecialStockType on $projection.InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType
{
  key 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,

      _WBSElementBasicData
}

Learn More