|
|
API AMRV
AMRV - Inventory Revaluation - History Table
Documents Numbering - Series NNM1 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 | Document Number | Int | 11 | NUM | No | |||
| DocDate | Posting Date | Date | 8 | |||||
| Ref1 | Reference 1 | nVarChar | 11 | |||||
| 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 | |||||
| RevalType | Inventory Revaluation Type | VarChar | P) Price Change M) Material Debit/Credit | 1 | P | |||
| UpdateDate | Update Date | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| Series KEY | Series | Int | 6 | NNM1 Documents Numbering - Series | 0 | SERIES | No | |
| TaxDate | Document Date | Date | 8 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Upgrade M) Import O) DI API A) Auto. Incr. D) Data Document P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| StationID | Workstation ID | Int | 11 | CSTN Workstation ID | ||||
| RIncmAcct | Invent. Reval. Expense Account | nVarChar | 15 | |||||
| RExpnAcct | Invent. Reval. Expense Account | nVarChar | 15 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | 162 | ||||
| SeqCode | Sequence Code | Int | 6 | |||||
| Serial | Serial Number | Int | 11 | |||||
| SeriesStr | Series String | nVarChar | 3 | |||||
| SubStr | Subseries String | nVarChar | 3 | |||||
| VersionNum | Version Number | nVarChar | 11 | |||||
| InflaReval | Inflation-Based Revaluation | VarChar | 1 | N | ||||
| SupplCode | Supplementary Code | nVarChar | 127 | |||||
| CardCode | Customer/Vendor Code | nVarChar | 15 | |||||
| CardName | Customer/Vendor Name | nVarChar | 100 | |||||
| CreatedBy | Entry Creation Origin | VarChar | M) Created Manually by User W) Created by Product Cost Recalculation Wizard | 1 | M |
Table relationship map
SELECT statement
SELECT
AMRV.DocEntry AS 'Internal Number',
AMRV.DocNum AS 'Document Number',
AMRV.DocDate AS 'Posting Date',
AMRV.Ref1 AS 'Reference 1',
AMRV.Ref2 AS 'Reference 2',
AMRV.Comments AS 'Remarks',
AMRV.JrnlMemo AS 'Journal Remarks',
AMRV.TransId AS 'Transaction Number',
AMRV.DocTime AS 'Generation Time',
AMRV.RevalType AS 'Inventory Revaluation Type',
AMRV.UpdateDate AS 'Update Date',
AMRV.CreateDate AS 'Creation Date',
AMRV.Series AS 'Series',
AMRV.TaxDate AS 'Document Date',
AMRV.DataSource AS 'Data Source',
AMRV.UserSign AS 'User Signature',
AMRV.UserSign2 AS 'Updating User',
AMRV.StationID AS 'Workstation ID',
AMRV.RIncmAcct AS 'Invent. Reval. Expense Account',
AMRV.RExpnAcct AS 'Invent. Reval. Expense Account',
AMRV.LogInstanc AS 'Log Instance',
AMRV.ObjType AS 'Object Type',
AMRV.SeqCode AS 'Sequence Code',
AMRV.Serial AS 'Serial Number',
AMRV.SeriesStr AS 'Series String',
AMRV.SubStr AS 'Subseries String',
AMRV.VersionNum AS 'Version Number',
AMRV.InflaReval AS 'Inflation-Based Revaluation',
AMRV.SupplCode AS 'Supplementary Code',
AMRV.CardCode AS 'Customer/Vendor Code',
AMRV.CardName AS 'Customer/Vendor Name',
AMRV.CreatedBy AS 'Entry Creation Origin'
FROM AMRV AS AMRV
Related information
Documents Numbering - Series NNM1 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
