IEQT_WL_ITEMS

Interim Statuses - Items | #transactional | Component: Equipment

🔑 Keys (5)
💰 Amounts
∑ Quantities
📅 Dates (9)
☰ Categorical (43)
Other (32)
🔗 Relations (23)

Column Name	Description
MANDT	Client
EQUNR	Equipment Number
LSTTYP	List Type
EVENT_DATE	Valid-From Date
EVENT_TIME	Valid-From Time

Column Name	Description

Column Name	Description

Column Name	Description
EVENT_DATE	Valid-From Date
EVENT_TIME	Valid-From Time
DATBI	Valid To Date
ERDAT	Date on which the record was created
AEDAT	Last Changed On
TIMBI	Equipment usage period time stamp
DATAB	Valid-From Date
EZDAT	Date, intended for SAP internal use
BLDAT	Document Date in Document

Column Name	Description
EVENT_TYPE	Type of Event	Show values
NOTIF_CREATE	Create Notification	Show values
NOTIF_REFER	Link to Existing Notification	Show values
NOTIF_NOT_REQ	Notification is Not Required	Show values
NOTIF_DELETE	Delete Notification	Show values
NOTIF_UNDEFINED	Notification is Undefined	Show values
PROCESSED	Checkbox	Show values
CCM_PLRMV	Checkbox	Show values
CCM_UPRMV	Checkbox	Show values
CCM_USCND	Checkbox	Show values
CCM_SVCND	Checkbox	Show values
CCM_UKCND	Checkbox	Show values
IWERKI	Data origin indicator	Show values
INGRPI	Data origin indicator	Show values
PM_OBJTY	Object Type of CIM Resources for Work Center	Show values
GEWRKI	Data origin indicator	Show values
TIDNRI	Data origin indicator	Show values
RBNR_I	Data origin indicator	Show values
FRCFIT	Indicator: Forced Installation/Dismantling	Show values
FRCRMV	Force Dismantling Flag	Show values
ABCKZI	Data origin for ABC indicator field	Show values
EQFNRI	Data origin for sort field	Show values
SWERKI	Data origin for maintenance plant field	Show values
STORTI	Data origin for location field	Show values
MSGRPI	Data origin for room number field	Show values
BEBERI	Data origin for plant section field	Show values
CR_OBJTY	Object types of the CIM resource	Show values
PPSIDI	Data origin for PP work center field	Show values
GSBERI	Data origin for business area field	Show values
KOKRSI	Data origin for controlling area field	Show values
KOSTLI	Data origin for cost center field	Show values
PROIDI	Data origin for WBS element field	Show values
BUKRSI	Data origin for company code field	Show values
ANLNRI	Data origin for asset main no./sub-no. fields	Show values
ANLUNI	Data origin indicator	Show values
DAUFNI	Data origin of standing order number field	Show values
AUFNRI	Data origin for settlement order field	Show values
TPLNRI	Data origin for functional location field	Show values
VKORGI	Data origin for sales organization field	Show values
VTWEGI	Data origin of distribution channel field	Show values
SPARTI	Data origin for division field	Show values
ADRNRI	Data origin for address field	Show values
OWNER	Object reference indicator	Show values

Column Name	Description	Domain name
FIELD_CNT	Amount of Changed Fields	INT1
EQLFN	Consecutive numbering of EquipUsagePeriods on same day	NUM03
EQUZN	Number of next EquipUsagePeriod on same day	NUM03
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
ESTAI	SAP Development Reserve: Format CHAR, Length 1	CHAR1
ESTAE	SAP Development reserve: Format CHAR, length 4	CHAR4
STNAM	SAP Development Reserve: Format CHAR, Length 12	CHAR12
LVORM	SAP Development Reserve: Format CHAR, Length 1	CHAR1
IWERK	Maintenance Planning Plant	WERKS
SUBMT	Construction type material of the object	MATNR
MAPAR	Manufacturer part number	MAPAR
HEQUI	Superordinate Equipment	EQUNR
HEQNR	Equipment position at InstallLoc (Superior Equip./FunctLoc)	CHAR4
INGRP	Planner Group for Customer Service and Plant Maintenance	INGRP
GEWRK	Object ID of the Work Center	CR_OBJID
TIDNR	Technical identification number	TIDNR
ILOAN	Location and account assignment for technical object	ILOAN
KUND1	Customer number	KUNNR
KUND2	End customer number	KUNNR
KUND3	Operator	KUNNR
LIZNR	Equipment license number	CHAR20
RBNR	Catalog Profile	RBNR
EZBER	Technical information, intended for SAP internal use	CHAR30
EZNUM	Numerical field, intended for SAP internal use	NUM9
IBLNR	Physical Inventory Document	BELNR
PVS_FOCUS	Internal Identification for PVS Objects	SYSUUID
PPEGUID	Internal Identification for PVS Objects	SYSUUID
TECHS	Parameter Variant/Standard Variant	TECHS
FUNCID	Function Identifier	CHAR40
EQFNR	Sort Field	CHAR30
MSGRP	Room	CHAR8

Master Data Relations	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`IEQT_WL_ITEMS.ABCKZ == T370C.ABCKZ` `IEQT_WL_ITEMS.MANDT == T370C.MANDT`
Address Number Address Number ? ?	`IEQT_WL_ITEMS.MANDT == ADRC.CLIENT` `IEQT_WL_ITEMS.ADRNR == ADRC.ADDRNUMBER` `IEQT_WL_ITEMS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM` `IEQT_WL_ITEMS.[column in domain "AD_NATION"] == ADRC.NATION`
Asset Subnumber Asset Subnumber Company Code Main Asset Number	`IEQT_WL_ITEMS.MANDT == ANLA.MANDT` `IEQT_WL_ITEMS.ANLUN == ANLA.ANLN2` `IEQT_WL_ITEMS.BUKRS == ANLA.BUKRS` `IEQT_WL_ITEMS.ANLNR == ANLA.ANLN1`
Settlement order Settlement order Client	`IEQT_WL_ITEMS.AUFNR == AUFK.AUFNR` `IEQT_WL_ITEMS.MANDT == AUFK.MANDT`
Plant Section Plant Section Client Maintenance Plant	`IEQT_WL_ITEMS.BEBER == T357.BEBER` `IEQT_WL_ITEMS.MANDT == T357.MANDT` `IEQT_WL_ITEMS.SWERK == T357.WERKS`
Company Code	`IEQT_WL_ITEMS.MANDT == T001.MANDT` `IEQT_WL_ITEMS.BUKRS == T001.BUKRS`
Standing order number Standing order number Client	`IEQT_WL_ITEMS.DAUFN == AUFK.AUFNR` `IEQT_WL_ITEMS.MANDT == AUFK.MANDT`
Business Area	`IEQT_WL_ITEMS.MANDT == TGSB.MANDT` `IEQT_WL_ITEMS.GSBER == TGSB.GSBER`
Controlling Area	`IEQT_WL_ITEMS.MANDT == TKA01.MANDT` `IEQT_WL_ITEMS.KOKRS == TKA01.KOKRS`
Cost Center ? Cost Center Controlling Area	`IEQT_WL_ITEMS.MANDT == CSKS.MANDT` `IEQT_WL_ITEMS.[column in domain "DATBI"] == CSKS.DATBI` `IEQT_WL_ITEMS.KOSTL == CSKS.KOSTL` `IEQT_WL_ITEMS.KOKRS == CSKS.KOKRS`
Object ID of PP work center Object ID of PP work center Object types of the CIM resource Client	`IEQT_WL_ITEMS.PPSID == CRID.OBJID` `IEQT_WL_ITEMS.CR_OBJTY == CRID.OBJTY` `IEQT_WL_ITEMS.MANDT == CRID.MANDT`
Division Sales Organization Distribution Channel Division Client	`IEQT_WL_ITEMS.VKORG == TVTA.VKORG` `IEQT_WL_ITEMS.VTWEG == TVTA.VTWEG` `IEQT_WL_ITEMS.SPART == TVTA.SPART` `IEQT_WL_ITEMS.MANDT == TVTA.MANDT`
Location of maintenance object Location of maintenance object Client Maintenance Plant	`IEQT_WL_ITEMS.STORT == T499S.STAND` `IEQT_WL_ITEMS.MANDT == T499S.MANDT` `IEQT_WL_ITEMS.SWERK == T499S.WERKS`
Maintenance Plant	`IEQT_WL_ITEMS.MANDT == T001W.MANDT` `IEQT_WL_ITEMS.SWERK == T001W.WERKS`
Functional Location	`IEQT_WL_ITEMS.MANDT == IFLOT.MANDT` `IEQT_WL_ITEMS.TPLNR == IFLOT.TPLNR`
Sales group Sales group Sales office	`IEQT_WL_ITEMS.MANDT == TVBVK.MANDT` `IEQT_WL_ITEMS.VKGRP == TVBVK.VKGRP` `IEQT_WL_ITEMS.VKBUR == TVBVK.VKBUR`
Sales Organization	`IEQT_WL_ITEMS.MANDT == TVKO.MANDT` `IEQT_WL_ITEMS.VKORG == TVKO.VKORG`
Distribution Channel Sales Organization Client Distribution Channel	`IEQT_WL_ITEMS.VKORG == TVKOV.VKORG` `IEQT_WL_ITEMS.MANDT == TVKOV.MANDT` `IEQT_WL_ITEMS.VTWEG == TVKOV.VTWEG`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Sales Organization Client Distribution Channel Division Sales office	`IEQT_WL_ITEMS.VKORG == TVKBZ.VKORG` `IEQT_WL_ITEMS.MANDT == TVKBZ.MANDT` `IEQT_WL_ITEMS.VTWEG == TVKBZ.VTWEG` `IEQT_WL_ITEMS.SPART == TVKBZ.SPART` `IEQT_WL_ITEMS.VKBUR == TVKBZ.VKBUR`