P_Purchasereqmassupdate

purchase requisition mass update | view: PMASSUPDATEPR | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, FM01, T001W, LFA1, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice Price in Purchase Requisition
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
Column Name Description
DeliveryDate Item delivery date
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
CreationDate Requisition (request) date
PurReqCreationDate Requisition (request) date
Column Name Description
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
ProcessingStatus Processing status of purchase requisition Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
InvoiceIsExpected Invoice receipt indicator Show values
PurReqnReleaseStatus Requisition Processing State Show values
PurchaseOrderPriceType Use Requisition Price in Purchase Order Show values
Column Name Description Domain name
FormattedPurRequisitionItem null
PurReqnRequestor Requestor
RequirementTracking Requirement Tracking Number CHAR10
PurReqnPriceQuantity Price unit DEC5
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
Batch Batch Number CHARG
MaterialGoodsReceiptDuration Goods receipt processing time in days DEC3
PurchaseRequisitionItemText Short Text TEXT40
SupplierMaterialNumber Material Number Used by Supplier IDNEX
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_PURCHASEREQMASSUPDATE.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_PURCHASEREQMASSUPDATE.MANDT == T163K.MANDT
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • P_PURCHASEREQMASSUPDATE.MANDT == T006.MANDT
  • P_PURCHASEREQMASSUPDATE.BASEUNIT == T006.MSEHI
Company code
  • Company Code
  • Client
  • P_PURCHASEREQMASSUPDATE.COMPANYCODE == T001.BUKRS
  • P_PURCHASEREQMASSUPDATE.MANDT == T001.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • P_PURCHASEREQMASSUPDATE.FIXEDSUPPLIER == LFA1.LIFNR
  • P_PURCHASEREQMASSUPDATE.MANDT == LFA1.MANDT
Material Number
  • Material Number
  • Client
  • P_PURCHASEREQMASSUPDATE.MATERIAL == MARA.MATNR
  • P_PURCHASEREQMASSUPDATE.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_PURCHASEREQMASSUPDATE.MATERIALGROUP == T023.MATKL
  • P_PURCHASEREQMASSUPDATE.MANDT == T023.MANDT
MRP Controller
  • MRP Controller
  • Plant
  • Client
  • P_PURCHASEREQMASSUPDATE.MRPCONTROLLER == T024D.DISPO
  • P_PURCHASEREQMASSUPDATE.PLANT == T024D.WERKS
  • P_PURCHASEREQMASSUPDATE.MANDT == T024D.MANDT
Plant
  • Plant
  • Client
  • P_PURCHASEREQMASSUPDATE.PLANT == T001W.WERKS
  • P_PURCHASEREQMASSUPDATE.MANDT == T001W.MANDT
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • ?
  • Client
  • P_PURCHASEREQMASSUPDATE.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_PURCHASEREQMASSUPDATE.[column in domain "BSTYP"] == T161.BSTYP
  • P_PURCHASEREQMASSUPDATE.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • P_PURCHASEREQMASSUPDATE.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • P_PURCHASEREQMASSUPDATE.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCHASEREQMASSUPDATE.PURCHASINGGROUP == T024.EKGRP
  • P_PURCHASEREQMASSUPDATE.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • P_PURCHASEREQMASSUPDATE.PURCHASINGINFORECORD == EINA.INFNR
  • P_PURCHASEREQMASSUPDATE.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCHASEREQMASSUPDATE.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCHASEREQMASSUPDATE.MANDT == T024E.MANDT
Currency Key
  • Currency Key
  • Client
  • P_PURCHASEREQMASSUPDATE.PURREQNITEMCURRENCY == TCURC.WAERS
  • P_PURCHASEREQMASSUPDATE.MANDT == TCURC.MANDT
Storage location
  • Plant
  • Storage location
  • Client
  • P_PURCHASEREQMASSUPDATE.PLANT == T001L.WERKS
  • P_PURCHASEREQMASSUPDATE.STORAGELOCATION == T001L.LGORT
  • P_PURCHASEREQMASSUPDATE.MANDT == T001L.MANDT
Desired Vendor
  • Desired Vendor
  • Client
  • P_PURCHASEREQMASSUPDATE.SUPPLIER == LFA1.LIFNR
  • P_PURCHASEREQMASSUPDATE.MANDT == LFA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Category of delivery date
  • ?
  • Category of delivery date
  • Client
  • P_PURCHASEREQMASSUPDATE.[column in domain "SPRAS"] == TPRG.SPRAS
  • P_PURCHASEREQMASSUPDATE.DELIVDATECATEGORY == TPRG.PRGBZ
  • P_PURCHASEREQMASSUPDATE.MANDT == TPRG.MANDT