I_InsurClmPaymentItemTP

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_InsurClmPaymentItemTP.
-- 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_InsurClmPaymentItemTP AS
SELECT
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmPayt,
  InsurClmPaytItem,
  InsurClmPaytDraftUUID,
  InsurClmPaytItemDraftUUID,
  InsuranceClaim AS InsuranceClaimForEdit,
  InsurClmSubclm AS InsurClmSubclmForEdit,
  InsurClmPaytItem AS InsurClmPaytItemForEdit,
  InsurClmPaytSubobject,
  InsurClmItemSubclm,
  InsurBnftType,
  _BenefitType._BenefitTypeText[1:Language=$session.system_language].InsurBnftTypeName AS InsurBnftTypeName,
  InsurClmPaytAmt,
  InsurClmPaytRequestedAmount,
  InsurClmPaymentCurrency,
  InsurClmCoverageType,
  InsurClmPaytItemCategory,
  InsurClmPaytIsFinalPayment,
  InsurClmPaytReasonGrp,
  InsurClmPaytReason,
  InsurClmPaytAmtCategory,
  _PaytItemAmtCat._Text[1:Language = $session.system_language].InsurClmPaytAmtCategoryName AS InsurClmPaytAmtCategoryName,
  _PaymentHdr.TaxCalculationProcedure AS TaxCalculationProcedure,
  InsurClmPaytTaxCategory,
  InsurClmPaytTaxCode,
  InsurClmPaytAmtTaxCategory,
  InsurClmItem,
  InsurClmPaytValidFromDate,
  InsurClmPaytValidToDate,
  InsurClmChangedBy,
  InsurClmChangeTime,
  InsurClmBenefitTypeTree,
  InsurClmBnftTypeTreeGeneration,
  InsurClmBnftTypeTreeVersion,
  _BenefitType.InsurClmLossExpnType AS InsurClmLossExpnType,
  _PaymentHdr.InsurClmPaytRefundFldIsHidden AS InsurClmPaytRefundFldIsHidden,
  _PaymentHdr.InsurClmPaytDisbmtFldIsHidden AS InsurClmPaytDisbmtFldIsHidden,
  InsurClmType,
  InsurClmAuthznGrp
FROM I_InsurClmPaymentItemApp
LEFT OUTER JOIN I_InsurClmTaxCategory AS _TaxCategory ON InsurClmPaytTaxCategory = _TaxCategory.InsuranceClaimTaxCategory  -- association [1]
LEFT OUTER JOIN I_InsurClmPaytItemAmtCat AS _PaytItemAmtCat ON InsurClmPaytAmtCategory = _PaytItemAmtCat.InsurClmPaytAmtCategory  -- association [1]
LEFT OUTER JOIN I_InsurClmPaytAmtTaxCat AS _PaytAmtTaxCat ON InsurClmPaytAmtTaxCategory = _PaytAmtTaxCat.InsurClmPaytAmtTaxCategory  -- association [1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON taxcalculationprocedure = _TaxCode.TaxCalculationProcedure AND InsurClmPaytTaxCode = _TaxCode.TaxCode  -- association [1]
;