I_BusPartAddrDepdntTaxNmbrTP

DDL: I_BUSPARTADDRDEPDNTTAXNMBRTP SQL: BPTAXNUMADDRTP Type: view TRANSACTIONAL Package: VDM_MD_BP

TP for Address dependent tax number

I_BusPartAddrDepdntTaxNmbrTP is a Transactional CDS View that provides data about "TP for Address dependent tax number" in SAP S/4HANA. It reads from 1 data source (I_BusPartAddrDepdntTaxNmbr) and exposes 10 fields with key fields BusinessPartner, BusinessPartnerAddressID, BPTaxType. It has 1 association to related views. Part of development package VDM_MD_BP.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_BusPartAddrDepdntTaxNmbr BPAddrDepdntTaxNumber from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName BPTAXNUMADDRTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP for Address dependent tax number view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence DEPDTXNMBR_D view
ObjectModel.draftEnabled true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusPartAddrDepdntTaxNmbr BusinessPartner
KEY BusinessPartnerAddressID I_BusPartAddrDepdntTaxNmbr BusinessPartnerAddressID
KEY BPTaxType I_BusPartAddrDepdntTaxNmbr BPTaxType
BPTaxNumberendasBPTaxLongNumber
AuthorizationGroup I_BusPartAddrDepdntTaxNmbr AuthorizationGroup
BusinessPartnerForEdit I_BusPartAddrDepdntTaxNmbr BusinessPartner
BPTaxTypeForEdit I_BusPartAddrDepdntTaxNmbr BPTaxType
AddressIDForEdit I_BusPartAddrDepdntTaxNmbr BusinessPartnerAddressID
FormattedAddress
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'BPTAXNUMADDRTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TP for Address dependent tax number'

@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL

@ObjectModel.writeDraftPersistence: 'DEPDTXNMBR_D'
@ObjectModel.semanticKey: ['BusinessPartner', 'BusinessPartnerAddressID', 'BPTaxType']
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled
@Search.searchable: true

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_BusPartAddrDepdntTaxNmbrTP
  as select from I_BusPartAddrDepdntTaxNmbr as BPAddrDepdntTaxNumber
  association [1..1] to I_BusinessPartnerTP as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
{
  key BPAddrDepdntTaxNumber.BusinessPartner,
  key BPAddrDepdntTaxNumber.BusinessPartnerAddressID,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key BPAddrDepdntTaxNumber.BPTaxType,
//       BPAddrDepdntTaxNumber.BPTaxNumber,

//       BPAddrDepdntTaxNumber.BPTaxLongNumber,


      case
            when BPAddrDepdntTaxNumber.BPTaxNumber is not initial
              then BPAddrDepdntTaxNumber.BPTaxNumber
            when BPAddrDepdntTaxNumber.BPTaxLongNumber is not initial
              then BPAddrDepdntTaxNumber.BPTaxLongNumber
            else BPAddrDepdntTaxNumber.BPTaxNumber
              end                                                                   as BPTaxLongNumber,

      BPAddrDepdntTaxNumber.AuthorizationGroup,
      @ObjectModel.foreignKey.association: null
      BPAddrDepdntTaxNumber.BusinessPartner                                         as BusinessPartnerForEdit,
      BPAddrDepdntTaxNumber.BPTaxType                                               as BPTaxTypeForEdit,
      BPAddrDepdntTaxNumber.BusinessPartnerAddressID                                as AddressIDForEdit,



      cast( '                                           ' as  abap.sstring( 260 ) ) as FormattedAddress,

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

Learn More