What is P_SI_StRpTaxReturnBoxCube in SAP S/4HANA?

P_SI_StRpTaxReturnBoxCube is a composite CDS view in SAP S/4HANA. Slovenian TaxBox view for KPR, KIR It contains 71 fields.

Which tables does P_SI_StRpTaxReturnBoxCube read from?

P_SI_StRpTaxReturnBoxCube reads data from: P_SI_STRPTAXRETURNBOXCUBE1.

What VDM layer is P_SI_StRpTaxReturnBoxCube?

P_SI_StRpTaxReturnBoxCube is classified as a Composite view that combines data from multiple basic views.

P_SI_StRpTaxReturnBoxCube

DDL: P_SI_STRPTAXRETURNBOXCUBE Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_SI

71 Fields 1 Data Sources 4 Associations

Slovenian TaxBox view for KPR, KIR

P_SI_StRpTaxReturnBoxCube is a Composite CDS View that provides data about "Slovenian TaxBox view for KPR, KIR" in SAP S/4HANA. It reads from 1 data source (P_SI_STRPTAXRETURNBOXCUBE1) and exposes 71 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TransactionTypeDetermination. It has 4 associations to related views. Part of development package GLO_FIN_IS_VAT_SI.

Data Sources (1)

Source	Alias	Join Type
P_SI_STRPTAXRETURNBOXCUBE1	P_SI_STRPTAXRETURNBOXCUBE1	from

Parameters (7)

Name	Type	Default
P_TaxIsDeferredRelevant	figen_deferred_check
P_TaxIsMossRelevant	figen_moss_check
P_StatryRptgEntity	srf_reporting_entity
P_StatryRptCategory	srf_rep_cat_id
P_StatryRptRunID	srf_report_run_id
P_ReportingCountry	land1
P_TaxBoxConfiguration	figen_tdt_taxbox_config

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	I_SupplierToBusinessPartner	_SupplierToBusinessPartner	`_SupplierToBusinessPartner.Supplier = StRpTaxReturnBoxCube.Supplier`
[0..1]	I_CustomerToBusinessPartner	_CustomerToBusinessPartner	`_CustomerToBusinessPartner.Customer = StRpTaxReturnBoxCube.Customer`
[0..1]	I_AccountingDocumentODN	_AccountingDocumentODN	`_AccountingDocumentODN.CompanyCode = $projection.CompanyCode and _AccountingDocumentODN.FiscalYear = $projection.FiscalYear and _AccountingDocumentODN.AccountingDocument = $projection.AccountingDocument`
[0..1]	I_BillingDocumentODN	_BillingDocumentODN	`_BillingDocumentODN.BillingDocument = StRpTaxReturnBoxCube.BillingDocument`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view

Fields (71)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	StRpTaxReturnBoxCube	CompanyCode	Receiver Company Code
KEY	AccountingDocument	StRpTaxReturnBoxCube	AccountingDocument	Journal Entry
KEY	FiscalYear	StRpTaxReturnBoxCube	FiscalYear	G/L Fiscal Year
KEY	TaxItem	StRpTaxReturnBoxCube	TaxItem	Tax Item
KEY	TransactionTypeDetermination	StRpTaxReturnBoxCube	TransactionTypeDetermination	Transaction Key
KEY	DebitCreditCode	StRpTaxReturnBoxCube	DebitCreditCode	Single-Character Flag
KEY	AccountingDocumentType	StRpTaxReturnBoxCube	AccountingDocumentType	Journal Entry Type
KEY	SupplierAccountGroup	StRpTaxReturnBoxCube	SupplierAccountGroup	Account group
KEY	TaxBox	StRpTaxReturnBoxCube	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType	StRpTaxReturnBoxCube	TaxDeclnAmountType
KEY	TaxBoxStrucValidityStartDate	StRpTaxReturnBoxCube	TaxBoxStrucValidityStartDate
KEY	UnifiedTaxBoxStructureType	StRpTaxReturnBoxCube	UnifiedTaxBoxStructureType
KEY	TaxGroup	StRpTaxReturnBoxCube	TaxGroup	Tax Group
KEY	TaxItemGrpgDebitCreditCode	StRpTaxReturnBoxCube	TaxItemGrpgDebitCreditCode
KEY	TaxItemGrpgAcctgDocumentType	StRpTaxReturnBoxCube	TaxItemGrpgAcctgDocumentType
KEY	TaxItemGrpgSupplierAcctGroup	StRpTaxReturnBoxCube	TaxItemGrpgSupplierAcctGroup
KEY	TaxItemGrpgSpecialGLCode	StRpTaxReturnBoxCube	TaxItemGrpgSpecialGLCode
KEY	StatryRptgEntity	StRpTaxReturnBoxCube	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	StRpTaxReturnBoxCube	StatryRptCategory	Report ID
KEY	StatryRptRunID	StRpTaxReturnBoxCube	StatryRptRunID	Report Run ID
	StatryRptRun	StRpTaxReturnBoxCube	StatryRptRun
	ValidFrom	StRpTaxReturnBoxCube	ValidFrom	Vers.Valid From
	Country	StRpTaxReturnBoxCube	Country	Venue: Ctry/Reg
	TaxCode	StRpTaxReturnBoxCube	TaxCode	Tax Code
	TaxBoxStructureType	StRpTaxReturnBoxCube	TaxBoxStructureType
	ValidTo	StRpTaxReturnBoxCube	ValidTo	Vers.Valid To
	TaxBoxStrucValidityEndDate	StRpTaxReturnBoxCube	TaxBoxStrucValidityEndDate
	TaxCalculationProcedure	StRpTaxReturnBoxCube	TaxCalculationProcedure	Tax Procedure
	TaxRate	StRpTaxReturnBoxCube	TaxRate	Tax Rate
	TaxGroupOperation	StRpTaxReturnBoxCube	TaxGroupOperation
	Customer	StRpTaxReturnBoxCube	Customer	Sold-to Party
	Supplier	StRpTaxReturnBoxCube	Supplier	Supplier
	AccountingDocumentItem	StRpTaxReturnBoxCube	AccountingDocumentItem	Posting View Item
	SupplyingCountry	StRpTaxReturnBoxCube	SupplyingCountry	Supplying Ctry/Reg.
	BusinessPartnerendasBusinessPartner
	GLAccount
	VATRegistration
	ReferenceDocumentType	StRpTaxReturnBoxCube	ReferenceDocumentType	Reference Document Type
	AlternativeReferenceDocument	StRpTaxReturnBoxCube	AlternativeReferenceDocument	Alternative Reference Document
	DocumentReferenceID	StRpTaxReturnBoxCube	DocumentReferenceID	Reference
	OriginalReferenceDocument	StRpTaxReturnBoxCube	OriginalReferenceDocument	Reference Key
	Ledger	StRpTaxReturnBoxCube	Ledger	Ledger
	ReportingVATRegistration
	ActiveTaxType	StRpTaxReturnBoxCube	ActiveTaxType
	TaxType	StRpTaxReturnBoxCube	TaxType	Tax Type
	PostingDate	StRpTaxReturnBoxCube	PostingDate	Posting Date for GR
	DocumentDate	StRpTaxReturnBoxCube	DocumentDate	Journal Entry Date
	TaxReportingDate	StRpTaxReturnBoxCube	TaxReportingDate	Tax Reporting Date
	ReportingDate	StRpTaxReturnBoxCube	ReportingDate
	TaxReportingDocumentDate	StRpTaxReturnBoxCube	TaxReportingDocumentDate
	TaxFulfillmentDate	StRpTaxReturnBoxCube	TaxFulfillmentDate	Tax Settlement Date
	InvoiceReceiptDate	StRpTaxReturnBoxCube	InvoiceReceiptDate	Invoice Receipt Date
	FiscalPeriod	StRpTaxReturnBoxCube	FiscalPeriod	Tax period
	AccountingDocumentHeaderText	StRpTaxReturnBoxCube	AccountingDocumentHeaderText	Doc.Header Text
	CompanyCodeCountry	StRpTaxReturnBoxCube	CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry	StRpTaxReturnBoxCube	ReportingCountry
	TaxReturnCountry	StRpTaxReturnBoxCube	TaxReturnCountry	Reporting C/R
	CompanyCodeCurrency	StRpTaxReturnBoxCube	CompanyCodeCurrency	Local Currency
	CountryCurrency	StRpTaxReturnBoxCube	CountryCurrency	Currency
	DocumentCurrency	StRpTaxReturnBoxCube	DocumentCurrency	Document Currency
	ReportingCurrency	StRpTaxReturnBoxCube	ReportingCurrency	Currency
	TaxBaseAmountInRptgCrcy	StRpTaxReturnBoxCube	TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy	StRpTaxReturnBoxCube	TaxAmountInRptgCrcy	Tax Rept. Crcy
	AmountInReportingCurrency	StRpTaxReturnBoxCube	AmountInReportingCurrency
	TaxCountry	StRpTaxReturnBoxCube	TaxCountry	Tax Ctry/Reg.
	TaxJurisdiction	StRpTaxReturnBoxCube	TaxJurisdiction	Tax Jurisdiction
	TaxIsNotDeductible	StRpTaxReturnBoxCube	TaxIsNotDeductible	Non-Deductible
	TaxGroupFreeClassification	StRpTaxReturnBoxCube	TaxGroupFreeClassification
	JrnlEntryCntrySpecificRef2	StRpTaxReturnBoxCube	JrnlEntryCntrySpecificRef2	Country/Region Specific Reference 2
	BillingDocument	StRpTaxReturnBoxCube	BillingDocument	SD Document
	CountryendasBusinessPartnerCountry

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_SI_StRpTaxReturnBoxCube.
-- 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.
-- Parameters: P_TaxIsDeferredRelevant : figen_deferred_check, P_TaxIsMossRelevant : figen_moss_check, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_TaxBoxConfiguration : figen_tdt_taxbox_config

CREATE VIEW P_SI_StRpTaxReturnBoxCube AS
SELECT
  StRpTaxReturnBoxCube.CompanyCode AS CompanyCode,
  StRpTaxReturnBoxCube.AccountingDocument AS AccountingDocument,
  StRpTaxReturnBoxCube.FiscalYear AS FiscalYear,
  StRpTaxReturnBoxCube.TaxItem AS TaxItem,
  StRpTaxReturnBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  StRpTaxReturnBoxCube.DebitCreditCode AS DebitCreditCode,
  StRpTaxReturnBoxCube.AccountingDocumentType AS AccountingDocumentType,
  StRpTaxReturnBoxCube.SupplierAccountGroup AS SupplierAccountGroup,
  StRpTaxReturnBoxCube.TaxBox AS TaxBox,
  StRpTaxReturnBoxCube.TaxDeclnAmountType AS TaxDeclnAmountType,
  StRpTaxReturnBoxCube.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  StRpTaxReturnBoxCube.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  StRpTaxReturnBoxCube.TaxGroup AS TaxGroup,
  StRpTaxReturnBoxCube.TaxItemGrpgDebitCreditCode AS TaxItemGrpgDebitCreditCode,
  StRpTaxReturnBoxCube.TaxItemGrpgAcctgDocumentType AS TaxItemGrpgAcctgDocumentType,
  StRpTaxReturnBoxCube.TaxItemGrpgSupplierAcctGroup AS TaxItemGrpgSupplierAcctGroup,
  StRpTaxReturnBoxCube.TaxItemGrpgSpecialGLCode AS TaxItemGrpgSpecialGLCode,
  StRpTaxReturnBoxCube.StatryRptgEntity AS StatryRptgEntity,
  StRpTaxReturnBoxCube.StatryRptCategory AS StatryRptCategory,
  StRpTaxReturnBoxCube.StatryRptRunID AS StatryRptRunID,
  StRpTaxReturnBoxCube.StatryRptRun AS StatryRptRun,
  StRpTaxReturnBoxCube.ValidFrom AS ValidFrom,
  StRpTaxReturnBoxCube.Country AS Country,
  StRpTaxReturnBoxCube.TaxCode AS TaxCode,
  StRpTaxReturnBoxCube.TaxBoxStructureType AS TaxBoxStructureType,
  StRpTaxReturnBoxCube.ValidTo AS ValidTo,
  StRpTaxReturnBoxCube.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  StRpTaxReturnBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  StRpTaxReturnBoxCube.TaxRate AS TaxRate,
  StRpTaxReturnBoxCube.TaxGroupOperation AS TaxGroupOperation,
  StRpTaxReturnBoxCube.Customer AS Customer,
  StRpTaxReturnBoxCube.Supplier AS Supplier,
  StRpTaxReturnBoxCube.AccountingDocumentItem AS AccountingDocumentItem,
  StRpTaxReturnBoxCube.SupplyingCountry AS SupplyingCountry,
  case when _SupplierToBusinessPartner._BusinessPartner.BusinessPartner is not initial then _SupplierToBusinessPartner._BusinessPartner.BusinessPartner when _CustomerToBusinessPartner._BusinessPartner.BusinessPartner is not initial then _CustomerToBusinessPartner._BusinessPartner.BusinessPartner end as BusinessPartner AS BusinessPartnerendasBusinessPartner,
  StRpTaxReturnBoxCube._DebtorCreditorRblsPyblsItem[ AccountingDocumentItem = accountingdocumentitem ].GLAccount AS GLAccount,
  StRpTaxReturnBoxCube._DebtorCreditorRblsPyblsItem[ AccountingDocumentItem = accountingdocumentitem ].VATRegistration AS VATRegistration,
  StRpTaxReturnBoxCube.ReferenceDocumentType AS ReferenceDocumentType,
  StRpTaxReturnBoxCube.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  StRpTaxReturnBoxCube.DocumentReferenceID AS DocumentReferenceID,
  StRpTaxReturnBoxCube.OriginalReferenceDocument AS OriginalReferenceDocument,
  StRpTaxReturnBoxCube.Ledger AS Ledger,
  cast ( StRpTaxReturnBoxCube.ReportingVATRegistration as fis_stceg ) AS ReportingVATRegistration,
  StRpTaxReturnBoxCube.ActiveTaxType AS ActiveTaxType,
  StRpTaxReturnBoxCube.TaxType AS TaxType,
  StRpTaxReturnBoxCube.PostingDate AS PostingDate,
  StRpTaxReturnBoxCube.DocumentDate AS DocumentDate,
  StRpTaxReturnBoxCube.TaxReportingDate AS TaxReportingDate,
  StRpTaxReturnBoxCube.ReportingDate AS ReportingDate,
  StRpTaxReturnBoxCube.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  StRpTaxReturnBoxCube.TaxFulfillmentDate AS TaxFulfillmentDate,
  StRpTaxReturnBoxCube.InvoiceReceiptDate AS InvoiceReceiptDate,
  StRpTaxReturnBoxCube.FiscalPeriod AS FiscalPeriod,
  StRpTaxReturnBoxCube.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  StRpTaxReturnBoxCube.CompanyCodeCountry AS CompanyCodeCountry,
  StRpTaxReturnBoxCube.ReportingCountry AS ReportingCountry,
  StRpTaxReturnBoxCube.TaxReturnCountry AS TaxReturnCountry,
  StRpTaxReturnBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  StRpTaxReturnBoxCube.CountryCurrency AS CountryCurrency,
  StRpTaxReturnBoxCube.DocumentCurrency AS DocumentCurrency,
  StRpTaxReturnBoxCube.ReportingCurrency AS ReportingCurrency,
  StRpTaxReturnBoxCube.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  StRpTaxReturnBoxCube.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  StRpTaxReturnBoxCube.AmountInReportingCurrency AS AmountInReportingCurrency,
  StRpTaxReturnBoxCube.TaxCountry AS TaxCountry,
  StRpTaxReturnBoxCube.TaxJurisdiction AS TaxJurisdiction,
  StRpTaxReturnBoxCube.TaxIsNotDeductible AS TaxIsNotDeductible,
  StRpTaxReturnBoxCube.TaxGroupFreeClassification AS TaxGroupFreeClassification,
  StRpTaxReturnBoxCube.JrnlEntryCntrySpecificRef2 AS JrnlEntryCntrySpecificRef2,
  StRpTaxReturnBoxCube.BillingDocument AS BillingDocument,
  case when StRpTaxReturnBoxCube.BusinessPartnerCountry is not initial then StRpTaxReturnBoxCube.BusinessPartnerCountry when _SupplierToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.Country is not initial then _SupplierToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.Country when _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.Country is not initial then _CustomerToBusinessPartner._BusinessPartner._CurrentDefaultAddress._Address.Country end as BusinessPartnerCountry AS CountryendasBusinessPartnerCountry
FROM P_SI_STRPTAXRETURNBOXCUBE1
LEFT OUTER JOIN I_SupplierToBusinessPartner AS _SupplierToBusinessPartner ON _SupplierToBusinessPartner.Supplier = StRpTaxReturnBoxCube.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CustomerToBusinessPartner AS _CustomerToBusinessPartner ON _CustomerToBusinessPartner.Customer = StRpTaxReturnBoxCube.Customer  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentODN AS _AccountingDocumentODN ON _AccountingDocumentODN.CompanyCode = CompanyCode AND _AccountingDocumentODN.FiscalYear = FiscalYear AND _AccountingDocumentODN.AccountingDocument = AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentODN AS _BillingDocumentODN ON _BillingDocumentODN.BillingDocument = StRpTaxReturnBoxCube.BillingDocument  -- association [0..1]
;

Depth:

P_SI_StRpTaxReturnBoxCube view_entity

P_SI_STRPTAXRETURNBOXCUBE1 view_entity