I_BusinessPartnerTaxNumberTP

DDL: I_BUSINESSPARTNERTAXNUMBERTP SQL: IBUPATAXNUMBERTP Type: view TRANSACTIONAL

Partner Tax Number BO View

I_BusinessPartnerTaxNumberTP is a Transactional CDS View that provides data about "Partner Tax Number BO View" in SAP S/4HANA. It reads from 1 data source (I_Businesspartnertaxnumber) and exposes 6 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
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBUPATAXNUMBERTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Partner Tax Number BO View view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence BUPA_TAX_NUM_D view
ObjectModel.draftEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_Businesspartnertaxnumber BusinessPartner
KEY BPTaxType I_Businesspartnertaxnumber BPTaxType
BusinessPartnerForEdit I_Businesspartnertaxnumber BusinessPartner
BPTaxNumberendasBPTaxNumber
BPTaxTypeForEdit I_Businesspartnertaxnumber BPTaxType
_BusinessPartner _BusinessPartner
@AbapCatalog.sqlViewName: 'IBUPATAXNUMBERTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Partner Tax Number BO View'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeEnabled: true

@ObjectModel.writeDraftPersistence: 'BUPA_TAX_NUM_D'
@ObjectModel.draftEnabled:true

@ObjectModel.semanticKey: [ 'BusinessPartner', 'BPTaxtype' ]
@ObjectModel.createEnabled
@ObjectModel.updateEnabled: 'EXTERNAL_CALCULATION'
@ObjectModel.deleteEnabled: 'EXTERNAL_CALCULATION'
@Search.searchable: true


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

define view I_BusinessPartnerTaxNumberTP
  as select from I_Businesspartnertaxnumber as BusinessPartnerTaxNumber



  association [1..1] to I_BusinessPartnerTP as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  //  association [0..1] to I_DraftAdministrativeData    as _DraftAdministrativeData on  _DraftAdministrativeData.DraftUUID = $projection.DraftAdministrativeDataUUID

  //

  //  association [0..1] to i_businesspartnertaxnumbertp as _SiblingEntity           on  $projection.IsActiveEntity  <> _SiblingEntity.IsActiveEntity

  //                                                                                 and $projection.BusinessPartner =  _SiblingEntity.BusinessPartner

  //                                                                                 and $projection.BPTaxType       =  _SiblingEntity.BPTaxType


{
      //@Consumption.hidden: true

      //  key BusinessPartnerTaxNumber.DraftUUID                                   as DraftUUID,

      //@Consumption.hidden: true

  key BusinessPartnerTaxNumber.BusinessPartner                             as BusinessPartner,
      //@Consumption.hidden: true

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key BusinessPartnerTaxNumber.BPTaxType                                   as BPTaxType,
      //      BusinessPartnerTaxNumber.ParentDraftUUID,

      BusinessPartnerTaxNumber.BusinessPartner                             as BusinessPartnerForEdit,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      case
      when BusinessPartnerTaxNumber.BPTaxNumber is not initial
        then BusinessPartnerTaxNumber.BPTaxNumber
      when BusinessPartnerTaxNumber.BPTaxLongNumber is not initial
        then BusinessPartnerTaxNumber.BPTaxLongNumber
      else BusinessPartnerTaxNumber.BPTaxNumber
        end                                                                as BPTaxNumber,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerTaxNumber.BPTaxType                                   as BPTaxTypeForEdit,

      //      BusinessPartnerTaxNumber.IsActiveEntity,

      //      BusinessPartnerTaxNumber.HasActiveEntity,

      //      BusinessPartnerTaxNumber.HasDraftEntity,

      //

      //

      //

      //      BusinessPartnerTaxNumber.DraftAdministrativeDataUUID,



      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT ]
      _BusinessPartner
      //      _DraftAdministrativeData,

      //      _SiblingEntity

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