What is P_StRpBPTaxItem14 in SAP S/4HANA?

P_StRpBPTaxItem14 is a composite CDS view in SAP S/4HANA. It contains 65 fields.

Which tables does P_StRpBPTaxItem14 read from?

P_StRpBPTaxItem14 reads data from: P_StRpBPTaxItem1.

What VDM layer is P_StRpBPTaxItem14?

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

P_StRpBPTaxItem14

DDL: P_STRPBPTAXITEM14 SQL: PSTRPBPTAXITEM14 Type: view COMPOSITE

65 Fields 1 Data Sources

P_StRpBPTaxItem14 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_StRpBPTaxItem1) and exposes 65 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem.

Data Sources (1)

Source	Alias	Join Type
P_StRpBPTaxItem1	P_TaxItem	from

Annotations (7)

Name	Value	Level
AbapCatalog.sqlViewName	PSTRPBPTAXITEM14	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.private	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view

Fields (65)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_StRpBPTaxItem1	CompanyCode	Receiver Company Code
KEY	AccountingDocument	P_StRpBPTaxItem1	AccountingDocument	Journal Entry
KEY	FiscalYear	P_StRpBPTaxItem1	FiscalYear	G/L Fiscal Year
KEY	TaxItem	P_StRpBPTaxItem1	TaxItem	Tax Item
	AccountingDocumentItem	P_JournalEntryItem	AccountingDocumentItem	Posting View Item
	TransactionTypeDetermination	P_StRpBPTaxItem1	TransactionTypeDetermination	Transaction Key
	TaxCode	P_StRpBPTaxItem1	TaxCode	Tax Code
	GLAccount	P_StRpBPTaxItem1	GLAccount	General Ledger
	TaxType	P_StRpBPTaxItem1	TaxType	Tax Type
	TaxResultManualModification	P_StRpBPTaxItem1	TaxResultManualModification	Tax Modified
	TaxBaseAmountInCoCodeCrcy	P_StRpBPTaxItem1	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	P_StRpBPTaxItem1	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	P_StRpBPTaxItem1	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmountInTransCrcy	P_StRpBPTaxItem1	TaxAmountInTransCrcy	TaxAmt in Tran. Crcy
	VATRegistration	P_StRpBPTaxItem1	VATRegistration	VAT Registration No.
	TaxJurisdiction	P_StRpBPTaxItem1	TaxJurisdiction	Tax Jurisdiction
	ConditionType	P_StRpBPTaxItem1	ConditionType	Condition type
	TaxRate
	TaxReturnCountry
	TaxAmountInCountryCrcy	P_StRpBPTaxItem1	TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmountInCountryCrcy	P_StRpBPTaxItem1	TaxBaseAmountInCountryCrcy	Base Amount
	CompanyCodeCurrency
	CompanyCodeCountry
	DocumentCurrency
	CountryCurrency
	TaxCalculationProcedure	P_StRpBPTaxItem1	TaxCalculationProcedure	Tax Procedure
	TaxRateValidityStartDate	P_StRpBPTaxItem1	TaxRateValidityStartDate	Tax Rate Validity Start Date
	DocumentDate	I_JournalEntry	DocumentDate	Journal Entry Date
	PostingDate	I_JournalEntry	PostingDate	Posting Date for GR
	PostingFiscalPeriod
	ReferenceDocumentType	I_JournalEntry	ReferenceDocumentType	Reference Document Type
	DocumentReferenceID	I_JournalEntry	DocumentReferenceID	Reference
	ReverseDocument	I_JournalEntry	ReverseDocument	Reversed With
	ReverseDocumentFiscalYear	I_JournalEntry	ReverseDocumentFiscalYear	Year
	OriginalReferenceDocument	I_JournalEntry	OriginalReferenceDocument	Reference Key
	AccountingDocumentType
	TaxBaseAmountIsNetAmount	I_JournalEntry	TaxBaseAmountIsNetAmount	Tax Base Amount is Net Amount
	TaxReportingDate	I_JournalEntry	TaxReportingDate	Tax Reporting Date
	SenderLogicalSystem	I_JournalEntry	SenderLogicalSystem	Sender Logical System
	SenderCompanyCode	I_JournalEntry	SenderCompanyCode	Sender Company Code
	SenderAccountingDocument	I_JournalEntry	SenderAccountingDocument	Sender Journal Entry
	SenderFiscalYear	I_JournalEntry	SenderFiscalYear	Sender FiscalYr
	JrnlEntryCntrySpecificRef1	I_JournalEntry	JrnlEntryCntrySpecificRef1	Country/Region Specific Reference 1
	JrnlEntryCntrySpecificDate1	I_JournalEntry	JrnlEntryCntrySpecificDate1	Country/Region Specific Date 1
	JrnlEntryCntrySpecificRef2	I_JournalEntry	JrnlEntryCntrySpecificRef2	Country/Region Specific Reference 2
	JrnlEntryCntrySpecificDate2	I_JournalEntry	JrnlEntryCntrySpecificDate2	Country/Region Specific Date 2
	JrnlEntryCntrySpecificRef3	I_JournalEntry	JrnlEntryCntrySpecificRef3	Country/Region Specific Reference 3
	JrnlEntryCntrySpecificDate3	I_JournalEntry	JrnlEntryCntrySpecificDate3	Country/Region Specific Date 3
	JrnlEntryCntrySpecificRef4	I_JournalEntry	JrnlEntryCntrySpecificRef4	Country/Region Specific Reference 4
	JrnlEntryCntrySpecificDate4	I_JournalEntry	JrnlEntryCntrySpecificDate4	Country/Region Specific Date 4
	JrnlEntryCntrySpecificRef5	I_JournalEntry	JrnlEntryCntrySpecificRef5	Country/Region Specific Reference 5
	JrnlEntryCntrySpecificDate5	I_JournalEntry	JrnlEntryCntrySpecificDate5	Country/Region Specific Date 5
	JrnlEntryCntrySpecificBP1	I_JournalEntry	JrnlEntryCntrySpecificBP1	Ctry/Reg. Specific Business Partner 1
	JrnlEntryCntrySpecificBP2	I_JournalEntry	JrnlEntryCntrySpecificBP2	Ctry/Reg. Specific Business Partner 2
	InvoiceReference	P_JournalEntryItem	InvoiceReference	Invoice Reference
	InvoiceReferenceFiscalYear	P_JournalEntryItem	InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
	ReferenceDocument
	ReferenceDocumentContext
	FinancialAccountType	P_JournalEntryItem	FinancialAccountType	Fin. Account Type
	Supplier
	Customer
	ReportingCountry	P_StRpBPTaxItem1	ReportingCountry
	InvoiceNumber	P_DefTaxTransfer	InvoiceNumber	Invoice Number
	InvoiceFiscalYear	P_DefTaxTransfer	InvoiceFiscalYear
	InvoiceDocumentItem	P_DefTaxInvoiceItem	AccountingDocumentItem	Posting View Item

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_StRpBPTaxItem14.
-- 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: PSTRPBPTAXITEM14

CREATE VIEW P_StRpBPTaxItem14 AS
SELECT
  P_TaxItem.CompanyCode AS CompanyCode,
  P_TaxItem.AccountingDocument AS AccountingDocument,
  P_TaxItem.FiscalYear AS FiscalYear,
  P_TaxItem.TaxItem AS TaxItem,
  P_JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  P_TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_TaxItem.TaxCode AS TaxCode,
  P_TaxItem.GLAccount AS GLAccount,
  P_TaxItem.TaxType AS TaxType,
  P_TaxItem.TaxResultManualModification AS TaxResultManualModification,
  P_TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  P_TaxItem.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  P_TaxItem.VATRegistration AS VATRegistration,
  P_TaxItem.TaxJurisdiction AS TaxJurisdiction,
  P_TaxItem.ConditionType AS ConditionType,
  cast (DIVISION(P_TaxItem.TaxRate,10,2) as kbetr_tax) AS TaxRate,
  P_TaxItem.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  P_TaxItem.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  P_TaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  P_TaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_JournalEntry.DocumentDate AS DocumentDate,
  I_JournalEntry.PostingDate AS PostingDate,
  cast( SUBSTRING( I_JournalEntry.FiscalPeriod, 2, 2 ) as monat ) AS PostingFiscalPeriod,
  I_JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  I_JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  I_JournalEntry.ReverseDocument AS ReverseDocument,
  I_JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  I_JournalEntry.TaxBaseAmountIsNetAmount AS TaxBaseAmountIsNetAmount,
  I_JournalEntry.TaxReportingDate AS TaxReportingDate,
  I_JournalEntry.SenderLogicalSystem AS SenderLogicalSystem,
  I_JournalEntry.SenderCompanyCode AS SenderCompanyCode,
  I_JournalEntry.SenderAccountingDocument AS SenderAccountingDocument,
  I_JournalEntry.SenderFiscalYear AS SenderFiscalYear,
  I_JournalEntry.JrnlEntryCntrySpecificRef1 AS JrnlEntryCntrySpecificRef1,
  I_JournalEntry.JrnlEntryCntrySpecificDate1 AS JrnlEntryCntrySpecificDate1,
  I_JournalEntry.JrnlEntryCntrySpecificRef2 AS JrnlEntryCntrySpecificRef2,
  I_JournalEntry.JrnlEntryCntrySpecificDate2 AS JrnlEntryCntrySpecificDate2,
  I_JournalEntry.JrnlEntryCntrySpecificRef3 AS JrnlEntryCntrySpecificRef3,
  I_JournalEntry.JrnlEntryCntrySpecificDate3 AS JrnlEntryCntrySpecificDate3,
  I_JournalEntry.JrnlEntryCntrySpecificRef4 AS JrnlEntryCntrySpecificRef4,
  I_JournalEntry.JrnlEntryCntrySpecificDate4 AS JrnlEntryCntrySpecificDate4,
  I_JournalEntry.JrnlEntryCntrySpecificRef5 AS JrnlEntryCntrySpecificRef5,
  I_JournalEntry.JrnlEntryCntrySpecificDate5 AS JrnlEntryCntrySpecificDate5,
  I_JournalEntry.JrnlEntryCntrySpecificBP1 AS JrnlEntryCntrySpecificBP1,
  I_JournalEntry.JrnlEntryCntrySpecificBP2 AS JrnlEntryCntrySpecificBP2,
  P_JournalEntryItem.InvoiceReference AS InvoiceReference,
  P_JournalEntryItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  left(I_JournalEntry.OriginalReferenceDocument,10) AS ReferenceDocument,
  substring(I_JournalEntry.OriginalReferenceDocument,11,10) AS ReferenceDocumentContext,
  P_JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  coalesce(P_DefTaxInvoiceItem.Supplier, P_JournalEntryItem.Supplier) AS Supplier,
  coalesce(P_DefTaxInvoiceItem.Customer, P_JournalEntryItem.Customer) AS Customer,
  P_TaxItem.ReportingCountry AS ReportingCountry,
  P_DefTaxTransfer.InvoiceNumber AS InvoiceNumber,
  P_DefTaxTransfer.InvoiceFiscalYear AS InvoiceFiscalYear,
  P_DefTaxInvoiceItem.AccountingDocumentItem AS InvoiceDocumentItem
FROM P_StRpBPTaxItem1 AS P_TaxItem
;

Depth:

P_StRpBPTaxItem14 view

P_StRpBPTaxItem1 view

I_StRpBPTaxItem view