P_CL_StRpJrnlEntryItemWithTax

DDL: P_CL_STRPJRNLENTRYITEMWITHTAX Type: view_entity CONSUMPTION Package: GLO_FIN_IS_CL

Journal Entry With Tax Log for Chilean Reports

P_CL_StRpJrnlEntryItemWithTax is a Consumption CDS View that provides data about "Journal Entry With Tax Log for Chilean Reports" in SAP S/4HANA. It reads from 6 data sources and exposes 11 fields with key fields CompanyCode, AccountingDocument, FiscalYear, Ledger, LedgerGLLineItem. Part of development package GLO_FIN_IS_CL.

6 data source(s) 11 fields

Data Sources (6)

SourceAliasJoin Type
I_CompanyCode CompanyCode inner
I_Country Country inner
I_GLAccountLineItemRawData GLAccountLineItem inner
I_JournalEntry JournalEntry from
I_TaxCode TaxCode inner
I_TaxItem TaxItem inner

Annotations (6)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode
KEY AccountingDocument I_JournalEntry AccountingDocument
KEY FiscalYear I_JournalEntry FiscalYear
KEY Ledger I_GLAccountLineItemRawData SourceLedger
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem
FiscalPeriod I_JournalEntry FiscalPeriod
DocumentReferenceID I_JournalEntry DocumentReferenceID
ReverseDocument I_JournalEntry ReverseDocument
IsReversal I_JournalEntry IsReversal
FinancialAccountType I_GLAccountLineItemRawData FinancialAccountType
TaxType I_TaxCode TaxType 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@VDM: {
  private: true,
  viewType: #CONSUMPTION
}
define view entity P_CL_StRpJrnlEntryItemWithTax
  as select from I_JournalEntry  as JournalEntry

    inner join I_GLAccountLineItemRawData as GLAccountLineItem on  GLAccountLineItem.CompanyCode        = JournalEntry.CompanyCode
                                                               and GLAccountLineItem.AccountingDocument = JournalEntry.AccountingDocument
                                                               and GLAccountLineItem.FiscalYear         = JournalEntry.FiscalYear

    inner join I_TaxItem                  as TaxItem           on  TaxItem.CompanyCode        = JournalEntry.CompanyCode
                                                               and TaxItem.AccountingDocument = JournalEntry.AccountingDocument
                                                               and TaxItem.FiscalYear         = JournalEntry.FiscalYear

    inner join I_CompanyCode              as CompanyCode       on CompanyCode.CompanyCode = JournalEntry.CompanyCode

    inner join I_Country                  as Country           on Country.Country = CompanyCode.Country

    inner join I_TaxCode                  as TaxCode           on  TaxCode.TaxCode                 = TaxItem.TaxCode
                                                               and TaxCode.TaxCalculationProcedure = Country.TaxCalculationProcedure
{
  key JournalEntry.CompanyCode,
  key JournalEntry.AccountingDocument,
  key JournalEntry.FiscalYear,
  key GLAccountLineItem.SourceLedger as Ledger,
  key GLAccountLineItem.LedgerGLLineItem,
   
      cast(
        case
          when JournalEntry.TaxReportingDate = '00000000'
            then JournalEntry.PostingDate
          else JournalEntry.TaxReportingDate
        end
      as glo_reporting_date ) as ReportingDate,      

      JournalEntry.FiscalPeriod,
      JournalEntry.DocumentReferenceID,
      JournalEntry.ReverseDocument,
      JournalEntry.IsReversal,
      GLAccountLineItem.FinancialAccountType,
      TaxCode.TaxType
}

Learn More