P_EventBasedOrderKPI

Event-based Order KPI | view: PEBORDKPI | TRAN | Extraction: Not supported | Component: Cost Object Controlling
Tables used: COSL, ACDOCA, JEST, AFPO, T001, TKA02, FINSC_LEDGER, T001, AUFK, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FCOC_EBW_ASSG_CC, FCOC_EBW_ASSG_IT, FCOC_EBW_SRC_CAT, FCOC_EBW_SRC_ITM, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
OrderID Order Number
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
WIPCumltvAmtInCoCodeCurrency Amount in Company Code Currency
RsrvCumltvAmtInCoCodeCurrency Amount in Company Code Currency
WIPPerdAmtInCoCodeCurrency Amount in Company Code Currency
RsrvPerdAmtInCoCodeCurrency Amount in Company Code Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
PeriodAmountInCompanyCodeCrcy Amount in Company Code Currency
💲 Currency Key (GlobalCurrency):
WIPCumltvAmtInGlobalCurrency Amount in Global Currency
RsrvCumltvAmtInGlobalCurrency Amount in Global Currency
WIPPerdAmtInGlobalCurrency Amount in Global Currency
RsrvPerdAmtInGlobalCurrency Amount in Global Currency
AmountInGlobalCurrency Amount in Global Currency
PeriodAmountInGlobalCurrency Amount in Global Currency
💲 Currency Key (FreeDefinedCurrency1):
WIPCumltvAmtInFreeDfndCrcy1 Amount in Freely Defined Currency 1
RsrvCumltvAmtInFreeDfndCrcy1 Amount in Freely Defined Currency 1
WIPPerdAmtInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
RsrvPerdAmtInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
PeriodAmountInFreeDfndCrcy1 Amount in Freely Defined Currency 1
💲 Currency Key (FreeDefinedCurrency2):
WIPCumltvAmtInFreeDfndCrcy2 Amount in Freely Defined Currency 2
RsrvCumltvAmtInFreeDfndCrcy2 Amount in Freely Defined Currency 2
WIPPerdAmtInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
RsrvPerdAmtInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
PeriodAmountInFreeDfndCrcy2 Amount in Freely Defined Currency 2
💲 Currency Key (FreeDefinedCurrency3):
WIPCumltvAmtInFreeDfndCrcy3 Amount in Freely Defined Currency 3
RsrvCumltvAmtInFreeDfndCrcy3 Amount in Freely Defined Currency 3
WIPPerdAmtInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
RsrvPerdAmtInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
PeriodAmountInFreeDfndCrcy3 Amount in Freely Defined Currency 3
💲 Currency Key (FreeDefinedCurrency4):
WIPCumltvAmtInFreeDfndCrcy4 Amount in Freely Defined Currency 4
RsrvCumltvAmtInFreeDfndCrcy4 Amount in Freely Defined Currency 4
WIPPerdAmtInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
RsrvPerdAmtInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
PeriodAmountInFreeDfndCrcy4 Amount in Freely Defined Currency 4
💲 Currency Key (FreeDefinedCurrency5):
WIPCumltvAmtInFreeDfndCrcy5 Amount in Freely Defined Currency 5
RsrvCumltvAmtInFreeDfndCrcy5 Amount in Freely Defined Currency 5
WIPPerdAmtInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
RsrvPerdAmtInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
PeriodAmountInFreeDfndCrcy5 Amount in Freely Defined Currency 5
💲 Currency Key (FreeDefinedCurrency6):
WIPCumltvAmtInFreeDfndCrcy6 Amount in Freely Defined Currency 6
RsrvCumltvAmtInFreeDfndCrcy6 Amount in Freely Defined Currency 6
WIPPerdAmtInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
RsrvPerdAmtInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
PeriodAmountInFreeDfndCrcy6 Amount in Freely Defined Currency 6
💲 Currency Key (FreeDefinedCurrency7):
WIPCumltvAmtInFreeDfndCrcy7 Amount in Freely Defined Currency 7
RsrvCumltvAmtInFreeDfndCrcy7 Amount in Freely Defined Currency 7
WIPPerdAmtInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
RsrvPerdAmtInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
PeriodAmountInFreeDfndCrcy7 Amount in Freely Defined Currency 7
💲 Currency Key (FreeDefinedCurrency8):
WIPCumltvAmtInFreeDfndCrcy8 Amount in Freely Defined Currency 8
RsrvCumltvAmtInFreeDfndCrcy8 Amount in Freely Defined Currency 8
WIPPerdAmtInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
RsrvPerdAmtInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
PeriodAmountInFreeDfndCrcy8 Amount in Freely Defined Currency 8
Column Name Description
📏 Output Unit of Measure (BaseUnit):
PlanOutputQuantity null
ActualOutputQuantity null
Column Name Description
Column Name Description
OrderCategory Order category Show values
Column Name Description Domain name
OrderDescription Order Description TEXT40
StatusCode null
LogNumber Application Log: Log Number BALOGNR
LogHandle Application Log: Log Handle SYSUUID_22
LogMessageText Event-Based WIP and Variance Errors TEXT120
Severity null
Master Data Relations Join Conditions
Activity unit
  • Client
  • Output Unit of Measure
  • P_EVENTBASEDORDERKPI.MANDT == T006.MANDT
  • P_EVENTBASEDORDERKPI.BASEUNIT == T006.MSEHI
Company Code
  • Company Code
  • Client
  • P_EVENTBASEDORDERKPI.COMPANYCODE == T001.BUKRS
  • P_EVENTBASEDORDERKPI.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_EVENTBASEDORDERKPI.CONTROLLINGAREA == TKA01.KOKRS
  • P_EVENTBASEDORDERKPI.MANDT == TKA01.MANDT
Material Number for Order
  • Material Number for Order
  • Client
  • P_EVENTBASEDORDERKPI.MATERIAL == MARA.MATNR
  • P_EVENTBASEDORDERKPI.MANDT == MARA.MANDT
Order Type
  • Client
  • Order Type
  • P_EVENTBASEDORDERKPI.MANDT == T003O.CLIENT
  • P_EVENTBASEDORDERKPI.ORDERTYPE == T003O.AUART
Plant
  • Client
  • Plant
  • P_EVENTBASEDORDERKPI.MANDT == T001W.MANDT
  • P_EVENTBASEDORDERKPI.PLANT == T001W.WERKS
Unit of measure for in-house production
  • Unit of measure for in-house production
  • Client
  • P_EVENTBASEDORDERKPI.PRODUCTIONUNIT == T006.MSEHI
  • P_EVENTBASEDORDERKPI.MANDT == T006.MANDT
Profit Center
  • Controlling Area
  • Client
  • Profit Center
  • ?
  • P_EVENTBASEDORDERKPI.CONTROLLINGAREA == CEPC.KOKRS
  • P_EVENTBASEDORDERKPI.MANDT == CEPC.MANDT
  • P_EVENTBASEDORDERKPI.PROFITCENTER == CEPC.PRCTR
  • P_EVENTBASEDORDERKPI.[column in domain "DATBI"] == CEPC.DATBI
Results Analysis Key
  • Client
  • Results Analysis Key
  • P_EVENTBASEDORDERKPI.MANDT == TKKAA.MANDT
  • P_EVENTBASEDORDERKPI.RESULTSANALYSISKEY == TKKAA.ABGSL