I_StRpBPTaxItem

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 I_StRpBPTaxItem.
-- 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: ISTRPBPTAXITEM

CREATE VIEW I_StRpBPTaxItem AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  AccountingDocumentItem,
  TransactionTypeDetermination,
  TaxCode,
  GLAccount,
  TaxType,
  TaxResultManualModification,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInTransCrcy,
  VATRegistration,
  TaxJurisdiction,
  ConditionType,
  TaxRate,
  TaxReturnCountry,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInCountryCrcy,
  CompanyCodeCurrency,
  CompanyCodeCountry,
  DocumentCurrency,
  CountryCurrency,
  TaxCalculationProcedure,
  TaxRateValidityStartDate,
  DocumentDate,
  PostingDate,
  PostingFiscalPeriod,
  ReferenceDocumentType,
  DocumentReferenceID,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  OriginalReferenceDocument,
  AccountingDocumentType,
  TaxBaseAmountIsNetAmount,
  TaxReportingDate,
  SenderLogicalSystem,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  JrnlEntryCntrySpecificRef1,
  JrnlEntryCntrySpecificDate1,
  JrnlEntryCntrySpecificRef2,
  JrnlEntryCntrySpecificDate2,
  JrnlEntryCntrySpecificRef3,
  JrnlEntryCntrySpecificDate3,
  JrnlEntryCntrySpecificRef4,
  JrnlEntryCntrySpecificDate4,
  JrnlEntryCntrySpecificRef5,
  JrnlEntryCntrySpecificDate5,
  JrnlEntryCntrySpecificBP1,
  JrnlEntryCntrySpecificBP2,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  ReferenceDocument,
  ReferenceDocumentContext,
  FinancialAccountType,
  Supplier,
  Customer,
  ReportingCountry,
  ReportingDate,
  InvoiceNumber AS DeferTaxReferenceDocument,
  InvoiceFiscalYear AS DeferTaxReferenceFiscalYear,
  InvoiceDocumentItem AS DeferTaxReferenceDocumentItem
FROM P_StRpBPTaxItem14
LEFT OUTER JOIN I_ReceivablesPayablesItem AS _ReceivablesPayablesItem ON CompanyCode = _ReceivablesPayablesItem.CompanyCode AND FiscalYear = _ReceivablesPayablesItem.FiscalYear AND AccountingDocument = _ReceivablesPayablesItem.AccountingDocument AND AccountingDocumentItem = _ReceivablesPayablesItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON CompanyCode = _AccountingDocument.CompanyCode AND AccountingDocument = _AccountingDocument.AccountingDocument AND FiscalYear = _AccountingDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_OneTimeAccountBP AS _OneTimeAccountBP ON CompanyCode = _OneTimeAccountBP.CompanyCode AND AccountingDocument = _OneTimeAccountBP.AccountingDocument AND FiscalYear = _OneTimeAccountBP.FiscalYear AND AccountingDocumentItem = _OneTimeAccountBP.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_OneTimeAccountBP AS _OneTimeDefTaxAccountBP ON CompanyCode = _OneTimeDefTaxAccountBP.CompanyCode AND DeferTaxReferenceDocument = _OneTimeDefTaxAccountBP.AccountingDocument AND DeferTaxReferenceFiscalYear = _OneTimeDefTaxAccountBP.FiscalYear AND DeferTaxReferenceDocumentItem = _OneTimeDefTaxAccountBP.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_BillingDocument AS _BillingDocument ON ReferenceDocumentType = 'VBRK' AND OriginalReferenceDocument = _BillingDocument.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_CFinBillingDocument AS _CFinBillingDocument ON OriginalReferenceDocument = _CFinBillingDocument.CentralFinanceBillingDocument AND ReferenceDocumentType = 'VBRK' AND SenderLogicalSystem = _CFinBillingDocument.SenderLogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoice AS _SupplierInvoice ON ReferenceDocumentType = 'RMRP' AND ReferenceDocument = _SupplierInvoice.SupplierInvoice AND ReferenceDocumentContext = _SupplierInvoice.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_CFinSupplierInvoice AS _CFinSupplierInvoice ON SenderLogicalSystem = _CFinSupplierInvoice.SenderLogicalSystem AND ReferenceDocumentType = 'RMRP' AND ReferenceDocument = _CFinSupplierInvoice.CentralFinanceSupplierInvoice AND ReferenceDocumentContext = _CFinSupplierInvoice.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_TaxType AS _TaxType ON TaxType = _TaxType.TaxType  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxCalculationProcedure = _TaxJurisdiction.TaxJurisdictionCalcProcedure AND TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerToBusinessPartner ON Customer = _CustomerToBusinessPartner.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier_to_BusinessPartner AS _SupplierToBusinessPartner ON Supplier = _SupplierToBusinessPartner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CompanyCodeCountry ON CompanyCodeCountry = _CompanyCodeCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxReturnCountry ON TaxReturnCountry = _TaxReturnCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CountryCurrency ON CountryCurrency = _CountryCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_StRpJournalEntryLog AS _ReportedItemsLog ON _ReportedItemsLog.CompanyCode = CompanyCode AND _ReportedItemsLog.AccountingDocument = AccountingDocument AND _ReportedItemsLog.FiscalYear = FiscalYear  -- association [0..*]
;