P_AR_CashJournalEntry

DDL: P_AR_CASHJOURNALENTRY Type: view_entity COMPOSITE Package: GLO_FIN_IS_AR_CASH_JOURNAL

Argentina Cash Journal Accounts Selection

P_AR_CashJournalEntry is a Composite CDS View that provides data about "Argentina Cash Journal Accounts Selection" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountInCompanyCode, I_GLAccountLineItemRawData) and exposes 9 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. Part of development package GLO_FIN_IS_AR_CASH_JOURNAL.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_GLAccountInCompanyCode GLCashFlowRelAcct from
I_GLAccountLineItemRawData LineItem inner

Parameters (3)

NameTypeDefault
P_Ledger fins_ledger
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger
KEY CompanyCode
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem
GLAccount
IsReversal I_GLAccountLineItemRawData IsReversal
IsReversed I_GLAccountLineItemRawData IsReversed
ReversalReferenceDocument I_GLAccountLineItemRawData ReversalReferenceDocument 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_AR_CashJournalEntry
  with parameters
    @EndUserText.label: 'Ledger'
    P_Ledger          : fins_ledger,
    @EndUserText.label: 'From Posting Date'
    P_FromPostingDate : fis_budat_from,
    @EndUserText.label: 'To Posting Date'
    P_ToPostingDate   : fis_budat_to

  as select from I_GLAccountInCompanyCode   as GLCashFlowRelAcct

    inner join   I_GLAccountLineItemRawData as LineItem on  LineItem.SourceLedger = $parameters.P_Ledger
                                                        and LineItem.CompanyCode  = GLCashFlowRelAcct.CompanyCode
                                                        and LineItem.PostingDate  >= $parameters.P_FromPostingDate
                                                        and LineItem.PostingDate  <= $parameters.P_ToPostingDate
                                                        and LineItem.GLAccount    = GLCashFlowRelAcct.GLAccount

{
  key    cast( LineItem.SourceLedger as fins_ledger_pers preserving type )  as SourceLedger,
  key    cast( GLCashFlowRelAcct.CompanyCode as fis_bukrs preserving type ) as CompanyCode,
  key    LineItem.FiscalYear,
  key    LineItem.AccountingDocument,
  key    LineItem.LedgerGLLineItem,
         cast( GLCashFlowRelAcct.GLAccount as fis_saknr preserving type )   as GLAccount,
         LineItem.IsReversal,
         LineItem.IsReversed,
         LineItem.ReversalReferenceDocument
}
where
  GLCashFlowRelAcct.IsCashFlowAccount = 'X'

Learn More