C_IHBAccountTemplateTP

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_IHBAccountTemplateTP.
-- 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_IHBAccountTemplateTP AS
SELECT
  IHBAccountUUID,
  _IHBBankAreaText[1:IHBBankAreaLanguage = $session.system_language ].IHBBankAreaDescription AS IHBBankAreaDescription,
  IHBBankArea,
  IHBAccountIsTemplate,
  IHBAccountCurrency,
  IHBAccountAliasName,
  IHBAccountGroupName,
  IHBAccountTemplateShortDesc,
  IHBAccountTemplateLongDesc,
  IHBAccountTemplateIsPrivate,
  IHBAccountBalancingIsNeeded,
  IHBAcctBalancingFrequency,
  _IHBAccountFrequencyTxt[1:Language = $session.system_language ].IHBAccountFrequencyText AS IHBAccountFrequencyText,
  IHBAcctBalancingKeyDay,
  _IHBAccountBalancingKeyDayTxt[1:Language = $session.system_language ].IHBAccountBalancingKeyDayText AS IHBAccountBalancingKeyDayText,
  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,
  IHBAcctBkStmntSendStartTime,
  IHBAcctBkStmntSendEndTime,
  IHBAcctBkStmntSendTmznCode,
  IHBAcctBankStmntWeeklyOccren,
  _IHBAcctBkStmntWeeklyOccrenTxt[1:Language = $session.system_language ].IHBAcctBkStmntWeeklyOccrenTxt AS IHBAcctBkStmntWeeklyOccrenTxt,
  IHBAcctBkStmntIsWithinDay,
  IHBAcctBkStmntNoTrnovrIsNeeded,
  _IHBAccountBkStmntKeyDayText[1:Language = $session.system_language ].IHBAccountBkStmntKeyDayText AS IHBAccountBkStmntKeyDayText,
  IHBAcctBkStmntKeyDay,
  _IHBAcctBkStmntYearMnthNmbrTxt[1:Language = $session.system_language ].IHBAcctBkStmntYearMnthNmbrText AS IHBAcctBkStmntYearMnthNmbrText,
  IHBAcctBkStmntFreqYearMnthNmbr,
  IHBAcctBalanceNotifIsNeeded,
  IHBAcctIntrstScNotifIsNeeded,
  IHBAccountCreatedDateTime,
  IHBAccountCreatedByUser,
  _CreatedBy.UserDescription AS IHBAccountCreatedByUserText,
  IHBAccountChangedDateTime,
  IHBAccountChangedByUser,
  IHBAccountDeletedDateTime,
  IHBAccountDeletedByUser,
  _ChangedBy.UserDescription AS IHBAccountChangedByUserText,
  virtual UICT_IHBAcctBalSectionIsHidden : abap.char( 1 ) AS char1
FROM R_IHBAccountTP
LEFT OUTER JOIN C_IHBBankAreaCard AS _IHBBankAreaCard ON IHBBankArea = _IHBBankAreaCard.IHBBankArea  -- association [0..1]
;