biuan SAP® BUSINESS ONE SDK
DTW Departments
API Departments Service / Department
OUDP - Departments Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodeInt
6
PRIMARYYes
Name KEY UNIQUEDepartments NamenVarChar
20
NAMEYes
RemarksDescriptionnVarChar
100
UserSignUser SignatureInt
6OUSR
Users
FatherParent DepartmentnVarChar
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates