I_BusPartAddrDepdntTaxNmbrTP

DDL: I_BUSPARTADDRDEPDNTTAXNMBRTP SQL: BPTAXNUMADDRTP Type: view TRANSACTIONAL

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.

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
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,

      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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSPARTADDRDEPDNTTAXNMBR"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More