I_OpnPurReqnForContr

Open Purchase Reqn for Contracts | view: IOPNPRFORCONTR | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, KNA1, FM01, T001W, LFA1, USR21, T001K, MMPUR_C_BE_SYREG, T161A, FINSC_FISC_DATE
Column Name Description
PurchaseContract FK Purchasing Contract Header
PurchaseContractItem Item Number of Purchasing Contract
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
ContractItemCategory FK Item category in purchasing document
PurReqItemCategory FK Item category in purchasing document
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PurchaseContractItemUniqueID Concatenation of EBELN and EBELP PURCHASINGDOCUMENTITEMUNIQUEID
PurchaseReqnItemUniqueID Key to identify purchase requisition item MM_PUR_PR_ITEM_KEY
Master Data Relations Join Conditions
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • Item category in purchasing document
  • I_OPNPURREQNFORCONTR.MANDT == T163.MANDT
  • I_OPNPURREQNFORCONTR.CONTRACTITEMCATEGORY == T163.PSTYP
  • I_OPNPURREQNFORCONTR.PURREQITEMCATEGORY == T163.PSTYP
Material Group
  • Client
  • Material Group
  • I_OPNPURREQNFORCONTR.MANDT == T023.MANDT
  • I_OPNPURREQNFORCONTR.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • I_OPNPURREQNFORCONTR.MANDT == T001W.MANDT
  • I_OPNPURREQNFORCONTR.PLANT == T001W.WERKS
Purchasing Document Type
  • Client
  • Purchase Requisition Document Type
  • Purchasing Document Type
  • ?
  • I_OPNPURREQNFORCONTR.MANDT == T161.MANDT
  • I_OPNPURREQNFORCONTR.PURCHASEREQUISITIONTYPE == T161.BSART
  • I_OPNPURREQNFORCONTR.PURCHASECONTRACTTYPE == T161.BSART
  • I_OPNPURREQNFORCONTR.[column in domain "BSTYP"] == T161.BSTYP
Purchase Requisition Document Type
  • Client
  • Purchase Requisition Document Type
  • Purchasing Document Type
  • ?
  • I_OPNPURREQNFORCONTR.MANDT == T161.MANDT
  • I_OPNPURREQNFORCONTR.PURCHASEREQUISITIONTYPE == T161.BSART
  • I_OPNPURREQNFORCONTR.PURCHASECONTRACTTYPE == T161.BSART
  • I_OPNPURREQNFORCONTR.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • I_OPNPURREQNFORCONTR.MANDT == T024.MANDT
  • I_OPNPURREQNFORCONTR.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • I_OPNPURREQNFORCONTR.MANDT == T024E.MANDT
  • I_OPNPURREQNFORCONTR.PURCHASINGORGANIZATION == T024E.EKORG
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • Item category in purchasing document
  • I_OPNPURREQNFORCONTR.MANDT == T163.MANDT
  • I_OPNPURREQNFORCONTR.CONTRACTITEMCATEGORY == T163.PSTYP
  • I_OPNPURREQNFORCONTR.PURREQITEMCATEGORY == T163.PSTYP
Supplier
  • Client
  • Supplier
  • I_OPNPURREQNFORCONTR.MANDT == LFA1.MANDT
  • I_OPNPURREQNFORCONTR.SUPPLIER == LFA1.LIFNR