R_InsurancePolicyDateTP

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 R_InsurancePolicyDateTP.
-- 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 R_InsurancePolicyDateTP AS
SELECT
  Date.InsurPlcyUUID AS InsurPlcyUUID,
  Date.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  Date.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Date.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Date.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Date.InsurancePolicyDateIdentifier AS InsurancePolicyDateIdentifier,
  Date.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  Date.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  Date.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  Date.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Date.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Date.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Date.InsurPlcyDateIsCancelled AS InsurPlcyDateIsCancelled,
  Date.InsurancePolicyDateType AS InsurancePolicyDateType,
  Date.InsurPolicyTimeModelFunction AS InsurPolicyTimeModelFunction,
  Date.InsurPlcyDateEffectiveDate AS InsurPlcyDateEffectiveDate,
  Date.InsurPlcyDateIsAuxiliary AS InsurPlcyDateIsAuxiliary,
  Date.InsurPlcyDateReleaseDate AS InsurPlcyDateReleaseDate,
  Date.InsurPlcyDateApplicationID AS InsurPlcyDateApplicationID,
  Date.InsurPlcyDatePerfPhaseType AS InsurPlcyDatePerfPhaseType,
  Date.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  Date.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurancePolicyDateVersion AS Date
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
LEFT OUTER JOIN E_InsurancePolicyDate AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurancePolicyDateIdentifier = _Extension.InsurancePolicyDateIdentifier  -- association [1..1]
;