SAP ABAP Table RIEQUI (Internal Structure for IEQUI)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ IQSM (Package) Application Development R/3 Serial Numbers
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ IQSM (Package) Application Development R/3 Serial Numbers
Basic Data
Table Category | INTTAB | Structure |
Structure | RIEQUI | Table Relationship Diagram |
Short Description | Internal Structure for IEQUI |
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 | .INCLUDE | 0 | 0 | Equipment master data | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | EQUNR | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
4 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
5 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
6 | EQASP | EQASP | SPRAS | LANG | 1 | 0 | Language in which the piece of equipment was entered | T002 | |
7 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
8 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
9 | BEGRU | IAUTG | IAUTG | CHAR | 4 | 0 | Authorization Group for Technical Object | T370B | |
10 | EQTYP | EQTYP | EQTYP | CHAR | 1 | 0 | Equipment Category | T370T | |
11 | EQART | EQART | EQART | CHAR | 10 | 0 | Type of Technical Object | T370K | |
12 | LVORM | RESERVE_CHAR_001 | CHAR1 | CHAR | 1 | 0 | SAP Development Reserve: Format CHAR, Length 1 | ||
13 | INVNR | INVNR | INVNR_ANLA | CHAR | 25 | 0 | Inventory number | ||
14 | GROES | GROSS | GROES | CHAR | 18 | 0 | Size/dimension | ||
15 | BRGEW | OBJ_WEIGHT | MENG13 | QUAN | 13 | 3 | Weight of object | ||
16 | GEWEI | WEIGHT_UNIT | MEINS | UNIT | 3 | 0 | Unit of weight | T006 | |
17 | ANSDT | ANDTI | DATUM | DATS | 8 | 0 | Acquisition date | ||
18 | ANSWT | ANSWT | WERT | CURR | 13 | 2 | Acquisition Value | ||
19 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
20 | ELIEF | ELIEF | LIFNR | CHAR | 10 | 0 | Vendor number | LFA1 | |
21 | GWLEN | GWLEN | DATUM | DATS | 8 | 0 | Date on which the warranty ends | ||
22 | GWLDT | GWLDT | DATUM | DATS | 8 | 0 | Guarantee date | ||
23 | WDBWT | WDBWT | WERT | CURR | 13 | 2 | Equipment replacement value | ||
24 | HERST | HERST | TEXT30 | CHAR | 30 | 0 | Manufacturer of asset | ||
25 | HERLD | HERLD | LAND1 | CHAR | 3 | 0 | Country of manufacture | T005 | |
26 | HZEIN | HZEIN | HZEIN | CHAR | 30 | 0 | Manufacturer drawing number | ||
27 | SERGE | SERGE | CHAR30 | CHAR | 30 | 0 | Manufacturer serial number | ||
28 | TYPBZ | TYPBZ | TYPBZ | CHAR | 20 | 0 | Manufacturer model number | ||
29 | BAUJJ | BAUJJ | CJAHR | CHAR | 4 | 0 | Year of construction | ||
30 | BAUMM | BAUMM | BAUMM | CHAR | 2 | 0 | Month of construction | ||
31 | APLKZ | APLKZ | APLKZ | CHAR | 1 | 0 | Indicator: Task List Exists | ||
32 | AULDT | AULDT | DATUM | DATS | 8 | 0 | First delivery date of the equipment | ||
33 | INBDT | ILOM_DATAB | DATUM | DATS | 8 | 0 | Start-up Date of the Technical Object | ||
34 | GERNR | GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
35 | EQLFN | EQLFN | NUM03 | NUMC | 3 | 0 | Consecutive numbering of EquipUsagePeriods on same day | ||
36 | GWLDV | GWLDV | DATUM | DATS | 8 | 0 | Warranty date for Sales and Distribution | ||
37 | EQDAT | EQDAT | DATUM | DATS | 8 | 0 | Date | ||
38 | EQBER | EQBER | CHAR30 | CHAR | 30 | 0 | Text for Notes | ||
39 | EQNUM | EQNUM | NUM9 | NUMC | 9 | 0 | Numerical Field | ||
40 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
41 | EQSNR | EQSNR | EQSNR | CHAR | 18 | 0 | EQSE Number | EQSE | |
42 | CUOBJ | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
43 | KRFKZ | KRFKZ | X | CHAR | 1 | 0 | Referenced Configuration | ||
44 | KMATN | KMATN | MATNR | CHAR | 18 | 0 | Configurable Material | MARA | |
45 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
46 | SERNR | GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
47 | WERK | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
48 | LAGER | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
49 | CHARGE | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
50 | KUNDE | KUNDSE | KUNNR | CHAR | 10 | 0 | Customer to Whom Serial Number was Delivered | KNA1 | |
51 | WARPL | WARPL | WARPL | CHAR | 12 | 0 | Maintenance Plan | MPLA | |
52 | IMRC_POINT | IMRC_POINT | IMRC_POINT | CHAR | 12 | 0 | Measuring Point | IMPTT | |
53 | REVLV | REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
54 | MGANR | MGANR | MGANR | CHAR | 20 | 0 | Master warranty number | BGMK | |
55 | BEGRUI | INH_BEGRUI | INHER | CHAR | 1 | 0 | Data origin for authorization group field | ||
56 | S_EQUI | EQUIP_KNZ | X | CHAR | 1 | 0 | Equipment | ||
57 | S_SERIAL | KZKSD | X | CHAR | 1 | 0 | Serial data when maintaining equipment | ||
58 | S_KONFI | KONFKNZ | XFELD | CHAR | 1 | 0 | Configuration supported | ||
59 | S_SALE | SDKNZ | XFELD | CHAR | 1 | 0 | Sales equipment | ||
60 | S_FHM | FHMKZ | XFLAG | CHAR | 1 | 0 | Equip. category relevant to production resources and tools | ||
61 | S_ELSE | ELSE_KNZ | X | CHAR | 1 | 0 | Indicator: Other Data Active | ||
62 | S_ISU | ISU_KNZ | X | CHAR | 1 | 0 | IS-U data | ||
63 | S_EQBS | KZEQBS | KZEQBS | CHAR | 1 | 0 | EQSI Exists | ||
64 | S_FLEET | FLEET_KNZ | X | CHAR | 1 | 0 | Indicator: Fleet object active | ||
65 | BSTVP | BSTVP | BSTVP | CHAR | 1 | 0 | Stock Check for Serial Numbers | ||
66 | SPARTE | SPARTE | SPART | CHAR | 2 | 0 | Division | TSPA | |
67 | HANDLE | ITOBTMP_TSEGGUID | SYSUUID_22 | CHAR | 22 | 0 | SAP Development Reserve: Integration of Date Segment (Key) | ||
68 | TSEGTP | ITOBTMP_TSEGTEMPLA | TSEGTEMPLA | CHAR | 10 | 0 | SAP Development Reserve: Integration Date Segment (Template) | * | |
69 | EMATN | EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | * | |
70 | ACT_CHANGE_AA | AAPM_ACT_CHANGE_AA | AAPM_ACT | CHAR | 1 | 0 | Change Equipment Master when Changing Asset | ||
71 | S_CC | CCC_KNZ | X | CHAR | 1 | 0 | Configuration Control Data | ||
72 | DATLWB | DATLWB | DATS | DATS | 8 | 0 | Date of Last Goods Movement | ||
73 | UII | UII_CHAR72 | UII_CHAR72 | CHAR | 72 | 0 | Unique Item Identifier | ||
74 | IUID_TYPE | IUID_TYPE | IUID_TYPE | CHAR | 10 | 0 | Structure Type of UII | TIUID_TYPE | |
75 | UII_PLANT | UII_PLANT | WERKS | CHAR | 4 | 0 | Plant Responsible for UII | * | |
76 | .INCLUDE | 0 | 0 | ||||||
77 | .INCLU--AP | 0 | 0 | Equipment Add On for Bw SDP | |||||
78 | EQEXT_ACTIVE | /ISDFPS/DE_LM_DB_EQEXT_ACTIVE | XFELD | CHAR | 1 | 0 | Backpack Table /isdfps/lmeqext Active | ||
79 | .INCLU--AP | 0 | 0 | Enhancements to Shift Note/Report | |||||
80 | EQUI_SRTYPE | COCF_SR_SRTYPE | CHAR | 10 | 0 | Shift Report Type | COCF_CU_SRTYPE | ||
81 | EQUI_SNTYPE | COCF_SN_SNTYPE | QMART | CHAR | 2 | 0 | Shift Note Type | TQ80 | |
82 | .INCLU--AP | 0 | 0 | Logbook Equi Append | |||||
83 | EQLB_DUTY | DIACL_DUTY | XFLAG | CHAR | 1 | 0 | Logbook Duty | ||
84 | EQLB_HIDE | DIACL_HIDE | XFLAG | CHAR | 1 | 0 | Hide Logbook Display | ||
85 | .INCLUDE | 0 | 0 | Data Part EQBS & BSINF | |||||
86 | LBBSA | LBBSA | LBBSA | CHAR | 2 | 0 | Stock Type of Goods Movement (Primary Posting) | T156C | |
87 | B_WERK | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
88 | B_LAGER | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
89 | B_CHARGE | B_CHARGE | CHARG | CHAR | 10 | 0 | Batch Number | * | |
90 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | * | |
91 | KUNNR | B_KUNNR | KUNNR | CHAR | 10 | 0 | Customer account number | * | |
92 | LIFNR | B_LIFNR | LIFNR | CHAR | 10 | 0 | Account number of the vendor | * | |
93 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
94 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
95 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
96 | DBKNZ | DBKNZ | FLAG | CHAR | 1 | 0 | Data base indicator | ||
97 | EQUPD | EQUPD | CHAR1 | CHAR | 1 | 0 | Indicator: Create Equipment/Equipment Created | ||
98 | BSUPD | BSUPD | CHAR1 | CHAR | 1 | 0 | Indicator: Stock Info Serial Number Updates (D/ /U) | ||
99 | STUPD | STUPD | CHAR1 | CHAR | 1 | 0 | Temporary Status | ||
100 | CUUPD | IEQM_CUUPD | XFELD | CHAR | 1 | 0 | Indicator: Temporary configuration object | ||
101 | PAUPD | PAUPD | CHAR1 | CHAR | 1 | 0 | Update Flag for Partners at Serialized Object | ||
102 | LIEFERANT | ELIEF | LIFNR | CHAR | 10 | 0 | Vendor number | * | |
103 | J_VORGANG | J_VORGANG | J_VORGANG | CHAR | 4 | 0 | Business Transaction | * | |
104 | PARVW | PARVW | PARVW | CHAR | 2 | 0 | Partner Role | * | |
105 | OBKNR | OBJKNR | OBJKN | INT4 | 10 | 0 | Object list number | * | |
106 | MATNR_OLD | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
107 | KUND1 | KUND1 | KUNNR | CHAR | 10 | 0 | Customer No. | * | |
108 | KUND2 | KUND2 | KUNNR | CHAR | 10 | 0 | End customer number | * | |
109 | KUND3 | KUND3 | KUNNR | CHAR | 10 | 0 | Operator | * | |
110 | RECUPD_EX | RECUPD_EX | CHAR1 | CHAR | 1 | 0 | Flag Showing Whether User Exit Triggers Data Record Update | ||
111 | CUOBJ_OLD | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
112 | UII_ACTIVITY | J_VORGANG | J_VORGANG | CHAR | 4 | 0 | Business Transaction | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RIEQUI | BEGRU | T370B | BEGRU | REF | C | CN |
2 | RIEQUI | CHARGE | MCH1 | CHARG | |||
3 | RIEQUI | ELIEF | LFA1 | LIFNR | REF | 1 | CN |
4 | RIEQUI | EQART | T370K | EQART | REF | C | CN |
5 | RIEQUI | EQASP | T002 | SPRAS | KEY | 1 | CN |
6 | RIEQUI | EQSNR | EQSE | EQSNR | KEY | 1 | C |
7 | RIEQUI | EQTYP | T370T | EQTYP | REF | 1 | CN |
8 | RIEQUI | EQUI_SNTYPE | TQ80 | QMART | KEY | 1 | CN |
9 | RIEQUI | EQUI_SRTYPE | COCF_CU_SRTYPE | SRTYPE | KEY | 1 | CN |
10 | RIEQUI | GEWEI | T006 | MSEHI | REF | 1 | CN |
11 | RIEQUI | HERLD | T005 | LAND1 | REF | 1 | CN |
12 | RIEQUI | IMRC_POINT | IMPTT | POINT | |||
13 | RIEQUI | IUID_TYPE | TIUID_TYPE | IUID_TYPE | |||
14 | RIEQUI | KMATN | MARA | MATNR | REF | 1 | CN |
15 | RIEQUI | KUNDE | KNA1 | KUNNR | |||
16 | RIEQUI | LAGER | T001L | LGORT | |||
17 | RIEQUI | LBBSA | T156C | LBBSA | |||
18 | RIEQUI | MANDT | T000 | MANDT | KEY | 1 | CN |
19 | RIEQUI | MATNR | MARA | MATNR | |||
20 | RIEQUI | MGANR | BGMK | MGANR | |||
21 | RIEQUI | SPARTE | TSPA | SPART | KEY | 1 | CN |
22 | RIEQUI | WAERS | TCURC | WAERS | REF | 1 | CN |
23 | RIEQUI | WARPL | MPLA | WARPL | |||
24 | RIEQUI | WERK | T001W | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |