R_InsurPlcyContrJrnlHdrTP

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_InsurPlcyContrJrnlHdrTP.
-- 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_InsurPlcyContrJrnlHdrTP AS
SELECT
  InsurPlcyApplUUID,
  InsurPlcyUUID,
  InsurPlcyInsurContr,
  InsurPlcyBusProcType,
  InsurPlcyBusProcessNumerator,
  InsurPlcyChgEffctvDte,
  InsurPlcyProcgStsCode,
  InsurPlcyBackgroundProcNumber,
  InsurPlcyBizTransChangeReason,
  InsurPlcyBizTransOthChgRsnText,
  InsurPlcyIsNoneUpdateChange,
  InsurPlcyBizTransApplDte,
  InsurancePolicyApplication,
  InsurPlcyBizTransApplRcptDte,
  InsurPlcyCustomer1Text,
  InsurPlcyCustomer2Text,
  InsurPlcyCustomer3Text,
  InsurApplChgdByUsr,
  InsurPlcyChgDteTime,
  InsurancePolicyCreatedByUser,
  InsurApplCrtnDteTme
FROM I_InsurPlcyContrJrnlHdrBasic
LEFT OUTER JOIN E_InsurPolicyContractJournal AS _Extension ON InsurPlcyApplUUID = _Extension.InsurPlcyApplUUID AND InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcyContrJrnlItmTP AS _ContractJournalItem ON /* condition not available in parsed metadata */  -- association [1..*]
;