P_SM_BasicBatchData

DDL: P_SM_BASICBATCHDATA SQL: PSMBSCBTCHDATA Type: view
8 Fields 1 Data Sources

Schedule Manager main batch data

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

Data Sources (1)

SourceAliasJoin Type
smbatch smbatch from

Annotations (5)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
logsys logsys Source system
idtype idtype Type
jobname jobname Name of Send Process
jobcount jobcount Job number
stepcount stepcount Step no.
status status Workflow Status
lstflg lstflg Spool 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_BasicBatchData.
-- 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: PSMBSCBTCHDATA

CREATE VIEW P_SM_BasicBatchData AS
SELECT
  id,
  logsys,
  idtype,
  jobname,
  jobcount,
  stepcount,
  status,
  lstflg
FROM smbatch
;

Learn More