I_WorkItemPurReqnHdrItemDetail

Interface View for Workitem Purchase Reqn Hdr Item Details | view: IWIPRRQHDITMDET | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, SWWWIHEAD, SWWUSERWI, SWWWIHEAD, SWPSTEPLOG, SWWWIHEAD, FM01, T001W, T024, LFA1, T001K, SWW_WI2OBJ, HRUS_D2, SWWWICOMMENT, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
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
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurchasingGroupName Purchasing Group Name TEXT18
Supplier Desired Vendor LIFNR
SupplierName Name of Supplier TEXT80
ExtPlantForPurg Plant of External System WERKS
ExtMaterialForPurg Material of External System MATNR
ExtPurgOrgForPurg Purchasing Organization EKORG
ExtCompanyCodeForPurg Company Code of External System BUKRS
IsDeleted Deletion Indicator in Purchasing Document ELOEK
PurReqnSSPCatalog Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
FixedSupplier Fixed Supplier of External System LIFNR
CnsldtnMaterialText Material Number MATNR
SourceOfSupply Number of principal purchase agreement EBELN
ProcurementHubSourceSystem Connected System ID
PurReqnSSPRequestor Requestor
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
LastChangeDateTime null
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T163K.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T006.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.BASEUNIT == T006.MSEHI
  • I_WORKITEMPURREQNHDRITEMDETAIL.ITEMUOM == T006.MSEHI
Company code
  • Company Code
  • Client
  • I_WORKITEMPURREQNHDRITEMDETAIL.COMPANYCODE == T001.BUKRS
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T001.MANDT
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T006.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.BASEUNIT == T006.MSEHI
  • I_WORKITEMPURREQNHDRITEMDETAIL.ITEMUOM == T006.MSEHI
Material Number
  • Client
  • Material Number
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == MARA.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T023.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T001W.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Client
  • ?
  • I_WORKITEMPURREQNHDRITEMDETAIL.PURCHASEREQUISITIONTYPE == T161.BSART
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T161.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.[column in domain "BSTYP"] == T161.BSTYP
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T163.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T024.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == EINA.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Purchasing organization
  • Client
  • I_WORKITEMPURREQNHDRITEMDETAIL.PURCHASINGORGANIZATION == T024E.EKORG
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T024E.MANDT
Currency Key
  • Client
  • Currency Key
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == TCURC.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.PURREQNITEMCURRENCY == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • I_WORKITEMPURREQNHDRITEMDETAIL.STORAGELOCATION == T001L.LGORT
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T001L.MANDT
  • I_WORKITEMPURREQNHDRITEMDETAIL.PLANT == T001L.WERKS
Workflow: Recipient of Work Item
  • Workflow: Recipient of Work Item
  • Client
  • I_WORKITEMPURREQNHDRITEMDETAIL.WORKFLOWTASKRECIPIENT == USR02.BNAME
  • I_WORKITEMPURREQNHDRITEMDETAIL.MANDT == USR02.MANDT