SAP table RIHEQUI (Transfer data for equipment hierarchy)

Field Description Data Type Length Decimals Checktable Data Element
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
SPRAS Language Key LANG 1 0 T002 SPRAS
EQKTX Description of technical object CHAR 40 0 KTX01
EQTYP Equipment category CHAR 1 0 T370T EQTYP
IWERK Maintenance Planning Plant CHAR 4 0 T001W IWERK
SWERK Maintenance Plant CHAR 4 0 T001W SWERK
STORT Asset location CHAR 10 0 T499S STORT
MSGRP Room CHAR 8 0 RAUMNR
BEBER Plant Section CHAR 3 0 T357 BEBER
ABCKZ ABC Indicator for Technical Object CHAR 1 0 T370C ABCKZ
EQFNR Sort Field CHAR 30 0 EQFNR
BUKRS Company Code CHAR 4 0 T001 BUKRS
ANLNR Main Asset Number CHAR 12 0 ANLH ANLN1
ANLUN Asset Subnumber CHAR 4 0 ANLA ANLN2
GSBER Business Area CHAR 4 0 TGSB GSBER
KOSTL Cost Center CHAR 10 0 KOSTL
DAUFN Standing order number CHAR 12 0 AUFK DAUFN
AUFNR Order Number CHAR 12 0 AUFK AUFNR
TPLNR Functional Location CHAR 30 0 IFLOT TPLNR
TIDNR Technical identification number CHAR 25 0 TIDNR
HEQUI Superordinate Equipment CHAR 18 0 EQUI HEQUI
HEQNR Equipment position at InstallLoc (Superior Equip./FunctLoc) CHAR 4 0 HEQNR
SUBMT Construction type material of the object CHAR 40 0 MARA SUBMT
SERNR Serial Number CHAR 18 0 GERNR
MAPAR Manufacturer part number CHAR 30 0 MAPAR
INGRP Planner Group for Customer Service and Plant Maintenance CHAR 3 0 T024I INGRP
ELIEF Vendor number CHAR 10 0 LFA1 ELIEF
ANSWT Acquisition Value CURR 13 2 ANSWT
KRFKZ Referenced Configuration CHAR 1 0 KRFKZ
WAERS Currency Key CUKY 5 0 TCURC WAERS
INVNR Inventory number CHAR 25 0 INVNR
GROES Size/dimension CHAR 18 0 GROSS
BRGEW Gross weight QUAN 13 3 BRGEW
BAUJJ Year of construction CHAR 4 0 BAUJJ
BAUMM Month of construction CHAR 2 0 BAUMM
00
HERST Manufacturer of Asset CHAR 30 0 HERST
HERLD Country/Region of Manufacture CHAR 3 0 T005 HERLD
HZEIN Manufacturer drawing number CHAR 30 0 HZEIN
SERGE Manufacturer's Serial Number CHAR 30 0 SERGE
KUND1 Customer number CHAR 10 0 KNA1 KUND1
KUND2 End customer number CHAR 10 0 KNA1 KUND2
KUND3 Operator CHAR 10 0 KNA1 KUND3
LIZNR Equipment license number CHAR 20 0 LIZNR
ARBPL Work Center CHAR 8 0 ARBPL
GEWRK Main work center for maintenance tasks CHAR 8 0 GEWRK
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAZ Last Changed On DATS 8 0 AEDAT
AENAZ Name of Person Who Changed Object CHAR 12 0 AENAM
DATAB Valid-From Date DATS 8 0 DATAB
BEGRU Technical Object Authorization Group CHAR 4 0 T370B IAUTG
KMATN Configurable Material CHAR 40 0 KMATN
MATNR Material Number CHAR 40 0 MATNR
WERK Plant CHAR 4 0 WERKS_D
TYPBZ Manufacturer model number CHAR 20 0 TYPBZ
LAGER Storage location CHAR 4 0 LGORT_D
CHARGE Batch Number CHAR 10 0 CHARG_D
KUNDE Customer to Whom Serial Number was Delivered CHAR 10 0 KUNDSE
DATBI Valid To Date DATS 8 0 DATBI
STTXT System status line CHAR 40 0 J_STEXT
ILOAN Location and account assignment for technical object CHAR 12 0 ILOA ILOAN
USTXT User Status Line CHAR 40 0 J_ATEXT
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
RBNR Catalog Profile CHAR 9 0 T352B RBNR
PROID Work Breakdown Structure Element (WBS Element) for List CHAR 24 0 I_PM_POSID
EQART Type of Technical Object CHAR 10 0 T370K EQART
ANSDT Acquisition date DATS 8 0 ANDTI
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
ADRNR Addresses: Address Number CHAR 10 0 CADNR
MANDT Client CLNT 3 0 MANDT
NAME_LIST Name for List Displays CHAR 35 0 I_NAME_LST
TEL_NUMBER First telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR1
POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
CITY1 City CHAR 40 0 AD_CITY1
CITY2 District CHAR 40 0 AD_CITY2
COUNTRY Country/Region Key CHAR 3 0 * LAND1
REGION Region (State, Province, County) CHAR 3 0 * REGIO
STREET Street CHAR 60 0 AD_STREET
RKEOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
KOKRS Controlling Area CHAR 4 0 KOKRS
GWLDT_K Customer Warranty Start DATS 8 0 IGWLDT_K
GWLEN_K Warranty End for Customer DATS 8 0 IGWLEN_K
MGANR_K Master Warranty Number for Customer CHAR 20 0 * IMGANR_K
GARTX_K Customer Warranty Description CHAR 40 0 IGARTXL_K
GWLDT_L Vendor Warranty Start DATS 8 0 IGWLDT_L
GWLEN_L Warranty End for Vendor DATS 8 0 IGWLEN_L
MGANR_L Master Warranty Number for Vendor CHAR 20 0 * IMGANR_L
GARTX_L Vendor Warranty Description CHAR 40 0 IGARTXL_L
AULDT First delivery date of the equipment DATS 8 0 AULDT
INBDT First start-up date DATS 8 0 INBDT
EQLFN Consecutive numbering of EquipUsagePeriods on same day NUMC 3 0 EQLFN
SUBMTKTX Construction Type Description CHAR 40 0 SUBMTKTX
EQUZ_ERDAT Date on which the time segment was created DATS 8 0 EQUZ_ERDAT
EQUZ_ERNAM Name of person who created time segment CHAR 12 0 EQUZ_ERNAM
EQUZ_AEDAT Date on which time segment was changed DATS 8 0 EQUZ_AEDAT
EQUZ_AENAM Name of person who changed the time segment CHAR 12 0 EQUZ_AENAM
EQUZN Number of next EquipUsagePeriod on same day NUMC 3 0 EQNNR
TIMBI Equipment usage period time stamp TIMS 6 0 TIMBI
UII Unique Item Identifier CHAR 72 0 UII_CHAR72
IUID_TYPE Structure Type of UII CHAR 10 0 IUID_TYPE
UII_PLANT Plant Responsible for UII CHAR 4 0 UII_PLANT
J_3GDISPO Planning Indicator CHAR 1 0 J_3GDISPO
Can be planned
1 Cannot be planned
J_3GZDEQUI Indicator for Central-Decentral Equipment CHAR 1 0 J_3GZDEQUI
1 Central (equipment)
2 Decentral (equipment)
J_3GEQART Procurement Type for External Equipment CHAR 10 0 J_3GFEQUI J_3GEQART
J_3GKZMENG Item/Multipart Indicator CHAR 1 0 J_3GKZMENG
1 Equipment item
2 Multipart equipment
J_3GKONDE Material Price Group CHAR 2 0 T178 KONDM
J_3GFIKTIV Fictitious Indicator CHAR 1 0 J_3GFIKTIV
J_3GBELTYP Document Categories Allowed CHAR 15 0 J_3GBELTYP
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
J_3GKZLADG Indicator: Relevancy to Loading Costs CHAR 1 0 J_3GLADEKE J_3GKZLADG
J_3GKZBERG Indicator for Provision Fees CHAR 1 0 J_3GKZBERG
None
1 Internal
2 External
3 Internal/External
J_3GEIFR Indicator for Own/External Equipment CHAR 1 0 J_3GEIFR
1 Own
2 External
J_3GVERMEIN Unit of Measure for Settlement UNIT 3 0 T006 J_3GVERMEIN
J_3GZULNR License Plate Number CHAR 15 0 J_3GLICENCE_NUM
/SAPCEM/ABRECHVH Settlement Using Shipping Document CHAR 1 0 /SAPCEM/ABRECHVH
/SAPCEM/ABRECHLG Settlement Using PBE Document CHAR 1 0 /SAPCEM/ABRECHLG
/SAPCEM/DISPOGR Planning Group CHAR 4 0 /SAPCEM/DISPOGRU /SAPCEM/DISPOGR
J_3GEIGNER Owner CHAR 12 0 J_3GEIVERS J_3GEIGNER
J_3GVERWAL Administrator CHAR 12 0 J_3GEIVERS J_3GVERWAL
J_3GPMAUFE PM Order Number (Owner) CHAR 12 0 AUFK J_3GPMAUFE
J_3GPMAUFV PM Order Number (Administrator) CHAR 12 0 AUFK J_3GPMAUFV
J_3GPACHT Leasing Type CHAR 1 0 J_3GPACHT

RIHEQUI foreign key relationships

Table Field Check Table Check Field
0 RIHEQUI ABCKZ T370C ABC indicator for technical objects MANDT
1 RIHEQUI ANLNR ANLH Main asset number BUKRS
1 RIHEQUI ANLNR ANLH Main asset number ANLN1
0 RIHEQUI ANLUN ANLA Asset Master Record Segment BUKRS
0 RIHEQUI ANLUN ANLA Asset Master Record Segment ANLN1
0 RIHEQUI ANLUN ANLA Asset Master Record Segment ANLN2
1 RIHEQUI AUFNR AUFK Order master data AUFNR
0 RIHEQUI BEBER T357 Plant Section MANDT
0 RIHEQUI BEBER T357 Plant Section BEBER
1 RIHEQUI BEGRU T370B Technical object authorization group MANDT
1 RIHEQUI BEGRU T370B Technical object authorization group BEGRU
0 RIHEQUI BUKRS T001 Company Codes BUKRS
1 RIHEQUI DAUFN AUFK Order master data AUFNR
0 RIHEQUI ELIEF LFA1 Supplier Master (General Section) MANDT
0 RIHEQUI ELIEF LFA1 Supplier Master (General Section) LIFNR
1 RIHEQUI EQART T370K Type of technical object MANDT
1 RIHEQUI EQART T370K Type of technical object EQART
0 RIHEQUI EQTYP T370T Equipment categories MANDT
0 RIHEQUI EQTYP T370T Equipment categories EQTYP
1 RIHEQUI EQUNR EQUI Equipment master data MANDT
0 RIHEQUI GEWEI T006 Units of Measurement MANDT
0 RIHEQUI GEWEI T006 Units of Measurement MSEHI
1 RIHEQUI GSBER TGSB Business Areas MANDT
1 RIHEQUI GSBER TGSB Business Areas GSBER
0 RIHEQUI HEQUI EQUI Equipment master data MANDT
1 RIHEQUI HERLD T005 Countries MANDT
1 RIHEQUI HERLD T005 Countries LAND1
0 RIHEQUI ILOAN ILOA PM Object Location and Account Assignment MANDT
0 RIHEQUI ILOAN ILOA PM Object Location and Account Assignment ILOAN
1 RIHEQUI INGRP T024I Maintenance planner groups INGRP
0 RIHEQUI IWERK T001W Plants/Branches MANDT
0 RIHEQUI IWERK T001W Plants/Branches WERKS
1 RIHEQUI J_3GEIGNER J_3GEIVERS Owner/Administrator Master Record J_3GEIGVER
0 RIHEQUI J_3GEQART J_3GFEQUI External Equipment Type J_3GEQART
1 RIHEQUI J_3GKONDE T178 Conditions: Groups for Materials MANDT
1 RIHEQUI J_3GKONDE T178 Conditions: Groups for Materials KONDM
0 RIHEQUI J_3GKZLADG J_3GLADEKE Loading Costs Indicator J_3GKZLADG
1 RIHEQUI J_3GPMAUFE AUFK Order master data AUFNR
0 RIHEQUI J_3GPMAUFV AUFK Order master data AUFNR
1 RIHEQUI J_3GVERMEIN T006 Units of Measurement MANDT
0 RIHEQUI J_3GVERWAL J_3GEIVERS Owner/Administrator Master Record J_3GEIGVER
1 RIHEQUI KUND1 KNA1 General Data in Customer Master MANDT
1 RIHEQUI KUND1 KNA1 General Data in Customer Master KUNNR
0 RIHEQUI KUND2 KNA1 General Data in Customer Master MANDT
0 RIHEQUI KUND2 KNA1 General Data in Customer Master KUNNR
1 RIHEQUI KUND3 KNA1 General Data in Customer Master MANDT
1 RIHEQUI KUND3 KNA1 General Data in Customer Master KUNNR
0 RIHEQUI MEINS T006 Units of Measurement MANDT
0 RIHEQUI MEINS T006 Units of Measurement MSEHI
1 RIHEQUI OBJNR ONR00 General Object Number MANDT
0 RIHEQUI RBNR T352B Technical report MANDT
1 RIHEQUI SPART TSPA Organizational Unit: Sales Divisions MANDT
1 RIHEQUI SPART TSPA Organizational Unit: Sales Divisions SPART
0 RIHEQUI STORT T499S Location MANDT
0 RIHEQUI STORT T499S Location WERKS
1 RIHEQUI SUBMT MARA General Material Data MANDT
1 RIHEQUI SUBMT MARA General Material Data MATNR
0 RIHEQUI SWERK T001W Plants/Branches MANDT
0 RIHEQUI SWERK T001W Plants/Branches WERKS
1 RIHEQUI VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 RIHEQUI VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 RIHEQUI VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 RIHEQUI VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
1 RIHEQUI WAERS TCURC Currency Codes MANDT
1 RIHEQUI WAERS TCURC Currency Codes WAERS