I_PurchaseRequisitionItemBasic

Purchase Requisition Item | view: IPRITEMBASIC | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Tables used: EBAN
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
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity Purchase requisition quantity
MaterialShortageQuantity Shortage (stock undercoverage) quantity
OrderedQuantity Quantity ordered against this purchase requisition
Column Name Description
LastChangedDate Last Changed On
CreationDate Requisition (request) date
PurReqCreationDate Requisition (request) date
DeliveryDate Item delivery date
PurchaseRequisitionReleaseDate Purchase Requisition Release Date
PurchaseOrderDate Purchase Order Date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
ProcessingStatus Processing status of purchase requisition Show values
PurReqnOrigin Creation indicator (purchase requisition/schedule lines) Show values
ConsumptionPosting Consumption posting Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
PartialInvoiceDistribution Partial invoice indicator Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
InvoiceIsExpected Invoice receipt indicator Show values
PurReqnSourceOfSupplyType Purchasing Document Category Show values
SourceOfSupplyIsAssigned Assigned Source of Supply Show values
IsClosed Purchase requisition closed Show values
PurchaseRequisitionIsFixed Purchase requisition is fixed Show values
PurchaseOrderPriceType Use Requisition Price in Purchase Order Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
IsPurReqnOvrlRel Overall release of purchase requisitions Show values
IsPurReqnCmplt Purchase Requisition not yet Complete Show values
PurReqnReleaseStatus Requisition Processing State Show values
IsPurReqnBlocked Purchase Requisition Blocked Show values
PurReqnCmpltnsCat Category of Incompleteness Show values
PurReqnIsCreatedInExpertMode PR Created in Expert Mode Show values
PurReqnIsValdInCntrlReqnProcg Is PR relevant for Central PR Processing Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
ProcmtHubPurReqnItmIsChanged Change Indicator for PR in Central Procurement Show values
ExternalApprovalStatus External Processing Status Show values
ExtApprvlIntmdSts External Processing Status Show values
IsOnBehalfCart Shop on behalf indicator Show values
PurchasingDeliveryAddressType Purchasing Delivery Address Type Show values
IsOutline Is Outline Show values
PurReqnItemOutlineType Outline Type Show values
PurReqnHasDelegateApproval Purchase Requisition in external approval Show values
Column Name Description Domain name
IsDeleted Deletion Indicator in Purchasing Document ELOEK
PurchaseRequisitionStatus Release State FRGZU
ReleaseStrategy Release strategy in the purchase requisition FRGST
CreatedByUser Name of Person Responsible for Creating the Object USNAM
RequisitionerName Name of requisitioner/requester AFNAM
PurchaseRequisitionItemText Short Text TEXT40
RequirementTracking Requirement Tracking Number CHAR10
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
MaterialGoodsReceiptDuration Goods receipt processing time in days DEC3
PurReqnPriceQuantity Price unit DEC5
Reservation Number of reservation/dependent requirements RSNUM
MaterialRevisionLevel Revision Level VDM_QM_REVLV
Batch Batch Number CHARG
CommitmentItemShortID Commitment Item Short ID FMIS_CI_INTERNALNAME
FundsCenter Funds Center FISTL
Fund Fund BP_GEBER
SupplierMaterialNumber Material Number Used by Supplier IDNEX
ManufacturerPartProfile Mfr part profile MPROF
ManufacturerPartNmbr Manufacturer Part Number CHAR40
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
MRPArea MRP Area BERID
TaxCode Tax on sales/purchases code MWSKZ
FunctionalArea Functional Area FKBER
GrantID Grant GM_GRANT_NBR
PurReqnItemBlockingReasonText Reason for Item Block CHAR60K
ExternalProcurementProfile External Procurement Profile EPROFILE
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
EarmarkedFundsDocumentItem Earmarked Funds: Document Item KBLPOS
MinRemainingShelfLife Minimum Remaining Shelf Life DEC4
BudgetPeriod Budget Period FM_BUDGET_PERIOD
ProductTypeCode Product Type Group CHAR2
ServicePerformer Service Performer BU_PARTNER
ExtMaterialForPurg Material of External System MATNR
ExtFixedSupplierForPurg Fixed Supplier of External System LIFNR
ExtDesiredSupplierForPurg Desired Supplier of External System LIFNR
ExtContractForPurg Contract of External System EBELN
ExtContractItemForPurg Contract Item of External System EBELP
ExtInfoRecordForPurg Info Record of External System INFNR
ExtPlantForPurg Plant of External System WERKS
ExtCompanyCodeForPurg Company Code of External System BUKRS
ExtPurgOrgForPurg Purchasing Organization EKORG
ExtSourceSystem Logical System LOGSYS
ProcurementHubSourceSystem Connected System ID
ExtPurchaseRequisitionType PR Document Type of Connected System BSART
PurchaseReqnItemUniqueID Key to identify purchase requisition item MM_PUR_PR_ITEM_KEY
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
GLAccount G/L Account Number SAKNR
CostCenter Cost Center KOSTL
PurReqnSSPCrossCatalogItem Catalog Item Key
PurReqnSSPCatalog Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
PurReqnSSPCatalogItem Catalog Item Id
PurReqnSSPRequestor Requestor
PurReqnSSPAuthor Author of Requisition UNAME
StockSegment Stock Segment SGT_SRCA
RequirementSegment Requirement Segment SGT_SRCA
PurchasingParentItem Parent Item No BNFPO
PurgConfigurableItemNumber Hierarchy Number EXLIN
PurgExternalSortNumber External Sort Number EXSNR
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T163K.MANDT
Link to Central Address Management
  • Manual address number in purchasing document item
  • Manual address number in purchasing document item
  • Client
  • ?
  • ?
  • I_PURCHASEREQUISITIONITEMBASIC.ADDRESSID == ADRC.ADDRNUMBER
  • I_PURCHASEREQUISITIONITEMBASIC.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == ADRC.CLIENT
  • I_PURCHASEREQUISITIONITEMBASIC.[column in domain "AD_NATION"] == ADRC.NATION
  • I_PURCHASEREQUISITIONITEMBASIC.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T006.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.BASEUNIT == T006.MSEHI
Fixed Vendor
  • Client
  • Fixed Vendor
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == LFA1.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.FIXEDSUPPLIER == LFA1.LIFNR
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T148.MANDT
Number of delivery address
  • Client
  • ?
  • ?
  • Number of delivery address
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == ADRC.CLIENT
  • I_PURCHASEREQUISITIONITEMBASIC.[column in domain "AD_NATION"] == ADRC.NATION
  • I_PURCHASEREQUISITIONITEMBASIC.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_PURCHASEREQUISITIONITEMBASIC.ITEMDELIVERYADDRESSID == ADRC.ADDRNUMBER
Language Key I_PURCHASEREQUISITIONITEMBASIC.LANGUAGE == T002.SPRAS
Link to Central Address Management
  • Manual address number in purchasing document item
  • Manual address number in purchasing document item
  • Client
  • ?
  • ?
  • I_PURCHASEREQUISITIONITEMBASIC.ADDRESSID == ADRC.ADDRNUMBER
  • I_PURCHASEREQUISITIONITEMBASIC.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == ADRC.CLIENT
  • I_PURCHASEREQUISITIONITEMBASIC.[column in domain "AD_NATION"] == ADRC.NATION
  • I_PURCHASEREQUISITIONITEMBASIC.[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_PURCHASEREQUISITIONITEMBASIC.MANUFACTURERMATERIAL == MARA.MATNR
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == MARA.MANDT
Material Number
  • Client
  • Material Number
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == MARA.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T023.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.MATERIALGROUP == T023.MATKL
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.MATERIALORDERUNIT == T006.MSEHI
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T006.MANDT
MRP Controller
  • MRP Controller
  • Client
  • Plant
  • I_PURCHASEREQUISITIONITEMBASIC.MRPCONTROLLER == T024D.DISPO
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T024D.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.PLANT == T024D.WERKS
Plant
  • Client
  • Plant
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T001W.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.PLANT == T001W.WERKS
Procuring Plant
  • Client
  • Procuring Plant
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T001W.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.PROCURINGPLANT == T001W.WERKS
Fashion Collection
  • Season
  • Season Year
  • Client
  • Fashion Collection
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == FSH_COLLECTIONS.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION
Season
  • Season
  • Season Year
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Season
  • Season Year
  • Client
  • Fashion Collection
  • Fashion Theme
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == FSH_THEMES.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_PURCHASEREQUISITIONITEMBASIC.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Purchase Requisition Document Type
  • Purchase Requisition Document Type
  • Purchasing Document Category
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.PURCHASEREQUISITIONTYPE == T161.BSART
  • I_PURCHASEREQUISITIONITEMBASIC.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T161.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T163.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T024.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == EINA.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Purchasing organization
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.PURCHASINGORGANIZATION == T024E.EKORG
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T024E.MANDT
Currency Key
  • Currency Key
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.PURREQNITEMCURRENCY == TCURC.WAERS
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == TCURC.MANDT
Customer
  • Client
  • Customer
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == KNA1.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.PURREQNRECEIVINGCUSTOMER == KNA1.KUNNR
Release Indicator
  • Client
  • Release Indicator
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T161S.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.RELEASECODE == T161S.FRGKZ
Release group
  • Release group
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.RELEASEGROUP == T16FG.FRGGR
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T16FG.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • I_PURCHASEREQUISITIONITEMBASIC.STORAGELOCATION == T001L.LGORT
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == T001L.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.PLANT == T001L.WERKS
Supplier to be Supplied/Who is to Receive Delivery
  • Supplier to be Supplied/Who is to Receive Delivery
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.SUBCONTRACTOR == LFA1.LIFNR
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == LFA1.MANDT
Desired Vendor
  • Client
  • Desired Vendor
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == LFA1.MANDT
  • I_PURCHASEREQUISITIONITEMBASIC.SUPPLIER == LFA1.LIFNR
Other Relations | to Master Data Relations ↑ Join Conditions
Category of delivery date
  • Category of delivery date
  • ?
  • Client
  • I_PURCHASEREQUISITIONITEMBASIC.DELIVDATECATEGORY == TPRG.PRGBZ
  • I_PURCHASEREQUISITIONITEMBASIC.[column in domain "SPRAS"] == TPRG.SPRAS
  • I_PURCHASEREQUISITIONITEMBASIC.MANDT == TPRG.MANDT