P_MaterialLedgerDocument

DDL: P_MATERIALLEDGERDOCUMENT SQL: PMLDOC Type: view COMPOSITE Package: ODATA_ML_MATLVCA_DISP

Material Ledger Document

P_MaterialLedgerDocument is a Composite CDS View that provides data about "Material Ledger Document" in SAP S/4HANA. It reads from 1 data source (mldoc) and exposes 70 fields with key fields docref, LedgerValuationCurrencyRole. Part of development package ODATA_ML_MATLVCA_DISP.

1 data source(s) 70 fields

Data Sources (1)

SourceAliasJoin Type
mldoc mldoc from

Annotations (7)

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

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY docref docref
KEY LedgerValuationCurrencyRole curtp
Ledger rldnr
runref runref
CostEstimate kalnr
FiscalYearPeriod jahrper
jahrper_wip jahrper_wip
current_per current_per
xabr xabr
glvor glvor
vgart vgart
posart posart
categ categ
ProcessCategory ptyp
bewartgrp bewartgrp
ProcurementAlternative bvalt
ProductionProcess process
pkalnr pkalnr
ValuationQuantity quant
ValuationQuantityUnit meins
InventoryAmtInCCCrcy stval
PriceDifferenceAmtInCCCrcy prd
ExchRateDiffAmtInCoCodeCrcy kdm
tpprd tpprd
altval altval
Currency waers
lbkum lbkum
salk3 salk3
salkv salkv
stprs stprs
pvprs pvprs
peinh peinh
xekrel xekrel
xplrel xplrel
plqty plqty
markup markup
xtprel xtprel
vkwrt vkwrt
vksal vksal
eqnum eqnum
timestamp timestamp
PostingDate budat
cyclenr cyclenr
aufnr aufnr
aufps aufps
belnr belnr
kjahr kjahr
posnr posnr
awtyp awtyp
awsys awsys
aworg aworg
awref awref
awitem awitem
awitgrp awitgrp
usnam usnam
tcode tcode
mlvnr mlvnr
vgabe vgabe
hrkft hrkft
kstar kstar
bwart bwart
Plant werks
storno storno
bstmg bstmg
bstme bstme
arewr arewr
reewr reewr
xkdm_nact xkdm_nact
_dataaging _dataaging
kongr kongr 
@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