P_GB_StRpRCTaxItemBoxCube

DDL: P_GB_STRPRCTAXITEMBOXCUBE SQL: PGBSRRCTAXITMBOX Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_GB
52 Fields 1 Data Sources

VAT Tax Item box level reporting for Reverse Charge

P_GB_StRpRCTaxItemBoxCube is a Consumption CDS View that provides data about "VAT Tax Item box level reporting for Reverse Charge" in SAP S/4HANA. It reads from 1 data source (I_StRpTaxItemLog) and exposes 52 fields with key fields CompanyCode, AccountingDocument, FiscalYear, StatryRptgEntity, StatryRptCategory. Part of development package GLO_FIN_IS_VAT_GB.

Data Sources (1)

SourceAliasJoin Type
I_StRpTaxItemLog I_StRpTaxItemLog from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PGBSRRCTAXITMBOX view
EndUserText.label VAT Tax Item box level reporting for Reverse Charge view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED 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

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpTaxItemLog CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpTaxItemLog AccountingDocument Journal Entry
KEY FiscalYear I_StRpTaxItemLog FiscalYear G/L Fiscal Year
KEY StatryRptgEntity I_StRpTaxItemLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpTaxItemLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpTaxItemLog StatryRptRunID Report Run ID
KEY TaxCode I_StRpTaxItemLog TaxCode Tax Code
KEY TransactionTypeDetermination I_StRpTaxItemLog TransactionTypeDetermination Transaction Key
KEY TaxBox I_StRpTaxItemLog TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType I_StRpTaxItemLog TaxDeclnAmountType
KEY TaxItemGroupingVersion I_StRpTaxItemLog TaxItemGroupingVersion Tax Grping Ver.
KEY ValidFrom ValidFrom Vers.Valid From
KEY TaxBoxStructureType TaxBoxStructureType
KEY TaxGroup TaxGroup Tax Group
TaxBoxConfiguration TaxBoxConfiguration
PostingDate I_StRpTaxItemLog PostingDate Posting Date for GR
DocumentDate I_StRpTaxItemLog DocumentDate Journal Entry Date
TaxReportingDate I_StRpTaxItemLog TaxReportingDate Tax Reporting Date
FiscalPeriod I_StRpTaxItemLog FiscalPeriod Tax period
ReportingDate
AccountingDocumentType I_StRpTaxItemLog AccountingDocumentType Journal Entry Type
DocumentReferenceID DocumentReferenceID Reference
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry ReportingCountry
TaxReturnCountry TaxReturnCountry Reporting C/R
ExchangeRate ExchangeRate Exchange rate
TaxRate TaxRate Tax Rate
GLAccount I_StRpTaxItemLog GLAccount General Ledger
BusinessPlace I_StRpTaxItemLog BusinessPlace Business place
TaxJurisdiction I_StRpTaxItemLog TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction Jurisdict. Code
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
TaxNumber3 TaxNumber3
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerCountry BusinessPartnerCountry BP Ctry/Reg.
BusinessPartnerName BusinessPartnerName Extracted Customer Name
CustomerSupplierAddress CustomerSupplierAddress
TaxType I_StRpTaxItemLog TaxType Tax Type
TargetTaxCode TargetTaxCode
ReportingCurrency ReportingCurrency Currency
AmountInReportingCurrency AmountInReportingCurrency
DocumentCurrency DocumentCurrency Document Currency
AmountInTransactionCurrency I_StRpTaxItemLog AmountInTransactionCurrency Pt Crcy Amt
AdditionalCurrency1 I_StRpTaxItemLog AdditionalCurrency1 Local curr. 2
AmountInAdditionalCurrency1 I_StRpTaxItemLog AmountInAdditionalCurrency1 Amount in Additional Currency 1
AdditionalCurrency2 I_StRpTaxItemLog AdditionalCurrency2 Local curr. 3
AmountInAdditionalCurrency2 I_StRpTaxItemLog AmountInAdditionalCurrency2 LC2 Amount
SenderCompanyCode SenderCompanyCode Sender Company Code
SenderAccountingDocument SenderAccountingDocument Sender Journal Entry
SenderFiscalYear SenderFiscalYear Sender FiscalYr
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text

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 P_GB_StRpRCTaxItemBoxCube.
-- 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: PGBSRRCTAXITMBOX

CREATE VIEW P_GB_StRpRCTaxItemBoxCube AS
SELECT
  I_StRpTaxItemLog.CompanyCode AS CompanyCode,
  I_StRpTaxItemLog.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemLog.FiscalYear AS FiscalYear,
  I_StRpTaxItemLog.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTaxItemLog.StatryRptCategory AS StatryRptCategory,
  I_StRpTaxItemLog.StatryRptRunID AS StatryRptRunID,
  I_StRpTaxItemLog.TaxCode AS TaxCode,
  I_StRpTaxItemLog.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItemLog.TaxBox AS TaxBox,
  I_StRpTaxItemLog.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_StRpTaxItemLog.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  TaxGroup,
  TaxBoxConfiguration,
  I_StRpTaxItemLog.PostingDate AS PostingDate,
  I_StRpTaxItemLog.DocumentDate AS DocumentDate,
  I_StRpTaxItemLog.TaxReportingDate AS TaxReportingDate,
  I_StRpTaxItemLog.FiscalPeriod AS FiscalPeriod,
  cast(TaxReportingDocumentDate as glo_reporting_date) AS ReportingDate,
  I_StRpTaxItemLog.AccountingDocumentType AS AccountingDocumentType,
  DocumentReferenceID,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  ExchangeRate,
  TaxRate,
  I_StRpTaxItemLog.GLAccount AS GLAccount,
  I_StRpTaxItemLog.BusinessPlace AS BusinessPlace,
  I_StRpTaxItemLog.TaxJurisdiction AS TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerCountry,
  BusinessPartnerName,
  CustomerSupplierAddress,
  I_StRpTaxItemLog.TaxType AS TaxType,
  TargetTaxCode,
  ReportingCurrency,
  AmountInReportingCurrency,
  DocumentCurrency,
  I_StRpTaxItemLog.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_StRpTaxItemLog.AdditionalCurrency1 AS AdditionalCurrency1,
  I_StRpTaxItemLog.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  I_StRpTaxItemLog.AdditionalCurrency2 AS AdditionalCurrency2,
  I_StRpTaxItemLog.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  AccountingDocumentHeaderText
FROM I_StRpTaxItemLog
;

Learn More