|
|
DTW Administration / Setup / Inventory / Cycle Count Determination
API Columns Preferences / Column Preferences
CPRF - Column Preferences Table
Column Preferences ColumnPreferences Object· Table: CPRF
Parent: Columns Preferences ColumnsPreferences Collection
Columns Preferences Params ColumnsPreferencesParams Object· Table: CPRF Parent: Form Preferences Service FormPreferencesService Service
Customized Template UICU SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | FormID | Form ID | nVarChar | 20 |
|---|---|---|---|---|---|---|---|---|
| ItemID | Item Number | nVarChar | 20 | |||||
| ColID | Column | nVarChar | 20 | |||||
| Width | Width | Int | 11 | |||||
| VisInForm | Visible in Form | VarChar | Y) Yes N) No | 1 | N | |||
| VisualIndx | Tabs Layout | Int | 11 | |||||
| EditInForm | Editable in Form | VarChar | Y) Yes N) No | 1 | N | |||
| VisInExpnd | Visible in Expanded | VarChar | Y) Yes N) No | 1 | N | |||
| ExpandIndx | Expanded Index | Int | 11 | |||||
| EditInEXP | Editable in Expanded | VarChar | Y) Yes N) No | 1 | N | |||
| Folded | Folder | VarChar | Y) Yes N) No | 1 | N | |||
| UserSign KEY UNIQUE | User Signature | Int | 6 | OUSR Users | PRIMARY | Yes | ||
| ExtDisable | Externally Disabled | VarChar | N) No Y) Yes | 1 | N | |||
| ExtInvsbl | Externally Invisible | VarChar | N) No Y) Yes | 1 | N | |||
| TPLId | Template ID | Int | 6 | UICU Customized Template | 0 |
Table relationship map
SELECT statement
SELECT
CPRF.FormID AS 'Form ID',
CPRF.ItemID AS 'Item Number',
CPRF.ColID AS 'Column',
CPRF.Width AS 'Width',
CPRF.VisInForm AS 'Visible in Form',
CPRF.VisualIndx AS 'Tabs Layout',
CPRF.EditInForm AS 'Editable in Form',
CPRF.VisInExpnd AS 'Visible in Expanded',
CPRF.ExpandIndx AS 'Expanded Index',
CPRF.EditInEXP AS 'Editable in Expanded',
CPRF.Folded AS 'Folder',
CPRF.UserSign AS 'User Signature',
CPRF.ExtDisable AS 'Externally Disabled',
CPRF.ExtInvsbl AS 'Externally Invisible',
CPRF.TPLId AS 'Template ID'
FROM CPRF AS CPRF
Related information
Column Preferences ColumnPreferences Object· Table: CPRF
ColumnPreferences is a Data structure related to the FormPreferencesService.
Source table: CPRF.
Parent: Columns Preferences ColumnsPreferences CollectionColumns Preferences Params ColumnsPreferencesParams Object· Table: CPRF
The ColumnsPreferencesParams specifies the identification key combination (user and FormId) for which the FormPreferencesService is related.
Source table: CPRF.
Parent: Form Preferences Service FormPreferencesService ServiceCustomized Template UICU SQL Table
Users OUSR SQL Table
ColumnsPreferences
Object
ColumnPreferences
Method
Property
Column
DB
FormID
DB
ItemNumber
DB
TabsLayout
DB
User
DB
Width
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
