P_DMVCGLACCLINEITEMEDGE

CDS View

DMVC: ACDOCA for Edges

P_DMVCGLACCLINEITEMEDGE is a CDS View in S/4HANA. DMVC: ACDOCA for Edges. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DMVCEdgeSemanticTag view from COMPOSITE DMVC: Semantic Tag for Edge 
@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

Learn More