I_LiquidationData

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_LiquidationData.
-- 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_LiquidationData AS
SELECT
  liq_guid AS CollateralLiquidationUUID,
  obj_ref_guid AS ObjectReferenceUUID,
  objsysid AS LiquidationObjectRefSystem,
  liq_typ AS LiquidationType,
  liq_start_date AS LiquidationStartDate,
  liq_end_date AS LiquidationEndDate,
  liq_ini_by AS LiquidationInitiatedBy,
  appln_date AS LiquidationApplicationDate,
  order_date AS LiquidationCourtOrderDate,
  order_rcvd_on AS LqdtnCourtOrderReceivedDate,
  close_dcsn_date AS LiquidationDecisionClosedDate,
  close_dn_rcvd_on AS LqdtnDecisionCloseReceivedDate,
  val_guar_amt AS LqdtnGuaranteeCallingAmount,
  val_guar_curr AS LqdtnGuaranteeCallingCurrency,
  call_date_guar AS LqdtnGuaranteeCallingDate,
  enfc_date_guar AS LqdtnGuaranteeEnforceableDate,
  enfc_obtain_ind AS LqdtnEnfrcmntTitleObtained,
  enfc_title_desc AS LiquidationEnforceableDesc,
  affidavit_date AS LiquidationAffidavitDate,
  affidavit_desc AS LiquidationAffidavitDesc,
  amicable_date AS LiquidationAmicableDate,
  amicable_desc AS LiquidationAmicableDescription,
  reg_date AS LiquidationRegistrationDate,
  req_date AS LiquidationAdminRcvrReqDte,
  attcmt_date AS LiquidationAttachmentDate,
  title_req_before AS LqdtnEnfrcmntTtlRqdBfrDte,
  settlement_date AS LqdtnOutOfCourtSettlmtDte
FROM cms_liq
LEFT OUTER JOIN I_LiquidationCashFlow AS _LiquidationCashFlow ON CollateralLiquidationUUID = _LiquidationCashFlow.CollateralLiquidationUUID  -- association [0..*]
LEFT OUTER JOIN I_LiquidationProcess AS _LiquidationProcess ON CollateralLiquidationUUID = _LiquidationProcess.CollateralLiquidationUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetPartner AS _LiquidationPartner ON CollateralLiquidationUUID = _LiquidationPartner.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetDocument AS _LiquidationDocument ON CollateralLiquidationUUID = _LiquidationDocument.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstateObjectData AS _RealEstateObjectData ON ObjectReferenceUUID = _RealEstateObjectData.RealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRealEstate AS _CollateralRealEstate ON ObjectReferenceUUID = _CollateralRealEstate.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_MovableObjectData AS _MovableObjectData ON ObjectReferenceUUID = _MovableObjectData.MovableObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_ShipObjectData AS _ShipObjectData ON ObjectReferenceUUID = _ShipObjectData.ShipObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RightsObjectData AS _RightsObjectData ON ObjectReferenceUUID = _RightsObjectData.RightsObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectData AS _InsuranceObjectData ON ObjectReferenceUUID = _InsuranceObjectData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RealEstateObjectMasterData AS _RealEstateObjectMasterData ON ObjectReferenceUUID = _RealEstateObjectMasterData.RealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRealEstateMaster AS _CollateralRealEstateMaster ON ObjectReferenceUUID = _CollateralRealEstateMaster.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_MovableObjectMasterData AS _MovableObjectMasterData ON ObjectReferenceUUID = _MovableObjectMasterData.MovableObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RightsObjectMasterData AS _RightsObjectMasterData ON ObjectReferenceUUID = _RightsObjectMasterData.RightsObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectMasterData AS _InsuranceObjectMasterData ON ObjectReferenceUUID = _InsuranceObjectMasterData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralInsurance AS _CollateralInsurance ON ObjectReferenceUUID = _CollateralInsurance.CollateralInsuranceUUID  -- association [0..1]
LEFT OUTER JOIN I_LiquidationObjectRefSystem AS _LiquidationObjectRefSystem ON LiquidationObjectRefSystem = _LiquidationObjectRefSystem.LiquidationObjectRefSystem  -- association [0..1]
LEFT OUTER JOIN I_LiquidationType AS _LiquidationType ON LiquidationType = _LiquidationType.LiquidationType  -- association [0..1]
LEFT OUTER JOIN I_LiquidationInitiatedBy AS _LiquidationInitiatedBy ON LiquidationInitiatedBy = _LiquidationInitiatedBy.LiquidationInitiatedBy  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _LqdtnGuaranteeCallingCurrency ON LqdtnGuaranteeCallingCurrency = _LqdtnGuaranteeCallingCurrency.Currency  -- association [0..1]
;