| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 96 | PSWSL | | nvarchar | 5 | 0 | | |
2 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 120 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
3 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 128 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
4 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 37 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
5 | BSEG | Accounting Document Segment | 35 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
6 | BSID_BAK | Accounting: Secondary Index for Customers | 120 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
7 | BSIK_BAK | Accounting: Secondary index for vendors | 128 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
8 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 37 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
9 | BSSEG | Accounting Document Segment | 24 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
10 | DFKKEPRT | Log for Inconsistent FI-CA Documents | 52 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
11 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 37 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
12 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 37 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
13 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 24 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
14 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 24 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
15 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 24 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
16 | REGUP | Processed items from payment program | 154 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPAccounting Interface |
17 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 82 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
18 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 82 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPContract Accounts Receivable and Payable |
19 | DFKKMOP | Items in contract account document | 130 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
20 | DFKKMOPK | Items in contract account document | 57 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
21 | DFKKOP | Items in contract account document | 130 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
22 | DFKKOPK | Items in contract account document | 57 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
23 | DFKKOP_REP | Open Items from FPO4 | 136 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
24 | DFKKRAP | Clearing/Reversal History (Line Item Level) < 4.62 | 17 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
25 | DFKKRAPT | Clearing/Reversal History (Line Item Level) | 17 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
26 | DFKKSUM | Posting totals from FI-CA | 10 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPCross-Application Components |
27 | BBSID | Accounting: Secondary index for customers | 120 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPData Retention Tool |
28 | TXW_S_BSEG | Retrieve BSEG from archive | 68 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPFinancial Accounting |
29 | ACCTIT | Compressed Data from FI/CO Document | 26 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
30 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 120 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
31 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 128 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
32 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 37 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
33 | BSID | Accounting: Secondary Index for Customers | 120 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
34 | BSIK | Accounting: Secondary Index for Vendors | 128 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
35 | BSIS | Accounting: Secondary Index for G/L Accounts | 37 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPGeneral Ledger Accounting |
36 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 80 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
37 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 37 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
38 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 37 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
39 | FAGL_SPLINFO | Splittling Information of Open Items | 57 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPGeneral Ledger Reorganization |
40 | FAGL_R_BLNCE | Reorganization: Balances to Be Transferred | 7 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
41 | FAGL_R_BLNCE_VAL | Reorganization: Balances to Be Transferred - Values | 7 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
42 | FAGL_R_SPL | Reorganization: Splitting Information of the Open Items | 36 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPLocal Currency Changeover |
43 | EWUFI_SCA | EMU conversion: Table of the clearings to be adjusted | 41 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
44 | EWUFI_SOP | EMU conversion: Table for open items total | 11 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPLocalization |
45 | J_1AINFINV | Inflation: Invoices for Replacement Value Determination | 14 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
46 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 99 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
47 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 98 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
48 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 98 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
49 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 98 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPPayment Transactions |
50 | FPRL_ITEM | Item Data | 26 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
51 | REGUP_CORE | Processed Items from Payment Program | 35 | PSWSL | Currency Key | nvarchar | 5 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
52 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 26 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
TOPTechnical Application Support |
53 | CNV_20425_SCA | EMU conversion: Table of the clearings to be adjusted | 36 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |
54 | CNV_20425_SOP | EMU conversion: Table for open items total | 10 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | | |