R_InsurPlcyCoinsurCommsnTP

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_InsurPlcyCoinsurCommsnTP.
-- 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_InsurPlcyCoinsurCommsnTP AS
SELECT
  InsurPlcyCoinsurCommsnUUID,
  InsurPlcyCoinsurJournalNumber,
  InsurPlcyCoinsurHdrUUID,
  InsurPlcyCoinsurSegmentID,
  InsurPlcyCoinsurCommsnID,
  InsurPlcyCoinsurCommsnType,
  InsurPlcyCoinsurCommsnPercent,
  InsurPlcyCoinsurCommsnTmplNmbr,
  InsurPlcyCoinsurCommsnTmplText,
  InsPlcyCoinsurCommsnJrnlEndID,
  InsurPlcyCoinsurCommsnIsCancld,
  InsurPlcyCoinsurCommsnChgUsr,
  LastChangeDateTime,
  InsurPlcyCoinsurCommsnCrtedUsr,
  InsPlcyCoinsurCommsnCrtnDteTme
FROM I_InsurPlcyCoinsurCommsnBasic AS CoinsuranceCommission
LEFT OUTER JOIN E_InsurancePolicyCoinsurCommsn AS _Extension ON InsurPlcyCoinsurCommsnUUID = _Extension.InsurPlcyCoinsurCommsnUUID AND InsurPlcyCoinsurJournalNumber = _Extension.InsurPlcyCoinsurJournalNumber  -- association [1..1]
;