P_GB_StRpNotRepTaxBoxItem

DDL: P_GB_STRPNOTREPTAXBOXITEM SQL: PGBSTRPNRTI Type: view CONSUMPTION
5 Fields 2 Data Sources

Not reported tax box items

P_GB_StRpNotRepTaxBoxItem is a Consumption CDS View that provides data about "Not reported tax box items" in SAP S/4HANA. It reads from 2 data sources (C_StRpRptdJournalEntry, I_StRpTaxItemBoxConfiguration) and exposes 5 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
C_StRpRptdJournalEntry C_StRpRptdJournalEntry left_outer
I_StRpTaxItemBoxConfiguration I_StRpTaxItemBoxConfiguration left_outer

Parameters (4)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_ValidFrom fot_atr_tbs_valid_from
P_TaxBoxStructure fot_atr_tax_box_struct_type

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PGBSTRPNRTI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.preserveKey true view
EndUserText.label Not reported tax box items view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode TaxData CompanyCode Receiver Company Code
KEY AccountingDocument TaxData AccountingDocument Journal Entry
KEY FiscalYear TaxData FiscalYear G/L Fiscal Year
TaxReportingDocumentDate TaxReportingDocumentDate
ReportingCountry ReportingCountry

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_StRpNotRepTaxBoxItem.
-- 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: PGBSTRPNRTI
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_ValidFrom : fot_atr_tbs_valid_from, P_TaxBoxStructure : fot_atr_tax_box_struct_type

CREATE VIEW P_GB_StRpNotRepTaxBoxItem AS
SELECT
  TaxData.CompanyCode AS CompanyCode,
  TaxData.AccountingDocument AS AccountingDocument,
  TaxData.FiscalYear AS FiscalYear,
  TaxReportingDocumentDate,
  ReportingCountry
LEFT OUTER JOIN C_StRpRptdJournalEntry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StRpTaxItemBoxConfiguration ON /* join condition not captured in parsed metadata */
;

Learn More