|
|
API ABSL
ABSL - Warehouse Sublevel - History Table
Bin Field Configuration OBFC 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 |
|---|---|---|---|---|---|---|---|---|
| FldAbs | Bin Field Conf. Internal Number | Int | 11 | OBFC Bin Field Configuration | ||||
| SLCode | Code | nVarChar | 50 | |||||
| Descr | Description | nVarChar | 50 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| DataSource | Data Source | VarChar | 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 | |||||
| Deleted | Deleted | VarChar | 1 | N |
Table relationship map
SELECT statement
SELECT
ABSL.AbsEntry AS 'Internal Number',
ABSL.FldAbs AS 'Bin Field Conf. Internal Number',
ABSL.SLCode AS 'Code',
ABSL.Descr AS 'Description',
ABSL.UserSign AS 'User Signature',
ABSL.DataSource AS 'Data Source',
ABSL.Transfered AS 'Year Transfer [Y/N]',
ABSL.Instance AS 'Instance',
ABSL.LogInstanc AS 'Log Instance',
ABSL.CreateDate AS 'Creation Date',
ABSL.UserSign2 AS 'Updating User',
ABSL.UpdateDate AS 'Date of Update',
ABSL.Deleted AS 'Deleted'
FROM ABSL AS ABSL
Related information
Bin Field Configuration OBFC 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
