A_PurchasingInfoRecord

Purchasing Info Record | view: APURINFREC | TRAN | Extraction: Not supported | Component: Vendor-Material Relationships and Conditions
Tables used: EINA
Column Name Description
PurchasingInfoRecord Number of purchasing info record
Column Name Description
Column Name Description
📏 Points Unit (ProductPurchasePointsQtyUnit):
ProductPurchasePointsQty Number of Points
Column Name Description
CreationDate Date on which the record was created
AvailabilityStartDate Available (Deliverable) From
AvailabilityEndDate Available (Deliverable) 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
SupplierSubrangeSortNumber Sort Sequence Number NUMC5
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • A_PURCHASINGINFORECORD.MANDT == T006.MANDT
  • A_PURCHASINGINFORECORD.BASEUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • A_PURCHASINGINFORECORD.MANDT == MARA.MANDT
  • A_PURCHASINGINFORECORD.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • A_PURCHASINGINFORECORD.MANDT == T023.MANDT
  • A_PURCHASINGINFORECORD.MATERIALGROUP == T023.MATKL
Prior Supplier
  • Client
  • Prior Supplier
  • A_PURCHASINGINFORECORD.MANDT == LFA1.MANDT
  • A_PURCHASINGINFORECORD.PRIORSUPPLIER == LFA1.LIFNR
Points Unit
  • Client
  • Points Unit
  • A_PURCHASINGINFORECORD.MANDT == T006.MANDT
  • A_PURCHASINGINFORECORD.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • A_PURCHASINGINFORECORD.MANDT == T006.MANDT
  • A_PURCHASINGINFORECORD.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
Vendor's account number
  • Client
  • Vendor's account number
  • A_PURCHASINGINFORECORD.MANDT == LFA1.MANDT
  • A_PURCHASINGINFORECORD.SUPPLIER == LFA1.LIFNR
Supplier Subrange
  • Client
  • Vendor's account number
  • Supplier Subrange
  • A_PURCHASINGINFORECORD.MANDT == WYT1.MANDT
  • A_PURCHASINGINFORECORD.SUPPLIER == WYT1.LIFNR
  • A_PURCHASINGINFORECORD.SUPPLIERSUBRANGE == WYT1.LTSNR