| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /GBT/O_SALO_ITM | Sales Document Item for Tracking | 13 | ITEM_TYPE | Item Type | nvarchar | 1 | 0 | | |
| 2 | /MRSS/C_PLANSTAT | Determination of 'Planned Status' of a demand' | 3 | ITEM_TYPE | Demand Item Category | nvarchar | 4 | 0 | | |
| 3 | /OTTM/BL_T_ERA | E-Receipt assignments | 5 | ITEM_TYPE | Item type of e-receipt | nvarchar | 30 | 0 | | |
| 4 | /OTTM/BL_T_ERM | E-Receipt metadata | 5 | ITEM_TYPE | Item type of e-receipt | nvarchar | 30 | 0 | | |
| 5 | /RPM/PORT_ITM_MP | Mapping: Item Types with Portfolio Types (Note 1748331) | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 6 | /SAPSRM/C_IT_TY | Item Types of SRM Procurement Documents incl. initial entry | 1 | ITEM_TYPE | Item Type of Procurement Documents | nvarchar | 4 | 0 | | |
| 7 | /SAPSRM/C_IT_TY0 | Item Types of SRM Procurement Documents, '0' replaces '' | 1 | ITEM_TYPE | Item Type of Procurement Documents | nvarchar | 4 | 0 | | |
| 8 | /SAPSRM/C_IT_TYA | Item Types of SRM Procurement Documents, '0' and ' ' | 1 | ITEM_TYPE | Item Type of Procurement Documents | nvarchar | 4 | 0 | | |
| 9 | /SAPSRM/C_IT_TYT | Text Table for Item Types of SRM Procurement Documents | 1 | ITEM_TYPE | Item Type of Procurement Documents | nvarchar | 4 | 0 | | |
| 10 | /SAPSRM/C_MDA_I1 | Meta Data Configuration for Business Object Item Fields | 5 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 11 | /SAPSRM/C_MDA_IC | Customer Meta Data Configuration for BO Item Fields | 7 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 12 | /SAPSRM/C_MDA_IL | Look-Up Table for Meta Data Configuration for Item Actions | 6 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 13 | /SAPSRM/C_MDA_IT | Meta Data Configuration for Business Object Item Fields | 7 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 14 | /SAPSRM/C_MDF_I1 | Meta Data Configuration for Business Object Item Fields | 5 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 15 | /SAPSRM/C_MDF_IB | Background Table for Meta Data Configuration for Item Fields | 5 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 16 | /SAPSRM/C_MDF_IC | Customer Meta Data Configuration for BO Item Fields | 6 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 17 | /SAPSRM/C_MDF_IL | Look-Up Table for Meta Data Configuration for Item Fields | 5 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 18 | /SAPSRM/C_MDF_IT | Meta Data Configuration for Business Object Item Fields | 6 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 19 | /SAPSRM/C_MDS_I1 | Meta Data Configuration for Business Object Item Fields | 4 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 20 | /SAPSRM/C_MDS_IC | Customer Metadata Configuration for Item Set Types | 6 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 21 | /SAPSRM/C_MDS_IL | Look-Up Table for Metadata Configuration for Item Set Types | 5 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 22 | /SAPSRM/C_MDS_IT | Meta Data Configuration for Business Object Item Fields | 6 | ITEM_TYPE | Item Type of Purchasing Document with ' ' Replaced by '0' | nvarchar | 4 | 0 | | |
| 23 | /XPPM/GW_PRT_CUS | Defaults Customzing | 6 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 24 | BBPC_META_ITM | Meta Data for Items Types | 1 | ITEM_TYPE | Item Category | nvarchar | 4 | 0 | | |
| 25 | GRACREVITEM | Review Request related items | 11 | ITEM_TYPE | Item type for UAR requests | nvarchar | 1 | 0 | | |
| 26 | PSSCC_DBA_ITEM | Decision Basis: Item Control Parameters | 2 | ITEM_TYPE | Item Category (CRM) | nvarchar | 4 | 0 | | |
| 27 | RSBPC_EN_DEFPRE | E&N Master User Preferences for Default Values | 3 | ITEM_TYPE | Item Types for User Preferences | nvarchar | 10 | 0 | | |
| 28 | RSDB2A_CONTROL | DB2 Accelerator: conrol center TOC | 5 | ITEM_TYPE | DB2 Accelerator: Flag | nvarchar | 1 | 0 | | |
| 29 | RSDB2A_STAT | DB2 Accelerator: Load statistics | 5 | ITEM_TYPE | DB2 Accelerator: Flag | nvarchar | 1 | 0 | | |
| 30 | SRMSOCO_DRFT_ITM | Draft Items for FIORI SOCO | 267 | ITEM_TYPE | Single-Character Indicator | nvarchar | 1 | 0 | | |
| 31 | T7CNRMP_DETITM | Determining Factor Item | 5 | ITEM_TYPE | Determining Item Type | nvarchar | 2 | 0 | | |
| 32 | T7CNRMP_RPTGRP | Grouping Dimension for Report | 5 | ITEM_TYPE | Grouping Item Type | nvarchar | 1 | 0 | | |
| 33 | T7CNRMP_RPTSTA | Statistical Dimension for Report | 13 | ITEM_TYPE | Statistical Item Type | nvarchar | 1 | 0 | | |
| 34 | T7CNRMP_SUMITM | Summary Structure Item | 5 | ITEM_TYPE | Summary Item Type | nvarchar | 1 | 0 | | |
| 35 | ZRPM_STATUS | RPM Status | 3 | ITEM_TYPE | Item_type | nvarchar | 15 | 0 | | |
| 36 | ZRPM_WF_RECI | RPM WF Recipient | 2 | ITEM_TYPE | Item_type | nvarchar | 15 | 0 | | |
| TOPAccounts Receivable Accounting Process Integration |
| 37 | FDM_DOC_MIRROR | Document Information (Raw Data in Substitute System) | 3 | ITEM_TYPE | Object Type of Accounting Document | nvarchar | 10 | 0 | | |
| TOPAdvertising Management |
| 38 | TJJCAMP_AM_ITYPE | IS-M/AM: Marketing Campaign - Item Type | 3 | ITEM_TYPE | IS-M: Order-Publishing-Media - Item Type | nvarchar | 2 | 0 | | |
| TOPBasic functions |
| 39 | HUWM_LOAD_PROT | Log Table of Initial Data Transfer for Subsequent Posting | 5 | ITEM_TYPE | Record Type | nvarchar | 1 | 0 | | |
| TOPBusiness Navigator |
| 40 | DF54S | Active nodes for a variant | 3 | ITEM_TYPE | Item type | nvarchar | 2 | 0 | | |
| TOPCollaborative Cross Applications |
| 41 | /POA/D_ENDEFPREF | E&N Master User Preferences for Default Values | 3 | ITEM_TYPE | Item Types for User Preferences | nvarchar | 10 | 0 | | |
| TOPCommunication Channel |
| 42 | ICI_CCS_PARAM | CCS Properties | 2 | ITEM_TYPE | CMSS Parameter Type | nvarchar | 2 | 0 | | |
| TOPCorporate Performance Monitor |
| 43 | UMC_TD100 | Task List | 20 | ITEM_TYPE | Todo item type (info, task, warning, ...) | nvarchar | 1 | 0 | | |
| TOPCross-Application Components |
| 44 | /MRSS/C_CSG_CTRL | MRS relevance of CRM Service orders | 3 | ITEM_TYPE | Demand Item Category | nvarchar | 4 | 0 | | |
| 45 | /MRSS/C_CSG_LOC | Location of Service | 3 | ITEM_TYPE | Demand Item Category | nvarchar | 4 | 0 | | |
| 46 | /MRSS/C_CSG_PROF | MRS : Demand profile mapping | 3 | ITEM_TYPE | Demand Item Category | nvarchar | 4 | 0 | | |
| TOPExchanges |
| 47 | OIA08 | LIA Document: Item Data | 5 | ITEM_TYPE | LIA item type | nvarchar | 1 | 0 | | |
| 48 | OIAQB | Exchange Movements Index | 17 | ITEM_TYPE | LIA item type | nvarchar | 1 | 0 | | |
| TOPFinancial Accounting |
| 49 | J_5KFH_CADVTYPE | Advance accounting control settings | 5 | ITEM_TYPE | Advance item type | nvarchar | 1 | 0 | | |
| TOPGovernance, Risk and Compliance |
| 50 | GRFNMENUITEM | Menu Item | 3 | ITEM_TYPE | (Obsolete) Menu Item Type | nvarchar | 5 | 0 | | |
| 51 | GRFNMENUITEMC | Menu Item - Customer enhancement | 4 | ITEM_TYPE | (Obsolete) Menu Item Type | nvarchar | 5 | 0 | | |
| TOPLogistics - General |
| 52 | CRMD_CO_ITEM | CO Account Assignment of Sales Items | 4 | ITEM_TYPE | Item Category | nvarchar | 4 | 0 | | |
| 53 | CRM_SRV_SCENARIO | Service Logistics Scenarios for Material Withdrawal | 3 | ITEM_TYPE | Item Category | nvarchar | 4 | 0 | | |
| TOPMaintenance Orders |
| 54 | /MRSS/C_AUT_ASGS | Control Automatic Asssignment Creation Based on Status Type | 3 | ITEM_TYPE | Demand Item Category | nvarchar | 4 | 0 | | |
| 55 | /MRSS/C_CSG_SL | Customize the Unit of Measure for slots | 3 | ITEM_TYPE | Demand Item Category | nvarchar | 4 | 0 | | |
| 56 | /MRSS/C_NW_AFD | Assignment follows Demand (NW Addon) | 3 | ITEM_TYPE | Demand Item Category | nvarchar | 4 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 57 | JITCIRCBOOK | IS-M/SD: Circulation Book with Delivery Quantities | 26 | ITEM_TYPE | Internal Item Type for Sales Order | nvarchar | 2 | 0 | | |
| 58 | TJD75 | IS-M: Issue Change Type for Each IS-M/AM Item Category | 3 | ITEM_TYPE | IS-M: Item Category for Sales Document | nvarchar | 4 | 0 | | |
| TOPPortfolio |
| 59 | VDBILL_ITEMS | Billing Items | 3 | ITEM_TYPE | Bill Item Type | nvarchar | 1 | 0 | | |
| TOPPortfolio Management |
| 60 | /RPM/CPDP_MAP | Decision Points to cProjects Phase Mapping | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 61 | /RPM/CPIT_MAP | Item Type to cProjects Templates Mapping | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 62 | /RPM/DP_DP_MAP | Decision Point to Target Decision Point Mapping | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 63 | /RPM/DP_ITEM_TYP | For decision points permitted item types for switching to | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 64 | /RPM/DP_STATUS | Decision Point Status | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 65 | /RPM/DP_STATUS_N | Decision Point Status:Next Possible Statuses | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 66 | /RPM/DP_STATUS_T | Decision Point Status Text | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 67 | /RPM/DP_STA_MAP | Decision Point Status Mapping | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 68 | /RPM/ITEM_CYCLE | Defining Item types in a Life Cycle | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 69 | /RPM/ITEM_D | Operational item persisted data | 31 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 70 | /RPM/ITEM_PHASE | Decision points per Item/Initiative Type | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 71 | /RPM/ITEM_STATUS | Decision Point Status | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 72 | /RPM/ITEM_STAT_N | Decision Point Status:Next Possible Statuses | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 73 | /RPM/ITEM_STAT_T | Decision Point Status Text | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 74 | /RPM/ITEM_TYPE | Item Type | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 75 | /RPM/ITEM_TYPE_T | Item Text | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 76 | /RPM/ITEM_TYP_MP | For Item Types permitted Target Item Types for switching to | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 77 | /RPM/ITM_STA_MAP | Item Type Status Mapping | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 78 | /RPM/ITPSPP_MAP | Item Type to PS Project Profile | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 79 | /RPM/LTXT_I_TYPE | Longtext for Item/Initiative Type | 4 | ITEM_TYPE | Item_type | nvarchar | 15 | 0 | | |
| 80 | /RPM/METRIC | Application specific customization for Metric | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 81 | /RPM/MET_GRP | Application specific customizing for Metric Group | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 82 | /RPM/NADP_MAP | Item Type Decision Point - PS Project Template NA Mapping | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 83 | /RPM/PDDP_MAP | Mapping of PD Phase to RPM Decision point | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 84 | /RPM/PDPIT_MAP | Mapping of PD Concept -ProcessTemplate to RPM Portfolio item | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 85 | /RPM/PHASE_T | Phase Text | 3 | ITEM_TYPE | Item_type | nvarchar | 15 | 0 | | |
| 86 | /RPM/PORT_IP_UI | Override Portfolio Item UI fields-Phase | 4 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 87 | /RPM/PORT_I_UI | Override Portfolio UI fields-Item | 4 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 88 | /RPM/PSPTIT_MAP | Item Type to PS Project template mapping table | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 89 | /RPM/PTIT_MAP | Item Type to Project Type Mapping | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 90 | /RPM/VAL_TYP | Application specific customization for value Type | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 91 | /RPM/WBSDP_MAP | Item Type DecisionPoint - PS Project Template WBS Mapping | 3 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 92 | RPM_ITEM_D_CD | Item details - Pseudo table for change documents | 31 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| 93 | ZNPDI_XRPM2CPR_T | xRPM -> cPro Integration | 2 | ITEM_TYPE | Type | nvarchar | 15 | 0 | | |
| TOPProcess Controls |
| 94 | GRPCMENUITEM | Menu Item | 2 | ITEM_TYPE | Menu Item Type | nvarchar | 5 | 0 | | |
| 95 | GRPCMENUITEMC | Menu Item - Customer enhancement | 3 | ITEM_TYPE | Menu Item Type | nvarchar | 5 | 0 | | |
| TOPPublic Sector Contract Accounts Receivable and Payable |
| 96 | TFMCA_BRF222 | BRF: Parameters for Refund Line Items | 7 | ITEM_TYPE | Refund Item Type | nvarchar | 1 | 0 | | |
| 97 | TFMCA_REFUND | Main/Subtransaction for Refund Items | 4 | ITEM_TYPE | Refund Item Type | nvarchar | 1 | 0 | | |
| TOPPurchasing |
| 98 | WRFT_POHF_POLF | Order List Screen Layout | 2 | ITEM_TYPE | Type of Data Record | nvarchar | 1 | 0 | | |
| TOPRecipe Development |
| 99 | /PLMI/RFO_SUBCAT | Allowed Specification Types for Stream Specifications | 2 | ITEM_TYPE | Formula Item Type | nvarchar | 2 | 0 | | |
| TOPSAP Multiresource Scheduling |
| 100 | /MRSS/C_APPT_TYP | Appointment booking type for PM/CS/CRM Order Types | 3 | ITEM_TYPE | Demand Item Category | nvarchar | 4 | 0 | | |
| TOPShipping |
| 101 | FIP_D_WORKLIST | Worklist Substitution during Goods Receipt | 18 | ITEM_TYPE | Item Type | nvarchar | 1 | 0 | | |
| TOPUnique Identification |
| 102 | IUID_MAN_DATA | Manually Maintained Values for IUID Messages | 15 | ITEM_TYPE | Item Type (End Item or Embedded Item) | nvarchar | 3 | 0 | | |
| 103 | IUID_PEDIGREE | UII IDoc Message Data for Supporting Supplier Collaboration | 15 | ITEM_TYPE | Item Type (End Item or Embedded Item) | nvarchar | 3 | 0 | | |
| TOPWorkforce Management Core |
| 104 | WFDSD_DEMAND | Work Force Deployment Demand | 17 | ITEM_TYPE | Item Category | nvarchar | 4 | 0 | | |
