I_ChgMgmtReqPersonInvolvedCube

DDL: I_CHGMGMTREQPERSONINVOLVEDCUBE SQL: ICMRPICUBE Type: view COMPOSITE
45 Fields 1 Data Sources 7 Associations

Change Mgmt Person Involved - Cube

I_ChgMgmtReqPersonInvolvedCube is a Composite CDS View (Cube) that provides data about "Change Mgmt Person Involved - Cube" in SAP S/4HANA. It reads from 1 data source (I_ChgMgmtReqPersonInvolved) and exposes 45 fields with key field ChgMgmtReqPersnInvolvedUUID. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChgMgmtReqPersonInvolved I_ChgMgmtReqPersonInvolved from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_ChgMgmtPersnInvolvedRole _ChgMgmtPersnInvolvedRole $projection.ChgMgmtPersnInvolvedRole = _ChgMgmtPersnInvolvedRole.ChgMgmtPersnInvolvedRole
[0..1] I_BusinessUserBasic _BusinessUserBasic $projection.BusinessPartner = _BusinessUserBasic.BusinessPartner
[0..1] I_ChgMgmtRequestCube _ChgMgmtRequestCube $projection.ChgMgmtReqUUID = _ChgMgmtRequestCube.ChgMgmtReqUUID
[0..1] I_ChgMgmtReqRelatedObject _ChgMgmtReqLeadingObject $projection.ChgMgmtReqUUID = _ChgMgmtReqLeadingObject.ChgMgmtReqUUID and _ChgMgmtReqLeadingObject.ChgMgmtReqReltdObjIsLeading = 'X'
[0..1] I_ChgMgmtReqMainPlant _ChgMgmtReqMainPlant $projection.ChgMgmtReqUUID = _ChgMgmtReqMainPlant.ChgMgmtReqUUID
[0..1] I_ChgMgmtActivity _ChgMgmtActivity $projection.ChgMgmtReqUUID = _ChgMgmtActivity.ChgMgmtReqUUID
[0..1] I_ChgMgmtReqPersonInvolved _ChgMgmtReqPersonInvolved $projection.ChgMgmtReqUUID = _ChgMgmtReqPersonInvolved.ChgMgmtReqUUID

Annotations (16)

NameValueLevelField
EndUserText.label Change Mgmt Person Involved - Cube view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ICMRPICUBE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ChgMgmtReqPersnInvolvedUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY ChgMgmtReqPersnInvolvedUUID ChgMgmtReqPersnInvolvedUUID UUID
ChgMgmtReqUUID ChgMgmtReqUUID UUID
ChgMgmtPersnInvolvedRole ChgMgmtPersnInvolvedRole
_ChgMgmtPersnInvolvedRole _ChgMgmtPersnInvolvedRole
BusinessPartner BusinessPartner Issuing Authority
_BusinessUserBasic _BusinessUserBasic
ChgMgmtReqDescriptionText
ChgMgmtReqType _ChgMgmtRequestCube ChgMgmtReqType Change Request Type
_ChgMgmtReqType _ChgMgmtRequestCube _ChgMgmtReqType
ChgMgmtReqStatus _ChgMgmtRequestCube ChgMgmtReqStatus
_ChgMgmtReqStatus _ChgMgmtRequestCube _ChgMgmtReqStatus
ChgMgmtReqLeadingObjType _ChgMgmtRequestCube ChgMgmtReqLeadingObjType
_ChgMgmtReqLeadingObjTypeText _ChgMgmtRequestCube _ChgMgmtReqLeadingObjTypeText
ChgMgmtReqLeadingObject _ChgMgmtRequestCube ChgMgmtReqLeadingObject
ChgMgmtReqLeadingObjName _ChgMgmtRequestCube ChgMgmtReqLeadingObjName
ChgMgmtReqMainPlant _ChgMgmtRequestCube ChgMgmtReqMainPlant
Country _ChgMgmtRequestCube Country Venue: Ctry/Reg
_CountryText _ChgMgmtRequestCube _CountryText
ChgMgmtReqIsEmergency _ChgMgmtRequestCube ChgMgmtReqIsEmergency
ChgMgmtReqDurationCode _ChgMgmtRequestCube ChgMgmtReqDurationCode
_ChgMgmtReqDurationText _ChgMgmtRequestCube _ChgMgmtReqDurationText
ChgMgmtReqImpact _ChgMgmtRequestCube ChgMgmtReqImpact
_ChgMgmtReqImpactText _ChgMgmtRequestCube _ChgMgmtReqImpactText
ChgMgmtReqReversalDate _ChgMgmtRequestCube ChgMgmtReqReversalDate
ChgMgmtReqReversalMonth _ChgMgmtRequestCube ChgMgmtReqReversalMonth
ChgMgmtReqReversalYear _ChgMgmtRequestCube ChgMgmtReqReversalYear
ChgMgmtReqApprovalDate _ChgMgmtRequestCube ChgMgmtReqApprovalDate
ChgMgmtReqApprovalMonth _ChgMgmtRequestCube ChgMgmtReqApprovalMonth
ChgMgmtReqApprovalYear _ChgMgmtRequestCube ChgMgmtReqApprovalYear
ChgMgmtReqExecStartDate _ChgMgmtRequestCube ChgMgmtReqExecStartDate
ChgMgmtReqExecStartMonth _ChgMgmtRequestCube ChgMgmtReqExecStartMonth
ChgMgmtReqExecStartYear _ChgMgmtRequestCube ChgMgmtReqExecStartYear
ChgMgmtReqOplStartDate _ChgMgmtRequestCube ChgMgmtReqOplStartDate
ChgMgmtReqOplStartMonth _ChgMgmtRequestCube ChgMgmtReqOplStartMonth
ChgMgmtReqOplStartYear _ChgMgmtRequestCube ChgMgmtReqOplStartYear
ChgMgmtReqCreationDate _ChgMgmtRequestCube ChgMgmtReqCreationDate
ChgMgmtReqCreationMonth _ChgMgmtRequestCube ChgMgmtReqCreationMonth
ChgMgmtReqCreationYear _ChgMgmtRequestCube ChgMgmtReqCreationYear
ChgMgmtReqAuthorizationGroup _ChgMgmtRequestCube ChgMgmtReqAuthorizationGroup
_ChgMgmtReqLeadingObject _ChgMgmtReqLeadingObject
_ChgMgmtReqMainPlant _ChgMgmtReqMainPlant
ChgMgmtReqIsAccessRestricted _ChgMgmtRequestCube ChgMgmtReqIsAccessRestricted
_ChgMgmtReqPersonInvolved _ChgMgmtReqPersonInvolved
_ChgMgmtActivity _ChgMgmtActivity
NumberOfChgMgmtRequests 1 Number of Change Requests

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_ChgMgmtReqPersonInvolvedCube.
-- 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: ICMRPICUBE

CREATE VIEW I_ChgMgmtReqPersonInvolvedCube AS
SELECT
  ChgMgmtReqPersnInvolvedUUID,
  ChgMgmtReqUUID,
  ChgMgmtPersnInvolvedRole,
  BusinessPartner,
  _ChgMgmtRequest._ChgMgmtReqExplanation._Text[1:ChgMgmtReqDescriptionUUID = ChgMgmtReqDescriptionUUID].ChgMgmtReqDescriptionText AS ChgMgmtReqDescriptionText,
  _ChgMgmtRequestCube.ChgMgmtReqType AS ChgMgmtReqType,
  _ChgMgmtRequestCube._ChgMgmtReqType AS _ChgMgmtReqType,
  _ChgMgmtRequestCube.ChgMgmtReqStatus AS ChgMgmtReqStatus,
  _ChgMgmtRequestCube._ChgMgmtReqStatus AS _ChgMgmtReqStatus,
  _ChgMgmtRequestCube.ChgMgmtReqLeadingObjType AS ChgMgmtReqLeadingObjType,
  _ChgMgmtRequestCube._ChgMgmtReqLeadingObjTypeText AS _ChgMgmtReqLeadingObjTypeText,
  _ChgMgmtRequestCube.ChgMgmtReqLeadingObject AS ChgMgmtReqLeadingObject,
  _ChgMgmtRequestCube.ChgMgmtReqLeadingObjName AS ChgMgmtReqLeadingObjName,
  _ChgMgmtRequestCube.ChgMgmtReqMainPlant AS ChgMgmtReqMainPlant,
  _ChgMgmtRequestCube.Country AS Country,
  _ChgMgmtRequestCube._CountryText AS _CountryText,
  _ChgMgmtRequestCube.ChgMgmtReqIsEmergency AS ChgMgmtReqIsEmergency,
  _ChgMgmtRequestCube.ChgMgmtReqDurationCode AS ChgMgmtReqDurationCode,
  _ChgMgmtRequestCube._ChgMgmtReqDurationText AS _ChgMgmtReqDurationText,
  _ChgMgmtRequestCube.ChgMgmtReqImpact AS ChgMgmtReqImpact,
  _ChgMgmtRequestCube._ChgMgmtReqImpactText AS _ChgMgmtReqImpactText,
  _ChgMgmtRequestCube.ChgMgmtReqReversalDate AS ChgMgmtReqReversalDate,
  _ChgMgmtRequestCube.ChgMgmtReqReversalMonth AS ChgMgmtReqReversalMonth,
  _ChgMgmtRequestCube.ChgMgmtReqReversalYear AS ChgMgmtReqReversalYear,
  _ChgMgmtRequestCube.ChgMgmtReqApprovalDate AS ChgMgmtReqApprovalDate,
  _ChgMgmtRequestCube.ChgMgmtReqApprovalMonth AS ChgMgmtReqApprovalMonth,
  _ChgMgmtRequestCube.ChgMgmtReqApprovalYear AS ChgMgmtReqApprovalYear,
  _ChgMgmtRequestCube.ChgMgmtReqExecStartDate AS ChgMgmtReqExecStartDate,
  _ChgMgmtRequestCube.ChgMgmtReqExecStartMonth AS ChgMgmtReqExecStartMonth,
  _ChgMgmtRequestCube.ChgMgmtReqExecStartYear AS ChgMgmtReqExecStartYear,
  _ChgMgmtRequestCube.ChgMgmtReqOplStartDate AS ChgMgmtReqOplStartDate,
  _ChgMgmtRequestCube.ChgMgmtReqOplStartMonth AS ChgMgmtReqOplStartMonth,
  _ChgMgmtRequestCube.ChgMgmtReqOplStartYear AS ChgMgmtReqOplStartYear,
  _ChgMgmtRequestCube.ChgMgmtReqCreationDate AS ChgMgmtReqCreationDate,
  _ChgMgmtRequestCube.ChgMgmtReqCreationMonth AS ChgMgmtReqCreationMonth,
  _ChgMgmtRequestCube.ChgMgmtReqCreationYear AS ChgMgmtReqCreationYear,
  _ChgMgmtRequestCube.ChgMgmtReqAuthorizationGroup AS ChgMgmtReqAuthorizationGroup,
  _ChgMgmtRequestCube.ChgMgmtReqIsAccessRestricted AS ChgMgmtReqIsAccessRestricted,
  1 AS NumberOfChgMgmtRequests
FROM I_ChgMgmtReqPersonInvolved
LEFT OUTER JOIN I_ChgMgmtPersnInvolvedRole AS _ChgMgmtPersnInvolvedRole ON ChgMgmtPersnInvolvedRole = _ChgMgmtPersnInvolvedRole.ChgMgmtPersnInvolvedRole  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _BusinessUserBasic ON BusinessPartner = _BusinessUserBasic.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtRequestCube AS _ChgMgmtRequestCube ON ChgMgmtReqUUID = _ChgMgmtRequestCube.ChgMgmtReqUUID  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqRelatedObject AS _ChgMgmtReqLeadingObject ON ChgMgmtReqUUID = _ChgMgmtReqLeadingObject.ChgMgmtReqUUID AND _ChgMgmtReqLeadingObject.ChgMgmtReqReltdObjIsLeading = 'X'  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqMainPlant AS _ChgMgmtReqMainPlant ON ChgMgmtReqUUID = _ChgMgmtReqMainPlant.ChgMgmtReqUUID  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtActivity AS _ChgMgmtActivity ON ChgMgmtReqUUID = _ChgMgmtActivity.ChgMgmtReqUUID  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtReqPersonInvolved AS _ChgMgmtReqPersonInvolved ON ChgMgmtReqUUID = _ChgMgmtReqPersonInvolved.ChgMgmtReqUUID  -- association [0..1]
;

Learn More