A_InsurClmSrvcsDmgdVehicle

DDL: A_INSURCLMSRVCSDMGDVEHICLE Type: view_entity CONSUMPTION

Claim Services For Damaged Vehicle

A_InsurClmSrvcsDmgdVehicle is a Consumption CDS View that provides data about "Claim Services For Damaged Vehicle" in SAP S/4HANA. It reads from 1 data source (R_InsurClmSrvcsDmgdVehTP) and exposes 55 fields with key fields InsuranceClaim, InsurClmDamagedObject.

Data Sources (1)

SourceAliasJoin Type
R_InsurClmSrvcsDmgdVehTP R_InsurClmSrvcsDmgdVehTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Claim Services For Damaged Vehicle 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 InsurClmSrvcsDmgdVehicle_Type view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmDamagedObject InsurClmDamagedObject Damaged Object
InsurClmDamagedObjectLocation InsurClmDamagedObjectLocation
InsurClmInsuredObjectMake InsurClmInsuredObjectMake
InsurClmInsuredObjectModel InsurClmInsuredObjectModel
InsurClmConstructionYear InsurClmConstructionYear
InsurClmVehicleIdentification InsurClmVehicleIdentification
InsurClmVehiclePlateNumber InsurClmVehiclePlateNumber
InsurClmVehicleMileage InsurClmVehicleMileage
InsurClmVehicleMileageUnit InsurClmVehicleMileageUnit
InsurClmVehicleValueAmount InsurClmVehicleValueAmount
InsurClmVehObjectValCurrency InsurClmVehObjectValCurrency
InsurClmInspectionDate InsurClmInspectionDate
InsurClmInsuredVehicleCategory InsurClmInsuredVehicleCategory
InsurClmVehicleEngineCapacity InsurClmVehicleEngineCapacity
InsurClmVehicleEngineCapUnit InsurClmVehicleEngineCapUnit
InsurClmSeasnlLicPlateValdFrm InsurClmSeasnlLicPlateValdFrm
InsurClmSeasnlLicPlateValidTo InsurClmSeasnlLicPlateValidTo
InsurClmVehicleGearType InsurClmVehicleGearType
InsurClmVehiclePlateCountry InsurClmVehiclePlateCountry
InsurClmVehiclePlateRegion InsurClmVehiclePlateRegion
InsurClmVehFrontTreadQuantity InsurClmVehFrontTreadQuantity
InsurClmVehRearTreadQuantity InsurClmVehRearTreadQuantity
InsurClmVehTreadUnit InsurClmVehTreadUnit
InsurClmChangeDateTime InsurClmChangeDateTime
InsuranceClaimChangedByUser InsuranceClaimChangedByUser
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClaimRegistrationDate InsurClaimRegistrationDate
InsuranceClaimVehicleColor InsuranceClaimVehicleColor
InsurClmDmgdObjHasLblty InsurClmDmgdObjHasLblty
InsurClmDmgdVehInspNoteText InsurClmDmgdVehInspNoteText
InsurClmVehTripPrps InsurClmVehTripPrps
InsuranceClaimVehicleLeased InsuranceClaimVehicleLeased
InsurClmVehIsDrivingPmtd InsurClmVehIsDrivingPmtd
InsurClmVehIsDamaged InsurClmVehIsDamaged
InsurClmVehIsCited InsurClmVehIsCited
InsurClmVehDrvrIsCited InsurClmVehDrvrIsCited
InsurClmVehIsPrfrdSuplr InsurClmVehIsPrfrdSuplr
InsurClmVehIsParked InsurClmVehIsParked
InsurClmVehHasPrevDamage InsurClmVehHasPrevDamage
InsurClmVehicleIsNotRoadworthy InsurClmVehicleIsNotRoadworthy
InsurClmVehQtyInMlge InsurClmVehQtyInMlge
InsurClmRelshpOwnrAndPlcyHldr InsurClmRelshpOwnrAndPlcyHldr
InsurClmVehicleIsTotalLoss InsurClmVehicleIsTotalLoss
InsurClmDmgdItmIsStolen InsurClmDmgdItmIsStolen
InsurClmDmgdItmIsRecovered InsurClmDmgdItmIsRecovered
InsurClaimVehRecoveryDate InsurClaimVehRecoveryDate
InsurClmVehLastOwnrChgDte InsurClmVehLastOwnrChgDte
InsClmVehNextMandInspInYrMnth InsClmVehNextMandInspInYrMnth
CityName CityName Name
Country Country Venue: Ctry/Reg
HouseNumber HouseNumber House Number
StreetName StreetName Text
PostalCode PostalCode Postal Code
Region Region Venue Region

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_InsurClmSrvcsDmgdVehicle.
-- 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_InsurClmSrvcsDmgdVehicle AS
SELECT
  InsuranceClaim,
  InsurClmDamagedObject,
  InsurClmDamagedObjectLocation,
  InsurClmInsuredObjectMake,
  InsurClmInsuredObjectModel,
  InsurClmConstructionYear,
  InsurClmVehicleIdentification,
  InsurClmVehiclePlateNumber,
  InsurClmVehicleMileage,
  InsurClmVehicleMileageUnit,
  InsurClmVehicleValueAmount,
  InsurClmVehObjectValCurrency,
  InsurClmInspectionDate,
  InsurClmInsuredVehicleCategory,
  InsurClmVehicleEngineCapacity,
  InsurClmVehicleEngineCapUnit,
  InsurClmSeasnlLicPlateValdFrm,
  InsurClmSeasnlLicPlateValidTo,
  InsurClmVehicleGearType,
  InsurClmVehiclePlateCountry,
  InsurClmVehiclePlateRegion,
  InsurClmVehFrontTreadQuantity,
  InsurClmVehRearTreadQuantity,
  InsurClmVehTreadUnit,
  InsurClmChangeDateTime,
  InsuranceClaimChangedByUser,
  InsurClmDatabaseLineStatus,
  InsurClaimRegistrationDate,
  InsuranceClaimVehicleColor,
  InsurClmDmgdObjHasLblty,
  InsurClmDmgdVehInspNoteText,
  InsurClmVehTripPrps,
  InsuranceClaimVehicleLeased,
  InsurClmVehIsDrivingPmtd,
  InsurClmVehIsDamaged,
  InsurClmVehIsCited,
  InsurClmVehDrvrIsCited,
  InsurClmVehIsPrfrdSuplr,
  InsurClmVehIsParked,
  InsurClmVehHasPrevDamage,
  InsurClmVehicleIsNotRoadworthy,
  InsurClmVehQtyInMlge,
  InsurClmRelshpOwnrAndPlcyHldr,
  InsurClmVehicleIsTotalLoss,
  InsurClmDmgdItmIsStolen,
  InsurClmDmgdItmIsRecovered,
  InsurClaimVehRecoveryDate,
  InsurClmVehLastOwnrChgDte,
  InsClmVehNextMandInspInYrMnth,
  CityName,
  Country,
  HouseNumber,
  StreetName,
  PostalCode,
  Region
FROM R_InsurClmSrvcsDmgdVehTP
;