| 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 | | |