I_BusPartCustSelectedTaxType

DDL: I_BUSPARTCUSTSELECTEDTAXTYPE SQL: IBPCUSTTAXTYPE Type: view BASIC Package: MDC_BUPA_BO

Business Partner Tax Number Categories

I_BusPartCustSelectedTaxType (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

BusinessPartnerTaxType · Database & Data Management

I_BusPartCustSelectedTaxType is a Basic CDS View that provides data about "Business Partner Tax Number Categories" in SAP S/4HANA. It reads from 1 data source (tfktaxnumtype_c) and exposes 2 fields with key field BPTaxType. It has 1 association to related views. Part of development package MDC_BUPA_BO.

SAP Help Documentation

CategoryCDS Views for Business Partner
Purpose
This CDS view is designed to retrieve and display information related to business partner tax types, specifically focusing on tax types associated with customers. It provides a structured way to access and present tax type data along with its descriptive text. This CDS view provides the data to answer the following business questions: What are the different tax types associated with business partners in the customer context? For example, India: GSTIN , Italy: VAT Registration Number , Greece: Personal ID . How can I access the descriptive text for each business partner tax type?

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description BPTaxType Tax category

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessDatabase & Data Management
Application ComponentAP-MD-BP-RAP
CapabilitiesAssociation Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageDatabase and Data Management for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view is designed to retrieve and display information related to business partner tax types, specifically focusing on tax types associated with customers. It provides a structured way to access and present tax type data along with its descriptive text.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the different tax types associated with business partners in the customer context? For example, India: GSTIN, Italy: VAT Registration Number, Greece: Personal ID.</p></li> <li><p>How can I access the descriptive text for each business partner tax type?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tfktaxnumtype_c tfktaxnumtype_c from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BusPartTaxTypeText _Text $projection.BPTaxType = _Text.BPTaxType

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBPCUSTTAXTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label Business Partner Tax Number Categories view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.representativeKey BPTaxType view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name BusinessPartnerTaxType view
Metadata.ignorePropagatedAnnotations true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY BPTaxType taxtype Tax Number Category
_Text _Text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BusPartCustSelectedTaxType.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IBPCUSTTAXTYPE

CREATE VIEW I_BusPartCustSelectedTaxType AS
SELECT
  taxtype AS BPTaxType
FROM tfktaxnumtype_c
LEFT OUTER JOIN I_BusPartTaxTypeText AS _Text ON BPTaxType = _Text.BPTaxType  -- association [0..*]
;