C_PurgInfoRecdAvgPrHist

Calculating Average Price History for PIR | view: CPIRAVGPRHIST | TRAN | Extraction: Not supported | Component: Info Record
Tables used: SCAL_TT_DATEADCPADRCT005T001WEINAEINEA017A018A025A028KONPLFA1
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
PurchasingDocument Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
Column Name Description
💲 Currency Key (Currency):
NetAmount Condition amount or percentage where no scale exists
Column Name Description
Column Name Description
ConditionValidityStartDate null
FirstDayOfMonthDate First Day of Month Date
Column Name Description
PurchasingInfoRecordCategory Purchasing info record category Show values
Column Name Description Domain name
FormattedPurDoc null
ParentNode null
HierarchyNodeLevel null
PurchasingDocumentType null
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Client
  • C_PURGINFORECDAVGPRHIST.CURRENCY == TCURC.WAERS
  • C_PURGINFORECDAVGPRHIST.MANDT == TCURC.MANDT
Plant
  • Client
  • Plant
  • C_PURGINFORECDAVGPRHIST.MANDT == T001W.MANDT
  • C_PURGINFORECDAVGPRHIST.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURGINFORECDAVGPRHIST.MANDT == T024.MANDT
  • C_PURGINFORECDAVGPRHIST.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURGINFORECDAVGPRHIST.MANDT == T024E.MANDT
  • C_PURGINFORECDAVGPRHIST.PURCHASINGORGANIZATION == T024E.EKORG