I_SecuritiesAcctObjMstrData

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_SecuritiesAcctObjMstrData.
-- 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 I_SecuritiesAcctObjMstrData AS
SELECT
  SecuritiesAcctObjMstrData.sec_acc_guid AS SecuritiesAccountObjectUUID,
  SecuritiesAcctObjMstrData.depo_bank_id AS SecuritiesAcctObjDepositoryBk,
  SecuritiesAcctObjMstrData.account_number AS SecuritiesAccountObjectNumber,
  SecuritiesAcctObjMstrData.sec_acc_desc AS SecuritiesAccountObjDesc,
  SecuritiesAcctObjMstrData.acc_old_ref_no AS SecuritiesAcctObjExtRefNmbr,
  SecuritiesAcctObjMstrData.sec_acc_val AS SecuritiesAccountObjValAmt,
  SecuritiesAcctObjMstrData.sec_acc_val_curr AS SecuritiesAccountObjValCrcy,
  SecuritiesAcctObjMstrData.val_date AS SecuritiesAccountObjValnDte,
  SecuritiesAcctObjMstrData.admin_org_unit AS CollateralAdminOrgUnit,
  SecuritiesAcctObjMstrData.bankarea AS CollateralBankArea,
  SecuritiesAcctObjMstrData.risk_code AS SecuritiesAccountObjRiskCode,
  SecuritiesAcctObjMstrData.sfty_ind AS SecuritiesAcctObjSftyDiscSign,
  SecuritiesAcctObjMstrData.sfty_dscnt AS SecuritiesAcctObjSftyDiscPct,
  SecuritiesAcctObjMstrData.sfty_amount AS SecuritiesAcctObjSftyDiscAmt,
  SecuritiesAcctObjMstrData.sfty_amt_curr AS SecuritiesAcctObjSftyDiscCrcy,
  SecuritiesAcctObjMstrData.unit_valn_freq AS SecuritiesAcctObjValnFrqcy,
  SecuritiesAcctObjMstrData.period_valn_freq AS SecuritiesAcctObjValnPerd,
  SecuritiesAcctObjMstrData.start_date AS SecuritiesAcctObjRevalStrtDte,
  SecuritiesAcctObjMstrData.end_date AS SecuritiesAcctObjRevalEndDte,
  SecuritiesAcctObjMstrData.lending_rate_ind AS SecuritiesAcctObjLendgRateSign,
  SecuritiesAcctObjMstrData.lending_rate1 AS SecuritiesAcctObj1stLendgRate,
  SecuritiesAcctObjMstrData.liqd_typ AS SecuritiesAcctObjLqdtnType,
  SecuritiesAcctObjMstrData.liqd_reason AS SecuritiesAcctObjLqdtnRsn,
  SecuritiesAcctObjMstrData.liqd_date AS SecuritiesAcctObjLqdtnDate,
  SecuritiesAcctObjMstrData.liqd_amt AS SecuritiesAcctObjLqdtnAmt,
  SecuritiesAcctObjMstrData.liqd_curr AS SecuritiesAcctObjLqdtnCrcy,
  SecuritiesAcctObjMstrData.org_unit1 AS SecuritiesAccountObjOrgUnit1,
  SecuritiesAcctObjMstrData.org_unit2 AS SecuritiesAccountObjOrgUnit2,
  SecuritiesAcctObjMstrData.org_unit3 AS SecuritiesAccountObjOrgUnit3,
  SecuritiesAcctObjMstrData.org_unit4 AS SecuritiesAccountObjOrgUnit4,
  SecuritiesAcctObjMstrData.org_unit5 AS SecuritiesAccountObjOrgUnit5,
  SecuritiesAcctObjMstrData.created_by AS SecuritiesAcctObjEnteredBy,
  SecuritiesAcctObjMstrData.created_date AS SecuritiesAcctObjEnteredDte,
  SecuritiesAcctObjMstrData.created_time AS SecuritiesAcctObjEnteredTme,
  SecuritiesAcctObjMstrData.last_chg_by AS SecuritiesAcctObjLastChgdBy,
  SecuritiesAcctObjMstrData.last_chg_date AS SecuritiesAcctObjLastChgdDte,
  SecuritiesAcctObjMstrData.last_chg_time AS SecuritiesAcctObjLastChgdTme,
  I_SecuritiesAccountAssetType.CollateralProcessControlKey AS CollateralProcessControlKey
FROM cms_sec_acc AS SecuritiesAcctObjMstrData
CROSS JOIN I_SecuritiesAccountAssetType
LEFT OUTER JOIN I_SecuritiesAccountObjectData AS _SecuritiesAccountObjectData ON SecuritiesAccountObjectUUID = _SecuritiesAccountObjectData.SecuritiesAccountObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_SecuritiesAccountPosition AS _SecuritiesAccountPosition ON SecuritiesAccountObjectUUID = _SecuritiesAccountPosition.SecuritiesAccountObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_SecuritiesAcctPosMstrData AS _SecuritiesAcctPosMstrData ON SecuritiesAccountObjectUUID = _SecuritiesAcctPosMstrData.SecuritiesAccountObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_SecuritiesAccountPartner AS _SecuritiesAccountPartner ON SecuritiesAccountObjectUUID = _SecuritiesAccountPartner.SecuritiesAccountObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAdminOrgUnitAttrib AS _CollateralAdminOrgUnitAttrib ON CollateralAdminOrgUnit = _CollateralAdminOrgUnitAttrib.CollateralAdminOrgUnit  -- association [0..1]
LEFT OUTER JOIN I_ObjectAssetLiquidationType AS _SecuritiesAcctObjLqdtnType ON SecuritiesAcctObjLqdtnType = _SecuritiesAcctObjLqdtnType.ObjectAssetLiquidationType  -- association [0..1]
LEFT OUTER JOIN I_CollateralSafetyDiscountSign AS _SecuritiesAcctObjSftyDiscSign ON SecuritiesAcctObjSftyDiscSign = _SecuritiesAcctObjSftyDiscSign.CollateralSafetyDiscountSign  -- association [0..1]
LEFT OUTER JOIN I_ObjectAssetValuationFrqcy AS _SecuritiesAcctObjValnFrqcy ON SecuritiesAcctObjValnFrqcy = _SecuritiesAcctObjValnFrqcy.ObjectAssetValuationFrequency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SecuritiesAccountObjValCrcy ON SecuritiesAccountObjValCrcy = _SecuritiesAccountObjValCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SecuritiesAcctObjSftyDiscCrcy ON SecuritiesAcctObjSftyDiscCrcy = _SecuritiesAcctObjSftyDiscCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SecuritiesAcctObjLqdtnCrcy ON SecuritiesAcctObjLqdtnCrcy = _SecuritiesAcctObjLqdtnCrcy.Currency  -- association [0..1]
;