rrp_e_GiPr

DDL: RRP_DDL_GI_PR SQL: RRP_V_GI_PR Type: view

RRP: Select Purchase Requisitions as Goods Issues

rrp_e_GiPr is a CDS View that provides data about "RRP: Select Purchase Requisitions as Goods Issues" in SAP S/4HANA. It reads from 5 data sources (wrrp_ctrl, wrrp_doc_type, eban, wrrp_paramset, V_WRF_STORLOC_CLASS) and exposes 3 fields.

Data Sources (5)

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

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName RRP_V_GI_PR view
EndUserText.label RRP: Select Purchase Requisitions as Goods Issues 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 reswk Supplying 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_GiPr.
-- 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_GI_PR

CREATE VIEW rrp_e_GiPr AS
SELECT
  ctrl.process_id AS process_id,
  eban.reswk 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_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 */
;