P_SM_BasicRuntimeData

DDL: P_SM_BASICRUNTIMEDATA SQL: PSMBSCRTMDATA Type: view
28 Fields 1 Data Sources

Schedule Manager main runtime data

P_SM_BasicRuntimeData is a CDS View that provides data about "Schedule Manager main runtime data" in SAP S/4HANA. It reads from 1 data source (smmain) and exposes 28 fields with key field id.

Data Sources (1)

SourceAliasJoin Type
smmain smmain from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PSMBSCRTMDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Schedule Manager main runtime data view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
idtype idtype Type
sdate sdate Valid From
stime stime Time
edate edate To-Date
etime etime TIME Data Element for SYST
uname uname User Name
aplstat aplstat Job Status
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
masterid masterid Master ID
wf_witem wf_witem Work Item ID
function function Unit Func.
tcode tcode Undefined range (can be used for patch levels)
activity activity VAT Activity
variante variante Variant
repid repid Program Name
application application UI Application
testflag testflag Test Run
masterappl masterappl Application
batchflag batchflag Batch flag
selkritflag selkritflag Select.criteria
messageflag messageflag Messages
statusflag statusflag Status
specificflag specificflag Appl. Data
extflag extflag Extract
wfflag wfflag WF Data
worklistflag worklistflag Worklist
onelistflag onelistflag Basic List

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SM_BasicRuntimeData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PSMBSCRTMDATA

CREATE VIEW P_SM_BasicRuntimeData AS
SELECT
  id,
  idtype,
  sdate,
  stime,
  edate,
  etime,
  uname,
  aplstat,
  timestamp,
  masterid,
  wf_witem,
  function,
  tcode,
  activity,
  variante,
  repid,
  application,
  testflag,
  masterappl,
  batchflag,
  selkritflag,
  messageflag,
  statusflag,
  specificflag,
  extflag,
  wfflag,
  worklistflag,
  onelistflag
FROM smmain
;

Learn More