P_Prchinforecords_FS

private factsheet - purchasing info records | view: PPRCHINFORECORDS | 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
AvailibilityStartDate Available (Deliverable) From
AvailibilityEndDate Available (Deliverable) Until
Column Name Description
IsDeleted Purchasing info: General data flagged for deletion Show values
VarblPurOrdUnitStatus Variable Purchase Order Unit Active Show values
IsRegularSupplier Regular Supplier Show values
Column Name Description Domain name
PersonFullName Full Name of Person TEXT80
ManufacturerName Name of manufacturer NAME
MaterialGroupName Product Group Description TEXT20
ProductDescription Product Description TEXT40
PriorSupplierName Name 1 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
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PreferredSupplierName null
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_PRCHINFORECORDS_FS.MANDT == T006.MANDT
  • P_PRCHINFORECORDS_FS.BASEUNIT == T006.MSEHI
Language Key P_PRCHINFORECORDS_FS.LANGUAGE == T002.SPRAS
Material Number
  • Client
  • Material Number
  • P_PRCHINFORECORDS_FS.MANDT == MARA.MANDT
  • P_PRCHINFORECORDS_FS.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Product Group
  • P_PRCHINFORECORDS_FS.MANDT == T023.MANDT
  • P_PRCHINFORECORDS_FS.MATERIALGROUP == T023.MATKL
Prior Supplier
  • Client
  • Prior Supplier
  • P_PRCHINFORECORDS_FS.MANDT == LFA1.MANDT
  • P_PRCHINFORECORDS_FS.PRIORSUPPLIER == LFA1.LIFNR
Points Unit
  • Client
  • Points Unit
  • P_PRCHINFORECORDS_FS.MANDT == T006.MANDT
  • P_PRCHINFORECORDS_FS.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PRCHINFORECORDS_FS.MANDT == T006.MANDT
  • P_PRCHINFORECORDS_FS.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
Vendor's account number
  • Client
  • Vendor's account number
  • P_PRCHINFORECORDS_FS.MANDT == LFA1.MANDT
  • P_PRCHINFORECORDS_FS.SUPPLIER == LFA1.LIFNR
Supplier Subrange
  • Client
  • Vendor's account number
  • Supplier Subrange
  • P_PRCHINFORECORDS_FS.MANDT == WYT1.MANDT
  • P_PRCHINFORECORDS_FS.SUPPLIER == WYT1.LIFNR
  • P_PRCHINFORECORDS_FS.SUPPLIERSUBRANGE == WYT1.LTSNR