服务通知单
QMEL Quality Notification
AUFNR 服务工单(直接创建才有)
QMFE Quality notification - items
FECOD Problem or Damage Code
 
AFIH 服务工单表头
AUFNR 订单号 QMNUM 通知单(如果不是直接由通知单创建的,就需要去凭证流找)
AFKO(AFPO没有)
rsnum 预留号
RESB 预留
 
IHPA 合作伙伴(售达方、责任人等,只有编号没有描述)(对象号在aufk)
 
代码
QPCD 故障代码、服务类型、Inspection catalog codes
如服务通知单 Catalog = 'D',Code group = ZSER*
 
设备主数据
Table: EQUI - Equipment Master Data
The following are the key fields within the EQUI table:
- ERDAT = Date the Equipment record was created
- ERNAM = Name of person who created the equipment record
- AEDAT = Date the Equipment record was last changed
- EQTYP = Equipment type
- OBJNR = Equipment object number (needed when accessing other equipment tables)
- WERK = Plant(可能为空,去设备的function location找工厂)
- LAGER = Storage Location
BGMKOBJ 设备分配的保固代码(主担保号)
J_OBJNR 对象号(关联equi) MGANR 主担保号
BGMT 保固代码描述
GAKTX
Table: EQUZ - Equipment Time Segment Information
EQUNR 设备号 DATBI 有效截至日期 EQLFN 同一天的设备使用期段连号(001)
- IWERK = Maintenance Planning Plant
- HEQUI = Superior Equipment
GEWRK 工作中心的对象ID( CRHD -Objid )
ILOAN TPLNR Location and account assignment for technical object
Table: EQKT - Equipment Short Texts
The following are the key fields within the EQKT table:
- EQKTX = equipment short description
ILOA Functional Location
ILOAN TPLNR Location and account assignment for technical object
SWERK 维护工厂
IFLOT Functional Location (Table)
注:无修改记录
IFLOTX Functional Location文本
PLTXT
PA0001 HR Master Record: Infotype 0001 (Org. Assignment)
PERNR 人员编号 KOSTL 成本中心 BUKRS 公司代码 WERKS 人事范围(非工厂)
SNAME ENAME
AEDTM 修改日期
注:没有cdhdr,用changed on(AEDTM)
 
installed base
IBSP IB: Installed Base Component - Enhancement/Specialization
First link with IBIN using IBIB-IBASE = IBIN-IBASE
Then link IBIN with IBSP using instance IBIN-INSTANCE = IBSP-INSTANCE
 
V_EQUI_EQBS_SML 序列号和库存地点