P_KR_BPAdditionalInformation

DDL: P_KR_BPADDITIONALINFORMATION SQL: PKRBPADDINFOR Type: view COMPOSITE
15 Fields 4 Data Sources

P_KR_BPAdditionalInformation is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_KR_CustVAT, I_StRpBPTaxItem, I_StRpBPTaxItem, I_KR_SupplierVATInformation) and exposes 15 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, AccountingDocument.

Data Sources (4)

SourceAliasJoin Type
I_KR_CustVAT custvat left_outer
I_StRpBPTaxItem TaxItem from
I_StRpBPTaxItem TaxItem union
I_KR_SupplierVATInformation venvat left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PKRBPADDINFOR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK 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 (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpBPTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpBPTaxItem AccountingDocument Journal Entry
KEY FiscalYear I_StRpBPTaxItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_StRpBPTaxItem TaxItem Tax Item
Customer I_StRpBPTaxItem Customer Sold-to Party
FinancialAccountType I_StRpBPTaxItem FinancialAccountType Fin. Account Type
PostingDate I_StRpBPTaxItem PostingDate Posting Date for GR
CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpBPTaxItem AccountingDocument Journal Entry
KEY FiscalYear I_StRpBPTaxItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_StRpBPTaxItem TaxItem Tax Item
vencustnum I_StRpBPTaxItem Supplier Supplier
FinancialAccountType I_StRpBPTaxItem FinancialAccountType Fin. Account Type
PostingDate I_StRpBPTaxItem PostingDate Posting Date for GR
TaxInvcNmbrValidityStartDate

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_KR_BPAdditionalInformation.
-- 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: PKRBPADDINFOR

CREATE VIEW P_KR_BPAdditionalInformation AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS AccountingDocumentItem,
  TaxItem.Customer AS Customer,
  TaxItem.FinancialAccountType AS FinancialAccountType,
  TaxItem.PostingDate AS PostingDate,
  TaxItem.Supplier AS vencustnum,
  max(venvat.TaxInvcNmbrValidityStartDate) AS TaxInvcNmbrValidityStartDate
FROM I_StRpBPTaxItem AS TaxItem
LEFT OUTER JOIN I_KR_CustVAT AS custvat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_KR_SupplierVATInformation AS venvat ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_StRpBPTaxItem
;

Learn More