/APE/C_ProcStepCondPreBuffered

DDL: /APE/C_PROCSTEPCONDPREBUFFERED Type: view BASIC
21 Fields 5 Data Sources 10 Associations

Process Step Condition

/APE/C_ProcStepCondPreBuffered is a Basic CDS View that provides data about "Process Step Condition" in SAP S/4HANA. It reads from 5 data sources (/ape/proc, /ape/prstp, /ape/proc, /ape/prstp, /ape/prstpcond) and exposes 21 fields with key field config_key. It has 10 associations to related views.

Data Sources (5)

SourceAliasJoin Type
/ape/proc PredProc left_outer
/ape/prstp PredStep left_outer
/ape/proc Proc inner
/ape/prstp Step inner
/ape/prstpcond StepCond from

Associations (10)

CardinalityTargetAliasCondition
[0..1] /ape/procid ProcId Proc.proc_id_uuid = ProcId.config_key
[0..1] /ape/procclus ProcCluster Proc.proc_cluster_uuid = ProcCluster.config_key
[0..1] /ape/version Version Proc.version_uuid = Version.config_key
[0..1] /ape/prstpid StepId Step.proc_step_id_uuid = StepId.config_key
[0..1] /ape/procid PredProcId PredProc.proc_id_uuid = PredProcId.config_key
[0..1] /ape/procclus PredProcCluster PredProc.proc_cluster_uuid = PredProcCluster.config_key
[0..1] /ape/version PredVersion PredProc.version_uuid = PredVersion.config_key
[0..1] /ape/prstpid PredStepId PredStep.proc_step_id_uuid = PredStepId.config_key
[0..1] /ape/procval LowProcVal StepCond.value_low_uuid = LowProcVal.config_key
[0..1] /ape/procval HighProcVal StepCond.value_high_uuid = HighProcVal.config_key

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_PRSTCNDPB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Process Step Condition view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY config_key /ape/prstpcond config_key Char
ape_root_key /ape/prstpcond ape_root_key
proc_cluster ProcCluster proc_cluster
proc_id ProcId proc_id Processing
version Version version XML Vers.
seq_no /ape/prstp seq_no Value Number
proc_step_id StepId proc_step_id
condition_no /ape/prstpcond condition_no
multiple /ape/prstp multiple Multiple Values
type /ape/prstp type Worklist Type
pred_proc_id PredProcId proc_id Processing
pred_version PredVersion version XML Vers.
pred_seq_no /ape/prstp seq_no Value Number
pred_type /ape/prstp type Worklist Type
status /ape/prstpcond status Workflow Status
operator /ape/prstpcond operator Type of OPTION component in row type of a Ranges type
proc_value_Low LowProcVal proc_value
source_step /ape/prstpcond source_step
mandatory /ape/prstpcond mandatory Yes/No
cardinality /ape/prstpcond cardinality Cardinality
link /ape/prstpcond link URL

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 /APE/C_ProcStepCondPreBuffered.
-- 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.

CREATE VIEW /APE/C_ProcStepCondPreBuffered AS
SELECT
  StepCond.config_key AS config_key,
  StepCond.ape_root_key AS ape_root_key,
  ProcCluster.proc_cluster AS proc_cluster,
  ProcId.proc_id AS proc_id,
  Version.version AS version,
  Step.seq_no AS seq_no,
  StepId.proc_step_id AS proc_step_id,
  StepCond.condition_no AS condition_no,
  Step.multiple AS multiple,
  Step.type AS type,
  PredProcId.proc_id AS pred_proc_id,
  PredVersion.version AS pred_version,
  PredStep.seq_no AS pred_seq_no,
  PredStep.type AS pred_type,
  StepCond.status AS status,
  StepCond.operator AS operator,
  LowProcVal.proc_value AS proc_value_Low,
  StepCond.source_step AS source_step,
  StepCond.mandatory AS mandatory,
  StepCond.cardinality AS cardinality,
  StepCond.link AS link
FROM /ape/prstpcond AS StepCond
INNER JOIN /ape/prstp AS Step ON /* join condition not captured in parsed metadata */
INNER JOIN /ape/proc AS Proc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ape/prstp AS PredStep ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ape/proc AS PredProc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ape/procid AS ProcId ON Proc.proc_id_uuid = ProcId.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procclus AS ProcCluster ON Proc.proc_cluster_uuid = ProcCluster.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/version AS Version ON Proc.version_uuid = Version.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/prstpid AS StepId ON Step.proc_step_id_uuid = StepId.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procid AS PredProcId ON PredProc.proc_id_uuid = PredProcId.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procclus AS PredProcCluster ON PredProc.proc_cluster_uuid = PredProcCluster.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/version AS PredVersion ON PredProc.version_uuid = PredVersion.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/prstpid AS PredStepId ON PredStep.proc_step_id_uuid = PredStepId.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procval AS LowProcVal ON StepCond.value_low_uuid = LowProcVal.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procval AS HighProcVal ON StepCond.value_high_uuid = HighProcVal.config_key  -- association [0..1]
;

Learn More