P_BOPFICA_GL_RESULT

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_BOPFICA_GL_RESULT.
-- 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_BOPFICA_GL_RESULT AS
SELECT
  gl_item.CompanyCode AS CompanyCode,
  gl_item.CADocumentNumber AS CADocumentNumber,
  gl_item.FiscalYear AS FiscalYear,
  gl_item.CAGLItemNumber AS CAGLItemNumber,
  gl_item.BOPRptgCntry AS BOPRptgCntry,
  gl_item.BOPForm AS BOPForm,
  fir.BOPFormItem AS BOPFormItem,
  log.StatryRptCategory AS StatryRptCategory,
  log.StatryRptgEntity AS StatryRptgEntity,
  log.StatryRptRunID AS StatryRptRunID,
  gl_item.CAReconciliationKey AS CAReconciliationKey,
  cast('' as umskz) AS SpecialGLCode,
  gl_item.CompanyCodeCountry AS CompanyCodeCountry,
  gl_item.BOPPartnerCntry AS BOPPartnerCntry,
  gl_item.FinancialAccountType AS FinancialAccountType,
  gl_item.CAPostingDate AS PostingDate,
  gl_item.ChartOfAccounts AS ChartOfAccounts,
  gl_item.GLAccount AS GLAccount,
  gl_item.TaxCode AS TaxCode,
  gl_item.CADocumentType AS CADocumentType,
  cast('' as belnr_d) AS AccountingDocument,
  cast('' as blart) AS AccountingDocumentType,
  gl_item.TransactionCurrency AS TransactionCurrency,
  gl_item.CAAmountInTransactionCurrency AS AmountInTransactionCurrency,
  gl_item.CompanyCodeCurrency AS CompanyCodeCurrency,
  gl_item.CAAmountInLocalCurrency AS AmountInCompanyCodeCurrency,
  gl_item.CAClearingDate AS ClearingDate,
  gl_item.CAClearingDocumentNumber AS CAClearingAccountingDocument,
  gl_item.BusinessPartner AS BusinessPartner,
  cast( 'D' as farp_koart ) AS ImportExportFinancialAccType,
  gl_item.FinancialAccountType AS OffsettingAccountType,
  gl_item.PartnerCompany AS PartnerCompany
FROM P_BOPFICA_GL_ITEM AS gl_item
INNER JOIN I_BOPContractAccountFormRule AS fir ON /* join condition not captured in parsed metadata */
;