REPM_DepSalesOrderQ

DDL: REPM_DEPTSALESORDERQ SQL: REPM_DEPSOQ Type: view
13 Fields 1 Data Sources

Query View

REPM_DepSalesOrderQ is a CDS View that provides data about "Query View" in SAP S/4HANA. It reads from 1 data source (REPM_DepSalesOrderC) and exposes 13 fields with key field DepartmentID.

Data Sources (1)

SourceAliasJoin Type
REPM_DepSalesOrderC REPM_DepSalesOrderC from

Annotations (5)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DepartmentID REPM_DepSalesOrderC DepartmentID Department Name
DepartmentName REPM_DepSalesOrderC DepartmentName
LifeCycleStatus REPM_DepSalesOrderC LifeCycleStatus Life Cycle Status
SalesOrderLifeCycleStatusName REPM_DepSalesOrderC SalesOrderLifeCycleStatusName
EmployeeName REPM_DepSalesOrderC EmployeeName Employee Name
TotalGrossAmount REPM_DepSalesOrderC TotalGrossAmount Total Gross Amount
TransactionCurrency REPM_DepSalesOrderC TransactionCurrency Transaction Currency
SalesOrderID REPM_DepSalesOrderC SalesOrderID Sales Order ID
CustomerName REPM_DepSalesOrderC CustomerName Customer Name
CustomerEmailID REPM_DepSalesOrderC CustomerEmailID Customer Email ID
EmployeeEmailID REPM_DepSalesOrderC EmployeeEmailID Employee Email ID
EmployeePhoneNo REPM_DepSalesOrderC EmployeePhoneNo Employee Phone Numnber
EmployeeCity REPM_DepSalesOrderC EmployeeCity Employee City

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_DepSalesOrderQ.
-- 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_DEPSOQ

CREATE VIEW REPM_DepSalesOrderQ AS
SELECT
  REPM_DepSalesOrderC.DepartmentID AS DepartmentID,
  REPM_DepSalesOrderC.DepartmentName AS DepartmentName,
  REPM_DepSalesOrderC.LifeCycleStatus AS LifeCycleStatus,
  REPM_DepSalesOrderC.SalesOrderLifeCycleStatusName AS SalesOrderLifeCycleStatusName,
  REPM_DepSalesOrderC.EmployeeName AS EmployeeName,
  REPM_DepSalesOrderC.TotalGrossAmount AS TotalGrossAmount,
  REPM_DepSalesOrderC.TransactionCurrency AS TransactionCurrency,
  REPM_DepSalesOrderC.SalesOrderID AS SalesOrderID,
  REPM_DepSalesOrderC.CustomerName AS CustomerName,
  REPM_DepSalesOrderC.CustomerEmailID AS CustomerEmailID,
  REPM_DepSalesOrderC.EmployeeEmailID AS EmployeeEmailID,
  REPM_DepSalesOrderC.EmployeePhoneNo AS EmployeePhoneNo,
  REPM_DepSalesOrderC.EmployeeCity AS EmployeeCity
FROM REPM_DepSalesOrderC
;

Learn More