C_IHBAccountApprovalStartEml

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 C_IHBAccountApprovalStartEml.
-- 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: CIHBARRPEML2

CREATE VIEW C_IHBAccountApprovalStartEml AS
SELECT
  _Workflowtask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _IHBAccountTP.IHBAccountUUID AS IHBAccountUUID,
  _IHBAccountTP.IHBAccountApprovalActivity AS IHBAccountApprovalActivity,
  _IHBAccountActivity.IHBAccountActivityText AS IHBAccountActivityText,
  _IHBAccountTP.IHBBankArea AS IHBBankArea,
  _IHBBankArea.IHBBankKey AS IHBBankKey,
  _IHBBankArea.IHBBankAreaCountry AS IHBBankAreaCountry,
  _IHBAccountTP.IHBAccountNumber AS IHBAccountNumber,
  _IHBAccountTP.IHBAccountCurrency AS IHBAccountCurrency,
  _IHBAccountTP.IHBAccountHolder AS IHBAccountHolder,
  _IHBAccountTP.IHBAccountAliasName AS IHBAccountAliasName,
  _IHBAccountTP.IHBAccountGroupName AS IHBAccountGroupName,
  _IHBAccountTP.IHBAccountChangedByUser AS IHBAccountChangedByUser,
  _IHBAccountTP._ChangedBy.UserDescription AS IHBAccountChangedByUserText,
  cast(tstmp_to_dats( _IHBAccountTP.IHBAccountChangedDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd ) AS IHBAccountChangedDate,
  cast(tstmp_to_tims( _IHBAccountTP.IHBAccountChangedDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst ) AS IHBAccountChangedTime,
  _WorkflowTaskURL.WorkflowTaskURL AS WorkflowTaskURL
FROM I_WorkflowTask AS _Workflowtask
LEFT OUTER JOIN I_WorkflowTaskURL AS _WorkflowTaskURL ON WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID  -- association [0..1]
LEFT OUTER JOIN I_IHBBankArea AS _IHBBankArea ON IHBBankArea = _IHBBankArea.IHBBankArea  -- association [0..1]
LEFT OUTER JOIN C_IHBAccountActivityVH AS _IHBAccountActivity ON IHBAccountApprovalActivity = _IHBAccountActivity.IHBAccountActivity  -- association [0..1]
;