C_TrackToolUsageTP

Track Tool Usage | view: CTTTUTRACKTOOLTP | Extraction: Not supported | Component: Shop Floor Execution

Tables used: AIN_OBJECT_LINK, AFKO, AFIH, AFKO, MPE_OAN_INSTANCE, MPE_OA_INSTANCE, AFKO, AFVC, JSTO, JEST, MPE_TT_CLAIM_OA, MPE_TT_CLAIM_HST, MPE_TT_CLAIM_USR, MPE_TT_CLAIM_WC, ANLH, T370C, T370C_T, ADCP, ADRC, TGSB, TGSBT, T001, TKA02, TKA01, CSKS, CSKS, CSKT, T370U, EQUI, T370T, CRVE_A, EQBS, EQKT, EQUZ, T370F_T, IFLOS, IFLOS, IFLOT, T370S, IFLOT, T370F, IFLOTX, T499S, ILOA, AUFK, MARA, MAKT, MPE_OAN, MPE_OA_T, AUFK, T001W, T357, CRFH, TC23A, CRTX, T000, T001L, T370K, T370K_T, ADRP, USR21, PRPS, CRHD, FAAT_MD, FAAT_MD_ROOT, ITOBCUST, IFLOUSR, T024I, MPE_OAN_ELEMENT

🔑 Keys (1)
💰 Amounts
∑ Quantities (1)
📅 Dates (2)
☰ Categorical (2)
Other (68)
🔗 Relations (30)

Column Name	Description
Equipment FK	Equipment Number

Column Name	Description

Column Name	Description
📏 Unit of weight (GrossWeightUnit):
GrossWeight	Weight of object

Column Name	Description
CreationDate	Date on which the record was created
LastChangeDate	Last Changed On

Column Name	Description
EquipmentClaimType	Tool Tracking Claim Type	Show values
EquipmentClaimIsAvailable	Truth Value: True/False	Show values

Column Name	Description	Domain name
EquipmentName	Description of technical object	TEXT40
MaterialName	Material Description	TEXT40
SerialNumber	Serial Number	GERNR
UniqueItemIdentifier	Unique Item Identifier	UII_CHAR72
PlantName	Plant Name	TEXT30
MaintenancePlantName	Plant Name	TEXT30
StorageLocation	Storage location	LGORT
StorageLocationName	Storage Location Name	TEXT16
ConcatenatedActiveSystStsName	Concatenated System Status
EquipmentClaimedByUser	Created By	USNAM
UserDescription	User Description	SUIDTECHDESC
EquipmentClaimTypeName	Short Text for Fixed Values
EquipmentHistoryDocument	Document Number	MPE_DOC_NMBR
EquipmentClaimedForText	null
PersonFullName	Description of the Technical User Account	SUIDTECHDESC
Operation	Operation/Activity Number	VORNR
OpActyNtwkElementExternalID	Element Number	MPE_OAN_ELEMENT_NUMBER_EXT
OperationActivityName	Operation Activity Description	MPE_OAN_OBJECT_DESCRIPTION
WorkCenter	Work Center
WorkCenterText	Work Center Text	TEXT40
NmbrOfObjectsClaimingEquipment	null
EquipClaimDurationInSeconds	null
EquipmentClaimDurationText	Text (100 characters)
EquipLastClaimDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
EquipLastUnclaimDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
MaintObjectInternalID	Object number	J_OBJNR
EquipmentIsClaimed	null
EquipmentIsOnHold	null
Criticality	null
TechObjIsEquipOrFuncnlLoc	null
BusinessPartner	Business Partner Number	BU_PARTNER
TechnicalObjectCategoryDesc	Equipment category description
AssetManufacturerName	Manufacturer of Asset	TEXT30
ConcatenatedActiveUserStsName	Concatenated User Status
ManufacturerPartTypeName	Manufacturer model number
ManufacturerPartNmbr	Manufacturer part number
ManufacturerSerialNumber	Manufacturer's Serial Number
PlantSectionPersonRespName	Group of Employees Responsible for Company Area
PlantSectionPersonRespPhone	Phone Number of Employee Group Responsible for Company Area
LocationName	Location Name	TEXT40
AssetRoom	Room
ABCIndicatorDesc	Description of ABC Indicator of Technical Object
PostalCode	City postal code	CHAR10
CityName	City	TEXT40
SuperiorTechnicalObjectLabel	Technical Object Identifier
SuperiorTechnicalObjectName	Technical Object Description
SuperiorObjIsEquipOrFuncnlLoc	Technical Object Type
TechnicalObjectSortCode	Technical identification number
MaintenancePlanningPlantName	Plant Name
MaintenancePlannerGroupName	Name of the Maintenance Planner Group
MainWorkCenter	Work Center
MainWorkCenterDescription	Work Center Text
MainWorkCenterPlantName	Plant Name
CompanyCodeName	Name of Company Code or Company	TEXT25
BusinessAreaName	Business Area Description
MasterFixedAssetDescription	Asset Main Number Text
CostCenterName	Cost Center Name
ControllingAreaName	Controlling Area Name
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSDescription	WBS Element Name
StandingOrderDesc	Description
SettlementOrderDesc	Order Description
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
LastChangedByUser	Name of Person Who Changed Object	USNAM
TechnicalObjectHasLongText	Long Text Indicator
InventoryNumber	Inventory number	INVNR_ANLA
SizeOrDimensionText	Size/dimension	GROES
MaintObjectFreeDefinedAttrib	Sort Field	CHAR30

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`C_TRACKTOOLUSAGETP.ABCINDICATOR == T370C.ABCKZ` `C_TRACKTOOLUSAGETP.MANDT == T370C.MANDT`
Location of maintenance object Location of maintenance object Client ?	`C_TRACKTOOLUSAGETP.ASSETLOCATION == T499S.STAND` `C_TRACKTOOLUSAGETP.MANDT == T499S.MANDT` `C_TRACKTOOLUSAGETP.[column in domain "WERKS_D"] == T499S.WERKS`
Technical Object Authorization Group Technical Object Authorization Group Client	`C_TRACKTOOLUSAGETP.AUTHORIZATIONGROUP == T370B.BEGRU` `C_TRACKTOOLUSAGETP.MANDT == T370B.MANDT`
Business Area Business Area Client	`C_TRACKTOOLUSAGETP.BUSINESSAREA == TGSB.GSBER` `C_TRACKTOOLUSAGETP.MANDT == TGSB.MANDT`
Company Code Company Code Client	`C_TRACKTOOLUSAGETP.COMPANYCODE == T001.BUKRS` `C_TRACKTOOLUSAGETP.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`C_TRACKTOOLUSAGETP.CONTROLLINGAREA == TKA01.KOKRS` `C_TRACKTOOLUSAGETP.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Cost Center Client	`C_TRACKTOOLUSAGETP.[column in domain "DATBI"] == CSKS.DATBI` `C_TRACKTOOLUSAGETP.CONTROLLINGAREA == CSKS.KOKRS` `C_TRACKTOOLUSAGETP.COSTCENTER == CSKS.KOSTL` `C_TRACKTOOLUSAGETP.MANDT == CSKS.MANDT`
Distribution channel Distribution Channel Client Sales Organization	`C_TRACKTOOLUSAGETP.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `C_TRACKTOOLUSAGETP.MANDT == TVKOV.MANDT` `C_TRACKTOOLUSAGETP.SALESORGANIZATION == TVKOV.VKORG`
Division Distribution Channel Client Division Sales Organization	`C_TRACKTOOLUSAGETP.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `C_TRACKTOOLUSAGETP.MANDT == TVTA.MANDT` `C_TRACKTOOLUSAGETP.DIVISION == TVTA.SPART` `C_TRACKTOOLUSAGETP.SALESORGANIZATION == TVTA.VKORG`
Equipment Number Equipment Number Technical Object Client	`C_TRACKTOOLUSAGETP.EQUIPMENT == EQUI.EQUNR` `C_TRACKTOOLUSAGETP.TECHNICALOBJECT == EQUI.EQUNR` `C_TRACKTOOLUSAGETP.MANDT == EQUI.MANDT`
Equipment category Client Equipment category Technical Object Category	`C_TRACKTOOLUSAGETP.MANDT == T370T.MANDT` `C_TRACKTOOLUSAGETP.EQUIPMENTCATEGORY == T370T.EQTYP` `C_TRACKTOOLUSAGETP.TECHNICALOBJECTCATEGORY == T370T.EQTYP`
Asset Subnumber Asset Subnumber Company Code Main Asset Number Client	`C_TRACKTOOLUSAGETP.FIXEDASSET == ANLA.ANLN2` `C_TRACKTOOLUSAGETP.COMPANYCODE == ANLA.BUKRS` `C_TRACKTOOLUSAGETP.MASTERFIXEDASSET == ANLA.ANLN1` `C_TRACKTOOLUSAGETP.MANDT == ANLA.MANDT`
Unit of weight Unit of weight Client	`C_TRACKTOOLUSAGETP.GROSSWEIGHTUNIT == T006.MSEHI` `C_TRACKTOOLUSAGETP.MANDT == T006.MANDT`
Plant Client Plant	`C_TRACKTOOLUSAGETP.MANDT == T001W.MANDT` `C_TRACKTOOLUSAGETP.MAINWORKCENTERPLANT == T001W.WERKS`
Material Number Material Number Client	`C_TRACKTOOLUSAGETP.MATERIAL == MARA.MATNR` `C_TRACKTOOLUSAGETP.MANDT == MARA.MANDT`
Order Number Order Number Settlement order Client	`C_TRACKTOOLUSAGETP.ORDERID == AUFK.AUFNR` `C_TRACKTOOLUSAGETP.SETTLEMENTORDER == AUFK.AUFNR` `C_TRACKTOOLUSAGETP.MANDT == AUFK.MANDT`
Plant Plant Client	`C_TRACKTOOLUSAGETP.PLANT == T001W.WERKS` `C_TRACKTOOLUSAGETP.MANDT == T001W.MANDT`
Plant Section Plant Section Client ?	`C_TRACKTOOLUSAGETP.PLANTSECTION == T357.BEBER` `C_TRACKTOOLUSAGETP.MANDT == T357.MANDT` `C_TRACKTOOLUSAGETP.[column in domain "WERKS_D"] == T357.WERKS`
Sales group Client Sales office Sales group	`C_TRACKTOOLUSAGETP.MANDT == TVBVK.MANDT` `C_TRACKTOOLUSAGETP.SALESOFFICE == TVBVK.VKBUR` `C_TRACKTOOLUSAGETP.SALESGROUP == TVBVK.VKGRP`
Sales organization Client Sales Organization	`C_TRACKTOOLUSAGETP.MANDT == TVKO.MANDT` `C_TRACKTOOLUSAGETP.SALESORGANIZATION == TVKO.VKORG`
Settlement order Order Number Settlement order Client	`C_TRACKTOOLUSAGETP.ORDERID == AUFK.AUFNR` `C_TRACKTOOLUSAGETP.SETTLEMENTORDER == AUFK.AUFNR` `C_TRACKTOOLUSAGETP.MANDT == AUFK.MANDT`
Standing order number Client Standing order number	`C_TRACKTOOLUSAGETP.MANDT == AUFK.MANDT` `C_TRACKTOOLUSAGETP.STANDINGORDERNUMBER == AUFK.AUFNR`
Technical Object Equipment Number Technical Object Client	`C_TRACKTOOLUSAGETP.EQUIPMENT == EQUI.EQUNR` `C_TRACKTOOLUSAGETP.TECHNICALOBJECT == EQUI.EQUNR` `C_TRACKTOOLUSAGETP.MANDT == EQUI.MANDT`
Technical Object Category Client Equipment category Technical Object Category	`C_TRACKTOOLUSAGETP.MANDT == T370T.MANDT` `C_TRACKTOOLUSAGETP.EQUIPMENTCATEGORY == T370T.EQTYP` `C_TRACKTOOLUSAGETP.TECHNICALOBJECTCATEGORY == T370T.EQTYP`
Object ID of the resource ? Client Object ID of the resource	`C_TRACKTOOLUSAGETP.[column in domain "CR_OBJTY"] == CRID.OBJTY` `C_TRACKTOOLUSAGETP.MANDT == CRID.MANDT` `C_TRACKTOOLUSAGETP.WORKCENTERINTERNALID == CRID.OBJID`

Other Relations \| to Master Data Relations ↑	Join Conditions
Planner Group for Customer Service and Plant Maintenance Maintenance Planning Plant Maintenance Planning Plant Planner Group for Customer Service and Plant Maintenance Client	`C_TRACKTOOLUSAGETP.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `C_TRACKTOOLUSAGETP.MAINTENANCEPLANT == T024I.IWERK` `C_TRACKTOOLUSAGETP.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_TRACKTOOLUSAGETP.MANDT == T024I.MANDT`
Maintenance planning plant Maintenance Planning Plant Maintenance Planning Plant Client	`C_TRACKTOOLUSAGETP.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `C_TRACKTOOLUSAGETP.MAINTENANCEPLANT == T399I.IWERK` `C_TRACKTOOLUSAGETP.MANDT == T399I.MANDT`
Maintenance planning plant Maintenance Planning Plant Maintenance Planning Plant Client	`C_TRACKTOOLUSAGETP.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `C_TRACKTOOLUSAGETP.MAINTENANCEPLANT == T399I.IWERK` `C_TRACKTOOLUSAGETP.MANDT == T399I.MANDT`
Sales office Distribution Channel Client Division Sales office Sales Organization	`C_TRACKTOOLUSAGETP.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG` `C_TRACKTOOLUSAGETP.MANDT == TVKBZ.MANDT` `C_TRACKTOOLUSAGETP.DIVISION == TVKBZ.SPART` `C_TRACKTOOLUSAGETP.SALESOFFICE == TVKBZ.VKBUR` `C_TRACKTOOLUSAGETP.SALESORGANIZATION == TVKBZ.VKORG`