| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/CABN_EX | xChange table for characteristic data | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
2 | /SMERP/CAWN_EX | xChange table - char values (ATINN+ATZHL+ADZHL) | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
3 | /SMERP/DOC_EX | Exchange Table - DMS Documents | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
4 | /SMERP/DOC_FI_EX | Exchange Table - DMS Document Files | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
5 | /SMERP/DOC_LI_EX | Exchange Table - DMS Document Links | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
6 | /SMERP/EAML_EX | Exchange Table - Linear Asset Management | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
7 | /SMERP/KBED_EX | Exchange Table - Capacity Requirements | 10 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
8 | /SMERP/KLAH_EX | xChange Table - Classification Header (CLINT) | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
9 | /SMERP/KSSK_EX | xChange Table - Object To Class Allocation | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
10 | /SMERP/SWOR_EX | xChange table - Class Keyword (CLINT+SPRAS+KLPOS) | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
11 | /SMFND/DEMO_B_EX | Exchange Table - Demo Bookings | 11 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
12 | /SMFND/DEMO_C_EX | Exchange Table - Demo Customers | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
13 | /SMFND/DEMO_F_EX | Exchange Table - Demo Flights | 10 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
14 | /SMFND/OID01_EX | xChange table - SAP Object/GIS Object Id Mapping | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
15 | /SYCLO/ARBPL_EX | Syclo Exchange Table - Work Center | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
16 | /SYCLO/AUFNR_EX | Syclo Exchange Table - Maintenance Work Order | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
17 | /SYCLO/AUFPL_EX | Syclo Exchange Table - Maintenance Work Order | 9 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
18 | /SYCLO/AUSP_EX | Syclo Exchange Table - Maintenance Equipment/FuncLoc CharVal | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
19 | /SYCLO/CHARG_EX | Syclo Exchange Table - Material Batch | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
20 | /SYCLO/EBELN_EX | Syclo Exchange Table - Purchase Order | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
21 | /SYCLO/EQUNR_EX | Syclo Exchange Table - Equipment | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
22 | /SYCLO/FLEET_EX | Syclo Exchange Table - Crew Management | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
23 | /SYCLO/IBASE_EX | Syclo Exchange Table - Installed Base | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
24 | /SYCLO/IBLNR_EX | Syclo Exchange Table - Physical Inventory Document | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
25 | /SYCLO/IVNUM_EX | Syclo Exchange Table - Inventory Documents | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
26 | /SYCLO/KSML_EX | Syclo Exchange Table - Class Char (CLINT+POSNR+ADZHL) | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
27 | /SYCLO/KUNNR_EX | Syclo Exchange Table - Customer Master | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
28 | /SYCLO/LIFNR_EX | Syclo Exchange Table - Vendor Master | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
29 | /SYCLO/LSTAR_EX | Syclo Exchange Table - Cost Center/Activity Type | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
30 | /SYCLO/MATNR1_EX | Syclo Exchange Table - Material Master UoM | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
31 | /SYCLO/MATNR2_EX | Syclo Exchange Table - Material Master CRM Extension | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
32 | /SYCLO/MATNR_EX | Syclo Exchange Table - Material Master | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
33 | /SYCLO/MBLNR_EX | Syclo Exchange Table - Material Document | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
34 | /SYCLO/MDOCM_EX | Syclo Exchange Table - Measurment Document | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
35 | /SYCLO/MELNR_EX | Syclo Exchange Table - Entry List | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
36 | /SYCLO/OBKNR_EX | Syclo Exchange Table - PM Object List | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
37 | /SYCLO/POINT_EX | Syclo Exchange Table - Measuring Point | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
38 | /SYCLO/QMNUM_EX | Syclo Exchange Table - PM/CS/QM notification | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
39 | /SYCLO/RSNUM_EX | Syclo Exchange Table - Material Reservation | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
40 | /SYCLO/STOCK1_EX | Syclo Exchange Table - Material Stock (WERKS, MATNR) | 9 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
41 | /SYCLO/STOCK2_EX | Syclo Exchange Table - Customer Special Stock | 12 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
42 | /SYCLO/STOCK_EX | Syclo Exchange Table - Material Stock Data | 9 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
43 | /SYCLO/TANUM_EX | Syclo Exchange Table - Transfer Order | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
44 | /SYCLO/TBNUM_EX | Syclo Exchange Table - Transfer Requirements | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
45 | /SYCLO/TPLNR_EX | Syclo Exchange Table - Functional Location | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
46 | /SYCLO/VBELN_EX | Exchange Table - SD Sales Document Master | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
47 | /SYCLO/WFLOW_EX | Syclo Exchange Table - Workflow | 7 | REC_STATUS | Exchange table record status | nvarchar | 1 | 0 | | |
48 | EHPRCC_IMPRES | Restrictions for import MDS data | 2 | REC_STATUS | Recipient Status | nvarchar | 1 | 0 | | |
49 | EHPRCD_ICH4 | Chapter 4 Data | 27 | REC_STATUS | Recipient Status | nvarchar | 1 | 0 | | |
50 | T7NOEDG_PRD06 | EDAG - Receptions | 12 | REC_STATUS | EDAG - Receipt status | nvarchar | 9 | 0 | | |
51 | T7NOEDG_TEST06 | EDAG[TEST] - Receptions | 12 | REC_STATUS | EDAG - Receipt status | nvarchar | 9 | 0 | | |
TOPEnvironment, Health and Safety |
52 | /TDAG/CPA_ICH4 | Chapter 4 Data | 27 | REC_STATUS | Recipient Status | nvarchar | 1 | 0 | | |
53 | /TDAG/CPC_IMPRES | Restrictions for import MDS data | 2 | REC_STATUS | Recipient Status | nvarchar | 1 | 0 | | |
TOPLocalization |
54 | IDIN_ASSETTRNS | Asset Transaction Table for India (Block Level) | 7 | REC_STATUS | Record status of Asset Block | nvarchar | 1 | 0 | | |