I_InsurClmFNOLTP

DDL: I_INSURCLMFNOLTP SQL: ICLFNOLRAPTP Type: view_entity TRANSACTIONAL Package: ICL_VDM_FIRSTNOTICEOFLOSS_RAP

FNOL Header - TP

I_InsurClmFNOLTP is a Transactional CDS View that provides data about "FNOL Header - TP" in SAP S/4HANA. It reads from 1 data source (I_InsuranceClaim) and exposes 51 fields with key fields InsuranceClaim, InsurClaimUUID. It has 15 associations to related views. Part of development package ICL_VDM_FIRSTNOTICEOFLOSS_RAP.

Data Sources (1)

SourceAliasJoin Type
I_InsuranceClaim I_InsuranceClaim from

Associations (15)

CardinalityTargetAliasCondition
[1..1] I_InsurClmIncdntType _IncidentType $projection.InsurClmPolicyProduct = _IncidentType.InsurClmPolicyProduct and $projection.InsurClmPolicyProdGeneration = _IncidentType.InsurClmPolicyProdGeneration and $projection.InsurClmPolicyProductVersion = _IncidentType.InsurClmPolicyProductVersion and $projection.InsurClmIncdntType = _IncidentType.InsurClmIncdntType
[0..1] I_InsurClmLossCause _LossCause $projection.InsurClmType = _LossCause.InsurClmType and $projection.InsurClmTypeGeneration = _LossCause.InsurClmTypeGeneration and $projection.InsurClmTypeVers = _LossCause.InsurClmTypeVers and $projection.InsurClmCauseOfLoss = _LossCause.InsurClmCauseOfLoss
[0..1] I_InsurClmLossDesc _LossDescription $projection.InsuranceClaim = _LossDescription.InsuranceClaim
[0..1] I_Address _LossLocationAddress $projection.InsurClmLossLocAddressID = _LossLocationAddress.AddressID
[0..1] I_InsurClmHandler _ClaimHandler $projection.InsuranceClaim = _ClaimHandler.InsuranceClaim
[0..1] I_InsurClmStatus _ClaimStatus $projection.InsurClmLifeCycSts = _ClaimStatus.InsurClmLifeCycSts
[1..*] I_InsurClmPrtcpntOccrnc _PolicyHolder $projection.InsuranceClaim = _PolicyHolder.InsuranceClaim and _PolicyHolder.InsurClmSubobjectCategory = 'PO' and _PolicyHolder.InsurClmSubobject = '' and _PolicyHolder.InsurClmParticipantRole = 'POLH'
[1..1] I_InsurClmFNOLPaymentDetails _FnolPay $projection.InsurClmPolicyProduct = _FnolPay.InsurClmPolicyProduct and $projection.InsurClmIncdntType = _FnolPay.InsurClmIncdntType
[1..1] I_InsurClmProdNameVH _ProductName $projection.InsurClmPolicyProduct = _ProductName.InsurClmPolicyProduct and $projection.InsurClmPolicyProdGeneration = _ProductName.InsurClmPolicyProdGeneration
[0..*] I_InsurClmFNOLDamagedObjectTP _DamagedVehicle
[0..*] I_InsurClmFNOLNoteTP _Note
[1..*] I_InsurClmFNOLFactsOriginTP _Facts
[0..*] I_InsurClmFNOLWtnssTP _Witness
[1..*] I_InsurClmFNOLFactsLossLocTP _SFCLoss
[1..*] I_InsurClmFNOLPaytAppTP _Payment

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label FNOL Header - TP view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
AccessControl.personalData.blocking #REQUIRED view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim
KEY InsurClaimUUID
InsuranceClaimDraftIdentifier InsuranceClaimDraftIdentifier
InsuranceContract InsuranceContract
ChangedOnDateTime ChangedOnDateTime
LastChangedByUser LastChangedByUser
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
InsurClmType InsurClmType
InsurClmTypeGeneration InsurClmTypeGeneration
InsurClmTypeVers InsurClmTypeVers
InsurClmLifeCycSts InsurClmLifeCycSts
InsurClmLifeCycStsName
InsurClmAuthznGrp InsurClmAuthznGrp
InsurClmIncdntType I_InsuranceClaim InsurClmIncdntType
InsurClmIncdntTypeName
InsurClmDateOfLoss InsurClmDateOfLoss
InsurClmCauseOfLoss InsurClmCauseOfLoss
InsurClmCauseOfLossName
InsurClmLossLocAddressID InsurClmLossLocAddressID
InsurClmPolicyProduct I_InsuranceClaim InsurClmPolicyProduct
InsurClmPolicyProdGeneration I_InsuranceClaim InsurClmPolicyProdGeneration
InsurClmPolicyProductVersion I_InsuranceClaim InsurClmPolicyProductVersion
InsurClmPlcyProdGnrtnSrchHelp I_InsuranceClaim InsurClmPolicyProdGeneration
InsurClmPolicyProdVersSrchHelp I_InsuranceClaim InsurClmPolicyProductVersion
InsurClmPlcyProdName
InsurClmPolicyHolderName _PolicyHolder BusinessPartnerName
BirthDate _PolicyHolder BirthDate
FullName _ClaimHandler FullName
ContactCardID _ClaimHandler ContactCardID
InsurancePolicyholder _PolicyHolder BusinessPartner
InsurClmDescriptionOfLoss _LossDescription InsurClmDescriptionOfLoss
InsurClmLossLocStreet _LossLocationAddress StreetName
InsurClmLossLocHouseNumber _LossLocationAddress HouseNumber
InsurClmLossLocCity _LossLocationAddress CityName
InsurClmLossLocRegion _LossLocationAddress Region
InsurClmLossLocPostalCode _LossLocationAddress PostalCode
InsurClmLossLocCountry _LossLocationAddress Country
InsurClmLossLocLongitude
InsurClmLossLocLatitude
InsurClmImageURL
_PolicyHolder _PolicyHolder
_IncidentType _IncidentType
_LossCause _LossCause
_DamagedVehicle _DamagedVehicle
_Note _Note
_ClaimHandler _ClaimHandler
_Witness _Witness
_SFCLoss _SFCLoss
_Facts _Facts
_Payment _Payment
////@AbapCatalog.sqlViewName: 'ICLFNOLRAPTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: ' FNOL Header - TP'
//@Metadata.allowExtensions: true

//@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #X
}
//@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.personalData.blocking: #REQUIRED

define root view entity I_InsurClmFNOLTP
  as select from I_InsuranceClaim

  //  association [1..1] to I_InsurClmFNOLContract        as _Contract            on  $projection.InsuranceContract = _Contract.InsuranceContract


  association [1..1] to I_InsurClmIncdntType          as _IncidentType        on  $projection.InsurClmPolicyProduct        = _IncidentType.InsurClmPolicyProduct
                                                                              and $projection.InsurClmPolicyProdGeneration = _IncidentType.InsurClmPolicyProdGeneration
                                                                              and $projection.InsurClmPolicyProductVersion = _IncidentType.InsurClmPolicyProductVersion
                                                                              and $projection.InsurClmIncdntType           = _IncidentType.InsurClmIncdntType

  association [0..1] to I_InsurClmLossCause           as _LossCause           on  $projection.InsurClmType           = _LossCause.InsurClmType
                                                                              and $projection.InsurClmTypeGeneration = _LossCause.InsurClmTypeGeneration
                                                                              and $projection.InsurClmTypeVers       = _LossCause.InsurClmTypeVers
                                                                              and $projection.InsurClmCauseOfLoss    = _LossCause.InsurClmCauseOfLoss

  association [0..1] to I_InsurClmLossDesc            as _LossDescription     on  $projection.InsuranceClaim = _LossDescription.InsuranceClaim

  association [0..1] to I_Address                     as _LossLocationAddress on  $projection.InsurClmLossLocAddressID = _LossLocationAddress.AddressID

  composition [0..*] of I_InsurClmFNOLDamagedObjectTP as _DamagedVehicle
  //on  $projection.InsuranceClaim = _DamagedVehicle.InsuranceClaim


  composition [0..*] of I_InsurClmFNOLNoteTP          as _Note
  //on  $projection.InsuranceClaim = _Note.InsuranceClaim



  association [0..1] to I_InsurClmHandler             as _ClaimHandler        on  $projection.InsuranceClaim = _ClaimHandler.InsuranceClaim

  association [0..1] to I_InsurClmStatus              as _ClaimStatus         on  $projection.InsurClmLifeCycSts = _ClaimStatus.InsurClmLifeCycSts

  association [1..*] to I_InsurClmPrtcpntOccrnc       as _PolicyHolder        on  $projection.InsuranceClaim              = _PolicyHolder.InsuranceClaim
                                                                              and _PolicyHolder.InsurClmSubobjectCategory = 'PO'
                                                                              and _PolicyHolder.InsurClmSubobject         = ''
                                                                              and _PolicyHolder.InsurClmParticipantRole   = 'POLH'

  association [1..1] to I_InsurClmFNOLPaymentDetails  as _FnolPay             on  $projection.InsurClmPolicyProduct = _FnolPay.InsurClmPolicyProduct
                                                                              and $projection.InsurClmIncdntType    = _FnolPay.InsurClmIncdntType


  association [1..1] to I_InsurClmProdNameVH          as _ProductName         on  $projection.InsurClmPolicyProduct        = _ProductName.InsurClmPolicyProduct
                                                                              and $projection.InsurClmPolicyProdGeneration = _ProductName.InsurClmPolicyProdGeneration

  // association [1..1] to C_InsurClmBPQuickView         as _BPDetails           on  $projection.InsurancePolicyholder = _BPDetails.BusinessPartner

  composition [1..*] of I_InsurClmFNOLFactsOriginTP   as _Facts
  //on  $projection.InsuranceClaim = _Facts.InsuranceClaim

  composition [0..*] of I_InsurClmFNOLWtnssTP         as _Witness

  composition [1..*] of I_InsurClmFNOLFactsLossLocTP  as _SFCLoss
  //  composition [1..*] of I_InsurClmFNOLSFCDMGDOBJ    as _SFCDMG

  //on  $projection.InsuranceClaim = _Witness.InsuranceClaim

  /////////////////////////////////////////////////////////

  ///////////Payment Section///////

  ////////////////////////////////////////////////////////

  composition [1..*] of I_InsurClmFNOLPaytAppTP       as _Payment



{
  key         InsuranceClaim,

              // key         cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) as InsurClaimUUID,

  key         cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type )          as InsurClaimUUID,
              //           InsuranceClaim                                                                       as InsuranceClaimForEdit,

              //              @Consumption.valueHelp: '_Contract'

              //              InsuranceClaim                                                                                as InsuranceClaimDraftIdentifier,

              InsuranceClaimDraftIdentifier,
              InsuranceContract,
              ChangedOnDateTime,
              LastChangedByUser,
              CreationDateTime,
              CreatedByUser,
              //              InsuranceClaimExternalNumber,

              InsurClmType,
              InsurClmTypeGeneration,
              InsurClmTypeVers,
              InsurClmLifeCycSts,
              _ClaimStatus._ClaimStatusText[ Language = $session.system_language ].InsurClmLifeCycStsName   as InsurClmLifeCycStsName,
              InsurClmAuthznGrp,
              I_InsuranceClaim.InsurClmIncdntType,
              _IncidentType._IncidentTypeText[ Language = $session.system_language ].InsurClmIncdntTypeName as InsurClmIncdntTypeName,

              InsurClmDateOfLoss,
              InsurClmCauseOfLoss,
              _LossCause._LossCauseText[ Language = $session.system_language].InsurClmCauseOfLossName       as InsurClmCauseOfLossName,
              InsurClmLossLocAddressID,

              I_InsuranceClaim.InsurClmPolicyProduct,
              I_InsuranceClaim.InsurClmPolicyProdGeneration,
              I_InsuranceClaim.InsurClmPolicyProductVersion,

              // Start of New fields for Benefit Type Search Help in payments tab Only

              // These fields are manupulated in Class to get the correct results for the search Help

              // Please do not use these or manupulate them in class, it may result in search help failure

              I_InsuranceClaim.InsurClmPolicyProdGeneration                                                 as InsurClmPlcyProdGnrtnSrchHelp,
              I_InsuranceClaim.InsurClmPolicyProductVersion                                                 as InsurClmPolicyProdVersSrchHelp,
              // End of new fields for search help


              _ProductName[Language = $session.system_language].InsurClmPlcyProdName                        as InsurClmPlcyProdName,
              _PolicyHolder.BusinessPartnerName                                                             as InsurClmPolicyHolderName,
              _PolicyHolder.BirthDate,
              _ClaimHandler.FullName,
              _ClaimHandler.ContactCardID                                                                   as ContactCardID,
              _PolicyHolder.BusinessPartner                                                                 as InsurancePolicyholder,
              _LossDescription.InsurClmDescriptionOfLoss                                                    as InsurClmDescriptionOfLoss,
              _LossLocationAddress.StreetName                                                               as InsurClmLossLocStreet,
              _LossLocationAddress.HouseNumber                                                              as InsurClmLossLocHouseNumber,
              _LossLocationAddress.CityName                                                                 as InsurClmLossLocCity,
              _LossLocationAddress.Region                                                                   as InsurClmLossLocRegion,
              _LossLocationAddress.PostalCode                                                               as InsurClmLossLocPostalCode,
              _LossLocationAddress.Country                                                                  as InsurClmLossLocCountry,
              cast(0 as geolon)                                                                             as InsurClmLossLocLongitude,
              cast(0 as geolat)                                                                             as InsurClmLossLocLatitude,

              cast ( '/sap/bc/ui5_ui5/sap/INS_FNOL2S1/images/Fnol.jpg' as abap.char( 48 )      )            as InsurClmImageURL,

              case InsurClmLifeCycSts
              when '0' then 1
              when '1' then 1
              when '2' then 3
              else 1
              end                                                                                           as InsurClmCriticalityCat,
              //            cast ( 'X' as boolean_flg preserving type  )                                                  as InsurClmPaymentFlag,

              cast(     case _FnolPay.InsurClmIncdntType
                     when ' ' then 'X'
                     else ' '
                     end  as boolean_flg)                                                                   as InsurClmPaymentFlag,
              // Associations

              _PolicyHolder,
              //              _Contract,

              _IncidentType,
              _LossCause,
              _DamagedVehicle,
              _Note,
              _ClaimHandler,
              _Witness,
              _SFCLoss,

              _Facts,

              /// Payment Section

              _Payment
              //            _BPDetails


}
where
  InsuranceClaim <> InsuranceContract