| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /AIF/FLBOOK_IDX | Standard index table | 45 | CURR | Local currency of airline | nvarchar | 5 | 0 | | |
2 | /SAPPSSRM/TRESHD | IBU PS: Thresholds | 4 | CURR | Currency Key | nvarchar | 5 | 0 | | |
3 | CMCBD_ENTRY_HIST | Cash Budgeting Entry History | 10 | CURR | Currency Key | nvarchar | 5 | 0 | | |
4 | REFXCN_CD_ADJ | Condition Adjustment | 7 | CURR | Currency of condition item | nvarchar | 5 | 0 | | |
5 | T77WWW_ELIGIBLE | Employee Eligibility for Advanced Claims | 11 | CURR | Currency Key | nvarchar | 5 | 0 | | |
6 | ZMTMPERS | CM MtM Persistency | 25 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPAccounting Interface |
7 | GLE_BALANC_LINE | Line Items for Balancing | 3 | CURR | Balancing Currency | nvarchar | 5 | 0 | | |
8 | GLE_BALANC_LINET | Text Table for Line Items for Balancing | 3 | CURR | Balancing Currency | nvarchar | 5 | 0 | | |
TOPAdaptor |
9 | UKM_TRANSFER_ARV | Data from AR for SAP Credit Management | 10 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPAerospace Defence Industry Solution |
10 | ORF2CUST | Customising Profils for Optimal Rotable Float ORF1,2,4 | 13 | CURR | Currency Key | nvarchar | 5 | 0 | | |
11 | ORFECT | ORF: Essentiality-Code Table | 5 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPAgency Business Global Trade |
12 | TMPA1 | Agency Business: Profit Group | 5 | CURR | Currency for minimum profit margin | nvarchar | 5 | 0 | | |
TOPAssetLiability Management |
13 | JBRBRLQSZ | Assignment of Liquidation Scenario to Valuation Rule | 6 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPBank Customer Accounts |
14 | TBKKIHB6 | Dispatcher per Account Number | 6 | CURR | Currency of External Bank Account | nvarchar | 5 | 0 | | |
TOPBasic Functions |
15 | EWULC03 | FI-LC: Companies for conversion | 4 | CURR | Local currency prior to conversion | nvarchar | 5 | 0 | | |
TOPBusiness Consolidation |
16 | UCF2301 | C/T: Methods: Target Key Figures | 4 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPBusiness Partner |
17 | BP3100 | Additional information | 12 | CURR | Currency | nvarchar | 5 | 0 | | |
TOPClaims Management |
18 | ICLCCEVENT | Claim Bundle | 11 | CURR | Currency of Claim Bundle Reserve | nvarchar | 5 | 0 | | |
19 | ICLCCEVPAY | Claim Bundle - Payment Sum | 6 | CURR | Transaction Currency | nvarchar | 5 | 0 | | |
20 | ICLCCEVRES | Claim Bundle - Reserve Sum | 5 | CURR | Currency of Reserve (Transactn Crcy) | nvarchar | 5 | 0 | | |
21 | ICLDIPL | Distribution Plan | 14 | CURR | Distribution Plan: Currency | nvarchar | 5 | 0 | | |
22 | ICLDRGITEM | DRG Item | 30 | CURR | Currency of Evaluated Amount | nvarchar | 5 | 0 | | |
23 | ICLINDRES | Reserve Lot | 10 | CURR | Currency of Reserve (Transactn Crcy) | nvarchar | 5 | 0 | | |
24 | ICLINDRESA | Claim-Independent Reserve - Case Reserve - Assignment | 7 | CURR | Currency of Reserve (Transactn Crcy) | nvarchar | 5 | 0 | | |
25 | ICLITEMAU | Damaged Vehicle | 51 | CURR | Currency of Actual Cash Value | nvarchar | 5 | 0 | | |
26 | ICLITEMEQ | Damaged Item | 30 | CURR | Currency of Actual Cash Value | nvarchar | 5 | 0 | | |
27 | ICLITEMRE | Damaged Real Estate | 23 | CURR | Currency of Actual Cash Value | nvarchar | 5 | 0 | | |
28 | ICLITEMSV | Salvage Item Evaluation | 11 | CURR | Currency of Actual Cash Value | nvarchar | 5 | 0 | | |
29 | ICLPAY | Claim Payment | 26 | CURR | Claim Payment Currency | nvarchar | 5 | 0 | | |
30 | ICLPOL | Policy Snapshot | 17 | CURR | Currency of Limit and Deductible | nvarchar | 5 | 0 | | |
31 | ICLRESERVE | Case Reserve | 6 | CURR | Currency of Reserve (Transactn Crcy) | nvarchar | 5 | 0 | | |
32 | ICSCCEVENT | Shadow Table Claim Bundle | 11 | CURR | Currency of Claim Bundle Reserve | nvarchar | 5 | 0 | | |
33 | ICSCCEVPAY | Claim Bundle - Payment Sum | 6 | CURR | Transaction Currency | nvarchar | 5 | 0 | | |
34 | ICSCCEVRES | Claim Bundle - Reserve Sum | 5 | CURR | Currency of Reserve (Transactn Crcy) | nvarchar | 5 | 0 | | |
35 | ICSDIPL | Distribution Plan (Shadow Table) | 14 | CURR | Distribution Plan: Currency | nvarchar | 5 | 0 | | |
36 | ICSDRGITEM | DRG Item | 30 | CURR | Currency of Evaluated Amount | nvarchar | 5 | 0 | | |
37 | ICSITEMAU | Damaged Vehicle | 51 | CURR | Currency of Actual Cash Value | nvarchar | 5 | 0 | | |
38 | ICSITEMEQ | Damaged Item | 30 | CURR | Currency of Actual Cash Value | nvarchar | 5 | 0 | | |
39 | ICSITEMRE | Damaged Real Estate | 23 | CURR | Currency of Actual Cash Value | nvarchar | 5 | 0 | | |
40 | ICSITEMSV | Salvage Item Evaluation | 11 | CURR | Currency of Actual Cash Value | nvarchar | 5 | 0 | | |
41 | ICSPAY | Payment | 26 | CURR | Claim Payment Currency | nvarchar | 5 | 0 | | |
42 | ICSPOL | Policy Snapshot | 17 | CURR | Currency of Limit and Deductible | nvarchar | 5 | 0 | | |
43 | ICSRESERVE | Case Reserve | 6 | CURR | Currency of Reserve (Transactn Crcy) | nvarchar | 5 | 0 | | |
44 | TICL003 | Internal Claim Type Version | 17 | CURR | Currency for All Amount Fields of Internal Claim Type | nvarchar | 5 | 0 | | |
45 | TICL072 | Reserving Rules | 4 | CURR | Currency of all statistical reserves | nvarchar | 5 | 0 | | |
46 | TICL161 | Version of Benefit Type Tree | 18 | CURR | Currency for All Amount Fields of Benefit Type Tree | nvarchar | 5 | 0 | | |
47 | TICL321 | Policy Product Version | 20 | CURR | Currency for All reserves, Limits and Deductibles | nvarchar | 5 | 0 | | |
TOPCollectionsDisbursements |
48 | DIMAPARSCPOS | IO: Change to Scheduling Items | 18 | CURR | Currency Key | nvarchar | 5 | 0 | | |
49 | IBROSTMCF | Clarif. Cases from Broker Report | 10 | CURR | Currency Key | nvarchar | 5 | 0 | | |
50 | IBROSTMH | ISCD: Broker Report - Header Data | 24 | CURR | Currency Key | nvarchar | 5 | 0 | | |
51 | IBROSTMP | ISCD: Broker Report - Item Data | 26 | CURR | Currency Key | nvarchar | 5 | 0 | | |
52 | IBROSTMSUM | Broker Summary Postings - Restart Information | 13 | CURR | Currency Key | nvarchar | 5 | 0 | | |
53 | ITAGCYCONTP | Items for a Container | 6 | CURR | Currency Key | nvarchar | 5 | 0 | | |
54 | ITAGCYTPCOMM | Reported Commission for Items in a Container | 4 | CURR | Currency Key | nvarchar | 5 | 0 | | |
55 | VVSCITEM | Bill Scheduling: Scheduling Document | 24 | CURR | Currency Key | nvarchar | 5 | 0 | | |
56 | VVSCITEML | Bill Scheduling: for General Ledger | 9 | CURR | Currency Key | nvarchar | 5 | 0 | | |
57 | VVSCITEM_MAN | Scheduling Items: Temp. Storage for Manual -> Auto Change | 24 | CURR | Currency Key | nvarchar | 5 | 0 | | |
58 | VVSCLOCKAMT | Scheduling: Premium Lock Period Share Already Transferred | 8 | CURR | Currency Key | nvarchar | 5 | 0 | | |
59 | VVSCPOS | Payment Plan Item | 42 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPCondition |
60 | BKK81 | Bank Condition | 10 | CURR | Currency Key | nvarchar | 5 | 0 | | |
61 | BKK82 | Bank Condition Item | 20 | CURR | Currency Key | nvarchar | 5 | 0 | | |
62 | BKK83 | Bank Condition Determination | 7 | CURR | Currency Key | nvarchar | 5 | 0 | | |
63 | BKK84 | Bank Account - Individual Condition | 12 | CURR | Currency Key | nvarchar | 5 | 0 | | |
64 | BKK85 | Bank Account - Individual Condition Position | 22 | CURR | Currency Key | nvarchar | 5 | 0 | | |
65 | BKK8RK | Standard Conditions: Retroactive Condition Changes | 11 | CURR | Currency | nvarchar | 5 | 0 | | |
66 | BKK91 | Value Date Transaction Figures | 8 | CURR | Account Currency | nvarchar | 5 | 0 | | |
67 | BKK92 | Account Balancing (Interest and Charges) | 9 | CURR | Account Currency | nvarchar | 5 | 0 | | |
68 | BKK95 | Account Specific Amount Limits for Graduated Conditions | 7 | CURR | Currency of Current Account | nvarchar | 5 | 0 | | |
69 | BKK96 | Account Balancing Detail Data | 22 | CURR | Currency of Current Account | nvarchar | 5 | 0 | | |
70 | BKK9A | Posting and Value Date Balances Carried Forward | 8 | CURR | Account Currency | nvarchar | 5 | 0 | | |
71 | BKK9B | Value Date Transaction Figures | 10 | CURR | Account Currency | nvarchar | 5 | 0 | | |
72 | TBKK8M | Trivial Amounts | 4 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPConsolidation |
73 | EWUCS10 | SAP Cons.-EURO: Consolidation Units for Euro Conversion | 5 | CURR | Local currency | nvarchar | 5 | 0 | | |
74 | TF164 | Consolidation Unit Year-Dependent | 5 | CURR | Local currency | nvarchar | 5 | 0 | | |
75 | TF184 | Consolidation Groups, Version- and Year-Dependent | 7 | CURR | Local currency | nvarchar | 5 | 0 | | |
76 | TF199C | Characteristic Values of Organizational Elements | 4 | CURR | Currency | nvarchar | 5 | 0 | | |
77 | TF555 | Methods for Interunit Elimination | 13 | CURR | Currency | nvarchar | 5 | 0 | | |
78 | TF557 | Methods: Threshold Value for Posting Differences | 4 | CURR | Currency | nvarchar | 5 | 0 | | |
TOPContract Accounts Receivable and Payable |
79 | TFK056I | Minimum Amounts for Interest Calculation Rule | 3 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPDefault Risk and Limit System |
80 | KLDATESHIFT | Shift Validity Date of Settlement Risk for FX Option | 2 | CURR | Currency in which the foreign currency option is sold | nvarchar | 5 | 0 | | |
TOPDownloadUpload |
81 | /DSD/HH_RACL | DSD Route Settlement: Clearing | 13 | CURR | Currency Key | nvarchar | 5 | 0 | | |
82 | /DSD/HH_RACOCICI | DSD Route Settlement: Check-Out/Check-In - Money Item | 6 | CURR | Currency Key | nvarchar | 5 | 0 | | |
83 | /DSD/HH_RADELCD | DSD Route Settlement: Delivery Execution Conditions | 8 | CURR | Currency Key | nvarchar | 5 | 0 | | |
84 | /DSD/HH_RADELCND | DSD Route Settlement: Delivery Execution Conditions | 9 | CURR | Currency Key | nvarchar | 5 | 0 | | |
85 | /DSD/HH_RAEC | DSD Route Settlement: Receipts/Expenditures | 7 | CURR | Currency Key | nvarchar | 5 | 0 | | |
86 | /DSD/HH_RAIVCD | DSD Route Settlement: HH Invoice Header Conditions | 7 | CURR | Currency Key | nvarchar | 5 | 0 | | |
87 | /DSD/HH_RAIVCND | DSD Route Settlement: HH Invoice Header Conditions | 8 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPEnterprise Compensation Management |
88 | T71ADM_SPENT_AMT | Compensation Planning: Spent Amounts | 8 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPExpenditure Certification |
89 | FMEUFEXP | Certified Expenditure Documents | 20 | CURR | Currency of the Financing Source | nvarchar | 5 | 0 | | |
90 | FMEUFFNS | Financing Source | 12 | CURR | Currency Key | nvarchar | 5 | 0 | | |
91 | FMEUFPRELCONS | Preliminarily Certified Amounts | 8 | CURR | Currency Key | nvarchar | 5 | 0 | | |
92 | FMEUFRUN | Certification Run Parameter | 5 | CURR | Currency Key | nvarchar | 5 | 0 | | |
93 | FMEUFTIM | Financing Source Time Slices | 8 | CURR | Currency Key | nvarchar | 5 | 0 | | |
94 | FMEUFTYP | Financing Source Type | 6 | CURR | Currency of the Financing Source | nvarchar | 5 | 0 | | |
95 | FMEUF_PREL_FS_CO | Obsolete!! To be removed!! | 8 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPFlexible Real Estate Management |
96 | VIXCFCFS | Fuel Movement | 12 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPFSCM In-House Cash |
97 | IHC_DB_CL_ACCTS | Account Determination for AMS Update | 3 | CURR | Currency Key | nvarchar | 5 | 0 | | |
98 | IHC_DB_DSP_TRAPO | Table Structure for displaying the Posted Item Detail | 9 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPGlobal Organization Customizing |
99 | /MRSS/D_REQ_CAND | Table of Portal demands : Candidates Information | 11 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPIndustry-Specific Component-Mining |
100 | /BPR3MI/MIN_CBP | Mining - Contract additional parameters | 11 | CURR | Mining - Contract Based Pricing Currency | nvarchar | 5 | 0 | | |
TOPInterest Calculation |
101 | T056I | Time-dep.terms for interest calc.rule | 3 | CURR | Currency Key | nvarchar | 5 | 0 | | |
102 | T056J | Time-dependent terms for interest calc.rule - access | 3 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPInterestCharge Calculation |
103 | BKKM3 | BCA: Parameters for Mass Runs in Parallel Processing | 22 | CURR | Transaction Currency | nvarchar | 5 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
104 | PSACR | PSA Document Currencies | 10 | CURR | Currency Key | nvarchar | 5 | 0 | | |
105 | PSCCR | PSC document line item amounts | 10 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPLand Register |
106 | CMS_LR_DE_2 | Grundbuch - Section II | 9 | CURR | Currency of the Charge | nvarchar | 5 | 0 | | |
TOPLoans Management |
107 | TDCAP_COND | Condition amount for capitalization | 6 | CURR | Currency | nvarchar | 5 | 0 | | |
108 | TDDEF_COND | Condition amount for deferral | 6 | CURR | Currency | nvarchar | 5 | 0 | | |
109 | VDBOINS | Business Operation Insurance Data | 16 | CURR | Insurance Policy Currency | nvarchar | 5 | 0 | | |
TOPLocalization |
110 | J_1IQRDEP | Quarterly Returns Depot structure | 22 | CURR | Currency | nvarchar | 5 | 0 | | |
111 | J_1ISERVC | Service tax details | 15 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPLogistics - General |
112 | EPM_KPI_CATALOG | KPIs Available in Company Catalog | 14 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPMaster Data |
113 | BKK620 | Account Hierarchy: Amount Definitions for Cash Concentration | 6 | CURR | Currency of Current Account | nvarchar | 5 | 0 | | |
114 | BKK621 | Cash Concentration: Different Amount Defintions | 10 | CURR | Currency of Current Account | nvarchar | 5 | 0 | | |
115 | BKK62_CC | Value Date Transaction Figures for Cash Concentration | 6 | CURR | Account Currency | nvarchar | 5 | 0 | | |
116 | BKK9B_CC | Value Date Transaction Figures for Cash Concentration | 10 | CURR | Account Currency | nvarchar | 5 | 0 | | |
117 | TDCLI_INSURANCE | Table of Credit Life Insurance Rates | 12 | CURR | Currency Key | nvarchar | 5 | 0 | | |
118 | TDCLI_INS_1 | Table of Credit Life Insurance Rates | 11 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPPayroll |
119 | T7SKA4 | Pomocná tabulka HRSK | 15 | CURR | Klúc meny | nvarchar | 5 | 0 | | |
120 | T7SKVDP | Aux table for HSKLVDP0 | 10 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPRevenue |
121 | OIURV03_TAXDTL | Valuation Tax Master Detail | 27 | CURR | Currency Key | nvarchar | 5 | 0 | | |
122 | OIURV03_TAXEMP | Valuation Tax Exempt Detail | 12 | CURR | Currency Key | nvarchar | 5 | 0 | | |
123 | OIURV03_TAXHDR | Valuation Tax Header | 12 | CURR | Currency Key | nvarchar | 5 | 0 | | |
124 | OIURV03_TAXMKT | Valuation Tax Marketing Detail | 13 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPRoute Settlement |
125 | /DSD/SL_POSTSET | DSD Collection: Posting Ctrl. Driver Receipts/Expenditures | 3 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
126 | /ISHFR/TNWFR_CCP | IS-H FR: Coordinated Care Path | 12 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPSchedule Manager |
127 | T880 | Global Company Data (for KONS Ledger) | 11 | CURR | Local currency | nvarchar | 5 | 0 | | |
TOPStock Visibility |
128 | /DSD/SV_RACOCICI | DSD SV: Check-Out / Check-In - Money Item | 6 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPTrading Contract |
129 | WB2_D_STRING | Logistical string,circle and washout | 9 | CURR | Currency | nvarchar | 5 | 0 | | |
130 | WB2_D_STRING_H | Header: Logistical string,circle and washout | 4 | CURR | Currency | nvarchar | 5 | 0 | | |
TOPTransaction Tax Engine |
131 | TTEC_CURR | Tax Currencies per Country | 5 | CURR | Currency Units in Tax Calculation | nvarchar | 5 | 0 | | |
132 | TTEC_ROUNDING | Rounding Decimals: Exceptions | 8 | CURR | Currency Units in Tax Calculation | nvarchar | 5 | 0 | | |
TOPValuation |
133 | OIURV_DOC_TAXDTL | Valuation Tax Master Detail | 27 | CURR | Currency Key | nvarchar | 5 | 0 | | |
134 | OIURV_DOC_TAXEMP | Valuation Tax Exempt Detail | 12 | CURR | Currency Key | nvarchar | 5 | 0 | | |
135 | OIURV_DOC_TAXHDR | Valuation Tax Header | 12 | CURR | Currency Key | nvarchar | 5 | 0 | | |
136 | OIURV_DOC_TAXMKT | Valuation Tax Marketing Detail | 13 | CURR | Currency Key | nvarchar | 5 | 0 | | |
137 | OIURV_SSTD | Settlement statement detail | 26 | CURR | Currency Key | nvarchar | 5 | 0 | | |
138 | OIURV_SSTD_MKT | Settlement statement detail | 8 | CURR | Currency Key | nvarchar | 5 | 0 | | |
139 | OIURV_SSTD_TAX | Settlement statement detail | 8 | CURR | Currency Key | nvarchar | 5 | 0 | | |
140 | OIURV_TCD | Tax calculation data | 13 | CURR | Currency Key | nvarchar | 5 | 0 | | |
141 | OIUVL_SSTH | Settlement statement header | 10 | CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPWorkbench Tools Editors, Painters, Modelers |
142 | COVMVHID | Table for Storing History Versions | 2 | CURR | Indicator | nvarchar | 1 | 0 | | |
TOPWorkbench Utilities |
143 | FLIGHTM | Flight master data | 9 | CURR | Currency indicator | nvarchar | 3 | 0 | | |