C_IHBAcctLimitObjectTP

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_IHBAcctLimitObjectTP.
-- 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_IHBAcctLimitObjectTP AS
SELECT
  IHBObjectUUID,
  IHBObjectReferenceUUID,
  IHBObjectType,
  IHBObjectCategory,
  IHBObjectKeyUUID,
  IHBReleaseStatus,
  _IHBObjectReleaseStatus._IHBObjectReleaseStatusT[1:Language = $session.system_language ].IHBReleaseStatusText AS IHBReleaseStatusText,
  _IHBObjectRelStsCriticality.IHBReleaseStatusCriticality AS IHBReleaseStatusCriticality,
  _IHBGroupType.InhouseBankGroupID AS InhouseBankGroupID,
  _IHBAccount.IHBAccountNumber AS IHBAccountNumber,
  _IHBBankArea._IHBBankAreaText[1:IHBBankAreaLanguage = $session.system_language ].IHBBankAreaDescription AS IHBBankAreaDescription,
  IHBBankArea,
  IHBObjectLevel,
  _IHBObjectLevel._IHBObjectLevelT[1:Language = $session.system_language ].IHBObjectLevelText AS IHBObjectLevelText,
  IHBObjectTotalChangedDateTime,
  IHBObjectCreatedDateTime,
  IHBObjectCreatedByUser,
  IHBObjectChangedDateTime,
  IHBObjectChangedByUser,
  _IHBAccount._IHBAccountText[1:IHBAccountLanguage = $session.system_language ].IHBAccountDescription AS IHBAccountDescription,
  _IHBAccount.IHBAccountAliasName AS IHBAccountAliasName,
  _IHBAccount.IHBAccountHolder AS IHBAccountHolder,
  _IHBAccount.IHBAccountCurrency AS IHBAccountCurrency,
  _IHBBankArea.IHBBankKey AS IHBBankKey,
  _IHBBankArea.IHBBankAreaCountry AS IHBBankAreaCountry,
  virtual IHBObjectNavigationUUID : uuid AS virtualIHBObjectNavigationUUIDuuid,
  virtual IHBObjectHeaderType : char20 AS virtualIHBObjectHeaderTypechar20,
  virtual UICT_IHBAccountSectionIsHidden : abap.char( 1 ) AS char1
FROM R_IHBMasterDataObjectTP
LEFT OUTER JOIN C_IHBMstrDataObjChangeDocument AS _IHBMstrDataObjChangeDocument ON IHBObjectUUID = _IHBMstrDataObjChangeDocument.IHBObjectUUID  -- association [0..*]
LEFT OUTER JOIN C_IHBBankAreaCard AS _IHBBankAreaCard ON IHBBankArea = _IHBBankAreaCard.IHBBankArea  -- association [0..1]
LEFT OUTER JOIN E_InhouseBankMasterObject AS _Extension ON IHBObjectUUID = _Extension.IHBObjectUUID  -- association [1]
;