Repm_SalesQrdTestQ

DDL: REPM_SALESORD_TESTQ SQL: REPM_SALORDTQ Type: view Package: RS_EPM_NW_REF_CDS
6 Fields 1 Data Sources

Sales Order Details Query View

Repm_SalesQrdTestQ 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

Annotations (5)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
DepartmentName Department Name
DateChanged REPM_DepSalesOrderC DateChanged
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_SalesQrdTestQ.
-- 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_SALORDTQ

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

Learn More