|
|
API CUFD / User Fields MD
CUFD - User Fields - Description Table
User Fields MD UserFieldsMD Object· Table: CUFD
CUFD SQL Table
User Tables OUTB SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TableID KEY UNIQUE | Table | nVarChar | 20 | ALIAS | Yes |
|---|---|---|---|---|---|---|---|---|
| FieldID | Field | Int | 6 | |||||
| AliasID | Title | nVarChar | 18 | |||||
| Descr | Description | nVarChar | 30 | |||||
| TypeID | Type | VarChar | 1 | |||||
| EditType | Edit Type | VarChar | 1 | |||||
| SizeID | Size | Int | 6 | |||||
| EditSize | Edit Size | Int | 6 | |||||
| Dflt | Default | nVarChar | 127 | |||||
| NotNull | Required Entry Field | VarChar | Y) Yes N) No | 1 | N | |||
| IndexID | Create Index | VarChar | Y) Yes N) No | 1 | N | |||
| RTable | Linked Table | nVarChar | 20 | OUTB User Tables | ||||
| RField | Linked Field | Int | 6 | |||||
| Action | Action | VarChar | 1 | |||||
| Sys | System Defined? | VarChar | Y) Yes N) No | 1 | N | |||
| DfltDate | Default Date | Date | 8 | |||||
| RelUDO | Related UDO | nVarChar | 20 | |||||
| ValidRule | Validation Rule | nVarChar | 127 |
Table relationship map
SELECT statement
SELECT
CUFD.TableID AS 'Table',
CUFD.FieldID AS 'Field',
CUFD.AliasID AS 'Title',
CUFD.Descr AS 'Description',
CUFD.TypeID AS 'Type',
CUFD.EditType AS 'Edit Type',
CUFD.SizeID AS 'Size',
CUFD.EditSize AS 'Edit Size',
CUFD.Dflt AS 'Default',
CUFD.NotNull AS 'Required Entry Field',
CUFD.IndexID AS 'Create Index',
CUFD.RTable AS 'Linked Table',
CUFD.RField AS 'Linked Field',
CUFD.Action AS 'Action',
CUFD.Sys AS 'System Defined?',
CUFD.DfltDate AS 'Default Date',
CUFD.RelUDO AS 'Related UDO',
CUFD.ValidRule AS 'Validation Rule'
FROM CUFD AS CUFD
Related information
User Fields MD UserFieldsMD Object· Table: CUFD
UserFieldsMD is a business object that enables you to manage user-defined fields in user and system tables.
This object enables you to:
Add a user-defined field.
Retrieve a user-defined field from the database by its key.
Remove a...
CUFD SQL Table
User Tables OUTB SQL Table
UserFieldsMD
Enumeration
Method
Object
ValidValuesMD UFD1
Property
DefaultValue
DB
Description
DB
EditSize
DB
FieldID
DB
LinkedTable
DB
LinkedUDO
DB
Mandatory
DB
Size
DB
TableName
DB
Type
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
