I_PurchaseReqnItem

Purchase Requisition Items | view: IPURREQNITM | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, KNA1, FM01, T001W, LFA1, USR21, T001K, MMPUR_C_BE_SYREG, TWLAD, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
💲 Currency Key (PurReqnItemCurrency):
PurchaseRequisitionPrice Price in Purchase Requisition
PurReqnLimitConsumptionAmt Consumption Value for Limit Items
ExpectedOverallLimitAmount Expected Value of Overall Limit
OverallLimitAmount Overall Limit
ItemNetAmount null
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
OrderedQuantity Quantity ordered against this purchase requisition
Column Name Description
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
DeliveryDate Item delivery date
CreationDate Requisition (request) date
PurReqCreationDate Requisition (request) date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
IsOutline Is Outline Show values
PurReqnItemOutlineType Outline Type Show values
SourceOfSupplyIsAssigned Assigned Source of Supply Show values
AddressType Purchase Requisition Address Type Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
PartialInvoiceDistribution Partial invoice indicator Show values
PurReqnSourceOfSupplyType Purchasing Document Category Show values
ConsumptionPosting Consumption posting Show values
IsPurReqnBlocked Purchase Requisition Blocked Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
IsPurReqnCmplt Purchase Requisition not yet Complete Show values
PurReqnCmpltnsCat Category of Incompleteness Show values
PurchaseOrderPriceType Use Requisition Price in Purchase Order Show values
IsPurReqnOvrlRel Overall release of purchase requisitions Show values
ExternalApprovalStatus External Processing Status Show values
Column Name Description Domain name
PurReqnReleaseStatus Requisition Processing State
PurchaseRequisitionItemText Short Text
ManufacturerPartProfile Mfr part profile MPROF
ManufacturerPartNmbr Manufacturer Part Number CHAR40
PurchasingParentItem Parent Item No BNFPO
PurgConfigurableItemNumber Hierarchy Number EXLIN
PurgExternalSortNumber External Sort Number EXSNR
PurReqnPriceQuantity Price unit
MaterialGoodsReceiptDuration Goods receipt processing time in days
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
ProcessingStatus Processing status of purchase requisition
IsDeleted Deletion Indicator in Purchasing Document ELOEK
RequisitionerName Name of requisitioner/requester AFNAM
PurReqnSSPRequestor Requestor
CreatedByUser Name of Person Responsible for Creating the Object USNAM
UserDescription User Description
DeliveryAddressID Address ADRNR
MaterialPlannedDeliveryDurn Planned Delivery Time in Days
PurReqnOrigin Creation indicator (purchase requisition/schedule lines)
IsClosed Purchase requisition closed
ServicePerformer Service Performer BU_PARTNER
ProductType Product Type Group CHAR2
PurchaseRequisitionStatus Release State FRGZU
ReleaseStrategy Release strategy in the purchase requisition FRGST
SupplierMaterialNumber Material Number Used by Supplier
Batch Batch Number CHARG
MaterialRevisionLevel Revision Level
MinRemainingShelfLife Minimum Remaining Shelf Life
GoodsReceiptIsExpected Goods Receipt Indicator
InvoiceIsExpected Invoice receipt indicator
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated
RequirementTracking Requirement Tracking Number
TaxCode Tax on sales/purchases code
PurchaseRequisitionIsFixed Purchase requisition is fixed
PurReqnCatalog Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
PurReqnCatalogItem Catalog Item Id
PurReqnCrossCatalogItem Catalog Item Key
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
PurchaseReqnItemUniqueID Key to identify purchase requisition item
CommitmentItem Commitment Item FIPOS
FundsCenter Funds Center FISTL
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
EarmarkedFundsDocumentItem Earmarked Funds: Document Item KBLPOS
BudgetPeriod Budget Period FM_BUDGET_PERIOD
CostCenter Cost Center KOSTL
GLAccount G/L Account Number SAKNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
FundedProgram null
PurchaseReqnStatusPriority null
IsAdvncdPurchaseReqnItemType 1 Byte Unsigned Integer INT1
IsAdvncdPurchaseReqnOrigin 1 Byte Unsigned Integer INT1
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • I_PURCHASEREQNITEM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • I_PURCHASEREQNITEM.MANDT == T163K.MANDT
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • I_PURCHASEREQNITEM.MANDT == T006.MANDT
  • I_PURCHASEREQNITEM.BASEUNIT == T006.MSEHI
Company code
  • Company Code
  • Client
  • I_PURCHASEREQNITEM.COMPANYCODE == T001.BUKRS
  • I_PURCHASEREQNITEM.MANDT == T001.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • I_PURCHASEREQNITEM.FIXEDSUPPLIER == LFA1.LIFNR
  • I_PURCHASEREQNITEM.MANDT == LFA1.MANDT
Number of delivery address
  • Client
  • ?
  • ?
  • Number of delivery address
  • I_PURCHASEREQNITEM.MANDT == ADRC.CLIENT
  • I_PURCHASEREQNITEM.[column in domain "AD_NATION"] == ADRC.NATION
  • I_PURCHASEREQNITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_PURCHASEREQNITEM.ITEMDELIVERYADDRESSID == ADRC.ADDRNUMBER
Language Key I_PURCHASEREQNITEM.LANGUAGE == T002.SPRAS
Link to Central Address Management
  • Manual address number in purchasing document item
  • Client
  • ?
  • ?
  • I_PURCHASEREQNITEM.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • I_PURCHASEREQNITEM.MANDT == ADRC.CLIENT
  • I_PURCHASEREQNITEM.[column in domain "AD_NATION"] == ADRC.NATION
  • I_PURCHASEREQNITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Material number corresponding to manufacturer part number
  • Material number corresponding to manufacturer part number
  • Client
  • I_PURCHASEREQNITEM.MANUFACTURERMATERIAL == MARA.MATNR
  • I_PURCHASEREQNITEM.MANDT == MARA.MANDT
Material Number
  • Client
  • Material Number
  • I_PURCHASEREQNITEM.MANDT == MARA.MANDT
  • I_PURCHASEREQNITEM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_PURCHASEREQNITEM.MANDT == T023.MANDT
  • I_PURCHASEREQNITEM.MATERIALGROUP == T023.MATKL
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_PURCHASEREQNITEM.MANDT == T006.MANDT
  • I_PURCHASEREQNITEM.MATERIALORDERUNIT == T006.MSEHI
MRP Controller
  • MRP Controller
  • Client
  • Plant
  • I_PURCHASEREQNITEM.MRPCONTROLLER == T024D.DISPO
  • I_PURCHASEREQNITEM.MANDT == T024D.MANDT
  • I_PURCHASEREQNITEM.PLANT == T024D.WERKS
Plant
  • Client
  • Plant
  • I_PURCHASEREQNITEM.MANDT == T001W.MANDT
  • I_PURCHASEREQNITEM.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Purchasing Document Category
  • Client
  • I_PURCHASEREQNITEM.PURCHASEREQUISITIONTYPE == T161.BSART
  • I_PURCHASEREQNITEM.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_PURCHASEREQNITEM.MANDT == T161.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • I_PURCHASEREQNITEM.MANDT == T163.MANDT
  • I_PURCHASEREQNITEM.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • I_PURCHASEREQNITEM.PURCHASINGGROUP == T024.EKGRP
  • I_PURCHASEREQNITEM.MANDT == T024.MANDT
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • I_PURCHASEREQNITEM.MANDT == EINA.MANDT
  • I_PURCHASEREQNITEM.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Client
  • Purchasing organization
  • I_PURCHASEREQNITEM.MANDT == T024E.MANDT
  • I_PURCHASEREQNITEM.PURCHASINGORGANIZATION == T024E.EKORG
Currency Key
  • Client
  • Currency Key
  • I_PURCHASEREQNITEM.MANDT == TCURC.MANDT
  • I_PURCHASEREQNITEM.PURREQNITEMCURRENCY == TCURC.WAERS
Customer
  • Customer
  • Client
  • I_PURCHASEREQNITEM.PURREQNRECEIVINGCUSTOMER == KNA1.KUNNR
  • I_PURCHASEREQNITEM.MANDT == KNA1.MANDT
Supplier to be Supplied/Who is to Receive Delivery
  • Supplier to be Supplied/Who is to Receive Delivery
  • Client
  • I_PURCHASEREQNITEM.PURREQNRECEIVINGSUPPLIER == LFA1.LIFNR
  • I_PURCHASEREQNITEM.MANDT == LFA1.MANDT
Release Indicator
  • Release Indicator
  • Client
  • I_PURCHASEREQNITEM.RELEASECODE == T161S.FRGKZ
  • I_PURCHASEREQNITEM.MANDT == T161S.MANDT
Storage location
  • Client
  • Storage location
  • Plant
  • I_PURCHASEREQNITEM.MANDT == T001L.MANDT
  • I_PURCHASEREQNITEM.STORAGELOCATION == T001L.LGORT
  • I_PURCHASEREQNITEM.PLANT == T001L.WERKS
Desired Vendor
  • Client
  • Desired Vendor
  • I_PURCHASEREQNITEM.MANDT == LFA1.MANDT
  • I_PURCHASEREQNITEM.SUPPLIER == LFA1.LIFNR
Other Relations | to Master Data Relations ↑ Join Conditions
Category of delivery date
  • Category of delivery date
  • ?
  • Client
  • I_PURCHASEREQNITEM.DELIVDATECATEGORY == TPRG.PRGBZ
  • I_PURCHASEREQNITEM.[column in domain "SPRAS"] == TPRG.SPRAS
  • I_PURCHASEREQNITEM.MANDT == TPRG.MANDT