I_CADisputeCaseContactVH

DDL: I_CADISPUTECASECONTACTVH SQL: ICADSPUTCNTCTVH Type: view COMPOSITE

Dispute Case Contact in Contract Account

I_CADisputeCaseContactVH is a Composite CDS View that provides data about "Dispute Case Contact in Contract Account" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerAddress_2) and exposes 9 fields with key fields BusinessPartner, AddressNumber. It has 2 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerAddress_2 I_BusinessPartnerAddress_2 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AddressDefaultRepresentation _AddressDefaultRepresentation $projection.AddressNumber = _AddressDefaultRepresentation.AddressID
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICADSPUTCNTCTVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Dispute Case Contact in Contract Account view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY AddressNumber AddressNumber
ContactPersonFullName _BusinessPartner BusinessPartnerName
ContactPersonEmailAddress
ContactPersonPhoneNumber
ContactPersonFaxNumber
ContactPersonFaxCountry
_AddressDefaultRepresentation _AddressDefaultRepresentation
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'ICADSPUTCNTCTVH'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Dispute Case Contact in Contract Account'

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C

@VDM.viewType: #COMPOSITE

define view I_CADisputeCaseContactVH
  as select from I_BusinessPartnerAddress_2

  association [1..1] to I_AddressDefaultRepresentation as _AddressDefaultRepresentation on $projection.AddressNumber = _AddressDefaultRepresentation.AddressID
  association [1..1] to I_BusinessPartner              as _BusinessPartner              on $projection.BusinessPartner = _BusinessPartner.BusinessPartner

{
  key BusinessPartner,
  key AddressNumber,

      _BusinessPartner.BusinessPartnerName                                                      as ContactPersonFullName,

      _AddressDefaultRepresentation._CurrentDfltEmailAddress.EmailAddress                       as ContactPersonEmailAddress,

      _AddressDefaultRepresentation._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber as ContactPersonPhoneNumber,

      _AddressDefaultRepresentation._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber           as ContactPersonFaxNumber,

      _AddressDefaultRepresentation._CurrentDfltFaxNumber.FaxNumberCountry                      as ContactPersonFaxCountry,

      /* associations */
      _AddressDefaultRepresentation,
      _BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRCURDEFAULTEMAILADDRESS",
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRCURDFLTLANDLINEPHONENMBR",
"I_ADDRESSDEFAULTREPRESENTATION",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERADDRESS_2"
],
"ASSOCIATED":
[
"I_ADDRESSDEFAULTREPRESENTATION",
"I_BUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More