|
|
API OFAR
OFAR - Fixed Asset Revaluation Table
OFAR SQL Table
Business Place OBPL SQL Table
Fixed Asset Depreciation Areas ODPA SQL Table
Period Indicator OPID SQL Table
Documents Numbering - Series NNM1 SQL Table
Journal Entry OJDT 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 | INDEX | Yes | |||
| Series | Series | Int | 6 | NNM1 Documents Numbering - Series | ||||
| PostDate | Posting Date | Date | 8 | |||||
| AssetDate | Asset Value Date | Date | 8 | |||||
| Ref | Reference | nVarChar | 32 | |||||
| Comments | Remarks | nVarChar | 127 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| DprArea | Depreciation Area | nVarChar | 15 | ODPA Fixed Asset Depreciation Areas | ||||
| TransId | Transaction Number | Int | 11 | OJDT Journal Entry | ||||
| Handwrtten | Manual Numbering | VarChar | Y) Yes N) No | 1 | N | |||
| PIndicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ||||
| DocDate | Document Date | Date | 8 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| VatRegNum | VAT Reg. Number | nVarChar | 32 | |||||
| RevalPerc | Revaluation Percentage % | Num | 20 |
Table relationship map
SELECT statement
SELECT
OFAR.DocEntry AS 'Internal Number',
OFAR.DocNum AS 'Document Number',
OFAR.Series AS 'Series',
OFAR.PostDate AS 'Posting Date',
OFAR.AssetDate AS 'Asset Value Date',
OFAR.Ref AS 'Reference',
OFAR.Comments AS 'Remarks',
OFAR.JrnlMemo AS 'Journal Remarks',
OFAR.DprArea AS 'Depreciation Area',
OFAR.TransId AS 'Transaction Number',
OFAR.Handwrtten AS 'Manual Numbering',
OFAR.PIndicator AS 'Period Indicator',
OFAR.DocDate AS 'Document Date',
OFAR.BPLId AS 'Branch',
OFAR.BPLName AS 'Branch Name',
OFAR.VatRegNum AS 'VAT Reg. Number',
OFAR.RevalPerc AS 'Revaluation Percentage %'
FROM OFAR AS OFAR
Related information
OFAR SQL Table
Business Place OBPL SQL Table
Fixed Asset Depreciation Areas ODPA SQL Table
Period Indicator OPID SQL Table
Documents Numbering - Series NNM1 SQL Table
Journal Entry OJDT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
