P_MATERIALLEDGERDOCUMENT

CDS View

Material Ledger Document

P_MATERIALLEDGERDOCUMENT is a CDS View in S/4HANA. Material Ledger Document. It contains 30 fields. 13 CDS views read from this table.

Used by 13 CDS view(s) 30 fields

CDS Views using this table (13)

ViewTypeJoinVDMDescription
P_ActlCostRsltActyClsgBase view_entity inner COMPOSITE Actual Costing Run Result Closing Line for Activity
P_ActlCostRsltActySettlmtDta view_entity inner COMPOSITE Actual Costing Run Result Settlement Data
P_ActlCostRsltActyTranBase view_entity inner COMPOSITE Actual Costing Run Result Transactional Data Base
P_ActlCostRsltActyTranWIP view_entity inner COMPOSITE Actual Costing Run Result Transactional WIP Data
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_DACRMLDOC view_entity from COMPOSITE MLDOC for DACR
P_DACRReceipts view from COMPOSITE Receipts for materials from MLDOC
P_DMVCActivityMaterialPair view from COMPOSITE DMVC: Activity/Material Pair
P_DMVCOpeningInventory view from COMPOSITE DMVC: Opening Inventory Values
P_InvtryTransBsdWithMvt view_entity from COMPOSITE Transactional based inventory with movement
P_InvtryTransBsdWOMvt view_entity from COMPOSITE Transactional based inventory without movement

Fields (30)

KeyField CDS FieldsUsed in Views
KEY aufnr OrderID 4
KEY categ MaterialLedgerCategory 6
KEY ControllingObject ControllingObject 1
KEY CostEstimate CostEstimate 8
KEY CurrencyRole CurrencyRole 1
KEY GLAccount GLAccount 1
KEY kstar GLAccount 1
KEY Ledger Ledger 8
KEY LedgerValuationCurrencyRole CurrencyRole 6
KEY MaterialLedgerCategory MaterialLedgerCategory 1
KEY MatlLdgrDocIsCostingRelevant MatlLdgrDocIsCostingRelevant 1
KEY OrderID OrderID 1
KEY ProcessCategory ProcessCategory 6
KEY ProcurementAlternative ProcurementAlternative 2
KEY ProductionProcess ProductionProcess 6
KEY ValuationArea ValuationArea 1
KEY xabr MatlLdgrDocIsCostingRelevant 6
awitem ReferenceDocumentItem 2
aworg ReferenceDocumentContext 2
awref ReferenceDocument 2
awtyp ReferenceDocumentType 2
Currency Currency 6
ExchRateDiffAmtInCoCodeCrcy ExchRateDiffAmtInCoCodeCrcy 2
FiscalYearPeriod FiscalYearPeriod 5
InventoryAmtInCCCrcy InventoryAmtInCCCrcy 5
PriceDiffAmtInDisplayCrcy PriceDiffAmtInDisplayCrcy 1
PriceDifferenceAmtInCCCrcy PriceDiffAmtInDisplayCrcy,PriceDifferenceAmtInCCCrcy 4
TotalVltdStockQuantity TotalVltdStockQuantity 1
ValuationQuantity TotalVltdStockQuantity,ValuationQuantity 4
ValuationQuantityUnit ValuationQuantityUnit,ValuationQuantityUnitInternal 7 
@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
}

Learn More