P_ARBSITMCLRITEM03

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_ARBSITMCLRITEM03.
-- 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: PARBSITMCLRITEM3

CREATE VIEW P_ARBSITMCLRITEM03 AS
SELECT
  ReceivableItem.CompanyCode AS CompanyCode,
  ReceivableItem.FiscalYear AS FiscalYear,
  ReceivableItem.AccountingDocument AS AccountingDocument,
  ReceivableItem.AccountingDocumentItem AS AccountingDocumentItem,
  ReceivableItem.AccountingDocumentType AS AccountingDocumentType,
  ReceivableItem.PostingDate AS PostingDate,
  ReceivableItem.DocumentReferenceID AS DocumentReferenceID,
  ReceivableItem.AssignmentReference AS AssignmentReference,
  ReceivableItem.PaymentReference AS PaymentReference,
  ReceivableItem.BillingDocument AS BillingDocument,
  ReceivableItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  ReceivableItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  ReceivableItem.ClearingDate AS ClearingDate,
  ReceivableItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  ReceivableItem.TransactionCurrency AS TransactionCurrency,
  ReceivableItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  ReceivableItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  ReceivableItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  ReceivableItem.TaxAmount AS TaxAmount,
  ReceivableItem.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  ReceivableItem.CashDiscountAmount AS CashDiscountAmount,
  ReceivableItem.DebitCreditCode AS DebitCreditCode,
  ReceivableItem.DocumentItemText AS DocumentItemText,
  ReceivableItem.FinancialAccountType AS FinancialAccountType,
  ReceivableItem.InvoiceReference AS InvoiceReference,
  ReceivableItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  ReceivableItem.InvoiceItemReference AS InvoiceItemReference,
  ReceivableItem.FollowOnDocumentType AS FollowOnDocumentType,
  ReceivableItem.Debtor AS Debtor,
  ReceivableItem.OrganizationBPName1 AS OrganizationBPName1,
  ReceivableItem.OrganizationBPName2 AS OrganizationBPName2,
  ReceivableItem.OrganizationBPName3 AS OrganizationBPName3,
  ReceivableItem.OrganizationBPName4 AS OrganizationBPName4,
  ReceivableItem.CityName AS CityName,
  ReceivableItem.Country AS Country,
  ReceivableItem.PartnerCompany AS PartnerCompany
FROM P_ARBSITMCLRITEM01 AS ReceivableItem
INNER JOIN P_ARBSITMBANKSTMT01 AS BankStatementItem ON /* join condition not captured in parsed metadata */
;