P_WrkflwPurRequisitionItem

P_WRKFLWPURREQUISITIONITEM | view: PWPURREQITEM | Extraction: Not supported | Component: Reporting
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, SWWWIHEAD, SWWWIHEAD, SWPSTEPLOG, SWWWIHEAD, FM01, T001W, T161, T001K, SWW_WI2OBJ, SWWWICOMMENT, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
PurchaseRequisitionPrice Price in Purchase Requisition
Column Name Description
RequestedQuantity Purchase requisition quantity
Column Name Description
PurReqCreationDate Requisition (request) date
Column Name Description
PurReqFlxblWrkflwApprvlLevel Workflow Type Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurReqnPriceQuantity Price unit DEC5
ProcurementHubSourceSystem Connected System ID
WrkflwTskCreationUTCDateTime null
WrkflwTskCompletionUTCDateTime null
ApprovalTime null
TargetApprovalTime null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_WRKFLWPURREQUISITIONITEM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_WRKFLWPURREQUISITIONITEM.MANDT == T163K.MANDT
Company code
  • Company Code
  • Client
  • P_WRKFLWPURREQUISITIONITEM.COMPANYCODE == T001.BUKRS
  • P_WRKFLWPURREQUISITIONITEM.MANDT == T001.MANDT
Material Number
  • Client
  • Material Number
  • P_WRKFLWPURREQUISITIONITEM.MANDT == MARA.MANDT
  • P_WRKFLWPURREQUISITIONITEM.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • P_WRKFLWPURREQUISITIONITEM.MATERIALGROUP == T023.MATKL
  • P_WRKFLWPURREQUISITIONITEM.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • P_WRKFLWPURREQUISITIONITEM.PLANT == T001W.WERKS
  • P_WRKFLWPURREQUISITIONITEM.MANDT == T001W.MANDT
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • ?
  • Client
  • P_WRKFLWPURREQUISITIONITEM.PURCHASEREQUISITIONTYPE == T161.BSART
  • P_WRKFLWPURREQUISITIONITEM.[column in domain "BSTYP"] == T161.BSTYP
  • P_WRKFLWPURREQUISITIONITEM.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_WRKFLWPURREQUISITIONITEM.PURCHASINGGROUP == T024.EKGRP
  • P_WRKFLWPURREQUISITIONITEM.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_WRKFLWPURREQUISITIONITEM.PURCHASINGORGANIZATION == T024E.EKORG
  • P_WRKFLWPURREQUISITIONITEM.MANDT == T024E.MANDT
Currency Key
  • Client
  • Currency Key
  • P_WRKFLWPURREQUISITIONITEM.MANDT == TCURC.MANDT
  • P_WRKFLWPURREQUISITIONITEM.PURREQNITEMCURRENCY == TCURC.WAERS
Desired Vendor
  • Desired Vendor
  • Client
  • P_WRKFLWPURREQUISITIONITEM.SUPPLIER == LFA1.LIFNR
  • P_WRKFLWPURREQUISITIONITEM.MANDT == LFA1.MANDT