| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBP_RBKP | Document Header: Invoice Receipt | 59 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
2 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 123 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
3 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 63 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
4 | BSEG | Accounting Document Segment | 138 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
5 | BSID_BAK | Accounting: Secondary Index for Customers | 123 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
6 | BSIK_BAK | Accounting: Secondary index for vendors | 63 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
7 | BSSEG | Accounting Document Segment | 127 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
8 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 127 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
9 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 127 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
10 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 127 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
11 | GLPOS_C_CT | FI Document: Entry View | 159 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
12 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 159 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
13 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 159 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
14 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 159 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
15 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 161 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
16 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 161 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
17 | REGUP | Processed items from payment program | 66 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
18 | TREAT_FLOW_PM | Treasury: TREA Flow Payment Details | 16 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPAccounting Interface |
19 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 128 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
20 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 128 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPAgency Business Global Trade |
21 | WBRK | Agency business: Header | 73 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPAutomatic Payments |
22 | PAYRQ | Payment Requests | 51 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPContract Accounts Receivable and Payable |
23 | DFKKMOP | Items in contract account document | 118 | LANDL | Country Supplied (for Tax Notifications) | nvarchar | 3 | 0 | | |
24 | DFKKOP | Items in contract account document | 118 | LANDL | Country Supplied (for Tax Notifications) | nvarchar | 3 | 0 | | |
25 | DFKKOP_REP | Open Items from FPO4 | 123 | LANDL | Country Supplied (for Tax Notifications) | nvarchar | 3 | 0 | | |
26 | DPAYP | Payment program - data on paid item | 53 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
27 | FKKVKP | Contract Account Partner-Specific | 73 | LANDL | Country Supplied (for Tax Notifications) | nvarchar | 3 | 0 | | |
TOPCross-Application Components |
28 | BBSID | Accounting: Secondary index for customers | 123 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPData Retention Tool |
29 | TXW_S_BSEG | Retrieve BSEG from archive | 61 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
30 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 123 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
31 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 63 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
32 | BSID | Accounting: Secondary Index for Customers | 123 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
33 | BSIK | Accounting: Secondary Index for Vendors | 63 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
34 | VBSEGD | Document Segment for Customer Document Parking | 70 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
35 | VBSEGK | Document Segment for Vendor Document Parking | 78 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
36 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 47 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPFunds Management-Specific Postings |
37 | PSOSEGD | Document Segment: Recurring Request, Customer | 71 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
38 | PSOSEGK | Recurring Request Document Segment, Vendors | 79 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPGL Account Posting |
39 | TCJ_DOCUMENTS | Cash Journal Documents (Header Data) | 37 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPInvoice Verification |
40 | RBKP | Document Header: Invoice Receipt | 59 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
41 | RBKPB | Invoice Document Header (Batch Invoice Verification) | 54 | LANDL | Obsolete: supplying country: do NOT use! | nvarchar | 3 | 0 | | |
TOPPayment Transactions |
42 | FPRL_ITEM | Item Data | 56 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
43 | REGUPO | Line item status before the 'n'th change | 15 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
44 | REGUP_CORE | Processed Items from Payment Program | 28 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
45 | TFICA_DEF | Samples for Contract Account Types | 48 | LANDL | Country Supplied (for Tax Notifications) | nvarchar | 3 | 0 | | |
TOPReal Estate Management |
46 | VIAKBSEG | Document Line Item from SCS for Interface | 146 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
47 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 129 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPTransaction Manager |
48 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 132 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
49 | SLDT_FLOW | Subledger Distributor Transactions | 75 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
50 | TRDT_FLOW | Persistent distributor flows | 73 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
51 | VTBFHAPO | Transaction Flow | 132 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
52 | VTBFHAPO_MIGR | Migrated Financial Flows | 132 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
53 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 132 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
54 | VTBZV | Payment Details for Transaction | 29 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |
TOPTransfer to Financial Accounting |
55 | TRACT_ACCITEM | Accounting Items | 34 | LANDL | Supplying Country | nvarchar | 3 | 0 | | |