| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VIM_1ITEM_S | Document Item | 100 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
2 | /OPT/VIM_TITEM | Document Item | 100 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
3 | AUAA | Settlement Document: Receiver Segment | 22 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
4 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 177 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
5 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 179 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
6 | BSEG | Accounting Document Segment | 211 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
7 | BSID_BAK | Accounting: Secondary Index for Customers | 177 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
8 | BSIK_BAK | Accounting: Secondary index for vendors | 179 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
9 | BSSEG | Accounting Document Segment | 200 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
10 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 200 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
11 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 200 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
12 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 200 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
13 | GLPOS_C_CT | FI Document: Entry View | 101 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
14 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 101 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
15 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 101 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
16 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 101 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
17 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 103 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
18 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 103 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
19 | MHND | Dunning Data | 60 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
20 | YVIM_1ITEM | Document Item | 100 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPAccounting Interface |
21 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 207 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
22 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 207 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPActual CostingMaterial Ledger |
23 | FCML_CCS_REP | HDB Reporting Structure for ML | 17 | EGRUP | Cost Component Group | nvarchar | 2 | 0 | | |
TOPElectronic Bank Statement |
24 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 50 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
25 | FEB_ACT | Acct Assignment Templates | 50 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
26 | /OPT/VIM_1ITEM | Document Item | 100 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
27 | ACCTIT | Compressed Data from FI/CO Document | 79 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
28 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 177 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
29 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 179 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
30 | BSID | Accounting: Secondary Index for Customers | 177 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
31 | BSIK | Accounting: Secondary Index for Vendors | 179 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
32 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 64 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
33 | KMZEI | FI: Account Assignment Model Item Information | 42 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
34 | KOMU | Account Assignment Templates for G/L Account Items | 42 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
35 | VBSEGA | Document Segment for Document Parking - Asset Database | 55 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
36 | VBSEGD | Document Segment for Customer Document Parking | 40 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
37 | VBSEGK | Document Segment for Vendor Document Parking | 45 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
38 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 68 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPFunds Management-Specific Postings |
39 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 67 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
40 | PSOSEGD | Document Segment: Recurring Request, Customer | 41 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
41 | PSOSEGK | Recurring Request Document Segment, Vendors | 46 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
42 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 66 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPGeneral Ledger Accounting |
43 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 40 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
44 | FAGL_SPLINFO | Splittling Information of Open Items | 83 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPGL Account Posting |
45 | TCJ_POSITIONS | Cash Journal Document Items | 57 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
46 | JVBX | JV Billing Database (INDX-Table) | 12 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
47 | JVGLFLEX07 | General Ledger: Joint Venture Accounting Fields | 3 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
48 | JVGLFLEXA | General Ledger: Actual Line Items | 30 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
49 | JVGLFLEXP | General Ledger: Plan Line Items | 32 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
50 | JVGLFLEXT | General Ledger: Totals | 39 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
51 | PSAIT | PSA Document Items | 17 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
52 | PSCIT | PSC document line items | 17 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
53 | T8J2C | Carried Interest | 4 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
54 | T8J4B | JV Cash Call Batch table | 7 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
55 | T8J4D | Non-op Billing Item Table (Deprecated -> replaced by T8J4H) | 5 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
56 | T8J4E | Non-op bill user currency (Deprecated -> replaced by T8J4J) | 5 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
57 | T8J4F | Non op Bill table assets (Deprecated -> replaced by T8J4I) | 5 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
58 | T8J4H | Non-Op saved bills - Detail Info (for holding bills) | 5 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
59 | T8J4I | Non operated Billing Asset Tables (for holding bills) | 5 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
60 | T8J4J | Non-Operated Billing User Currency Table (for holding bills) | 5 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
61 | T8J9A | Equity Group - JOA level | 4 | EGRUP | Equity Group - JOA level | nvarchar | 3 | 0 | | |
62 | T8J9B | Equity Group Description - JOA level | 5 | EGRUP | Equity Group - JOA level | nvarchar | 3 | 0 | | |
63 | T8J9C | Joint operating agreement partner shares | 4 | EGRUP | Equity Group - JOA level | nvarchar | 3 | 0 | | |
64 | T8JC2 | Funding Currency by Equity Group | 4 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
65 | T8JDD | JV EDI Inbound: Property Table | 6 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
66 | T8JF | Investment Group | 4 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
67 | T8JFT | Investment Group Description | 5 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
68 | T8JG | Valid Investment Group | 6 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
69 | T8JI | Joint Venture Inter-Company Ventures | 4 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
70 | T8JQ | Joint Venture Owner Equity | 4 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
71 | T8JSC | Joint Venture Substitute Cost Object | 4 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPLocalization |
72 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 136 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPProduct Cost Planning |
73 | TCKH3 | Cost Components | 6 | EGRUP | Cost Component Group | nvarchar | 2 | 0 | | |
74 | TCKH6 | Cost Component Groups - Texts | 3 | EGRUP | Cost Component Group | nvarchar | 2 | 0 | | |
75 | TCKH7 | Cost Component Groups | 2 | EGRUP | Cost Component Group | nvarchar | 2 | 0 | | |
TOPProject Risk Management for Contractors |
76 | /SAPPCE/JVA_T8JV | E&C table for JVA master data | 4 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPPurchasing |
77 | EBKN | Purchase Requisition Account Assignment | 65 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
78 | EKKN | Account Assignment in Purchasing Document | 75 | EGRUP | Equity group | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
79 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 202 | EGRUP | Equity group | nvarchar | 3 | 0 | | |