| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPJoint Venture und Production Sharing Accounting |
| 1 | JVPO1 | JVA: Plan Line Items | 24 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 2 | JVSO1 | JV LI Table with Objects for JVTO1 | 24 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 3 | JVTO1 | JV Summary Table with Objects | 22 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 4 | T8JIX | JV index table | 14 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| TOPLocalization |
| 5 | J_3RFTAXRA | Tax Accounting: Actual line item table | 22 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 6 | J_3RFTAXRP | Tax Accounting: Plan line item table | 22 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 7 | J_3RFTAXRT | Tax Accounting: Summary table | 20 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 8 | J_3RFTAXRVA | Tax Accounting: Actual line item table | 19 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 9 | J_3RFTAXRVP | Tax Accounting: Plan line item table | 19 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 10 | J_3RFTAXRVT | Tax Accounting: Summary table | 17 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| TOPSpecial Purpose Ledger |
| 11 | /CCIS/PROFTAX03 | Object Table Number:03 | 9 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 12 | /CCIS/PROFTAXA | Actual Line Items Table for General Ledger | 23 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 13 | /CCIS/PROFTAXP | Plan Line Items Table for General Ledger | 25 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| 14 | /CCIS/PROFTAXT | Totals Table for General Ledger | 32 | RANLN1 | Main Asset Number | nvarchar | 12 | 0 | | |
| TOPTransfer Postings |
| 15 | J_1AAWAYBL | Way Bills for asset movements | 17 | RANLN1 | Receiver Asset main number | nvarchar | 12 | 0 | | |
