STEP

STEP is an SAP database table in S/4HANA. It contains 30 fields.

Fields (30)

KeyField CDS FieldsUsed in Views
KEY db_key MDChgProcessStepUUID 17
KEY job_name jobname 1
KEY jobcount jobcount 1
KEY MDChgProcessStepUUID MDChgProcessStepUUID 2
KEY stepcount stepnr 1
adapter MDChgProcessStepAdapter 13
app_rc step_app_rc 1
appl_log_severity step_log_severity 1
finished_at MDChgProcessStepFinishDateTime 12
job_catalog_entry_name job_catalog_entry_name 1
job_run_has_results_ind step_has_results 1
job_run_log_intent job_run_log_intent 1
MasterDataChangeProcess MasterDataChangeProcess 1
MDChgProcessSrceObjectTypeCode MDChgProcessSrceObjectTypeCode 1
MDChgProcessStep MDChgProcessStep 2
MDChgProcessStepAdapter MDChgProcessStepAdapter 1
MDChgProcessStepType MDChgProcessStepType 2
MfgBuyOffAdhocStepDescription MfgBuyOffAdhocStepDescription 1
MfgBuyOffReferencedStep MfgBuyOffReferencedStep 1
parent_key MasterDataChangeProcessUUID 1
process_id MasterDataChangeProcess 13
started_at MDChgProcessStepStartDateTime 12
status MDChgProcessStepStatus,step_status 5
step_number MDChgProcessStep 13
step_start_date step_start_date 1
step_start_time step_start_time 1
step_type MDChgProcessStepType 13
ValueChainInstanceUUID ValueChainInstanceUUID 2
ValueChainStepPredecessorUUID ValueChainStepPredecessorUUID 2
ValueChainStepType ValueChainStepType 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STEP (
    DB_KEY,
    JOB_NAME,
    JOBCOUNT,
    MDCHGPROCESSSTEPUUID,
    STEPCOUNT,
    ADAPTER,
    APP_RC,
    APPL_LOG_SEVERITY,
    FINISHED_AT,
    JOB_CATALOG_ENTRY_NAME,
    JOB_RUN_HAS_RESULTS_IND,
    JOB_RUN_LOG_INTENT,
    MASTERDATACHANGEPROCESS,
    MDCHGPROCESSSRCEOBJECTTYPECODE,
    MDCHGPROCESSSTEP,
    MDCHGPROCESSSTEPADAPTER,
    MDCHGPROCESSSTEPTYPE,
    MFGBUYOFFADHOCSTEPDESCRIPTION,
    MFGBUYOFFREFERENCEDSTEP,
    PARENT_KEY,
    PROCESS_ID,
    STARTED_AT,
    STATUS,
    STEP_NUMBER,
    STEP_START_DATE,
    STEP_START_TIME,
    STEP_TYPE,
    VALUECHAININSTANCEUUID,
    VALUECHAINSTEPPREDECESSORUUID,
    VALUECHAINSTEPTYPE,
    PRIMARY KEY (DB_KEY, JOB_NAME, JOBCOUNT, MDCHGPROCESSSTEPUUID, STEPCOUNT)
);