I_WrkItmPurReqnHdrItemDetailTP

Transaction Processing view for Purchase Requisition Hdr Itm | view: IWIPRHDRITMDETTP | Extraction: Not supported | Component: Purchase Requisitions

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

🔑 Keys (3)
💰 Amounts (4)
∑ Quantities (1)
📅 Dates (5)
☰ Categorical (4)
Other (19)
🔗 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
AccountAssignmentIsAddable	Boolean Variable (X = True, - = False, Space = Unknown)	Show values

Column Name	Description	Domain name
PurchaseRequisitionItemText	Short Text	TEXT40
PurchasingGroupName	Purchasing Group Name	TEXT18
PurReqnPriceQuantity	Price unit	DEC5
ProcurementHubSourceSystem	Connected System ID
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
UserDescription	User Description	SUIDTECHDESC
Supplier	Desired Vendor	LIFNR
FixedSupplier	Fixed Supplier of External System	LIFNR
SourceOfSupply	Number of principal purchase agreement	EBELN
ExtPlantForPurg	Plant of External System	WERKS
ExtPurgOrgForPurg	Purchasing Organization	EKORG
ExtMaterialForPurg	Material of External System	MATNR
ExtCompanyCodeForPurg	Company Code of External System	BUKRS
SupplierName	Name of Supplier	TEXT80
CnsldtnMaterialText	Material Number	MATNR
PurReqnSSPCatalog	Technical Key of a Web Service (for Example - a Catalog)	BBP_WS_SERVICE_ID
RequisitionerName	Name of requisitioner/requester	AFNAM
PurReqnSSPRequestor	Requestor
ProductTypeCode	Product Type Group	CHAR2

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