I_MasterRecipeSecondaryRsce

Master Recipe Secondary Resouce Details | view: IMSTRRCPSECRSC | Extraction: Not supported | Component: Virtual Data Model in PP Master Data
Tables used: PLPO, PLAS, TC21, CRHD
Column Name Description
BillOfOperationsType FK Task List Type
BillOfOperationsGroup Key for Task List Group
BOOOperationInternalID Number of the Task List Node
BOOOpInternalVersionCounter Internal counter
BillOfOperationsVariant Group Counter
Column Name Description
💲 Currency Key (OpExternalProcessingCurrency):
OpExternalProcessingPrice Net Price in Purchasing Info Record
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
📏 Unit for Offset to Start (StartDateOffsetDurationUnit):
StartDateOffsetDuration Offset to sub-operation start
📏 Unit for Offset to Finish (EndDateOffsetDurationUnit):
EndDateOffsetDuration Offset to sub-operation finish
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid-To Date
CreationDate Created On
LastChangeDate Last Changed On
Column Name Description
IsDeleted Deletion Indicator Show values
IsImplicitlyDeleted Deletion Indicator Show values
BOOSuperiorOperationIsPhase Indicator: Phase Show values
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
Operation Operation / Phase Number PPH_VORNR
OperationText Operation Short Text TEXT40
SuperiorOperationInternalID Node Number of the Superior Operation KNTNR
WorkCenterInternalID Object ID NUM08
OperationControlProfile Control key STEUS
OperationStandardTextCode Standard Text Key KTSCH
OpQtyToBaseQtyNmrtr Numerator for Converting Routing and Operation UoM UMBSZ
OpQtyToBaseQtyDnmntr Denominator for Converting Routing and Operation UoM UMBSN
NumberOfTimeTickets Number of Time Tickets LOHNANZ
NumberOfConfirmationSlips Number of Confirmation Slips NUM03
EmployeeWageGroup Employee Wage Group LOHNGRP
EmployeeWageType Employee Wage Type LOART
EmployeeSuitability Suitability QUALF
NumberOfEmployees Number of employees ANZMA
BusinessProcess Business Process CO_PRZNR
OpIsExtlyProcdWithSubcontrg Indicator: External Processing Operation with Subcontracting CHAR1
PurchaseContract Purchasing Document Number EBELN
PurchasingInfoRecdAddlGrpgName Sort Term for Non-Stock Info Records CHAR10
PlannedDeliveryDuration Planned Delivery Time in Days DEC3
NumberOfOperationPriceUnits Price unit DEC5
InspectionLotType Inspection Type QPART
CreatedByUser Created By USNAM
LastChangedByUser Last Changed By USNAM
Master Data Relations Join Conditions
Task List Type
  • Task List Type
  • Client
  • I_MASTERRECIPESECONDARYRSCE.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TCA01.MANDT
Capacity Category
  • Capacity Category
  • Client
  • I_MASTERRECIPESECONDARYRSCE.CAPACITYCATEGORYCODE == TC26.KAPAR
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC26.MANDT
Change Number
  • Change Number
  • Client
  • I_MASTERRECIPESECONDARYRSCE.CHANGENUMBER == AENR.AENNR
  • I_MASTERRECIPESECONDARYRSCE.MANDT == AENR.MANDT
Cost Center Activity Type 1
  • Last Changed On
  • ?
  • Cost Center Activity Type 1
  • Client
  • I_MASTERRECIPESECONDARYRSCE.LASTCHANGEDATE == CSLA.DATBI
  • I_MASTERRECIPESECONDARYRSCE.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_MASTERRECIPESECONDARYRSCE.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR
  • I_MASTERRECIPESECONDARYRSCE.MANDT == CSLA.MANDT
Cost Center Activity Type 2
  • Cost Center Activity Type 2
  • Last Changed On
  • ?
  • Client
  • I_MASTERRECIPESECONDARYRSCE.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR
  • I_MASTERRECIPESECONDARYRSCE.LASTCHANGEDATE == CSLA.DATBI
  • I_MASTERRECIPESECONDARYRSCE.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_MASTERRECIPESECONDARYRSCE.MANDT == CSLA.MANDT
Cost Center Activity Type 3
  • Cost Center Activity Type 3
  • Last Changed On
  • ?
  • Client
  • I_MASTERRECIPESECONDARYRSCE.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR
  • I_MASTERRECIPESECONDARYRSCE.LASTCHANGEDATE == CSLA.DATBI
  • I_MASTERRECIPESECONDARYRSCE.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_MASTERRECIPESECONDARYRSCE.MANDT == CSLA.MANDT
Cost Center Activity Type 4
  • Last Changed On
  • Cost Center Activity Type 4
  • ?
  • Client
  • I_MASTERRECIPESECONDARYRSCE.LASTCHANGEDATE == CSLA.DATBI
  • I_MASTERRECIPESECONDARYRSCE.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR
  • I_MASTERRECIPESECONDARYRSCE.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_MASTERRECIPESECONDARYRSCE.MANDT == CSLA.MANDT
Cost Center Activity Type 5
  • Cost Center Activity Type 5
  • Last Changed On
  • ?
  • Client
  • I_MASTERRECIPESECONDARYRSCE.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR
  • I_MASTERRECIPESECONDARYRSCE.LASTCHANGEDATE == CSLA.DATBI
  • I_MASTERRECIPESECONDARYRSCE.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_MASTERRECIPESECONDARYRSCE.MANDT == CSLA.MANDT
Cost Center Activity Type 6
  • Last Changed On
  • ?
  • Cost Center Activity Type 6
  • Client
  • I_MASTERRECIPESECONDARYRSCE.LASTCHANGEDATE == CSLA.DATBI
  • I_MASTERRECIPESECONDARYRSCE.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_MASTERRECIPESECONDARYRSCE.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR
  • I_MASTERRECIPESECONDARYRSCE.MANDT == CSLA.MANDT
Cost Element
  • ?
  • Client
  • Cost Element
  • I_MASTERRECIPESECONDARYRSCE.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_MASTERRECIPESECONDARYRSCE.MANDT == CSKA.MANDT
  • I_MASTERRECIPESECONDARYRSCE.COSTELEMENT == CSKA.KSTAR
Unit for Offset to Finish
  • Unit for Offset to Finish
  • Client
  • I_MASTERRECIPESECONDARYRSCE.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T006.MANDT
Factory Calendar I_MASTERRECIPESECONDARYRSCE.FACTORYCALENDAR == TFACD.IDENT
Language Key I_MASTERRECIPESECONDARYRSCE.LONGTEXTLANGUAGECODE == T002.SPRAS
Material Group
  • Client
  • Material Group
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T023.MANDT
  • I_MASTERRECIPESECONDARYRSCE.MATERIALGROUP == T023.MATKL
Operation Costing Relevancy Type
  • Operation Costing Relevancy Type
  • Client
  • I_MASTERRECIPESECONDARYRSCE.OPERATIONCOSTINGRELEVANCYTYPE == TCK08.SELKZ
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TCK08.MANDT
Unit of measure for activity
  • Unit of measure for activity
  • Client
  • I_MASTERRECIPESECONDARYRSCE.OPERATIONUNIT == T006.MSEHI
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T006.MANDT
Currency Key
  • Client
  • Currency Key
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TCURC.MANDT
  • I_MASTERRECIPESECONDARYRSCE.OPEXTERNALPROCESSINGCURRENCY == TCURC.WAERS
Key for performance efficiency rate
  • Client
  • Key for performance efficiency rate
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC31.MANDT
  • I_MASTERRECIPESECONDARYRSCE.PERFEFFICIENCYRATIOCODE1 == TC31.ID
Key for performance efficiency rate
  • Key for performance efficiency rate
  • Client
  • I_MASTERRECIPESECONDARYRSCE.PERFEFFICIENCYRATIOCODE2 == TC31.ID
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC31.MANDT
Key for performance efficiency rate
  • Client
  • Key for performance efficiency rate
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC31.MANDT
  • I_MASTERRECIPESECONDARYRSCE.PERFEFFICIENCYRATIOCODE3 == TC31.ID
Key for performance efficiency rate
  • Key for performance efficiency rate
  • Client
  • I_MASTERRECIPESECONDARYRSCE.PERFEFFICIENCYRATIOCODE4 == TC31.ID
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC31.MANDT
Key for performance efficiency rate
  • Key for performance efficiency rate
  • Client
  • I_MASTERRECIPESECONDARYRSCE.PERFEFFICIENCYRATIOCODE5 == TC31.ID
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC31.MANDT
Key for performance efficiency rate
  • Key for performance efficiency rate
  • Client
  • I_MASTERRECIPESECONDARYRSCE.PERFEFFICIENCYRATIOCODE6 == TC31.ID
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC31.MANDT
Plant
  • Plant
  • Client
  • I_MASTERRECIPESECONDARYRSCE.PLANT == T001W.WERKS
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T001W.MANDT
Purchasing Group for External Processing Activity
  • Purchasing Group for External Processing Activity
  • Client
  • I_MASTERRECIPESECONDARYRSCE.PURCHASINGGROUP == T024.EKGRP
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • I_MASTERRECIPESECONDARYRSCE.PURCHASINGINFORECORD == EINA.INFNR
  • I_MASTERRECIPESECONDARYRSCE.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_MASTERRECIPESECONDARYRSCE.PURCHASINGORGANIZATION == T024E.EKORG
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T024E.MANDT
Work Center Formula Parameter 1
  • Client
  • Work Center Formula Parameter 1
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC20.MANDT
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKFORMULAPARAM1 == TC20.PARID
Work Center Formula Parameter 2
  • Work Center Formula Parameter 2
  • Client
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKFORMULAPARAM2 == TC20.PARID
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC20.MANDT
Work Center Formula Parameter 3
  • Work Center Formula Parameter 3
  • Client
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKFORMULAPARAM3 == TC20.PARID
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC20.MANDT
Work Center Formula Parameter 4
  • Work Center Formula Parameter 4
  • Client
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKFORMULAPARAM4 == TC20.PARID
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC20.MANDT
Work Center Formula Parameter 5
  • Work Center Formula Parameter 5
  • Client
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKFORMULAPARAM5 == TC20.PARID
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC20.MANDT
Work Center Formula Parameter 6
  • Work Center Formula Parameter 6
  • Client
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKFORMULAPARAM6 == TC20.PARID
  • I_MASTERRECIPESECONDARYRSCE.MANDT == TC20.MANDT
Standard Work Quantity Unit 1
  • Standard Work Quantity Unit 1
  • Client
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKQUANTITYUNIT1 == T006.MSEHI
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T006.MANDT
Standard Work Quantity Unit 2
  • Client
  • Standard Work Quantity Unit 2
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T006.MANDT
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKQUANTITYUNIT2 == T006.MSEHI
Standard Work Quantity Unit 3
  • Standard Work Quantity Unit 3
  • Client
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKQUANTITYUNIT3 == T006.MSEHI
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T006.MANDT
Standard Work Quantity Unit 4
  • Standard Work Quantity Unit 4
  • Client
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKQUANTITYUNIT4 == T006.MSEHI
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T006.MANDT
Standard Work Quantity Unit 5
  • Client
  • Standard Work Quantity Unit 5
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T006.MANDT
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKQUANTITYUNIT5 == T006.MSEHI
Standard Work Quantity Unit 6
  • Standard Work Quantity Unit 6
  • Client
  • I_MASTERRECIPESECONDARYRSCE.STANDARDWORKQUANTITYUNIT6 == T006.MSEHI
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T006.MANDT
Unit for Offset to Start
  • Unit for Offset to Start
  • Client
  • I_MASTERRECIPESECONDARYRSCE.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_MASTERRECIPESECONDARYRSCE.MANDT == T006.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_MASTERRECIPESECONDARYRSCE.SUPPLIER == LFA1.LIFNR
  • I_MASTERRECIPESECONDARYRSCE.MANDT == LFA1.MANDT