|
|
API ABFC
ABFC - Bin Field Configuration - History 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 |
|---|---|---|---|---|---|---|---|---|
| FldType | Field Type | VarChar | S) Warehouse Sublevel A) Bin Location Attribute | 1 | ||||
| FldNum | Field Number | Int | 6 | |||||
| DispName | Display Name | nVarChar | 20 | |||||
| Activated | Active [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | 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 | |||||
| DftName | Default Field Name | nVarChar | 20 |
SELECT statement
SELECT
ABFC.AbsEntry AS 'Internal Number',
ABFC.FldType AS 'Field Type',
ABFC.FldNum AS 'Field Number',
ABFC.DispName AS 'Display Name',
ABFC.Activated AS 'Active [Y/N]',
ABFC.UserSign AS 'User Signature',
ABFC.DataSource AS 'Data Source',
ABFC.Transfered AS 'Year Transfer [Y/N]',
ABFC.Instance AS 'Instance',
ABFC.LogInstanc AS 'Log Instance',
ABFC.CreateDate AS 'Creation Date',
ABFC.UserSign2 AS 'Updating User',
ABFC.UpdateDate AS 'Date of Update',
ABFC.DftName AS 'Default Field Name'
FROM ABFC AS ABFC
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
