P_MLDocumentExtract

DDL: P_MLDOCUMENTEXTRACT SQL: PMLDOCXTRCTR Type: view BASIC

P_MLDocumentExtract is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (mldoc_extract) and exposes 9 fields with key fields CostEstimate, FiscalYearPeriod, docref, LedgerValuationCurrencyRole.

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