|
|
API OUDO / / User Objects MD
OUDO - User-Defined Object Table
User Objects MD UserObjectsMD Object· Table: OUDO
User Tables OUTB SQL Table
Workflow Manager OWMG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 20 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Name | nVarChar | 100 | |||||
| TableName KEY UNIQUE | Table Name | nVarChar | 19 | OUTB User Tables | TABLE | Yes | ||
| LogTable | Log Table Name | nVarChar | 19 | |||||
| TYPE | Object Type | VarChar | 1) Master Data 3) Document | 1 | 1 | |||
| MngSeries | Manage Series | VarChar | Y) Yes N) No | 1 | N | |||
| CanDelete | Delete | VarChar | Y) Yes N) No | 1 | Y | |||
| CanClose | Close | VarChar | Y) Yes N) No | 1 | N | |||
| CanCancel | Cancel | VarChar | Y) Yes N) No | 1 | N | |||
| ExtName | Extension Name | nVarChar | 127 | |||||
| CanFind | Find | VarChar | Y) Yes N) No | 1 | N | |||
| CanYrTrnsf | Year Transfer | VarChar | Y) Yes N) No | 1 | N | |||
| CanDefForm | Create Default Form | VarChar | Y) Yes N) No | 1 | N | |||
| CanLog | Log | VarChar | Y) Yes N) No | 1 | N | |||
| OvrWrtDll | Overwrite DLL File | VarChar | Y) Yes N) No | 1 | Y | |||
| UIDFormat | Unique Form ID Format | VarChar | Y) Yes N) No | 1 | Y | |||
| CanArchive | Archive | VarChar | 1 | N | ||||
| MenuItem | Specify Menu Item | VarChar | Y) Yes N) No | 1 | N | |||
| MenuCapt | Menu Caption | nVarChar | 127 | |||||
| FatherMenu | Parent Menu ID | Int | 11 | |||||
| Position | Menu Position | Int | 6 | |||||
| CanNewForm | Create Enhanced Form | VarChar | 1 | Y | ||||
| IsRebuild | If Needed, Rebuild New Form | VarChar | 1 | Y | ||||
| NewFormSrf | Enhanced Form: SRF File | Text | 16 | |||||
| MenuUid | Menu UID | nVarChar | 32 | |||||
| LstUpdDate | Last Update Date | Date | 8 | |||||
| LstUpdTime | Last Update Time | Int | 11 | |||||
| CanApprove | Approve | VarChar | Y) Yes N) No | 1 | N | |||
| TemplateID | Workflow Template ID | Int | 11 | OWMG Workflow Manager |
Table relationship map
SELECT statement
SELECT
OUDO.Code AS 'Code',
OUDO.Name AS 'Name',
OUDO.TableName AS 'Table Name',
OUDO.LogTable AS 'Log Table Name',
OUDO.TYPE AS 'Object Type',
OUDO.MngSeries AS 'Manage Series',
OUDO.CanDelete AS 'Delete',
OUDO.CanClose AS 'Close',
OUDO.CanCancel AS 'Cancel',
OUDO.ExtName AS 'Extension Name',
OUDO.CanFind AS 'Find',
OUDO.CanYrTrnsf AS 'Year Transfer',
OUDO.CanDefForm AS 'Create Default Form',
OUDO.CanLog AS 'Log',
OUDO.OvrWrtDll AS 'Overwrite DLL File',
OUDO.UIDFormat AS 'Unique Form ID Format',
OUDO.CanArchive AS 'Archive',
OUDO.MenuItem AS 'Specify Menu Item',
OUDO.MenuCapt AS 'Menu Caption',
OUDO.FatherMenu AS 'Parent Menu ID',
OUDO.Position AS 'Menu Position',
OUDO.CanNewForm AS 'Create Enhanced Form',
OUDO.IsRebuild AS 'If Needed, Rebuild New Form',
OUDO.NewFormSrf AS 'Enhanced Form: SRF File',
OUDO.MenuUid AS 'Menu UID',
OUDO.LstUpdDate AS 'Last Update Date',
OUDO.LstUpdTime AS 'Last Update Time',
OUDO.CanApprove AS 'Approve',
OUDO.TemplateID AS 'Workflow Template ID'
FROM OUDO AS OUDO
Related information
User Objects MD UserObjectsMD Object· Table: OUDO
The UserObjectsMD object represents the registration data settings, such as table name and supported services, of a user defined object.
This object enables you to:
Add a user define object.
Retrieve a user define object by its key....
User Tables OUTB SQL Table
Workflow Manager OWMG SQL Table
UserObjectsMD
Enumeration
Method
Object
Property
CanApprove
DB
CanCancel
DB
CanClose
DB
CanDelete
DB
CanFind
DB
CanLog
DB
Code
DB
FatherMenuID
DB
FormSRF
DB
LogTableName
DB
ManageSeries
DB
MenuCaption
DB
MenuItem
DB
MenuUID
DB
Name
DB
ObjectType
DB
Position
DB
TableName
DB
TemplateID
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
