I_WorkItemPurReqnItemDetailTP

Transaction Processing view for Purchase Requisition Item | view: IWIPRITMDETTP | 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 (2)
💰 Amounts (4)
∑ Quantities (1)
📅 Dates (5)
☰ Categorical (3)
Other (21)
🔗 Relations (17)

Column Name	Description
PurchaseRequisition	Purchase Requisition Number
WorkflowTaskInternalID	Work item ID

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
PurchaseRequisitionItem	Item number of purchase requisition	BNFPO
PurchaseRequisitionItemText	Short Text	TEXT40
Supplier	Desired Vendor	LIFNR
FixedSupplier	Fixed Supplier of External System	LIFNR
SupplierName	Name of Supplier	TEXT80
PurReqnPriceQuantity	Price unit	DEC5
ProcurementHubSourceSystem	Connected System ID
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
ExtPlantForPurg	Plant of External System	WERKS
ExtPurgOrgForPurg	Purchasing Organization	EKORG
ExtMaterialForPurg	Material of External System	MATNR
ExtCompanyCodeForPurg	Company Code of External System	BUKRS
SourceOfSupply	Number of principal purchase agreement	EBELN
ProductTypeCode	Product Type Group	CHAR2
CnsldtnMaterialText	Material Number	MATNR
PurReqnWrkflwRestartIsSkipped	null
DraftCreatedByUser	Name of Person Responsible for Creating the Object	USNAM
PurReqnSSPCatalog	Technical Key of a Web Service (for Example - a Catalog)	BBP_WS_SERVICE_ID
LastChangeDateTime	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	TZNTSTMPL
RequisitionerName	Name of requisitioner/requester	AFNAM
PurReqnSSPRequestor	Requestor

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