I_PurOrdsOpenForConf

Union on all PO open for cnf | view: IPOOPNCNFUNION | Extraction: Not supported | Component: Purchase Requisitions
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
ProcuringPlant FK Plant
Column Name Description
Column Name Description
OpenQuantity null
Column Name Description
Column Name Description
IsExtPurgScenario Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
PurchaseRequisitionItem Item number of purchase requisition BNFPO
ReferenceDocumentPlant Plant WERKS
Material Material Number MATNR
PurchaseReqnItemUniqueID Key to identify purchase requisition item MM_PUR_PR_ITEM_KEY
Master Data Relations Join Conditions
Plant
  • Plant
  • Plant
  • Client
  • I_PURORDSOPENFORCONF.PLANT == T001W.WERKS
  • I_PURORDSOPENFORCONF.PROCURINGPLANT == T001W.WERKS
  • I_PURORDSOPENFORCONF.MANDT == T001W.MANDT
Plant
  • Plant
  • Plant
  • Client
  • I_PURORDSOPENFORCONF.PLANT == T001W.WERKS
  • I_PURORDSOPENFORCONF.PROCURINGPLANT == T001W.WERKS
  • I_PURORDSOPENFORCONF.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_PURORDSOPENFORCONF.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • I_PURORDSOPENFORCONF.MANDT == T006.MANDT
Supplier
  • Client
  • Supplier
  • I_PURORDSOPENFORCONF.MANDT == LFA1.MANDT
  • I_PURORDSOPENFORCONF.SUPPLIER == LFA1.LIFNR