A_InsurClmDamagedItem

DDL: A_INSURCLMDAMAGEDITEM Type: view_entity CONSUMPTION

Claim Damaged Item

A_InsurClmDamagedItem is a Consumption CDS View that provides data about "Claim Damaged Item" in SAP S/4HANA. It reads from 1 data source (R_InsurClmDamagedItemTP) and exposes 37 fields with key fields InsurClmActive, InsuranceClaim, InsurClmDamagedObject.

Data Sources (1)

SourceAliasJoin Type
R_InsurClmDamagedItemTP R_InsurClmDamagedItemTP projection

Annotations (12)

NameValueLevelField
EndUserText.label Claim Damaged Item view
AbapCatalog.extensibility.elementSuffix ICL view
AbapCatalog.extensibility.quota.maximumFields 100 view
AbapCatalog.extensibility.quota.maximumBytes 1000 view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name InsurClmDamagedItem_Type view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive InsurClmActive Active/Suspense
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmDamagedObject InsurClmDamagedObject Damaged Object
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangedByUser LastChangedByUser User Name
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClmVehicleMfr InsurClmVehicleMfr
InsurClmVehicleModel InsurClmVehicleModel
InsurClmHomeContentsYear InsurClmHomeContentsYear
InsurClmSerialNoHomeContents InsurClmSerialNoHomeContents
InsurClmDamagedObjectLocation InsurClmDamagedObjectLocation
InsurClmScopeOfLoss InsurClmScopeOfLoss
InsurClmDmgdItmPropUse InsurClmDmgdItmPropUse
InsurClmDmgdItmIsDamage InsurClmDmgdItmIsDamage
InsurClmDmgdItmIsRecovered InsurClmDmgdItmIsRecovered
InsurClmPreferredSupplier InsurClmPreferredSupplier
InsurClmDmgdItmIsStolen InsurClmDmgdItmIsStolen
InsurClmDmgdItmIsRental InsurClmDmgdItmIsRental
InsurClmDmgdItmIsOperable InsurClmDmgdItmIsOperable
InsurClmDmgdEstRepDate InsurClmDmgdEstRepDate
InsurClmDmgdActRepDate InsurClmDmgdActRepDate
InsurClmDmgdItmInspNoteText InsurClmDmgdItmInspNoteText
InsurClmTotalLoss InsurClmTotalLoss
InsClmDmgdItmIsRetainedByOwnr InsClmDmgdItmIsRetainedByOwnr
InsurClmSalvgEvalDte InsurClmSalvgEvalDte
InsurClmDmgdObjSalvgDetmDte InsurClmDmgdObjSalvgDetmDte
InsurClmAvgSalvgPotntlAmt InsurClmAvgSalvgPotntlAmt
InsurClmSalvgValAmt InsurClmSalvgValAmt
InsurClmSalvgActlCshCrcy InsurClmSalvgActlCshCrcy
InsurClmHistRatePct InsurClmHistRatePct
InsurClmSalvgAssgDte InsurClmSalvgAssgDte
InsurClmSalvgArrivalDate InsurClmSalvgArrivalDate
InsurClmSalvgSettlmtDte InsurClmSalvgSettlmtDte
InsurClmSalvgSoldDte InsurClmSalvgSoldDte
InsurClmSalvgTtlReceiveDte InsurClmSalvgTtlReceiveDte
InsurClmSalvgNoteTxt InsurClmSalvgNoteTxt
InsurClmInspLoc InsurClmInspLoc

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 A_InsurClmDamagedItem.
-- 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 A_InsurClmDamagedItem AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmDamagedObject,
  ChangedOnDateTime,
  LastChangedByUser,
  InsurClmDatabaseLineStatus,
  InsurClmVehicleMfr,
  InsurClmVehicleModel,
  InsurClmHomeContentsYear,
  InsurClmSerialNoHomeContents,
  InsurClmDamagedObjectLocation,
  InsurClmScopeOfLoss,
  InsurClmDmgdItmPropUse,
  InsurClmDmgdItmIsDamage,
  InsurClmDmgdItmIsRecovered,
  InsurClmPreferredSupplier,
  InsurClmDmgdItmIsStolen,
  InsurClmDmgdItmIsRental,
  InsurClmDmgdItmIsOperable,
  InsurClmDmgdEstRepDate,
  InsurClmDmgdActRepDate,
  InsurClmDmgdItmInspNoteText,
  InsurClmTotalLoss,
  InsClmDmgdItmIsRetainedByOwnr,
  InsurClmSalvgEvalDte,
  InsurClmDmgdObjSalvgDetmDte,
  InsurClmAvgSalvgPotntlAmt,
  InsurClmSalvgValAmt,
  InsurClmSalvgActlCshCrcy,
  InsurClmHistRatePct,
  InsurClmSalvgAssgDte,
  InsurClmSalvgArrivalDate,
  InsurClmSalvgSettlmtDte,
  InsurClmSalvgSoldDte,
  InsurClmSalvgTtlReceiveDte,
  InsurClmSalvgNoteTxt,
  InsurClmInspLoc
FROM R_InsurClmDamagedItemTP
;