|
|
API OFTR
OFTR - Transfer Table
OFTR SQL Table
Business Place OBPL SQL Table
Currency Codes OCRN SQL Table
Fixed Asset Depreciation Areas ODPA SQL Table
Posting Period OFPR SQL Table
Fixed Assets Depreciation Types ODTP SQL Table
Period Indicator OPID SQL Table
Documents Numbering - Series NNM1 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 | INDEX | Yes | |||
| Series | Series | Int | 6 | NNM1 Documents Numbering - Series | ||||
| PeriodCat | Period Category | nVarChar | 10 | |||||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period | ||||
| PostDate | Posting Date | Date | 8 | |||||
| DocDate | Document Date | Date | 8 | |||||
| DocStatus | Document Status | VarChar | P) Posted D) Draft C) Canceled | 1 | P | |||
| TransId | Transaction Number | Int | 11 | OJDT Journal Entry | ||||
| Comments | Remarks | nVarChar | 127 | |||||
| Reference | Reference | nVarChar | 32 | |||||
| ObjType | Object Type | nVarChar | 20 | |||||
| Currency | Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| DocRate | Document Rate | Num | 20 | |||||
| SysRate | System Rate | Num | 20 | |||||
| PIndicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ||||
| DocTotal | Document Total | Num | 20 | |||||
| DocTotalFC | Document Total (FC) | Num | 20 | |||||
| DocTotalSy | Document Total (SC) | Num | 20 | |||||
| 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 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Create Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| TransType KEY | Original Document | nVarChar | 13) A/R Invoice 19) A/P Credit Memo 18) A/P Invoice 46) Outgoing Payment 163) A/P Correction Invoice 1470000049) Capitalization 1470000060) Fixed Assets Credit Memo -1) All Transactions 1470000075) Manual Depreciation 1470000090) Fixed Assets Transfer 1470000094) Retirement | 20 | -1 | TRANS_TYPE | No | |
| CreatedBy | Original | Int | 11 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| AssetDate | Asset Value Date | Date | 8 | |||||
| CurSource | Base Currency | VarChar | L) Local Currency S) System Currency F) Foreign Currency | 1 | L | |||
| DocType | Document Type | nVarChar | PL) Ordinary Depreciation UP) Unplanned Depreciation SD) Special Depreciation AP) Appreciation TR) Asset Transfer NC) Sales SC) Scrapping TC) Asset Class Transfer | 15 | PL | |||
| PrjSmarz | Summarize by Project | VarChar | Y) Yes N) No | 1 | N | |||
| DstRlSmarz | Summarize by Distribution Rule | VarChar | Y) Yes N) No | 1 | N | |||
| ManDprType | Manual Depreciation Type | nVarChar | 15 | ODTP Fixed Assets Depreciation Types | ||||
| Handwrtten | Manual Numbering | VarChar | Y) Yes N) No | 1 | N | |||
| CancelDate | Cancelation Date | Date | 8 | |||||
| DprArea | Depreciation Area | nVarChar | 15 | ODPA Fixed Asset Depreciation Areas | ||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BaseRef | Base Reference | nVarChar | 11 | |||||
| LVARetire | Low Value Asset Retirement | VarChar | Y) Yes N) No | 1 | N | |||
| CancelOpt | Cancelation Option | Int | 6 | 1 | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| VatRegNum | VAT Reg. Number | nVarChar | 32 | |||||
| GdsMovType | Goods Movement Type | nVarChar | 2 |
Table relationship map
SELECT statement
SELECT
OFTR.DocEntry AS 'Internal Number',
OFTR.DocNum AS 'Document Number',
OFTR.Series AS 'Series',
OFTR.PeriodCat AS 'Period Category',
OFTR.FinncPriod AS 'Posting Period',
OFTR.PostDate AS 'Posting Date',
OFTR.DocDate AS 'Document Date',
OFTR.DocStatus AS 'Document Status',
OFTR.TransId AS 'Transaction Number',
OFTR.Comments AS 'Remarks',
OFTR.Reference AS 'Reference',
OFTR.ObjType AS 'Object Type',
OFTR.Currency AS 'Currency',
OFTR.DocRate AS 'Document Rate',
OFTR.SysRate AS 'System Rate',
OFTR.PIndicator AS 'Period Indicator',
OFTR.DocTotal AS 'Document Total',
OFTR.DocTotalFC AS 'Document Total (FC)',
OFTR.DocTotalSy AS 'Document Total (SC)',
OFTR.DataSource AS 'Data Source',
OFTR.UserSign AS 'User Signature',
OFTR.LogInstanc AS 'Log Instance',
OFTR.CreateDate AS 'Create Date',
OFTR.UserSign2 AS 'Updating User',
OFTR.UpdateDate AS 'Date of Update',
OFTR.TransType AS 'Original Document',
OFTR.CreatedBy AS 'Original',
OFTR.JrnlMemo AS 'Journal Remarks',
OFTR.AssetDate AS 'Asset Value Date',
OFTR.CurSource AS 'Base Currency',
OFTR.DocType AS 'Document Type',
OFTR.PrjSmarz AS 'Summarize by Project',
OFTR.DstRlSmarz AS 'Summarize by Distribution Rule',
OFTR.ManDprType AS 'Manual Depreciation Type',
OFTR.Handwrtten AS 'Manual Numbering',
OFTR.CancelDate AS 'Cancelation Date',
OFTR.DprArea AS 'Depreciation Area',
OFTR.BPLId AS 'Branch',
OFTR.BaseRef AS 'Base Reference',
OFTR.LVARetire AS 'Low Value Asset Retirement',
OFTR.CancelOpt AS 'Cancelation Option',
OFTR.BPLName AS 'Branch Name',
OFTR.VatRegNum AS 'VAT Reg. Number',
OFTR.GdsMovType AS 'Goods Movement Type'
FROM OFTR AS OFTR
Related information
OFTR SQL Table
Business Place OBPL SQL Table
Currency Codes OCRN SQL Table
Fixed Asset Depreciation Areas ODPA SQL Table
Posting Period OFPR SQL Table
Fixed Assets Depreciation Types ODTP SQL Table
Period Indicator OPID SQL Table
Documents Numbering - Series NNM1 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
