P_DDPurchaseRequisition

Purchase Requisition Basic Details | view: PDDPURREQDET | Extraction: Not supported | Component: Replenishment Planning & Execution
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
Column Name Description
📏 Purchase requisition unit of measure (PurchaseRequisitionUnit):
TotalQuantity Purchase requisition quantity
OrderedQuantity Quantity ordered against this purchase requisition
OpenQuantity null
Column Name Description
ReleaseDate Purchase Requisition Release Date
DeliveryDate Item delivery date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchaseRequisitionIsFixed Purchase requisition is fixed Show values
Column Name Description Domain name
MaterialName Material Description TEXT40
MRPPlant Supplying (issuing) plant in case of stock transport order WERKS
SupplyingPlant Plant WERKS
SupplierMaterialNumber Material Number Used by Supplier IDNEX
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
MaterialGoodsReceiptDuration Goods receipt processing time in days DEC3
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingGroupPhoneNumber Telephone number of purchasing group (buyer group) CHAR12
PurchasingGroupEmailAddress E-Mail Address AD_SMTPADR
Supplier Desired Vendor LIFNR
SupplierIsFixed null
Master Data Relations Join Conditions
Fixed Vendor
  • Client
  • Fixed Vendor
  • P_DDPURCHASEREQUISITION.MANDT == LFA1.MANDT
  • P_DDPURCHASEREQUISITION.FIXEDSUPPLIER == LFA1.LIFNR
Material Number
  • Material Number
  • Client
  • P_DDPURCHASEREQUISITION.MATERIAL == MARA.MATNR
  • P_DDPURCHASEREQUISITION.MANDT == MARA.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • P_DDPURCHASEREQUISITION.MATERIALPROCUREMENTCATEGORY == T163.PSTYP
  • P_DDPURCHASEREQUISITION.MANDT == T163.MANDT
MRP Controller
  • MRP Controller
  • Client
  • Plant
  • P_DDPURCHASEREQUISITION.MRPCONTROLLER == T024D.DISPO
  • P_DDPURCHASEREQUISITION.MANDT == T024D.MANDT
  • P_DDPURCHASEREQUISITION.PLANT == T024D.WERKS
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_DDPURCHASEREQUISITION.ORDERUNIT == T006.MSEHI
  • P_DDPURCHASEREQUISITION.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • P_DDPURCHASEREQUISITION.MANDT == T001W.MANDT
  • P_DDPURCHASEREQUISITION.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Purchasing Document Category
  • Client
  • P_DDPURCHASEREQUISITION.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_DDPURCHASEREQUISITION.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_DDPURCHASEREQUISITION.MANDT == T161.MANDT
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • P_DDPURCHASEREQUISITION.PURCHASEREQUISITIONUNIT == T006.MSEHI
  • P_DDPURCHASEREQUISITION.MANDT == T006.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_DDPURCHASEREQUISITION.MANDT == T024.MANDT
  • P_DDPURCHASEREQUISITION.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • P_DDPURCHASEREQUISITION.PURCHASINGINFORECORD == EINA.INFNR
  • P_DDPURCHASEREQUISITION.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_DDPURCHASEREQUISITION.PURCHASINGORGANIZATION == T024E.EKORG
  • P_DDPURCHASEREQUISITION.MANDT == T024E.MANDT