| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 178 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
2 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 180 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
3 | BSEG | Accounting Document Segment | 231 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
4 | BSID_BAK | Accounting: Secondary Index for Customers | 178 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
5 | BSIK_BAK | Accounting: Secondary index for vendors | 180 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
6 | BSSEG | Accounting Document Segment | 220 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
7 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 220 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
8 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 220 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
9 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 220 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
10 | GLPOS_C_CT | FI Document: Entry View | 65 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
11 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 65 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
12 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 65 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
13 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 65 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
14 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 65 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
15 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 65 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
16 | MHND | Dunning Data | 61 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
17 | T5PSS | Wage types for social protection regime calculation | 3 | BTYPE | Type of social protection regime | nvarchar | 2 | 0 | | |
18 | T704M | Control Table for Statements | 8 | BTYPE | Indicator: Statement Type | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
19 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 208 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
20 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 208 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
TOPCCMS Database Monitors for Oracle |
21 | SDBAP | DBA Planning Table | 5 | BTYPE | Type of DBA action | nvarchar | 5 | 0 | | |
TOPCorporate Performance Monitor |
22 | UMC_TD110 | Task List: Message | 3 | BTYPE | Single-Character Indicator | nvarchar | 1 | 0 | | |
TOPEmpties Management When Extension EA-CP Is Active |
23 | /BEV1/NEINVBAL | Balances of Empties Qties and Empties Values f. Inv.Receipt | 5 | BTYPE | Balance Category | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
24 | ACCTIT | Compressed Data from FI/CO Document | 80 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
25 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 178 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
26 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 180 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
27 | BSID | Accounting: Secondary Index for Customers | 178 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
28 | BSIK | Accounting: Secondary Index for Vendors | 180 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
29 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 73 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
30 | KMZEI | FI: Account Assignment Model Item Information | 51 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
31 | KOMU | Account Assignment Templates for G/L Account Items | 51 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
32 | VBSEGD | Document Segment for Customer Document Parking | 41 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
33 | VBSEGK | Document Segment for Vendor Document Parking | 46 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
34 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 81 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
TOPFunds Management-Specific Postings |
35 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 80 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
36 | PSOSEGD | Document Segment: Recurring Request, Customer | 42 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
37 | PSOSEGK | Recurring Request Document Segment, Vendors | 47 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
38 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 79 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
TOPGeneral Ledger Accounting |
39 | FAGL_SPLINFO | Splittling Information of Open Items | 86 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
TOPLocalization |
40 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 137 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
TOPMaxDB |
41 | SDBADSDB | DBA calendar: planning- vs. R/3 exec.vs. DB exec. times | 8 | BTYPE | Type of DBA action | nvarchar | 5 | 0 | | |
TOPMedical Rounds |
42 | TN1BALANCETYPE | i.s.h.med: Fluid Balancing, Inflow/Outflow Types | 3 | BTYPE | i.s.h.med: Balancing, Inflow/Outlow Classification | nvarchar | 1 | 0 | | |
TOPPayroll General Parts |
43 | T7CCE_DIST_BASIS | Distribution basis | 4 | BTYPE | Distribution Basis Type | nvarchar | 1 | 0 | | |
TOPProduction Orders |
44 | COWIPB_CHVW | WIP Batches with Where-Used List | 12 | BTYPE | Type of Batch in WIP Batch Management | nvarchar | 2 | 0 | | |
TOPProduction Planning and Control PP enhancements |
45 | MILL_PBWU | Mill: Process Batches with Usage | 12 | BTYPE | Mill: Type of Batch in Process Batch Processing | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
46 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 222 | BTYPE | Payroll Type | nvarchar | 2 | 0 | | |
TOPSmart Forms |
47 | SSFXSFBMP | Smart Forms: BMP Cache (for XSF Output, for Example) | 4 | BTYPE | Graphic type | nvarchar | 4 | 0 | | |