I_WorkItemPurReqnItemDetail

Interface View for Purchase Reqn Item Workitem Details | view: IWIPURREQNITMDET | Extraction: Not supported | Component: Purchase Requisitions

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, SWWWIHEAD, SWWUSERWI, SWWWIHEAD, SWPSTEPLOG, SWWWIHEAD, FM01, T001W, LFA1, T001K, SWW_WI2OBJ, HRUS_D2, SWWWICOMMENT, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (3)
💰 Amounts (4)
∑ Quantities (1)
📅 Dates (5)
☰ Categorical (3)
Other (20)
🔗 Relations (17)

Column Name	Description
WorkflowTaskInternalID	Work item ID
PurchaseRequisition	Purchase Requisition Number
PurchaseRequisitionItem	Item number of purchase requisition

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

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

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

Column Name	Description
PurReqnReleaseStatus	Requisition Processing State	Show values
MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment	Show values
ConsumptionPosting	Consumption posting	Show values

Column Name	Description	Domain name
PurchaseRequisitionItemText	Short Text	TEXT40
PurReqnPriceQuantity	Price unit	DEC5
PurReqnSSPCatalog	Technical Key of a Web Service (for Example - a Catalog)	BBP_WS_SERVICE_ID
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
Supplier	Desired Vendor	LIFNR
SupplierName	Name of Supplier	TEXT80
ExtPlantForPurg	Plant of External System	WERKS
ExtPurgOrgForPurg	Purchasing Organization	EKORG
ExtCompanyCodeForPurg	Company Code of External System	BUKRS
FixedSupplier	Fixed Supplier of External System	LIFNR
CnsldtnMaterialText	Material Number	MATNR
ExtMaterialForPurg	Material of External System	MATNR
SourceOfSupply	Number of principal purchase agreement	EBELN
ProcurementHubSourceSystem	Connected System ID
LastChangeDateTime	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	TZNTSTMPL
RequisitionerName	Name of requisitioner/requester	AFNAM
ProductTypeCode	Product Type Group	CHAR2
TechnicalWrkflwObjectType	Type of Objects in Persistent Object References	SIBFTYPEID
TechnicalWrkflwObject	Instance Ident. in BOR Compat. Persistent Object References	SIBFBORIID
PurReqnSSPRequestor	Requestor

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