REPM_SalesOrderAnalysisQ1

DDL: REPM_SALESORDERANALYSISQ1 SQL: REPM_SOANLYQ11 Type: view Package: RS_EPM_NW_CONTENT_CDS
6 Fields 1 Data Sources

Sales Order Analysis Query View

REPM_SalesOrderAnalysisQ1 is a CDS View that provides data about "Sales Order Analysis Query View" in SAP S/4HANA. It reads from 1 data source (REPM_SalesOrderAnalysisC1) and exposes 6 fields. Part of development package RS_EPM_NW_CONTENT_CDS.

Data Sources (1)

SourceAliasJoin Type
REPM_SalesOrderAnalysisC1 SO from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName REPM_SOANLYQ11 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.query true view
EndUserText.label Sales Order Analysis Query View view
OData.publish true view

Fields (6)

KeyFieldSource TableSource FieldDescription
Customer REPM_SalesOrderAnalysisC1 Customer Sold-to Party
OverallStatus REPM_SalesOrderAnalysisC1 OverallStatus Status Criticality
TransactionCurrency REPM_SalesOrderAnalysisC1 TransactionCurrency Transaction Currency
ClosedSOGrossAmt REPM_SalesOrderAnalysisC1 ClosedSOGrossAmt Gross value
OpenSOGrossAmt REPM_SalesOrderAnalysisC1 OpenSOGrossAmt Gross value
OpenSOID REPM_SalesOrderAnalysisC1 SalesOrder Sales Order

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_SalesOrderAnalysisQ1.
-- 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_SOANLYQ11

CREATE VIEW REPM_SalesOrderAnalysisQ1 AS
SELECT
  SO.Customer AS Customer,
  SO.OverallStatus AS OverallStatus,
  SO.TransactionCurrency AS TransactionCurrency,
  SO.ClosedSOGrossAmt AS ClosedSOGrossAmt,
  SO.OpenSOGrossAmt AS OpenSOGrossAmt,
  SO.SalesOrder AS OpenSOID
FROM REPM_SalesOrderAnalysisC1 AS SO
;

Learn More