| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | J_3RF_TP_CP_SBCD | Controllable Partners. Data saved in backgroud. BC Documents | 9 | PARTN | Partner | nvarchar | 10 | 0 | | |
2 | J_3RF_TP_CP_SNBD | Controllable Partners. Data saved in backgroud. NonBC Docum | 9 | PARTN | Partner | nvarchar | 10 | 0 | | |
3 | T510O | Cost-of-Living Allowances -BAT- | 4 | PARTN | Partnership | nvarchar | 2 | 0 | | |
4 | T5D5A | OBSOLETE: Check Table for COLA Level/Partner Indicator | 3 | PARTN | Partnership | nvarchar | 2 | 0 | | |
5 | T8PSA_RUII_HIST | PSA Rollup II History (for produc split by volume) | 13 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
TOPBank Customer Accounts |
6 | BKKPOGISP | EDI Payments: Reporting Data to Clearing, Segm. E1EDLA1 | 5 | PARTN | Partner number | nvarchar | 17 | 0 | | |
TOPBasic Functions |
7 | FEBEP | Electronic Bank Statement Line Items | 40 | PARTN | Business Partner | nvarchar | 55 | 0 | | |
8 | T028P | Assign Search Strings to Bank Statement Transactions | 11 | PARTN | Business Partner | nvarchar | 55 | 0 | | |
TOPCash Desk |
9 | FMSHERLOCK | Clarification List (Payments to be Clarified) | 23 | PARTN | Business Partner | nvarchar | 55 | 0 | | |
TOPContract Accounts Receivable and Payable |
10 | FKKBEP | Electronic Bank Statement Line Items | 40 | PARTN | Business Partner | nvarchar | 55 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
11 | JVBX | JV Billing Database (INDX-Table) | 11 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
12 | JVOO1 | Object Table for FI-SL Table JVTO1 | 21 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
13 | JVOO2 | JV Billing FI-SL Object Table | 10 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
14 | JVPSC01A | Actual line item table | 34 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
15 | JVPSC01C | Object table 2 | 9 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
16 | JVPSC01P | Plan line item table | 34 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
17 | JVPSC01T | Summary table | 33 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
18 | JVT1 | JV Summary Table | 13 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
19 | PSAIT | PSA Document Items | 18 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
20 | PSCIT | PSC document line items | 18 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
21 | T8J4B | JV Cash Call Batch table | 5 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
22 | T8J4C | Bill Trans Fields Table (Deprecated -> replaced by T8J4G) | 9 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
23 | T8J4G | Non-Op saved bills - Header Info (for holding bills) | 7 | PARTN | JV Operator | nvarchar | 10 | 0 | | |
24 | T8J6N | JV EDI Processed Partners/Ventures | 6 | PARTN | JV partner | nvarchar | 10 | 0 | | |
25 | T8J9C | Joint operating agreement partner shares | 5 | PARTN | JV partner | nvarchar | 10 | 0 | | |
26 | T8JBI_TH | JVA billing thresholds | 3 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
27 | T8JBI_THD | JVA billing threshold details | 3 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
28 | T8JDC | JV EDI Inbound: Sender's JIBE/PASC Number Table | 4 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
29 | T8JO | Partner | 3 | PARTN | JV partner | nvarchar | 10 | 0 | | |
30 | T8JOA | Company addresses | 3 | PARTN | JV partner | nvarchar | 10 | 0 | | |
31 | T8JOAT | Company addresses (text) | 4 | PARTN | JV partner | nvarchar | 10 | 0 | | |
32 | T8JQ | Joint Venture Owner Equity | 5 | PARTN | JV partner | nvarchar | 10 | 0 | | |
33 | T8PSA_CLOS_STOCK | PSA Closing Stock per Partner | 9 | PARTN | JV partner | nvarchar | 10 | 0 | | |
34 | T8PSA_EG | PSC Equity Group | 5 | PARTN | JV partner | nvarchar | 10 | 0 | | |
35 | T8PSA_EG_HIST | PSC Equity Group History Information | 8 | PARTN | JV partner | nvarchar | 10 | 0 | | |
36 | T8PSA_LIFT_VOL | Lifting Volumes | 11 | PARTN | Partner account number | nvarchar | 10 | 0 | | |
37 | T8PSA_STOCK_ADJ | PSA Stock Adjustment | 14 | PARTN | JV partner | nvarchar | 10 | 0 | | |
38 | T8PSC_LIFT | PSC Lifting Data | 10 | PARTN | JV partner | nvarchar | 10 | 0 | | |
TOPLoans Management |
39 | VDZNB_PAYINFO | Payment Postprocessing: Payment Inform. for a PPP Activity | 16 | PARTN | Business Partner | nvarchar | 55 | 0 | | |
40 | VDZNB_USAGE | Payment Postprocessing: Usage of a Payment Postpr. Activity | 27 | PARTN | Business Partner | nvarchar | 55 | 0 | | |
TOPPayment Transactions |
41 | FIBL_RPCODE | Master Data for Repetitive Code | 14 | PARTN | Reference to Business Partner Receiving Payment | nvarchar | 16 | 0 | | |
TOPPayroll |
42 | T7UAF230 | Form 23 rows | 3 | PARTN | Part number | nvarchar | 1 | 0 | | |
43 | T7UAF230T | Form 23 rows texts | 4 | PARTN | Part number | nvarchar | 1 | 0 | | |
44 | T7UAF231 | Form 23 rows | 3 | PARTN | Part number | nvarchar | 1 | 0 | | |
45 | T7UAF232 | Form 23 rows | 3 | PARTN | Part number | nvarchar | 1 | 0 | | |
46 | T7UAF23P | Form 23 parts | 3 | PARTN | Part number | nvarchar | 1 | 0 | | |
47 | T7UAF23PT | Form 23 parts texts | 4 | PARTN | Part number | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
48 | PA0008 | HR Master Record: Infotype 0008 (Basic Pay) | 30 | PARTN | Partnership | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
49 | OIUCM_T8JO | PRA Partner Table from JV | 3 | PARTN | Customer Number | nvarchar | 10 | 0 | | |
TOPProject Risk Management for Contractors |
50 | /SAPPCE/HRP1960 | DB table for info type 1960 | 19 | PARTN | Joint Venture Partner | nvarchar | 10 | 0 | | |
51 | /SAPPCE/JVA_T8JO | E&C version of table T8JO | 3 | PARTN | Joint Venture Partner | nvarchar | 10 | 0 | | |
52 | /SAPPCE/JVA_T8JV | E&C table for JVA master data | 5 | PARTN | Joint Venture Partner | nvarchar | 10 | 0 | | |
TOPPublic Sector |
53 | PA0237 | HR Master Record: Infotype 0237 / View for 0052 (PSG) | 27 | PARTN | Partnership | nvarchar | 2 | 0 | | |
TOPRecruitment |
54 | PB0008 | Applicant Master Record Infotype (Basic Pay) | 30 | PARTN | Partnership | nvarchar | 2 | 0 | | |
TOPRussia |
55 | T7RUM0 | Military card information catalogue | 2 | PARTN | Section in Military Catalog | nvarchar | 2 | 0 | | |
TOPService Process Warranty |
56 | WTYSCC_STATMAP | Claim status mapping | 2 | PARTN | Partner Parts that Have to Be Returned | nvarchar | 1 | 0 | | |
TOPWarranty Claim Processing |
57 | CWTY004 | Status for Parts that Have to Be Returned | 2 | PARTN | Partner Parts that Have to Be Returned | nvarchar | 1 | 0 | | |
58 | CWTY004T | Texts for Parts Statuses | 2 | PARTN | Partner Parts that Have to Be Returned | nvarchar | 1 | 0 | | |