Repm_SalesQrdQ

DDL: REPM_SALESORDQ SQL: REPM_SALORD Type: view Package: RS_EPM_NW_REF_CDS
6 Fields 1 Data Sources

Sales Order Details Query View

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

Data Sources (1)

SourceAliasJoin Type
REPM_DepSalesOrderC depsalord from

Parameters (1)

NameTypeDefault
p_cutoff_date sydatum

Annotations (6)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
DepartmentName Department Name
DateChanged REPM_DepSalesOrderC DateChanged
DepartmentID REPM_DepSalesOrderC DepartmentID Department Name
EmployeeName REPM_DepSalesOrderC EmployeeName
TotalGrossAmount REPM_DepSalesOrderC TotalGrossAmount Total Gross Amount
TransactionCurrency REPM_DepSalesOrderC TransactionCurrency Transaction Currency

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_SalesQrdQ.
-- 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_SALORD
-- Parameters: p_cutoff_date : sydatum

CREATE VIEW Repm_SalesQrdQ AS
SELECT
  depsalord._Department.DepartmentName AS DepartmentName,
  depsalord.DateChanged AS DateChanged,
  depsalord.DepartmentID AS DepartmentID,
  depsalord.EmployeeName AS EmployeeName,
  depsalord.TotalGrossAmount AS TotalGrossAmount,
  depsalord.TransactionCurrency AS TransactionCurrency
FROM REPM_DepSalesOrderC AS depsalord
;

Learn More