C_BusPartContactPersonTP

DDL: C_BUSPARTCONTACTPERSONTP Type: view_entity CONSUMPTION Package: MDC_BUPA_REL_BO

Projection view for Contact Persons

C_BusPartContactPersonTP is a Consumption CDS View that provides data about "Projection view for Contact Persons" in SAP S/4HANA. It reads from 1 data source (I_BusPartRelationshipTP) and exposes 28 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory, BPRelshpCatIsInFwdDirection. It is exposed through 1 OData service (C_BUSINESSPARTNERTP_2_SRV). Part of development package MDC_BUPA_REL_BO.

Data Sources (1)

SourceAliasJoin Type
I_BusPartRelationshipTP I_BusPartRelationshipTP projection

Annotations (6)

NameValueLevelField
EndUserText.label Projection view for Contact Persons view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
Metadata.allowExtensions true view
Search.searchable true view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSINESSPARTNERTP_2_SRV C_BUSINESSPARTNERTP_2_SRV V2 C1 NOT_RELEASED

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 BusinessPartner1
KEY BusinessPartner2 BusinessPartner2
KEY ValidityEndDate ValidityEndDate
KEY RelationshipCategory RelationshipCategory
KEY BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection
BusinessPartner1ForEdit BusinessPartner1ForEdit
BusinessPartner2ForEdit BusinessPartner2ForEdit
RelationshipCategoryForEdit RelationshipCategoryForEdit
RelationshipNumber RelationshipNumber
ValidityStartDate ValidityStartDate
ValidityEndDateForEdit ValidityEndDateForEdit
IsStandardRelationship IsStandardRelationship
BPRelationshipType BPRelationshipType
BusPartRelshpIsRoleDefinition BusPartRelshpIsRoleDefinition
BusinessPartner1Name _BusinessPartner1 BusinessPartnerName
BusinessPartner2Name _BusinessPartner2 BusinessPartnerName
BusPartRelshpCatDescription _RelationshipCategoryText BusPartRelshpCatDescription
OrganizationBPName1 _BusinessPartner1 OrganizationBPName1
FirstName _BusinessPartner2 FirstName
LastName _BusinessPartner2 LastName
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
_BusinessPartner1 _BusinessPartner1
_BusinessPartner2 _BusinessPartner2
@EndUserText.label: 'Projection view for Contact Persons'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #A
@Metadata.allowExtensions: true
@Search.searchable: true
@VDM.viewType: #CONSUMPTION
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ] 
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define root view entity C_BusPartContactPersonTP
  provider contract transactional_query
  as projection on I_BusPartRelationshipTP
{
//  key BPDrftUUID,

//  key BPRelshpUUID,

      @ObjectModel.text.element: ['BusinessPartner1Name']
  key BusinessPartner1 as BusinessPartner1,
      @ObjectModel.text.element: ['BusinessPartner2Name']
  key BusinessPartner2 as BusinessPartner2,
  key ValidityEndDate,
      @ObjectModel.text.element: ['BusPartRelshpCatDescription']
  key RelationshipCategory,
  key BPRelshpCatIsInFwdDirection,
      @ObjectModel.text.element: ['BusinessPartner1Name']
      BusinessPartner1ForEdit,
      @ObjectModel.text.element: ['BusinessPartner2Name']
      BusinessPartner2ForEdit,
      @ObjectModel.text.element: ['BusPartRelshpCatDescription']
      RelationshipCategoryForEdit,
      RelationshipNumber,
      ValidityStartDate,
      ValidityEndDateForEdit,
      IsStandardRelationship,
      BPRelationshipType,
      BusPartRelshpIsRoleDefinition,
      //BPRelshpCatIsInFwdDirection,


      //Texts

      _BusinessPartner1.BusinessPartnerName as BusinessPartner1Name,
      _BusinessPartner2.BusinessPartnerName as BusinessPartner2Name,
      _RelationshipCategoryText.BusPartRelshpCatDescription,// : localized,

      _BusinessPartner1.OrganizationBPName1,
      _BusinessPartner2.FirstName,
      _BusinessPartner2.LastName,

      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangedByUser,
      LastChangeDate,
      LastChangeTime,

      _BusinessPartner1,
      _BusinessPartner2,
//      _BPDataControllerUsage1,

//      _BPDataControllerUsage2,

      

      _BusPartRelStdAddress      : redirected to C_BPContactPersonAddressTP,

      _BPRelshpContactPerson     : redirected to composition child C_BPContactPersonBasicTP,
      _BPRelshpCntctPersnAddress : redirected to composition child C_BPContactPersonAddressTP
}
where
  RelationshipCategory = 'BUR001'