P_MasterRecipeActyWithLongText

Master Recipe Activities with Long Text | view: PMRCACTYLT | Extraction: Not supported | Component: Virtual Data Model in PP Master Data
Tables used: ESH_SR_LTXT, PLPO, PLAS, PLAS, TC21, PLPO_TEXT, CRHD
Column Name Description
BillOfOperationsType FK Task List Type
BillOfOperationsGroup Key for Task List Group
BillOfOperationsVariant Group Counter
BOOOperationInternalID Number of the Task List Node
BOOOpInternalVersionCounter Internal counter
BillOfOperationsIntID Internal counter
Column Name Description
Column Name Description
📏 Unit of measure for activity (OperationUnit):
OperationReferenceQuantity Base Quantity
📏 Standard Work Quantity Unit 1 (StandardWorkQuantityUnit1):
StandardWorkQuantity1 Standard Work Quantity 1
📏 Standard Work Quantity Unit 2 (StandardWorkQuantityUnit2):
StandardWorkQuantity2 Standard Work Quantity 2
📏 Standard Work Quantity Unit 3 (StandardWorkQuantityUnit3):
StandardWorkQuantity3 Standard Work Quantity 3
📏 Standard Work Quantity Unit 4 (StandardWorkQuantityUnit4):
StandardWorkQuantity4 Standard Work Quantity 4
📏 Standard Work Quantity Unit 5 (StandardWorkQuantityUnit5):
StandardWorkQuantity5 Standard Work Quantity 5
📏 Standard Work Quantity Unit 6 (StandardWorkQuantityUnit6):
StandardWorkQuantity6 Standard Work Quantity 6
StartDateOffsetDuration Offset to sub-operation start
EndDateOffsetDuration Offset to sub-operation finish
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid-To Date
Column Name Description
BOOOperationIsPhase Indicator: Phase Show values
BOOOperationIsSecdryRsce General Flag Show values
BOOSuperiorOperationIsPhase General Flag Show values
IsDeleted Deletion Indicator Show values
IsImplicitlyDeleted Deletion Indicator Show values
Column Name Description Domain name
Operation Operation / Phase Number PPH_VORNR
OperationText Operation Short Text TEXT40
BOOPhaseSuperiorOpInternalID Number of the Task List Node KNTNR
SuperiorOperationInternalID Number of the Task List Node KNTNR
OperationControlProfile Control key STEUS
WorkCenterInternalID Object ID NUM08
WorkCenter Work Center ARBPL
Plant Plant WERKS
StandardWorkFormulaParamGroup Standard Value Key VORGSCHL
OpQtyToBaseQtyNmrtr Numerator for Converting Routing and Operation UoM UMBSZ
OpQtyToBaseQtyDnmntr Denominator for Converting Routing and Operation UoM UMBSN
OperationSetupType Setup Type Key RUEARSCHLU
OperationStandardTextCode Standard Text Key KTSCH
PlainLongText Long Text
Master Data Relations Join Conditions
Task List Type
  • Task List Type
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == TCA01.MANDT
Change Number
  • Change Number
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.CHANGENUMBER == AENR.AENNR
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == AENR.MANDT
Cost Center Activity Type 1
  • Cost Center Activity Type 1
  • ?
  • ?
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "DATBI"] == CSLA.DATBI
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == CSLA.MANDT
Cost Center Activity Type 2
  • Cost Center Activity Type 2
  • ?
  • ?
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "DATBI"] == CSLA.DATBI
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == CSLA.MANDT
Cost Center Activity Type 3
  • Cost Center Activity Type 3
  • ?
  • ?
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "DATBI"] == CSLA.DATBI
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == CSLA.MANDT
Cost Center Activity Type 4
  • ?
  • ?
  • Cost Center Activity Type 4
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "DATBI"] == CSLA.DATBI
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_MASTERRECIPEACTYWITHLONGTEXT.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == CSLA.MANDT
Cost Center Activity Type 5
  • ?
  • ?
  • Cost Center Activity Type 5
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "DATBI"] == CSLA.DATBI
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_MASTERRECIPEACTYWITHLONGTEXT.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == CSLA.MANDT
Cost Center Activity Type 6
  • ?
  • ?
  • Cost Center Activity Type 6
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "DATBI"] == CSLA.DATBI
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_MASTERRECIPEACTYWITHLONGTEXT.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == CSLA.MANDT
Factory Calendar P_MASTERRECIPEACTYWITHLONGTEXT.FACTORYCALENDAR == TFACD.IDENT
Language Key P_MASTERRECIPEACTYWITHLONGTEXT.LONGTEXTLANGUAGECODE == T002.SPRAS
Setup group key
  • Setup group category
  • Setup group key
  • Client
  • ?
  • P_MASTERRECIPEACTYWITHLONGTEXT.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • P_MASTERRECIPEACTYWITHLONGTEXT.OPERATIONSETUPGROUP == T425.RFSCH
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == T425.MANDT
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "WERKS_D"] == T425.WERKS
Setup group category
  • Setup group category
  • Client
  • ?
  • P_MASTERRECIPEACTYWITHLONGTEXT.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == T426.MANDT
  • P_MASTERRECIPEACTYWITHLONGTEXT.[column in domain "WERKS_D"] == T426.WERKS
Unit of measure for activity
  • Client
  • Unit of measure for activity
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == T006.MANDT
  • P_MASTERRECIPEACTYWITHLONGTEXT.OPERATIONUNIT == T006.MSEHI
Work Center Formula Parameter 1
  • Client
  • Work Center Formula Parameter 1
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == TC20.MANDT
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKFORMULAPARAM1 == TC20.PARID
Work Center Formula Parameter 2
  • Work Center Formula Parameter 2
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKFORMULAPARAM2 == TC20.PARID
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == TC20.MANDT
Work Center Formula Parameter 3
  • Work Center Formula Parameter 3
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKFORMULAPARAM3 == TC20.PARID
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == TC20.MANDT
Work Center Formula Parameter 4
  • Work Center Formula Parameter 4
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKFORMULAPARAM4 == TC20.PARID
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == TC20.MANDT
Work Center Formula Parameter 5
  • Work Center Formula Parameter 5
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKFORMULAPARAM5 == TC20.PARID
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == TC20.MANDT
Work Center Formula Parameter 6
  • Work Center Formula Parameter 6
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKFORMULAPARAM6 == TC20.PARID
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == TC20.MANDT
Standard Work Quantity Unit 1
  • Standard Work Quantity Unit 1
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKQUANTITYUNIT1 == T006.MSEHI
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == T006.MANDT
Standard Work Quantity Unit 2
  • Client
  • Standard Work Quantity Unit 2
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == T006.MANDT
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKQUANTITYUNIT2 == T006.MSEHI
Standard Work Quantity Unit 3
  • Standard Work Quantity Unit 3
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKQUANTITYUNIT3 == T006.MSEHI
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == T006.MANDT
Standard Work Quantity Unit 4
  • Standard Work Quantity Unit 4
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKQUANTITYUNIT4 == T006.MSEHI
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == T006.MANDT
Standard Work Quantity Unit 5
  • Standard Work Quantity Unit 5
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKQUANTITYUNIT5 == T006.MSEHI
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == T006.MANDT
Standard Work Quantity Unit 6
  • Standard Work Quantity Unit 6
  • Client
  • P_MASTERRECIPEACTYWITHLONGTEXT.STANDARDWORKQUANTITYUNIT6 == T006.MSEHI
  • P_MASTERRECIPEACTYWITHLONGTEXT.MANDT == T006.MANDT