C_PurchasingInfoRecordDEX

Data Extraction for Purchasing Info Record | view: CMMPURINFORECDEX | TRAN | Extraction: Full or Incremental | Component: Reporting
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
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
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
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_PURCHASINGINFORECORDDEX.MANDT == T006.MANDT
  • C_PURCHASINGINFORECORDDEX.BASEUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • C_PURCHASINGINFORECORDDEX.MANDT == MARA.MANDT
  • C_PURCHASINGINFORECORDDEX.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURCHASINGINFORECORDDEX.MANDT == T023.MANDT
  • C_PURCHASINGINFORECORDDEX.MATERIALGROUP == T023.MATKL
Prior Supplier
  • Client
  • Prior Supplier
  • C_PURCHASINGINFORECORDDEX.MANDT == LFA1.MANDT
  • C_PURCHASINGINFORECORDDEX.PRIORSUPPLIER == LFA1.LIFNR
Points Unit
  • Client
  • Points Unit
  • C_PURCHASINGINFORECORDDEX.MANDT == T006.MANDT
  • C_PURCHASINGINFORECORDDEX.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PURCHASINGINFORECORDDEX.MANDT == T006.MANDT
  • C_PURCHASINGINFORECORDDEX.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
Return Agreement
  • Client
  • Return Agreement
  • C_PURCHASINGINFORECORDDEX.MANDT == TWRV.MANDT
  • C_PURCHASINGINFORECORDDEX.RETURNAGREEMENT == TWRV.RUECV
Vendor's account number
  • Vendor's account number
  • Client
  • C_PURCHASINGINFORECORDDEX.SUPPLIER == LFA1.LIFNR
  • C_PURCHASINGINFORECORDDEX.MANDT == LFA1.MANDT
Certificate Category
  • Client
  • Certificate Category
  • C_PURCHASINGINFORECORDDEX.MANDT == T069.MANDT
  • C_PURCHASINGINFORECORDDEX.SUPPLIERCERTORIGINCAT == T069.URZTP
Country/Region of Issue of Certificate of Origin
  • Client
  • Country/Region of Issue of Certificate of Origin
  • C_PURCHASINGINFORECORDDEX.MANDT == T005.MANDT
  • C_PURCHASINGINFORECORDDEX.SUPPLIERCERTORIGINCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region of Issue of Certificate of Origin
  • C_PURCHASINGINFORECORDDEX.MANDT == T005S.MANDT
  • C_PURCHASINGINFORECORDDEX.SUPPLIERCERTORIGINREGION == T005S.BLAND
  • C_PURCHASINGINFORECORDDEX.SUPPLIERCERTORIGINCOUNTRY == T005S.LAND1
Supplier Subrange
  • Vendor's account number
  • Client
  • Supplier Subrange
  • C_PURCHASINGINFORECORDDEX.SUPPLIER == WYT1.LIFNR
  • C_PURCHASINGINFORECORDDEX.MANDT == WYT1.MANDT
  • C_PURCHASINGINFORECORDDEX.SUPPLIERSUBRANGE == WYT1.LTSNR