R_InsurClmSrvcsRblsHeaderTP

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_InsurClmSrvcsRblsHeaderTP.
-- 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_InsurClmSrvcsRblsHeaderTP AS
SELECT
  I_InsurClmSrvcsSubrogtnPaytRef.InsuranceClaim AS InsuranceClaim,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmSubclm AS InsurClmSubclm,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPayt AS InsurClmPayt,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmSubrogationUUID AS InsurClmSubrogationUUID,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytCat AS InsurClmPaytCat,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaymentType AS InsurClmPaymentType,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaymentCurrency AS InsurClmPaymentCurrency,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaymentDatabaseStatus AS InsurClmPaymentDatabaseStatus,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmAssignUUID AS InsurClmAssignUUID,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytPostgDte AS InsurClmPaytPostgDte,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytMethod AS InsurClmPaytMethod,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytCheque AS InsurClmPaytCheque,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmBankID AS InsurClmBankID,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytDocRefInSubLedger AS InsurClmPaytDocRefInSubLedger,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytDueDate AS InsurClmPaytDueDate,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytHasAlreadyPaid AS InsurClmPaytHasAlreadyPaid,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytHasAddlPayee AS InsurClmPaytHasAddlPayee,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytAddrNmbrForChecks AS InsurClmPaytAddrNmbrForChecks,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytCheckRcpntAddrNmbr AS InsurClmPaytCheckRcpntAddrNmbr,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmPaytNote AS InsurClmPaytNote,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmServicePeriodStartDate AS InsurClmServicePeriodStartDate,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmServicePeriodEndDate AS InsurClmServicePeriodEndDate,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmChangedBy AS InsurClmChangedBy,
  I_InsurClmSrvcsSubrogtnPaytRef.InsurClmChangeTime AS InsurClmChangeTime,
  cast('' as bu_aktyp ) AS InsuranceClaimActivityCategory
FROM I_InsurClmSrvcsSubrogtnPaytRef
LEFT OUTER JOIN R_InsurClmSrvcsInsurClaimTP AS _InsuranceClaim ON InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN E_InsuranceClaimPayment AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim AND InsurClmSubclm = _Extension.InsurClmSubclm AND InsurClmPayt = _Extension.InsurClmPayt  -- association [1..1]
LEFT OUTER JOIN R_InsurClmSrvcsRblsItemTP AS _InsuranceClaimRblsItem ON /* condition not available in parsed metadata */  -- association [0..*]
;