I_SecurityAccount

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 I_SecurityAccount.
-- 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.
-- SQL view name: ISECACCOUNT

CREATE VIEW I_SecurityAccount AS
SELECT
  SecurityAccount.bukrs AS CompanyCode,
  cast(SecurityAccount.rldepo as ftr_gen_security_account preserving type) AS SecurityAccount,
  cast(SecurityAccount.xldepo as ftr_gen_security_account_name preserving type) AS SecurityAccountName,
  cast(SecurityAccount.sec_acc_grp as ftr_gen_sec_account_group preserving type) AS SecurityAccountGroup,
  cast(SecurityAccount.secacc_type as ftr_gen_security_account_type preserving type ) AS SecurityAccountType,
  cast(SecurityAccount.rdpbank as ftr_gen_partnr_depository_bank preserving type ) AS DepositoryBank
FROM twd01 AS SecurityAccount
LEFT OUTER JOIN I_SecurityAccountType AS _SecurityAccountType ON SecurityAccountType = _SecurityAccountType.SecurityAccountType  -- association [0..1]
LEFT OUTER JOIN I_SecurityAccountGroup AS _SecurityAccountGroup ON SecurityAccountGroup = _SecurityAccountGroup.SecurityAccountGroup AND CompanyCode = _SecurityAccountGroup.CompanyCode  -- association [0..1]
;