P_FAGLBSAS_BCK

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_FAGLBSAS_BCK.
-- 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: PFAGLBSASBCK

CREATE VIEW P_FAGLBSAS_BCK AS
SELECT
  cast( bukrs as fis_bukrs ) AS CompanyCode,
  cast( hkont as fis_racct ) AS GLAccount,
  cast( augdt as fis_augdt ) AS ClearingDate,
  cast( augbl as farp_augbl preserving type ) AS ClearingJournalEntry,
  cast( zuonr as fis_zuonr ) AS AssignmentReference,
  cast( gjahr as fis_gjahr ) AS FiscalYear,
  cast( belnr as farp_belnr_d ) AS AccountingDocument,
  cast( buzei as fis_buzei ) AS AccountingDocumentItem,
  cast( auggj as fis_auggj_no_conv preserving type ) AS ClearingJournalEntryFiscalYear,
  cast( blart as farp_blart ) AS AccountingDocumentType,
  cast( bldat as fis_bldat ) AS DocumentDate,
  cast( budat as fis_budat ) AS PostingDate,
  cast( sgtxt as farp_sgtxt ) AS DocumentItemText,
  cast( rebzg as fis_rebzg ) AS InvoiceReference,
  cast( rebzt as farp_rebzt ) AS FollowOnDocumentType,
  cast( bstat as fis_bstat ) AS AccountingDocumentCategory,
  buzid AS AccountingDocumentItemType,
  rfzei AS PaymentCardItem,
  cast( waers as fis_rwcur ) AS TransactionCurrency
FROM faglbsas_bck
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;