rrp_e_GrPr

DDL: RRP_DDL_GR_PR SQL: RRP_V_GR_PR Type: view

RRP: Select Purchase Requisitions as Goods Receipts

rrp_e_GrPr is a CDS View that provides data about "RRP: Select Purchase Requisitions as Goods Receipts" in SAP S/4HANA. It reads from 6 data sources and exposes 3 fields.

Data Sources (6)

SourceAliasJoin Type
wrrp_ctrl ctrl inner
wrrp_doc_type doc_type from
eban eban inner
wrrp_kntp_sbkz knttp_sobkz inner
wrrp_paramset param inner
V_WRF_STORLOC_CLASS storloc_class left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName RRP_V_GR_PR view
EndUserText.label RRP: Select Purchase Requisitions as Goods Receipts view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
process_id wrrp_ctrl process_id Process Instance ID
werks eban werks Receiving Plant
matnr eban matnr Vehicle Model

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 rrp_e_GrPr.
-- 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: RRP_V_GR_PR

CREATE VIEW rrp_e_GrPr AS
SELECT
  ctrl.process_id AS process_id,
  eban.werks AS werks,
  eban.matnr AS matnr
FROM wrrp_doc_type AS doc_type
INNER JOIN eban ON /* join condition not captured in parsed metadata */
INNER JOIN wrrp_kntp_sbkz AS knttp_sobkz ON /* join condition not captured in parsed metadata */
INNER JOIN wrrp_ctrl AS ctrl ON /* join condition not captured in parsed metadata */
INNER JOIN wrrp_paramset AS param ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN V_WRF_STORLOC_CLASS AS storloc_class ON /* join condition not captured in parsed metadata */
;