I_ShipObjectData

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_ShipObjectData.
-- 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_ShipObjectData AS
SELECT
  shp_guid AS ShipObjectUUID,
  ast_guid AS ObjectAssetUUID,
  shp_type AS ShipObjectType,
  name AS ShipObjectName,
  charter_name AS ShipObjectCharteredName,
  call_sign AS ShipObjectIntlMaritimeOrgNmbr,
  shp_class AS ShipObjectClass,
  reg_number AS ShipObjectRegistrationNumber,
  reg_date AS ShipObjectRegistrationDate,
  reg_place AS ShipObjectRegistrationPlace,
  reg_country AS ShipObjectRegistrationCountry,
  extn_ref_id AS ShipObjectExternalRefNumber,
  fleet_name AS ShipObjectFleetName,
  ship_id AS ShipObjectID,
  ism_valid_from AS ShipObjIntlSftyMgmtValdFrmDte,
  ism_valid_to AS ShipObjIntlSftyMgmtValdToDte,
  rating_date AS ShipObjectRatingDate,
  rating_cls AS ShipObjectRatingClass,
  classification AS ShipObjectClassification,
  classifi_company AS ShipObjCompanyClassification,
  comments AS ShipObjectDescription,
  purch_price AS ShipObjectPurchaseAmount,
  purch_curr AS ShipObjectPurchaseCurrency,
  purch_price_date AS ShipObjectPurchaseDate,
  cons_country AS ShipObjectConstructionCountry,
  cons_price AS ShipObjectConstructionAmount,
  cons_curr AS ShipObjectConstructionCurrency,
  delivery_date AS ShipObjectDeliveryDate,
  dock AS ShipObjectBuiltShipyard,
  length AS ShipObjectLength,
  length_uom AS ShipObjectLengthUnitMeasure,
  breadth AS ShipObjectBreadthQty,
  breadth_uom AS ShipObjectBreadthUnitMeasure,
  depth AS ShipObjectDepthQty,
  depth_uom AS ShipObjectDepthUnitMeasure,
  volume AS ShipObjectVolume,
  volume_uom AS ShipObjectVolumeUnitMeasure,
  dwt AS ShipObjDeadWgtCarryingCapacity,
  dwt_uom AS ShipObjDeadWgtCarryCapUnitMsr,
  grosst AS ShipObjectGrossTonnageQuantity,
  grosst_uom AS ShipObjectGrossTonnageUnitMsr,
  track_length AS ShipObjectTrackLength,
  track_length_uom AS ShipObjectTrackLengthUnitMsr,
  num_ref_cont AS ShipObjNrOfRefrigeratedCtns,
  num_cont_cap AS ShipObjNrOfCapacityContainers,
  num_cabin_room AS ShipObjectNumberOfCabinRooms,
  num_veh_park AS ShipObjectNumberOfParking,
  num_of_pax AS ShipObjectNumberOfPassenger,
  isovr_container AS ShipObjOversizeCtnIsAllowed,
  hull_typ AS ShipObjectHullType,
  manufr_machine AS ShipObjectMachineMfrName,
  machine_typ AS ShipObjectMachineModelName,
  num_machines AS ShipObjectNumberOfMainMachines,
  crane_equip AS ShipObjectCraneEquipment,
  power AS ShipObjectEnginePowerQty,
  power_uom AS ShipObjectEnginePowerUnitMsr,
  speed AS ShipObjectSpeedQty,
  speed_uom AS ShipObjectSpeedUnitMeasure,
  fuel_consum AS ShipObjectFuelConsumptionQty,
  fuel_consum_uom AS ShipObjFuelConsumptionUnitMsr,
  insur_premium AS ShipObjectInsurancePremiumAmt,
  insur_pre_curr AS ShipObjectInsurancePremiumCrcy,
  insur_type AS ShipObjectInsuranceType,
  annual_dep AS ShipObjAnnualDepreciationPct,
  insur_valid_till AS ShipObjectInsuranceExpiryDate,
  policy_amount AS ShipObjectInsurancePolicyAmt,
  policy_curr AS ShipObjectInsurancePolicyCrcy,
  reqd_insur_cover AS ShipObjRqdInsuranceCoverAmt,
  reqd_insur_curr AS ShipObjRqdInsuranceCoverCrcy,
  insurer AS ShipObjectInsurer,
  contact_firm AS ShipObjectInsuranceContactFirm,
  contact_person AS ShipObjInsuranceContactPerson,
  admin_org_unit AS CollateralAdminOrgUnit,
  created_at AS ShipObjectEnteredDateTime,
  changed_at AS ShipObjectLastChangedDateTime
FROM cms_shp
LEFT OUTER JOIN I_ObjectAssetData AS _ObjectAssetData ON ObjectAssetUUID = _ObjectAssetData.ObjectAssetUUID  -- association [0..1]
LEFT OUTER JOIN I_ObjectAssetPartner AS _ObjectAssetPartner ON ObjectAssetUUID = _ObjectAssetPartner.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetDocument AS _ObjectAssetDocument ON ObjectAssetUUID = _ObjectAssetDocument.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectValuationLinkData AS _ObjectValuationLinkData ON ShipObjectUUID = _ObjectValuationLinkData.ObjectValuationLinkUUID  -- association [0..*]
LEFT OUTER JOIN I_AssetAgreementLinkData AS _AssetAgreementLinkData ON ObjectAssetUUID = _AssetAgreementLinkData.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectInsuranceLinkData AS _ObjectInsuranceLinkData ON ShipObjectUUID = _ObjectInsuranceLinkData.ObjectReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_LiquidationData AS _LiquidationData ON ShipObjectUUID = _LiquidationData.ObjectReferenceUUID  -- association [0..*]
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_ShipObjectType AS _ShipObjectType ON ShipObjectType = _ShipObjectType.ShipObjectType  -- association [0..1]
LEFT OUTER JOIN I_ShipObjectClass AS _ShipObjectClass ON ShipObjectClass = _ShipObjectClass.ShipObjectClass  -- association [0..1]
LEFT OUTER JOIN I_CollateralAdminOrgUnitAttrib AS _CollateralAdminOrgUnitAttrib ON CollateralAdminOrgUnit = _CollateralAdminOrgUnitAttrib.CollateralAdminOrgUnit  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ShipObjCompanyClassification ON ShipObjCompanyClassification = _ShipObjCompanyClassification.CollateralAttributeIndType AND _ShipObjCompanyClassification.CollateralAttributeIndCat = 'SHP002'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ShipObjectHullType ON ShipObjectHullType = _ShipObjectHullType.CollateralAttributeIndType AND _ShipObjectHullType.CollateralAttributeIndCat = 'SHP001'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ShipObjectInsuranceType ON ShipObjectInsuranceType = _ShipObjectInsuranceType.CollateralAttributeIndType AND _ShipObjectInsuranceType.CollateralAttributeIndCat = 'SHP003'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ShipObjectInsurer ON ShipObjectInsurer = _ShipObjectInsurer.CollateralAttributeIndType AND _ShipObjectInsurer.CollateralAttributeIndCat = 'SHP004'  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ShipObjectPurchaseCurrency ON ShipObjectPurchaseCurrency = _ShipObjectPurchaseCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ShipObjectConstructionCrcy ON ShipObjectConstructionCurrency = _ShipObjectConstructionCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ShipObjInsurancePremiumCrcy ON ShipObjectInsurancePremiumCrcy = _ShipObjInsurancePremiumCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ShipObjRqdInsuranceCoverCrcy ON ShipObjRqdInsuranceCoverCrcy = _ShipObjRqdInsuranceCoverCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ShipObjectInsurancePolicyCrcy ON ShipObjectInsurancePolicyCrcy = _ShipObjectInsurancePolicyCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _ShipObjectRegistrationCountry ON ShipObjectRegistrationCountry = _ShipObjectRegistrationCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _ShipObjectConstructionCountry ON ShipObjectConstructionCountry = _ShipObjectConstructionCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ShipObjectLengthUnitMeasure ON ShipObjectLengthUnitMeasure = _ShipObjectLengthUnitMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ShipObjectBreadthUnitMeasure ON ShipObjectBreadthUnitMeasure = _ShipObjectBreadthUnitMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ShipObjectDepthUnitMeasure ON ShipObjectDepthUnitMeasure = _ShipObjectDepthUnitMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ShipObjectVolumeUnitMeasure ON ShipObjectVolumeUnitMeasure = _ShipObjectVolumeUnitMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ShipObjDeadWgtCarryCapUnitMsr ON ShipObjDeadWgtCarryCapUnitMsr = _ShipObjDeadWgtCarryCapUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ShipObjectGrossTonnageUnitMsr ON ShipObjectGrossTonnageUnitMsr = _ShipObjectGrossTonnageUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ShipObjectTrackLengthUnitMsr ON ShipObjectTrackLengthUnitMsr = _ShipObjectTrackLengthUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ShipObjectEnginePowerUnitMsr ON ShipObjectEnginePowerUnitMsr = _ShipObjectEnginePowerUnitMsr.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ShipObjectSpeedUnitMeasure ON ShipObjectSpeedUnitMeasure = _ShipObjectSpeedUnitMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ShipObjFuelConsumptionUnitMsr ON ShipObjFuelConsumptionUnitMsr = _ShipObjFuelConsumptionUnitMsr.UnitOfMeasure  -- association [0..1]
;