| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ZSAWT | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
2 | ZSEMBPST | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
3 | ZSPLITT | Summentabelle | 6 | ROBJNR | Objekt-Nummer für Objekte (Kontierungselemente) | nvarchar | 18 | 0 | | |
4 | ZZ001T | Summary Table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
5 | ZZLINET | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
6 | ZZSL01T | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
7 | ZZSPECT | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPAvailability Control |
8 | FMAVCT | AVC Summary Table (BCS) | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPBank Components |
9 | JBSSAMOB | Regulatory Reporting - Grouping Objects | 4 | ROBJNR | Grouping Object No. | nvarchar | 14 | 0 | | |
TOPBasic Functions |
10 | FILCT | FI-LC: Global totals table with 2 object tables | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
11 | GGREFT | Example for Global FI-SL Summary Table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
12 | GLFUNCT | Totals Table for Cost of Sales Accounting | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
13 | GLPO1 | Plan Line Items for Object Table | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
14 | GLPO2 | Plan Line Items for Object Table Global | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
15 | GLPO3 | Plan Line Items for Object Table | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
16 | GLREFT | Example for Local FI-SL Summary Table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
17 | GLSO1 | FI-SL Line Item Table with Objects for GLTO1 | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
18 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
19 | GLSO3 | FI-SL LI Table with Objects for GLTO3 | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
20 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
21 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
22 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
TOPBudgeting |
23 | FMBDT | FM budget totals table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
24 | FMRBT | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPCollectionsDisbursements |
25 | GLISDET | Summary Table for Insurance (DE) | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
26 | GRISDET | Summary Table for Insurance (DE) - Rollup | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPConsolidation |
27 | ECMCT | SAP Cons.: Totals Table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPCost Element Accounting |
28 | COFIT | Totals Records for Reconciliation Ledger | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
TOPFinancial Accounting |
29 | FBICRC001T | ICRC: Open Items GL Accounts: Totals | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
30 | FBICRC002T | ICRC: GL Accounts: Totals | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
31 | FBICRC003T | ICRC: Open Items Customers/Vendors: Totals | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPFinancial Services Localization |
32 | /CEEIS/RUT | Totals Table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPFlexible Real Estate Management |
33 | VIPRLEDTAGRT | Summentabelle Ledger 7A Mandate | 6 | ROBJNR | Objekt-Nummer für Objekte (Kontierungselemente) | nvarchar | 18 | 0 | | |
TOPFund Accounting |
34 | FMCCAVCT | Totals Table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPFunds Management |
35 | FMIT | Totals Table for Funds Management | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
36 | FMSPLITT | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
37 | FMUSFGFACTS1T | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
38 | FMUSFGFACTS2T | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
39 | FMUSFGT | Summary table for US Federal Government | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPGrantee Management |
40 | GMAVCT | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
41 | GMIT | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
42 | JVPSC01T | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
43 | JVTO1 | JV Summary Table with Objects | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
44 | JVTO2 | JV Billing FI-SL Summary Table | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
45 | T8JTPM | Joint Venture Production Month Summary Data | 5 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPLoans Management |
46 | VDARLOBJ | Loan objects relationship table | 4 | ROBJNR | Collateral object number | nvarchar | 10 | 0 | | |
47 | VDHOBJ | Collateral Objects | 2 | ROBJNR | Collateral object number | nvarchar | 10 | 0 | | |
48 | VDHOBJBL | Determination of collateral value/Expert report of object | 11 | ROBJNR | Collateral object number | nvarchar | 10 | 0 | | |
49 | VDHOBJGT | Object building parts | 2 | ROBJNR | Collateral object number | nvarchar | 10 | 0 | | |
TOPLocalization |
50 | J_3RFTAXRT | Tax Accounting: Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
51 | J_3RFTAXRVT | Tax Accounting: Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPProfit Center Accounting |
52 | GLPCT | EC-PCA: Totals Table | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
53 | T8APP_GLPCM | EC-PCA: Plan Costs from Material Costing for Rep. Material | 6 | ROBJNR | Object number for FI-SL tables | nvarchar | 18 | 0 | | |
TOPRegulatory reporting for insurance companies |
54 | ISSRFLDET | Summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
55 | /BEV3/CHFIT | Totals table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
56 | /BEV3/CHVGRT | Totals table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPRetail Ledger |
57 | PCRRETAILT | Totals Table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPSpecial Purpose Ledger |
58 | /CCIS/PBU18T | PBU18: Summary table x | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPTariffs, Duties and Permits |
59 | OIHEDT | Summary table, IS-OIL Excise Duty Special Ledger | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
60 | OIHSLT | TDP (excise duty) special ledger summary table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |
TOPTransfer to Financial Accounting |
61 | TRACTSLT | Totals Table | 6 | ROBJNR | Object number for objects (account assignment elements) | nvarchar | 18 | 0 | | |