R_InsurClmSrvcsPaymentItemTP

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_InsurClmSrvcsPaymentItemTP.
-- 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_InsurClmSrvcsPaymentItemTP AS
SELECT
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmPayt,
  InsurClmPaytItem,
  InsurClmItemSubclm,
  InsurBnftType,
  InsurClmPaytAmt,
  _Payment.InsurClmPaymentCurrency AS InsurClmPaymentCurrency,
  InsurClmCoverageType,
  InsurClmChangedBy,
  InsurClmChangeTime,
  InsurClmPaytItemCategory,
  InsurClmPaytTaxCategory,
  InsurClmPaytItemPaymentType,
  InsurClmPaytReasonGrp,
  InsurClmPaytReason,
  InsurClmPaytAmtTaxCategory,
  InsurClmPaytTaxCode,
  InsurClmPaytRequestedAmount,
  InsurClmItem,
  InsurClmPaytValidFromDate,
  InsurClmPaytValidToDate,
  cast('' as bu_aktyp ) AS InsuranceClaimActivityCategory
FROM I_InsurClmPaymentItem
LEFT OUTER JOIN R_InsurClmSrvcsInsurClaimTP AS _InsuranceClaim ON InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN E_InsuranceClaimPaymentItem AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim AND InsurClmSubclm = _Extension.InsurClmSubclm AND InsurClmPayt = _Extension.InsurClmPayt AND InsurClmPaytItem = _Extension.InsurClmPaytItem  -- association [1..1]
;