I_BpContactToAddressStdVH

DDL: I_BPCONTACTTOADDRESSSTDVH SQL: IBCTA__VH Type: view COMPOSITE

Business Partner Contact To Address

I_BpContactToAddressStdVH is a Composite CDS View that provides data about "Business Partner Contact To Address" in SAP S/4HANA. It reads from 1 data source (I_BpContactToAddress) and exposes 8 fields with key fields RelationshipNumber, BusinessPartnerCompany, BusinessPartnerPerson, ValidityEndDate, AddressID.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_BpContactToAddress I_BpContactToAddress from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBCTA__VH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey RelationshipNumber view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Business Partner Contact To Address view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY RelationshipNumber RelationshipNumber
KEY BusinessPartnerCompany BusinessPartnerCompany
KEY BusinessPartnerPerson BusinessPartnerPerson
KEY ValidityEndDate ValidityEndDate
KEY AddressID AddressID
PersonNumber PersonNumber
_BusinessPartnerCompany _BusinessPartnerCompany
_BusinessPartnerPerson _BusinessPartnerPerson 
//GENERATED:005:29JlHNUf7kY2uRn2Qz29KW

@AbapCatalog.sqlViewName: 'IBCTA__VH'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #COMPOSITE

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'RelationshipNumber'

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@AccessControl.authorizationCheck: #CHECK
//<TODO> Please double-check personal data blocking

@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Business Partner Contact To Address'
define view I_BpContactToAddressStdVH as select from I_BpContactToAddress {
  key RelationshipNumber,
  @ObjectModel.foreignKey.association: '_BusinessPartnerCompany'
  key BusinessPartnerCompany,
  @ObjectModel.foreignKey.association: '_BusinessPartnerPerson'
  key BusinessPartnerPerson,
  key ValidityEndDate,
 // @ObjectModel.foreignKey.association: '_AddressDetails'

  key AddressID,
  PersonNumber,

  @Consumption.hidden: true
  _BusinessPartnerCompany,
  @Consumption.hidden: true
  _BusinessPartnerPerson
  //@Consumption.hidden: true

  //_AddressDetails,


}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCONTACTTOADDRESS"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER"
],
"BASE":
[
"I_BPCONTACTTOADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More