C_IHBAccountTP

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_IHBAccountTP.
-- 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_IHBAccountTP AS
SELECT
  IHBAccountUUID,
  IHBAccountReferenceUUID,
  _IHBBankAreaText[1:IHBBankAreaLanguage = $session.system_language ].IHBBankAreaDescription AS IHBBankAreaDescription,
  IHBBankArea,
  IHBAccountNumber,
  _IHBAccountCurrencyText[1:Language = $session.system_language ].CurrencyName AS IHBAccountCurrencyDescription,
  IHBAccountCurrency,
  IHBAcctIdentifierIBAN,
  IHBAccountAliasName,
  _BPAccountHolder.BusinessPartnerName AS IHBAccountHolderName,
  IHBAccountHolder,
  _BPAccountGroup.BusinessPartnerName AS IHBAccountGroupBPName,
  IHBAccountGroupName,
  IHBAccountDescription,
  IHBAccountStatus,
  _IHBAccountStatusText[1:Language = $session.system_language ].IHBAccountStatusText AS IHBAccountStatusText,
  _IHBAccountStatusCriticality.IHBAccountStatusCriticality AS IHBAccountStatusCriticality,
  _IHBAccountTemplate.IHBAccountTemplateShortDesc AS IHBAccountRefTemplateShortDesc,
  IHBAccountPaymentIsBlocked,
  IHBAccountIsMrkdForDeletion,
  IHBAcctIsPreferredForAcctCrcy,
  IHBAccountBalancingIsNeeded,
  IHBAcctBalancingFrequency,
  _IHBAccountFrequencyTxt[1:Language = $session.system_language ].IHBAccountFrequencyText AS IHBAccountFrequencyText,
  IHBAcctBalancingKeyDay,
  _IHBAccountBalancingKeyDayTxt[1:Language = $session.system_language ].IHBAccountBalancingKeyDayText AS IHBAccountBalancingKeyDayText,
  IHBNextAccountBalancingDate,
  IHBAcctBalcngFreqQtrMnthNmbr,
  _IHBAcctBalFreqQtrMnthNmbrText[1:Language = $session.system_language ].IHBAcctBalFreqQtrMnthNmbrText AS IHBAcctBalFreqQtrMnthNmbrText,
  IHBAcctBalcngFreqYearMnthNmbr,
  _IHBAcctBalFreqYearMnthNmbrTxt[1:Language = $session.system_language ].IHBAcctBalFreqYearMnthNmbrText AS IHBAcctBalFreqYearMnthNmbrText,
  IHBAccountGLGroup,
  IHBAcctBankStmntIsNeeded,
  IHBAcctBkStmntFrequency,
  _IHBAccountBkStmntFrequencyTxt[1:Language = $session.system_language ].IHBAccountBkStmntFrequencyText AS IHBAccountBkStmntFrequencyText,
  IHBAcctBkStmntIsWithinDay,
  IHBAcctBkStmntSendStartTime,
  IHBAcctBkStmntSendEndTime,
  IHBAcctBkStmntSendTmznCode,
  IHBAcctBankStmntWeeklyOccren,
  _IHBAcctBkStmntWeeklyOccrenTxt[1:Language = $session.system_language ].IHBAcctBkStmntWeeklyOccrenTxt AS IHBAcctBkStmntWeeklyOccrenTxt,
  IHBAcctBkStmntNoTrnovrIsNeeded,
  _IHBAccountBkStmntKeyDayText[1:Language = $session.system_language ].IHBAccountBkStmntKeyDayText AS IHBAccountBkStmntKeyDayText,
  IHBAcctBkStmntKeyDay,
  _IHBAcctBkStmntYearMnthNmbrTxt[1:Language = $session.system_language ].IHBAcctBkStmntYearMnthNmbrText AS IHBAcctBkStmntYearMnthNmbrText,
  IHBAcctBkStmntFreqYearMnthNmbr,
  IHBAcctBalanceNotifIsNeeded,
  IHBAcctIntrstScNotifIsNeeded,
  IHBAccountCloseFromDate,
  IHBAccountRefBkAreaCode,
  IHBAccountRefAcctNumber,
  IHBAcctClosingAccountCountry,
  IHBAcctClosingAccountBankKey,
  IHBAcctClosingAccountBIC,
  IHBAcctClosingAccountIBAN,
  IHBAcctClosingAccountNumber,
  IHBAcctClosingAccountCurrency,
  IHBAcctClosingAccountHolder,
  IHBAccountClosureLongText,
  IHBAccountDeletionLongText,
  IHBBankAreaCountry,
  IHBBankKey,
  IHBAccountCreatedDateTime,
  IHBAccountCreatedByUser,
  _CreatedBy.UserDescription AS IHBAccountCreatedByUserText,
  IHBAccountChangedDateTime,
  IHBAccountChangedByUser,
  _ChangedBy.UserDescription AS IHBAccountChangedByUserText,
  IHBAccountReleasedDateTime,
  IHBAccountReleasedByUser,
  _ReleasedBy.UserDescription AS IHBAccountReleasedByUserText,
  IHBAccountOpenedDate,
  IHBAccountOpenedByUser,
  _OpenedBy.UserDescription AS IHBAccountOpenedByUserText,
  IHBAccountClosedDateTime,
  IHBAccountClosedByUser,
  IHBAccountDeletedDateTime,
  IHBAccountDeletedByUser,
  IHBAcctOpngBalPostDate,
  IHBAcctOpngBalValueDate,
  IHBAcctOpngBalAmount,
  IHBAccountIsTemplate,
  IHBAccountTemplateShortDesc,
  IHBAccountTemplateLongDesc,
  IHBAccountTemplateIsPrivate,
  _IHBBankAcctMgmtBasicData.BankAccountStatus AS BankAccountStatus,
  _IHBBankAcctMgmtBasicData.CompanyCode AS CompanyCode,
  _IHBBankAcctMgmtBasicData.BankAccountStatusName AS BankAccountStatusName,
  _IHBBankAcctMgmtBasicData.BankAccountInternalID AS BankAccountInternalID,
  _IHBBankAcctMgmtBasicData.BankAccountNumber AS BankAccountNumber,
  _IHBBusinessPartner.IHBCreditIntrstTaxCode AS IHBCreditIntrstTaxCode,
  _IHBBusinessPartner.IHBDebitIntrstTaxCode AS IHBDebitIntrstTaxCode,
  _BankAreaDate.IHBPaytPostingDate AS IHBPaytPostingDate,
  virtual IHBAccountNavigationUUID : uuid AS virtualIHBAccountNavigationUUIDuuid,
  virtual UICT_IHBAcctCondLimitIsHidden : abap.char( 1 ) AS char1,
  virtual IHBDebitIntrstTaxDesc : qsbez AS virtualIHBDebitIntrstTaxDescqsbez,
  virtual IHBCreditIntrstTaxDesc : qsbez AS virtualIHBCreditIntrstTaxDescqsbez
FROM R_IHBAccountTP
LEFT OUTER JOIN C_IHBAccountChangeDocument AS _IHBAccountChangeDocument ON IHBAccountUUID = _IHBAccountChangeDocument.IHBAccountUUID  -- association [0..*]
LEFT OUTER JOIN C_IHBAcctLimitExpand AS _IHBAccLimitExpand ON IHBAccountUUID = _IHBAccLimitExpand.IHBAccountUUID  -- association [0..*]
LEFT OUTER JOIN C_IHBAcctConditionExpandCust AS _IHBAccConditionExpand ON IHBAccountUUID = _IHBAccConditionExpand.IHBAccountUUID  -- association [0..*]
LEFT OUTER JOIN C_IHBBankAreaCard AS _IHBBankAreaCard ON IHBBankArea = _IHBBankAreaCard.IHBBankArea  -- association [0..1]
LEFT OUTER JOIN E_IHBAccount AS _Extension ON IHBAccountUUID = _Extension.IHBAccountUUID  -- association [1]
;