Which CDS Views use I_BUSINESSPARTNERCONTACTTP?

I_BUSINESSPARTNERCONTACTTP is used by 1 CDS view(s), including: C_BusinessPartnerContact.

How many fields does I_BUSINESSPARTNERCONTACTTP have?

I_BUSINESSPARTNERCONTACTTP has 34 fields. Key fields: BusinessPartner, BusinessPartnerPerson, RelationshipNumber, ValidityEndDate.

I_BUSINESSPARTNERCONTACTTP

CDS View

Business Partner Contact BO View

I_BUSINESSPARTNERCONTACTTP is a CDS View in S/4HANA. Business Partner Contact BO View. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

View	Type	Join	VDM	Description
C_BusinessPartnerContact	view	from	CONSUMPTION	Consumption BusinessPartner Contact

Fields (34)

Key	Field	CDS Fields	Used in Views
KEY	BusinessPartner	BusinessPartner	1
KEY	BusinessPartnerPerson	BusinessPartnerPerson	1
KEY	RelationshipNumber	RelationshipNumber	1
KEY	ValidityEndDate	ValidityEndDate	1
	BirthDate	BirthDate	1
	Building	Building	1
	BusinessPartnerCategory	BusinessPartnerCategory	1
	BusinessPartnerForEdit	BusinessPartnerForEdit	1
	BusinessPartnerPersonForEdit	BusinessPartnerPersonForEdit	1
	ContactPersonAuthorityType	ContactPersonAuthorityType	1
	ContactPersonDepartment	ContactPersonDepartment	1
	ContactPersonFunction	ContactPersonFunction	1
	ContactPersonRemarkText	ContactPersonRemarkText	1
	ContactPersonVIPType	ContactPersonVIPType	1
	CorrespondenceLanguage	CorrespondenceLanguage	1
	EmailAddress	EmailAddress	1
	FaxCountry	FaxCountry	1
	FaxNumber	FaxNumber	1
	FaxNumberExtension	FaxNumberExtension	1
	FirstName	FirstName	1
	Floor	Floor	1
	FormOfAddress	FormOfAddress	1
	FullName	FullName	1
	LastName	LastName	1
	MobilePhoneCountry	MobilePhoneCountry	1
	MobilePhoneNumber	MobilePhoneNumber	1
	PersonUUID	PersonUUID	1
	PhoneNumber	PhoneNumber	1
	PhoneNumberCountry	PhoneNumberCountry	1
	PhoneNumberExtension	PhoneNumberExtension	1
	RelationshipNumberForEdit	RelationshipNumberForEdit	1
	RoomNumber	RoomNumber	1
	ValidityEndDateForEdit	ValidityEndDateForEdit	1
	ValidityStartDate	ValidityStartDate	1

@AbapCatalog.sqlViewName: 'IBUPACONTCTTP'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeEnabled: true
@ObjectModel.createEnabled
@ObjectModel.deleteEnabled
@ObjectModel.updateEnabled
@Search.searchable: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Business Partner Contact BO View'

@ObjectModel.writeDraftPersistence: 'BUPA_CONTACT_D'
@ObjectModel.draftEnabled:true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
//@Metadata.ignorePropagatedAnnotations: true


define view I_BusinessPartnerContactTP

  as select from I_BPContact as BusinessPartnerContact

  //  association [0..1] to E_Bpcontactd               as _DraftExtension          on  $projection.DraftUUID = _DraftExtension.DraftUUID


  association [0..1] to E_BPCONTACT_D        as _ActiveExtension  on  $projection.BusinessPartnerPerson = _ActiveExtension.ContactPerson


  association [1..1] to I_BusinessPartnerTP        as _BusinessPartner         on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  
  association [0..*] to I_BPContactAddressTP as _BPContactAddress on $projection.BusinessPartner = _BPContactAddress.BusinessPartner1
                                                                  and $projection.BusinessPartnerPerson = _BPContactAddress.BusinessPartner2
                                                                  and $projection.RelationshipNumber = _BPContactAddress.RelationshipNumber
                                                                  and $projection.ValidityEndDate = _BPContactAddress.ValidityEndDate
//  association [0..1] to I_DraftAdministrativeData  as _DraftAdministrativeData on  _DraftAdministrativeData.DraftUUID = $projection.DraftAdministrativeDataUUID

//

//  association [0..1] to i_businesspartnercontacttp as _SiblingEntity           on  $projection.IsActiveEntity        <> _SiblingEntity.IsActiveEntity

//                                                                               and $projection.BusinessPartner       =  _SiblingEntity.BusinessPartner

//                                                                               and $projection.BusinessPartnerPerson =  _SiblingEntity.BusinessPartnerPerson

//                                                                               and $projection.RelationshipNumber    =  _SiblingEntity.RelationshipNumber




{
//      @semanticKey: true

//  key BusinessPartnerContact.DraftUUID,

      @semanticKey: true
  key BusinessPartnerContact.BusinessPartnerCompany                                       as BusinessPartner,
      @semanticKey: true
  key BusinessPartnerContact.BusinessPartnerPerson,
      @semanticKey: true
  key BusinessPartnerContact.RelationshipNumber,
      @semanticKey: true
      //@ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

  key BusinessPartnerContact.ValidityEndDate,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerContact.BusinessPartnerPerson                                          as BusinessPartnerPersonForEdit,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerContact.RelationshipNumber                                             as RelationshipNumberForEdit,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerContact.ValidityEndDate                                                as ValidityEndDateForEdit, // Internal Incident: 2280164720


      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      BusinessPartnerContact.BusinessPartnerCompany                                         as BusinessPartnerForEdit,

//      BusinessPartnerContact.RelationshipCategory, //

//

//      'X'                                                                                   as BPRelshpCatIsInFwdDirection, //


      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerContact.ValidityStartDate,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _BusinessPartnerPerson.BusinessPartnerUUID                                            as PersonUUID,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _BusinessPartnerPerson.FormOfAddress,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _BusinessPartnerPerson.FirstName,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _BusinessPartnerPerson.LastName,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _BusinessPartnerPerson.BirthDate,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _BusinessPartnerPerson.CorrespondenceLanguage,

      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @VDM.lifecycle.status: 'DEPRECATED'
      @VDM.lifecycle.successor: 'BPContactPersonFunction'
      _ContactRelationship.ContactPersonFunction,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _ContactRelationship.BPContactPersonFunction,
      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _ContactRelationship.ContactPersonDepartment,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast('' as ad_bldng_p )                                                               as Building,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast('' as ad_floor )                                                                 as Floor,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast('' as ad_roomnum )                                                               as RoomNumber,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast('' as ad_comctry )                                                               as PhoneNumberCountry,

      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _ContactRelationship.PhoneNumber                                                      as PhoneNumber,

      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _ContactRelationship.PhoneNumberExtension                                             as PhoneNumberExtension,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      cast('' as ad_comctry )                                                               as MobilePhoneCountry,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

      cast('' as ad_tlnmbr )                                                                as MobilePhoneNumber,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast('' as ad_tlxtns )                                                                as MobilePhoneNumberExtension,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast('' as ad_comctry )                                                               as FaxCountry,

      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _ContactRelationship.FaxNumber                                                        as FaxNumber,

      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _ContactRelationship.FaxNumberExtension                                               as FaxNumberExtension,

      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      _ContactRelationship.EmailAddress                                                     as EmailAddress,
      _ContactRelationship.ContactPersonVIPType,
      _ContactRelationship.ContactPersonAuthorityType,
      _ContactRelationship.ContactPersonRemarkText,

      concat_with_space(_BusinessPartnerPerson.FirstName,_BusinessPartnerPerson.LastName,1) as FullName, //to display in the header


      //      BusinessPartnerContact.ParentDraftUUID,


      //      BusinessPartnerContact.IsActiveEntity,

      //      BusinessPartnerContact.HasActiveEntity,

      //      BusinessPartnerContact.HasDraftEntity,


      _BusinessPartner.BusinessPartnerCategory,


      //new

      //      BusinessPartnerContact.DraftAdministrativeDataUUID,



      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT]
      _BusinessPartner,
      _ContactRelationship._ContactPersonFunction,
      _ContactRelationship._CntctPersnFuncValueHelp,
      _ContactRelationship._ContactPersonFunctionText,
      _ContactRelationship._CntctPersnDeptValueHelp,
      _ContactRelationship._ContactPersonDepartmentText,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPContactAddress,
      /* Associations */
      _BusinessPartnerCompany,
      _BusinessPartnerPerson

      //      _DraftAdministrativeData,

      //      _SiblingEntity


}

//union all select from I_BPContact as BusinessPartnerContact

//

////  association [0..1] to E_Bpcontactd               as _DraftExtension          on  $projection.DraftUUID = _DraftExtension.DraftUUID

//

//association [0..1] to E_BPCONTACT_D        as _ActiveExtension  on  $projection.BusinessPartner = _ActiveExtension.ContactPerson

//

//

//association [1..1] to I_BusinessPartnerTP  as _BusinessPartner  on  $projection.BusinessPartnerPerson = _BusinessPartner.BusinessPartner

//

//

//association [0..*] to I_BPContactAddressTP as _BPContactAddress on  $projection.BusinessPartnerPerson = _BPContactAddress.BusinessPartner1

//                                                                and $projection.BusinessPartnerCompany   = _BPContactAddress.BusinessPartner2

//                                                                and $projection.RelationshipNumber    = _BPContactAddress.RelationshipNumber

//                                                                and $projection.ValidityEndDate       = _BPContactAddress.ValidityEndDate

//

////  association [0..1] to I_DraftAdministrativeData  as _DraftAdministrativeData on  _DraftAdministrativeData.DraftUUID = $projection.DraftAdministrativeDataUUID

////

////  association [0..1] to i_businesspartnercontacttp as _SiblingEntity           on  $projection.IsActiveEntity        <> _SiblingEntity.IsActiveEntity

////                                                                               and $projection.BusinessPartner       =  _SiblingEntity.BusinessPartner

////                                                                               and $projection.BusinessPartnerPerson =  _SiblingEntity.BusinessPartnerPerson

////                                                                               and $projection.RelationshipNumber    =  _SiblingEntity.RelationshipNumber

//

//

//

//{

//      //      @semanticKey: true

//      //  key BusinessPartnerContact.DraftUUID,

//      @semanticKey: true

//  key BusinessPartnerContact.BusinessPartnerCompany                                         as BusinessPartnerPerson,

//      @semanticKey: true

//  key BusinessPartnerContact.BusinessPartnerPerson                                          as BusinessPartnerCompany,

//      @semanticKey: true

//  key BusinessPartnerContact.RelationshipNumber,

//      @semanticKey: true

//      //@ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//  key BusinessPartnerContact.ValidityEndDate,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      BusinessPartnerContact.BusinessPartnerPerson                                          as BusinessPartnerCompanyForEdit,

//

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      BusinessPartnerContact.RelationshipNumber                                             as RelationshipNumberForEdit,

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      BusinessPartnerContact.ValidityEndDate                                                as ValidityEndDateForEdit, // Internal Incident: 2280164720

//

//      @Search.defaultSearchElement: true

//      @Search.fuzzinessThreshold: 0.8

//      @Search.ranking: #HIGH

//      //  BusinessPartnerContact.BusinessPartnerCompany as BusinessPartnerForEdit,

//      BusinessPartnerContact.BusinessPartnerCompany                                         as BusinessPartnerPersonForEdit,

//

//      BusinessPartnerContact.RelationshipCategory, //

//

//      cast(' ' as abap_boolean)                                                             as BPRelshpCatIsInFwdDirection, //

//

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      BusinessPartnerContact.ValidityStartDate,

//

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _BusinessPartnerPerson.BusinessPartnerUUID                                            as PersonUUID,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _BusinessPartnerPerson.FormOfAddress,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _BusinessPartnerPerson.FirstName,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _BusinessPartnerPerson.LastName,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _BusinessPartnerPerson.BirthDate,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _BusinessPartnerPerson.CorrespondenceLanguage,

//

//      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _ContactRelationship.ContactPersonFunction,

//

//      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _ContactRelationship.ContactPersonDepartment,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      cast('' as ad_bldng_p )                                                               as Building,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      cast('' as ad_floor )                                                                 as Floor,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      cast('' as ad_roomnum )                                                               as RoomNumber,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      cast('' as ad_comctry )                                                               as PhoneNumberCountry,

//

//      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _ContactRelationship.PhoneNumber                                                      as PhoneNumber,

//

//      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _ContactRelationship.PhoneNumberExtension                                             as PhoneNumberExtension,

//

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      cast('' as ad_comctry )                                                               as MobilePhoneCountry,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//

//      cast('' as ad_tlnmbr )                                                                as MobilePhoneNumber,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      cast('' as ad_tlxtns )                                                                as MobilePhoneNumberExtension,

//

//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      cast('' as ad_comctry )                                                               as FaxCountry,

//

//      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _ContactRelationship.FaxNumber                                                        as FaxNumber,

//

//      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _ContactRelationship.FaxNumberExtension                                               as FaxNumberExtension,

//

//      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

//      _ContactRelationship.EmailAddress                                                     as EmailAddress,

//      _ContactRelationship.ContactPersonVIPType,

//      _ContactRelationship.ContactPersonAuthorityType,

//      _ContactRelationship.ContactPersonRemarkText,

//

//      concat_with_space(_BusinessPartnerPerson.FirstName,_BusinessPartnerPerson.LastName,1) as FullName, //to display in the header

//

//      //      BusinessPartnerContact.ParentDraftUUID,

//

//      //      BusinessPartnerContact.IsActiveEntity,

//      //      BusinessPartnerContact.HasActiveEntity,

//      //      BusinessPartnerContact.HasDraftEntity,

//

//      _BusinessPartner.BusinessPartnerCategory,

//

//

//      //new

//      //      BusinessPartnerContact.DraftAdministrativeDataUUID,

//

//

//      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT]

//      _BusinessPartner,

//      _ContactRelationship._ContactPersonFunction,

//      _ContactRelationship._CntctPersnFuncValueHelp,

//      _ContactRelationship._ContactPersonFunctionText,

//      _ContactRelationship._CntctPersnDeptValueHelp,

//      _ContactRelationship._ContactPersonDepartmentText,

//      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]

//      _BPContactAddress,

//      /* Associations */

//      _BusinessPartnerCompany,

//      _BusinessPartnerPerson

//

//      //      _DraftAdministrativeData,

//      //      _SiblingEntity


//}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCONTACT",
"I_BPCONTACTTOFUNCANDDEPT",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERTP"
],
"ASSOCIATED":
[
"E_BPCONTACT_D",
"I_BPCONTACTADDRESSTP",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERTP",
"I_CONTACTPERSONDEPARTMENT",
"I_CONTACTPERSONDEPARTMENTT",
"I_CONTACTPERSONFUNCTION",
"I_CONTACTPERSONFUNCTIONT"
],
"BASE":
[
"I_BPCONTACT",
"I_BPCONTACTTOFUNCANDDEPT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_BUSINESSPARTNERCONTACTTP

CDS Views using this table (1)

Fields (34)

Learn More