P_MATERIALLEDGERDOCUMENT

CDS View

P_MATERIALLEDGERDOCUMENT is a CDS View in S/4HANA. It contains 4 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 4 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_DACRConsumptions view from COMPOSITE Consumptions for material from MLDOC
P_DACRCostComponentConsumption view inner COMPOSITE Consumptions for cost components in DACR
P_DACRCostComponentReceipts view inner COMPOSITE Receipts for cost components in DACR
P_DACRReceipts view from COMPOSITE Receipts for materials from MLDOC
P_DMVCActivityMaterialPair view from COMPOSITE
P_DMVCOpeningInventory view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CostEstimate CostEstimate 2
FiscalYearPeriod FiscalYearPeriod 2
Ledger Ledger 2
ValuationQuantityUnit ValuationQuantityUnitInternal 1 
@AbapCatalog.sqlViewName: 'PMLDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_MaterialLedgerDocument
  as select from mldoc

{
  key docref,
  key curtp   as LedgerValuationCurrencyRole,
      rldnr   as Ledger,
      runref,
      acc_principle,
      kalnr   as CostEstimate,
      jahrper as FiscalYearPeriod,
      jahrper_wip,
      current_per,
      xabr,
      glvor,
      vgart,
      posart,
      categ,
      ptyp    as ProcessCategory,
      bewartgrp,
      bvalt   as ProcurementAlternative,
      process as ProductionProcess,
      pkalnr,
      @Semantics.quantity.unitOfMeasure: 'ValuationQuantityUnit'
      quant   as ValuationQuantity,
      @Semantics.unitOfMeasure: true
      meins   as ValuationQuantityUnit,
      @Semantics.amount.currencyCode: 'Currency'
      stval   as InventoryAmtInCCCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      prd     as PriceDifferenceAmtInCCCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      kdm     as ExchRateDiffAmtInCoCodeCrcy,
      tpprd,
      altval,
      @Semantics.currencyCode: true
      waers   as Currency,
      lbkum,
      salk3,
      salkv,
      stprs,
      pvprs,
      peinh,
      xekrel,
      xplrel,
      plqty,
      markup,
      xtprel,
      vkwrt,
      vksal,
      eqnum,
      timestamp,
      budat   as PostingDate,
      cyclenr,
      aufnr,
      aufps,
      belnr,
      kjahr,
      posnr,
      awtyp,
      awsys,
      aworg,
      awref,
      awitem,
      awitgrp,
      usnam,
      tcode,
      mlvnr,
      vgabe,
      hrkft,
      kstar,
      bwart,
      werks   as Plant,
      storno,
      bstmg,
      bstme,
      arewr,
      reewr,
      xkdm_nact,
      _dataaging,
      kongr
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MLDOC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More