|
|
API ODSW
ODSW - SN Draft Attribs in Location Table
Items OITM SQL Table
Serial Numbers Master Data OSRN 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 | ItemCode | Item Code | nVarChar | 20 | OITM Items |
|---|---|---|---|---|---|---|---|---|
| SysNumber | System No. | Int | 11 | OSRN Serial Numbers Master Data | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| Location | Loc. | nVarChar | 100 | |||||
| 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Transfered | Transferred | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | 0 | ||||
| AbsEntry KEY UNIQUE | abs entry | Int | 11 | PRIMARY | Yes | |||
| MdAbsEntry | MD Abs Entry | Int | 11 | |||||
| ObjType | Object Type | nVarChar | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 |
Table relationship map
SELECT statement
SELECT
ODSW.ItemCode AS 'Item Code',
ODSW.SysNumber AS 'System No.',
ODSW.WhsCode AS 'Warehouse Code',
ODSW.Location AS 'Loc.',
ODSW.DataSource AS 'Data Source',
ODSW.UserSign AS 'User Signature',
ODSW.Transfered AS 'Transferred',
ODSW.Instance AS 'Instance',
ODSW.AbsEntry AS 'abs entry',
ODSW.MdAbsEntry AS 'MD Abs Entry',
ODSW.ObjType AS 'Object Type',
ODSW.LogInstanc AS 'Log Instance',
ODSW.UserSign2 AS 'Updating User',
ODSW.UpdateDate AS 'Update Date'
FROM ODSW AS ODSW
Related information
Items OITM SQL Table
Serial Numbers Master Data OSRN 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
