P_BOPFICA_GL_ITEM

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_ITEM.
-- 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_ITEM AS
SELECT
  fica_itm_gl.CompanyCode AS CompanyCode,
  fica_itm_bp.FiscalYear AS FiscalYear,
  fica_itm_bp.CADocumentNumber AS CADocumentNumber,
  cast( fica_itm_gl.CAGLItemNumber as fica_gl_item) AS CAGLItemNumber,
  cast( '' as fica_opupz) AS CASubItemNumber,
  cast( '' as fica_opupk) AS CABPItemNumber,
  fica_itm_bp.BOPRptgCntry AS BOPRptgCntry,
  fica_itm_bp.BOPForm AS BOPForm,
  fica_itm_bp.CompanyCodeCountry AS CompanyCodeCountry,
  fica_itm_bp.CAPostingDate AS CAPostingDate,
  fica_itm_bp.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  fica_itm_bp.CAReconciliationKey AS CAReconciliationKey,
  fica_itm_gl.ChartOfAccounts AS ChartOfAccounts,
  fica_itm_gl.GLAccount AS GLAccount,
  fica_itm_gl.TaxCode AS TaxCode,
  fica_itm_bp.CADocumentType AS CADocumentType,
  fica_itm_gl.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  fica_itm_gl.TransactionCurrency AS TransactionCurrency,
  fica_itm_bp.CompanyCodeCurrency AS CompanyCodeCurrency,
  fica_itm_gl.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  fica_itm_bp.CAClearingDate AS CAClearingDate,
  fica_itm_bp.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  fica_itm_bp.BusinessPartner AS BusinessPartner,
  fica_itm_bp.BOPPartnerCntry AS BOPPartnerCntry,
  fica_itm_gl.PartnerCompany AS PartnerCompany,
  cast('S' as farp_koart ) AS FinancialAccountType,
  fica_itm_gl.LedgerGroup AS LedgerGroup
FROM P_BOPFICA_BP_ITEM_2 AS fica_itm_bp
INNER JOIN I_CADocumentGLItem AS fica_itm_gl ON /* join condition not captured in parsed metadata */
;