| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /XFT/CM_001 | Contract: head | 3 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 2 | /XFT/CM_110 | Contract: Last run deadline monitoring | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 3 | /XFT/CM_C001 | Maintain contract types | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 4 | /XFT/CM_C001T | Maintain contract types | 3 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 5 | /XFT/CM_C001_E1 | Maintain contract types - Extension subscreen header data | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 6 | /XFT/CM_C002 | Maintain contract types: role visibility | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 7 | /XFT/CM_C004 | Maintain contract types - contract state | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 8 | /XFT/CM_C006 | Maintain contract types - Automatic notification | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 9 | /XFT/CM_C011 | Maintain contract management - contract type | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 10 | /XFT/CM_C012 | Cust: Rule exp. of contr. - contr. type - notice period | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 11 | /XFT/CM_C018 | Cust: Rule notice period w/o exp. of contr. - contract type | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 12 | /XFT/CM_C040 | Cust: Automatic deadline monit. - contract types | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 13 | /XFT/CM_C100 | Maintain contract types - toolbar activities | 2 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 14 | /XFT/CM_C100T | Maintain contract types - toolbar activities | 3 | CTYPE | Contract type | nvarchar | 32 | 0 | | |
| 15 | J1IEX_LOCACCLOG | EXIM: Letter of Credit Account log | 3 | CTYPE | EXIM: Bank charge type | nvarchar | 2 | 0 | | |
| 16 | J1IEX_LOCBNKCHRG | EXIM: Letter of Credit bank charges | 3 | CTYPE | EXIM: Bank charge type | nvarchar | 2 | 0 | | |
| 17 | P2CO_COICC | PC2CO_ICC | 8 | CTYPE | Commitment entry type | nvarchar | 1 | 0 | | |
| 18 | P2IN_EPF | Payroll structure for Provident Fund Infotype | 12 | CTYPE | Contribution type | nvarchar | 1 | 0 | | |
| 19 | P2RB_SVCIC | Complementary Indemnity Contributions | 9 | CTYPE | Complementary Indemnity Contribution type | nvarchar | 1 | 0 | | |
| 20 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 7 | CTYPE | XDEC: Costing Type (+ or -) | nvarchar | 1 | 0 | | |
| 21 | P2RN_NARG | Payroll Results: Add. Terms of Employment | 20 | CTYPE | Calculation Type | nvarchar | 1 | 0 | | |
| 22 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 7 | CTYPE | XDEC: Costing Type (+ or -) | nvarchar | 1 | 0 | | |
| 23 | P2RU_TCRT | Payroll results: Tax accumulation (USA) | 8 | CTYPE | Cumulation Type | nvarchar | 1 | 0 | | |
| 24 | PA0615 | HR Master Record: Infotype 0615 | 24 | CTYPE | HESA: Contract type | nvarchar | 2 | 0 | | |
| 25 | RFCTA | RFC stub generation - ABAP/4 data types, RFC data type | 2 | CTYPE | C data type | nvarchar | 15 | 0 | | |
| 26 | T5GPBSC_CTY | HESA: Contract types | 2 | CTYPE | HESA: NHS Contract type | nvarchar | 1 | 0 | | |
| 27 | T5GPBSH_CTY | HESA: Contract types | 2 | CTYPE | HESA: Contract type | nvarchar | 2 | 0 | | |
| 28 | T5GPBSH_CTYT | HESA: Contract types (text) | 3 | CTYPE | HESA: Contract type | nvarchar | 2 | 0 | | |
| 29 | T7CNRM_FRMOPR | Operands for Formula | 8 | CTYPE | Cumulation Type | nvarchar | 1 | 0 | | |
| TOPBasic Functions |
| 30 | BIW_EMMA_CASE | Delta Queue for Process Statistics for Clarification Cases | 4 | CTYPE | Case Type | nvarchar | 4 | 0 | | |
| 31 | EMMAC_CCAT_HDR | Clarification Case Categories | 4 | CTYPE | Case Type | nvarchar | 4 | 0 | | |
| 32 | EMMAC_CTYPE | Case Types | 2 | CTYPE | Case Type | nvarchar | 4 | 0 | | |
| 33 | EMMAC_CTYPET | Short Description of Case Types | 3 | CTYPE | Case Type | nvarchar | 4 | 0 | | |
| 34 | EMMA_CASE | Clarification Case | 9 | CTYPE | Case Type | nvarchar | 4 | 0 | | |
| TOPCCMS Database Monitors for Oracle |
| 35 | SDBAC | DBA Action Table | 9 | CTYPE | Execution mode for DBA action (using ext. program or report) | nvarchar | 3 | 0 | | |
| TOPClaims Management |
| 36 | ICL_CPCFICT2DOC | Permitted Internal Claim Types for Documents | 5 | CTYPE | Internal Claim Type | nvarchar | 4 | 0 | | |
| TOPClientServer Technology |
| 37 | TXCOM | Communications Table | 4 | CTYPE | Communications type | nvarchar | 1 | 0 | | |
| TOPCompensation Management |
| 38 | PA0380 | HR Master Data Record Infotype 0380 (Comp. Adjustment) | 25 | CTYPE | Compensation Component | nvarchar | 4 | 0 | | |
| 39 | PA0382 | HR Master Data Record Infotype 0382 (Award) | 24 | CTYPE | Award | nvarchar | 4 | 0 | | |
| 40 | PA0383 | HR Master Data Record Infotype 0383 (Compensation Package) | 24 | CTYPE | Compensation Component | nvarchar | 4 | 0 | | |
| 41 | T71C0 | Compensation Component | 2 | CTYPE | Compensation Component | nvarchar | 4 | 0 | | |
| 42 | T71C01 | Fixed Compensation Components | 2 | CTYPE | Compensation Component | nvarchar | 4 | 0 | | |
| 43 | T71C02 | Variable Compensation Components | 2 | CTYPE | Compensation Component | nvarchar | 4 | 0 | | |
| 44 | T71C03 | Stock Components | 2 | CTYPE | Compensation Component | nvarchar | 4 | 0 | | |
| 45 | T71C0T | Compensation Component Type Texts | 3 | CTYPE | Compensation Component | nvarchar | 4 | 0 | | |
| 46 | T71C2 | Compensation Package | 3 | CTYPE | Compensation Component | nvarchar | 4 | 0 | | |
| 47 | T71CA | Compensation Adjustment Type | 5 | CTYPE | Compensation Component | nvarchar | 4 | 0 | | |
| TOPConsolidation |
| 48 | TF595 | Elimination of IU Profit/Loss in Inventory: Tasks | 9 | CTYPE | Comparative exchange rate indicator | nvarchar | 1 | 0 | | |
| 49 | TF620 | Changes in Investments | 25 | CTYPE | Exchange rate indicator | nvarchar | 1 | 0 | | |
| 50 | TF630 | Changes in Investee Equity | 18 | CTYPE | Exchange rate indicator | nvarchar | 1 | 0 | | |
| 51 | TF660 | Equity Holdings Adjustments | 14 | CTYPE | Exchange rate indicator | nvarchar | 1 | 0 | | |
| 52 | TF661 | Equity Holdings Adjustments by Upper Unit | 14 | CTYPE | Exchange rate indicator | nvarchar | 1 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 53 | DFKKDEFREV_HEAD | Header Table (Event-Based Deferred Revenues) | 3 | CTYPE | Cost Type/Revenue Type | nvarchar | 4 | 0 | | |
| 54 | DFKKDEFREV_POS | Line Item Table (Event-Based Deferred Revenues) | 3 | CTYPE | Cost Type/Revenue Type | nvarchar | 4 | 0 | | |
| 55 | DFKKDEFREV_TRIG | Trigger Table - Amounts (Event-Based Deferred Revenues) | 3 | CTYPE | Cost Type/Revenue Type | nvarchar | 4 | 0 | | |
| 56 | TFK157 | Deferred Revenue: Cost/Revenue Types | 2 | CTYPE | Cost Type/Revenue Type | nvarchar | 4 | 0 | | |
| 57 | TFK157T | Deferred Revenue: Cost/Revenue Types (Texts) | 3 | CTYPE | Cost Type/Revenue Type | nvarchar | 4 | 0 | | |
| 58 | TFKEBPP | FSCM Biller Direct: Customizing | 4 | CTYPE | Contact Type | nvarchar | 3 | 0 | | |
| TOPCorporate Performance Monitor |
| 59 | UMK_MB020 | Measure Hierarchy | 1 | CTYPE | Object Type | nvarchar | 1 | 0 | | |
| 60 | UMR_RI020 | Risk: Catalog Hierarchy | 2 | CTYPE | Node Type | nvarchar | 1 | 0 | | |
| TOPCustomer Contact |
| 61 | BCONT | Business Partner Contact | 7 | CTYPE | Contact Type | nvarchar | 3 | 0 | | |
| 62 | BCONTT | Contact Type | 2 | CTYPE | Contact Type | nvarchar | 3 | 0 | | |
| 63 | BCONTTT | Contact Types: Texts | 2 | CTYPE | Contact Type | nvarchar | 3 | 0 | | |
| 64 | BPCT_CRM_CLASS | Display Contact Type/Class on CRM Activities | 4 | CTYPE | Contact Type | nvarchar | 3 | 0 | | |
| TOPData Modeler |
| 65 | TDM28 | EDM Clusters | 11 | CTYPE | Type for identifying objects | nvarchar | 1 | 0 | | |
| TOPDatabase Interface, Database Platforms |
| 66 | SDBAC_DATA | DB13: DBA Action Table - Configuration Data Part | 7 | CTYPE | Execution mode for DBA action (using ext. program or report) | nvarchar | 3 | 0 | | |
| TOPEnvironment, Health and Safety |
| 67 | EHQMT_CHARTYPE | EH&S-QM: Types of Characteristics | 2 | CTYPE | EH&S-QM: Type of Characteristic | nvarchar | 1 | 0 | | |
| 68 | EHQMT_CHARTYPET | EH&S-QM: Descriptions of Types of Characteristics | 3 | CTYPE | EH&S-QM: Type of Characteristic | nvarchar | 1 | 0 | | |
| 69 | EHQMT_MAIN2 | EH&S-QM: Characteristics for Inspection Plan Creation | 17 | CTYPE | EH&S-QM: Type of Characteristic | nvarchar | 1 | 0 | | |
| TOPFinancial Accounting |
| 70 | FBICRC01000 | Reconciliation Processes: Attributes | 29 | CTYPE | Communication Type | nvarchar | 1 | 0 | | |
| 71 | FBICRC01010 | Reconciliation Processes: Attributes per Company | 20 | CTYPE | Communication Type | nvarchar | 1 | 0 | | |
| 72 | J_1GWTC0 | Withholding tax certificates data | 5 | CTYPE | Withholding tax certificate type | nvarchar | 1 | 0 | | |
| 73 | J_1GWTC1 | Withholding tax certificate types | 2 | CTYPE | Withholding tax certificate type | nvarchar | 1 | 0 | | |
| 74 | J_1GWTC1T | Withholding tax certificate type descriptions | 3 | CTYPE | Withholding tax certificate type | nvarchar | 1 | 0 | | |
| 75 | J_1GWTC2 | Withholding tax accounts | 6 | CTYPE | Withholding tax certificate type | nvarchar | 1 | 0 | | |
| TOPGreat Britain |
| 76 | T5G31 | Pension Contribution Calculation Rules | 5 | CTYPE | Type of pension contribution calculation rule | nvarchar | 1 | 0 | | |
| TOPIndia |
| 77 | T7INF3 | Statutory rates for Provident fund | 2 | CTYPE | Contribution type | nvarchar | 1 | 0 | | |
| TOPIndonesia |
| 78 | PA0319 | Indonesia Private Insurances | 33 | CTYPE | Contribution Type Indicator | nvarchar | 1 | 0 | | |
| TOPItaly |
| 79 | T5ITUG | Unified reporting: output generation | 5 | CTYPE | Content type | nvarchar | 5 | 0 | | |
| 80 | T5ITUGE | Unified reporting: content types for output generation | 2 | CTYPE | Content type | nvarchar | 5 | 0 | | |
| 81 | T5ITUGET | Unified reporting: Text table for content type | 3 | CTYPE | Content type | nvarchar | 5 | 0 | | |
| 82 | T5ITUG_C | Unified reporting: output generation | 5 | CTYPE | Content type | nvarchar | 5 | 0 | | |
| TOPJust-In-Time Processing |
| 83 | JITCTYPE | JIT Call Type | 2 | CTYPE | Call Type | nvarchar | 1 | 0 | | |
| 84 | JITCTYPE1 | Call Types per Application | 3 | CTYPE | Call Type | nvarchar | 1 | 0 | | |
| 85 | JITCTYPET | Text Table for JIT Call Types | 3 | CTYPE | Call Type | nvarchar | 1 | 0 | | |
| 86 | JITTC0 | User Profile for the JIT Cockpit | 33 | CTYPE | Call Type | nvarchar | 1 | 0 | | |
| TOPLocalization |
| 87 | IDGT_CUSTTYPE | VAT Invoice Type | 3 | CTYPE | VAT Invoice Type | nvarchar | 1 | 0 | | |
| TOPManagement of Internal Controls |
| 88 | FOPCRBFPGLUE | Reporting Buffer: P-CO-R | 8 | CTYPE | Control Type ID | nvarchar | 10 | 0 | | |
| TOPMaterial Master |
| 89 | T134 | Material Types | 30 | CTYPE | Class Type | nvarchar | 3 | 0 | | |
| TOPMove-InOut |
| 90 | ECAMIOPRCONT | IS-U: Pre-entry Document: Contact Data | 4 | CTYPE | Contact Type | nvarchar | 3 | 0 | | |
| TOPPayroll |
| 91 | T5TNEMPRI | HRCZ - sick pay application attachment | 10 | CTYPE | Item creation type | nvarchar | 1 | 0 | | |
| 92 | T7UAQ1 | Quarterly Reports Cumulations | 5 | CTYPE | Cumulation Type | nvarchar | 1 | 0 | | |
| TOPPersonnel Administration |
| 93 | T51CA | Obsolete !!! Replaced by T51CB in April 2002 | 3 | CTYPE | Allowed types for IT0442 | nvarchar | 1 | 0 | | |
| 94 | T51CB | Wagetypes for payrollfunction P0442 | 4 | CTYPE | Allowed types for IT0442 | nvarchar | 1 | 0 | | |
| 95 | T5H5D | Help table to infotype p0441 | 17 | CTYPE | | nvarchar | 1 | 0 | | |
| 96 | T7COTA | Payroll external results transfer: COICC | 8 | CTYPE | Commitment entry type | nvarchar | 1 | 0 | | |
| TOPPersonnel Cost Planning |
| 97 | HRP1015 | Infotype 1015 DB table | 18 | CTYPE | Wage Element (in Personnel Cost Planning) | nvarchar | 14 | 0 | | |
| 98 | T77KL | Wage Elements in Personnel Cost Planning | 2 | CTYPE | Wage Element (in Personnel Cost Planning) | nvarchar | 14 | 0 | | |
| TOPPersonnel Management |
| 99 | T7HR03 | Employee Group/Subgroup HR | 4 | CTYPE | Contract type | nvarchar | 1 | 0 | | |
| TOPPersonnel Time Management |
| 100 | T556C | Counting Rule for Attendances and Absences | 5 | CTYPE | Counting type | nvarchar | 1 | 0 | | |
| 101 | T556D | Absence Counting With/Without Quotas Texts | 6 | CTYPE | Counting type | nvarchar | 1 | 0 | | |
| TOPPricing |
| 102 | PRCC_CTYPE_ATTR | Attributes of a Calculation Type | 2 | CTYPE | Calculation Type for Condition | nvarchar | 3 | 0 | | |
| 103 | PRCC_CTYPE_DEF | Calculation Types in Pricing | 2 | CTYPE | Calculation Type for Condition | nvarchar | 3 | 0 | | |
| 104 | PRCC_CTYPE_T | Descriptions for Calculation Types | 3 | CTYPE | Calculation Type for Condition | nvarchar | 3 | 0 | | |
| TOPProcess Controls |
| 105 | GRPCRBFPGLUE | Reporting Buffer: P-CO-R | 8 | CTYPE | Control Type ID | nvarchar | 10 | 0 | | |
| TOPProcess Management |
| 106 | CMX_XS_DB_XCT | XSteps: BAdI Exits, Custom Node Types | 3 | CTYPE | XSteps: Type of Custom Node | nvarchar | 25 | 0 | | |
| 107 | CMX_XS_DB_XCTT | XSteps: BAdI Exits, Descriptions for Custom Node Types | 3 | CTYPE | XSteps: Type of Custom Node | nvarchar | 25 | 0 | | |
| TOPReporting |
| 108 | T5N6C | Link between Regulations and Calculation Components | 6 | CTYPE | Calculation Type | nvarchar | 1 | 0 | | |
| 109 | T5N6D | Calculation Codes for Regulations | 3 | CTYPE | Calculation Type | nvarchar | 1 | 0 | | |
| TOPReuse Services for Country Development |
| 110 | PA3213 | HR Pensions | 24 | CTYPE | Pension Subtype | nvarchar | 4 | 0 | | |
| 111 | T5F99M12 | Mobility Groups and Means of Transport for Reporting | 4 | CTYPE | Cost Type | nvarchar | 4 | 0 | | |
| 112 | T5F99M3 | Cost Types | 3 | CTYPE | Cost Type | nvarchar | 4 | 0 | | |
| 113 | T5F99M3T | Cost Type Texts | 4 | CTYPE | Cost Type | nvarchar | 4 | 0 | | |
| 114 | T5F99M5 | Connect Feature with Compensation Rules | 5 | CTYPE | Cost Type | nvarchar | 4 | 0 | | |
| 115 | T799BHRF04 | HRF Report output generation | 6 | CTYPE | Content type | nvarchar | 5 | 0 | | |
| 116 | T799BHRF04C | HRF Report customer output generation | 6 | CTYPE | Content type | nvarchar | 5 | 0 | | |
| 117 | T799BHRF07 | HRF Content types for output generation | 2 | CTYPE | Content type | nvarchar | 5 | 0 | | |
| 118 | T799BHRF07T | HRF Content types for output generation texts | 3 | CTYPE | Content type | nvarchar | 5 | 0 | | |
| TOPSpain |
| 119 | PA3231 | Personnel master record infotype 3231 | 24 | CTYPE | Notification type to SPEE | nvarchar | 4 | 0 | | |
| TOPUSA |
| 120 | T5U8A | Transfer ext.payroll result: Tax cumulation data (USA) | 10 | CTYPE | Letter | nvarchar | 1 | 0 | | |
| TOPWeb Service and SOAP - ABAP |
| 121 | SRT_NAME_CACHE | SRT Name Cache | 3 | CTYPE | Use Type for SRT Name Cache | nvarchar | 10 | 0 | | |
