C_AR_StRpJrnlEntrDocSelection

DDL: C_AR_STRPJRNLENTRDOCSELECTION SQL: CARJOURNALENTRY Type: view CONSUMPTION

Argentina Journal Ledger Document Selection for Reporting

C_AR_StRpJrnlEntrDocSelection is a Consumption CDS View that provides data about "Argentina Journal Ledger Document Selection for Reporting" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 5 fields with key fields CompanyCode, FiscalYear, AccountingDocument.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem JournalEntryItem inner

Parameters (1)

NameTypeDefault
P_Ledger fins_ledger

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CARJOURNALENTRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Argentina Journal Ledger Document Selection for Reporting view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode JournalEntry CompanyCode
KEY FiscalYear JournalEntry FiscalYear
KEY AccountingDocument JournalEntry AccountingDocument
AccountingDocumentCategory JournalEntry AccountingDocumentCategory
PostingDate JournalEntry PostingDate 
@AbapCatalog.sqlViewName: 'CARJOURNALENTRY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Argentina Journal Ledger Document Selection for Reporting'
define view C_AR_StRpJrnlEntrDocSelection
  with parameters
    P_Ledger : fins_ledger
  as select distinct from I_JournalEntry as JournalEntry

    inner join   I_JournalEntryItem as JournalEntryItem on  JournalEntryItem.CompanyCode        = JournalEntry.CompanyCode
                                                        and JournalEntryItem.FiscalYear         = JournalEntry.FiscalYear
                                                        and JournalEntryItem.AccountingDocument = JournalEntry.AccountingDocument
                                                        and JournalEntryItem.SourceLedger       = $parameters.P_Ledger
                                                        and JournalEntryItem.Ledger             = $parameters.P_Ledger

{

  key JournalEntry.CompanyCode,
  key JournalEntry.FiscalYear,
  key JournalEntry.AccountingDocument,
      JournalEntry.AccountingDocumentCategory,
      JournalEntry.PostingDate,
      cast(
        case
          when JournalEntry.TaxReportingDate = '00000000' then JournalEntry.PostingDate
          when JournalEntry.TaxReportingDate <> '00000000' then JournalEntry.TaxReportingDate
        end
      as glo_reporting_date preserving type ) as ReportingDate

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_JOURNALENTRYITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More