What is P_StRpTaxItemDebitCredit in SAP S/4HANA?

P_StRpTaxItemDebitCredit is a composite CDS view in SAP S/4HANA. Tax Item for Statutory Reporting (Auxiliary View) It contains 70 fields.

Which tables does P_StRpTaxItemDebitCredit read from?

P_StRpTaxItemDebitCredit reads data from: I_TaxItem.

What VDM layer is P_StRpTaxItemDebitCredit?

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

P_StRpTaxItemDebitCredit

DDL: P_STRPTAXITEMDEBITCREDIT Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_GEN

70 Fields 1 Data Sources 4 Associations

Tax Item for Statutory Reporting (Auxiliary View)

P_StRpTaxItemDebitCredit is a Composite CDS View that provides data about "Tax Item for Statutory Reporting (Auxiliary View)" in SAP S/4HANA. It reads from 1 data source (I_TaxItem) and exposes 70 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxItemUUID. It has 4 associations to related views. Part of development package GLO_FIN_IS_VAT_GEN.

Data Sources (1)

Source	Alias	Join Type
I_TaxItem	I_TaxItem	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..*]	I_TaxJurisdiction	_TaxJurisdiction	`$projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction`
[0..*]	I_OperationalAcctgDocItem	_DebtorCreditorRblsPyblsItem	$projection.CompanyCode = _DebtorCreditorRblsPyblsItem.CompanyCode and $projection.FiscalYear = _DebtorCreditorRblsPyblsItem.FiscalYear and $projection.AccountingDocument = _DebtorCreditorRblsPyblsItem.AccountingDocument and ( $projection.TaxCode = _DebtorCreditorRblsPyblsItem.TaxCode or _DebtorCreditorRblsPyblsItem.TaxCode = '**' or _DebtorCreditorRblsPyblsItem.TaxCode = '' ) and $projection.TaxCountry = _DebtorCreditorRblsPyblsItem.TaxCountry and $projection.TaxJurisdiction = _DebtorCreditorRblsPyblsItem.TaxJurisdiction and( _DebtorCreditorRblsPyblsItem.FinancialAccountType = 'D' or _DebtorCreditorRblsPyblsItem.FinancialAccountType = 'K' )
[0..*]	I_OperationalAcctgDocItem	_TaxReceivablesPayablesItem	$projection.CompanyCode = _TaxReceivablesPayablesItem.CompanyCode and $projection.FiscalYear = _TaxReceivablesPayablesItem.FiscalYear and $projection.AccountingDocument = _TaxReceivablesPayablesItem.AccountingDocument and $projection.TaxItemGroup = _TaxReceivablesPayablesItem.TaxItemGroup and $projection.TaxCode = _TaxReceivablesPayablesItem.TaxCode and $projection.TaxCountry = _TaxReceivablesPayablesItem.TaxCountry and $projection.TaxJurisdiction = _TaxReceivablesPayablesItem.TaxJurisdiction and ( _TaxReceivablesPayablesItem.TaxType = 'A' or _TaxReceivablesPayablesItem.TaxType = 'V' )
[0..*]	I_OperationalAcctgDocItem	_ReceivablesPayablesItem	`$projection.CompanyCode = _ReceivablesPayablesItem.CompanyCode and $projection.FiscalYear = _ReceivablesPayablesItem.FiscalYear and $projection.AccountingDocument = _ReceivablesPayablesItem.AccountingDocument`

Annotations (6)

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

Fields (70)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_TaxItem	CompanyCode	Receiver Company Code
KEY	AccountingDocument	I_TaxItem	AccountingDocument	Journal Entry
KEY	FiscalYear	I_TaxItem	FiscalYear	G/L Fiscal Year
KEY	TaxItem	I_TaxItem	TaxItem	Tax Item
KEY	TaxItemUUID	I_TaxItem	TaxItemUUID
	TaxItemAcctgDocItemRef	I_TaxItem	TaxItemAcctgDocItemRef	Tax doc. item number
	TaxCode	I_TaxItem	TaxCode	Tax Code
	TaxItemGroup	I_TaxItem	TaxItemGroup	Tax doc. item number
	TransactionTypeDetermination	I_TaxItem	TransactionTypeDetermination	Transaction Key
	TaxRateValidityStartDate	I_TaxItem	TaxRateValidityStartDate	Tax Rate Validity Start Date
	GLAccount	I_TaxItem	GLAccount	General Ledger
	BusinessPlace	I_TaxItem	BusinessPlace	Business place
	TaxJurisdiction	I_TaxItem	TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction	I_TaxItem	LowestLevelTaxJurisdiction	Jurisdict. Code
	CompanyCodeCountry	I_TaxItem	CompanyCodeCountry	Reporting Ctry/Reg.
	TaxReturnCountry	I_TaxItem	TaxReturnCountry	Reporting C/R
	TaxAmountInCoCodeCrcy	I_TaxItem	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	I_TaxItem	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	I_TaxItem	TaxAmount	Tax Amt in Rptg Crcy
	TaxBaseAmountInCountryCrcy	I_TaxItem	TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmountInCountryCrcy	I_TaxItem	TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmtInAdditionalCrcy1	I_TaxItem	TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxAmountInAdditionalCurrency1	I_TaxItem	TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxBaseAmtInAdditionalCrcy2	I_TaxItem	TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency2	I_TaxItem	TaxAmountInAdditionalCurrency2	LC 3 Tax
	AccountingDocumentType
	ReferenceDocumentType
	AlternativeReferenceDocument
	ReverseDocument
	ReverseDocumentFiscalYear
	Ledger
	LedgerGroup
	PostingDate
	DocumentDate
	TaxReportingDate	I_TaxItem	TaxReportingDate	Tax Reporting Date
	ReportingDate
	TaxReportingDocumentDate
	TaxFulfillmentDate
	IsReversal
	IsReversed
	FiscalPeriod
	ExchangeRate
	AccountingDocumentHeaderText
	DocumentReferenceID
	OriginalReferenceDocument
	ConditionType	I_TaxItem	ConditionType	Condition type
	DocumentCurrency	I_TaxItem	DocumentCurrency	Document Currency
	CountryCurrency	I_TaxItem	CountryCurrency	Currency
	CompanyCodeCurrency	I_TaxItem	CompanyCodeCurrency	Local Currency
	AdditionalCurrency1	I_TaxItem	AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2	I_TaxItem	AdditionalCurrency2	Local curr. 3
	DebitCreditCodeCalc	I_TaxItem	DebitCreditCode	Single-Character Flag
	DebitCreditCodeIsChanged
	ReportingCountry	I_TaxItem	TaxCountry	Tax Ctry/Reg.
	ReportingCurrency
	SenderCompanyCode
	SenderAccountingDocument
	SenderFiscalYear
	SenderLogicalSystem
	TaxCountry	I_TaxItem	TaxCountry	Tax Ctry/Reg.
	AccountingDocumentCategory
	TaxDataSource	I_TaxItem	TaxDataSource
	_AccountingDocument		_AccountingDocument
	_GLAccount		_GLAccount
	_TaxJurisdiction		_TaxJurisdiction
	_CompanyCodeCountry		_CompanyCodeCountry
	_DebtorCreditorRblsPyblsItem		_DebtorCreditorRblsPyblsItem
	_ReceivablesPayablesItem		_ReceivablesPayablesItem
	_TaxReceivablesPayablesItem		_TaxReceivablesPayablesItem
	_TaxReturnCountry		_TaxReturnCountry

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_StRpTaxItemDebitCredit.
-- 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.

CREATE VIEW P_StRpTaxItemDebitCredit AS
SELECT
  I_TaxItem.CompanyCode AS CompanyCode,
  I_TaxItem.AccountingDocument AS AccountingDocument,
  I_TaxItem.FiscalYear AS FiscalYear,
  I_TaxItem.TaxItem AS TaxItem,
  I_TaxItem.TaxItemUUID AS TaxItemUUID,
  I_TaxItem.TaxItemAcctgDocItemRef AS TaxItemAcctgDocItemRef,
  I_TaxItem.TaxCode AS TaxCode,
  I_TaxItem.TaxItemGroup AS TaxItemGroup,
  I_TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_TaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_TaxItem.GLAccount AS GLAccount,
  I_TaxItem.BusinessPlace AS BusinessPlace,
  I_TaxItem.TaxJurisdiction AS TaxJurisdiction,
  I_TaxItem.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  I_TaxItem.CompanyCodeCountry AS CompanyCodeCountry,
  I_TaxItem.TaxReturnCountry AS TaxReturnCountry,
  I_TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  I_TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_TaxItem.TaxAmount AS TaxAmount,
  I_TaxItem.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  I_TaxItem.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  I_TaxItem.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  I_TaxItem.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  I_TaxItem.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  I_TaxItem.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  I_TaxItem._JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  I_TaxItem._JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  cast (I_TaxItem._JournalEntry.AlternativeReferenceDocument as figen_alt_ref_doc_num) AS AlternativeReferenceDocument,
  I_TaxItem._JournalEntry.ReverseDocument AS ReverseDocument,
  I_TaxItem._JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_TaxItem._JournalEntry.Ledger AS Ledger,
  I_TaxItem._JournalEntry.LedgerGroup AS LedgerGroup,
  I_TaxItem._JournalEntry.PostingDate AS PostingDate,
  I_TaxItem._JournalEntry.DocumentDate AS DocumentDate,
  I_TaxItem.TaxReportingDate AS TaxReportingDate,
  case when ( _JournalEntry.TaxReportingDate = '00000000' ) then _JournalEntry.PostingDate else _JournalEntry.TaxReportingDate end AS ReportingDate,
  case when ( _JournalEntry.TaxReportingDate = '00000000' ) then _JournalEntry.DocumentDate else _JournalEntry.TaxReportingDate end AS TaxReportingDocumentDate,
  I_TaxItem._JournalEntry.TaxFulfillmentDate AS TaxFulfillmentDate,
  I_TaxItem._JournalEntry.IsReversal AS IsReversal,
  I_TaxItem._JournalEntry.IsReversed AS IsReversed,
  I_TaxItem._JournalEntry.FiscalPeriod AS FiscalPeriod,
  I_TaxItem._JournalEntry.ExchangeRate AS ExchangeRate,
  I_TaxItem._JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_TaxItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  I_TaxItem._JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  I_TaxItem.ConditionType AS ConditionType,
  I_TaxItem.DocumentCurrency AS DocumentCurrency,
  I_TaxItem.CountryCurrency AS CountryCurrency,
  I_TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_TaxItem.AdditionalCurrency1 AS AdditionalCurrency1,
  I_TaxItem.AdditionalCurrency2 AS AdditionalCurrency2,
  I_TaxItem.DebitCreditCode AS DebitCreditCodeCalc,
  cast('' as figen_shkzg_change_indicator ) AS DebitCreditCodeIsChanged,
  I_TaxItem.TaxCountry AS ReportingCountry,
  I_TaxItem._TaxCountry.CountryCurrency AS ReportingCurrency,
  I_TaxItem._JournalEntry.SenderCompanyCode AS SenderCompanyCode,
  I_TaxItem._JournalEntry.SenderAccountingDocument AS SenderAccountingDocument,
  I_TaxItem._JournalEntry.SenderFiscalYear AS SenderFiscalYear,
  I_TaxItem._JournalEntry.SenderLogicalSystem AS SenderLogicalSystem,
  I_TaxItem.TaxCountry AS TaxCountry,
  I_TaxItem._JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_TaxItem.TaxDataSource AS TaxDataSource
FROM I_TaxItem
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _DebtorCreditorRblsPyblsItem ON CompanyCode = _DebtorCreditorRblsPyblsItem.CompanyCode AND FiscalYear = _DebtorCreditorRblsPyblsItem.FiscalYear AND AccountingDocument = _DebtorCreditorRblsPyblsItem.AccountingDocument AND ( TaxCode = _DebtorCreditorRblsPyblsItem.TaxCode OR _DebtorCreditorRblsPyblsItem.TaxCode = '**' OR _DebtorCreditorRblsPyblsItem.TaxCode = '' ) AND TaxCountry = _DebtorCreditorRblsPyblsItem.TaxCountry AND TaxJurisdiction = _DebtorCreditorRblsPyblsItem.TaxJurisdiction AND( _DebtorCreditorRblsPyblsItem.FinancialAccountType = 'D' OR _DebtorCreditorRblsPyblsItem.FinancialAccountType = 'K' )  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _TaxReceivablesPayablesItem ON CompanyCode = _TaxReceivablesPayablesItem.CompanyCode AND FiscalYear = _TaxReceivablesPayablesItem.FiscalYear AND AccountingDocument = _TaxReceivablesPayablesItem.AccountingDocument AND TaxItemGroup = _TaxReceivablesPayablesItem.TaxItemGroup AND TaxCode = _TaxReceivablesPayablesItem.TaxCode AND TaxCountry = _TaxReceivablesPayablesItem.TaxCountry AND TaxJurisdiction = _TaxReceivablesPayablesItem.TaxJurisdiction AND ( _TaxReceivablesPayablesItem.TaxType = 'A' OR _TaxReceivablesPayablesItem.TaxType = 'V' )  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _ReceivablesPayablesItem ON CompanyCode = _ReceivablesPayablesItem.CompanyCode AND FiscalYear = _ReceivablesPayablesItem.FiscalYear AND AccountingDocument = _ReceivablesPayablesItem.AccountingDocument  -- association [0..*]
;

Depth:

P_StRpTaxItemDebitCredit view_entity

I_TaxItem view