I_SalesForecastKeyFigure

Sales Figure Collection | view: IPIRSFKF | Extraction: Not supported | Component: Demand Management
Tables used: SCAL_TT_DATEVBAKVBAPVBEP
Column Name Description
Product FK Material Number
Plant Plant (Own or External)
MRPArea Plant (Own or External)
SalesDocument FK Sales Document
OrderDocumentItem Sales Document Item
ScheduleLine Schedule Line Number
Column Name Description
Column Name Description
Column Name Description
ScheduleLineOrderDate Schedule line date
AvailabilityDate Material Staging/Availability Date
FirstDayOfWeekDate First day of week date
FirstDayOfMonthDate First Day of Month Date
Column Name Description
Column Name Description Domain name
SalesVolumeQuantity null
YearMonth Year Month NUM6
YearWeek Year Week NUM6
Master Data Relations Join Conditions
Material: order item
  • Client
  • Material Number
  • I_SALESFORECASTKEYFIGURE.MANDT == MARA.MANDT
  • I_SALESFORECASTKEYFIGURE.PRODUCT == MARA.MATNR
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • Plant (Own or External)
  • I_SALESFORECASTKEYFIGURE.STORAGELOCATION == T001L.LGORT
  • I_SALESFORECASTKEYFIGURE.MANDT == T001L.MANDT
  • I_SALESFORECASTKEYFIGURE.MRPAREA == T001L.WERKS
  • I_SALESFORECASTKEYFIGURE.PLANT == T001L.WERKS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SALESFORECASTKEYFIGURE.MANDT == T006.MANDT
  • I_SALESFORECASTKEYFIGURE.UNITOFMEASURE == T006.MSEHI