P_RealTmeWrkInProcOrdHdAndItem

Real Time Work in Process Order Header and Items | view: PRTWIPORDHDRITM | Extraction: Not supported | Component: Fiori FXU Cost Controlling CO-FIO
Tables used: AFKOAFPOT001TKA02AUFK
Column Name Description
OrderID Order Number
OrderItem Order Item
Column Name Description
Column Name Description
Column Name Description
PlannedReleaseDate Planned Release Date
PlannedCompletionDate Planned Completion Date
CreationDate Created On
LastChangeDate Changed On
TechnicalCompletionDate Technical Completion Date
ScheduledBasicEndDate Scheduled Finish Date
ScheduledReleaseDate Scheduled Release Date
ActualStartDate Actual Start Date
ConfirmedEndDate Actual Finish Date
ActualReleasedDate Actual Release Date
Column Name Description
OrderCategory Order Category Show values
IsMarkedForDeletion Deletion Flag Show values
MfgOrderHasMultipleItems Joint Production Show values
IsFixedPriceCoProduct Fixed-Price Co-Product Show values
Column Name Description Domain name
OrderDescription Order Description TEXT40
ExternalOrder External Order Number AUFEX
ProductionVersion Production Version VERID
ActualCostsCostingVariant Costing Variant For Actual Cost KLVAR
PlannedCostsCostingVariant Costing Variant for Planned Costs KLVAR
CreatedByUser Created By XUBNAME
LastChangedByUser Last Changed By USNAM
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == T006.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.BASEUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • P_REALTMEWRKINPROCORDHDANDITEM.BUSINESSAREA == TGSB.GSBER
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == T001.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == TKA01.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.CONTROLLINGAREA == TKA01.KOKRS
Order Currency
  • Client
  • Order Currency
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == TCURC.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.CURRENCY == TCURC.WAERS
Material Number for Order
  • Client
  • Material Number for Order
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == MARA.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.MATERIAL == MARA.MATNR
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == T001W.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.MRPPLANT == T001W.WERKS
Order Type
  • Order Type
  • Client
  • P_REALTMEWRKINPROCORDHDANDITEM.ORDERTYPE == T003O.AUART
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == T003O.CLIENT
Plant
  • Client
  • Plant
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == T001W.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.PLANT == T001W.WERKS
Output Unit of Measure
  • Client
  • Output Unit of Measure
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == T006.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.PRODUCTIONUNIT == T006.MSEHI
Profit Center
  • Client
  • Profit Center
  • ?
  • Controlling Area
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == CEPC.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.PROFITCENTER == CEPC.PRCTR
  • P_REALTMEWRKINPROCORDHDANDITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_REALTMEWRKINPROCORDHDANDITEM.CONTROLLINGAREA == CEPC.KOKRS
Responsible Cost Center
  • Client
  • ?
  • Controlling Area
  • Responsible Cost Center
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == CSKS.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_REALTMEWRKINPROCORDHDANDITEM.CONTROLLINGAREA == CSKS.KOKRS
  • P_REALTMEWRKINPROCORDHDANDITEM.RESPONSIBLECOSTCENTER == CSKS.KOSTL
Storage location
  • Client
  • Planning Plant for an Order
  • Storage location
  • P_REALTMEWRKINPROCORDHDANDITEM.MANDT == T001L.MANDT
  • P_REALTMEWRKINPROCORDHDANDITEM.MRPPLANT == T001L.WERKS
  • P_REALTMEWRKINPROCORDHDANDITEM.STORAGELOCATION == T001L.LGORT