| 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 | 25 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 2 | JVSO1 | JV LI Table with Objects for JVTO1 | 25 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 3 | JVTO1 | JV Summary Table with Objects | 23 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 4 | T8JIX | JV index table | 15 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| TOPLocalization |
| 5 | J_3RFTAXRA | Tax Accounting: Actual line item table | 23 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 6 | J_3RFTAXRP | Tax Accounting: Plan line item table | 23 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 7 | J_3RFTAXRT | Tax Accounting: Summary table | 21 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 8 | J_3RFTAXRVA | Tax Accounting: Actual line item table | 20 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 9 | J_3RFTAXRVP | Tax Accounting: Plan line item table | 20 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 10 | J_3RFTAXRVT | Tax Accounting: Summary table | 18 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| TOPSpecial Purpose Ledger |
| 11 | /CCIS/PROFTAX03 | Object Table Number:03 | 10 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 12 | /CCIS/PROFTAXA | Actual Line Items Table for General Ledger | 24 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 13 | /CCIS/PROFTAXP | Plan Line Items Table for General Ledger | 26 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| 14 | /CCIS/PROFTAXT | Totals Table for General Ledger | 33 | RANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | |
| TOPTransfer Postings |
| 15 | J_1AAWAYBL | Way Bills for asset movements | 18 | RANLN2 | Receiver Asset sub number | nvarchar | 4 | 0 | | |
