R_INS_ClaimItemDraft

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_INS_ClaimItemDraft.
-- 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_INS_ClaimItemDraft AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmItem,
  DraftUUID,
  InsurClmItemEvaluation,
  ParentDraftUUID,
  cast ( lastchangedatetime as icl_achangetime_fiori preserving type ) AS LastChangeDateTime,
  LastChangedByUser,
  InsurClmDatabaseLineStatus,
  InsurClmItemCat,
  InsurClmItemType,
  InsurClmCoverageType,
  InsurBnftType,
  InsurClmItemStatus,
  InsurClmItemRjcnRsn,
  InsurClmItemDescription,
  InsurClmItemEvalBase,
  InsuranceClaimItemUsageType,
  InsurClmBenefitCoverageType,
  InsurClmIsWaitPerdIgnrd,
  InsuranceClaimItemCoverage,
  InsurClmItemBenefitCatalogUUID,
  InsurClmItemIdOfServiceCatalog,
  InsurClmItmBnftCatalogItemID,
  InsurClmIsModified,
  InsurClmIsProcured,
  InsurClmIsCalculated,
  InsurClmDailyBenefitsValue,
  InsurClmWeeklyBenefitsValue,
  InsurClmMonthlyBenefitsValue,
  InsurClmTotalBenefitsValue,
  InsurClmItmValidFromDate,
  InsuranceClaimItemValidToDate,
  InsuranceClaimStartDate,
  InsuranceClaimEndDate,
  InsurClmItemEvaluationValue,
  InsurClmItemEvalQuantity,
  InsurClmItemEvalQuantityUnit,
  InsurClmItemEvalPerUnitAmt,
  InsurClmItemEvalAmount,
  InsurClmItemEvalCurrency,
  InsurClmEvaluationCategory,
  InsurClmItemEvalFactor,
  InsurClmItmEvalActlCshValAmt,
  InsurClmItmEvalActlCshValPct,
  InsurClmBRFCalcExpression,
  InsurClmItemTaxCode,
  InsuranceClaimItemPerDayAmount,
  InsurClmItmGrpDiscPercentAmt,
  InsurClmIsDiscountUsed,
  InsurClmIsDiscountPercent,
  InsurClmIsDiscountToBeApplied,
  InsurClmIsNet,
  InsurClmItemSubclmRef,
  InsurClmItemRef,
  InsuranceClaimProcurementID,
  InsurClmProcmtHandle,
  InsurClmDamagedObject,
  InsurClmAssignUUID,
  InsurClmBnftValAmt,
  InsurClmManuallyCreatedItem,
  InsuranceClaimCreationReason,
  InsurClmIsInternalClearing,
  InsuranceClaimPeriodicity,
  InsurClmAddlPaytDueDateVal,
  InsurClmItemRefNumber,
  InsurClmPurgDocReference,
  InsurClmPurgDocItemReference,
  InsurClmRefLocCat,
  InsurClmTransactionType,
  InsurClmIsGoodwillPayment,
  InsurClmAdditionalItem,
  InsurClmIsAdditionalTotal,
  InsurClmRemunerationCategory,
  InsurClaimTotalAnnualAmount,
  InsuranceClaimPayrollVariant,
  InsurClmDisbursementCategory,
  InsurClmPreliminarySubclaim,
  InsuranceDataAgingObjectDate,
  InsuranceClaimMaterialGroup,
  InsuranceClaimSupplier,
  InsuranceClaimManufacturerCode,
  InsuranceClaimIsService,
  InsurClmItemClmdAmount,
  InsurClmMfrNmbr,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM iclitemdraft2 AS ICL_ItemDraft
;