I_RoutingMaterialSearchModel

Material assgmt. to BOO | view: IRTGMATSRCHMOD | Extraction: Not supported | Component: Routing
Tables used: MAPL
Column Name Description
Material FK Material Number
Plant FK Plant
BillOfOperationsType FK Task List Type
BillOfOperationsGroup Key for Task List Group
BillOfOperationsVariant Group Counter
BOOToMaterialInternalID Counter for Additional Criteria
BOOMatlInternalVersionCounter Internal counter
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid-to date
CreationDate Date Record Created On
LastChangeDate Last Changed On
Column Name Description
IsDeleted Deletion Indicator Show values
IsImplicitlyDeleted Deletion Indicator Show values
Column Name Description Domain name
CreatedByUser Created By User XUBNAME
LastChangedByUser Last Changed By User XUBNAME
SalesOrder Sales Document VBELN
SalesOrderItem Sales Document Item POSNR
WBSElementInternalID Work Breakdown Structure Element Internal ID PS_POSNR
BOOSearchText Search Field for Customer-Specific Task List Selection CHAR20
BillOfOperationsVersion Routing Version PLNVERSN
Master Data Relations Join Conditions
Task List Type
  • Client
  • Task List Type
  • I_ROUTINGMATERIALSEARCHMODEL.MANDT == TCA01.MANDT
  • I_ROUTINGMATERIALSEARCHMODEL.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Change Number
  • Client
  • Change Number
  • I_ROUTINGMATERIALSEARCHMODEL.MANDT == AENR.MANDT
  • I_ROUTINGMATERIALSEARCHMODEL.CHANGENUMBER == AENR.AENNR
Account number of customer
  • Account number of customer
  • Client
  • I_ROUTINGMATERIALSEARCHMODEL.CUSTOMER == KNA1.KUNNR
  • I_ROUTINGMATERIALSEARCHMODEL.MANDT == KNA1.MANDT
Material Number
  • Client
  • Material Number
  • I_ROUTINGMATERIALSEARCHMODEL.MANDT == MARA.MANDT
  • I_ROUTINGMATERIALSEARCHMODEL.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_ROUTINGMATERIALSEARCHMODEL.MANDT == T001W.MANDT
  • I_ROUTINGMATERIALSEARCHMODEL.PLANT == T001W.WERKS
Vendor's account number
  • Vendor's account number
  • Client
  • I_ROUTINGMATERIALSEARCHMODEL.SUPPLIER == LFA1.LIFNR
  • I_ROUTINGMATERIALSEARCHMODEL.MANDT == LFA1.MANDT