I_ObjectAssetPartner

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_ObjectAssetPartner.
-- 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_ObjectAssetPartner AS
SELECT
  ast_bp_guid AS ObjectAssetPartnerUUID,
  ast_guid AS ObjectAssetUUID,
  cast( bu_partnerid as cms_dte_bpid_vdm preserving type ) AS ObjectAssetPartnerID,
  bpf AS ObjectAssetPartnerFunction,
  vald_frm AS ObjectAssetPartnerValidFromDte,
  vald_tll AS ObjectAssetPartnerValidToDate,
  _ObjectAssetData.ObjectAssetReferenceSystem AS ObjectAssetReferenceSystem,
  _LiquidationData.LiquidationObjectRefSystem AS LiquidationObjectRefSystem,
  _InsuranceObjectData.InsuranceObjectCategory AS InsuranceObjectCategory,
  _CollateralInsurance.CollateralObjectCategory AS CollateralObjectCategory,
  _MovableObjectData.MovableObjectUUID AS MovableObjectUUID,
  _RightsObjectData.RightsObjectUUID AS RightsObjectUUID
FROM cms_ast_bp
LEFT OUTER JOIN I_ObjectAssetData AS _ObjectAssetData ON ObjectAssetUUID = _ObjectAssetData.ObjectAssetUUID  -- association [0..1]
LEFT OUTER JOIN I_ObjectAssetDocument AS _ObjectAssetDocument ON ObjectAssetUUID = _ObjectAssetDocument.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_AssetAgreementLinkData AS _AssetAgreementLinkData ON ObjectAssetUUID = _AssetAgreementLinkData.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_LiquidationData AS _LiquidationData ON ObjectAssetUUID = _LiquidationData.CollateralLiquidationUUID  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectData AS _InsuranceObjectData ON ObjectAssetUUID = _InsuranceObjectData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_MovableObjectData AS _MovableObjectData ON ObjectAssetUUID = _MovableObjectData.MovableObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_ShipObjectData AS _ShipObjectData ON ObjectAssetUUID = _ShipObjectData.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_RightsObjectData AS _RightsObjectData ON ObjectAssetUUID = _RightsObjectData.RightsObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectMasterData AS _InsuranceObjectMasterData ON ObjectAssetUUID = _InsuranceObjectMasterData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralInsurance AS _CollateralInsurance ON ObjectAssetUUID = _CollateralInsurance.CollateralInsuranceUUID  -- association [0..1]
LEFT OUTER JOIN I_MovableObjectMasterData AS _MovableObjectMasterData ON ObjectAssetUUID = _MovableObjectMasterData.MovableObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RightsObjectMasterData AS _RightsObjectMasterData ON ObjectAssetUUID = _RightsObjectMasterData.RightsObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralObjectCalcData AS _CollateralObjectCalcData ON ObjectAssetUUID = _CollateralObjectCalcData.CollateralObjectUUID AND _CollateralObjectCalcData.CollateralObjectType = 'AST'  -- association [0..1]
LEFT OUTER JOIN I_AgreementAssetCalcData AS _AgreementAssetCalcData ON ObjectAssetUUID = _AgreementAssetCalcData.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralPartnerFunction AS _ObjectAssetPartnerFunction ON ObjectAssetPartnerFunction = _ObjectAssetPartnerFunction.CollateralPartnerFunction  -- association [0..1]
;