SAP ABAP Table MSAM_MO_EQUIPMENT_LIST (Equipment list)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ PM-WOC (Application Component) Maintenance Processing
⤷ MSAM_MO (Package) MSAM for Handheld
⤷ PM-WOC (Application Component) Maintenance Processing
⤷ MSAM_MO (Package) MSAM for Handheld
Basic Data
Table Category | INTTAB | Structure |
Structure | MSAM_MO_EQUIPMENT_LIST | Table Relationship Diagram |
Short Description | Equipment list |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | EQUIPMENT | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | EQUI | |
2 | LANGU | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
3 | LANGU_ISO | LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
4 | EQUIDESCR | KTX01 | TEXT40 | CHAR | 40 | 0 | Description of technical object | ||
5 | EQUICATGRY | EQTYP | EQTYP | CHAR | 1 | 0 | Equipment Category | T370T | |
6 | PLANPLANT | IWERK | WERKS | CHAR | 4 | 0 | Maintenance Planning Plant | T001W | |
7 | MAINTPLANT | SWERK | WERKS | CHAR | 4 | 0 | Maintenance Plant | T001W | |
8 | LOCATION | STORT | AP_STAND | CHAR | 10 | 0 | Asset location | T499S | |
9 | MAINTROOM | RAUMNR | CHAR8 | CHAR | 8 | 0 | Room | ||
10 | PLSECTN | BEBER | BEBER | CHAR | 3 | 0 | Organizational Area | T357 | |
11 | ABCINDIC | ABCKZ | ABCKZ | CHAR | 1 | 0 | ABC Indicator for Technical Object | T370C | |
12 | SORTFIELD | EQFNR | CHAR30 | CHAR | 30 | 0 | Sort Field | ||
13 | COMP_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
14 | ASSET_NO | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | ANLH | |
15 | SUB_NUMBER | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | ANLA | |
16 | BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
17 | COSTCENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
18 | STDGORD | DAUFN | AUFNR | CHAR | 12 | 0 | Standing order number | AUFK | |
19 | ORDERID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
20 | FUNCTLOC | ILOM_STRNO | ILOM_STRNO | CHAR | 40 | 0 | Functional location label | ||
21 | TECHID | TIDNR | TIDNR | CHAR | 25 | 0 | Technical identification number | ||
22 | SUPEREQUI | HEQUI | EQUNR | CHAR | 18 | 0 | Superordinate Equipment | EQUI | |
23 | POSEQUI | HEQNR | CHAR4 | CHAR | 4 | 0 | Equipment position at InstallLoc (Superior Equip./FunctLoc) | ||
24 | CONSTTYPE | SUBMT | MATNR | CHAR | 18 | 0 | Construction Type Material of the Object | MARA | |
25 | SERIALNO | GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
26 | MANPARNO | MAPAR | MAPAR | CHAR | 30 | 0 | Manufacturer part number | ||
27 | PLANGROUP | INGRP | INGRP | CHAR | 3 | 0 | Planner Group for Customer Service and Plant Maintenance | T024I | |
28 | VENDOR | ELIEF | LIFNR | CHAR | 10 | 0 | Vendor number | LFA1 | |
29 | ACQUISVAL | ANSWT | WERT | CURR | 13 | 2 | Acquisition Value | ||
30 | REFERENCE | KRFKZ | X | CHAR | 1 | 0 | Referenced Configuration | ||
31 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
32 | CURRENCY_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
33 | INVENTORY | INVNR | INVNR_ANLA | CHAR | 25 | 0 | Inventory number | ||
34 | INV_SIZE | GROSS | GROES | CHAR | 18 | 0 | Size/dimension | ||
35 | GROSS_WT | BRGEW | MENG13 | QUAN | 13 | 3 | Gross weight | ||
36 | CONSTYR | BAUJJ | CJAHR | CHAR | 4 | 0 | Year of construction | ||
37 | CONSTMTH | BAUMM | BAUMM | CHAR | 2 | 0 | Month of construction | ||
38 | MANFACTURE | HERST | TEXT30 | CHAR | 30 | 0 | Manufacturer of asset | ||
39 | MANCOUNTRY | HERLD | LAND1 | CHAR | 3 | 0 | Country of manufacture | * | |
40 | MANCOUNTRY_ISO | LAND1_ISO | INTCA | CHAR | 2 | 0 | Country key in ISO code | ||
41 | DRAWING | HZEIN | HZEIN | CHAR | 30 | 0 | Manufacturer drawing number | ||
42 | SERNO | SERGE | CHAR30 | CHAR | 30 | 0 | Manufacturer serial number | ||
43 | CUSTOMER | KUND1 | KUNNR | CHAR | 10 | 0 | Customer No. | * | |
44 | ENDCUSTOM | KUND2 | KUNNR | CHAR | 10 | 0 | End customer number | * | |
45 | OPERATOR | KUND3 | KUNNR | CHAR | 10 | 0 | Operator | * | |
46 | LICENSE | LIZNR | CHAR20 | CHAR | 20 | 0 | Equipment license number | ||
47 | WORK_CNTR | ARBPL | ARBPL | CHAR | 8 | 0 | Work center | ||
48 | MN_WK_CTR | GEWRK | ARBPL | CHAR | 8 | 0 | Main work center for maintenance tasks | ||
49 | CREATED_ON | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
50 | CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
51 | CH_ON | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
52 | CHANGED_BY | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
53 | VALID_FROM | DATAB | DATUM | DATS | 8 | 0 | Valid-From Date | ||
54 | AUTHGRP | IAUTG | IAUTG | CHAR | 4 | 0 | Authorization Group for Technical Object | * | |
55 | CONFIGBMAT | KMATN | MATNR | CHAR | 18 | 0 | Configurable Material | * | |
56 | MATERIAL | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
57 | PLANT | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
58 | MANMODEL | TYPBZ | TYPBZ | CHAR | 20 | 0 | Manufacturer model number | ||
59 | STGE_LOC | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
60 | BATCH | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
61 | SERIAL_CUSTOMER | KUNDSE | KUNNR | CHAR | 10 | 0 | Customer to Whom Serial Number was Delivered | * | |
62 | VALID_TO | IDATBI | DATUM | DATS | 8 | 0 | Valid-to Date | ||
63 | S_STATUS | J_STEXT | TEXT40 | CHAR | 40 | 0 | System status line | ||
64 | LOC_ACC | ILOAN | ILOAN | CHAR | 12 | 0 | Location and account assignment for technical object | * | |
65 | U_STATUS | J_ATEXT | TEXT40 | CHAR | 40 | 0 | User Status Line | ||
66 | OBJECT_NO | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
67 | CATPROFILE | RBNR | RBNR | CHAR | 9 | 0 | Report layout | * | |
68 | WBS_ELEMENT | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
69 | EQUITYPE | EQART | EQART | CHAR | 10 | 0 | Type of Technical Object | * | |
70 | ACQDATE | ANDTI | DATUM | DATS | 8 | 0 | Acquisition date | ||
71 | SALESORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
72 | DISTR_CHAN | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
73 | DIVISION | SPART | SPART | CHAR | 2 | 0 | Division | * | |
74 | ADDR_NO | CADNR | CADRNR | CHAR | 10 | 0 | Addresses: Address Number | * | |
75 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
76 | LIST_NAME | I_NAME_LST | NAME | CHAR | 35 | 0 | Name for list displays | ||
77 | TEL1_NUMBR | AD_TLNMBR1 | CHAR30 | CHAR | 30 | 0 | First telephone no.: dialling code+number | ||
78 | POSTL_COD1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
79 | CITY | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
80 | DISTRICT | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
81 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
82 | COUNTRY_ISO | LAND1_ISO | INTCA | CHAR | 2 | 0 | Country key in ISO code | ||
83 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
84 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
85 | PROFIT_SEGM_NO | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
86 | INT_OBJ_NO | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
87 | UNIT_OF_WT | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
88 | UNIT_OF_WT_ISO | MEINS_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Base unit of measure in ISO code | * | |
89 | CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
90 | DELDATE | AULDT | DATUM | DATS | 8 | 0 | First delivery date of the equipment | ||
91 | DATE_OF_FIRST_RUN | INBDT | DATUM | DATS | 8 | 0 | First start-up date | ||
92 | CONSECNO | EQLFN | NUM03 | NUMC | 3 | 0 | Consecutive numbering of EquipUsagePeriods on same day | ||
93 | CONSTTYPE_2 | SUBMTKTX | TXT40 | CHAR | 40 | 0 | Construction Type Description | ||
94 | STOCK_TYPE | LBBSA | LBBSA | CHAR | 2 | 0 | Stock Type of Goods Movement (Primary Posting) | * | |
95 | SPEC_STOCK | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | * | |
96 | CUSTOMER_2 | EKUNN | KUNNR | CHAR | 10 | 0 | Account number of customer | * | |
97 | VENDOR_2 | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | * | |
98 | SALES_ORD | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
99 | S_ORD_ITEM | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
100 | WBS_ELEMENT_SER | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
101 | BATCH_2 | B_CHARGE | CHARG | CHAR | 10 | 0 | Batch Number | * | |
102 | TIME | TIMBI | ZEITBI | TIMS | 6 | 0 | Equipment usage period time stamp | ||
103 | MATL_DESC | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
104 | FUNCLDESCR | PLTXT | TEXT40 | CHAR | 40 | 0 | Description of functional location | ||
105 | CUSTOMER_WAR_DATE | IGWLDT_K | DATUM | DATS | 8 | 0 | Customer Warranty Start | ||
106 | CUSTOMER_WARRANTY | IGWLEN_K | DATUM | DATS | 8 | 0 | Warranty End for Customer | ||
107 | CUSTOMER_MSTR_WRTY | IMGANR_K | MGANR | CHAR | 20 | 0 | Master Warranty Number for Customer | * | |
108 | CUSTOMER_WARRANTY_TEXT | IGARTXL_K | TXT40 | CHAR | 40 | 0 | Customer Warranty Description | ||
109 | VENDOR_WAR_DATE | IGWLDT_L | DATUM | DATS | 8 | 0 | Vendor Warranty Start | ||
110 | VENDOR_WARRANTY | IGWLEN_L | DATUM | DATS | 8 | 0 | Warranty End for Vendor | ||
111 | VENDOR_MSTR_WRTY | IMGANR_L | MGANR | CHAR | 20 | 0 | Master Warranty Number for Vendor | * | |
112 | WARRANTY_TEXT | IGARTXL_L | TXT40 | CHAR | 40 | 0 | Vendor Warranty Description | ||
113 | LONG_TEXT | ILOM_KZLTX | X | CHAR | 1 | 0 | Indicator: Long text exists | ||
114 | TS_CREATED | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
115 | DATE_CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
116 | DATE_CH_ON | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
117 | DATE_CHANGED_BY | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MSAM_MO_EQUIPMENT_LIST | ABCINDIC | T370C | ABCKZ | |||
2 | MSAM_MO_EQUIPMENT_LIST | ASSET_NO | ANLH | ANLN1 | |||
3 | MSAM_MO_EQUIPMENT_LIST | BUS_AREA | TGSB | GSBER | |||
4 | MSAM_MO_EQUIPMENT_LIST | COMP_CODE | T001 | BUKRS | |||
5 | MSAM_MO_EQUIPMENT_LIST | CONSTTYPE | MARA | MATNR | |||
6 | MSAM_MO_EQUIPMENT_LIST | EQUICATGRY | T370T | EQTYP | |||
7 | MSAM_MO_EQUIPMENT_LIST | EQUIPMENT | EQUI | EQUNR | |||
8 | MSAM_MO_EQUIPMENT_LIST | LANGU | T002 | SPRAS | |||
9 | MSAM_MO_EQUIPMENT_LIST | LOCATION | T499S | STAND | |||
10 | MSAM_MO_EQUIPMENT_LIST | MAINTPLANT | T001W | WERKS | |||
11 | MSAM_MO_EQUIPMENT_LIST | ORDERID | AUFK | AUFNR | |||
12 | MSAM_MO_EQUIPMENT_LIST | PLANGROUP | T024I | INGRP | |||
13 | MSAM_MO_EQUIPMENT_LIST | PLANPLANT | T001W | WERKS | |||
14 | MSAM_MO_EQUIPMENT_LIST | PLSECTN | T357 | BEBER | |||
15 | MSAM_MO_EQUIPMENT_LIST | STDGORD | AUFK | AUFNR | |||
16 | MSAM_MO_EQUIPMENT_LIST | SUB_NUMBER | ANLA | ANLN2 | |||
17 | MSAM_MO_EQUIPMENT_LIST | SUPEREQUI | EQUI | EQUNR | |||
18 | MSAM_MO_EQUIPMENT_LIST | VENDOR | LFA1 | LIFNR |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 605 |