V_OP

12 Fields 5 CDS Views

V_OP is an SAP database table in S/4HANA. It contains 12 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_LGN_JOB_FOR_USER view from Get Last Logon Time for Stepuser
SAIS_JOB_LIST view from Get AIS related job (step) list
SAPJ_V_SPOOLREQS view inner spool requests created by application jobs
SUSR_IS_LGN_JOB_FOR_USR view inner Get Last Logon Time for Stepuser
SUSR_IS_LGN_JOB_FOR_USR_DETAIL view from Get details to last logon date of Stepuser

Fields (12)

KeyField CDS FieldsUsed in Views
KEY authcknam bname 3
KEY jobcount jobid 1
KEY jobname jobname 1
KEY stepcount stepcount 1
enddate enddate 1
endtime endtime 1
periodic periodic 1
sdlstrtdt next_dat 1
sdlstrttm next_tim 1
status jobstatus 1
strtdate exec_dat 1
strttime exec_tim 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 V_OP (
    AUTHCKNAM,
    JOBCOUNT,
    JOBNAME,
    STEPCOUNT,
    ENDDATE,
    ENDTIME,
    PERIODIC,
    SDLSTRTDT,
    SDLSTRTTM,
    STATUS,
    STRTDATE,
    STRTTIME,
    PRIMARY KEY (AUTHCKNAM, JOBCOUNT, JOBNAME, STEPCOUNT)
);

Learn More