P_PurInfoRecdPrHist

Private View for Purchasing Info Record Price History | view: PPURINFRECHIST | TRAN | Extraction: Not supported | Component: Info Record
Tables used: ADCP, ADRC, T005, T001W, EINA, EINE, A017, A018, A025, A028, KONP, LFA1
Column Name Description
PurchasingInfoRecord Number of purchasing info record
PurchasingOrganization FK Purchasing organization
PurchasingInfoRecordCategory Purchasing info record category Show values
Plant FK Plant
ConditionValidityEndDate null
Column Name Description
ConditionRateValue Condition amount or percentage where no scale exists
NetAmount Condition amount or percentage where no scale exists
Column Name Description
ConditionQuantity null
Column Name Description
ConditionValidityStartDate null
AvailabilityStartDate Available (Deliverable) From
AvailabilityEndDate Available (Deliverable) Until
Column Name Description
PurchasingInfoRecordCategory Purchasing info record category Show values
PricingDateControl Price Determination (Pricing) Date Control Show values
IsDeleted Purchasing info: General data flagged for deletion Show values
Column Name Description Domain name
FormattedPurDoc null
PurchasingDocument Purchasing Document Number EBELN
PurchasingDocumentItem Item Number of Purchasing Document EBELP
FormattedPurchaseOrderItem null
ConditionIsDeleted null
NumberOfItems null
HierarchyNodeLevel null
PurgDocDrillDownState null
PurchasingDocumentType null
ParentNode null
Manufacturer Manufacturer LIFNR
SupplierMaterialNumber Material Number Used by Supplier IDNEX
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
SupplierName Name of Supplier TEXT80
PlantName Plant Name TEXT30
ConditionType Condition Type KSCHL
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PURINFORECDPRHIST.BASEUNIT == T006.MSEHI
  • P_PURINFORECDPRHIST.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Client
  • P_PURINFORECDPRHIST.CURRENCY == TCURC.WAERS
  • P_PURINFORECDPRHIST.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • P_PURINFORECDPRHIST.MANDT == TINC.MANDT
  • P_PURINFORECDPRHIST.INCOTERMSCLASSIFICATION == TINC.INCO1
Material Number
  • Material Number
  • Client
  • P_PURINFORECDPRHIST.MATERIAL == MARA.MATNR
  • P_PURINFORECDPRHIST.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_PURINFORECDPRHIST.MATERIALGROUP == T023.MATKL
  • P_PURINFORECDPRHIST.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • P_PURINFORECDPRHIST.MANDT == T001W.MANDT
  • P_PURINFORECDPRHIST.PLANT == T001W.WERKS
Prior Supplier
  • Client
  • Prior Supplier
  • P_PURINFORECDPRHIST.MANDT == LFA1.MANDT
  • P_PURINFORECDPRHIST.PRIORSUPPLIER == LFA1.LIFNR
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURINFORECDPRHIST.PURCHASINGGROUP == T024.EKGRP
  • P_PURINFORECDPRHIST.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURINFORECDPRHIST.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURINFORECDPRHIST.MANDT == T024E.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • P_PURINFORECDPRHIST.SUPPLIER == LFA1.LIFNR
  • P_PURINFORECDPRHIST.MANDT == LFA1.MANDT
Supplier Subrange
  • Vendor's account number
  • Client
  • Supplier Subrange
  • P_PURINFORECDPRHIST.SUPPLIER == WYT1.LIFNR
  • P_PURINFORECDPRHIST.MANDT == WYT1.MANDT
  • P_PURINFORECDPRHIST.SUPPLIERSUBRANGE == WYT1.LTSNR
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • P_PURINFORECDPRHIST.[column in domain "KVEWE"] == T683.KVEWE
  • P_PURINFORECDPRHIST.[column in domain "KAPPL"] == T683.KAPPL
  • P_PURINFORECDPRHIST.TAXCALCULATIONPROCEDURE == T683.KALSM
  • P_PURINFORECDPRHIST.MANDT == T683.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • P_PURINFORECDPRHIST.TAXCODE == T007A.MWSKZ
  • P_PURINFORECDPRHIST.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • P_PURINFORECDPRHIST.MANDT == T007A.MANDT