MDDMAP

Mapping Table for External User for MRP Evaluations | #masterdata | Component: Master Data
Column Name Description
MANDT Client
UNAME User Name
VIEWN Key for planning result view
Column Name Description
Column Name Description
Column Name Description
Column Name Description
BESKZ Procurement Type Show values
JBEKZ Selection indicator for processed MRP lists Show values
NBEKZ Selection indicator for unprocessed MRP lists Show values
Column Name Description Domain name
BANKZ Selection by Purchase Requisitions CHAR1
BSTKZ Selection by Purchase Orders CHAR1
PAUKZ Selection by Planned Orders CHAR1
DTLFV Start of delivery date interval DECV4
DTLFB End of delivery date interval DECV4
DTDFV MRP date from - relative value NUMC3
DTDFB MRP date to - relative value NUMC3
DTDBV Processing date from - relative value NUMC3
DTDBB Processing date to - relative value NUMC3
BERW1 Stock Days' Supply Without Receipts DECV3_1
BERW2 First Receipt Days' Supply DECV3_1
BERW4 Second Receipt Days' Supply DECV3_1
SELKZ1 Selection indicator for exception groups CHAR1
SELKZ2 Selection indicator for exception groups CHAR1
SELKZ3 Selection indicator for exception groups CHAR1
SELKZ4 Selection indicator for exception groups CHAR1
SELKZ5 Selection indicator for exception groups CHAR1
SELKZ6 Selection indicator for exception groups CHAR1
SELKZ7 Selection indicator for exception groups CHAR1
SELKZ8 Selection indicator for exception groups CHAR1
NAUKZ Indicator: new exception in the MRP list CHAR1
Master Data Relations Join Conditions
MRP Area
  • MDDMAP.MANDT == MDLV.MANDT
  • MDDMAP.BERID == MDLV.BERID
MRP Type
  • MDDMAP.MANDT == T438A.MANDT
  • MDDMAP.DISMM == T438A.DISMM
MRP Controller
  • Plant
  • MRP Controller
  • Client
  • MDDMAP.WERKS == T024D.WERKS
  • MDDMAP.DISPO == T024D.DISPO
  • MDDMAP.MANDT == T024D.MANDT
MRP Controller
  • ?
  • MRP Controller
  • Client
  • MDDMAP.[column in domain "WERKS_D"] == T024D.WERKS
  • MDDMAP.DSP01 == T024D.DISPO
  • MDDMAP.MANDT == T024D.MANDT
Foreign Key Display Filter
  • Name of Display Filter
  • Client
  • MDDMAP.FILBZ == T463.AFIBZ
  • MDDMAP.MANDT == T463.MANDT
Vendor
  • MDDMAP.MANDT == LFA1.MANDT
  • MDDMAP.LIFNR == LFA1.LIFNR
ABC Indicator
  • MDDMAP.MANDT == TMABC.MANDT
  • MDDMAP.MAABC == TMABC.MAABC
Planning Scenario
  • MDDMAP.MANDT == PLSC.MANDT
  • MDDMAP.PLSCN == PLSC.PLSCN
Product Group
  • Name of the product group
  • Client
  • MDDMAP.PRGRP == MARA.MATNR
  • MDDMAP.MANDT == MARA.MANDT
Special Procurement Key
  • ?
  • Special procurement type
  • MDDMAP.MANDT == T460A.MANDT
  • MDDMAP.[column in domain "WERKS_D"] == T460A.WERKS
  • MDDMAP.SOBSL == T460A.SOBSL
Plant
  • MDDMAP.MANDT == T001W.MANDT
  • MDDMAP.WERKS == T001W.WERKS