C_GB_StRpParkedDocTxItmBoxCube

DDL: C_GB_STRPPARKEDDOCTXITMBOXCUBE SQL: CGBSRPARKEDITEMS Type: view CONSUMPTION
47 Fields 1 Data Sources

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.

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 Receiver Company Code
KEY AccountingDocument pti AccountingDocument Journal Entry
KEY FiscalYear pti FiscalYear G/L Fiscal Year
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID Report Run ID
KEY TaxCode pti TaxCode Tax Code
KEY TaxBox pti TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType pti TaxDeclnAmountType
KEY ValidFrom pti ValidFrom Vers.Valid From
AccountingDocumentHeaderText pti AccountingDocumentHeaderText Doc.Header Text
AccountingDocumentType pti AccountingDocumentType Journal Entry Type
AdditionalCurrency1 pti AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 pti AdditionalCurrency2 Local curr. 3
AmountInAdditionalCurrency1 pti AmountInAdditionalCurrency1 Amount in Additional Currency 1
AmountInAdditionalCurrency2 pti AmountInAdditionalCurrency2 LC2 Amount
AmountInReportingCurrency pti AmountInReportingCurrency
AmountInTransactionCurrency pti AmountInTransactionCurrency Pt Crcy Amt
BusinessPartner pti BusinessPartner Issuing Authority
BusinessPlace pti BusinessPlace Business place
CompanyCodeCountry pti CompanyCodeCountry Reporting Ctry/Reg.
CompanyCodeCurrency pti CompanyCodeCurrency Local Currency
CountryCurrency pti CountryCurrency Currency
DocumentCurrency pti DocumentCurrency Document Currency
DocumentDate pti DocumentDate Journal Entry Date
DocumentReferenceID pti DocumentReferenceID Reference
FiscalPeriod pti FiscalPeriod Tax period
GLAccount pti GLAccount General Ledger
PostingDate pti PostingDate Posting Date for GR
ReportingCountry pti ReportingCountry
ReportingCurrency pti ReportingCurrency Currency
TargetTaxCode pti TargetTaxCode
TaxAmountInAdditionalCurrency1 pti TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 pti TaxAmountInAdditionalCurrency2 LC 3 Tax
TaxAmountInCoCodeCrcy pti TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxAmountInRptgCrcy pti TaxAmountInRptgCrcy Tax Rept. Crcy
TaxBaseAmountInCoCodeCrcy pti TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxBaseAmountInRptgCrcy pti TaxBaseAmountInRptgCrcy Base Amount
TaxBaseAmountInTransCrcy pti TaxBaseAmountInTransCrcy Value-Added Tax
TaxBaseAmtInAdditionalCrcy1 pti TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 pti TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxCalculationProcedure pti TaxCalculationProcedure Tax Procedure
TaxJurisdiction pti TaxJurisdiction Tax Jurisdiction
TaxReportingDate pti TaxReportingDate Tax Reporting Date
TaxReturnCountry pti TaxReturnCountry Reporting C/R
TaxType pti TaxType Tax Type
NetDueDate pti NetDueDate Net Due Date

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_GB_StRpParkedDocTxItmBoxCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CGBSRPARKEDITEMS

CREATE VIEW C_GB_StRpParkedDocTxItmBoxCube AS
SELECT
  pti.CompanyCode AS CompanyCode,
  pti.AccountingDocument AS AccountingDocument,
  pti.FiscalYear AS FiscalYear,
  stl.StatryRptgEntity AS StatryRptgEntity,
  stl.StatryRptCategory AS StatryRptCategory,
  stl.StatryRptRunID AS StatryRptRunID,
  pti.TaxCode AS TaxCode,
  pti.TaxBox AS TaxBox,
  pti.TaxDeclnAmountType AS TaxDeclnAmountType,
  pti.ValidFrom AS ValidFrom,
  pti.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  pti.AccountingDocumentType AS AccountingDocumentType,
  pti.AdditionalCurrency1 AS AdditionalCurrency1,
  pti.AdditionalCurrency2 AS AdditionalCurrency2,
  pti.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  pti.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  pti.AmountInReportingCurrency AS AmountInReportingCurrency,
  pti.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  pti.BusinessPartner AS BusinessPartner,
  pti.BusinessPlace AS BusinessPlace,
  pti.CompanyCodeCountry AS CompanyCodeCountry,
  pti.CompanyCodeCurrency AS CompanyCodeCurrency,
  pti.CountryCurrency AS CountryCurrency,
  pti.DocumentCurrency AS DocumentCurrency,
  pti.DocumentDate AS DocumentDate,
  pti.DocumentReferenceID AS DocumentReferenceID,
  pti.FiscalPeriod AS FiscalPeriod,
  pti.GLAccount AS GLAccount,
  pti.PostingDate AS PostingDate,
  pti.ReportingCountry AS ReportingCountry,
  pti.ReportingCurrency AS ReportingCurrency,
  pti.TargetTaxCode AS TargetTaxCode,
  pti.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  pti.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  pti.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  pti.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  pti.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  pti.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  pti.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  pti.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  pti.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  pti.TaxCalculationProcedure AS TaxCalculationProcedure,
  pti.TaxJurisdiction AS TaxJurisdiction,
  pti.TaxReportingDate AS TaxReportingDate,
  pti.TaxReturnCountry AS TaxReturnCountry,
  pti.TaxType AS TaxType,
  pti.NetDueDate AS NetDueDate
LEFT OUTER JOIN I_StRpJournalEntryLog AS stl ON /* join condition not captured in parsed metadata */
;

Learn More