I_CHGMGMTREQWORKLIST

CDS View
51 Fields 4 CDS Views

Change Management Request Worklist

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_ChgMgmtReqWorklist view from CONSUMPTION Manage Change Requests
I_ChemicalApprovalRequestC view_entity from COMPOSITE Chemical Approval Request - Cube
I_ChgMgmtRequestCube view from COMPOSITE Change Management Request Cube
I_MyChemicalApprovalRequest view_entity from COMPOSITE My Chemical Approval Requests

Fields (51)

KeyField CDS FieldsUsed in Views
KEY ChgMgmtReqUUID ChgMgmtReqUUID 2
_ChgMgmtDigitalSgntrSts _ChgMgmtDigitalSgntrSts 1
_ChgMgmtReqCategory _ChgMgmtReqCategory 1
_ChgMgmtReqDuration _ChgMgmtReqDuration 1
_ChgMgmtReqDurationText _ChgMgmtReqDurationText 1
_ChgMgmtReqEnteredByBP _ChgMgmtReqEnteredByBP 1
_ChgMgmtReqImpact _ChgMgmtReqImpact 1
_ChgMgmtReqImpactText _ChgMgmtReqImpactText 1
_ChgMgmtReqLeadingObject _ChgMgmtReqLeadingObject 2
_ChgMgmtReqLeadingObjTypeText _ChgMgmtReqLeadingObjTypeText 1
_ChgMgmtReqMainPlant _ChgMgmtReqMainPlant 2
_ChgMgmtReqMainPlantText _ChgMgmtReqMainPlantText 1
_ChgMgmtReqReportedByBP _ChgMgmtReqReportedByBP 1
_ChgMgmtReqReporter _ChgMgmtReqReporter 1
_ChgMgmtReqStatus _ChgMgmtReqStatus 1
_ChgMgmtReqType _ChgMgmtReqType 2
_CountryText _CountryText 1
_EnteredBy _EnteredBy 1
ChgMgmtDigitalSgntrStatus ChgMgmtDigitalSgntrStatus 1
ChgMgmtReqApprovalDate ChgMgmtReqApprovalDate 1
ChgMgmtReqAuthorizationGroup ChgMgmtReqAuthorizationGroup 2
ChgMgmtReqCategory ChgMgmtReqCategory 1
ChgMgmtReqCreationDate ChgMgmtReqCreationDate 1
ChgMgmtReqDescriptionText ChgMgmtReqDescriptionText 2
ChgMgmtReqDurationCode ChgMgmtReqDurationCode 1
ChgMgmtReqEnteredByBP ChgMgmtReqEnteredByBP 1
ChgMgmtReqEnteredByUser ChgMgmtReqEnteredByUser 1
ChgMgmtReqExecStartDate ChgMgmtReqExecStartDate 1
ChgMgmtReqImpact ChgMgmtReqImpact 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 2
ChgMgmtRequest ChgMgmtRequest 2
ChgMgmtUserStatus1 ChgMgmtUserStatus1 1
ChgMgmtUserStatus2 ChgMgmtUserStatus2 2
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,
    _CHGMGMTDIGITALSGNTRSTS,
    _CHGMGMTREQCATEGORY,
    _CHGMGMTREQDURATION,
    _CHGMGMTREQDURATIONTEXT,
    _CHGMGMTREQENTEREDBYBP,
    _CHGMGMTREQIMPACT,
    _CHGMGMTREQIMPACTTEXT,
    _CHGMGMTREQLEADINGOBJECT,
    _CHGMGMTREQLEADINGOBJTYPETEXT,
    _CHGMGMTREQMAINPLANT,
    _CHGMGMTREQMAINPLANTTEXT,
    _CHGMGMTREQREPORTEDBYBP,
    _CHGMGMTREQREPORTER,
    _CHGMGMTREQSTATUS,
    _CHGMGMTREQTYPE,
    _COUNTRYTEXT,
    _ENTEREDBY,
    CHGMGMTDIGITALSGNTRSTATUS,
    CHGMGMTREQAPPROVALDATE,
    CHGMGMTREQAUTHORIZATIONGROUP,
    CHGMGMTREQCATEGORY,
    CHGMGMTREQCREATIONDATE,
    CHGMGMTREQDESCRIPTIONTEXT,
    CHGMGMTREQDURATIONCODE,
    CHGMGMTREQENTEREDBYBP,
    CHGMGMTREQENTEREDBYUSER,
    CHGMGMTREQEXECSTARTDATE,
    CHGMGMTREQIMPACT,
    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)
);

Learn More