P_RO_StRpSalesPurchaseBox

DDL: P_RO_STRPSALESPURCHASEBOX SQL: PROSRTAXRETBOX Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RO
31 Fields 1 Data Sources

Data selection for the RO SPJ

P_RO_StRpSalesPurchaseBox is a Consumption CDS View that provides data about "Data selection for the RO SPJ" in SAP S/4HANA. It reads from 1 data source (I_StRpTaxItemBoxCube) and exposes 31 fields with key fields CompanyCode, AccountingDocument, FiscalYear. Part of development package GLO_FIN_IS_VAT_RO.

Data Sources (1)

SourceAliasJoin Type
I_StRpTaxItemBoxCube I_StRpTaxItemBoxCube from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PROSRTAXRETBOX view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Data selection for the RO SPJ view
VDM.viewType #CONSUMPTION view
VDM.private true 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 (31)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpTaxItemBoxCube CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpTaxItemBoxCube AccountingDocument Journal Entry
KEY FiscalYear I_StRpTaxItemBoxCube FiscalYear G/L Fiscal Year
ReportingDate I_StRpTaxItemBoxCube ReportingDate
PostingDate I_StRpTaxItemBoxCube PostingDate Posting Date for GR
DocumentDate I_StRpTaxItemBoxCube DocumentDate Journal Entry Date
TaxReportingDate I_StRpTaxItemBoxCube TaxReportingDate Tax Reporting Date
TaxReportingDocumentDate I_StRpTaxItemBoxCube TaxReportingDocumentDate
AccountingDocumentType I_StRpTaxItemBoxCube AccountingDocumentType Journal Entry Type
TransactionTypeDetermination I_StRpTaxItemBoxCube TransactionTypeDetermination Transaction Key
GLAccount I_StRpTaxItemBoxCube GLAccount General Ledger
BusinessPlace I_StRpTaxItemBoxCube BusinessPlace Business place
TaxJurisdiction I_StRpTaxItemBoxCube TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction I_StRpTaxItemBoxCube LowestLevelTaxJurisdiction Jurisdict. Code
TaxDeclnAmountType I_StRpTaxItemBoxCube TaxDeclnAmountType
ReportingCountry I_StRpTaxItemBoxCube ReportingCountry
TaxItemGroupingVersion I_StRpTaxItemBoxCube TaxItemGroupingVersion Tax Grping Ver.
ValidFrom I_StRpTaxItemBoxCube ValidFrom Vers.Valid From
SenderCompanyCode I_StRpTaxItemBoxCube SenderCompanyCode Sender Company Code
SenderAccountingDocument I_StRpTaxItemBoxCube SenderAccountingDocument Sender Journal Entry
SenderFiscalYear I_StRpTaxItemBoxCube SenderFiscalYear Sender FiscalYr
TaxBoxStructureType I_StRpTaxItemBoxCube TaxBoxStructureType
TargetTaxCode I_StRpTaxItemBoxCube TargetTaxCode
ClearingDate oadi ClearingDate Clearing Date
ClearingAccountingDocument oadi ClearingAccountingDocument Clearing Journal Entry
ClearingJournalEntry oadi ClearingJournalEntry Clrng doc.
VATRegistration oadi VATRegistration VAT Registration No.
TaxCode oadi TaxCode Tax Code
StatryRptgEntity
StatryRptCategory
StatryRptRunID

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_RO_StRpSalesPurchaseBox.
-- 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: PROSRTAXRETBOX
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW P_RO_StRpSalesPurchaseBox AS
SELECT
  I_StRpTaxItemBoxCube.CompanyCode AS CompanyCode,
  I_StRpTaxItemBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemBoxCube.FiscalYear AS FiscalYear,
  I_StRpTaxItemBoxCube.ReportingDate AS ReportingDate,
  I_StRpTaxItemBoxCube.PostingDate AS PostingDate,
  I_StRpTaxItemBoxCube.DocumentDate AS DocumentDate,
  I_StRpTaxItemBoxCube.TaxReportingDate AS TaxReportingDate,
  I_StRpTaxItemBoxCube.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  I_StRpTaxItemBoxCube.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxItemBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItemBoxCube.GLAccount AS GLAccount,
  I_StRpTaxItemBoxCube.BusinessPlace AS BusinessPlace,
  I_StRpTaxItemBoxCube.TaxJurisdiction AS TaxJurisdiction,
  I_StRpTaxItemBoxCube.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  I_StRpTaxItemBoxCube.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_StRpTaxItemBoxCube.ReportingCountry AS ReportingCountry,
  I_StRpTaxItemBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_StRpTaxItemBoxCube.ValidFrom AS ValidFrom,
  I_StRpTaxItemBoxCube.SenderCompanyCode AS SenderCompanyCode,
  I_StRpTaxItemBoxCube.SenderAccountingDocument AS SenderAccountingDocument,
  I_StRpTaxItemBoxCube.SenderFiscalYear AS SenderFiscalYear,
  I_StRpTaxItemBoxCube.TaxBoxStructureType AS TaxBoxStructureType,
  I_StRpTaxItemBoxCube.TargetTaxCode AS TargetTaxCode,
  oadi.ClearingDate AS ClearingDate,
  oadi.ClearingAccountingDocument AS ClearingAccountingDocument,
  oadi.ClearingJournalEntry AS ClearingJournalEntry,
  oadi.VATRegistration AS VATRegistration,
  oadi.TaxCode AS TaxCode,
  $parameters.P_StatryRptgEntity AS StatryRptgEntity,
  $parameters.P_StatryRptCategory AS StatryRptCategory,
  $parameters.P_StatryRptRunID AS StatryRptRunID
FROM I_StRpTaxItemBoxCube
;

Learn More