C_HistMaterialsMalfuncManage

Historic Materials | view: CHISTMAT | Extraction: Not supported | Component: Plant Maintenance
Tables used: MATDOC, JSTO, JEST, MATDOC_EXTRACT, MARA, T418, EQUI, EQKT, EQUZ, IFLOS, T370S, IFLOT, IFLOTX, ILOA, MARA, MAKT, NRIV, TQ80, MARA, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, T001W, T418V, ITOBCUST, IFLOUSR, EAM_PLANT, TPAER, /SAPSLL/TUNOS
Column Name Description
TechnicalObject Technical Object
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
Material Material Number
NotificationType FK Notification Type
MaintenanceOrderType FK Order Type
Column Name Description
Column Name Description
📏 Weight Unit (MaterialWeightUnit):
MaterialGrossWeight Gross weight
MaterialNetWeight Net weight
MatlWrhsStkQtyInMatlBaseUnit null
MatlWrhsStkQtyOnPlantLvl null
📏 Base Unit of Measure (MaterialBaseUnit):
RequirementQuantityInBaseUnit Requirement Quantity
Column Name Description
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
MaterialAvailabilityStatus Material Availability Show values
MaterialHasThumbnail Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
IsMarkedForDeletion Flag Material for Deletion at Plant Level Show values
Column Name Description Domain name
StorageLocation Storage location LGORT
Plant Plant WERKS
MaterialName Material Description TEXT40
RcrrcOfMatlUsageInTechObj null
MaterialManufacturerPartNumber Manufacturer Part Number CHAR40
AvailabilityCheckType Checking Group for Availability Check MTVFP
MaterialThumbnailMIMEType HTML content type W3_CONTTYP
AuthorizationGroup Authorization Group BEGRU
Master Data Relations | to Other Relations ↓ Join Conditions
Controlling Area
  • Client
  • Controlling Area
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == TKA01.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • C_HISTMATERIALSMALFUNCMANAGE.[column in domain "DATBI"] == CSKS.DATBI
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == CSKS.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.CONTROLLINGAREA == CSKS.KOKRS
  • C_HISTMATERIALSMALFUNCMANAGE.COSTCENTER == CSKS.KOSTL
Order Type
  • Order Type
  • Client
  • C_HISTMATERIALSMALFUNCMANAGE.MAINTENANCEORDERTYPE == T003O.AUART
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == T003O.CLIENT
Maintenance Plant
  • Client
  • Maintenance Plant
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == T001W.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.MAINTENANCEPLANT == T001W.WERKS
Unit of Measure
  • Client
  • Base Unit of Measure
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == T006.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.MATERIALBASEUNIT == T006.MSEHI
Material Group
  • Client
  • Material Group
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == T023.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.MATERIALGROUP == T023.MATKL
Manufacturer Number
  • Client
  • Manufacturer number
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == LFA1.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.MATERIALMANUFACTURERNUMBER == LFA1.LIFNR
Material type
  • Material type
  • Client
  • C_HISTMATERIALSMALFUNCMANAGE.MATERIALTYPE == T134.MTART
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == T134.MANDT
Unit of Weight
  • Client
  • Weight Unit
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == T006.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.MATERIALWEIGHTUNIT == T006.MSEHI
Notification Type
  • Client
  • Notification Type
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == TQ80.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.NOTIFICATIONTYPE == TQ80.QMART
Technical Object Authorization Group
  • Client
  • Technical Object Authorization Group
  • Authorization Group
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == T370B.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.TECHOBJAUTHORIZATIONGROUP == T370B.BEGRU
  • C_HISTMATERIALSMALFUNCMANAGE.AUTHORIZATIONGROUP == T370B.BEGRU
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • C_HISTMATERIALSMALFUNCMANAGE.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == T024I.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance planning plant
  • Client
  • Maintenance Planning Plant
  • C_HISTMATERIALSMALFUNCMANAGE.MANDT == T399I.MANDT
  • C_HISTMATERIALSMALFUNCMANAGE.MAINTENANCEPLANNINGPLANT == T399I.IWERK