|
|
API AIGW
AIGW - Item Group - Warehouse - History Table
Bin Location OBIN SQL Table
Item Groups OITB SQL Table
Users OUSR SQL Table
Warehouses OWHS 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 |
|---|---|---|---|---|---|---|---|---|
| ItmsGrpCod | Item Group Code | Int | 6 | OITB Item Groups | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| DftBinAbs | Default Bin Internal Number | Int | 11 | OBIN Bin Location | ||||
| DftBinEnfd | Default Bin Enforced [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | 1 | N | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Create Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 |
Table relationship map
SELECT statement
SELECT
AIGW.AbsEntry AS 'Internal Number',
AIGW.ItmsGrpCod AS 'Item Group Code',
AIGW.WhsCode AS 'Warehouse Code',
AIGW.DftBinAbs AS 'Default Bin Internal Number',
AIGW.DftBinEnfd AS 'Default Bin Enforced [Y/N]',
AIGW.DataSource AS 'Data Source',
AIGW.UserSign AS 'User Signature',
AIGW.LogInstanc AS 'Log Instance',
AIGW.CreateDate AS 'Create Date',
AIGW.UserSign2 AS 'Updating User',
AIGW.UpdateDate AS 'Date of Update'
FROM AIGW AS AIGW
Related information
Bin Location OBIN SQL Table
Item Groups OITB SQL Table
Users OUSR SQL Table
Warehouses OWHS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
