| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBP_RBKP | Document Header: Invoice Receipt | 16 | KURSF | Exchange rate | decimal | 9 | 5 | | |
2 | CE1PR22 | Périm. résultat IDES | 24 | KURSF | Cours de change | decimal | 9 | 5 | | |
3 | FIAPSAD_ORDR_HD | Order Number Header KSA | 22 | KURSF | Exchange rate | decimal | 9 | 5 | | |
4 | FIEUD_FIDOC_H | SAFT: FI Transaction Document Header | 44 | KURSF | Exchange rate | decimal | 9 | 5 | | |
5 | FIEUD_GOODS_I | SAFT-XML:Goods Movement Line Items | 57 | KURSF | Exchange rate | decimal | 9 | 5 | | |
6 | FIEUD_MMINVTAX | SAFT:MM: TAX Information for E-XML MM invoice for LU | 18 | KURSF | Exchange rate | decimal | 9 | 5 | | |
7 | FIEUD_MMINV_I | SAFT:MM: Item Details for XML Purchase Invoice | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
8 | FUDT_VDOCBKPF | Verification Document Header | 23 | KURSF | Exchange rate | decimal | 9 | 5 | | |
9 | FUDT_VDOCBKPFH | Verification Document Header(History) | 23 | KURSF | Exchange rate | decimal | 9 | 5 | | |
10 | GLPOS_C_CT | FI Document: Entry View | 155 | KURSF | Exchange rate | decimal | 9 | 5 | | |
11 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 155 | KURSF | Exchange rate | decimal | 9 | 5 | | |
12 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 155 | KURSF | Exchange rate | decimal | 9 | 5 | | |
13 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 155 | KURSF | Exchange rate | decimal | 9 | 5 | | |
14 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 157 | KURSF | Exchange rate | decimal | 9 | 5 | | |
15 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 157 | KURSF | Exchange rate | decimal | 9 | 5 | | |
16 | J_3RFRNDRATE_CLC | Rounded documents for cancellations | 5 | KURSF | Exchange rate | decimal | 9 | 5 | | |
17 | MEV_D_AD_ITEM_MM | Period-End Valuation: Accruals Document Item MM | 25 | KURSF | Exchange rate | decimal | 9 | 5 | | |
18 | MEV_D_AD_ROOT | Period-End Valuation: Accruals Document Root | 22 | KURSF | Exchange rate | decimal | 9 | 5 | | |
19 | MEV_D_WL_MM | Period-end valuation: Worklist - Materials Management Data | 25 | KURSF | Exchange rate | decimal | 9 | 5 | | |
20 | VIXCESM180REC | Modelo 180 - Witholding Tax Recipients DMEE Line 02 | 11 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPAccounting Interface |
21 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 455 | KURSF | Exchange rate | decimal | 9 | 5 | | |
22 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 455 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPActual Payments and Forecast |
23 | COFP | Document Lines (project cash management) | 40 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPBasic Functions |
24 | FEBEP | Electronic Bank Statement Line Items | 64 | KURSF | Exchange rate (different from local currency) | decimal | 9 | 5 | | |
TOPBasis Components |
25 | ZDS400_BKPF | Belegkopf für Buchhaltung | 23 | KURSF | Umrechnungskurs | decimal | 9 | 5 | | |
TOPCollectionsDisbursements |
26 | VVKKCFREC | Cash Receipts to be Transferred to Claims System | 21 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPContract Accounts Receivable and Payable |
27 | DFKKMOP | Items in contract account document | 40 | KURSF | Exchange rate | decimal | 9 | 5 | | |
28 | DFKKMOPK | Items in contract account document | 19 | KURSF | Exchange rate | decimal | 9 | 5 | | |
29 | DFKKOP | Items in contract account document | 40 | KURSF | Exchange rate | decimal | 9 | 5 | | |
30 | DFKKOPK | Items in contract account document | 19 | KURSF | Exchange rate | decimal | 9 | 5 | | |
31 | DFKKOP_REP | Open Items from FPO4 | 44 | KURSF | Exchange rate | decimal | 9 | 5 | | |
32 | DFKKORDERPOS | Requests: Items | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
33 | DFKKORDERPOS_S | Request Templates: Items | 23 | KURSF | Exchange rate | decimal | 9 | 5 | | |
34 | DFKKRK | Returns lot: Header data | 15 | KURSF | Exchange rate | decimal | 9 | 5 | | |
35 | DFKKRP | Returns lot: Data for payment | 29 | KURSF | Exchange rate | decimal | 9 | 5 | | |
36 | DFKKRP3 | Returns: Manual Posting Specifications | 21 | KURSF | Exchange rate | decimal | 9 | 5 | | |
37 | DFKKRP3H | Returns: History for Manual Posting Items | 17 | KURSF | Exchange rate | decimal | 9 | 5 | | |
38 | DFKKZK | Payment lot: Header data | 13 | KURSF | Exchange rate | decimal | 9 | 5 | | |
39 | DFKKZP | Payment lot: Data for payment | 23 | KURSF | Exchange rate | decimal | 9 | 5 | | |
40 | FKKBEP | Electronic Bank Statement Line Items | 64 | KURSF | Exchange rate (different from local currency) | decimal | 9 | 5 | | |
TOPCross-Application Components |
41 | BKKPF | Accounting document header | 23 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPData Retention Tool |
42 | TXW_S_BKPF | Retrieve BKPF from archive | 18 | KURSF | Exchange rate | nvarchar | 12 | 0 | | |
TOPFinancial Accounting |
43 | ACCTCR | Compressed Data from FI/CO Document - Currencies | 9 | KURSF | Exchange rate | decimal | 9 | 5 | | |
44 | AVIK | Payment Advice Header | 43 | KURSF | Exchange rate (different from local currency) | decimal | 9 | 5 | | |
45 | BKPF | Accounting Document Header | 23 | KURSF | Exchange rate | decimal | 9 | 5 | | |
46 | EBKPF | Fin.Accntng Doc.Header (of Docs from Extern.Systems) | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
47 | VBKPF | Document Header for Document Parking | 30 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPFunds Management |
48 | KBLK | Document Header: Manual Document Entry | 23 | KURSF | Exchange rate | decimal | 9 | 5 | | |
49 | KBLPS | Earmarked Funds: Value Adjustment Documents | 22 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPFunds Management-Specific Postings |
50 | PSOKPF | Recurring Request Document Header | 31 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPGeneral Ledger Accounting |
51 | BKPF_ADD | Accounting Document Header | 23 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPInformation System |
52 | QSTRE | FI/HR Withholding Tax Report for Spain | 37 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPInvoice Verification |
53 | RBKP | Document Header: Invoice Receipt | 16 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPInvoicing |
54 | DEABPS | Customer change table: Logical view of BB amounts | 35 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPLease Accounting |
55 | FILA_GF_ITEMDATA | Process Data | 43 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPLocalization |
56 | IDEU_VAT | EU VAT Posting | 26 | KURSF | Exchange rate | decimal | 9 | 5 | | |
57 | J_3RF_REGINV_DE | Outgoing invoice journal transp tab for IBOOK ver 2 | 20 | KURSF | Exchange rate | decimal | 9 | 5 | | |
58 | J_3RF_REGINV_K | Incoming invoice journal transp tab for IBOOK | 15 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPMulti Currency Accounting |
59 | GLE_MCA_MI_RATES | Manual input exchanges rates | 6 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPPayment Transactions |
60 | REGUH | Settlement data from payment program | 86 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPPeriodical Sales and Distribution |
61 | JFXBPOSDL | IS-M: Backup Transfer Internal Table XBPOS | 40 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPProfitability Analysis |
62 | CE18500 | | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
63 | CE1BGIS | Ergebnisbereich für | 24 | KURSF | Umrechnungskurs | decimal | 9 | 5 | | |
64 | CE1E_B1 | Model Bank | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
65 | CE1IDEA | Op. Concern BR World | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
66 | CE1IDEB | Ergebnisbereich IDES | 24 | KURSF | Umrechnungskurs | decimal | 9 | 5 | | |
67 | CE1IDES | Ergebnisbereich IDES | 24 | KURSF | Umrechnungskurs | decimal | 9 | 5 | | |
68 | CE1INT1 | Ergebnisbereich IDES | 24 | KURSF | Umrechnungskurs | decimal | 9 | 5 | | |
69 | CE1OC01 | Bike International | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
70 | CE1R300 | Operating Concern IDES | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
71 | CE1S001 | Sample operating concern | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
72 | CE1S300 | Operating Concern IDES | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
73 | CE1S_AL | Airline Route Profit | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
74 | CE1S_CP | Template for Consumer Goods Industry | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
75 | CE1S_GO | Quickstart Template | 24 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPReal Estate Management |
76 | VIAKBKPF | Document Header from Service Charge Settlement for Interface | 11 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPRecycling Administration Core Functions |
77 | J_7LV1K | REA Document: Header Data | 27 | KURSF | Exchange rate | decimal | 9 | 5 | | |
TOPRemaining Beverage - Obsolete Objects |
78 | /BEV3/CH1030BKPF | Header Data for CH Event Ledger 00001030 | 25 | KURSF | Exchange rate | decimal | 9 | 5 | | |