C_PurInfoRecdPrHist

Monitor Purchasing Info Record Price History | view: CPURINFRECHIST | TRAN | Extraction: Not supported | Component: Info Record
Tables used: ADCPADRCT005TCURTTINCTT023TMAKTT001WT024EINAT024EEINEA017A018A025A028KONPLFA1WYT1TT007ST006ATWMEG
Column Name Description
PurchasingInfoRecord Number of purchasing info record
PurchasingOrganization FK Purchasing organization
PurchasingInfoRecordCategory Purchasing info record category
Plant FK Plant
ConditionValidityEndDate null
Column Name Description
💲 Condition Unit (Currency or Percentage) (ConditionRateValueUnit):
ConditionRateValue Condition amount or percentage where no scale exists
Column Name Description
📏 Condition Unit (ConditionQuantityUnit):
ConditionQuantity null
Column Name Description
ConditionValidityStartDate null
AvailabilityStartDate Available (Deliverable) From
AvailabilityEndDate Available (Deliverable) Until
Column Name Description
IsDeleted Purchasing info: General data flagged for deletion Show values
PricingDateControl Price Determination (Pricing) Date Control Show values
Column Name Description Domain name
FormattedPurDoc null
PurchasingDocument Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
PurchasingDocumentType null
PurchasingDocumentTypeName null
ParentNode null
HierarchyNodeLevel null
PurgDocDrillDownState null
Manufacturer Manufacturer
SupplierMaterialNumber Material Number Used by Supplier
MaterialPlannedDeliveryDurn Planned Delivery Time in Days
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance
SupplierName Name of Supplier TEXT80
TaxCodeName Tax Code Name TEXT50
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingInfoRecordTitle Description for Purchasing Info Record Category TEXT20
PlantName Plant Name TEXT30
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
IncotermsClassificationName Description TEXT30
ManufacturerName Name of Supplier TEXT80
PricingDateControlText Short Text for Fixed Values DDTEXT
PreferredSupplierName Name of Supplier TEXT80
SupplierSubrangeName Description of Supplier Subrange TEXT20
CurrencyName Description TEXT40
UnitOfMeasureLongName Unit of Measurement Text (Maximum 30 Characters) TEXT30
PriceVarianceInPct null
ConditionType Condition Type KSCHL
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PURINFORECDPRHIST.MANDT == T006.MANDT
  • C_PURINFORECDPRHIST.BASEUNIT == T006.MSEHI
Currency Key
  • Currency Key
  • Client
  • C_PURINFORECDPRHIST.CURRENCY == TCURC.WAERS
  • C_PURINFORECDPRHIST.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_PURINFORECDPRHIST.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_PURINFORECDPRHIST.MANDT == TINC.MANDT
Material Number
  • Material Number
  • Client
  • C_PURINFORECDPRHIST.MATERIAL == MARA.MATNR
  • C_PURINFORECDPRHIST.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_PURINFORECDPRHIST.MANDT == T023.MANDT
  • C_PURINFORECDPRHIST.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_PURINFORECDPRHIST.MANDT == T001W.MANDT
  • C_PURINFORECDPRHIST.PLANT == T001W.WERKS
Prior Supplier
  • Client
  • Prior Supplier
  • C_PURINFORECDPRHIST.MANDT == LFA1.MANDT
  • C_PURINFORECDPRHIST.PRIORSUPPLIER == LFA1.LIFNR
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURINFORECDPRHIST.PURCHASINGGROUP == T024.EKGRP
  • C_PURINFORECDPRHIST.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURINFORECDPRHIST.MANDT == T024E.MANDT
  • C_PURINFORECDPRHIST.PURCHASINGORGANIZATION == T024E.EKORG
Vendor's account number
  • Client
  • Vendor's account number
  • C_PURINFORECDPRHIST.MANDT == LFA1.MANDT
  • C_PURINFORECDPRHIST.SUPPLIER == LFA1.LIFNR
Supplier Subrange
  • Supplier Subrange
  • Client
  • Vendor's account number
  • C_PURINFORECDPRHIST.SUPPLIERSUBRANGE == WYT1.LTSNR
  • C_PURINFORECDPRHIST.MANDT == WYT1.MANDT
  • C_PURINFORECDPRHIST.SUPPLIER == WYT1.LIFNR
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • C_PURINFORECDPRHIST.[column in domain "KVEWE"] == T683.KVEWE
  • C_PURINFORECDPRHIST.[column in domain "KAPPL"] == T683.KAPPL
  • C_PURINFORECDPRHIST.TAXCALCULATIONPROCEDURE == T683.KALSM
  • C_PURINFORECDPRHIST.MANDT == T683.MANDT
Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • Tax on sales/purchases code
  • C_PURINFORECDPRHIST.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • C_PURINFORECDPRHIST.MANDT == T007A.MANDT
  • C_PURINFORECDPRHIST.TAXCODE == T007A.MWSKZ