I_SitnContrRdyToUseInPurReqn

Trigger view to find open PRs for Contr | view: IOPNPURREQNTGGR | Extraction: Not supported | Component: Purchase Requisitions
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PurchaseContractItem Item Number of Purchasing Contract EBELP
PurchaseRequisition Purchase requisition number BANFN
PurchaseRequisitionItem Item number of purchase requisition BNFPO
PurchaseContractItemUniqueID Concatenation of EBELN and EBELP PURCHASINGDOCUMENTITEMUNIQUEID
PurchaseReqnItemUniqueID Key to identify purchase requisition item MM_PUR_PR_ITEM_KEY
Master Data Relations Join Conditions
Material Group
  • Material Group
  • Client
  • I_SITNCONTRRDYTOUSEINPURREQN.MATERIALGROUP == T023.MATKL
  • I_SITNCONTRRDYTOUSEINPURREQN.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • I_SITNCONTRRDYTOUSEINPURREQN.PLANT == T001W.WERKS
  • I_SITNCONTRRDYTOUSEINPURREQN.MANDT == T001W.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • I_SITNCONTRRDYTOUSEINPURREQN.PURCHASECONTRACTTYPE == T161.BSART
  • I_SITNCONTRRDYTOUSEINPURREQN.[column in domain "BSTYP"] == T161.BSTYP
  • I_SITNCONTRRDYTOUSEINPURREQN.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_SITNCONTRRDYTOUSEINPURREQN.PURCHASINGGROUP == T024.EKGRP
  • I_SITNCONTRRDYTOUSEINPURREQN.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_SITNCONTRRDYTOUSEINPURREQN.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SITNCONTRRDYTOUSEINPURREQN.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • I_SITNCONTRRDYTOUSEINPURREQN.SUPPLIER == LFA1.LIFNR
  • I_SITNCONTRRDYTOUSEINPURREQN.MANDT == LFA1.MANDT