C_BPCustomerTaxGrouping

DDL: C_BPCUSTOMERTAXGROUPING SQL: CBPCUSTTAXGRP Type: view CONSUMPTION

Consumption for Customer Tax Grouping

C_BPCustomerTaxGrouping is a Consumption CDS View that provides data about "Consumption for Customer Tax Grouping" in SAP S/4HANA. It reads from 1 data source (I_BPCustomerTaxGroupingTP) and exposes 15 fields with key fields BusinessPartner, Customer, CustomerTaxGroupingCode. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPCustomerTaxGroupingTP TaxGrpData from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] C_BPTaxCodeTextValueHelp _TaxCodeTextValueHelp $projection.CustomerTaxGroupingCodeForEdit = _TaxCodeTextValueHelp.TaxGroupingCode and _TaxCodeTextValueHelp.Language = $session.system_language and _TaxCodeTextValueHelp.AccountType = 'D'

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CBPCUSTTAXGRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Consumption for Customer Tax Grouping view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
UI.headerInfo.typeName Tax Data view
UI.headerInfo.typeNamePlural Tax Data view
UI.headerInfo.title.label Tax Code view
VDM.viewType #CONSUMPTION view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPCustomerTaxGroupingTP BusinessPartner
KEY Customer I_BPCustomerTaxGroupingTP Customer
KEY CustomerTaxGroupingCode I_BPCustomerTaxGroupingTP CustomerTaxGroupingCode
CustomerForEdit I_BPCustomerTaxGroupingTP CustomerForEdit
BusinessPartnerForEdit I_BPCustomerTaxGroupingTP BusinessPartnerForEdit
CustomerTaxGroupingCodeForEdit I_BPCustomerTaxGroupingTP CustomerTaxGroupingCodeForEdit
CustTaxGroupSubjectedStartDate I_BPCustomerTaxGroupingTP CustTaxGroupSubjectedStartDate
CustTaxGroupSubjectedEndDate I_BPCustomerTaxGroupingTP CustTaxGroupSubjectedEndDate
CustTaxGroupExemptionRate I_BPCustomerTaxGroupingTP CustTaxGroupExemptionRate
CustTaxGroupExemptionStartDate I_BPCustomerTaxGroupingTP CustTaxGroupExemptionStartDate
CustTaxGroupExemptionEndDate I_BPCustomerTaxGroupingTP CustTaxGroupExemptionEndDate
CustTaxGrpExemptionCertificate I_BPCustomerTaxGroupingTP CustTaxGrpExemptionCertificate
_BusinessPartner _BusinessPartner
_BusinessPartnerCustomer _BusinessPartnerCustomer
_TaxCodeTextValueHelp _TaxCodeTextValueHelp
@AbapCatalog.sqlViewName: 'CBPCUSTTAXGRP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:#CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Consumption for Customer Tax Grouping'
@Metadata.allowExtensions: true
//@ObjectModel.type: #CONSUMPTION


@ObjectModel: {
    semanticKey: [ 'BusinessPartner', 'Customer','CustomerTaxGroupingCodeForEdit' ],
    createEnabled,
    updateEnabled,
    deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true


@UI.headerInfo:{
  typeName: 'Tax Data',
  typeNamePlural: 'Tax Data',
  title:  { label: 'Tax Code', value:#('CustomerTaxGroupingCode') }
}

@VDM.viewType: #CONSUMPTION
define view C_BPCustomerTaxGrouping
  as select from I_BPCustomerTaxGroupingTP as TaxGrpData
  association [1..1] to C_BusinessPartnerCustomer as _BusinessPartnerCustomer on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
  association [1..1] to C_BusinessPartner         as _BusinessPartner         on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [0..1] to C_BPTaxCodeTextValueHelp  as _TaxCodeTextValueHelp    on  $projection.CustomerTaxGroupingCodeForEdit = _TaxCodeTextValueHelp.TaxGroupingCode
                                                                              and _TaxCodeTextValueHelp.Language     = $session.system_language
                                                                              and _TaxCodeTextValueHelp.AccountType = 'D'                    

{
      //TaxGrpData

  key TaxGrpData.BusinessPartner,
  key TaxGrpData.Customer,
  key TaxGrpData.CustomerTaxGroupingCode,
      TaxGrpData.CustomerForEdit,
      TaxGrpData.BusinessPartnerForEdit,
      @ObjectModel.text.association: '_TaxCodeTextValueHelp'
      //@Search: {fuzzinessThreshold: 0.8}

      TaxGrpData.CustomerTaxGroupingCodeForEdit,
      TaxGrpData.CustTaxGroupSubjectedStartDate,
      TaxGrpData.CustTaxGroupSubjectedEndDate,
      TaxGrpData.CustTaxGroupExemptionRate,
      TaxGrpData.CustTaxGroupExemptionStartDate,
      TaxGrpData.CustTaxGroupExemptionEndDate,
      TaxGrpData.CustTaxGrpExemptionCertificate,
      /* Associations */
      //TaxGrpData

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _BusinessPartner,
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _BusinessPartnerCustomer,
      _TaxCodeTextValueHelp
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCUSTOMERTAXGROUPINGTP"
],
"ASSOCIATED":
[
"C_BPTAXCODETEXTVALUEHELP",
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/