I_BusPartIdentificationTP_2

DDL: I_BUSPARTIDENTIFICATIONTP_2 SQL: IBUPAIDTP2 Type: view_entity TRANSACTIONAL

Transactional View for I_BuPaIdentification

I_BusPartIdentificationTP_2 is a Transactional CDS View that provides data about "Transactional View for I_BuPaIdentification" in SAP S/4HANA. It reads from 1 data source (I_BuPaIdentification) and exposes 31 fields with key fields BusinessPartner, BPIdentificationType, BPIdentificationNumber. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BuPaIdentification BusinessPartnerIdentification from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerTP_2 _BusinessPart $projection.BusinessPartner = _BusinessPart.BusinessPartner
[0..1] I_Country _Country $projection.Country = _Country.Country
[0..1] I_Region _Region $projection.Country = _Region.Country and $projection.Region = _Region.Region
[0..1] I_BusPartIdentificationType _BusPartIdType $projection.BPIdentificationType = _BusPartIdType.BPIdentificationType and $projection.businesspartnercategory = _BusPartIdType.BusinessPartnerCategory

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Transactional View for I_BuPaIdentification view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY BPIdentificationType BPIdentificationType
KEY BPIdentificationNumber BPIdentificationNumber
BPIdnNmbrIssuingInstitute BPIdnNmbrIssuingInstitute
BPIdentificationEntryDate BPIdentificationEntryDate
Country Country
Region Region
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
AuthorizationGroup AuthorizationGroup
BPIdnTypeForEditValue BPIdentificationType
BPIdnNumberForEditValue BPIdentificationNumber
BusinessPartnerCategory _BusinessPart BusinessPartnerCategory
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted
DataControllerSet _BusinessPartner DataControllerSet
DataController1 _BusinessPartner DataController1
DataController2 _BusinessPartner DataController2
DataController3 _BusinessPartner DataController3
DataController4 _BusinessPartner DataController4
DataController5 _BusinessPartner DataController5
DataController6 _BusinessPartner DataController6
DataController7 _BusinessPartner DataController7
DataController8 _BusinessPartner DataController8
DataController9 _BusinessPartner DataController9
DataController10 _BusinessPartner DataController10
_BusinessPartner _BusinessPartner
_BusinessPartnerCategory _BusinessPart _BusinessPartnerCategory
_BusPartIdType _BusPartIdType
_Region _Region
_Country _Country
_BuPaIdentificationType I_BuPaIdentification _BuPaIdentificationType
//@AbapCatalog.sqlViewName: 'IBUPAIDTP2'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
//@ClientHandling.algorithm : #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@EndUserText.label: 'Transactional View for I_BuPaIdentification'
define view entity I_BusPartIdentificationTP_2
  as select from I_BuPaIdentification as BusinessPartnerIdentification
  association        to parent I_BusinessPartnerTP_2 as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
//                                                                         and $projection.BPDrftUUID      = _BusinessPartner.BPDrftUUID

  association [0..1] to I_BusinessPartnerTP_2        as _BusinessPart    on  $projection.BusinessPartner = _BusinessPart.BusinessPartner
                                                                        // and $projection.BPDrftUUID      = _BusinessPart.BPDrftUUID

  association [0..1] to I_Country                    as _Country         on  $projection.Country = _Country.Country
  association [0..1] to I_Region                     as _Region          on  $projection.Country = _Region.Country
                                                                         and $projection.Region  = _Region.Region
  association [0..1] to I_BusPartIdentificationType  as _BusPartIdType   on  $projection.BPIdentificationType    = _BusPartIdType.BPIdentificationType
                                                                         and $projection.businesspartnercategory = _BusPartIdType.BusinessPartnerCategory

{
//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPIdentificationDrftUUID,

  key BusinessPartner,
  key BPIdentificationType,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key BPIdentificationNumber,
      BPIdnNmbrIssuingInstitute,
      BPIdentificationEntryDate,
      Country,
      Region,
      ValidityStartDate,
      ValidityEndDate,
      AuthorizationGroup,
      @ObjectModel.editableFieldFor: 'BPIdentificationType'
      BPIdentificationType                                               as BPIdnTypeForEditValue,
      @ObjectModel.editableFieldFor: 'BPIdentificationNumber'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      BPIdentificationNumber                                             as BPIdnNumberForEditValue,
      _BusinessPart.BusinessPartnerCategory,
      _BusinessPartner.IsBusinessPurposeCompleted,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataControllerSet              as DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController1                as DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController2                as DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController3                as DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController4                as DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController5                as DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController6                as DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController7                as DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController8                as DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController9                as DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController10               as DataController10,
      _BusinessPartner,
      _BusinessPart._BusinessPartnerCategory as _BusinessPartnerCategory,
      _BusPartIdType,
      _Region,
      _Country,
      
      BusinessPartnerIdentification._BuPaIdentificationType as _BuPaIdentificationType
 //     _BPDataControllerUsage

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUPAIDENTIFICATION",
"I_BUSINESSPARTNERTP_2"
],
"ASSOCIATED":
[
"I_BUPAIDENTIFICATIONTYPE",
"I_BUSINESSPARTNERTP_2",
"I_BUSPARTCATEGORY",
"I_BUSPARTIDENTIFICATIONTYPE",
"I_COUNTRY",
"I_REGION"
],
"BASE":
[
"I_BUPAIDENTIFICATION",
"I_BUSINESSPARTNERTP_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/