C_WorkItemPurReqnItemDetail

Consumption view for Workitem Purchase Requisition Item | view: CWIPRITMDET | TRAN | Extraction: Not supported | Component: Purchase Requisitions

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, SWWWIHEAD, SWWUSERWI, SWWWIHEAD, SWPSTEPLOG, SWWWIHEAD, CMD_PRDTYPE, CMD_PRDTYPE_T, FM01, T001W, WSI_DESCRIPTION, WSI_ENTITY, T163Y, T001L, LFA1, T001K, SWW_WI2OBJ, HRUS_D2, SWWWICOMMENT, MMPUR_C_BE_SYREG, MMPUROCI_DETAILS, MMPUR_CAT_ATTRB, FINSC_FISC_DATE

🔑 Keys (2)
💰 Amounts (4)
∑ Quantities (1)
📅 Dates (5)
☰ Categorical (2)
Other (24)
🔗 Relations (14)

Column Name	Description
PurchaseRequisition	Purchase Requisition Number
WorkflowTaskInternalID	Work item ID

Column Name	Description
💲 Currency Key (Currency):
ItemNetAmount	null
💲 Currency Key (PurReqnItemCurrency):
ExpectedOverallLimitAmount	Expected Value of Overall Limit
OverallLimitAmount	Overall Limit
PurchaseRequisitionPrice	Price in Purchase Requisition

Column Name	Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity	Purchase requisition quantity

Column Name	Description
PurReqCreationDate	Requisition (request) date
PerformancePeriodStartDate	Start Date for Period of Performance
PerformancePeriodEndDate	End Date for Period of Performance
PurchaseRequisitionReleaseDate	Purchase Requisition Release Date
DeliveryDate	Item delivery date

Column Name	Description
PurReqnReleaseStatus	Requisition Processing State	Show values
ConsumptionPosting	Consumption posting	Show values

Column Name	Description	Domain name
PurchaseRequisitionItem	Item number of purchase requisition
PurchaseRequisitionItemText	Short Text
CnsldtnMaterialText	Material Number	MATNR
SourceOfSupply	Number of principal purchase agreement
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
PurReqnPriceQuantity	Price unit
Supplier	Desired Vendor	LIFNR
FixedSupplier	Fixed Supplier of External System
SupplierName	Name of Supplier	TEXT80
FixedSupplierName	Name of Supplier	TEXT80
MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment
ProcurementHubSourceSystem	Connected System ID
PurgDocItemCategoryName	Text for Item Category	TEXT20
ProductTypeCode	Product Type Group	CHAR2
ProductTypeName	Product Type Group Description	TEXT40
StorageLocationName	Storage Location Name	TEXT16
ExtPlantForPurg	Plant of External System	WERKS
ExtPurgOrgForPurg	Purchasing Organization	EKORG
ExtMaterialForPurg	Material of External System	MATNR
ExtCompanyCodeForPurg	Company Code of External System	BUKRS
PurReqnSSPCatalog	Technical Key of a Web Service (for Example - a Catalog)	BBP_WS_SERVICE_ID
OpnCtlgWebServiceName	Description for a Web Service	CHAR60K
RequisitionerName	Name of requisitioner/requester	AFNAM
PurReqnSSPRequestor	Requestor

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`C_WORKITEMPURREQNITEMDETAIL.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `C_WORKITEMPURREQNITEMDETAIL.MANDT == T163K.MANDT`
Purchase requisition unit of measure Client Purchase requisition unit of measure Purchase requisition unit of measure	`C_WORKITEMPURREQNITEMDETAIL.MANDT == T006.MANDT` `C_WORKITEMPURREQNITEMDETAIL.ITEMUOM == T006.MSEHI` `C_WORKITEMPURREQNITEMDETAIL.BASEUNIT == T006.MSEHI`
Currency Key Client Currency Key Currency Key	`C_WORKITEMPURREQNITEMDETAIL.MANDT == TCURC.MANDT` `C_WORKITEMPURREQNITEMDETAIL.CURRENCY == TCURC.WAERS` `C_WORKITEMPURREQNITEMDETAIL.PURREQNITEMCURRENCY == TCURC.WAERS`
Purchase requisition unit of measure Client Purchase requisition unit of measure Purchase requisition unit of measure	`C_WORKITEMPURREQNITEMDETAIL.MANDT == T006.MANDT` `C_WORKITEMPURREQNITEMDETAIL.ITEMUOM == T006.MSEHI` `C_WORKITEMPURREQNITEMDETAIL.BASEUNIT == T006.MSEHI`
Material Number Client Material Number	`C_WORKITEMPURREQNITEMDETAIL.MANDT == MARA.MANDT` `C_WORKITEMPURREQNITEMDETAIL.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_WORKITEMPURREQNITEMDETAIL.MANDT == T023.MANDT` `C_WORKITEMPURREQNITEMDETAIL.MATERIALGROUP == T023.MATKL`
Plant Client Plant	`C_WORKITEMPURREQNITEMDETAIL.MANDT == T001W.MANDT` `C_WORKITEMPURREQNITEMDETAIL.PLANT == T001W.WERKS`
Purchase Requisition Document Type Purchase Requisition Document Type ? Client	`C_WORKITEMPURREQNITEMDETAIL.PURCHASEREQUISITIONTYPE == T161.BSART` `C_WORKITEMPURREQNITEMDETAIL.[column in domain "BSTYP"] == T161.BSTYP` `C_WORKITEMPURREQNITEMDETAIL.MANDT == T161.MANDT`
Item category in purchasing document Client Item category in purchasing document	`C_WORKITEMPURREQNITEMDETAIL.MANDT == T163.MANDT` `C_WORKITEMPURREQNITEMDETAIL.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Purchasing Group Purchasing Group Client	`C_WORKITEMPURREQNITEMDETAIL.PURCHASINGGROUP == T024.EKGRP` `C_WORKITEMPURREQNITEMDETAIL.MANDT == T024.MANDT`
Purchasing organization Client Purchasing organization	`C_WORKITEMPURREQNITEMDETAIL.MANDT == T024E.MANDT` `C_WORKITEMPURREQNITEMDETAIL.PURCHASINGORGANIZATION == T024E.EKORG`
Currency Key Client Currency Key Currency Key	`C_WORKITEMPURREQNITEMDETAIL.MANDT == TCURC.MANDT` `C_WORKITEMPURREQNITEMDETAIL.CURRENCY == TCURC.WAERS` `C_WORKITEMPURREQNITEMDETAIL.PURREQNITEMCURRENCY == TCURC.WAERS`
Storage location Client Plant Storage location	`C_WORKITEMPURREQNITEMDETAIL.MANDT == T001L.MANDT` `C_WORKITEMPURREQNITEMDETAIL.PLANT == T001L.WERKS` `C_WORKITEMPURREQNITEMDETAIL.STORAGELOCATION == T001L.LGORT`
Workflow: Recipient of Work Item Client Workflow: Recipient of Work Item	`C_WORKITEMPURREQNITEMDETAIL.MANDT == USR02.MANDT` `C_WORKITEMPURREQNITEMDETAIL.WORKFLOWTASKRECIPIENT == USR02.BNAME`