C_InsurPlcyBusPartner

DDL: C_INSURPLCYBUSPARTNER Type: view_entity CONSUMPTION

Geschäftspartner

C_InsurPlcyBusPartner is a Consumption CDS View that provides data about "Geschäftspartner" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 29 fields with key field BusinessPartner. It has 1 association to related views.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner _BusinessPartner from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BPGenderValueHelpText _BPGenderText $projection.GenderCodeName = _BPGenderText.GenderCodeName

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey BusinessPartner view
EndUserText.label Geschäftspartner view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
BusinessPartnerCategory BusinessPartnerCategory
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
BusinessPartnerName BusinessPartnerName
LastName LastName
FirstName FirstName
BirthDate BirthDate
PhoneNumber
EmailAddress
IsFemale IsFemale
IsMale IsMale
IsSexUnknown IsSexUnknown
GenderCodeNameText
GenderCodeName I_BusinessPartner GenderCodeName
Country1asInsurCustFullAddr Adresse
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
_BPGenderText _BPGenderText
_CurrentDefaultAddress _CurrentDefaultAddress 
@AccessControl.authorizationCheck : #CHECK
@ObjectModel.representativeKey    : 'BusinessPartner'
@EndUserText.label                : 'Geschäftspartner'
@VDM.viewType                     : #CONSUMPTION
@ObjectModel.usageType                : {
  serviceQuality                      : #C,
  sizeCategory                        : #XL,
  dataClass                           : #MASTER }

define view entity C_InsurPlcyBusPartner
  as select from I_BusinessPartner as _BusinessPartner
  association [0..*] to I_BPGenderValueHelpText as _BPGenderText on $projection.GenderCodeName = _BPGenderText.GenderCodeName

{
      @UI.facet           : [{
         purpose          : #QUICK_VIEW,
         type             : #FIELDGROUP_REFERENCE,
         targetQualifier  : 'BusinessPartnerQuickView' }]

  key BusinessPartner,
      BusinessPartnerCategory,
      AuthorizationGroup,
      IsBusinessPurposeCompleted,
      BusinessPartnerName,
      LastName,
      FirstName,

      //@EndUserText.label: 'Date of Birth'

      @UI.fieldGroup: [{position: 10 , qualifier: 'BusinessPartnerQuickView', importance: #HIGH }]
      @Semantics.contact.birthDate: true
      BirthDate,

      // @EndUserText.label: 'Phone Number'

      @Semantics.telephone : {type: [#CELL]}
      @UI.fieldGroup: [ { position: 40 , importance: #HIGH,qualifier: 'BusinessPartnerQuickView'} ]
      _CurrentDefaultAddress._Address._DefaultPhoneNumber.PhoneNumber                                                                                                                  as PhoneNumber,

      //@EndUserText.label: 'Email'

      @UI.fieldGroup: [{ position: 30 , importance: #HIGH,qualifier: 'BusinessPartnerQuickView'}]
      @Semantics.eMail.address: true
      @Semantics.eMail.type: [#PREF]
      _CurrentDefaultAddress._Address._DefaultEmailAddress.EmailAddress                                                                                                                as EmailAddress,

      IsFemale,

      IsMale,

      //@EndUserText.label: 'Gender'

      IsSexUnknown,
      @UI.fieldGroup: [{ position: 20 , importance: #HIGH,qualifier: 'BusinessPartnerQuickView'}]
      _BPGenderText[ Language = $session.system_language ].GenderCodeNameText                                                                                                          as GenderCodeNameText,

      _BusinessPartner.GenderCodeName                                                                                                                                                  as GenderCodeName,

      @EndUserText.label: 'Adresse' //Address

      @UI.fieldGroup: [{ position: 50 , importance: #HIGH,qualifier: 'BusinessPartnerQuickView'}]
      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 InsurCustFullAddr,
      
      //  Initials,

      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,
      DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController10,
      @Semantics.booleanIndicator: true
      
      // Associations

      _BPGenderText,
      _CurrentDefaultAddress
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_ADDRESSEMAILADDRESS",
"I_ADDRESSPHONENUMBER",
"I_BPCURRENTDEFAULTADDRESS",
"I_BPGENDERVALUEHELPTEXT",
"I_BUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_BPCURRENTDEFAULTADDRESS",
"I_BPGENDERVALUEHELPTEXT"
],
"BASE":
[
"I_BUSINESSPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More