rrp_e_GrPo

DDL: RRP_DDL_GR_PO SQL: RRP_V_GR_PO Type: view

RRP: Select Purchase Orders as Goods Receipts

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

Data Sources (8)

SourceAliasJoin Type
wrrp_ctrl ctrl inner
wrrp_doc_type doc_type from
eket eket inner
ekko ekko inner
ekpo ekpo inner
wrrp_kntp_sbkz knttp_sobkz inner
wrrp_paramset po_param inner
V_WRF_STORLOC_CLASS storloc_class left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName RRP_V_GR_PO view
EndUserText.label RRP: Select Purchase Orders 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 ekpo werks Receiving Plant
matnr ekpo 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_GrPo.
-- 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_PO

CREATE VIEW rrp_e_GrPo AS
SELECT
  ctrl.process_id AS process_id,
  ekpo.werks AS werks,
  ekpo.matnr AS matnr
FROM wrrp_doc_type AS doc_type
INNER JOIN ekko ON /* join condition not captured in parsed metadata */
INNER JOIN ekpo 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 po_param ON /* join condition not captured in parsed metadata */
INNER JOIN eket 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 */
;