R_InsurClmSrvcsDmgdVehSalvgTP

DDL: R_INSURCLMSRVCSDMGDVEHSALVGTP Type: view_entity TRANSACTIONAL
87 Fields 1 Data Sources 3 Associations

Claim Srvcs Damaged Vehicle Salvage - TP

R_InsurClmSrvcsDmgdVehSalvgTP is a Transactional CDS View that provides data about "Claim Srvcs Damaged Vehicle Salvage - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurClmDamagedVeh) and exposes 87 fields with key fields InsuranceClaim, InsurClmDamagedObject, InsurClmDamagedObjectLocation. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmDamagedVeh I_InsurClmDamagedVeh from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Address_2 _Location $projection.InsurClmDamagedObjectLocation = _Location.AddressID
[1..1] R_InsurClmSrvcsInsurClaimTP _InsuranceClaim $projection.InsuranceClaim = _InsuranceClaim.InsuranceClaim
[1..1] I_InsurClmPrtcpntOccrnc _InsurClmPrtcpntOccrnc $projection.InsuranceClaim = _InsurClmPrtcpntOccrnc.InsuranceClaim and $projection.BusinessPartner = _InsurClmPrtcpntOccrnc.BusinessPartner and _InsurClmPrtcpntOccrnc.InsurClmParticipantRole = 'SALV'

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Claim Srvcs Damaged Vehicle Salvage - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #REQUIRED view

Fields (87)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmDamagedObject InsurClmDamagedObject Damaged Object
KEY InsurClmDamagedObjectLocation InsurClmDamagedObjectLocation Text
InsurClmInsuredObjectMake InsurClmInsuredObjectMake Make
InsurClmInsuredObjectModel InsurClmInsuredObjectModel Model
InsurClmConstructionYear InsurClmConstructionYear Constructn Year
InsurClmVehicleIdentification InsurClmVehicleIdentification VIN Cond.
InsurClmVehiclePlateNumber InsurClmVehiclePlateNumber Plate Number
InsurClmVehicleMileage InsurClmVehicleMileage Wrnty Mileage
InsurClmVehicleMileageUnit InsurClmVehicleMileageUnit Unit
InsurClmVehicleValueAmount InsurClmVehicleValueAmount Vehicle Value
InsurClmVehObjectValCurrency InsurClmVehObjectValCurrency Currency
InsurClmInspectionDate InsurClmInspectionDate
InsurClmInsuredVehicleCategory InsurClmInsuredVehicleCategory Category
InsurClmVehicleEngineCapacity InsurClmVehicleEngineCapacity Engine Capacity
InsurClmVehicleEngineCapUnit InsurClmVehicleEngineCapUnit Unit of measure
InsurClmSeasnlLicPlateValdFrm InsurClmSeasnlLicPlateValdFrm Month From
InsurClmSeasnlLicPlateValidTo InsurClmSeasnlLicPlateValidTo Month to
InsurClmVehiclePlateRegion InsurClmVehiclePlateRegion Region
InsurClmVehicleGearType InsurClmVehicleGearType Gear Type
InsurClmVehiclePlateCountry InsurClmVehiclePlateCountry Reg. No. C/R
InsurClmVehFrontTreadQuantity InsurClmVehFrontTreadQuantity Front tread
InsurClmVehRearTreadQuantity InsurClmVehRearTreadQuantity Rear tread
InsurClmVehTreadUnit InsurClmVehTreadUnit Unit
InsurClmChangeDateTime InsurClmChangeDateTime
InsuranceClaimChangedByUser InsuranceClaimChangedByUser User Name
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClaimRegistrationDate InsurClaimRegistrationDate
InsuranceClaimVehicleColor InsuranceClaimVehicleColor Level Color
InsurClmDmgdObjHasLblty InsurClmDmgdObjHasLblty Liability
InsurClmDmgdVehInspNoteText InsurClmDmgdVehInspNoteText Inspection Note
InsurClmVehTripPrps InsurClmVehTripPrps Purpose of trip
InsuranceClaimVehicleLeased InsuranceClaimVehicleLeased Leasing
InsurClmVehIsDrivingPmtd InsurClmVehIsDrivingPmtd Drivers License
InsurClmVehIsDamaged InsurClmVehIsDamaged Damaged
InsurClmVehIsCited InsurClmVehIsCited Vehicle Cited
InsurClmVehDrvrIsCited InsurClmVehDrvrIsCited Driver cited
InsurClmVehIsPrfrdSuplr InsurClmVehIsPrfrdSuplr Pref. Vendor
InsurClmVehIsParked InsurClmVehIsParked Vehicle Parked
InsurClmVehHasPrevDamage InsurClmVehHasPrevDamage Preexistng Dam.
InsurClmVehicleIsNotRoadworthy InsurClmVehicleIsNotRoadworthy Not Roadworthy
InsurClmVehQtyInMlge InsurClmVehQtyInMlge Wrnty Mileage
InsurClmRelshpOwnrAndPlcyHldr InsurClmRelshpOwnrAndPlcyHldr Rel. Owner/PH
InsurClmVehicleIsTotalLoss InsurClmVehicleIsTotalLoss Total Loss
InsurClmDmgdItmIsStolen InsurClmDmgdItmIsStolen Stolen
InsurClmDmgdItmIsRecovered InsurClmDmgdItmIsRecovered Recovered
InsurClaimVehRecoveryDate InsurClaimVehRecoveryDate
InsurClmVehLastOwnrChgDte InsurClmVehLastOwnrChgDte
InsClmVehNextMandInspInYrMnth InsClmVehNextMandInspInYrMnth
InsurClmSalvgActlCshCrcy InsurClmSalvgActlCshCrcy Valuation Crcy
InsurClmSalvgValAmt InsurClmSalvgValAmt Salvage Value
InsurClmAvgSalvgPotntlAmt InsurClmAvgSalvgPotntlAmt Avge Potential
InsurClmSalvgEvalDte InsurClmSalvgEvalDte Evaluation Date
InsurClmDmgdObjSalvgDetmDte InsurClmDmgdObjSalvgDetmDte DmgdObj DetmDte
InsurClmVehSalvgArrivalDate InsurClmVehSalvgArrivalDate Arrival Date
InsurClmVehSalvgRptdPoliceDte InsurClmVehSalvgRptdPoliceDte Dte Rptd Police
InsurClmSalvgSoldDte InsurClmSalvgSoldDte Date Sold
InsClmDmgdItmIsRetainedByOwnr InsClmDmgdItmIsRetainedByOwnr Owner Retained
InsurClmHistRatePct InsurClmHistRatePct History Rate
InsurClmVehDailySalvgChrgsAmt InsurClmVehDailySalvgChrgsAmt StandgChrgeSalv
InsurClmSalvgAssgDte InsurClmSalvgAssgDte Date Assigned
InsurClmSalvgArrivalDate InsurClmSalvgArrivalDate Arrival Date
InsurClmSalvgSettlmtDte InsurClmSalvgSettlmtDte Settlement Date
InsurClmSalvgStockNumber InsurClmSalvgStockNumber Stock Number
InsurClmSalvgYardLocation InsurClmSalvgYardLocation Salvor Location
InsurClmVehSalvgTtlToSalvorDte InsurClmVehSalvgTtlToSalvorDte Title to Salvor
InsClmVehSalvgTtlRcvdSalvorDte InsClmVehSalvgTtlRcvdSalvorDte Title w.Salvor
InsurClmVehSalvgTtlToStateDte InsurClmVehSalvgTtlToStateDte Title to State
InsClmVehSalvgTtlRcvdStateDte InsClmVehSalvgTtlRcvdStateDte Title Recvd
InsurClmSalvgTtlReceiveDte InsurClmSalvgTtlReceiveDte Date Received
InsurClmVehSalvgCertDte InsurClmVehSalvgCertDte Certificate Dte
InsurClmItemRefNumber InsurClmItemRefNumber Reference no.
InsurClmPurgDocReference InsurClmPurgDocReference Purchasing Doc.
InsurClmPurgDocItemReference InsurClmPurgDocItemReference Item Number
InsurClmRefLocCat InsurClmRefLocCat Ref. Location
InsurClmTransactionType InsurClmTransactionType Procurem.Trans.
InsurClmInspLoc InsurClmInspLoc Location
BusinessPartner _InsurClmPrtcpntOccrnc BusinessPartner Issuing Authority
CityName _Location CityName Name
Country _Location Country Venue: Ctry/Reg
HouseNumber _Location HouseNumber House Number
StreetName _Location StreetName Text
PostalCode _Location PostalCode Postal Code
Region _Location Region Venue Region
_InsurClmDamagedObj _InsurClmDamagedObj
_InsuranceClaim _InsuranceClaim
_InsurClmPrtcpntOccrnc _InsurClmPrtcpntOccrnc

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_InsurClmSrvcsDmgdVehSalvgTP.
-- 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_InsurClmSrvcsDmgdVehSalvgTP AS
SELECT
  InsuranceClaim,
  InsurClmDamagedObject,
  InsurClmDamagedObjectLocation,
  InsurClmInsuredObjectMake,
  InsurClmInsuredObjectModel,
  InsurClmConstructionYear,
  InsurClmVehicleIdentification,
  InsurClmVehiclePlateNumber,
  InsurClmVehicleMileage,
  InsurClmVehicleMileageUnit,
  InsurClmVehicleValueAmount,
  InsurClmVehObjectValCurrency,
  InsurClmInspectionDate,
  InsurClmInsuredVehicleCategory,
  InsurClmVehicleEngineCapacity,
  InsurClmVehicleEngineCapUnit,
  InsurClmSeasnlLicPlateValdFrm,
  InsurClmSeasnlLicPlateValidTo,
  InsurClmVehiclePlateRegion,
  InsurClmVehicleGearType,
  InsurClmVehiclePlateCountry,
  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,
  InsurClmSalvgActlCshCrcy,
  InsurClmSalvgValAmt,
  InsurClmAvgSalvgPotntlAmt,
  InsurClmSalvgEvalDte,
  InsurClmDmgdObjSalvgDetmDte,
  InsurClmVehSalvgArrivalDate,
  InsurClmVehSalvgRptdPoliceDte,
  InsurClmSalvgSoldDte,
  InsClmDmgdItmIsRetainedByOwnr,
  InsurClmHistRatePct,
  InsurClmVehDailySalvgChrgsAmt,
  InsurClmSalvgAssgDte,
  InsurClmSalvgArrivalDate,
  InsurClmSalvgSettlmtDte,
  InsurClmSalvgStockNumber,
  InsurClmSalvgYardLocation,
  InsurClmVehSalvgTtlToSalvorDte,
  InsClmVehSalvgTtlRcvdSalvorDte,
  InsurClmVehSalvgTtlToStateDte,
  InsClmVehSalvgTtlRcvdStateDte,
  InsurClmSalvgTtlReceiveDte,
  InsurClmVehSalvgCertDte,
  InsurClmItemRefNumber,
  InsurClmPurgDocReference,
  InsurClmPurgDocItemReference,
  InsurClmRefLocCat,
  InsurClmTransactionType,
  InsurClmInspLoc,
  _InsurClmPrtcpntOccrnc.BusinessPartner AS BusinessPartner,
  _Location.CityName AS CityName,
  _Location.Country AS Country,
  _Location.HouseNumber AS HouseNumber,
  _Location.StreetName AS StreetName,
  _Location.PostalCode AS PostalCode,
  _Location.Region AS Region
FROM I_InsurClmDamagedVeh
LEFT OUTER JOIN I_Address_2 AS _Location ON InsurClmDamagedObjectLocation = _Location.AddressID  -- association [0..1]
LEFT OUTER JOIN R_InsurClmSrvcsInsurClaimTP AS _InsuranceClaim ON InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN I_InsurClmPrtcpntOccrnc AS _InsurClmPrtcpntOccrnc ON InsuranceClaim = _InsurClmPrtcpntOccrnc.InsuranceClaim AND BusinessPartner = _InsurClmPrtcpntOccrnc.BusinessPartner AND _InsurClmPrtcpntOccrnc.InsurClmParticipantRole = 'SALV'  -- association [1..1]
;

Learn More