SAP ABAP Table SMOEQUI (Equipment master data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MSA (Application Component) Mobile Sales
⤷ SMO3 (Package) Consolidated Database
⤷ CRM-MSA (Application Component) Mobile Sales
⤷ SMO3 (Package) Consolidated Database
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | SMOEQUI | Table Relationship Diagram |
Short Description | Equipment master data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | SFAEQUI | SMO_SFAEQI | SMO_GUID | CHAR | 32 | 0 | SFA Key of Equipment (EQUI) | ||
3 | SFAMARA | SMO_SFAMAR | SMO_GUID | CHAR | 32 | 0 | SFA Key of Material | ||
4 | SOURCE | SMO_SOURCE | SMO_SOURCE | CHAR | 3 | 0 | Source of an object | ||
5 | EQUNR | SMO3EQUNR | SMO3EQUNR | CHAR | 18 | 0 | Equipment number | ||
6 | ERDAT | SMO3ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
7 | ERNAM | SMO3ERNAM | USNAM | CHAR | 12 | 0 | Name of person who created the object | ||
8 | EQASP | SMO_LANGU | SMO_LANGU | CHAR | 2 | 0 | Language | ||
9 | AEDAT | SMO3AEDAT | DATUM | DATS | 8 | 0 | Last changed on | ||
10 | AENAM | SMO3AENAM | USNAM | CHAR | 12 | 0 | Name of person who changed object | ||
11 | EQTYP | SMO3EQTYP | SMO3EQTYP | CHAR | 1 | 0 | Equipment category | ||
12 | EQART | SMO3EQART | SMO3EQART | CHAR | 10 | 0 | Type of technical object | ||
13 | GROES | SMO3GROSS | SMO3GROES | CHAR | 18 | 0 | Size/dimension | ||
14 | BRGEW | SMO3BRGEW | MENG13 | QUAN | 13 | 3 | Gross weight | ||
15 | GEWEI | SMO3GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
16 | ANSDT | SMO3ANDTI | DATUM | DATS | 8 | 0 | Acquisition date | ||
17 | ANSWT | SMO_DMBTR | CURR | 28 | 9 | Amount in local currency | |||
18 | WAERS | SMO3WAERS | WAERS | CUKY | 5 | 0 | Currency key | * | |
19 | GWLEN | SMO3GWLEN | DATUM | DATS | 8 | 0 | Date on which the warranty ends | ||
20 | GWLDT | SMO3GWLDT | DATUM | DATS | 8 | 0 | Guarantee date | ||
21 | HERST | SMO3HERST | TEXT30 | CHAR | 30 | 0 | Manufacturer of asset | ||
22 | HERLD | SMO3HERLD | LAND1 | CHAR | 3 | 0 | Country of manufacture | * | |
23 | SERGE | SMO3SERGE | CHAR30 | CHAR | 30 | 0 | Manufacturer serial number | ||
24 | TYPBZ | SMO3TYPBZ | SMO3TYPBZ | CHAR | 20 | 0 | Manufacturer model number | ||
25 | BAUJJ | SMO3BAUJJ | CJAHR | CHAR | 4 | 0 | Year of construction | ||
26 | BAUMM | SMO3BAUMM | SMO3BAUMM | CHAR | 2 | 0 | Month of construction | ||
27 | AULDT | SMO3AULDT | DATUM | DATS | 8 | 0 | First delivery date of the equipment | ||
28 | INBDT | SMO3INBDT | DATUM | DATS | 8 | 0 | First start-up date | ||
29 | EQLFN | SMO3EQLFN | NUM03 | NUMC | 3 | 0 | Consecutive numbering of EquipUsagePeriods on same day | ||
30 | EQBER | SMO3EQBER | CHAR30 | CHAR | 30 | 0 | Text for notes | ||
31 | OBJNR | SMO3J_OBJ | SMO3J_OBJ | CHAR | 22 | 0 | Object number | ||
32 | CONFIG_ID | SMO_CONFID | SMO_CONFID | CHAR | 8 | 0 | Identity code for configuration | ||
33 | INST_ID | SMO_INSCID | SMO_TXT8 | CHAR | 8 | 0 | SCE Instance ID | ||
34 | ROOT_ID | SMO_ROOTID | SMO_CONFID | CHAR | 8 | 0 | Configuration Root ID | ||
35 | CUOBJ | SMO3CUOBJ | SMO3CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
36 | KRFKZ | SMO3KRFKZ | X | CHAR | 1 | 0 | Referenced Configuration | ||
37 | MATNR | SMO3MATNR | SMO3MATNR | CHAR | 40 | 0 | Material number | ||
38 | SERNR | SMO3GERNR | SMO3GERNR | CHAR | 18 | 0 | Serial number | ||
39 | WERK | SMO3WERKS | SMO3WERKS | CHAR | 4 | 0 | Plant | ||
40 | KUNDE | SMO3KUNDS | SMO3KUNNR | CHAR | 10 | 0 | Customer to Whom Serial Number was Delivered | ||
41 | EQP_STATUS | SMO_EQSTAT | SMO_ST2 | CHAR | 2 | 0 | Equipment Status | ||
42 | KV_BEDPOT | SMO_BEDPOT | SMO_TXT10 | CHAR | 10 | 0 | Potential of beds (pharmaceutical) | ||
43 | NON_GUID | SMO_NGUID | SMO_NGUID | DEC | 1 | 0 | Not Guided Record | ||
44 | .INCLUDE | 0 | 0 | Communication Fields for Mobile Sales/Service | |||||
45 | TR_USER | SMO_TR_USR | SMO_TR_USR | CHAR | 32 | 0 | Transaction User | ||
46 | TR_ID | SMO_TR_ID | SMO_TR_ID | CHAR | 32 | 0 | Transaction Identifier | ||
47 | TR_STATUS | SMO_TR_STS | SMO_TR_STS | CHAR | 4 | 0 | Status of Transaction | ||
48 | TIMESTAMP | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
49 | DELETED | SMO_DELETD | SMO_DELETD | CHAR | 1 | 0 | Mobile Sales Deleted | ||
50 | TR_ROOTID | SMO_RTGUID | SMO_GUID | CHAR | 32 | 0 | Identifier of BDoc Root object |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in |