C_PurchaseReqMassUpdate

Purchase Requisition Mass Update | view: CPRMASSUPDATE | TRAN | Extraction: Not supported | Component: Purchase Requisitions

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, T163I, T163K, FM01, T024D, T001W, EINA, T163, T163Y, LFA1, T001K, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates (3)
☰ Categorical
Other (28)
🔗 Relations (19)

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
CreationDate	Requisition (request) date
DeliveryDate	Item delivery date
PurchaseRequisitionReleaseDate	Purchase Requisition Release Date

Column Name	Description

Column Name	Description	Domain name
FormattedPurRequisitionItem	null
AcctAssignmentCategoryName	Account Assignment Category Description	TEXT20
PurReqnRequestor	Requestor
MRPControllerName	MRP Controller Name	TEXT18
ProcessingStatus	Processing status of purchase requisition
ProcessingStatusName	Short Text for Fixed Values	DDTEXT
InvoiceIsExpected	Invoice receipt indicator
PurgDocExternalItemCategory	Item Category in Purchasing Document
PurgDocItemCategoryName	Text for Item Category	TEXT20
PurchasingCategory	Purchasing Category ID	/SRMSMC/OBJECT_ID
PurgCatName	Name of Purchasing Category	/SRMSMC/MEDIUM_NAME
RequirementTracking	Requirement Tracking Number
PurchaseRequisitionItemText	Short Text
MaterialGoodsReceiptDuration	Goods receipt processing time in days
PurReqnPriceQuantity	Price unit
MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment
GoodsReceiptIsExpected	Goods Receipt Indicator
GoodsReceiptIsNonValuated	Goods Receipt, Non-Valuated
PurchasingInfoRecordDesc	Short Text for Purchasing Info Record	TEXT40
Batch	Batch Number	CHARG
SupplierMaterialNumber	Material Number Used by Supplier
PurReqnReleaseStatus	Requisition Processing State
MemoLine	null
DefectCodeText	null
ItemIsSelectedForProcessing	null
InternalComment	null
PurchaseOrderPriceType	Use Requisition Price in Purchase Order
PurchaseOrderPriceTypeDesc	Short Text for Fixed Values	DDTEXT

Master Data Relations	Join Conditions
Account Assignment Category Client Account Assignment Category	`C_PURCHASEREQMASSUPDATE.MANDT == T163K.MANDT` `C_PURCHASEREQMASSUPDATE.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Purchase requisition unit of measure Client Purchase requisition unit of measure	`C_PURCHASEREQMASSUPDATE.MANDT == T006.MANDT` `C_PURCHASEREQMASSUPDATE.BASEUNIT == T006.MSEHI`
Company code Client Company Code	`C_PURCHASEREQMASSUPDATE.MANDT == T001.MANDT` `C_PURCHASEREQMASSUPDATE.COMPANYCODE == T001.BUKRS`
Fixed Vendor Client Fixed Vendor	`C_PURCHASEREQMASSUPDATE.MANDT == LFA1.MANDT` `C_PURCHASEREQMASSUPDATE.FIXEDSUPPLIER == LFA1.LIFNR`
Material Number Client Material Number	`C_PURCHASEREQMASSUPDATE.MANDT == MARA.MANDT` `C_PURCHASEREQMASSUPDATE.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_PURCHASEREQMASSUPDATE.MANDT == T023.MANDT` `C_PURCHASEREQMASSUPDATE.MATERIALGROUP == T023.MATKL`
MRP Controller Client Plant MRP Controller	`C_PURCHASEREQMASSUPDATE.MANDT == T024D.MANDT` `C_PURCHASEREQMASSUPDATE.PLANT == T024D.WERKS` `C_PURCHASEREQMASSUPDATE.MRPCONTROLLER == T024D.DISPO`
Plant Client Plant	`C_PURCHASEREQMASSUPDATE.MANDT == T001W.MANDT` `C_PURCHASEREQMASSUPDATE.PLANT == T001W.WERKS`
Purchase Requisition Document Type Client Purchase Requisition Document Type ?	`C_PURCHASEREQMASSUPDATE.MANDT == T161.MANDT` `C_PURCHASEREQMASSUPDATE.PURCHASEREQUISITIONTYPE == T161.BSART` `C_PURCHASEREQMASSUPDATE.[column in domain "BSTYP"] == T161.BSTYP`
Item category in purchasing document Client Item category in purchasing document	`C_PURCHASEREQMASSUPDATE.MANDT == T163.MANDT` `C_PURCHASEREQMASSUPDATE.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Purchasing Group Client Purchasing Group	`C_PURCHASEREQMASSUPDATE.MANDT == T024.MANDT` `C_PURCHASEREQMASSUPDATE.PURCHASINGGROUP == T024.EKGRP`
Number of purchasing info record Number of purchasing info record Client	`C_PURCHASEREQMASSUPDATE.PURCHASINGINFORECORD == EINA.INFNR` `C_PURCHASEREQMASSUPDATE.MANDT == EINA.MANDT`
Purchasing organization Client Purchasing organization	`C_PURCHASEREQMASSUPDATE.MANDT == T024E.MANDT` `C_PURCHASEREQMASSUPDATE.PURCHASINGORGANIZATION == T024E.EKORG`
Currency Key Client Currency Key	`C_PURCHASEREQMASSUPDATE.MANDT == TCURC.MANDT` `C_PURCHASEREQMASSUPDATE.PURREQNITEMCURRENCY == TCURC.WAERS`
Storage location Client Plant Storage location	`C_PURCHASEREQMASSUPDATE.MANDT == T001L.MANDT` `C_PURCHASEREQMASSUPDATE.PLANT == T001L.WERKS` `C_PURCHASEREQMASSUPDATE.STORAGELOCATION == T001L.LGORT`
Desired Vendor Client Desired Vendor	`C_PURCHASEREQMASSUPDATE.MANDT == LFA1.MANDT` `C_PURCHASEREQMASSUPDATE.SUPPLIER == LFA1.LIFNR`

Other Relations \| to Master Data Relations ↑	Join Conditions
Category of delivery date Client ? Category of delivery date	`C_PURCHASEREQMASSUPDATE.MANDT == TPRG.MANDT` `C_PURCHASEREQMASSUPDATE.[column in domain "SPRAS"] == TPRG.SPRAS` `C_PURCHASEREQMASSUPDATE.DELIVDATECATEGORY == TPRG.PRGBZ`