MAPL

Assignment of Task Lists to Materials | #masterdata | Component: Routing
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
PLNTY FK Task List Type
PLNNR Key for Task List Group
PLNAL Group Counter
ZKRIZ Counter for Additional Criteria
ZAEHL Internal counter
Column Name Description
Column Name Description
Column Name Description
DATUV Valid-From Date
ANDAT Date Record Created On
AEDAT Last Changed On
VALID_TO Valid-to date
Column Name Description
LOEKZ Deletion Indicator Show values
PARKZ Indicator: inactive changes Show values
LOEKZ_INHERITED Deletion Indicator Show values
Column Name Description Domain name
TECHV Technical status from TECHS
ANNAM User who created record USNAM
AENAM Name of Person Who Changed Object USNAM
SUCHFELD Search Field for Customer-Specific Task List Selection CHAR20
VBELN Sales Document VBELN
POSNR Sales Document Item POSNR
PSPNR Work breakdown structure element (WBS element) PS_POSNR
VERSN Routing Version PLNVERSN
VERSN_SOURCE Source Routing Version PLNVERSN
VERSN_SOURCE_ZKRIZ Task List Version: Source number mat. assgnmt. to task ZKRIZ
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • MAPL.AENNR == AENR.AENNR
  • MAPL.MANDT == AENR.MANDT
Account number of customer
  • MAPL.MANDT == KNA1.MANDT
  • MAPL.KUNR == KNA1.KUNNR
Vendor's account number
  • MAPL.MANDT == LFA1.MANDT
  • MAPL.LIFNR == LFA1.LIFNR
Client MAPL.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • MAPL.MATNR == MARA.MATNR
  • MAPL.MANDT == MARA.MANDT
Object for Multiple Specifications
  • MAPL.MANDT == TQMS2.MANDT
  • MAPL.MS_OBJECT == TQMS2.OBJECT
Type of Object for Multiple Specifications
  • Type of Object for Multiple Specifications
  • Client
  • MAPL.MS_OBJTYPE == TQMS1.OBJECTTYPE
  • MAPL.MANDT == TQMS1.MANDT
Task List Type
  • MAPL.MANDT == TCA01.MANDT
  • MAPL.PLNTY == TCA01.PLNTY
Plant
  • MAPL.MANDT == T001W.MANDT
  • MAPL.WERKS == T001W.WERKS