P_PurRequisitionNoTouch1

Purchase Requisition No Touch1 | view: PMMPRNOTOU | Extraction: Not supported | Component: Reporting
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EKKO, EKPO, EBKN, FM01, T001W, T001K, MMPUR_C_BE_SYREG, CDPOS, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Supplier FK Desired Vendor
Column Name Description
Column Name Description
Column Name Description
CreationDate Requisition (request) date
Column Name Description
PurReqnItemClassification Purchase Reqn Item Classification Show values
PurReqnNoTouchType No Touch Type Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_PURREQUISITIONNOTOUCH1.COMPANYCODE == T001.BUKRS
  • P_PURREQUISITIONNOTOUCH1.MANDT == T001.MANDT
Cost Center
  • Cost Center
  • Client
  • ?
  • ?
  • P_PURREQUISITIONNOTOUCH1.COSTCENTER == CSKS.KOSTL
  • P_PURREQUISITIONNOTOUCH1.MANDT == CSKS.MANDT
  • P_PURREQUISITIONNOTOUCH1.[column in domain "DATBI"] == CSKS.DATBI
  • P_PURREQUISITIONNOTOUCH1.[column in domain "KOKRS"] == CSKS.KOKRS
Material Number
  • Client
  • Material Number
  • P_PURREQUISITIONNOTOUCH1.MANDT == MARA.MANDT
  • P_PURREQUISITIONNOTOUCH1.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURREQUISITIONNOTOUCH1.MANDT == T023.MANDT
  • P_PURREQUISITIONNOTOUCH1.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_PURREQUISITIONNOTOUCH1.MANDT == T001W.MANDT
  • P_PURREQUISITIONNOTOUCH1.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • ?
  • Client
  • P_PURREQUISITIONNOTOUCH1.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_PURREQUISITIONNOTOUCH1.[column in domain "BSTYP"] == T161.BSTYP
  • P_PURREQUISITIONNOTOUCH1.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURREQUISITIONNOTOUCH1.MANDT == T024.MANDT
  • P_PURREQUISITIONNOTOUCH1.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURREQUISITIONNOTOUCH1.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURREQUISITIONNOTOUCH1.MANDT == T024E.MANDT
Desired Vendor
  • Client
  • Desired Vendor
  • P_PURREQUISITIONNOTOUCH1.MANDT == LFA1.MANDT
  • P_PURREQUISITIONNOTOUCH1.SUPPLIER == LFA1.LIFNR