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