C_IHBAccountWorkflow

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_IHBAccountWorkflow.
-- 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 C_IHBAccountWorkflow AS
SELECT
  R_IHBAccountTP.IHBAccountUUID AS IHBAccountUUID,
  _IHBAccountTTP[1:IHBAccountLanguage = $session.system_language ].IHBAccountDescription AS IHBAccountDescription,
  R_IHBAccountTP.IHBBankArea AS IHBBankArea,
  R_IHBAccountTP.IHBAccountNumber AS IHBAccountNumber,
  R_IHBAccountTP.IHBAccountCurrency AS IHBAccountCurrency,
  R_IHBAccountTP.IHBAccountAliasName AS IHBAccountAliasName,
  R_IHBAccountTP.IHBAccountHolder AS IHBAccountHolder,
  R_IHBAccountTP.IHBAccountStatus AS IHBAccountStatus,
  _IHBAccountStatusText[1:Language = $session.system_language ].IHBAccountStatusText AS IHBAccountStatusText,
  cast('X' as abap_boolean preserving type) AS IsActiveEntity,
  _IHBAccountStatusCriticality.IHBAccountStatusCriticality AS IHBAccountStatusCriticality,
  IHBAccountApprovalActivity,
  _IHBAccountActivity.IHBAccountActivityText AS IHBAccountActivityText,
  IHBAccountIsTemplate,
  IHBAccountGroupName,
  IHBAccountGLGroup,
  _IHBBankArea.IHBBankKey AS IHBBankKey,
  _IHBBankArea.IHBBankAreaCountry AS IHBBankAreaCountry
FROM R_IHBAccountTP
LEFT OUTER JOIN C_IHBAccountChangeDocument AS _IHBAccountChangeDocument ON IHBAccountUUID = _IHBAccountChangeDocument.IHBAccountUUID  -- association [0..*]
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]
;