|
|
API IWZ1
IWZ1 - Accounts Revaluation History Table
Inflation Wizard OIWZ SQL Table
G/L Accounts OACT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OIWZ Inflation Wizard | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| AcctCode | Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| ActName | Account Name | nVarChar | 100 | |||||
| ActFrmBlnc | Account From Balance | Num | 20 | |||||
| ExecutLine | Executed Row | VarChar | Y) Executed Row N) Filter Line | 1 | Y | |||
| ActRevCncl | Account Revaluation Cancel | VarChar | N) No Y) Yes | 1 | N | |||
| RevToAct | Revaluate To Account | nVarChar | 15 | |||||
| ActDiffBal | Account Difference Balance | Num | 20 | |||||
| RvCaclDate | Reval. Acct Cancellation Date | Date | 8 | |||||
| ErrReason | Error Reason | Int | 11 | |||||
| ActLastBal | Account Last Reval Balance | Num | 20 |
Table relationship map
SELECT statement
SELECT
IWZ1.AbsEntry AS 'Internal Number',
IWZ1.AcctCode AS 'Account Code',
IWZ1.ActName AS 'Account Name',
IWZ1.ActFrmBlnc AS 'Account From Balance',
IWZ1.ExecutLine AS 'Executed Row',
IWZ1.ActRevCncl AS 'Account Revaluation Cancel',
IWZ1.RevToAct AS 'Revaluate To Account',
IWZ1.ActDiffBal AS 'Account Difference Balance',
IWZ1.RvCaclDate AS 'Reval. Acct Cancellation Date',
IWZ1.ErrReason AS 'Error Reason',
IWZ1.ActLastBal AS 'Account Last Reval Balance'
FROM IWZ1 AS IWZ1
Related information
Inflation Wizard OIWZ SQL Table
G/L Accounts OACT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
