P_DMVCGLAccLineItemEdge

DDL: P_DMVCGLACCLINEITEMEDGE SQL: PGLITMEDGE Type: view COMPOSITE

P_DMVCGLAccLineItemEdge is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_ACDOCA, P_DMVCActivityMaterialEdge) and exposes 6 fields with key fields MaterialValueChainNodeFrom, MaterialValueChainNodeTo, AccountingDocument, LedgerGLLineItem, CompanyCode.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
P_ACDOCA _Acdoca inner
P_DMVCActivityMaterialEdge P_DMVCActivityMaterialEdge from

Parameters (4)

NameTypeDefault
P_DateFrom calendardate
P_DateTo calendardate
P_CurrencyType fins_curtype
P_Ledger fins_ledger

Annotations (7)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MaterialValueChainNodeFrom MaterialValueChainNodeFrom
KEY MaterialValueChainNodeTo MaterialValueChainNodeTo
KEY AccountingDocument P_ACDOCA belnr
KEY LedgerGLLineItem P_ACDOCA docln
KEY CompanyCode P_ACDOCA rbukrs
Currency Currency 
@AbapCatalog.sqlViewName: 'PGLITMEDGE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_DMVCGLAccLineItemEdge
  with parameters
    P_DateFrom     : calendardate,
    P_DateTo       : calendardate,
    P_CurrencyType : fins_curtype,
    P_Ledger       : fins_ledger
  as select from P_DMVCActivityMaterialEdge(P_DateFrom     : $parameters.P_DateFrom, 
                                            P_DateTo       : $parameters.P_DateTo, 
                                            P_CurrencyType : $parameters.P_CurrencyType,
                                            P_Ledger       : $parameters.P_Ledger) as _Edge
                                            
      inner join P_ACDOCA as _Acdoca on ( _Acdoca.kalnr     = _Edge.MaterialValueChainNodeFrom and
                                          _Acdoca.qsprocess = _Edge.MaterialValueChainNodeTo ) 
                                     or ( _Acdoca.kalnr     = _Edge.MaterialValueChainNodeTo and 
                                          _Acdoca.qsprocess = _Edge.MaterialValueChainNodeFrom )
{
  key MaterialValueChainNodeFrom,
  key MaterialValueChainNodeTo,

  key _Acdoca.belnr  as AccountingDocument,
  key _Acdoca.docln  as LedgerGLLineItem,
  key _Acdoca.rbukrs as CompanyCode,
      Currency
}
where
      _Acdoca.budat >= $parameters.P_DateFrom
  and _Acdoca.budat <= $parameters.P_DateTo
  and _Acdoca.rldnr = $parameters.P_Ledger
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ACDOCA",
"P_DMVCACTIVITYMATERIALEDGE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More