C_LCMEntityIDValueHelp

DDL: C_LCMENTITYIDVALUEHELP SQL: CLCMENTITYIDVH Type: view CONSUMPTION
12 Fields 2 Associations

Value Help for LCM Entity ID

C_LCMEntityIDValueHelp is a Consumption CDS View that provides data about "Value Help for LCM Entity ID" in SAP S/4HANA. It has 2 associations to related views.

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_LegalTrEntityAggr _LegalTrEntityAggrgn LegalTransactionEntity.LegalTransactionEntityUUID = _LegalTrEntityAggrgn.LegalTransactionEntityUUID
[0..1] C_LCMEntityTypeValueHelp _LCMEntityTypeValueHelp $projection.LglCntntMEntityType = _LCMEntityTypeValueHelp.LglCntntMEntityType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CLCMENTITYIDVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Value Help for LCM Entity ID view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMEntity LegalTransactionEntity LglCntntMEntity Entity ID
KEY LglCntntMEntityType LegalTransactionEntity LglCntntMEntityType Entity Type
KEY LglCntntMAccessLvl _LegalTrEntityAggrgn LglCntntMAccessLvl Access Level
KEY LglCntntMMainOrgCoCode Main Company Code Organization
KEY LglCntntMMainOrgSalesOrg Main Sales Organization
KEY LglCntntMMainOrgPurOrg Main Purchase Organization
KEY LglCntntMProfile _LegalTrEntityAggrgn LglCntntMProfile Profile
IsEndOfPurposeBlocked
LglCntntMEntityName _LegalTrEntityAggrgn LglCntntMEntityName Entity Name
LglCntntMEntityTypeName _LCMEntityTypeValueHelp LglCntntMEntityTypeName Entity Type Name
LglCntntMProfileName Profile Name
LglCntntMAccessLvlName Access Level

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_LCMEntityIDValueHelp.
-- 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: CLCMENTITYIDVH

CREATE VIEW C_LCMEntityIDValueHelp AS
SELECT
  LegalTransactionEntity.LglCntntMEntity AS LglCntntMEntity,
  LegalTransactionEntity.LglCntntMEntityType AS LglCntntMEntityType,
  _LegalTrEntityAggrgn.LglCntntMAccessLvl AS LglCntntMAccessLvl,
  LegalTransactionEntity._LegalTransaction.LglCntntMMainOrgCoCode AS LglCntntMMainOrgCoCode,
  LegalTransactionEntity._LegalTransaction.LglCntntMMainOrgSalesOrg AS LglCntntMMainOrgSalesOrg,
  LegalTransactionEntity._LegalTransaction.LglCntntMMainOrgPurOrg AS LglCntntMMainOrgPurOrg,
  _LegalTrEntityAggrgn.LglCntntMProfile AS LglCntntMProfile,
  _LegalTrEntityAggrgn._LegalTransaction.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _LegalTrEntityAggrgn.LglCntntMEntityName AS LglCntntMEntityName,
  _LCMEntityTypeValueHelp.LglCntntMEntityTypeName AS LglCntntMEntityTypeName,
  _LegalTrEntityAggrgn._LglCntntMProfile._Text[1: Language = $session.system_language].LglCntntMProfileName AS LglCntntMProfileName,
  _LegalTrEntityAggrgn._LglCntntMAccessLvl._Text[1: Language = $session.system_language].LglCntntMAccessLvlName AS LglCntntMAccessLvlName
LEFT OUTER JOIN I_LegalTrEntityAggr AS _LegalTrEntityAggrgn ON LegalTransactionEntity.LegalTransactionEntityUUID = _LegalTrEntityAggrgn.LegalTransactionEntityUUID  -- association [0..1]
LEFT OUTER JOIN C_LCMEntityTypeValueHelp AS _LCMEntityTypeValueHelp ON LglCntntMEntityType = _LCMEntityTypeValueHelp.LglCntntMEntityType  -- association [0..1]
;

Learn More