C_InsurClmBPQuickView

DDL: C_INSURCLMBPQUICKVIEW SQL: CICLBPQUICKVIEW Type: view CONSUMPTION Package: ICL_VDM_CLAIMINQUIRY

Geschäftspartner für Fallauskunft

C_InsurClmBPQuickView is a Consumption CDS View that provides data about "Geschäftspartner für Fallauskunft" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 17 fields with key field BusinessPartner. It has 2 associations to related views. It is exposed through 5 OData services (ICL_CLAIMCHANGEHEADER, ICL_CLAIMINQUIRY_R, ICL_DAMAGEDMGDOBJECTMAINTAIN, ...). Part of development package ICL_VDM_CLAIMINQUIRY.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner _IBP from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_BPGenderValueHelpText _BPGenderText $projection.GenderCodeName = _BPGenderText.GenderCodeName
[0..*] I_InsurClmClaimOverview _Claim $projection.BusinessPartner = _Claim.InsurancePolicyholder

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CICLBPQUICKVIEW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Geschäftspartner für Fallauskunft view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.representativeKey BusinessPartner view

OData Services (5)

ServiceBindingVersionContractRelease
ICL_CLAIMCHANGEHEADER ICL_UI_CLAIMCHANGEHEADER V2 C1 NOT_RELEASED
ICL_CLAIMINQUIRY_R ICL_UI_CLAIMINQUIRY_R_O2 V2 C1 NOT_RELEASED
ICL_DAMAGEDMGDOBJECTMAINTAIN ICL_UI_DMGDOBJECTMAINTAIN V2 C1 NOT_RELEASED
ICL_INSURCLMFNOLTP ICL_UI_INSURCLMFNOLTP V2 C1 NOT_RELEASED
ICL_SUBLCLAIMMAINTAIN ICL_UI_SUBLCLAIMMAINTAIN V2 C1 NOT_RELEASED

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
BusinessPartnerCategory BusinessPartnerCategory
BusinessPartnerName BusinessPartnerName
LastName LastName
FirstName FirstName
BirthDate BirthDate
PhoneNumber
EmailAddress
IsFemale IsFemale
IsMale IsMale
IsSexUnknown IsSexUnknown
GenderCodeNameText
GenderCodeName I_BusinessPartner GenderCodeName
Country1asInsurClmLocationText
_BPGenderText _BPGenderText
_DefaultAddress _DefaultAddress
_Claim _Claim
@AbapCatalog.sqlViewName: 'CICLBPQUICKVIEW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Geschäftspartner für Fallauskunft'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@Metadata.allowExtensions: true
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #D
}
@ObjectModel.representativeKey: 'BusinessPartner'

define view C_InsurClmBPQuickView
  as select from I_BusinessPartner as _IBP
  association [0..*] to I_BPGenderValueHelpText as _BPGenderText on $projection.GenderCodeName = _BPGenderText.GenderCodeName
  association [0..*] to I_InsurClmClaimOverview as _Claim        on $projection.BusinessPartner = _Claim.InsurancePolicyholder
{
      @UI.facet: [
      {
        purpose:    #QUICK_VIEW,
        type:       #FIELDGROUP_REFERENCE,
        targetQualifier: 'QuickView'
      }]
      @Consumption.filter.hidden: true
  key BusinessPartner,
      @Consumption.filter.hidden: true
      BusinessPartnerCategory,
      @Consumption.filter.hidden: true
      BusinessPartnerName,
      @Consumption.filter.hidden: true
      LastName,
      @Consumption.filter.hidden: true
      FirstName,

      @UI.fieldGroup: [{ label: 'Geburtsdatum' ,position: 10 , qualifier: 'QuickView', importance: #HIGH }]
      // label: 'Date of Birth'

      @Consumption.filter.hidden: true
      @Semantics.contact.birthDate: true
      BirthDate,

      @Consumption.filter.hidden: true
      @Semantics.telephone : {type: [#CELL]}
      @UI.fieldGroup: [{ label: 'Telefonnummer' , position: 40 , importance: #HIGH,qualifier: 'QuickView'}]
      //  label: 'Phone Number'

      _CurrentDefaultAddress._Address._DefaultPhoneNumber.PhoneNumber,

      //       concat_with_space(_CurrentDefaultAddress._Address._DefaultPhoneNumber.PhoneNumber, PersonNumber, 1) as PhoneNumber,

      //      @Semantics.telephone : {type: [#HOME]}

      //      @UI.fieldGroup: [{label: 'Phone Number' , position: 60 , importance: #HIGH,qualifier: 'QuickView'}]

      //      PersonNumber,

      @UI.fieldGroup: [{ label: 'E-Mail', position: 30 , importance: #HIGH,qualifier: 'QuickView'}]
      //   label: 'Email'

      @Consumption.filter.hidden: true
      @Semantics.eMail.address: true
      @Semantics.eMail.type: [#PREF]
      _CurrentDefaultAddress._Address._DefaultEmailAddress.EmailAddress,
      @Consumption.filter.hidden: true
      IsFemale,
      @Consumption.filter.hidden: true
      IsMale,
      @Consumption.filter.hidden: true
      IsSexUnknown,

      @UI.fieldGroup: [{ label: 'Geschlecht'  , position: 20 , importance: #HIGH,qualifier: 'QuickView'}]
      @Consumption.filter.hidden: true
      //  label: 'Gender'

      //@ObjectModel.foreignKey.association: '_GenderValueHelp'

      //@ObjectModel.text.association: '_BPGenderText'

      _BPGenderText[Language = $session.system_language].GenderCodeNameText,
      @Consumption.filter.hidden: true
      _IBP.GenderCodeName,

      @UI.fieldGroup: [{ label: 'Adresse' , position: 50 , importance: #HIGH,qualifier: 'QuickView'}]
      @Consumption.filter.hidden: true
      //  label: 'Address'

      concat_with_space(
        concat_with_space(
          concat( concat_with_space( _CurrentDefaultAddress._Address.StreetName , _CurrentDefaultAddress._Address.HouseNumber, 1), ','),
          concat( concat_with_space(_CurrentDefaultAddress._Address.PostalCode,  _CurrentDefaultAddress._Address.CityName, 1), ','),
          1
        ),
        _CurrentDefaultAddress._Address.Country,
        1
      ) as InsurClmLocationText,
       @Consumption.filter.hidden: true
          case
          when BusinessPartnerCategory = '1'
              then concat(substring (FirstName,1,1), substring (LastName,1,1))
          when BusinessPartnerCategory = '2'
               then concat(substring (OrganizationBPName1,1,1), substring (OrganizationBPName2,1,1))
          when BusinessPartnerCategory = '3'
               then concat(substring (GroupBusinessPartnerName1,1,1), substring (GroupBusinessPartnerName1,1,1))
           else ''
        end                                                                                  as BusinessPartnerInitialsName,
   
      _BPGenderText,
      _DefaultAddress,
      _Claim
}