SAP MSQCCMSJOB table - MS SQL server list of CCMS planned tasks details in SAP


SAP MSQCCMSJOB table summary

Object Name: MSQCCMSJOB
Dictionary Type: Structure
Description: MS SQL server list of CCMS planned tasks


Field list for MSQCCMSJOB table on an S/4 SAP system

Details
MSQCCMSJOB-JOB_NAME table field - MS SQl server - name of the job

Description: MS SQl server - name of the job
Field Name: JOB_NAME
Data Element: MSQJOBNAME
Data Type: CHAR
length (Dec): 100(0)
Check table:
Conversion Routine:
Domain Name: CHAR100
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOB_NAME

MSQCCMSJOB-OWNER table field - Database user name/ Owner of sql agent job

Description: Database user name/ Owner of sql agent job
Field Name: OWNER
Data Element: MSQUNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OWNER

MSQCCMSJOB-DBNAME table field - Database name

Description: Database name
Field Name: DBNAME
Data Element: MSSDB
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSQCCMSJOB-JOBTYPE table field - MS SQL server - Name of the subsystem used for job execution

Description: MS SQL server - Name of the subsystem used for job execution
Field Name: JOBTYPE
Data Element: MSQSUBSYS
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOBTYPE

MSQCCMSJOB-COMMAND table field - MS SQL server - command executed by the subsytem

Description: MS SQL server - command executed by the subsytem
Field Name: COMMAND
Data Element: MSQJOBCMD
Data Type: CHAR
length (Dec): 520(0)
Check table:
Conversion Routine:
Domain Name: CHAR520
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND

MSQCCMSJOB-RUNDATE table field - MS SQL server - the date to begin executing the job

Description: MS SQL server - the date to begin executing the job
Field Name: RUNDATE
Data Element: MSQBEGRUDT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNDATE

MSQCCMSJOB-RUNTIME table field - MS SQL server - the time to start executing the server job

Description: MS SQL server - the time to start executing the server job
Field Name: RUNTIME
Data Element: MSQBEGRUTM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNTIME

MSQCCMSJOB-RUNSTATUS table field - MS SQL server - the status of the job's execution

Description: MS SQL server - the status of the job's execution
Field Name: RUNSTATUS
Data Element: MSQJOBSTAT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNSTATUS

MSQCCMSJOB-LSTRUNDATE table field - Sql agent job - Last run Date

Description: Sql agent job - Last run Date
Field Name: LSTRUNDATE
Data Element: MSSLSTRNDT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LSTRUNDATE

MSQCCMSJOB-LSTRUNTIME table field - Agent job's last run time

Description: Agent job's last run time
Field Name: LSTRUNTIME
Data Element: MSSLSTRNTM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LSTRUNTIME

MSQCCMSJOB-NEXTRUNTM table field - SQL Agent Job's Next Run Time

Description: SQL Agent Job's Next Run Time
Field Name: NEXTRUNTM
Data Element: MSSNXRNTM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEXTRUNTM

MSQCCMSJOB-NEXTRUNDT table field - Sql agent job - Next run Date

Description: Sql agent job - Next run Date
Field Name: NEXTRUNDT
Data Element: MSSNXRNDT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEXTRUNDT

MSQCCMSJOB-JOBID table field - MS SQL Server job ID

Description: MS SQL Server job ID
Field Name: JOBID
Data Element: MSQJOBID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOBID

MSQCCMSJOB-ENABLED table field - MS SQL server - job enable status for execution

Description: MS SQL server - job enable status for execution
Field Name: ENABLED
Data Element: MSQJOBENA
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ENABLED

MSQCCMSJOB-STATUSDESC table field - Sql Agent Job status description

Description: Sql Agent Job status description
Field Name: STATUSDESC
Data Element: MSSSTADESC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUSDESC


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table