I_BusPartIndustrySystem

DDL: I_BUSPARTINDUSTRYSYSTEM SQL: IBPINDSYST Type: view BASIC Package: MDC_BUPA_BO

Business Partner Industry System

I_BusPartIndustrySystem (Basic)

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

BPIndustrySystemType · Database & Data Management

I_BusPartIndustrySystem is a Basic CDS View that provides data about "Business Partner Industry System" in SAP S/4HANA. It reads from 1 data source (tb038) and exposes 2 fields with key field IndustrySystemType. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F7204A, ASQL_F7205A). Part of development package MDC_BUPA_BO.

SAP Help Documentation

CategoryCDS Views for Business Partner
Purpose
This CDS view is designed to provide information about industry system types, including their associated text descriptions. It serves as a foundational view for understanding and categorizing industry systems of business partners. This CDS view provides the data to answer the following business questions: What are the different industry system types available? How can industry system types be described or categorized using text descriptions? How can we associate business partners with specific industry system types for better segmentation and analysis?

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 IndustrySystemType Type of industry that serves to combine and categorize several industries into a group.

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessDatabase & Data Management
Application ComponentAP-MD-BP-RAP
CapabilitiesData Source for Data Extraction,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source in SQL Select
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 provide information about industry system types, including their associated text descriptions. It serves as a foundational view for understanding and categorizing industry systems of business partners.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the different industry system types available?</p></li> <li><p>How can industry system types be described or categorized using text descriptions?</p></li> <li><p>How can we associate business partners with specific industry system types for better segmentation and analysis?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tb038 tb038 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BusPartIndustrySystemText _Text $projection.IndustrySystemType = _Text.IndustrySystemType

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBPINDSYST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.sapObjectNodeType.name BPIndustrySystemType view
ObjectModel.modelingPattern #NONE view
EndUserText.label Business Partner Industry System view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7204A ASQL_F7204A C2 NOT_RELEASED
ASQL_F7205A ASQL_F7205A C2 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY IndustrySystemType istype Industry System
_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_BusPartIndustrySystem.
-- 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: IBPINDSYST

CREATE VIEW I_BusPartIndustrySystem AS
SELECT
  istype AS IndustrySystemType
FROM tb038
LEFT OUTER JOIN I_BusPartIndustrySystemText AS _Text ON IndustrySystemType = _Text.IndustrySystemType  -- association [0..*]
;