|
|
API HFC1
HFC1 - Hide Functions Configuration - Rows Table
Hide Functions Configuration OHFC SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| FuncID | Function ID | Int | 11 | OHFC Hide Functions Configuration | ||||
| formNum | Form Number | nVarChar | 127 | |||||
| ItemUID | Item UID | nVarChar | 127 | |||||
| ColUID | Column UID | nVarChar | 127 | |||||
| HideVal | Hide Valid Value | nVarChar | 20 | |||||
| AltVal | Alternative Valid Value | nVarChar | 20 | |||||
| PanelID | Hide Item by Panel | Int | 6 | |||||
| ActionType | Hide Item Action Type | Int | 0 1) Hide Column 2) Hide Item's Valid Value 3) Hide Panel 4) Hide Column's Valid Value | 6 | 0 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| Transfered | Year Transfer [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | 0 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 |
Table relationship map
SELECT statement
SELECT
HFC1.AbsEntry AS 'Internal Number',
HFC1.FuncID AS 'Function ID',
HFC1.formNum AS 'Form Number',
HFC1.ItemUID AS 'Item UID',
HFC1.ColUID AS 'Column UID',
HFC1.HideVal AS 'Hide Valid Value',
HFC1.AltVal AS 'Alternative Valid Value',
HFC1.PanelID AS 'Hide Item by Panel',
HFC1.ActionType AS 'Hide Item Action Type',
HFC1.UserSign AS 'User Signature',
HFC1.DataSource AS 'Data Source',
HFC1.Transfered AS 'Year Transfer [Y/N]',
HFC1.Instance AS 'Instance',
HFC1.LogInstanc AS 'Log Instance',
HFC1.CreateDate AS 'Creation Date',
HFC1.UserSign2 AS 'Updating User',
HFC1.UpdateDate AS 'Date of Update'
FROM HFC1 AS HFC1
Related information
Hide Functions Configuration OHFC SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
