P_BOPRblsPyblsItemToFormItemU

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_BOPRblsPyblsItemToFormItemU.
-- 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_BOPRblsPyblsItemToFormItemU AS
SELECT
  P_BOPRblsPyblsItemToFormItemR.CompanyCode AS CompanyCode,
  P_BOPRblsPyblsItemToFormItemR.AccountingDocument AS AccountingDocument,
  P_BOPRblsPyblsItemToFormItemR.FiscalYear AS FiscalYear,
  P_BOPRblsPyblsItemToFormItemR.AccountingDocumentItem AS AccountingDocumentItem,
  cast( '' as fica_opbel ) AS CADocument,
  cast( '000' as fica_opupz preserving type ) AS CASubItemNumber,
  cast( '0000' as fica_opupk preserving type ) AS CABPItemNumber,
  cast ( '000' as opupw_kk preserving type ) AS CARepetitionItemNumber,
  cast ( '' as ca_isoffsetting preserving type ) AS CAItemIsOffsetting,
  cast ( '' as ca_isdoubtful preserving type ) AS CAItemIsDoubtful,
  P_BOPRblsPyblsItemToFormItemR.BOPForm AS BOPForm,
  P_BOPRblsPyblsItemToFormItemR.BOPRptgCntry AS BOPRptgCntry,
  P_BOPRblsPyblsItemToFormItemR.BOPFormItem AS BOPFormItem,
  P_BOPRblsPyblsItemToFormItemR.CompanyCodeCountry AS CompanyCodeCountry,
  P_BOPRblsPyblsItemToFormItemR.StatryRptgEntity AS StatryRptgEntity,
  P_BOPRblsPyblsItemToFormItemR.StatryRptCategory AS StatryRptCategory,
  P_BOPRblsPyblsItemToFormItemR.StatryRptRunID AS StatryRptRunID,
  P_BOPRblsPyblsItemToFormItemR.PostingDate AS PostingDate,
  cast( '' as fikey_kk ) AS CAReconciliationKey,
  cast( '' as bu_partner ) AS BusinessPartner,
  P_BOPRblsPyblsItemToFormItemR.ClearingDate AS ClearingDate,
  P_BOPRblsPyblsItemToFormItemR.ChartOfAccounts AS ChartOfAccounts,
  P_BOPRblsPyblsItemToFormItemR.GLAccount AS GLAccount,
  P_BOPRblsPyblsItemToFormItemR.TaxCode AS TaxCode,
  P_BOPRblsPyblsItemToFormItemR.AccountingDocumentType AS AccountingDocumentType,
  P_BOPRblsPyblsItemToFormItemR.IsEUTriangularDeal AS IsEUTriangularDeal,
  P_BOPRblsPyblsItemToFormItemR.SpecialGLCode AS SpecialGLCode,
  P_BOPRblsPyblsItemToFormItemR.DebitCreditCode AS DebitCreditCode,
  P_BOPRblsPyblsItemToFormItemR.TransactionCurrency AS TransactionCurrency,
  P_BOPRblsPyblsItemToFormItemR.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_BOPRblsPyblsItemToFormItemR.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_BOPRblsPyblsItemToFormItemR.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_BOPRblsPyblsItemToFormItemR.ClearingJournalEntry AS ClearingJournalEntry,
  P_BOPRblsPyblsItemToFormItemR.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  cast( '' as augbl_kk ) AS CAClearingAccountingDocument,
  P_BOPRblsPyblsItemToFormItemR.FinancialAccountType AS FinancialAccountType,
  P_BOPRblsPyblsItemToFormItemR.OffsettingAccountType AS OffsettingAccountType,
  P_BOPRblsPyblsItemToFormItemR.OffsettingAccount AS OffsettingAccount,
  P_BOPRblsPyblsItemToFormItemR.PartnerCompany AS PartnerCompany,
  P_BOPRblsPyblsItemToFormItemR.Customer AS Customer,
  P_BOPRblsPyblsItemToFormItemR.Supplier AS Supplier,
  I_BOPRptdItmsLgCA.CADocumentType AS CADocumentType,
  I_BOPRptdItmsLgCA.BOPPartnerCntry AS BOPPartnerCntry
FROM P_BOPRblsPyblsItemToFormItemR
-- UNION ALL with additional select branch(es): I_BOPRptdItmsLgCA
;