C_LglCntntMProfileValueHelp

DDL: C_LGLCNTNTMPROFILEVALUEHELP SQL: CLCMPROFILEVH Type: view CONSUMPTION
8 Fields 3 Data Sources

Value Help for LCM Profile

C_LglCntntMProfileValueHelp is a Consumption CDS View that provides data about "Value Help for LCM Profile" in SAP S/4HANA. It reads from 3 data sources (I_BusinessFeatureState, I_LglCntntMIntegType, I_LglCntntMProfile) and exposes 8 fields with key fields LglCntntMProfile, LglCntntMIntegrationType, LglCntntMIntegrationType.

Data Sources (3)

SourceAliasJoin Type
I_BusinessFeatureState _BusinessFeatureState inner
I_LglCntntMIntegType I_LglCntntMIntegType union
I_LglCntntMProfile I_LglCntntMProfile from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CLCMPROFILEVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.semanticKey LglCntntMProfile view
ObjectModel.representativeKey LglCntntMProfile view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Value Help for LCM Profile view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMProfile LglCntntMProfile Profile
KEY LglCntntMIntegrationType Integration Variant
LglCntntMProfileName Long Text
LglCntntMIntegVarIsActive Integ variant active
KEY LglCntntMIntegrationType LglCntntMIntegrationType Integration Variant
LglCntntMProfileName _LglCntntMProfileText LglCntntMProfileName Long Text
LglCntntMIntegVarIsActive LglCntntMIntegVarIsActive Integ variant active
LglCntntMIntegrationTypeName _LglCntntMIntegTypeText LglCntntMIntegrationTypeName 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 C_LglCntntMProfileValueHelp.
-- 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: CLCMPROFILEVH

CREATE VIEW C_LglCntntMProfileValueHelp AS
SELECT
  LglCntntMProfile,
  cast( '' as lcm_integration_type ) AS LglCntntMIntegrationType,
  _Text[1: Language = $session.system_language].LglCntntMProfileName AS LglCntntMProfileName,
  cast('' as lcm_integ_var_isactive) AS LglCntntMIntegVarIsActive,
  _LglCntntMIntegTypeText.LglCntntMIntegrationTypeName AS LglCntntMIntegrationTypeName
FROM I_LglCntntMProfile
INNER JOIN I_BusinessFeatureState AS _BusinessFeatureState ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_LglCntntMIntegType
;

Learn More