P_PurInfoRecdPOPrHist

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