C_ProjBillgUserContactCard

DDL: C_PROJBILLGUSERCONTACTCARD Type: view_entity CONSUMPTION Package: ODATA_PROJBILLINGELEMENT_LIST

Project Billing User Contact Card

C_ProjBillgUserContactCard is a Consumption CDS View that provides data about "Project Billing User Contact Card" in SAP S/4HANA. It reads from 1 data source (I_WorkforcePerson) and exposes 26 fields with key field BusinessPartner. It is exposed through 2 OData services (PROJECTBILLINGREQUEST_SD, UI_PROJECTBILLINGREQUEST). Part of development package ODATA_PROJBILLINGELEMENT_LIST.

1 data source(s) Exposed by 2 service(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkforcePerson WorkforcePerson from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Project Billing User Contact Card view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Search.searchable true view
VDM.viewType #CONSUMPTION view
VDM.private false view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
PROJECTBILLINGREQUEST_SD UI_PROJBILLGREQUEST_SB_V2 V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_PROJECTBILLINGREQUEST UI_PROJECTBILLINGREQUEST V4 C1 NOT_RELEASED

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_WorkforcePerson Person
BusinessPartnerUUID I_WorkforcePerson BusinessPartnerUUID
FirstName I_WorkforcePerson FirstName
LastName I_WorkforcePerson LastName
FullName I_WorkforcePerson PersonFullName
UserDescription
AuthorizationGroup I_WorkforcePerson AuthorizationGroup
IsBusinessPurposeCompleted I_WorkforcePerson IsBusinessPurposeCompleted
AddressID
PhoneNumber
MobilePhoneNumber
InternationalFaxNumber
EmailAddress
Department
FunctionalTitleName
DataController1 I_WorkforcePerson DataController1
DataController2 I_WorkforcePerson DataController2
DataController3 I_WorkforcePerson DataController3
DataController4 I_WorkforcePerson DataController4
DataController5 I_WorkforcePerson DataController5
DataController6 I_WorkforcePerson DataController6
DataController7 I_WorkforcePerson DataController7
DataController8 I_WorkforcePerson DataController8
DataController9 I_WorkforcePerson DataController9
DataController10 I_WorkforcePerson DataController10
DataControllerSet I_WorkforcePerson DataControllerSet 
@AccessControl: {
    authorizationCheck: #PRIVILEGED_ONLY,
    personalData.blocking: #REQUIRED
}

@EndUserText.label: 'Project Billing User Contact Card'

@ObjectModel.usageType: {
    dataClass: #MIXED,
    serviceQuality: #C,
    sizeCategory: #XL
}
@Search.searchable: true
@VDM: {
    viewType: #CONSUMPTION,
    private: false
}
@Metadata.allowExtensions: true
@Consumption.dbHints: [ 'NO_USE_HEX_PLAN' ]

define view entity C_ProjBillgUserContactCard
  as select from I_WorkforcePerson as WorkforcePerson
{
      @ObjectModel.text.element : [ 'UserDescription' ]
      @Semantics.contact.type: #PERSON
  key WorkforcePerson.Person                                                                                            as BusinessPartner,
      WorkforcePerson.BusinessPartnerUUID                                                                               as BusinessPartnerUUID,

      @Semantics.name.givenName: true
      WorkforcePerson.FirstName                                                                                         as FirstName,

      @Semantics.name.familyName: true
      WorkforcePerson.LastName                                                                                          as LastName,

      @Semantics.name.fullName: true
      WorkforcePerson.PersonFullName                                                                                    as FullName,

      @Semantics.text: true
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      cast( WorkforcePerson.PersonFullName as vdm_userdescription preserving type )                                     as UserDescription,

      @UI.hidden: true
      WorkforcePerson.AuthorizationGroup,

      @Consumption.hidden: true
      @UI.hidden: true
      WorkforcePerson.IsBusinessPurposeCompleted,

      WorkforcePerson._WorkplaceAddress.AddressID                                                                       as AddressID,

      @Semantics.telephone.type:  [ #WORK ]
      cast(WorkforcePerson._WorkplaceAddress.NormalizedPhoneNumber as contactcardphonenumber preserving type )          as PhoneNumber,

      @Semantics.telephone.type:  [ #CELL ]
      cast(WorkforcePerson._WorkplaceAddress.MblNormalizedPhoneNumber as contactcardmobilephonenumber preserving type ) as MobilePhoneNumber,

      @Semantics.telephone.type:  [ #FAX ]
      cast(WorkforcePerson._WorkplaceAddress.InternationalFaxNumber as contactcardfaxnumber preserving type )           as InternationalFaxNumber,

      @Semantics.eMail.type:  [ #WORK ]
      @Semantics.eMail.address: true
      cast(WorkforcePerson._WorkplaceAddress.DefaultEmailAddress as contactcardemailaddress preserving type )           as EmailAddress,

      @Semantics.organization.name: true
      WorkforcePerson._WorkplaceAddress.Department                                                                      as Department,

      @Semantics.organization.role: true
      WorkforcePerson._WorkplaceAddress.FunctionalTitlename                                                             as FunctionalTitleName,


      //Adding 10 fields for DCP 10+1 development

      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataController1,
      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataController2,
      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataController3,
      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataController4,
      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataController5,
      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataController6,
      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataController7,
      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataController8,
      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataController9,
      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataController10,
      @UI.hidden: true
      @Consumption.hidden: true
      WorkforcePerson.DataControllerSet
      // End of Datacontroller 10+1 fields

}

Learn More