I_MasterRecipeActivity

Master Recipe Activity(Opr,Phs,SecRes) Details | view: IMSTRRCPACT | Extraction: Not supported | Component: Virtual Data Model in PP Master Data
Tables used: PLPO, PLFL, PLAS, TC21, TC20, TC20T, T006, T006A, CRHD
Column Name Description
BillOfOperationsType FK Task List Type
BillOfOperationsGroup Key for Task List Group
BillOfOperationsVariant Group Counter
BillOfOperationsSequence Sequence
BOOOperationInternalID Number of the Task List Node
BOOOpInternalVersionCounter Internal counter
Column Name Description
Column Name Description
📏 Unit of measure for activity (OperationUnit):
OperationReferenceQuantity Base Quantity
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit1):
StandardWorkQuantity1 Standard Value
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit2):
StandardWorkQuantity2 Standard Value
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit3):
StandardWorkQuantity3 Standard Value
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit4):
StandardWorkQuantity4 Standard Value
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit5):
StandardWorkQuantity5 Standard Value
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit6):
StandardWorkQuantity6 Standard Value
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid-To Date
Column Name Description
IsDeleted Deletion Indicator Show values
IsImplicitlyDeleted Deletion Indicator Show values
BOOSuperiorOperationIsPhase Indicator: Phase Show values
Column Name Description Domain name
Operation Operation/Activity Number VORNR
SuperiorOperationInternalID Number of the Task List Node KNTNR
SuperiorOperation Operation/Activity Number VORNR
BOOOperationIsPhase null
BOOOperationIsSecdryRsce null
WorkCenterInternalID Object ID NUM08
WorkCenter Work Center ARBPL
OperationText Operation Short Text TEXT40
OperationControlProfile Control key STEUS
OpQtyToBaseQtyNmrtr Numerator for Converting Routing and Operation UoM UMBSZ
OpQtyToBaseQtyDnmntr Denominator for Converting Routing and Operation UoM UMBSN
StandardWorkFormulaParam1 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName1 Standard Work Formula Parameter Name TEXT20
StandardWorkFormulaParam2 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName2 Standard Work Formula Parameter Name TEXT20
StandardWorkFormulaParam3 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName3 Standard Work Formula Parameter Name TEXT20
StandardWorkFormulaParam4 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName4 Standard Work Formula Parameter Name TEXT20
StandardWorkFormulaParam5 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName5 Standard Work Formula Parameter Name TEXT20
StandardWorkFormulaParam6 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName6 Standard Work Formula Parameter Name TEXT20
Master Data Relations Join Conditions
Task List Type
  • Client
  • Task List Type
  • I_MASTERRECIPEACTIVITY.MANDT == TCA01.MANDT
  • I_MASTERRECIPEACTIVITY.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Change Number
  • Client
  • Change Number
  • I_MASTERRECIPEACTIVITY.MANDT == AENR.MANDT
  • I_MASTERRECIPEACTIVITY.CHANGENUMBER == AENR.AENNR
Activity Type
  • ?
  • Client
  • ?
  • Activity Type
  • I_MASTERRECIPEACTIVITY.[column in domain "DATBI"] == CSLA.DATBI
  • I_MASTERRECIPEACTIVITY.MANDT == CSLA.MANDT
  • I_MASTERRECIPEACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_MASTERRECIPEACTIVITY.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR
Activity Type
  • ?
  • Activity Type
  • Client
  • ?
  • I_MASTERRECIPEACTIVITY.[column in domain "DATBI"] == CSLA.DATBI
  • I_MASTERRECIPEACTIVITY.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR
  • I_MASTERRECIPEACTIVITY.MANDT == CSLA.MANDT
  • I_MASTERRECIPEACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
Activity Type
  • ?
  • Client
  • Activity Type
  • ?
  • I_MASTERRECIPEACTIVITY.[column in domain "DATBI"] == CSLA.DATBI
  • I_MASTERRECIPEACTIVITY.MANDT == CSLA.MANDT
  • I_MASTERRECIPEACTIVITY.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR
  • I_MASTERRECIPEACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
Activity Type
  • Activity Type
  • ?
  • Client
  • ?
  • I_MASTERRECIPEACTIVITY.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR
  • I_MASTERRECIPEACTIVITY.[column in domain "DATBI"] == CSLA.DATBI
  • I_MASTERRECIPEACTIVITY.MANDT == CSLA.MANDT
  • I_MASTERRECIPEACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
Activity Type
  • ?
  • Client
  • ?
  • Activity Type
  • I_MASTERRECIPEACTIVITY.[column in domain "DATBI"] == CSLA.DATBI
  • I_MASTERRECIPEACTIVITY.MANDT == CSLA.MANDT
  • I_MASTERRECIPEACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_MASTERRECIPEACTIVITY.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR
Activity Type
  • ?
  • Activity Type
  • Client
  • ?
  • I_MASTERRECIPEACTIVITY.[column in domain "DATBI"] == CSLA.DATBI
  • I_MASTERRECIPEACTIVITY.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR
  • I_MASTERRECIPEACTIVITY.MANDT == CSLA.MANDT
  • I_MASTERRECIPEACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
Factory Calendar I_MASTERRECIPEACTIVITY.FACTORYCALENDAR == TFACD.IDENT
Language Key I_MASTERRECIPEACTIVITY.LONGTEXTLANGUAGECODE == T002.SPRAS
Setup group key
  • Plant
  • Client
  • Setup group category
  • Setup group key
  • I_MASTERRECIPEACTIVITY.PLANT == T425.WERKS
  • I_MASTERRECIPEACTIVITY.MANDT == T425.MANDT
  • I_MASTERRECIPEACTIVITY.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • I_MASTERRECIPEACTIVITY.OPERATIONSETUPGROUP == T425.RFSCH
Setup group category
  • Plant
  • Client
  • Setup group category
  • I_MASTERRECIPEACTIVITY.PLANT == T426.WERKS
  • I_MASTERRECIPEACTIVITY.MANDT == T426.MANDT
  • I_MASTERRECIPEACTIVITY.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
Setup Type Key
  • Setup Type Key
  • Plant
  • Client
  • I_MASTERRECIPEACTIVITY.OPERATIONSETUPTYPE == T428.RASCH
  • I_MASTERRECIPEACTIVITY.PLANT == T428.WERKS
  • I_MASTERRECIPEACTIVITY.MANDT == T428.MANDT
Standard Text Key
  • Standard Text Key
  • Client
  • I_MASTERRECIPEACTIVITY.OPERATIONSTANDARDTEXTCODE == T435.VLSCH
  • I_MASTERRECIPEACTIVITY.MANDT == T435.MANDT
Unit of measure for activity
  • Client
  • Unit of measure for activity
  • I_MASTERRECIPEACTIVITY.MANDT == T006.MANDT
  • I_MASTERRECIPEACTIVITY.OPERATIONUNIT == T006.MSEHI
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_MASTERRECIPEACTIVITY.MANDT == T006I.CLIENT
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.OPREFQTYUNITISOCODE == T006I.ISOCODE
Plant
  • Plant
  • Client
  • I_MASTERRECIPEACTIVITY.PLANT == T001W.WERKS
  • I_MASTERRECIPEACTIVITY.MANDT == T001W.MANDT
Standard Value Key
  • Client
  • Standard Value Key
  • I_MASTERRECIPEACTIVITY.MANDT == TC21.MANDT
  • I_MASTERRECIPEACTIVITY.STANDARDWORKFORMULAPARAMGROUP == TC21.VGWTS
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_MASTERRECIPEACTIVITY.MANDT == T006.MANDT
  • I_MASTERRECIPEACTIVITY.STANDARDWORKQUANTITYUNIT1 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_MASTERRECIPEACTIVITY.MANDT == T006.MANDT
  • I_MASTERRECIPEACTIVITY.STANDARDWORKQUANTITYUNIT2 == T006.MSEHI
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_MASTERRECIPEACTIVITY.STANDARDWORKQUANTITYUNIT3 == T006.MSEHI
  • I_MASTERRECIPEACTIVITY.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_MASTERRECIPEACTIVITY.MANDT == T006.MANDT
  • I_MASTERRECIPEACTIVITY.STANDARDWORKQUANTITYUNIT4 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_MASTERRECIPEACTIVITY.MANDT == T006.MANDT
  • I_MASTERRECIPEACTIVITY.STANDARDWORKQUANTITYUNIT5 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_MASTERRECIPEACTIVITY.MANDT == T006.MANDT
  • I_MASTERRECIPEACTIVITY.STANDARDWORKQUANTITYUNIT6 == T006.MSEHI
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_MASTERRECIPEACTIVITY.MANDT == T006I.CLIENT
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.OPREFQTYUNITISOCODE == T006I.ISOCODE
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_MASTERRECIPEACTIVITY.MANDT == T006I.CLIENT
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.OPREFQTYUNITISOCODE == T006I.ISOCODE
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_MASTERRECIPEACTIVITY.MANDT == T006I.CLIENT
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.OPREFQTYUNITISOCODE == T006I.ISOCODE
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_MASTERRECIPEACTIVITY.MANDT == T006I.CLIENT
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.OPREFQTYUNITISOCODE == T006I.ISOCODE
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_MASTERRECIPEACTIVITY.MANDT == T006I.CLIENT
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.OPREFQTYUNITISOCODE == T006I.ISOCODE
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_MASTERRECIPEACTIVITY.MANDT == T006I.CLIENT
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_MASTERRECIPEACTIVITY.OPREFQTYUNITISOCODE == T006I.ISOCODE