VFCLM_BKANT_SYNC_STATUS

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 VFCLM_BKANT_SYNC_STATUS.
-- 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: VFCLM_BKANT_VW

CREATE VIEW VFCLM_BKANT_SYNC_STATUS AS
SELECT
  TargetSystem,
  AccountID,
  AccountNumber,
  Currency,
  CompanyCode,
  BankKey,
  BankCountry,
  cast( _bankcountrytext.landx50 as abap.char( 50 ) ) AS CountryName,
  _record.status AS Status,
  _record.StatusText AS StatusText,
  _record.SyncPerson AS SyncPerson,
  _record.SyncDate AS SyncDate,
  _record.SyncTime AS SyncTime,
  _record.SyncStatus AS SyncStatus,
  _record.CmpPerson AS CmpPerson,
  _record.CmpDate AS CmpDate,
  _record.CmpTime AS CmpTime,
  _record.CmpStatus AS CmpStatus,
  _record.updatedate AS LastUpdateDate,
  _record.updatetime AS LastUpdateTime,
  cast( '' as abap.char( 50 ) ) AS LastUpdateAt,
  cast( '' as abap.sstring( 1333 ) ) AS Generated_ID,
  cast( '' as abap.char( 1 ) ) AS Log,
  _record.extnumber AS ExternalNumber,
  _amd.ValidFrom AS ValidFrom,
  _amd.ValidTo AS ValidTo,
  _amd.IBAN AS IBAN,
  _amd.Status AS BankAccountStatus,
  _amd.ProfitCenter AS ProfitCenter,
  _amd.BusinessArea AS BusinessArea,
  _amd.Segment AS Segment,
  _amd.AccountHolder AS AccountHolder,
  _amd.BankContact AS BankContact,
  _amd.RelationshipManager AS RelationshipManager,
  _amd.CompanyContact AS CompanyContact,
  _amd.AccountSupervisor AS AccountSupervisor,
  _amd.CreatedAtDate AS CreatedAtDate,
  _amd.CreatedAtTime AS CreatedAtTime,
  _amd.CreatedBy AS CreatedBy,
  _amd.OpenedBy AS OpenedBy,
  _amd.ChangedAtDate AS ChangedAtDate,
  _amd.ChangedAtTime AS ChangedAtTime,
  _amd.ChangedBy AS ChangedBy,
  _amd.ReviewedByUser AS ReviewedByUser,
  _amd.ClosedBy AS ClosedBy,
  _amd.deleted_flag AS deleted_flag,
  _amd.CutOffDomestic AS CutOffDomestic,
  _amd.CutOffCrossBorder AS CutOffCrossBorder,
  _amd.CompanyCodeDesp AS CompanyCodeDesp,
  _amd.BankControlKey AS BankControlKey,
  _amd.IBANValidityStartDate AS IBANValidityStartDate,
  _amd.AccountType AS AccountType
FROM Fclm_Bam_Bankacnt_Config AS _amd
LEFT OUTER JOIN t005t AS _bankcountrytext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_SYNCRECORD AS _record ON _record.targetsystem = _amd.Targetsystem AND _record.AccountID = _amd.AccountID AND _record.SyncObject = '0'  -- association [0..1]
;