|
|
API OMRL
OMRL - Advanced Inventory Revaluation Table
Posting Period OFPR SQL Table
Project Codes OPRJ SQL Table
Workstation ID CSTN SQL Table
Journal Entry OJDT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DocNum KEY UNIQUE | Document Number | Int | 11 | NUM | Yes | |||
| Series KEY | Series | Int | 6 | 0 | SERIES | No | ||
| DocDate | Posting Date | Date | 8 | |||||
| RevalType | Inventory Valuation Type | VarChar | P) Price Change M) Inventory Debit/Credit | 1 | P | |||
| Handwrtten | Manual Numbering | VarChar | 1 | N | ||||
| Printed | Printed | VarChar | Y) Copy N) Original | 1 | N | |||
| Transfered | Year Transfer | VarChar | Y) Yes N) No | 1 | N | |||
| DocCur | Document Currency | nVarChar | 3 | |||||
| DocRate | Document Rate | Num | 20 | |||||
| Ref2 | Reference 2 | nVarChar | 11 | |||||
| Comments | Remarks | nVarChar | 127 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| TransId | Transaction Number | Int | 11 | OJDT Journal Entry | ||||
| DocTime | Generation Time | Int | 6 | |||||
| Confirmed | Confirmed | VarChar | Y) Yes N) No | 1 | Y | |||
| Instance | Instance | Int | 6 | 0 | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| TaxDate | Document Date | Date | 8 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Upgrade M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| StampNum | Stamp No. | nVarChar | 16 | |||||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| StationID | Workstation ID | Int | 11 | CSTN Workstation ID | ||||
| Rounding | Rounding | VarChar | Y) Yes N) No | 1 | N | |||
| Segment | Segment | Int | 6 | 0 | ||||
| ReqDate | Required Date | Date | 8 | |||||
| CancelDate | Cancelation Date | Date | 8 | |||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes |
Table relationship map
SELECT statement
SELECT
OMRL.DocEntry AS 'Internal Number',
OMRL.DocNum AS 'Document Number',
OMRL.Series AS 'Series',
OMRL.DocDate AS 'Posting Date',
OMRL.RevalType AS 'Inventory Valuation Type',
OMRL.Handwrtten AS 'Manual Numbering',
OMRL.Printed AS 'Printed',
OMRL.Transfered AS 'Year Transfer',
OMRL.DocCur AS 'Document Currency',
OMRL.DocRate AS 'Document Rate',
OMRL.Ref2 AS 'Reference 2',
OMRL.Comments AS 'Remarks',
OMRL.JrnlMemo AS 'Journal Remarks',
OMRL.TransId AS 'Transaction Number',
OMRL.DocTime AS 'Generation Time',
OMRL.Confirmed AS 'Confirmed',
OMRL.Instance AS 'Instance',
OMRL.UpdateDate AS 'Date of Update',
OMRL.CreateDate AS 'Creation Date',
OMRL.TaxDate AS 'Document Date',
OMRL.DataSource AS 'Data Source',
OMRL.StampNum AS 'Stamp No.',
OMRL.FinncPriod AS 'Posting Period',
OMRL.UserSign AS 'User Signature',
OMRL.UserSign2 AS 'Updating User',
OMRL.LogInstanc AS 'Log Instance',
OMRL.StationID AS 'Workstation ID',
OMRL.Rounding AS 'Rounding',
OMRL.Segment AS 'Segment',
OMRL.ReqDate AS 'Required Date',
OMRL.CancelDate AS 'Cancelation Date',
OMRL.Project AS 'Project Code'
FROM OMRL AS OMRL
Related information
Posting Period OFPR SQL Table
Project Codes OPRJ SQL Table
Workstation ID CSTN SQL Table
Journal Entry OJDT 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
