OIFDDM1

Del. point/material info for bulk delivery planning | #masterdata | Component: Marketing Retail Network
Column Name Description
MANDT FK Client
KUNNR FK Customer Number
DPVERS FK Preplanning version - bulk delivery preplanning
MATNR FK Material Number
Column Name Description
Column Name Description
Column Name Description
ERDAT Date Record Created on (Date)
ERZEIT Time Record Created at (Time)
AEDAT Date Record Changed on (Date)
AEZEIT Time when Record Was Changed
Column Name Description
PPACT Bulk delivery preplanning active (indicator) Show values
BLOIND Block Indicator Show values
DELIND Deletion indicator Show values
Column Name Description Domain name
REOLEV Reorder level for delivery point material OIF_LEVEL
OPTLEV Delivery point material/optimum running level OIF_LEVEL
SFACT1 Bulk delivery preplanning smoothing factor 1 OIF_SMOOTH
SFACT2 Bulk delivery preplanning smoothing factor 2 OIF_SMOOTH
SP_W1 Delivery point material sales percentage - Monday OIF_SPERC
SP_W2 Delivery point material sales percentage - Tuesday OIF_SPERC
SP_W3 Delivery point material sales percentage - Wednesday OIF_SPERC
SP_W4 Delivery point material sales percentage - Thursday OIF_SPERC
SP_W5 Delivery point material sales percentage - Friday OIF_SPERC
SP_W6 Delivery point material sales percentage - Saturday OIF_SPERC
SP_W7 Delivery point material sales percentage - Sunday OIF_SPERC
ERNAM User who Created Record USNAM
AENAM User who Changed Record USNAM
Master Data Relations Join Conditions
Delivery point material - preplanning version
  • OIFDDM1.MANDT == OIFDD2.MANDT
  • OIFDDM1.DPVERS == OIFDD2.DPVERS
Delivery point material - business partner (i.e. ship-to)
  • OIFDDM1.MANDT == KNA1.MANDT
  • OIFDDM1.KUNNR == KNA1.KUNNR
Delivery point material - sys. client OIFDDM1.MANDT == T000.MANDT
Delivery point material - material
  • Material Number
  • Client
  • OIFDDM1.MATNR == MARA.MATNR
  • OIFDDM1.MANDT == MARA.MANDT
Delivery point material UoM - UoM
  • OIFDDM1.MANDT == T006.MANDT
  • OIFDDM1.MEINS == T006.MSEHI