| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GBT/O_PORD_HDR | Production Order for Tracking | 17 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
2 | /MRSS/C_PLANSTAT | Determination of 'Planned Status' of a demand' | 2 | ORDER_TYPE | Type of underlying order or operation | nvarchar | 4 | 0 | | |
3 | /MRSS/C_TOBJ_INT | Customizing Table for Technical Object Integration | 2 | ORDER_TYPE | Type of underlying order or operation | nvarchar | 4 | 0 | | |
4 | /MRSS/M_PREV_DEL | Mirror for Prevent Deletion of Operations | 6 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
5 | /MRSS/M_R3_AFD | Mirror for Assignment follows Demand (ERP Addon) | 4 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
6 | /MRSS/M_RSG_AA | Mirror for Allow Abstract Assignment | 5 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
7 | /MRSS/M_RSG_DEAS | Control: Mirror for one own demand for each assignment | 4 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
8 | /MRSS/M_RSG_OITG | Mirror for Control of PM/CS Order Integration | 4 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
9 | /MRSS/M_RSG_SA | Mirror for extended assignments | 5 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
10 | /MRSS/M_RSG_STEF | Control Keys for Production Resources/Tools in Resource Plng | 5 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
11 | /MRSS/M_RSG_ST_V | Mirror for Control-Key Default Values for PRT | 4 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
12 | /MRSS/M_SUPERVSR | Mirror for Site Supervisor Indicator | 4 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
13 | /MRSS/M_TRV_TIME | Mirror for Customizing for travel times | 6 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
14 | /OEE/C_PRDMODEOT | Production Mode Associated Order Type | 3 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
15 | FIKZD_MAT_MOVE | Customizing table for material movements | 12 | ORDER_TYPE | Order category | nvarchar | 2 | 0 | | |
16 | GHO_WELLCLASS | Wellclass table | 8 | ORDER_TYPE | Order Type for Maintenance Orders | nvarchar | 4 | 0 | | |
17 | ZCSM_SRVC_CATLOG | catalog for facility services | 10 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
TOPBrowser-Based PI Sheet Cockpit |
18 | POC_DB_ARC_CONN | Optical Archiving: Link Data (ArchiveLink) | 12 | ORDER_TYPE | Order category | nvarchar | 2 | 0 | | |
TOPCapacity and Resource Planning |
19 | /MRSS/C_MOB_STAT | Assignment of Abstract Status to Plants (Mobile Integration) | 4 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
20 | /MRSS/C_RCT_NPRV | Determination of MRS relevance | 4 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
21 | /MRSS/C_SUPERVSR | Site Supervisor Indicator | 2 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
22 | /MRSS/C_TRV_TIME | Customizing for travel times | 4 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
23 | ALM_ME_ORDERTDEF | MAM 1.0 Obsolete | 3 | ORDER_TYPE | | nvarchar | 4 | 0 | | |
24 | ALM_ME_PMILADEF | MAM 1.0 Obsolete | 3 | ORDER_TYPE | | nvarchar | 4 | 0 | | |
25 | ALM_ME_STDEF1 | MAM 1.0 Obsolete | 3 | ORDER_TYPE | | nvarchar | 4 | 0 | | |
26 | ALM_ME_STDEF3 | MAM 1.0 Obsolete | 3 | ORDER_TYPE | | nvarchar | 4 | 0 | | |
TOPDocument Management Framework |
27 | SKWF_APPLS | KW Framework: Application Table | 2 | ORDER_TYPE | KW Framework: Sort Sequence | nvarchar | 1 | 0 | | |
28 | SKWF_PKG | KW Framework: Packages | 16 | ORDER_TYPE | KW Framework: Sort Sequence | nvarchar | 1 | 0 | | |
TOPExcise Duty |
29 | /BEV2/CS_C_ORDER | Order Types for EMCS Control | 2 | ORDER_TYPE | Sales Document Type | nvarchar | 4 | 0 | | |
TOPIntegration with Manufacturing Execution Systems |
30 | TCOPODIST | Control of Distribution of Production Orders to an MES | 3 | ORDER_TYPE | Order Type for Production Orders | nvarchar | 4 | 0 | | |
TOPMaintenance Orders |
31 | /MRSS/C_FCHG_OBJ | Objects for Checking Field Changes | 3 | ORDER_TYPE | Demand Category | nvarchar | 4 | 0 | | |
32 | /MRSS/C_NW_ABS_A | Extended/Abstract assignments(Netweaver) | 2 | ORDER_TYPE | Type of underlying order or operation | nvarchar | 4 | 0 | | |
33 | /MRSS/C_NW_AFD | Assignment follows Demand (NW Addon) | 2 | ORDER_TYPE | Type of underlying order or operation | nvarchar | 4 | 0 | | |
34 | /MRSS/C_NW_STR_A | Extended/Stretched assignments(Netweaver) | 2 | ORDER_TYPE | Type of underlying order or operation | nvarchar | 4 | 0 | | |
35 | /MRSS/C_NW_SUPVI | Site Supervisor Indicator(Netweaver) | 2 | ORDER_TYPE | Type of underlying order or operation | nvarchar | 4 | 0 | | |
36 | /MRSS/C_NW_TRV_T | Customizing for travel times(Netweaver) | 3 | ORDER_TYPE | Type of underlying order or operation | nvarchar | 4 | 0 | | |
37 | /MRSS/C_PREV_DEL | Prevent Deletion of Operations | 4 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
38 | /MRSS/C_R3_AFD | Assignment follows Demand (ERP Addon) | 2 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
39 | /MRSS/C_RSG_AA | Allow Abstract Assignment | 3 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
40 | /MRSS/C_RSG_DEAS | Control: one own demand for each assignment | 2 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
41 | /MRSS/C_RSG_OITG | Control of PM/CS Order Integration | 2 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
42 | /MRSS/C_RSG_SA | Extended assignments | 3 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
43 | /MRSS/C_RSG_STEF | Control Keys for Production Resources/Tools in Resource Plng | 3 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
44 | /MRSS/C_RSG_ST_V | Control-Key Default Values for Production Resources & Tools | 2 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
45 | /MRSS/C_SGU_SRTP | Features of sort groups | 4 | ORDER_TYPE | Type of underlying order or operation | nvarchar | 4 | 0 | | |
TOPMaintenance Processing |
46 | ALM_ME_C012DEF | Define Order Type Profile | 3 | ORDER_TYPE | Order Type for Maintenance Orders | nvarchar | 4 | 0 | | |
47 | ALM_ORD_TYP_SD | Order Type Maintenance for Server Driven push of orders | 2 | ORDER_TYPE | Order Type for Maintenance Orders | nvarchar | 4 | 0 | | |
48 | MSAM_CORTYPDEF | Details for Order Type Profile | 3 | ORDER_TYPE | Order Type for Maintenance Orders | nvarchar | 4 | 0 | | |
TOPMaterials Management |
49 | /ISDFPS/CRBAPRIO | Priority Control for PM Order | 2 | ORDER_TYPE | Order Type | nvarchar | 4 | 0 | | |
TOPMedia Product Sales and Distribution |
50 | JKSENIP | IS-M: Shipping Schedule | 12 | ORDER_TYPE | IS-M: Sales Document Type | nvarchar | 4 | 0 | | |
51 | TJORDERGEN | IS-M: Controls for Use of Copying Control | 3 | ORDER_TYPE | Order Sales Document Type | nvarchar | 4 | 0 | | |
52 | TJSEORDERDEST | IS-M: Control Table for Order Generation | 3 | ORDER_TYPE | Sales Document Type | nvarchar | 4 | 0 | | |
TOPPeriodical Sales and Distribution |
53 | JVSOH | IS-M/SD Shipping Order Header | 15 | ORDER_TYPE | IS-M/SD: Sales Document Types | nvarchar | 4 | 0 | | |
54 | JVTMCP_HEADER | IS-M: TMCP Issue | 11 | ORDER_TYPE | IS-M/SD: Sales Document Types | nvarchar | 4 | 0 | | |
TOPProduction Orders |
55 | COMPF | OCM: Names of compared fields | 7 | ORDER_TYPE | Order category | nvarchar | 2 | 0 | | |
TOPSAP Multiresource Scheduling |
56 | /MRSS/C_APPT_TYP | Appointment booking type for PM/CS/CRM Order Types | 2 | ORDER_TYPE | Type of underlying order or operation | nvarchar | 4 | 0 | | |
TOPStock Visibility |
57 | /DSD/SV_RLD_ORD | DSD SV: Reload Order Type Determination | 3 | ORDER_TYPE | Sales Document Type | nvarchar | 4 | 0 | | |
TOPTariffs, Duties and Permits |
58 | OIH_J1B_SAL | Brazil: Check table for tax codes in sales process | 13 | ORDER_TYPE | Sales Document Type | nvarchar | 4 | 0 | | |
59 | OIH_J1B_SAL_2 | Brazil: ICMS Deferment | 10 | ORDER_TYPE | Sales Document Type | nvarchar | 4 | 0 | | |
TOPWaste Management |
60 | EWA_ORDER_OBJECT | Item Table for Waste Disposal Order | 41 | ORDER_TYPE | Processing of Waste Disposal Order | nvarchar | 2 | 0 | | |