P_Bprrbsdflow

DDL: P_BPRRBSDFLOW SQL: PBARRBSD Type: view BASIC
6 Fields 1 Data Sources

P_Bprrbsdflow is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_SDDocumentMultiLevelProcFlow) and exposes 6 fields with key fields PrecedingDocument, PrecedingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentMultiLevelProcFlow I_SDDocumentMultiLevelProcFlow from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PBARRBSD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument I_SDDocumentMultiLevelProcFlow PrecedingDocument SD Document
KEY PrecedingDocumentItem I_SDDocumentMultiLevelProcFlow PrecedingDocumentItem Item
SubsequentDocument I_SDDocumentMultiLevelProcFlow SubsequentDocument SD Sched. Agmt
SubsequentDocumentItem I_SDDocumentMultiLevelProcFlow SubsequentDocumentItem Subsequent Item
CreationDate
CreationTime

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_Bprrbsdflow.
-- 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: PBARRBSD

CREATE VIEW P_Bprrbsdflow AS
SELECT
  I_SDDocumentMultiLevelProcFlow.PrecedingDocument AS PrecedingDocument,
  I_SDDocumentMultiLevelProcFlow.PrecedingDocumentItem AS PrecedingDocumentItem,
  I_SDDocumentMultiLevelProcFlow.SubsequentDocument AS SubsequentDocument,
  I_SDDocumentMultiLevelProcFlow.SubsequentDocumentItem AS SubsequentDocumentItem,
  max (I_SDDocumentMultiLevelProcFlow.CreationDate) AS CreationDate,
  max (I_SDDocumentMultiLevelProcFlow.CreationTime) AS CreationTime
FROM I_SDDocumentMultiLevelProcFlow
;

Learn More