I_ChgMgmtActyPersnInvolvedCube

DDL: I_CHGMGMTACTYPERSNINVOLVEDCUBE SQL: IACPERINVCUBE Type: view COMPOSITE
32 Fields 1 Data Sources 3 Associations

Change Mgmt Person Involved - Cube

I_ChgMgmtActyPersnInvolvedCube 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_ChgMgmtActyPersonInvolved) and exposes 32 fields with key field ChgMgmtActyPersnInvolvedUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChgMgmtActyPersonInvolved I_ChgMgmtActyPersonInvolved from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ChgMgmtPersnInvolvedRole _ChgMgmtPersnInvolvedRole $projection.ChgMgmtPersnInvolvedRole = _ChgMgmtPersnInvolvedRole.ChgMgmtPersnInvolvedRole
[0..1] I_BusinessUserBasic _BusinessUserBasic $projection.BusinessPartner = _BusinessUserBasic.BusinessPartner
[1..1] I_ChgMgmtActivityCube _ChgMgmtActivityCube $projection.ChgMgmtActyUUID = _ChgMgmtActivityCube.ChgMgmtActyUUID

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 IACPERINVCUBE 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 ChgMgmtActyPersnInvolvedUUID 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 (32)

KeyFieldSource TableSource FieldDescription
KEY ChgMgmtActyPersnInvolvedUUID ChgMgmtActyPersnInvolvedUUID UUID
ChgMgmtReqUUID _ChgMgmtActivityCube ChgMgmtReqUUID
ChgMgmtActyUUID ChgMgmtActyUUID UUID
ChgMgmtPersnInvolvedRole ChgMgmtPersnInvolvedRole
_ChgMgmtPersnInvolvedRole _ChgMgmtPersnInvolvedRole
BusinessPartner BusinessPartner Issuing Authority
_BusinessUserBasic _BusinessUserBasic
ChgMgmtActyType _ChgMgmtActivityCube ChgMgmtActyType
_ChgMgmtActyType _ChgMgmtActivityCube _ChgMgmtActyType
ChgMgmtActyStatus _ChgMgmtActivityCube ChgMgmtActyStatus
_ChgMgmtActyStatus _ChgMgmtActivityCube _ChgMgmtActyStatus
ChgMgmtActyDueDate _ChgMgmtActivityCube ChgMgmtActyDueDate
ChgMgmtActyDueMonth _ChgMgmtActivityCube ChgMgmtActyDueMonth
ChgMgmtActyDueYear _ChgMgmtActivityCube ChgMgmtActyDueYear
ChgMgmtActyAuthorizationGroup _ChgMgmtActivityCube ChgMgmtActyAuthorizationGroup
ChgMgmtReqCreationDate _ChgMgmtActivityCube ChgMgmtReqCreationDate
ChgMgmtReqCreationMonth _ChgMgmtActivityCube ChgMgmtReqCreationMonth
ChgMgmtReqCreationYear _ChgMgmtActivityCube ChgMgmtReqCreationYear
ChgMgmtReqReversalDate _ChgMgmtActivityCube ChgMgmtReqReversalDate
ChgMgmtReqReversalMonth _ChgMgmtActivityCube ChgMgmtReqReversalMonth
ChgMgmtReqReversalYear _ChgMgmtActivityCube ChgMgmtReqReversalYear
ChgMgmtReqApprovalDate _ChgMgmtActivityCube ChgMgmtReqApprovalDate
ChgMgmtReqApprovalMonth _ChgMgmtActivityCube ChgMgmtReqApprovalMonth
ChgMgmtReqApprovalYear _ChgMgmtActivityCube ChgMgmtReqApprovalYear
ChgMgmtReqExecStartDate _ChgMgmtActivityCube ChgMgmtReqExecStartDate
ChgMgmtReqExecStartMonth _ChgMgmtActivityCube ChgMgmtReqExecStartMonth
ChgMgmtReqExecStartYear _ChgMgmtActivityCube ChgMgmtReqExecStartYear
ChgMgmtReqOplStartDate _ChgMgmtActivityCube ChgMgmtReqOplStartDate
ChgMgmtReqOplStartMonth _ChgMgmtActivityCube ChgMgmtReqOplStartMonth
ChgMgmtReqOplStartYear _ChgMgmtActivityCube ChgMgmtReqOplStartYear
NumberOfChgMgmtActivities 1 Number of Change Activities
_ChgMgmtActivity _ChgMgmtActivity

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_ChgMgmtActyPersnInvolvedCube.
-- 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: IACPERINVCUBE

CREATE VIEW I_ChgMgmtActyPersnInvolvedCube AS
SELECT
  ChgMgmtActyPersnInvolvedUUID,
  _ChgMgmtActivityCube.ChgMgmtReqUUID AS ChgMgmtReqUUID,
  ChgMgmtActyUUID,
  ChgMgmtPersnInvolvedRole,
  BusinessPartner,
  _ChgMgmtActivityCube.ChgMgmtActyType AS ChgMgmtActyType,
  _ChgMgmtActivityCube._ChgMgmtActyType AS _ChgMgmtActyType,
  _ChgMgmtActivityCube.ChgMgmtActyStatus AS ChgMgmtActyStatus,
  _ChgMgmtActivityCube._ChgMgmtActyStatus AS _ChgMgmtActyStatus,
  _ChgMgmtActivityCube.ChgMgmtActyDueDate AS ChgMgmtActyDueDate,
  _ChgMgmtActivityCube.ChgMgmtActyDueMonth AS ChgMgmtActyDueMonth,
  _ChgMgmtActivityCube.ChgMgmtActyDueYear AS ChgMgmtActyDueYear,
  _ChgMgmtActivityCube.ChgMgmtActyAuthorizationGroup AS ChgMgmtActyAuthorizationGroup,
  _ChgMgmtActivityCube.ChgMgmtReqCreationDate AS ChgMgmtReqCreationDate,
  _ChgMgmtActivityCube.ChgMgmtReqCreationMonth AS ChgMgmtReqCreationMonth,
  _ChgMgmtActivityCube.ChgMgmtReqCreationYear AS ChgMgmtReqCreationYear,
  _ChgMgmtActivityCube.ChgMgmtReqReversalDate AS ChgMgmtReqReversalDate,
  _ChgMgmtActivityCube.ChgMgmtReqReversalMonth AS ChgMgmtReqReversalMonth,
  _ChgMgmtActivityCube.ChgMgmtReqReversalYear AS ChgMgmtReqReversalYear,
  _ChgMgmtActivityCube.ChgMgmtReqApprovalDate AS ChgMgmtReqApprovalDate,
  _ChgMgmtActivityCube.ChgMgmtReqApprovalMonth AS ChgMgmtReqApprovalMonth,
  _ChgMgmtActivityCube.ChgMgmtReqApprovalYear AS ChgMgmtReqApprovalYear,
  _ChgMgmtActivityCube.ChgMgmtReqExecStartDate AS ChgMgmtReqExecStartDate,
  _ChgMgmtActivityCube.ChgMgmtReqExecStartMonth AS ChgMgmtReqExecStartMonth,
  _ChgMgmtActivityCube.ChgMgmtReqExecStartYear AS ChgMgmtReqExecStartYear,
  _ChgMgmtActivityCube.ChgMgmtReqOplStartDate AS ChgMgmtReqOplStartDate,
  _ChgMgmtActivityCube.ChgMgmtReqOplStartMonth AS ChgMgmtReqOplStartMonth,
  _ChgMgmtActivityCube.ChgMgmtReqOplStartYear AS ChgMgmtReqOplStartYear,
  1 AS NumberOfChgMgmtActivities
FROM I_ChgMgmtActyPersonInvolved
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_ChgMgmtActivityCube AS _ChgMgmtActivityCube ON ChgMgmtActyUUID = _ChgMgmtActivityCube.ChgMgmtActyUUID  -- association [1..1]
;

Learn More