I_AuthzdActlEquipmentDetails

View of Equipments relevant for AAC | view: IAUACEQUIDET | Extraction: Not supported | Component: Flexible Material Planning Object
Tables used: PRTE, EQUI, EQBS, EQUZ, USR02, DFS_FE_STRUCAUTH, ILOA, MARA, MAKT, T001W, PROJ, T001L, PRPS, /ISDFPS/FORCE, T77UA
Column Name Description
ForceElementOrgSrceID FK Object ID
Equipment Equipment Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
EquipmentIsInstalled Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
HasEquipmentData Equipment data exists Show values
Column Name Description Domain name
SerialNumber Serial Number GERNR
UniqueItemIdentifier Unique Item Identifier UII_CHAR72
PlantName Plant Name TEXT30
StorageLocationName Storage Location Name TEXT16
MaterialName Material Description TEXT40
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSDescription WBS Element Name TEXT40
FrcElmntOrgName Object Name TEXT40
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Batch Number
  • Client
  • I_AUTHZDACTLEQUIPMENTDETAILS.MATERIAL == MCH1.MATNR
  • I_AUTHZDACTLEQUIPMENTDETAILS.BATCH == MCH1.CHARG
  • I_AUTHZDACTLEQUIPMENTDETAILS.MANDT == MCH1.MANDT
Object ID
  • ?
  • Client
  • Object ID
  • ?
  • I_AUTHZDACTLEQUIPMENTDETAILS.[column in domain "OTYPE"] == PLOGI.OTYPE
  • I_AUTHZDACTLEQUIPMENTDETAILS.MANDT == PLOGI.MANDT
  • I_AUTHZDACTLEQUIPMENTDETAILS.FORCEELEMENTORGSRCEID == PLOGI.OBJID
  • I_AUTHZDACTLEQUIPMENTDETAILS.[column in domain "PLVAR"] == PLOGI.PLVAR
MRP Stock Area
  • MRP Stock Area
  • Client
  • I_AUTHZDACTLEQUIPMENTDETAILS.FRCELMNTORGMRPSTOCKAREA == MDLV.BERID
  • I_AUTHZDACTLEQUIPMENTDETAILS.MANDT == MDLV.MANDT
Plant
  • Plant
  • Client
  • I_AUTHZDACTLEQUIPMENTDETAILS.FRCELMNTORGSTOCKPLANT == T001W.WERKS
  • I_AUTHZDACTLEQUIPMENTDETAILS.MANDT == T001W.MANDT
Storage location
  • Storage location
  • Plant
  • Client
  • I_AUTHZDACTLEQUIPMENTDETAILS.FRCELMNTORGSTOCKSTORAGELOC == T001L.LGORT
  • I_AUTHZDACTLEQUIPMENTDETAILS.FRCELMNTORGSTOCKPLANT == T001L.WERKS
  • I_AUTHZDACTLEQUIPMENTDETAILS.MANDT == T001L.MANDT
Functional Location
  • Functional Location
  • Client
  • I_AUTHZDACTLEQUIPMENTDETAILS.FUNCTIONALLOCATION == IFLOT.TPLNR
  • I_AUTHZDACTLEQUIPMENTDETAILS.MANDT == IFLOT.MANDT
Material Number
  • Material Number
  • Client
  • I_AUTHZDACTLEQUIPMENTDETAILS.MATERIAL == MARA.MATNR
  • I_AUTHZDACTLEQUIPMENTDETAILS.MANDT == MARA.MANDT
Unit of Measure
  • Client
  • Base Unit of Measure
  • I_AUTHZDACTLEQUIPMENTDETAILS.MANDT == T006.MANDT
  • I_AUTHZDACTLEQUIPMENTDETAILS.MATERIALBASEUNIT == T006.MSEHI
Material Group
  • Material Group
  • Client
  • I_AUTHZDACTLEQUIPMENTDETAILS.MATERIALGROUP == T023.MATKL
  • I_AUTHZDACTLEQUIPMENTDETAILS.MANDT == T023.MANDT