I_ObjectValuationLinkData

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_ObjectValuationLinkData.
-- 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_ObjectValuationLinkData AS
SELECT
  val_guid AS ObjectValuationUUID,
  val_link_guid AS ObjectValuationLinkUUID,
  val_type AS ObjectValuationType,
  calc_amount AS ObjectValuationCalculatedAmt,
  calc_amt_curr AS ObjectValuationCalculatedCrcy,
  entered_amount AS ObjectValuationEnteredAmount,
  ent_amt_curr AS ObjectValuationEnteredCurrency,
  val_valid_from AS ObjectValuationValidFromDate,
  val_valid_to AS ObjectValuationValidToDate,
  val_date AS ObjectFirstValuationDate,
  val_origin AS ObjectValuationOrigin,
  created_at AS ObjectValuationEnteredDateTime,
  changed_at AS ObjectValuationLastChgdDteTme,
  _MovableObjectData.MovableObjectUUID AS MovableObjectUUID,
  _ShipObjectData.ShipObjectUUID AS ShipObjectUUID,
  _RightsObjectData.RightsObjectUUID AS RightsObjectUUID,
  _InsuranceObjectData.InsuranceObjectCategory AS InsuranceObjectCategory,
  _CollateralInsurance.CollateralObjectCategory AS CollateralObjectCategory
FROM cms_oms_val_lnk
LEFT OUTER JOIN I_MovableObjectData AS _MovableObjectData ON ObjectValuationLinkUUID = _MovableObjectData.MovableObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_ShipObjectData AS _ShipObjectData ON ObjectValuationLinkUUID = _ShipObjectData.ShipObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RightsObjectData AS _RightsObjectData ON ObjectValuationLinkUUID = _RightsObjectData.RightsObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectData AS _InsuranceObjectData ON ObjectValuationLinkUUID = _InsuranceObjectData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_MovableObjectMasterData AS _MovableObjectMasterData ON ObjectValuationLinkUUID = _MovableObjectMasterData.MovableObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RightsObjectMasterData AS _RightsObjectMasterData ON ObjectValuationLinkUUID = _RightsObjectMasterData.RightsObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectMasterData AS _InsuranceObjectMasterData ON ObjectValuationLinkUUID = _InsuranceObjectMasterData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralInsurance AS _CollateralInsurance ON ObjectValuationLinkUUID = _CollateralInsurance.CollateralInsuranceUUID  -- association [0..1]
LEFT OUTER JOIN I_ObjectValuationType AS _ObjectValuationType ON ObjectValuationType = _ObjectValuationType.ObjectValuationType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ObjectValuationCalculatedCrcy ON ObjectValuationCalculatedCrcy = _ObjectValuationCalculatedCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ObjectValuationEnteredCrcy ON ObjectValuationEnteredCurrency = _ObjectValuationEnteredCrcy.Currency  -- association [0..1]
;