I_PurchasingInfoRecord

Purchasing Info Record | view: IPURINFREC | Extraction: Not supported | Component: Quota Arrangement
Tables used: EINA
Column Name Description
PurchasingInfoRecord Number of purchasing info record
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
ProductPurchasePointsQty Number of Points
Column Name Description
CreationDate Date on which the record was created
AvailabilityStartDate Available (Deliverable) From
AvailabilityEndDate Available (Deliverable) Until
SupplierCertValidityEndDate Certificate of Origin Valid Until
Column Name Description
IsDeleted Purchasing info: General data flagged for deletion Show values
VarblPurOrdUnitIsActive Variable Purchase Order Unit Active Show values
IsRegularSupplier Regular Supplier Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
PurchasingInfoRecordDesc Short Text for Purchasing Info Record TEXT40
OrderItemQtyToBaseQtyNmrtr Numerator for Conversion of Order Unit to Base Unit UMBSZ
OrderItemQtyToBaseQtyDnmntr Denominator for Conversion of Order Unit to Base Unit UMBSN
SupplierMaterialNumber Material Number Used by Supplier IDNEX
SupplierRespSalesPersonName Salesperson Responsible in the Event of Queries TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
SupplierMaterialGroup Supplier Material Group CHAR18
Manufacturer Manufacturer LIFNR
NoDaysReminder1 Number of Days for First Reminder/Expediter MAHNT
NoDaysReminder2 Number of Days for Second Reminder/Expediter MAHNT
NoDaysReminder3 Number of Days for Third Reminder/Expediter MAHNT
SupplierCertOriginNumber Certificate Number URZNR
SuplrCertOriginClassfctnNumber Number URZZT
SupplierSubrangeSortNumber Sort Sequence Number NUMC5
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_PURCHASINGINFORECORD.BASEUNIT == T006.MSEHI
  • I_PURCHASINGINFORECORD.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
  • I_PURCHASINGINFORECORD.MATERIAL == MARA.MATNR
  • I_PURCHASINGINFORECORD.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_PURCHASINGINFORECORD.MATERIALGROUP == T023.MATKL
  • I_PURCHASINGINFORECORD.MANDT == T023.MANDT
Prior Supplier
  • Prior Supplier
  • Client
  • I_PURCHASINGINFORECORD.PRIORSUPPLIER == LFA1.LIFNR
  • I_PURCHASINGINFORECORD.MANDT == LFA1.MANDT
Points Unit
  • Client
  • Points Unit
  • I_PURCHASINGINFORECORD.MANDT == T006.MANDT
  • I_PURCHASINGINFORECORD.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_PURCHASINGINFORECORD.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
  • I_PURCHASINGINFORECORD.MANDT == T006.MANDT
Return Agreement
  • Return Agreement
  • Client
  • I_PURCHASINGINFORECORD.RETURNAGREEMENT == TWRV.RUECV
  • I_PURCHASINGINFORECORD.MANDT == TWRV.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_PURCHASINGINFORECORD.SUPPLIER == LFA1.LIFNR
  • I_PURCHASINGINFORECORD.MANDT == LFA1.MANDT
Certificate Category
  • Certificate Category
  • Client
  • I_PURCHASINGINFORECORD.SUPPLIERCERTORIGINCAT == T069.URZTP
  • I_PURCHASINGINFORECORD.MANDT == T069.MANDT
Country/Region of Issue of Certificate of Origin
  • Country/Region of Issue of Certificate of Origin
  • Client
  • I_PURCHASINGINFORECORD.SUPPLIERCERTORIGINCOUNTRY == T005.LAND1
  • I_PURCHASINGINFORECORD.MANDT == T005.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Country/Region of Issue of Certificate of Origin
  • Client
  • I_PURCHASINGINFORECORD.SUPPLIERCERTORIGINREGION == T005S.BLAND
  • I_PURCHASINGINFORECORD.SUPPLIERCERTORIGINCOUNTRY == T005S.LAND1
  • I_PURCHASINGINFORECORD.MANDT == T005S.MANDT
Supplier Subrange
  • Vendor's account number
  • Supplier Subrange
  • Client
  • I_PURCHASINGINFORECORD.SUPPLIER == WYT1.LIFNR
  • I_PURCHASINGINFORECORD.SUPPLIERSUBRANGE == WYT1.LTSNR
  • I_PURCHASINGINFORECORD.MANDT == WYT1.MANDT