REPM_DEPSALESORDERC

CDS View
14 Fields 3 CDS Views

Department Sales Order

REPM_DEPSALESORDERC is a CDS View in S/4HANA. Department Sales Order. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
REPM_DepSalesOrderQ view from Query View
Repm_SalesQrdQ view from Sales Order Details Query View
Repm_SalesQrdTestQ view from Sales Order Details Query View

Fields (14)

KeyField CDS FieldsUsed in Views
KEY DepartmentID DepartmentID 2
CustomerEmailID CustomerEmailID 1
CustomerName CustomerName 1
DateChanged DateChanged 2
DepartmentName DepartmentName 1
EmployeeCity EmployeeCity 1
EmployeeEmailID EmployeeEmailID 1
EmployeeName EmployeeName 3
EmployeePhoneNo EmployeePhoneNo 1
LifeCycleStatus LifeCycleStatus 1
SalesOrderID SalesOrderID 1
SalesOrderLifeCycleStatusName SalesOrderLifeCycleStatusName 1
TotalGrossAmount TotalGrossAmount 3
TransactionCurrency TransactionCurrency 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Department Sales Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE REPM_DEPSALESORDERC (
    DEPARTMENTID,
    CUSTOMEREMAILID,
    CUSTOMERNAME,
    DATECHANGED,
    DEPARTMENTNAME,
    EMPLOYEECITY,
    EMPLOYEEEMAILID,
    EMPLOYEENAME,
    EMPLOYEEPHONENO,
    LIFECYCLESTATUS,
    SALESORDERID,
    SALESORDERLIFECYCLESTATUSNAME,
    TOTALGROSSAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (DEPARTMENTID)
);

Learn More