I_InsurClmDamagedVeh

DDL: I_INSURCLMDAMAGEDVEH SQL: IICLITEMAU Type: view BASIC

Beschädigtes Fahrzeug

I_InsurClmDamagedVeh is a Basic CDS View that provides data about "Beschädigtes Fahrzeug" in SAP S/4HANA. It reads from 1 data source (iclitemau) and exposes 78 fields with key fields InsuranceClaim, InsurClmDamagedObject, InsurClmDamagedObjectLocation. It has 1 association to related views.

1 data source(s) 78 fields

Data Sources (1)

SourceAliasJoin Type
iclitemau iclitemau from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.InsurClmSalvgActlCshCrcy = _Currency.Currency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IICLITEMAU view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
EndUserText.label Beschädigtes Fahrzeug view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (78)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim claim
KEY InsurClmDamagedObject damagedobj
KEY InsurClmDamagedObjectLocation location
InsurClmInsuredObjectMake propmake
InsurClmInsuredObjectModel propmodel
InsurClmConstructionYear constyear
InsurClmVehicleIdentification vin
InsurClmVehiclePlateNumber plateno
InsurClmVehicleMileage mileage
InsurClmVehicleMileageUnit mileageunit
InsurClmVehFrontTreadQuantity treadf
InsurClmVehRearTreadQuantity treadr
InsurClmVehTreadUnit treadunit
InsurClmVehicleValueAmount pcv
InsurClmVehObjectValCurrency pcvcurr
InsurClmInspectionDate
InsurClmInsuredVehicleCategory modelty
InsurClmVehicleEngineCapacity capacity
InsurClmVehicleEngineCapUnit capunit
InsurClmVehicleGearType gear
InsurClmSeasnlLicPlateValdFrm month_from
InsurClmSeasnlLicPlateValidTo month_to
InsurClmVehiclePlateCountry platecountry
InsurClmVehiclePlateRegion plateregion
InsurClmChangeDateTime
InsuranceClaimChangedByUser changedby
InsurClmDatabaseLineStatus deleted
InsurClaimRegistrationDate
InsuranceClaimVehicleColor color
InsurClmDmgdObjHasLblty xthirdparty
InsurClmDmgdVehInspNoteText whenseen
InsurClmVehTripPrps purptrip
InsuranceClaimVehicleLeased leasing
InsurClmVehIsDrivingPmtd xperm
InsurClmVehIsDamaged xdam
InsurClmVehIsCited xvehicit
InsurClmVehDrvrIsCited xdrivcit
InsurClmVehIsPrfrdSuplr xpvendor
InsurClmVehIsParked xparked
InsurClmVehHasPrevDamage xpre
InsurClmVehicleIsNotRoadworthy drivable
InsurClmVehQtyInMlge mileage
InsurClmRelshpOwnrAndPlcyHldr owphrel
InsurClmVehicleIsTotalLoss xtotdamage
InsurClmDmgdItmIsStolen xstolen
InsurClmDmgdItmIsRecovered xrecovered
InsurClaimVehRecoveryDate
InsurClmVehLastOwnrChgDte
InsClmVehNextMandInspInYrMnth
InsurClmSalvgActlCshCrcy curr
InsurClmSalvgValAmt salvvalue
InsurClmAvgSalvgPotntlAmt estacv
InsurClmSalvgEvalDte evaldate
InsurClmDmgdObjSalvgDetmDte determdate
InsurClmVehSalvgArrivalDate dateatrpr
InsurClmVehSalvgRptdPoliceDte rptdtocb
InsurClmSalvgSoldDte solddate
InsClmDmgdItmIsRetainedByOwnr xownerret
InsurClmHistRatePct histrate
InsurClmVehDailySalvgChrgsAmt dailyrate
InsurClmSalvgAssgDte assigndate
InsurClmSalvgArrivalDate retrvdate
InsurClmSalvgSettlmtDte settledate
InsurClmSalvgStockNumber stocknum
InsurClmSalvgYardLocation yardloc
InsurClmVehSalvgTtlToSalvorDte titletosalv
InsClmVehSalvgTtlRcvdSalvorDte titlefmsalv
InsurClmVehSalvgTtlToStateDte titletostate
InsClmVehSalvgTtlRcvdStateDte titlefmstate
InsurClmSalvgTtlReceiveDte titlerecv
InsurClmVehSalvgCertDte certficatedt
InsurClmItemRefNumber refno
InsurClmPurgDocReference pdref
InsurClmPurgDocItemReference pdpos
InsurClmRefLocCat ref_loccat
InsurClmTransactionType ptype
InsurClmInspLoc sel_location
_Currency _Currency 
@AbapCatalog.sqlViewName: 'IICLITEMAU'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Beschädigtes Fahrzeug'

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC

@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #C
}


define view I_InsurClmDamagedVeh
  as select from iclitemau

  association [0..1] to I_Currency as _Currency on $projection.InsurClmSalvgActlCshCrcy = _Currency.Currency
{
  key claim                                                       as InsuranceClaim,
  key damagedobj                                                  as InsurClmDamagedObject,
  key location                                                    as InsurClmDamagedObjectLocation,
      propmake                                                    as InsurClmInsuredObjectMake,
      propmodel                                                   as InsurClmInsuredObjectModel,
      constyear                                                   as InsurClmConstructionYear,
      vin                                                         as InsurClmVehicleIdentification,
      plateno                                                     as InsurClmVehiclePlateNumber,
      mileage                                                     as InsurClmVehicleMileage,
      mileageunit                                                 as InsurClmVehicleMileageUnit,
      @Semantics.quantity.unitOfMeasure:'InsurClmVehTreadUnit'
      treadf                                                      as InsurClmVehFrontTreadQuantity,
      @Semantics.quantity.unitOfMeasure:'InsurClmVehTreadUnit'
      treadr                                                      as InsurClmVehRearTreadQuantity,
      treadunit                                                   as InsurClmVehTreadUnit,
      @Semantics.amount.currencyCode: 'InsurClmSalvgActlCshCrcy'
      pcv                                                         as InsurClmVehicleValueAmount,
      pcvcurr                                                     as InsurClmVehObjectValCurrency,
      case inspdate when '' then cast('00000000' as abap.dats(8)) end  as InsurClmInspectionDate,
      //New fields for FNOL API 03/07/23

      modelty                                                     as InsurClmInsuredVehicleCategory,
      capacity                                                    as InsurClmVehicleEngineCapacity,
      capunit                                                     as InsurClmVehicleEngineCapUnit,
      gear                                                        as InsurClmVehicleGearType,
      month_from                                                  as InsurClmSeasnlLicPlateValdFrm,
      month_to                                                    as InsurClmSeasnlLicPlateValidTo,
      platecountry                                                as InsurClmVehiclePlateCountry,
      plateregion                                                 as InsurClmVehiclePlateRegion,
      //New Fields for Maintenance API 16/08/23

      cast( changetime as icl_achangetime_fiori preserving type ) as InsurClmChangeDateTime,
      changedby                                                   as InsuranceClaimChangedByUser,
      deleted                                                     as InsurClmDatabaseLineStatus,
      case firstreg when '' then cast('00000000' as abap.dats(8)) end   as InsurClaimRegistrationDate,
      color                                                       as InsuranceClaimVehicleColor,
      xthirdparty                                                 as InsurClmDmgdObjHasLblty,
      whenseen                                                    as InsurClmDmgdVehInspNoteText,
      purptrip                                                    as InsurClmVehTripPrps,
      leasing                                                     as InsuranceClaimVehicleLeased,
      @Semantics.booleanIndicator: true
      xperm                                                       as InsurClmVehIsDrivingPmtd,
      @Semantics.booleanIndicator: true
      xdam                                                        as InsurClmVehIsDamaged,
      @Semantics.booleanIndicator: true
      xvehicit                                                    as InsurClmVehIsCited,
      @Semantics.booleanIndicator: true
      xdrivcit                                                    as InsurClmVehDrvrIsCited,
      @Semantics.booleanIndicator: true
      xpvendor                                                    as InsurClmVehIsPrfrdSuplr,
      @Semantics.booleanIndicator: true
      xparked                                                     as InsurClmVehIsParked,
      @Semantics.booleanIndicator: true
      xpre                                                        as InsurClmVehHasPrevDamage,
      @Semantics.booleanIndicator: true
      drivable                                                    as InsurClmVehicleIsNotRoadworthy,
      mileage                                                     as InsurClmVehQtyInMlge,
      owphrel                                                     as InsurClmRelshpOwnrAndPlcyHldr,
      @Semantics.booleanIndicator: true
      xtotdamage                                                  as InsurClmVehicleIsTotalLoss,
      @Semantics.booleanIndicator: true
      xstolen                                                     as InsurClmDmgdItmIsStolen,
      @Semantics.booleanIndicator: true
      xrecovered                                                  as InsurClmDmgdItmIsRecovered,
      case recoverdate when '' then cast('00000000' as abap.dats(8))  end  as InsurClaimVehRecoveryDate,
      case ownerchange when '' then cast('00000000' as abap.dats(8))  end  as InsurClmVehLastOwnrChgDte,
      cast( generalinsp as icl_generalinsp_api preserving type )  as InsClmVehNextMandInspInYrMnth,
      @Semantics.currencyCode: true
      curr                                                        as InsurClmSalvgActlCshCrcy,
      @Semantics.amount.currencyCode: 'InsurClmSalvgActlCshCrcy'
      salvvalue                                                   as InsurClmSalvgValAmt,
      @Semantics.amount.currencyCode: 'InsurClmSalvgActlCshCrcy'
      estacv                                                      as InsurClmAvgSalvgPotntlAmt,
      evaldate                                                    as InsurClmSalvgEvalDte,
      determdate                                                  as InsurClmDmgdObjSalvgDetmDte,
      dateatrpr                                                   as InsurClmVehSalvgArrivalDate,
      rptdtocb                                                    as InsurClmVehSalvgRptdPoliceDte,
      solddate                                                    as InsurClmSalvgSoldDte,
      @Semantics.booleanIndicator: true
      xownerret                                                   as InsClmDmgdItmIsRetainedByOwnr,
      histrate                                                    as InsurClmHistRatePct,
      @Semantics.amount.currencyCode: 'InsurClmSalvgActlCshCrcy'
      dailyrate                                                   as InsurClmVehDailySalvgChrgsAmt,
      assigndate                                                  as InsurClmSalvgAssgDte,
      retrvdate                                                   as InsurClmSalvgArrivalDate,
      settledate                                                  as InsurClmSalvgSettlmtDte,
      stocknum                                                    as InsurClmSalvgStockNumber,
      yardloc                                                     as InsurClmSalvgYardLocation,
      titletosalv                                                 as InsurClmVehSalvgTtlToSalvorDte,
      titlefmsalv                                                 as InsClmVehSalvgTtlRcvdSalvorDte,
      titletostate                                                as InsurClmVehSalvgTtlToStateDte,
      titlefmstate                                                as InsClmVehSalvgTtlRcvdStateDte,
      titlerecv                                                   as InsurClmSalvgTtlReceiveDte,
      certficatedt                                                as InsurClmVehSalvgCertDte,
      refno                                                       as InsurClmItemRefNumber,
      pdref                                                       as InsurClmPurgDocReference,
      pdpos                                                       as InsurClmPurgDocItemReference,
      ref_loccat                                                  as InsurClmRefLocCat,
      ptype                                                       as InsurClmTransactionType,
      sel_location                                                as InsurClmInspLoc,

      //Associations

      _Currency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ICLITEMAU"
],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More