C_PrchInfoRecords_Fs

Product Factsheet - Consumption view | view: CPRCHINFOREC | Extraction: Not supported | Component: Material Master
Tables used: MARAT002T023TMARAMAKTLFA1EINALFA1ADRPUSR21
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
Column Name Description
IsDeleted Purchasing info: General data flagged for deletion Show values
IsRegularSupplier Regular Supplier Show values
Column Name Description Domain name
Manufacturer Manufacturer LIFNR
ManufacturerName Name of manufacturer NAME
PriorSupplierName Name 1 NAME
PurchasingInfoRecordDesc Short Text for Purchasing Info Record TEXT40
SupplierPhoneNumber Supplier's Telephone Number TEXT16
SupplierMaterialGroup Supplier Material Group CHAR18
SupplierRespSalesPersonName Salesperson Responsible in the Event of Queries TEXT30
SupplierMaterialNumber Material Number Used by Supplier IDNEX
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PersonFullName Full Name of Person TEXT80
MaterialGroupName Product Group Description TEXT20
ProductDescription Product Description TEXT40
PreferredSupplierName null
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_PRCHINFORECORDS_FS.BASEUNIT == T006.MSEHI
  • C_PRCHINFORECORDS_FS.MANDT == T006.MANDT
Material Number
  • Client
  • Material Number
  • C_PRCHINFORECORDS_FS.MANDT == MARA.MANDT
  • C_PRCHINFORECORDS_FS.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Product Group
  • C_PRCHINFORECORDS_FS.MANDT == T023.MANDT
  • C_PRCHINFORECORDS_FS.MATERIALGROUP == T023.MATKL
Prior Supplier
  • Client
  • Prior Supplier
  • C_PRCHINFORECORDS_FS.MANDT == LFA1.MANDT
  • C_PRCHINFORECORDS_FS.PRIORSUPPLIER == LFA1.LIFNR
Points Unit
  • Client
  • Points Unit
  • C_PRCHINFORECORDS_FS.MANDT == T006.MANDT
  • C_PRCHINFORECORDS_FS.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PRCHINFORECORDS_FS.MANDT == T006.MANDT
  • C_PRCHINFORECORDS_FS.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
Vendor's account number
  • Vendor's account number
  • Client
  • C_PRCHINFORECORDS_FS.SUPPLIER == LFA1.LIFNR
  • C_PRCHINFORECORDS_FS.MANDT == LFA1.MANDT
Supplier Subrange
  • Vendor's account number
  • Supplier Subrange
  • Client
  • C_PRCHINFORECORDS_FS.SUPPLIER == WYT1.LIFNR
  • C_PRCHINFORECORDS_FS.SUPPLIERSUBRANGE == WYT1.LTSNR
  • C_PRCHINFORECORDS_FS.MANDT == WYT1.MANDT