I_BPCustomerTaxGroupingTP

DDL: I_BPCUSTOMERTAXGROUPINGTP SQL: IBPCUSTTAXGRPTP Type: view TRANSACTIONAL

BO view for Customer Tax Grouping

I_BPCustomerTaxGroupingTP is a Transactional CDS View that provides data about "BO view for Customer Tax Grouping" in SAP S/4HANA. It reads from 2 data sources (I_CustomerToBusinessPartner, I_CustomerTaxGrouping) and exposes 13 fields with key fields BusinessPartner, Customer, CustomerTaxGroupingCode. It has 1 association to related views.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_CustomerToBusinessPartner I_CustomerToBusinessPartner inner
I_CustomerTaxGrouping TaxGrpdata from

Associations (1)

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

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBPCUSTTAXGRPTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label BO view for Customer Tax Grouping view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence BUPA_KNAT_D view
Search.searchable true view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner
KEY Customer I_CustomerTaxGrouping Customer
KEY CustomerTaxGroupingCode I_CustomerTaxGrouping CustomerTaxGroupingCode
CustomerForEdit I_CustomerTaxGrouping Customer
CustomerTaxGroupingCodeForEdit I_CustomerTaxGrouping CustomerTaxGroupingCode
BusinessPartnerForEdit
CustTaxGrpExemptionCertificate I_CustomerTaxGrouping CustTaxGrpExemptionCertificate
CustTaxGroupExemptionRate I_CustomerTaxGrouping CustTaxGroupExemptionRate
CustTaxGroupExemptionStartDate I_CustomerTaxGrouping CustTaxGroupExemptionStartDate
CustTaxGroupExemptionEndDate I_CustomerTaxGrouping CustTaxGroupExemptionEndDate
CustTaxGroupSubjectedStartDate I_CustomerTaxGrouping CustTaxGroupSubjectedStartDate
CustTaxGroupSubjectedEndDate I_CustomerTaxGrouping CustTaxGroupSubjectedEndDate
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'IBPCUSTTAXGRPTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BO view for Customer Tax Grouping'
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.draftEnabled:true
@ObjectModel.writeDraftPersistence: 'BUPA_KNAT_D'
@ObjectModel.createEnabled
@ObjectModel.deleteEnabled
@ObjectModel.updateEnabled
@Search.searchable: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
define view I_BPCustomerTaxGroupingTP
  as select from I_CustomerTaxGrouping as TaxGrpdata
    inner join   I_CustomerToBusinessPartner on TaxGrpdata.Customer = I_CustomerToBusinessPartner.Customer
  association [1..1] to I_BusinessPartnerTP as _BusinessPartner on $projection.businesspartner = _BusinessPartner.BusinessPartner
{
          //I_CustomerToBusinessPartner

  key     I_CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
          //TaxGrpdata

  key     TaxGrpdata.Customer,
          @Search.defaultSearchElement: true
  key     TaxGrpdata.CustomerTaxGroupingCode,
          TaxGrpdata.Customer                                          as CustomerForEdit,
          @Search.defaultSearchElement: true
          TaxGrpdata.CustomerTaxGroupingCode                               as CustomerTaxGroupingCodeForEdit,
          I_CustomerToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartnerForEdit,
          TaxGrpdata.CustTaxGrpExemptionCertificate,
          TaxGrpdata.CustTaxGroupExemptionRate,
          TaxGrpdata.CustTaxGroupExemptionStartDate,
          TaxGrpdata.CustTaxGroupExemptionEndDate,
          TaxGrpdata.CustTaxGroupSubjectedStartDate,
          TaxGrpdata.CustTaxGroupSubjectedEndDate,
          /* Associations */
          @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
          _BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTOMERTAXGROUPING",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More