I_BusinessPartnerTaxNumberTP_2

DDL: I_BUSINESSPARTNERTAXNUMBERTP_2 SQL: IBUPATAXTP2 Type: view_entity TRANSACTIONAL

Business Partner Tax Number

I_BusinessPartnerTaxNumberTP_2 is a Transactional CDS View that provides data about "Business Partner Tax Number" in SAP S/4HANA. It reads from 1 data source (I_Businesspartnertaxnumber) and exposes 20 fields with key fields BusinessPartner, BPTaxType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_Businesspartnertaxnumber BusinessPartnerTaxNumber from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusPartTaxType _BusinessPartnerTaxType $projection.BPTaxType = _BusinessPartnerTaxType.BPTaxType

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Business Partner Tax Number view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_Businesspartnertaxnumber BusinessPartner
KEY BPTaxType I_Businesspartnertaxnumber BPTaxType
BPTaxTypeForEditValue I_Businesspartnertaxnumber BPTaxType
BPTaxNumber I_Businesspartnertaxnumber BPTaxNumber
BPTaxLongNumber I_Businesspartnertaxnumber BPTaxLongNumber
AuthorizationGroup _BusinessPartner AuthorizationGroup
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
_BusinessPartnerTaxType _BusinessPartnerTaxType
//@AbapCatalog.sqlViewName: 'IBUPATAXTP2'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Business Partner Tax Number'
//@ClientHandling.algorithm : #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL

define view entity I_BusinessPartnerTaxNumberTP_2
  as select from I_Businesspartnertaxnumber as BusinessPartnerTaxNumber
  association        to parent I_BusinessPartnerTP_2 as _BusinessPartner        on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
//                                                                                and $projection.BPDrftUUID = _BusinessPartner.BPDrftUUID

  association [0..1] to I_BusPartTaxType             as _BusinessPartnerTaxType on $projection.BPTaxType = _BusinessPartnerTaxType.BPTaxType
{ 
//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

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

  key BusinessPartnerTaxNumber.BusinessPartner as BusinessPartner,
      @ObjectModel.foreignKey.association: '_BusinessPartnerTaxType'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key BusinessPartnerTaxNumber.BPTaxType       as BPTaxType,
      case when BPTaxNumber is not initial
        then cast( BPTaxNumber as bptaxnumxl )
        else BPTaxLongNumber
      end                                      as BPTaxNumberForEditValue,
      @ObjectModel.editableFieldFor: 'BPTaxType'
      //@ObjectModel.foreignKey.association: '_BusinessPartnerTaxType'

      BusinessPartnerTaxNumber.BPTaxType as BPTaxTypeForEditValue,
      BusinessPartnerTaxNumber.BPTaxNumber,
      BusinessPartnerTaxNumber.BPTaxLongNumber,
      _BusinessPartner.AuthorizationGroup,
      _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,
      /* Associations */
      _BusinessPartner,
      _BusinessPartnerTaxType
//      _BPDataControllerUsage

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