| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 58 | VERTN | | nvarchar | 13 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 58 | VERTN | | nvarchar | 13 | 0 | | |
3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 66 | VERTN | | nvarchar | 13 | 0 | | |
4 | /OPT/VIM_1ITEM_S | Document Item | 98 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
5 | /OPT/VIM_TITEM | Document Item | 98 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
6 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 92 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
7 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 159 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
8 | BSEG | Accounting Document Segment | 214 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
9 | BSID_BAK | Accounting: Secondary Index for Customers | 92 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
10 | BSIK_BAK | Accounting: Secondary index for vendors | 159 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
11 | BSSEG | Accounting Document Segment | 203 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
12 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 203 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
13 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 203 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
14 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 203 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
15 | GLPOS_C_CT | FI Document: Entry View | 257 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
16 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 257 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
17 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 257 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
18 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 257 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
19 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 266 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
20 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 266 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
21 | MHND | Dunning Data | 55 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
22 | REGUP | Processed items from payment program | 121 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
23 | YVIM_1ITEM | Document Item | 98 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPAccounting Interface |
24 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 332 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
25 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 332 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPAutomatic Payments |
26 | PAYRQ | Payment Requests | 159 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPBasic Functions |
27 | FEBEP | Electronic Bank Statement Line Items | 45 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPBilling |
28 | VBRP | Billing Document: Item Data | 170 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPConditions |
29 | KONP | Conditions (Item) | 56 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPContract Accounts Receivable and Payable |
30 | FKKBEP | Electronic Bank Statement Line Items | 45 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPCross-Application Components |
31 | BBSID | Accounting: Secondary index for customers | 92 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
32 | PLLPO | Task list - operation/activity | 162 | VERTN | Distr.cap.reqmts (plant maint.,process order, network) | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
33 | TXW_S_BSEG | Retrieve BSEG from archive | 100 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPDunning |
34 | MHNK | Dunning data (account entries) | 34 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
35 | MHNKO | Dunning data (acct entries) version before the next change | 34 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPFinancial Accounting |
36 | /OPT/VIM_1ITEM | Document Item | 98 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
37 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 92 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
38 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 159 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
39 | BSID | Accounting: Secondary Index for Customers | 92 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
40 | BSIK | Accounting: Secondary Index for Vendors | 159 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
41 | VBSEGD | Document Segment for Customer Document Parking | 83 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
42 | VBSEGK | Document Segment for Vendor Document Parking | 96 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
43 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 71 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPFunds Management-Specific Postings |
44 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 70 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
45 | PSOSEGD | Document Segment: Recurring Request, Customer | 84 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
46 | PSOSEGK | Recurring Request Document Segment, Vendors | 97 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
47 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 69 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPLoans Management |
48 | LOANREF_O | Records of Loan Reference Unit for Open Items | 8 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
49 | LOANREF_OS | Saved Ref. Records Open Items per Business Operation No. | 9 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
50 | MZDAT | Dunning and interest data for batch input | 6 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
51 | VDCHK_IOA_OI | Check Interest on Arrears - Open Items | 7 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
52 | VDZNB_PAYINFO | Payment Postprocessing: Payment Inform. for a PPP Activity | 39 | VERTN | Contract Type | nvarchar | 1 | 0 | | |
TOPLocalization |
53 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 68 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
54 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 67 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
55 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 67 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
56 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 67 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPMaster Data Distribution |
57 | /ISDFPS/TL1 | Task List - Operation/Activity | 162 | VERTN | Distr.cap.reqmts (plant maint.,process order, network) | nvarchar | 8 | 0 | | |
TOPPayment Transactions |
58 | FPRL_ITEM | Item Data | 60 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPReal Estate Management |
59 | VIAKBSEG | Document Line Item from SCS for Interface | 109 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
60 | VIMIIP | Invoice Items | 15 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
61 | VIMIRA | Instalments for Lease-Out | 9 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
62 | /BEV1/BO_CONT | Contract Data for Rebate Agreements | 4 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
63 | /BEV1/RBKP | Copy Table for KONP for Accrual (Field KBRUE) | 56 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
64 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 205 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
65 | /BEV3/CHABELKPF | Contract Statement Header | 3 | VERTN | CHD Contract Number | nvarchar | 13 | 0 | | |
TOPRental Accounting |
66 | VIRALSRHD | Statistics - Returned Debit Memos in RE: Header Data | 11 | VERTN | Contract Number | nvarchar | 13 | 0 | | |
TOPRouting |
67 | PLPO | Task list - operation/activity | 162 | VERTN | Distr.cap.reqmts (plant maint.,process order, network) | nvarchar | 8 | 0 | | |
TOPWork Center |
68 | CRCA | Work Center Capacity Allocation | 18 | VERTN | Distr.cap.reqmts (plant maint.,process order, network) | nvarchar | 8 | 0 | | |