REPM_PurchaseOrderQ

DDL: REPM_PURCHASEORDERQ SQL: REPM_PURCHASEQ Type: view Package: RS_EPM_NW_CONTENT_CDS
5 Fields 1 Data Sources

Purchase Order Query View

REPM_PurchaseOrderQ is a CDS View that provides data about "Purchase Order Query View" in SAP S/4HANA. It reads from 1 data source (REPM_PurchaseOrderC) and exposes 5 fields. Part of development package RS_EPM_NW_CONTENT_CDS.

Data Sources (1)

SourceAliasJoin Type
REPM_PurchaseOrderC REPM_PurchaseOrderC from

Parameters (2)

NameTypeDefault
P_KeyDate sydate
hidden true

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName REPM_PURCHASEQ view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.query true view
EndUserText.label Purchase Order Query View view
OData.publish true view

Fields (5)

KeyFieldSource TableSource FieldDescription
GrossAmountInTransacCurrency REPM_PurchaseOrderC GrossAmountInTransacCurrency Gross Order Amount
CompanyName REPM_PurchaseOrderC CompanyName Comapny Name(EPM Demo)
TransactionCurrency REPM_PurchaseOrderC TransactionCurrency Transaction Currency
PurchaseOrder REPM_PurchaseOrderC PurchaseOrder Purchase Order
po_counter REPM_PurchaseOrderC po_counter Number Of PO created

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 REPM_PurchaseOrderQ.
-- 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: REPM_PURCHASEQ
-- Parameters: P_KeyDate : sydate, hidden : true

CREATE VIEW REPM_PurchaseOrderQ AS
SELECT
  REPM_PurchaseOrderC.GrossAmountInTransacCurrency AS GrossAmountInTransacCurrency,
  REPM_PurchaseOrderC.CompanyName AS CompanyName,
  REPM_PurchaseOrderC.TransactionCurrency AS TransactionCurrency,
  REPM_PurchaseOrderC.PurchaseOrder AS PurchaseOrder,
  REPM_PurchaseOrderC.po_counter AS po_counter
FROM REPM_PurchaseOrderC
;

Learn More