P_BOPRevnCostItemToFormItemU

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_BOPRevnCostItemToFormItemU.
-- 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_BOPRevnCostItemToFormItemU AS
SELECT
  P_BOPRevnCostItemToFormItem10.Ledger AS Ledger,
  P_BOPRevnCostItemToFormItem10.SourceLedger AS SourceLedger,
  P_BOPRevnCostItemToFormItem10.CompanyCode AS CompanyCode,
  P_BOPRevnCostItemToFormItem10.AccountingDocument AS AccountingDocument,
  P_BOPRevnCostItemToFormItem10.FiscalYear AS FiscalYear,
  P_BOPRevnCostItemToFormItem10.LedgerGLLineItem AS LedgerGLLineItem,
  cast( '' as fica_opbel ) AS CADocument,
  cast( '0000' as fica_gl_item preserving type ) AS CAGLItemNumber,
  P_BOPRevnCostItemToFormItem10.BOPForm AS BOPForm,
  P_BOPRevnCostItemToFormItem10.BOPRptgCntry AS BOPRptgCntry,
  P_BOPRevnCostItemToFormItem10.BOPFormItem AS BOPFormItem,
  P_BOPRevnCostItemToFormItem10.CompanyCodeCountry AS CompanyCodeCountry,
  P_BOPRevnCostItemToFormItem10.StatryRptgEntity AS StatryRptgEntity,
  P_BOPRevnCostItemToFormItem10.StatryRptCategory AS StatryRptCategory,
  P_BOPRevnCostItemToFormItem10.StatryRptRunID AS StatryRptRunID,
  P_BOPRevnCostItemToFormItem10.AccountingDocumentItem AS AccountingDocumentItem,
  cast( '' as fikey_kk ) AS CAReconciliationKey,
  cast( '' as bu_partner ) AS BusinessPartner,
  P_BOPRevnCostItemToFormItem10.PostingDate AS PostingDate,
  P_BOPRevnCostItemToFormItem10.ClearingDate AS ClearingDate,
  P_BOPRevnCostItemToFormItem10.ChartOfAccounts AS ChartOfAccounts,
  P_BOPRevnCostItemToFormItem10.GLAccount AS GLAccount,
  P_BOPRevnCostItemToFormItem10.TaxCode AS TaxCode,
  P_BOPRevnCostItemToFormItem10.AccountingDocumentType AS AccountingDocumentType,
  P_BOPRevnCostItemToFormItem10.IsEUTriangularDeal AS IsEUTriangularDeal,
  P_BOPRevnCostItemToFormItem10.SpecialGLCode AS SpecialGLCode,
  P_BOPRevnCostItemToFormItem10.DebitCreditCode AS DebitCreditCode,
  P_BOPRevnCostItemToFormItem10.TransactionCurrency AS TransactionCurrency,
  P_BOPRevnCostItemToFormItem10.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_BOPRevnCostItemToFormItem10.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_BOPRevnCostItemToFormItem10.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_BOPRevnCostItemToFormItem10.ClearingJournalEntry AS ClearingJournalEntry,
  P_BOPRevnCostItemToFormItem10.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  cast( '' as augbl_kk ) AS CAClearingAccountingDocument,
  P_BOPRevnCostItemToFormItem10.FinancialAccountType AS FinancialAccountType,
  P_BOPRevnCostItemToFormItem10.ImportExportFinancialAccType AS ImportExportFinancialAccType,
  P_BOPRevnCostItemToFormItem10.OffsettingAccountType AS OffsettingAccountType,
  P_BOPRevnCostItemToFormItem10.OffsettingAccount AS OffsettingAccount,
  P_BOPRevnCostItemToFormItem10.PartnerCompany AS PartnerCompany,
  P_BOPRevnCostItemToFormItem10.Customer AS Customer,
  P_BOPRevnCostItemToFormItem10.Supplier AS Supplier,
  P_BOPFICA_GL_RESULT.CADocumentType AS CADocumentType,
  P_BOPFICA_GL_RESULT.BOPPartnerCntry AS BOPPartnerCntry
FROM P_BOPRevnCostItemToFormItem10
-- UNION ALL with additional select branch(es): P_BOPRevnCostItemToFormItem25, P_BOPFICA_GL_RESULT
;