P_RequisitionTypeAnalysis2

P_RequisitionTypeAnalysis2 | view: PMMREQTYPEANA0 | 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
CreationDate Requisition (request) date
Column Name Description
PurReqnItemClassification Purchase Reqn Item Classification Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurReqnItemClassfctnCount null
NmbrOfFreeTxtItmCrtedFrmSSP Free Text Items (by Employee Self-Service) DEC
NmbrOfMaterialItmCrtedFrmSSP Material Items (by Employee Self-Service) DEC
NmbrOfCatalogItmCrtedFrmSSP Number of Catalog Items via Fiori Application DEC
NmbrOfMaterialItmCrtedManually Material Items (by Procurement) DEC
NmbrOfFreeTxtItmCrtedManually Free Text Items (by Procurement) DEC
Master Data Relations Join Conditions
Fixed Vendor
  • Fixed Vendor
  • Client
  • P_REQUISITIONTYPEANALYSIS2.FIXEDSUPPLIER == LFA1.LIFNR
  • P_REQUISITIONTYPEANALYSIS2.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • P_REQUISITIONTYPEANALYSIS2.MANDT == MARA.MANDT
  • P_REQUISITIONTYPEANALYSIS2.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_REQUISITIONTYPEANALYSIS2.MANDT == T023.MANDT
  • P_REQUISITIONTYPEANALYSIS2.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_REQUISITIONTYPEANALYSIS2.MANDT == T001W.MANDT
  • P_REQUISITIONTYPEANALYSIS2.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • ?
  • Client
  • Purchase Requisition Document Type
  • P_REQUISITIONTYPEANALYSIS2.[column in domain "BSTYP"] == T161.BSTYP
  • P_REQUISITIONTYPEANALYSIS2.MANDT == T161.MANDT
  • P_REQUISITIONTYPEANALYSIS2.PURCHASEREQUISITIONTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • P_REQUISITIONTYPEANALYSIS2.MANDT == T024.MANDT
  • P_REQUISITIONTYPEANALYSIS2.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_REQUISITIONTYPEANALYSIS2.MANDT == T024E.MANDT
  • P_REQUISITIONTYPEANALYSIS2.PURCHASINGORGANIZATION == T024E.EKORG