|
|
DTW Departments
API Departments Service / Department
OUDP - Departments Table
Department Department Object· Table: OUDP
Parent: Departments Service DepartmentsService Service· Table: OUDP
Departments Service DepartmentsService Service· Table: OUDP
OUDP SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY UNIQUE | Departments Name | nVarChar | 20 | NAME | Yes | |||
| Remarks | Description | nVarChar | 100 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Father | Parent Department | nVarChar | 20 |
Table relationship map
SELECT statement
SELECT
OUDP.Code AS 'Code',
OUDP.Name AS 'Departments Name',
OUDP.Remarks AS 'Description',
OUDP.UserSign AS 'User Signature',
OUDP.Father AS 'Parent Department'
FROM OUDP AS OUDP
Related information
Department Department Object· Table: OUDP
Represents a department that can be assigned to a user or employee.
Source table: OUDP
Mandatory properties: Name
Parent: Departments Service DepartmentsService Service· Table: OUDP Departments Service DepartmentsService Service· Table: OUDP
The DepartmentsService service enables you to add, look up and remove departments in the departments master data table. Users and employees can be assigned to departments.
To see the list of departments, do one of the following:
Select...
OUDP SQL Table
DepartmentsService
Object
Department
Method
Property
Code
DB
Description
DB
Name
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
