P_MLDocumentExtract

DDL: P_MLDOCUMENTEXTRACT SQL: PMLDOCXTRCTR Type: view BASIC Package: ODATA_ML_MATLVCA_DISP

Material Ledger: Document Extract

P_MLDocumentExtract is a Basic CDS View that provides data about "Material Ledger: Document Extract" in SAP S/4HANA. It reads from 1 data source (mldoc_extract) and exposes 9 fields with key fields CostEstimate, FiscalYearPeriod, docref, LedgerValuationCurrencyRole. Part of development package ODATA_ML_MATLVCA_DISP.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
mldoc_extract mldoc_extract from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMLDOCXTRCTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate kalnr
KEY FiscalYearPeriod jahrper
KEY docref docref
KEY LedgerValuationCurrencyRole curtp
quant quant
stval stval
vkwrt vkwrt
QuantityUnit meins
Currency waers 
@AbapCatalog.sqlViewName: 'PMLDOCXTRCTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #BASIC
@VDM.private:true
define view P_MLDocumentExtract
  as select from mldoc_extract

{
  key kalnr   as CostEstimate,
  key jahrper as FiscalYearPeriod,
  key docref,
  key curtp   as LedgerValuationCurrencyRole,
      
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      quant,
      
      @Semantics.amount.currencyCode: 'Currency'
      stval,
      
      @Semantics.amount.currencyCode: 'Currency'
      vkwrt,
      
      @Semantics.unitOfMeasure: true
      meins   as QuantityUnit,
      
      @Semantics.currencyCode: true
      waers   as Currency
}

Learn More