| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1RA/0SD010CO | Items for Class SD01 - Raw Data | 18 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
2 | /1RA/0SD010MI | Items for Class SD01 - Raw Data | 22 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
3 | /1RA/0SD012CO | Items for Class SD01 - Processable | 18 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
4 | /1RA/0SD012MI | Items for Class SD01 - Processable | 22 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
5 | /1RA/0SD014CO | Items for Class SD01 - Processed | 18 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
6 | /1RA/0SD014MI | Items for Class SD01 - Processed | 22 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
7 | /1RA/0SD020CO | Items for Class SD02 - Raw Data | 18 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
8 | /1RA/0SD022CO | Items for Class SD02 - Processable | 18 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
9 | /1RA/0SD024CO | Items for Class SD02 - Processed | 18 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
10 | /1RA/0SD030CO | Items for Class SD03 - Raw Data | 18 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
11 | /1RA/0SD030MI | Items for Class SD03 - Raw Data | 20 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
12 | /1RA/0SD032CO | Items for Class SD03 - Processable | 18 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
13 | /1RA/0SD032MI | Items for Class SD03 - Processable | 20 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
14 | /1RA/0SD034CO | Items for Class SD03 - Processed | 18 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
15 | /1RA/0SD034MI | Items for Class SD03 - Processed | 20 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
16 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 21 | HWAE3 | | nvarchar | 5 | 0 | | |
17 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 21 | HWAE3 | | nvarchar | 5 | 0 | | |
18 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 48 | HWAE3 | | nvarchar | 5 | 0 | | |
19 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 26 | HWAE3 | | nvarchar | 5 | 0 | | |
20 | CNVA_PCREA_GRIRO | GR/IR Items - Results (Level 2) | 22 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
21 | FARR_D_INVOICE | Invoice Entries | 17 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
22 | FARR_D_LEGACYC | Legacy data for initial load of conditions for rev.acc.it. | 15 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
23 | FARR_D_POSTING | Posting table | 17 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
24 | FUDT_VDOCBKPF | Verification Document Header | 40 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
25 | FUDT_VDOCBKPFH | Verification Document Header(History) | 40 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
26 | IDCN_3RFF4ADJDOC | Adjustment Document Header | 17 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPAccounting Interface |
27 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 476 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
28 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 476 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPAutomatic Payments |
29 | PAYRQ | Payment Requests | 16 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPBasic Functions |
30 | GSBLCA | Business area consolidation: deviating records | 24 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPBasis Components |
31 | ZDS400_BKPF | Belegkopf für Buchhaltung | 40 | HWAE3 | Währungsschlüssel der dritten Hauswährung | nvarchar | 5 | 0 | | |
TOPContract Accounts Receivable and Payable |
32 | DFKKSUMCB | Control details for posting totals per company code | 8 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPCross-Application Components |
33 | BKKPF | Accounting document header | 40 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPData Retention Tool |
34 | TXW_S_BKPF | Retrieve BKPF from archive | 21 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPFinancial Accounting |
35 | BKPF | Accounting Document Header | 40 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
36 | EBKPF | Fin.Accntng Doc.Header (of Docs from Extern.Systems) | 23 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
37 | KMKPF | FI: Account Assignment Model Header Information | 6 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
38 | VBKPF | Document Header for Document Parking | 29 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPFunds Management-Specific Postings |
39 | PSOKPF | Recurring Request Document Header | 30 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPGeneral Ledger Accounting |
40 | BKPF_ADD | Accounting Document Header | 40 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
41 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 39 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPLocalization |
42 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 29 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
43 | J_3RKKRS | Account correspondence line items | 28 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
44 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 29 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
45 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 29 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
46 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 29 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
47 | /BEV3/CH1030BKPF | Header Data for CH Event Ledger 00001030 | 42 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | | |