P_MatlLedgerDocumentExtract

DDL: P_MATLLEDGERDOCUMENTEXTRACT Type: view_entity BASIC Package: FCML4H_DISPLAY

Extract of Material Ledger Document

P_MatlLedgerDocumentExtract is a Basic CDS View that provides data about "Extract of Material Ledger Document" in SAP S/4HANA. It reads from 1 data source (mldoc_extract) and exposes 10 fields with key fields CostEstimate, FiscalYearPeriod, ReferenceDocument, CurrencyRole. Part of development package FCML4H_DISPLAY.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
mldoc_extract mldoc_extract from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate kalnr
KEY FiscalYearPeriod
KEY ReferenceDocument docref
KEY CurrencyRole curtp
Ledger rldnr
TotalVltdStockQuantity quant
InvtryTransacAmtInDisplayCrcy stval
SlsPrcAmtInclVATInCoCodeCrcy vkwrt
ValuationQuantityUnit meins
Currency waers 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
    serviceQuality: #A,
    sizeCategory: #L,
    dataClass: #MASTER
}
@VDM: {
  viewType: #BASIC,
  private: true
}
define view entity P_MatlLedgerDocumentExtract
  as select from mldoc_extract

{
  key kalnr                                              as CostEstimate,
  key cast(jahrper as fins_fyearperiod preserving type ) as FiscalYearPeriod,
  key docref                                             as ReferenceDocument,
  key curtp                                              as CurrencyRole,
      rldnr                                              as Ledger,
      @Semantics.quantity.unitOfMeasure: 'ValuationQuantityUnit'
      quant                                              as TotalVltdStockQuantity,
      @Semantics.amount.currencyCode: 'Currency'
      stval                                              as InvtryTransacAmtInDisplayCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      vkwrt                                              as SlsPrcAmtInclVATInCoCodeCrcy,
      meins                                              as ValuationQuantityUnit,
      waers                                              as Currency
}

Learn More