|
|
API ODBN
ODBN - Bat. Nos - Draft - Master Data Table
Items OITM SQL Table
Tracking Note OTCN SQL Table
Tracking Note - Line Data TCN1 SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY | Item No. | nVarChar | 20 | OITM Items | DIST_KEY | No |
|---|---|---|---|---|---|---|---|---|
| SysNumber | System No. | Int | 11 | |||||
| DistNumber | Distinct Number | nVarChar | 36 | |||||
| MnfSerial | Manufacturer Serial No. | nVarChar | 36 | |||||
| LotNumber | Lot Number | nVarChar | 36 | |||||
| ExpDate | Expiration Date | Date | 8 | |||||
| MnfDate | Manufacturing Date | Date | 8 | |||||
| InDate | Admission Date | Date | 8 | |||||
| GrntStart | Warranty Start Date | Date | 8 | |||||
| GrntExp | Warranty End Date | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| Location | Loc. | nVarChar | 100 | |||||
| Status | Status | VarChar | 0 1) Not Accessible 2) Locked | 1 | 0 | |||
| Notes | Details | Text | 16 | |||||
| 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 | |||
| ObjType | object type | nVarChar | 20 | |||||
| itemName | Item Description | nVarChar | 100 | |||||
| LogInstanc | Log Instance | Int | 11 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 | |||||
| CostTotal | Total Cost of Batches | Num | 20 | |||||
| Quantity | Quantity | Num | 20 | |||||
| QuantOut | Output Quantity | Num | 20 | |||||
| PriceDiff | Price Difference | Num | 20 | |||||
| Balance | Batch Balance | Num | 20 | |||||
| TrackingNt | CCD Tracking Note | Int | 11 | OTCN Tracking Note | ||||
| TrackiNtLn | CCD Tracking Note Line | Int | 11 | TCN1 Tracking Note - Line Data |
Table relationship map
SELECT statement
SELECT
ODBN.ItemCode AS 'Item No.',
ODBN.SysNumber AS 'System No.',
ODBN.DistNumber AS 'Distinct Number',
ODBN.MnfSerial AS 'Manufacturer Serial No.',
ODBN.LotNumber AS 'Lot Number',
ODBN.ExpDate AS 'Expiration Date',
ODBN.MnfDate AS 'Manufacturing Date',
ODBN.InDate AS 'Admission Date',
ODBN.GrntStart AS 'Warranty Start Date',
ODBN.GrntExp AS 'Warranty End Date',
ODBN.CreateDate AS 'Creation Date',
ODBN.Location AS 'Loc.',
ODBN.Status AS 'Status',
ODBN.Notes AS 'Details',
ODBN.DataSource AS 'Data Source',
ODBN.UserSign AS 'User Signature',
ODBN.Transfered AS 'Transferred',
ODBN.Instance AS 'Instance',
ODBN.AbsEntry AS 'abs entry',
ODBN.ObjType AS 'object type',
ODBN.itemName AS 'Item Description',
ODBN.LogInstanc AS 'Log Instance',
ODBN.UserSign2 AS 'Updating User',
ODBN.UpdateDate AS 'Update Date',
ODBN.CostTotal AS 'Total Cost of Batches',
ODBN.Quantity AS 'Quantity',
ODBN.QuantOut AS 'Output Quantity',
ODBN.PriceDiff AS 'Price Difference',
ODBN.Balance AS 'Batch Balance',
ODBN.TrackingNt AS 'CCD Tracking Note',
ODBN.TrackiNtLn AS 'CCD Tracking Note Line'
FROM ODBN AS ODBN
Related information
Items OITM SQL Table
Tracking Note OTCN SQL Table
Tracking Note - Line Data TCN1 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
