P_WrkflwReqnAvgApprovalTime

Workflow PR Avg Approval Time1 | view: PWREQNAVGAPPTIME | Extraction: Not supported | Component: Reporting
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EBKN, SWWWIHEAD, SWWWIHEAD, SWPSTEPLOG, SWWWIHEAD, FM01, T001W, T161, T001K, SWW_WI2OBJ, SWWWICOMMENT, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
Column Name Description
Column Name Description
PurReqCreationDate Requisition (request) date
Column Name Description
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurchaseRequisitionPrice null
ApprovalTime null
ProcurementHubSourceSystem Connected System ID
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_WRKFLWREQNAVGAPPROVALTIME.COMPANYCODE == T001.BUKRS
  • P_WRKFLWREQNAVGAPPROVALTIME.MANDT == T001.MANDT
Cost Center
  • ?
  • Cost Center
  • Client
  • ?
  • P_WRKFLWREQNAVGAPPROVALTIME.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_WRKFLWREQNAVGAPPROVALTIME.COSTCENTER == CSKS.KOSTL
  • P_WRKFLWREQNAVGAPPROVALTIME.MANDT == CSKS.MANDT
  • P_WRKFLWREQNAVGAPPROVALTIME.[column in domain "DATBI"] == CSKS.DATBI
Material Number
  • Client
  • Material Number
  • P_WRKFLWREQNAVGAPPROVALTIME.MANDT == MARA.MANDT
  • P_WRKFLWREQNAVGAPPROVALTIME.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_WRKFLWREQNAVGAPPROVALTIME.MANDT == T023.MANDT
  • P_WRKFLWREQNAVGAPPROVALTIME.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • P_WRKFLWREQNAVGAPPROVALTIME.PLANT == T001W.WERKS
  • P_WRKFLWREQNAVGAPPROVALTIME.MANDT == T001W.MANDT
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Client
  • ?
  • P_WRKFLWREQNAVGAPPROVALTIME.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_WRKFLWREQNAVGAPPROVALTIME.MANDT == T161.MANDT
  • P_WRKFLWREQNAVGAPPROVALTIME.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_WRKFLWREQNAVGAPPROVALTIME.MANDT == T024.MANDT
  • P_WRKFLWREQNAVGAPPROVALTIME.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_WRKFLWREQNAVGAPPROVALTIME.MANDT == T024E.MANDT
  • P_WRKFLWREQNAVGAPPROVALTIME.PURCHASINGORGANIZATION == T024E.EKORG
Desired Vendor
  • Client
  • Desired Vendor
  • P_WRKFLWREQNAVGAPPROVALTIME.MANDT == LFA1.MANDT
  • P_WRKFLWREQNAVGAPPROVALTIME.SUPPLIER == LFA1.LIFNR