I_BusinessPartnerGroupingText

DDL: I_BUSINESSPARTNERGROUPINGTEXT SQL: IBPGROUPINGTXT Type: view BASIC

Business Partner Grouping - Text

I_BusinessPartnerGroupingText (Basic)

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

Database & Data Management

I_BusinessPartnerGroupingText is a Basic CDS View that provides data about "Business Partner Grouping - Text" in SAP S/4HANA. It reads from 1 data source (tb002) and exposes 3 fields with key fields Language, BusinessPartnerGrouping.

SAP API Hub

StateC1
Line of BusinessDatabase & Data Management
Application ComponentAP-MD-BP-RAP
CapabilitiesLanguage-Dependent Text, Data Source for Defining CDS Entities, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageDatabase & Data Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tb002 tb002 from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IBPGROUPINGTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey BusinessPartnerGrouping view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
EndUserText.label Business Partner Grouping - Text view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Language spras Off. Language
KEY BusinessPartnerGrouping bu_group Business Partner Grouping
BusinessPartnerGroupingText txt40 Grouping Description

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_BusinessPartnerGroupingText.
-- 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: IBPGROUPINGTXT

CREATE VIEW I_BusinessPartnerGroupingText AS
SELECT
  spras AS Language,
  bu_group AS BusinessPartnerGrouping,
  txt40 AS BusinessPartnerGroupingText
FROM tb002
;