C_GB_StRpParkedDocTxItmBoxCube

DDL: C_GB_STRPPARKEDDOCTXITMBOXCUBE SQL: CGBSRPARKEDITEMS Type: view CONSUMPTION

Parked Items for Statutory Reporting

C_GB_StRpParkedDocTxItmBoxCube is a Consumption CDS View (Cube) that provides data about "Parked Items for Statutory Reporting" in SAP S/4HANA. It reads from 1 data source (I_StRpJournalEntryLog) and exposes 47 fields with key fields CompanyCode, AccountingDocument, FiscalYear, StatryRptgEntity, StatryRptCategory.

1 data source(s) 47 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpJournalEntryLog stl left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CGBSRPARKEDITEMS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Parked Items for Statutory Reporting view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.allowExtensions true view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode pti CompanyCode
KEY AccountingDocument pti AccountingDocument
KEY FiscalYear pti FiscalYear
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID
KEY TaxCode pti TaxCode
KEY TaxBox pti TaxBox
KEY TaxDeclnAmountType pti TaxDeclnAmountType
KEY ValidFrom pti ValidFrom
AccountingDocumentHeaderText pti AccountingDocumentHeaderText
AccountingDocumentType pti AccountingDocumentType
AdditionalCurrency1 pti AdditionalCurrency1
AdditionalCurrency2 pti AdditionalCurrency2
AmountInAdditionalCurrency1 pti AmountInAdditionalCurrency1
AmountInAdditionalCurrency2 pti AmountInAdditionalCurrency2
AmountInReportingCurrency pti AmountInReportingCurrency
AmountInTransactionCurrency pti AmountInTransactionCurrency
BusinessPartner pti BusinessPartner
BusinessPlace pti BusinessPlace
CompanyCodeCountry pti CompanyCodeCountry
CompanyCodeCurrency pti CompanyCodeCurrency
CountryCurrency pti CountryCurrency
DocumentCurrency pti DocumentCurrency
DocumentDate pti DocumentDate
DocumentReferenceID pti DocumentReferenceID
FiscalPeriod pti FiscalPeriod
GLAccount pti GLAccount
PostingDate pti PostingDate
ReportingCountry pti ReportingCountry
ReportingCurrency pti ReportingCurrency
TargetTaxCode pti TargetTaxCode
TaxAmountInAdditionalCurrency1 pti TaxAmountInAdditionalCurrency1
TaxAmountInAdditionalCurrency2 pti TaxAmountInAdditionalCurrency2
TaxAmountInCoCodeCrcy pti TaxAmountInCoCodeCrcy
TaxAmountInRptgCrcy pti TaxAmountInRptgCrcy
TaxBaseAmountInCoCodeCrcy pti TaxBaseAmountInCoCodeCrcy
TaxBaseAmountInRptgCrcy pti TaxBaseAmountInRptgCrcy
TaxBaseAmountInTransCrcy pti TaxBaseAmountInTransCrcy
TaxBaseAmtInAdditionalCrcy1 pti TaxBaseAmtInAdditionalCrcy1
TaxBaseAmtInAdditionalCrcy2 pti TaxBaseAmtInAdditionalCrcy2
TaxCalculationProcedure pti TaxCalculationProcedure
TaxJurisdiction pti TaxJurisdiction
TaxReportingDate pti TaxReportingDate
TaxReturnCountry pti TaxReturnCountry
TaxType pti TaxType
NetDueDate pti NetDueDate 
@AbapCatalog.sqlViewName: 'CGBSRPARKEDITEMS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Parked Items for Statutory Reporting'
@VDM.viewType: #CONSUMPTION
@Analytics: { dataCategory: #CUBE }
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@Metadata.allowExtensions:true



define view C_GB_StRpParkedDocTxItmBoxCube


  as select distinct from    P_GB_ParkedTaxItems     as pti
    left outer join I_StRpJournalEntryLog as stl on  stl.AccountingDocument = pti.AccountingDocument
                                                 and stl.CompanyCode        = pti.CompanyCode
                                                 and stl.FiscalYear         = pti.FiscalYear

{

  key    pti.CompanyCode,
  key    pti.AccountingDocument,
  key    pti.FiscalYear,
//  key    pti.ParkedAccountingDocumentItem,

  key    stl.StatryRptgEntity,
  key    stl.StatryRptCategory,
  key    stl.StatryRptRunID,
  key    pti.TaxCode,
  key    pti.TaxBox,
  key    pti.TaxDeclnAmountType,
  key    pti.ValidFrom,


         pti.AccountingDocumentHeaderText,
         pti.AccountingDocumentType,
         
         @Semantics.currencyCode:true
         pti.AdditionalCurrency1,
         
         @Semantics.currencyCode:true
         pti.AdditionalCurrency2,

         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'AdditionalCurrency1'
         pti.AmountInAdditionalCurrency1,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'AdditionalCurrency2'
         pti.AmountInAdditionalCurrency2,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'ReportingCurrency'
         pti.AmountInReportingCurrency,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'ReportingCurrency'
         pti.AmountInTransactionCurrency,
         
         pti.BusinessPartner,
         

         cast(case DATS_IS_VALID(pti.TaxReportingDate)
                    when 1 then
                       pti.TaxReportingDate
                    else
                       pti.DocumentDate
                    end as glo_reporting_date ) as ReportingDate,

         pti.BusinessPlace,
         pti.CompanyCodeCountry,
         
         @Semantics.currencyCode:true
         pti.CompanyCodeCurrency,
         
         @Semantics.currencyCode:true
         pti.CountryCurrency,
         
         @Semantics.currencyCode:true
         pti.DocumentCurrency,
         
         pti.DocumentDate,
         pti.DocumentReferenceID,
//         pti.ExchangeRate,

         pti.FiscalPeriod,
         pti.GLAccount,

         pti.PostingDate,
         pti.ReportingCountry,
         
         @Semantics.currencyCode:true
         pti.ReportingCurrency,
         
         pti.TargetTaxCode,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'AdditionalCurrency1'
         pti.TaxAmountInAdditionalCurrency1,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'AdditionalCurrency2'
         pti.TaxAmountInAdditionalCurrency2,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
         pti.TaxAmountInCoCodeCrcy,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'ReportingCurrency'
         pti.TaxAmountInRptgCrcy,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
         pti.TaxBaseAmountInCoCodeCrcy,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'ReportingCurrency'
         pti.TaxBaseAmountInRptgCrcy,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'DocumentCurrency'
         pti.TaxBaseAmountInTransCrcy,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'AdditionalCurrency1'
         pti.TaxBaseAmtInAdditionalCrcy1,
         
         @DefaultAggregation:#SUM
         @Semantics.amount.currencyCode: 'AdditionalCurrency2'
         pti.TaxBaseAmtInAdditionalCrcy2,
         
         pti.TaxCalculationProcedure,
         pti.TaxJurisdiction,
         pti.TaxReportingDate,
         pti.TaxReturnCountry,
         pti.TaxType,
         pti.NetDueDate


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

Learn More