C_ReqnAvgApprovalTime

Requisition Average Approval Time | view: CREQNAVGAPPTIME | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingCategory null
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
SupplierName Name of Supplier TEXT80
SupplierCountry Supplier Country/Region LAND1
CountryName Country/Region Name TEXT50
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
PlantName Plant Name TEXT30
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
CreatedByUser Name of Person Responsible for Creating the Object USNAM
AverageApprovalTime Overall Average Approval Time DEC
ApprovalDaysForLowCostItems Approval Days for Low-Cost Items Below 500 Euro DEC
ApprovalDaysForMediumCostItems Approval Days for Medium-Cost Items Between 500 & 1000 Euro DEC
ApprovalDaysForHighCostItems Approval Days for High-Cost Items Between 1000 and 2500 Euro DEC
ApprvlDaysForVeryHighCostItems Approval Days for Very High-Cost Items Above 2500 Euro DEC
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • C_REQNAVGAPPROVALTIME.COMPANYCODE == T001.BUKRS
  • C_REQNAVGAPPROVALTIME.MANDT == T001.MANDT
Cost Center
  • Cost Center
  • ?
  • ?
  • Client
  • C_REQNAVGAPPROVALTIME.COSTCENTER == CSKS.KOSTL
  • C_REQNAVGAPPROVALTIME.[column in domain "DATBI"] == CSKS.DATBI
  • C_REQNAVGAPPROVALTIME.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_REQNAVGAPPROVALTIME.MANDT == CSKS.MANDT
Material Number
  • Client
  • Material Number
  • C_REQNAVGAPPROVALTIME.MANDT == MARA.MANDT
  • C_REQNAVGAPPROVALTIME.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_REQNAVGAPPROVALTIME.MANDT == T023.MANDT
  • C_REQNAVGAPPROVALTIME.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • C_REQNAVGAPPROVALTIME.PLANT == T001W.WERKS
  • C_REQNAVGAPPROVALTIME.MANDT == T001W.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_REQNAVGAPPROVALTIME.PURCHASINGGROUP == T024.EKGRP
  • C_REQNAVGAPPROVALTIME.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_REQNAVGAPPROVALTIME.PURCHASINGORGANIZATION == T024E.EKORG
  • C_REQNAVGAPPROVALTIME.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_REQNAVGAPPROVALTIME.SUPPLIER == LFA1.LIFNR
  • C_REQNAVGAPPROVALTIME.MANDT == LFA1.MANDT