C_BusPartAddrDepdntTaxNmbr

DDL: C_BUSPARTADDRDEPDNTTAXNMBR SQL: CBPADTAXNMBR Type: view CONSUMPTION

Consumption for Address Depdnt Tax Nmbr

C_BusPartAddrDepdntTaxNmbr is a Consumption CDS View that provides data about "Consumption for Address Depdnt Tax Nmbr" in SAP S/4HANA. It reads from 1 data source (I_BusPartAddrDepdntTaxNmbrTP) and exposes 14 fields with key fields BusinessPartner, BusinessPartnerAddressID, BPTaxType. It has 4 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_BusPartAddrDepdntTaxNmbrTP BPAddrDepdntTaxNumber from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartnerSupplier _BusinessPartnerSupplier $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner
[0..1] I_BusPartAddrDepdntTaxTypeVH _TaxType $projection.BPTaxTypeForEdit = _TaxType.BPTaxType

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CBPADTAXNMBR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption for Address Depdnt Tax Nmbr view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
UI.headerInfo.typeName Address-Dependent Tax Numbers view
UI.headerInfo.typeNamePlural Address-Dependent Tax Numbers view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusPartAddrDepdntTaxNmbrTP BusinessPartner
KEY BusinessPartnerAddressID I_BusPartAddrDepdntTaxNmbrTP BusinessPartnerAddressID
KEY BPTaxType I_BusPartAddrDepdntTaxNmbrTP BPTaxType
BPTaxLongNumber I_BusPartAddrDepdntTaxNmbrTP BPTaxLongNumber
AuthorizationGroup I_BusPartAddrDepdntTaxNmbrTP AuthorizationGroup
BusinessPartnerForEdit I_BusPartAddrDepdntTaxNmbrTP BusinessPartnerForEdit
BPTaxTypeForEdit I_BusPartAddrDepdntTaxNmbrTP BPTaxTypeForEdit
BPTaxTypeName _TaxType BPTaxTypeName
AddressIDForEdit I_BusPartAddrDepdntTaxNmbrTP AddressIDForEdit
FormattedAddress I_BusPartAddrDepdntTaxNmbrTP FormattedAddress
_BusinessPartner _BusinessPartner
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartnerSupplier _BusinessPartnerSupplier
_TaxType _TaxType 
@AbapCatalog.sqlViewName: 'CBPADTAXNMBR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumption for Address Depdnt Tax Nmbr'

@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    semanticKey: ['BusinessPartner', 'AddressIDForEdit', 'BPTaxTypeForEdit'],
    createEnabled,
    updateEnabled,
    deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@UI.headerInfo:{
  typeName: 'Address-Dependent Tax Numbers',
  typeNamePlural: 'Address-Dependent Tax Numbers' }

@Search.searchable: true
@VDM.viewType: #CONSUMPTION
define view C_BusPartAddrDepdntTaxNmbr
  as select from I_BusPartAddrDepdntTaxNmbrTP as BPAddrDepdntTaxNumber
  association [1..1] to C_BusinessPartner            as _BusinessPartner         on $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  association [1..1] to C_BusinessPartnerCustomer    as _BusinessPartnerCustomer on $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner

  association [1..1] to C_BusinessPartnerSupplier    as _BusinessPartnerSupplier on $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner
  
  association [0..1] to I_BusPartAddrDepdntTaxTypeVH as _TaxType                 on $projection.BPTaxTypeForEdit = _TaxType.BPTaxType

{
  key BPAddrDepdntTaxNumber.BusinessPartner,
  key BPAddrDepdntTaxNumber.BusinessPartnerAddressID,
  key BPAddrDepdntTaxNumber.BPTaxType,
      BPAddrDepdntTaxNumber.BPTaxLongNumber,
      BPAddrDepdntTaxNumber.AuthorizationGroup,
      BPAddrDepdntTaxNumber.BusinessPartnerForEdit,
      //@ObjectModel.text.association: '_TaxCategoryText'

      BPAddrDepdntTaxNumber.BPTaxTypeForEdit,
      @ObjectModel.readOnly: true
      _TaxType.BPTaxTypeName,
      BPAddrDepdntTaxNumber.AddressIDForEdit,
      BPAddrDepdntTaxNumber.FormattedAddress,

      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartner,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerSupplier,
      _TaxType
      // tax type description

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSPARTADDRDEPDNTTAXNMBRTP",
"I_BUSPARTADDRDEPDNTTAXTYPEVH"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTOMER",
"C_BUSINESSPARTNERSUPPLIER",
"I_BUSPARTADDRDEPDNTTAXTYPEVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More