P_PurReqnItemTypeAnalysis

Purchase Requistion No Touch for OVP | view: PMMREQTYPEANA2 | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EBKN, T001, TKA02, FM01, MARA, T023, T023T, MAKT, T001W, T024, T024E, T001K, LFA1, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
CostCenter FK Cost Center
Column Name Description
Column Name Description
Column Name Description
CreationDate Requisition (request) date
Column Name Description
PurReqnItemClassification Purchase Reqn Item Classification Show values
Column Name Description Domain name
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingOrganizationName Purchasing Organization Name TEXT20
SupplierName Name of Supplier TEXT80
MaterialGroupName Product Group Description TEXT20
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
PurReqnItemClassfctnCount null
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_PURREQNITEMTYPEANALYSIS.COMPANYCODE == T001.BUKRS
  • P_PURREQNITEMTYPEANALYSIS.MANDT == T001.MANDT
Cost Center
  • Cost Center
  • ?
  • ?
  • Client
  • P_PURREQNITEMTYPEANALYSIS.COSTCENTER == CSKS.KOSTL
  • P_PURREQNITEMTYPEANALYSIS.[column in domain "DATBI"] == CSKS.DATBI
  • P_PURREQNITEMTYPEANALYSIS.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PURREQNITEMTYPEANALYSIS.MANDT == CSKS.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • P_PURREQNITEMTYPEANALYSIS.FIXEDSUPPLIER == LFA1.LIFNR
  • P_PURREQNITEMTYPEANALYSIS.MANDT == LFA1.MANDT
Material Number
  • Material Number
  • Client
  • P_PURREQNITEMTYPEANALYSIS.MATERIAL == MARA.MATNR
  • P_PURREQNITEMTYPEANALYSIS.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_PURREQNITEMTYPEANALYSIS.MATERIALGROUP == T023.MATKL
  • P_PURREQNITEMTYPEANALYSIS.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • P_PURREQNITEMTYPEANALYSIS.MANDT == T001W.MANDT
  • P_PURREQNITEMTYPEANALYSIS.PLANT == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURREQNITEMTYPEANALYSIS.PURCHASINGGROUP == T024.EKGRP
  • P_PURREQNITEMTYPEANALYSIS.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURREQNITEMTYPEANALYSIS.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURREQNITEMTYPEANALYSIS.MANDT == T024E.MANDT