I_CHGMGMTREQWORKLIST

CDS View

Change Management Request Worklist

I_CHGMGMTREQWORKLIST is a CDS View in S/4HANA. Change Management Request Worklist. It contains 52 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_ChgMgmtReqWorklist view from CONSUMPTION Manage Change Requests
I_ChgMgmtRequestCube view from COMPOSITE Change Management Request Cube

Fields (52)

KeyField CDS FieldsUsed in Views
KEY ChgMgmtReqUUID ChgMgmtReqUUID 1
_ChgMgmtActivity _ChgMgmtActivity 1
_ChgMgmtDigitalSgntrSts _ChgMgmtDigitalSgntrSts 1
_ChgMgmtReqDuration _ChgMgmtReqDuration 1
_ChgMgmtReqDurationText _ChgMgmtReqDurationText 1
_ChgMgmtReqEnteredByBP _ChgMgmtReqEnteredByBP 1
_ChgMgmtReqImpact _ChgMgmtReqImpact 1
_ChgMgmtReqImpactText _ChgMgmtReqImpactText 1
_ChgMgmtReqLeadingObject _ChgMgmtReqLeadingObject 1
_ChgMgmtReqLeadingObjTypeText _ChgMgmtReqLeadingObjTypeText 1
_ChgMgmtReqMainPlant _ChgMgmtReqMainPlant 1
_ChgMgmtReqMainPlantText _ChgMgmtReqMainPlantText 1
_ChgMgmtReqPersonInvolved _ChgMgmtReqPersonInvolved 1
_ChgMgmtReqReportedByBP _ChgMgmtReqReportedByBP 1
_ChgMgmtReqReporter _ChgMgmtReqReporter 1
_ChgMgmtReqStatus _ChgMgmtReqStatus 1
_ChgMgmtReqType _ChgMgmtReqType 1
_CountryText _CountryText 1
_EnteredBy _EnteredBy 1
ChgMgmtDigitalSgntrStatus ChgMgmtDigitalSgntrStatus 1
ChgMgmtReqApprovalDate ChgMgmtReqApprovalDate 1
ChgMgmtReqAuthorizationGroup ChgMgmtReqAuthorizationGroup 1
ChgMgmtReqCreationDate ChgMgmtReqCreationDate 1
ChgMgmtReqDescriptionText ChgMgmtReqDescriptionText 1
ChgMgmtReqDurationCode ChgMgmtReqDurationCode 1
ChgMgmtReqEnteredByBP ChgMgmtReqEnteredByBP 1
ChgMgmtReqEnteredByUser ChgMgmtReqEnteredByUser 1
ChgMgmtReqExecStartDate ChgMgmtReqExecStartDate 1
ChgMgmtReqImpact ChgMgmtReqImpact 1
ChgMgmtReqIsAccessRestricted ChgMgmtReqIsAccessRestricted 1
ChgMgmtReqIsEmergency ChgMgmtReqIsEmergency 1
ChgMgmtReqLeadingObject ChgMgmtReqLeadingObject 1
ChgMgmtReqLeadingObjectLoc ChgMgmtReqLeadingObjectLoc 1
ChgMgmtReqLeadingObjectLocName ChgMgmtReqLeadingObjectLocName 1
ChgMgmtReqLeadingObjName ChgMgmtReqLeadingObjName 1
ChgMgmtReqLeadingObjType ChgMgmtReqLeadingObjType 1
ChgMgmtReqMainPlant ChgMgmtReqMainPlant 1
ChgMgmtReqMainPlantUUID ChgMgmtReqMainPlantUUID 1
ChgMgmtReqOplStartDate ChgMgmtReqOplStartDate 1
ChgMgmtReqReportedByBP ChgMgmtReqReportedByBP 1
ChgMgmtReqReportedDate ChgMgmtReqReportedDate 1
ChgMgmtReqReversalDate ChgMgmtReqReversalDate 1
ChgMgmtReqStatus ChgMgmtReqStatus 1
ChgMgmtReqStatusCriticality ChgMgmtReqStatusCriticality 1
ChgMgmtReqType ChgMgmtReqType 1
ChgMgmtRequest ChgMgmtRequest 1
ChgMgmtUserStatus1 ChgMgmtUserStatus1 1
ChgMgmtUserStatus2 ChgMgmtUserStatus2 1
ChgMgmtUserStatus3 ChgMgmtUserStatus3 1
ChgMgmtUserStatus4 ChgMgmtUserStatus4 1
ChgMgmtUserStatus5 ChgMgmtUserStatus5 1
Country Country 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Change Management Request Worklist
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHGMGMTREQWORKLIST (
    CHGMGMTREQUUID,
    _CHGMGMTACTIVITY,
    _CHGMGMTDIGITALSGNTRSTS,
    _CHGMGMTREQDURATION,
    _CHGMGMTREQDURATIONTEXT,
    _CHGMGMTREQENTEREDBYBP,
    _CHGMGMTREQIMPACT,
    _CHGMGMTREQIMPACTTEXT,
    _CHGMGMTREQLEADINGOBJECT,
    _CHGMGMTREQLEADINGOBJTYPETEXT,
    _CHGMGMTREQMAINPLANT,
    _CHGMGMTREQMAINPLANTTEXT,
    _CHGMGMTREQPERSONINVOLVED,
    _CHGMGMTREQREPORTEDBYBP,
    _CHGMGMTREQREPORTER,
    _CHGMGMTREQSTATUS,
    _CHGMGMTREQTYPE,
    _COUNTRYTEXT,
    _ENTEREDBY,
    CHGMGMTDIGITALSGNTRSTATUS,
    CHGMGMTREQAPPROVALDATE,
    CHGMGMTREQAUTHORIZATIONGROUP,
    CHGMGMTREQCREATIONDATE,
    CHGMGMTREQDESCRIPTIONTEXT,
    CHGMGMTREQDURATIONCODE,
    CHGMGMTREQENTEREDBYBP,
    CHGMGMTREQENTEREDBYUSER,
    CHGMGMTREQEXECSTARTDATE,
    CHGMGMTREQIMPACT,
    CHGMGMTREQISACCESSRESTRICTED,
    CHGMGMTREQISEMERGENCY,
    CHGMGMTREQLEADINGOBJECT,
    CHGMGMTREQLEADINGOBJECTLOC,
    CHGMGMTREQLEADINGOBJECTLOCNAME,
    CHGMGMTREQLEADINGOBJNAME,
    CHGMGMTREQLEADINGOBJTYPE,
    CHGMGMTREQMAINPLANT,
    CHGMGMTREQMAINPLANTUUID,
    CHGMGMTREQOPLSTARTDATE,
    CHGMGMTREQREPORTEDBYBP,
    CHGMGMTREQREPORTEDDATE,
    CHGMGMTREQREVERSALDATE,
    CHGMGMTREQSTATUS,
    CHGMGMTREQSTATUSCRITICALITY,
    CHGMGMTREQTYPE,
    CHGMGMTREQUEST,
    CHGMGMTUSERSTATUS1,
    CHGMGMTUSERSTATUS2,
    CHGMGMTUSERSTATUS3,
    CHGMGMTUSERSTATUS4,
    CHGMGMTUSERSTATUS5,
    COUNTRY,
    PRIMARY KEY (CHGMGMTREQUUID)
);