I_InsurClmFNOLVehDriverTP

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_InsurClmFNOLVehDriverTP.
-- 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_InsurClmFNOLVehDriverTP AS
SELECT
  InsuranceClaim,
  cast(InsurClmSubobject as icl_damobjau) AS InsurClmDamagedObject,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClaimUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClmDmgdObjUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClmVehDriverUUID,
  concat(InsurClmParticipantRole, BusinessPartner) AS InsurFactsSubobject,
  BusinessPartner,
  BusinessPartner AS InsuranceClaimVehicleDriver,
  BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartner AS EmploymentBusinessPartner,
  InsurClmParticipantRole,
  LastChangedByUser,
  ChangedOnDateTime,
  _InsuComp.BusinessPartner AS InsurClmDrvrInsuranceCompany,
  _Part.InsurClmFNOLReferenceNumber AS InsurClmFNOLReferenceNumber,
  BusinessPartnerName,
  FormOfAddress,
  cast( '' as abap.char(1) ) AS InsurClmVehDriverActionIsChkd,
  cast ('' as abap.char(1)) AS InsurClmTransferDrvrIsNotChkd,
  cast( '' as abap.char(1) ) AS InsurClmFNOLActionIsChkd,
  LastName,
  FirstName,
  GenderCodeName,
  StreetName,
  HouseNumber,
  CityName,
  PostalCode,
  Region,
  Country,
  PhoneNumber,
  EmailAddress,
  BirthDate
FROM I_InsurClmPrtcpntOccrnc
LEFT OUTER JOIN I_InsurClmFNOLTP AS _ClaimHdr ON InsuranceClaim = _ClaimHdr.InsuranceClaim AND InsurClaimUUID = _ClaimHdr.InsurClaimUUID  -- association [1..1]
LEFT OUTER JOIN I_InsurClmParticipant AS _Part ON InsuranceClaim = _Part.InsuranceClaim AND BusinessPartner = _Part.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_InsurClmPrtcpntOccrnc AS _InsuComp ON InsuranceClaim = _InsuComp.InsuranceClaim AND _InsuComp.InsurClmSubobjectCategory = 'PA' AND _InsuComp.InsurClmSubobject = BusinessPartner AND _InsuComp.InsurClmParticipantRole = 'EXTI'  -- association [1..1]
LEFT OUTER JOIN I_InsurClmFNOLDriverSFCTP AS _driversfc ON /* condition not available in parsed metadata */  -- association [1..*]
;