|
|
API ASRN
ASRN - Serial Numbers 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 | LOT_KEY | No |
|---|---|---|---|---|---|---|---|---|
| SysNumber | System Number | Int | 11 | |||||
| DistNumber | Serial 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 | Mfr Warranty Start Date | Date | 8 | |||||
| GrntExp | Mfr Warranty End Date | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| Location | Location | nVarChar | 100 | |||||
| Status | Status | VarChar | 0 1) Unavailable | 1 | ||||
| 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
ASRN.ItemCode AS 'Item No.',
ASRN.SysNumber AS 'System Number',
ASRN.DistNumber AS 'Serial Number',
ASRN.MnfSerial AS 'Manufacturer Serial No.',
ASRN.LotNumber AS 'Lot Number',
ASRN.ExpDate AS 'Expiration Date',
ASRN.MnfDate AS 'Manufacturing Date',
ASRN.InDate AS 'Admission Date',
ASRN.GrntStart AS 'Mfr Warranty Start Date',
ASRN.GrntExp AS 'Mfr Warranty End Date',
ASRN.CreateDate AS 'Creation Date',
ASRN.Location AS 'Location',
ASRN.Status AS 'Status',
ASRN.Notes AS 'Details',
ASRN.DataSource AS 'Data Source',
ASRN.UserSign AS 'User Signature',
ASRN.Transfered AS 'Transferred',
ASRN.Instance AS 'Instance',
ASRN.AbsEntry AS 'Abs Entry',
ASRN.ObjType AS 'Object Type',
ASRN.itemName AS 'Item Description',
ASRN.LogInstanc AS 'Log Instance',
ASRN.UserSign2 AS 'Updating User',
ASRN.UpdateDate AS 'Update Date',
ASRN.CostTotal AS 'Total Cost of Batches',
ASRN.Quantity AS 'Quantity',
ASRN.QuantOut AS 'Output Quantity',
ASRN.PriceDiff AS 'Price Difference',
ASRN.Balance AS 'Batch Balance',
ASRN.TrackingNt AS 'CCD Tracking Note',
ASRN.TrackiNtLn AS 'CCD Tracking Note Line'
FROM ASRN AS ASRN
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
