I_LglCntntMCntxtPhseItemTP

DDL: I_LGLCNTNTMCNTXTPHSEITEMTP Type: view_entity TRANSACTIONAL

Legal Context Phase Item

I_LglCntntMCntxtPhseItemTP is a Transactional CDS View that provides data about "Legal Context Phase Item" in SAP S/4HANA. It reads from 1 data source (I_LglCntntMCntxtPhseItem) and exposes 10 fields with key field LglCntntMPhaseItemUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMCntxtPhseItem I_LglCntntMCntxtPhseItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_LCMContextTP _LCMContextTP $projection.LglCntntMContextUUID = _LCMContextTP.LglCntntMContextUUID
[0..*] I_LglCntntMPhaseActionText _LglCntntMPhaseActionText $projection.LglCntntMPhaseActionType = _LglCntntMPhaseActionText.LglCntntMPhaseActionType
[1..*] I_LglCntntMCntxtPhseDocTP _LglCntntMCntxtPhseDocTP

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.representativeKey LglCntntMPhaseItemUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Legal Context Phase Item view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMPhaseItemUUID LglCntntMPhaseItemUUID Universal Unique ID
LglCntntMPhaseUUID LglCntntMPhaseUUID Universal Unique ID
LglCntntMContextUUID LglCntntMContextUUID Universal Unique ID
LglCntntMPhaseActionType LglCntntMPhaseActionType State
LglCntntMRank LglCntntMRank Seq No
_LCMContextTP _LCMContextTP
_LglCntntMCntxtPhseTP _LglCntntMCntxtPhseTP
_LglCntntMCntxtPhseDocTP _LglCntntMCntxtPhseDocTP
_LglCntntMPhaseActionText _LglCntntMPhaseActionText
_LglCntntMContext _LglCntntMContext

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_LglCntntMCntxtPhseItemTP.
-- 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.

CREATE VIEW I_LglCntntMCntxtPhseItemTP AS
SELECT
  LglCntntMPhaseItemUUID,
  LglCntntMPhaseUUID,
  LglCntntMContextUUID,
  LglCntntMPhaseActionType,
  LglCntntMRank
FROM I_LglCntntMCntxtPhseItem
LEFT OUTER JOIN I_LCMContextTP AS _LCMContextTP ON LglCntntMContextUUID = _LCMContextTP.LglCntntMContextUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMPhaseActionText AS _LglCntntMPhaseActionText ON LglCntntMPhaseActionType = _LglCntntMPhaseActionText.LglCntntMPhaseActionType  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMCntxtPhseDocTP AS _LglCntntMCntxtPhseDocTP ON /* condition not available in parsed metadata */  -- association [1..*]
;