C_LglCntntMBusPartRoleVH

DDL: C_LGLCNTNTMBUSPARTROLEVH SQL: CLCMENTBPROLEVH Type: view CONSUMPTION

ECM Entity Type Business Partner Roles

C_LglCntntMBusPartRoleVH is a Consumption CDS View that provides data about "ECM Entity Type Business Partner Roles" in SAP S/4HANA. It reads from 1 data source (I_LCMEntityTypeByBPRole) and exposes 3 fields with key fields LglCntntMEntityType, BusinessPartnerRole.

Data Sources (1)

SourceAliasJoin Type
I_LCMEntityTypeByBPRole I_LCMEntityTypeByBPRole from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CLCMENTBPROLEVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ECM Entity Type Business Partner Roles view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey LglCntntMEntityType view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMEntityType LglCntntMEntityType Entity Type
KEY BusinessPartnerRole BusinessPartnerRole Business Partner Role
BusinessPartnerRoleShortName

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 C_LglCntntMBusPartRoleVH.
-- 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: CLCMENTBPROLEVH

CREATE VIEW C_LglCntntMBusPartRoleVH AS
SELECT
  LglCntntMEntityType,
  BusinessPartnerRole,
  _LCMEntityTypeByBPRoleText[1: Language = $session.system_language].BusinessPartnerRoleShortName AS BusinessPartnerRoleShortName
FROM I_LCMEntityTypeByBPRole
;