P_InvtryLdgrMatlLedgerDocument

DDL: P_INVTRYLDGRMATLLEDGERDOCUMENT Type: view_entity COMPOSITE Package: FCML4H_DISPLAY

Material Ledger Document for Inventory Ledger

P_InvtryLdgrMatlLedgerDocument is a Composite CDS View that provides data about "Material Ledger Document for Inventory Ledger" in SAP S/4HANA. It reads from 1 data source (mldoc) and exposes 26 fields with key fields ReferenceDocument, CurrencyRole. Part of development package FCML4H_DISPLAY.

Data Sources (1)

SourceAliasJoin Type
mldoc mldoc from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ReferenceDocument docref
KEY CurrencyRole curtp
Ledger rldnr
CostingRunReference runref
CostEstimate kalnr
FiscalYearPeriod
MatlLdgrDocIsCostingRelevant xabr
MaterialLedgerCategory categ
ProcessCategory ptyp
MaterialLedgerItemType posart
ProcurementAlternative bvalt
ProductionProcess process
TotalVltdStockQuantity quant
ValuationQuantityUnit meins
InventoryAmtInCCCrcy stval
PriceDiffAmtInDisplayCrcy prd
ExchRateDiffAmtInDspCurrency kdm
Currency waers
PostingDate budat
Plant werks
SourceReferenceDocument awref
ReferenceDocumentContext aworg
ReferenceDocumentItem awitem
RefBusinessTransactionType glvor
GoodsMovementType bwart
CostElement kstar
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
    serviceQuality: #A,
    sizeCategory: #XXL,
    dataClass: #MIXED
}
@VDM: {
  viewType: #COMPOSITE,
  private: true
}
define view entity P_InvtryLdgrMatlLedgerDocument
  as select from mldoc

{
  key docref                                              as ReferenceDocument,
  key curtp                                               as CurrencyRole,
      rldnr                                               as Ledger,
      runref                                              as CostingRunReference,
      kalnr                                               as CostEstimate,
      cast(jahrper as fml_yearper_nconv preserving type ) as FiscalYearPeriod,
      xabr                                                as MatlLdgrDocIsCostingRelevant,
      categ                                               as MaterialLedgerCategory,
      ptyp                                                as ProcessCategory,
      posart                                              as MaterialLedgerItemType,
      bvalt                                               as ProcurementAlternative,
      process                                             as ProductionProcess,
      @Semantics.quantity.unitOfMeasure: 'ValuationQuantityUnit'
      quant                                               as TotalVltdStockQuantity,
      meins                                               as ValuationQuantityUnit,
      @Semantics.amount.currencyCode: 'Currency'
      stval                                               as InventoryAmtInCCCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      prd                                                 as PriceDiffAmtInDisplayCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      kdm                                                 as ExchRateDiffAmtInDspCurrency,
      waers                                               as Currency,
      budat                                               as PostingDate,
      werks                                               as Plant,
      awref                                               as SourceReferenceDocument,
      aworg                                               as ReferenceDocumentContext,
      awitem                                              as ReferenceDocumentItem,
      glvor                                               as RefBusinessTransactionType,
      bwart                                               as GoodsMovementType,
      kstar                                               as CostElement
}