A_BPContactToFuncAndDept

DDL: A_BPCONTACTTOFUNCANDDEPT SQL: ABUPACONTACTFUNC Type: view BASIC Package: ODATA_MASTER_DATA_BP

Function and Department

A_BPContactToFuncAndDept is a Basic CDS View that provides data about "Function and Department" in SAP S/4HANA. It reads from 1 data source (I_BPContactToFuncAndDept) and exposes 19 fields with key fields RelationshipNumber, BusinessPartnerCompany, BusinessPartnerPerson, ValidityEndDate. It has 2 associations to related views. Part of development package ODATA_MASTER_DATA_BP.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_BPContactToFuncAndDept I_BPContactToFuncAndDept from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_BusinessPartner _BusinessPartnerCompany _BusinessPartnerCompany.BusinessPartner = $projection.BusinessPartnerCompany
[1..1] A_BusinessPartner _BusinessPartnerPerson _BusinessPartnerPerson.BusinessPartner = $projection.BusinessPartnerPerson

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ABUPACONTACTFUNC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Function and Department view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.updateEnabled true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY RelationshipNumber RelationshipNumber
KEY BusinessPartnerCompany BusinessPartnerCompany
KEY BusinessPartnerPerson BusinessPartnerPerson
KEY ValidityEndDate ValidityEndDate
ContactPersonAuthorityType ContactPersonAuthorityType
ContactPersonDepartment ContactPersonDepartment
ContactPersonDepartmentName ContactPersonDepartmentName
ContactPersonFunction ContactPersonFunction
ContactPersonFunctionName ContactPersonFunctionName
ContactPersonRemarkText ContactPersonRemarkText
ContactPersonVIPType ContactPersonVIPType
EmailAddress EmailAddress
FaxNumber FaxNumber
FaxNumberExtension FaxNumberExtension
PhoneNumber PhoneNumber
PhoneNumberExtension PhoneNumberExtension
RelationshipCategory RelationshipCategory
_BusinessPartnerCompany _BusinessPartnerCompany
_BusinessPartnerPerson _BusinessPartnerPerson 
@AbapCatalog.sqlViewName: 'ABUPACONTACTFUNC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Function and Department'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL 
@ObjectModel.usageType.dataClass: #MASTER
//@ObjectModel.createEnabled:true

@ObjectModel.updateEnabled:true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
//@ObjectModel.deleteEnabled:true

@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view A_BPContactToFuncAndDept as select from I_BPContactToFuncAndDept 

  association [1..1] to A_BusinessPartner as _BusinessPartnerCompany on _BusinessPartnerCompany.BusinessPartner = $projection.BusinessPartnerCompany
  
  association [1..1] to A_BusinessPartner as _BusinessPartnerPerson on _BusinessPartnerPerson.BusinessPartner = $projection.BusinessPartnerPerson
   
{
  key RelationshipNumber,
  key BusinessPartnerCompany,
  key BusinessPartnerPerson,
  key ValidityEndDate,   
      ContactPersonAuthorityType,
      ContactPersonDepartment,
      ContactPersonDepartmentName,  
      ContactPersonFunction,  
      ContactPersonFunctionName,     
      ContactPersonRemarkText,
      ContactPersonVIPType,
      EmailAddress,
      FaxNumber,
      FaxNumberExtension,
      PhoneNumber,
      PhoneNumberExtension,     
      RelationshipCategory,
      _BusinessPartnerCompany,
      _BusinessPartnerPerson   
}

Learn More