P_MLMaterialHeader

DDL: P_MLMATERIALHEADER SQL: PMLMHDR Type: view BASIC

P_MLMaterialHeader is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (ckmlhd) and exposes 18 fields with key field CostEstimate. It has 1 association to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
ckmlhd ckmlhd from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMLMHDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.private true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate kalnr
mlast mlast
xabrech xabrech
abrechdat abrechdat
xabrerr xabrerr
abrechuhr abrechuhr
Material matnr
ValuationArea bwkey
InventoryValuationType bwtar
kzbws kzbws
xobew xobew
sobkz sobkz
vbeln vbeln
posnr posnr
pspnr pspnr
Supplier lifnr
aexterrind aexterrind
_Supplier _Supplier 
@AbapCatalog.sqlViewName: 'PMLMHDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #BASIC
@VDM.private:true
define view P_MLMaterialHeader
  as select from ckmlhd

  association [1..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier

{
  key kalnr as CostEstimate,
      mlast,
      xabrech,
      abrechdat,
      xabrerr,
      abrechuhr,
      matnr as Material,
      bwkey as ValuationArea,
      bwtar as InventoryValuationType,
      kzbws,
      xobew,
      sobkz,
      vbeln,
      posnr,
      pspnr,
      lifnr as Supplier,
      aexterrind,
      matdoc_aexterrind,
      
      _Supplier
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CKMLHD"
],
"ASSOCIATED":
[
"I_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More