SDMCC_JOBREQ

Transparent Table Application Table
28 Fields 1 CDS Views

SD Mass Change Cockpit: Job Request

SDMCC_JOBREQ is an SAP database table in S/4HANA. SD Mass Change Cockpit: Job Request. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SDMassChgCkptMassChgReqBsc view from BASIC Mass Change of Sales Doc Chg Request

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY slsdocmasschangerequestuuid SD_MCC_JOB_UUID Job ID
applicationjobname BTCJOB Job Name
applicationjob BTCJOBCNT Job No.
slsdocmasschangereqstatus SD_MCC_JOB_STATUS Job Status
slsdocmasschangerequestrefuuid SD_MCC_JOB_UUID Job ID
createdbyuser CREATEDBYUSER Created by
timezoneid SD_MCC_JOB_ORGIN_TZONE Time Zone
slsdocmasschgreqplndstrtdte BTCSDATE Start Date
slsdocmasschgreqplndstrttme BTCSTIME Start Time
slsdocmasschgreqcompltndte BTCXDATE Execution Date
slsdocmasschgreqcompltntme BTCXTIME Execution Date
lastchangedbyuser LASTCHANGEDBYUSER Changed by
lastchangedatetime LAST_CHANGED_DATE_TIME Last Changed On
sddocumentcategory SD_MCC_DOCUMENT_CATEGORY Document Cat.
slsdocmasschgentitytype SD_MCC_ENTITY_TYPE Entity Type
slsdocmasschgentitylevel SD_MCC_ENTITY_LEVEL Entity Level
slsdocmasschgactionid SD_MCC_ACTION Action
slsdocmasschgactioncategory SD_MCC_ACTION_CATEGORY Action Category
slsdocmasschangejobname SD_MCC_JOB_NAME Job Name
slsdocmasschgreqlogmsgnumber SYMSGNO Message Number
slsdocmasschgreqlogmsgclass SYMSGID Message Class
slsdocmasschgreqlogmsgtype SYMSGTY Message Type
slsdocmasschgreqlgmsgvarbl1txt SYMSGV Message Variable
slsdocmasschgreqlgmsgvarbl2txt SYMSGV Message Variable
slsdocmasschgreqlgmsgvarbl3txt SYMSGV Message Variable
slsdocmasschgreqlgmsgvarbl4txt SYMSGV Message Variable
slsdocmasschgreqismnllycmplt SD_MCC_MANUALLY_COMPLETED Mnlly Cmplt

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.

-- SD Mass Change Cockpit: Job Request
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDMCC_JOBREQ (
    MANDT,                           -- Client [MANDT]
    SLSDOCMASSCHANGEREQUESTUUID,     -- Job ID [SD_MCC_JOB_UUID]
    APPLICATIONJOBNAME,              -- Job Name [BTCJOB]
    APPLICATIONJOB,                  -- Job No. [BTCJOBCNT]
    SLSDOCMASSCHANGEREQSTATUS,       -- Job Status [SD_MCC_JOB_STATUS]
    SLSDOCMASSCHANGEREQUESTREFUUID,  -- Job ID [SD_MCC_JOB_UUID]
    CREATEDBYUSER,                   -- Created by [CREATEDBYUSER]
    TIMEZONEID,                      -- Time Zone [SD_MCC_JOB_ORGIN_TZONE]
    SLSDOCMASSCHGREQPLNDSTRTDTE,     -- Start Date [BTCSDATE]
    SLSDOCMASSCHGREQPLNDSTRTTME,     -- Start Time [BTCSTIME]
    SLSDOCMASSCHGREQCOMPLTNDTE,      -- Execution Date [BTCXDATE]
    SLSDOCMASSCHGREQCOMPLTNTME,      -- Execution Date [BTCXTIME]
    LASTCHANGEDBYUSER,               -- Changed by [LASTCHANGEDBYUSER]
    LASTCHANGEDATETIME,              -- Last Changed On [LAST_CHANGED_DATE_TIME]
    SDDOCUMENTCATEGORY,              -- Document Cat. [SD_MCC_DOCUMENT_CATEGORY]
    SLSDOCMASSCHGENTITYTYPE,         -- Entity Type [SD_MCC_ENTITY_TYPE]
    SLSDOCMASSCHGENTITYLEVEL,        -- Entity Level [SD_MCC_ENTITY_LEVEL]
    SLSDOCMASSCHGACTIONID,           -- Action [SD_MCC_ACTION]
    SLSDOCMASSCHGACTIONCATEGORY,     -- Action Category [SD_MCC_ACTION_CATEGORY]
    SLSDOCMASSCHANGEJOBNAME,         -- Job Name [SD_MCC_JOB_NAME]
    SLSDOCMASSCHGREQLOGMSGNUMBER,    -- Message Number [SYMSGNO]
    SLSDOCMASSCHGREQLOGMSGCLASS,     -- Message Class [SYMSGID]
    SLSDOCMASSCHGREQLOGMSGTYPE,      -- Message Type [SYMSGTY]
    SLSDOCMASSCHGREQLGMSGVARBL1TXT,  -- Message Variable [SYMSGV]
    SLSDOCMASSCHGREQLGMSGVARBL2TXT,  -- Message Variable [SYMSGV]
    SLSDOCMASSCHGREQLGMSGVARBL3TXT,  -- Message Variable [SYMSGV]
    SLSDOCMASSCHGREQLGMSGVARBL4TXT,  -- Message Variable [SYMSGV]
    SLSDOCMASSCHGREQISMNLLYCMPLT,    -- Mnlly Cmplt [SD_MCC_MANUALLY_COMPLETED]
    PRIMARY KEY (MANDT, SLSDOCMASSCHANGEREQUESTUUID)
);

Learn More