C_IHBAcctLimitObjectWrkflw

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_IHBAcctLimitObjectWrkflw.
-- 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_IHBAcctLimitObjectWrkflw AS
SELECT
  IHBObjectUUID,
  IHBObjectReferenceUUID,
  IHBObjectType,
  IHBObjectCategory,
  IHBObjectKeyUUID,
  IHBReleaseStatus,
  IHBObjectApprovalActivity,
  IHBBankArea,
  _IHBGroupType.InhouseBankGroupID AS InhouseBankGroupID,
  _IHBAccount.IHBAccountNumber AS IHBAccountNumber,
  IHBObjectLevel,
  _IHBObjectLevel._IHBObjectLevelT[1:Language = $session.system_language ].IHBObjectLevelText AS IHBObjectLevelText,
  cast('X' as abap_boolean) AS IsActiveEntity
FROM R_IHBMasterDataObjectTP
LEFT OUTER JOIN C_IHBAcctLmtGrpAssgmtWrkflw AS _IHBGroupAssignmentWrkflw ON _IHBGroupAssignmentWrkflw.IHBObjectUUID = IHBObjectUUID  -- association [0..*]
LEFT OUTER JOIN C_IHBAcctLmtWrkflw AS _IHBAcctLimitWrkflw ON _IHBAcctLimitWrkflw.IHBObjectUUID = IHBObjectUUID  -- association [0..*]
LEFT OUTER JOIN C_IHBMstrDataObjChangeDocument AS _IHBAccountLimitChangeDocument ON IHBObjectUUID = _IHBAccountLimitChangeDocument.IHBObjectUUID  -- association [0..*]
;