PPH_DDL_MAT_CTRL_0

Read Material Data for MRP | view: V_PPH_MAT_CTRL_0 | TRAN | Extraction: Not supported | Component: Material Requirements Planning
Tables used: PPH_DBVM, MARA, MDFD, MDFDDB, MDLV, MDMA, PPHDBVMSET, T006, T460A, T460A
Column Name Description
Column Name Description
marc_losfx Lot-Size-Independent Costs
mdma_losfx Lot-Size-Independent Costs
Column Name Description
umlmc Stock in transfer (plant to plant)
marc_bstmi Minimum Lot Size
mdma_bstmi Minimum Lot Size
marc_bstma Maximum Lot Size
mdma_bstma Maximum Lot Size
marc_bstfe Fixed lot size
mdma_bstfe Fixed lot size
marc_mabst Maximum Stock Level
mdma_mabst Maximum Stock Level
marc_bstrf Rounding value for purchase order quantity
mdma_bstrf Rounding value for purchase order quantity
basmg Base quantity
Column Name Description
mmstd Date from Which the Plant-Specific Material Status Is Valid
mstde Date from which the cross-plant material status is valid
ausdt Effective-Out Date
mfxdt null
Column Name Description
loekz Deletion Indicator Show values
sgt_stat Segmentation Material Master Status Show values
sgt_statc Segmentation Status Show values
sgt_scope Segmentation Strategy Scope Show values
sgt_mrpsi Sort Stock based on Segment Show values
sgt_prcm Consumption Priority [Obsolete] Show values
sgt_chint Discrete Batch Number [Obsolete] Show values
fsh_mg_arun_req Supply Assignment (ARun) Show values
arun_fix_batch Assign Batches in Supply Assignment (ARun) Show values
berty Type of MRP Area Show values
lvorm_mara Flag Material for Deletion at Client Level Show values
lvorm_marc Flag Material for Deletion at Plant Level Show values
attyp Material Category Show values
kzkfg Configurable Material Show values
kzeff Assign effectivity parameter values/ override change numbers Show values
kzkup Indicator: Material can be co-product Show values
apokz Indicator: Is material relevant for APO Show values
ppskz Indicator for Advanced Planning Show values
beskz Procurement Type Show values
sbdkz Dependent requirements ind. for individual and coll. reqmts Show values
miskz Mixed MRP indicator Show values
marc_ahdis MRP relevancy for dependent requirements Show values
mdma_ahdis MRP relevancy for dependent requirements Show values
vrmod Consumption mode Show values
plifzx Consider Planned Delivery Time of the MRP Area Show values
marc_shflg Safety time indicator (with or without safety time) Show values
mdma_shflg Safety time indicator (with or without safety time) Show values
qmatv Inspection Setup Exists for Material/Plant Show values
sauft Indicator: Repetitive Manufacturing Allowed Show values
perkz Period Indicator Show values
altsl Method for Selecting Alternative Bills of Material Show values
resal Re-explode BOM Show values
resdt Indicator: Reset Procurement Proposals Show values
adspc_spc Spare Part Class Code Show values
marc_sfty_stk_meth MRP Safety Stock Method Show values
mdma_sfty_stk_meth MRP Safety Stock Method Show values
Column Name Description Domain name
matnr Material Number MATNR
werks Plant WERKS
berid MRP Area BERID
t460a_def_u_sobsl null
t460a_def_b_sobsl null
sgt_rel Segmentation Relevant CHAR1
sgt_covs Segmentation Strategy SGT_COVS
fsh_var_group Variant Group CHAR2
fsh_calendar_group Calendar Group FSH_CALENDAR_GROUP
disst Low-Level Code DISST
cuobf Internal object number CUOBJ
mfrpn Manufacturer Part Number CHAR40
mmsta Plant-Specific Material Status MMSTA
maabc ABC Indicator MAABC
ekgrp Purchasing Group EKGRP
andec No. of decimal places for rounding ANDEC
kzaus null
disgr_marc MRP Group DISGR
marc_disgr MRP Group DISGR
marc_dispo MRP Controller DISPO
rwpro Range of coverage profile RWPRO
fhori Scheduling Margin Key for Floats FHORI
vint1 Consumption period: backward VRINT
vint2 Consumption period: forward VRINT
stdpd Configurable material MATNR
cuobv Internal object number of configurable material for planning CUOBJ
bearz Processing time DEC3_2
ruezt Setup and teardown time DEC3_2
tranz Interoperation time DEC3_2
webaz Goods receipt processing time in days DEC3
marc_plifz Planned Delivery Time in Days DEC3
mdma_plifz Planned Delivery Time in Days DEC3
dzeit In-house production time DEC3
wzeit Total replenishment lead time (in workdays) DEC3
marc_shzet Safety Time (in Workdays) NUMC2
mdma_shzet Safety Time (in Workdays) NUMC2
marc_shpro Period Profile for Safety Time SHPRO
cuobj Internal object number CUOBJ
resvp Period of adjustment for planned independent requirements RESVP
usequ Quota arrangement usage USEQU
marc_minbe null
mdma_minbe null
marc_eisbe null
mdma_eisbe null
marc_disls Lot Sizing Procedure within Materials Planning DISLS
marc_lagpr Storage Costs Percentage Code LAGPR
marc_ausss Assembly scrap in percent DEC3_2
mdma_ausss Assembly scrap in percent DEC3_2
marc_takzt Takt time DEC3
mdma_takzt Takt time DEC3
marc_rdprf Rounding Profile RDPRF
strgr Planning Strategy Group STRGR
marc_lgfsb Default storage location for external procurement LGORT
periv Fiscal Year Variant PERIV
marc_mrppp PPC Planning Calendar MRPPP
sfepr Repetitive Manufacturing Profile SFEPR
marc_fxhor Planning time fence FXHOR
mdma_fxhor Planning time fence FXHOR
marc_dismm MRP Type DISMM
marc_sobsl Special procurement type SOBSL
disfg null
fevor Production Supervisor FEVOR
marc_lgpro Issue Storage Location LGORT
picnum Supersession chain number PIC_PICNUM
imatn FFF class MATNR
plan_in_abap null
Master Data Relations Join Conditions
Material Group
  • Client
  • Material Group
  • PPH_DDL_MAT_CTRL_0.MANDT == T023.MANDT
  • PPH_DDL_MAT_CTRL_0.MATKL == T023.MATKL
MRP Group
  • Plant
  • MRP Group
  • MRP Group
  • Client
  • PPH_DDL_MAT_CTRL_0.WERKS == T438M.WERKS
  • PPH_DDL_MAT_CTRL_0.MDMA_DISGR == T438M.MTART
  • PPH_DDL_MAT_CTRL_0.MARC_DISGR == T438M.MTART
  • PPH_DDL_MAT_CTRL_0.MANDT == T438M.MANDT
Lot Sizing Procedure within Materials Planning
  • Lot Sizing Procedure within Materials Planning
  • Lot Sizing Procedure within Materials Planning
  • Client
  • PPH_DDL_MAT_CTRL_0.MARC_DISLS == T439A.DISLS
  • PPH_DDL_MAT_CTRL_0.MDMA_DISLS == T439A.DISLS
  • PPH_DDL_MAT_CTRL_0.MANDT == T439A.MANDT
MRP Type
  • MRP Type
  • MRP Type
  • Client
  • PPH_DDL_MAT_CTRL_0.MDMA_DISMM == T438A.DISMM
  • PPH_DDL_MAT_CTRL_0.MARC_DISMM == T438A.DISMM
  • PPH_DDL_MAT_CTRL_0.MANDT == T438A.MANDT
MRP Controller
  • MRP Controller
  • MRP Controller
  • Plant
  • Client
  • PPH_DDL_MAT_CTRL_0.MDMA_DISPO == T024D.DISPO
  • PPH_DDL_MAT_CTRL_0.MARC_DISPO == T024D.DISPO
  • PPH_DDL_MAT_CTRL_0.WERKS == T024D.WERKS
  • PPH_DDL_MAT_CTRL_0.MANDT == T024D.MANDT
Storage costs percentage
  • Storage Costs Percentage Code
  • Storage Costs Percentage Code
  • Plant
  • Client
  • PPH_DDL_MAT_CTRL_0.MARC_LAGPR == T439L.LAGPR
  • PPH_DDL_MAT_CTRL_0.MDMA_LAGPR == T439L.LAGPR
  • PPH_DDL_MAT_CTRL_0.WERKS == T439L.WERKS
  • PPH_DDL_MAT_CTRL_0.MANDT == T439L.MANDT
Default storage location for external procurement
  • Plant
  • MRP Area
  • Default storage location for external procurement
  • Default storage location for external procurement
  • Client
  • PPH_DDL_MAT_CTRL_0.WERKS == MDLG.WERKS
  • PPH_DDL_MAT_CTRL_0.BERID == MDLG.BERID
  • PPH_DDL_MAT_CTRL_0.MARC_LGFSB == MDLG.LGORT
  • PPH_DDL_MAT_CTRL_0.MDMA_LGFSB == MDLG.LGORT
  • PPH_DDL_MAT_CTRL_0.MANDT == MDLG.MANDT
Production storage location
  • Plant
  • MRP Area
  • Issue Storage Location
  • Issue Storage Location
  • Client
  • PPH_DDL_MAT_CTRL_0.WERKS == MDLG.WERKS
  • PPH_DDL_MAT_CTRL_0.BERID == MDLG.BERID
  • PPH_DDL_MAT_CTRL_0.MARC_LGPRO == MDLG.LGORT
  • PPH_DDL_MAT_CTRL_0.MDMA_LGPRO == MDLG.LGORT
  • PPH_DDL_MAT_CTRL_0.MANDT == MDLG.MANDT
PPC Planning Calendar
  • Plant
  • PPC Planning Calendar
  • PPC Planning Calendar
  • Client
  • PPH_DDL_MAT_CTRL_0.WERKS == T439G.WERKS
  • PPH_DDL_MAT_CTRL_0.MDMA_MRPPP == T439G.MRPPP
  • PPH_DDL_MAT_CTRL_0.MARC_MRPPP == T439G.MRPPP
  • PPH_DDL_MAT_CTRL_0.MANDT == T439G.MANDT
Rounding Profile
  • Rounding Profile
  • Rounding Profile
  • ?
  • ?
  • Client
  • PPH_DDL_MAT_CTRL_0.MDMA_RDPRF == RDPR.RDPRF
  • PPH_DDL_MAT_CTRL_0.MARC_RDPRF == RDPR.RDPRF
  • PPH_DDL_MAT_CTRL_0.[column in domain "RDZAE"] == RDPR.RDZAE
  • PPH_DDL_MAT_CTRL_0.[column in domain "WERKS_D"] == RDPR.WERKS
  • PPH_DDL_MAT_CTRL_0.MANDT == RDPR.MANDT
Period Profile for Safety Time
  • Plant
  • Client
  • Period Profile for Safety Time
  • Period Profile for Safety Time
  • PPH_DDL_MAT_CTRL_0.WERKS == T438V.WERKS
  • PPH_DDL_MAT_CTRL_0.MANDT == T438V.MANDT
  • PPH_DDL_MAT_CTRL_0.MARC_SHPRO == T438V.SHPRO
  • PPH_DDL_MAT_CTRL_0.MDMA_SHPRO == T438V.SHPRO
Special procurement type
  • Plant
  • Special procurement type
  • Special procurement type
  • ?
  • ?
  • Client
  • PPH_DDL_MAT_CTRL_0.WERKS == T460A.WERKS
  • PPH_DDL_MAT_CTRL_0.MARC_SOBSL == T460A.SOBSL
  • PPH_DDL_MAT_CTRL_0.MDMA_SOBSL == T460A.SOBSL
  • PPH_DDL_MAT_CTRL_0.T460A_DEF_B_SOBSL == T460A.SOBSL
  • PPH_DDL_MAT_CTRL_0.T460A_DEF_U_SOBSL == T460A.SOBSL
  • PPH_DDL_MAT_CTRL_0.MANDT == T460A.MANDT
Unit of Measure
  • Base Unit of Measure
  • Client
  • PPH_DDL_MAT_CTRL_0.MEINS == T006.MSEHI
  • PPH_DDL_MAT_CTRL_0.MANDT == T006.MANDT
Manufacturer Number
  • Client
  • Manufacturer number
  • PPH_DDL_MAT_CTRL_0.MANDT == LFA1.MANDT
  • PPH_DDL_MAT_CTRL_0.MFRNR == LFA1.LIFNR
Control Profile for Manufacturer Parts Processing
  • Mfr part profile
  • Client
  • PPH_DDL_MAT_CTRL_0.MPROF == TMPPF.MPROF
  • PPH_DDL_MAT_CTRL_0.MANDT == TMPPF.MANDT
Cross-Plant Material Status
  • Cross-Plant Material Status
  • Client
  • PPH_DDL_MAT_CTRL_0.MSTAE == T141.MMSTA
  • PPH_DDL_MAT_CTRL_0.MANDT == T141.MANDT
Material type
  • Material type
  • Client
  • PPH_DDL_MAT_CTRL_0.MTART == T134.MTART
  • PPH_DDL_MAT_CTRL_0.MANDT == T134.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • PPH_DDL_MAT_CTRL_0.SATNR == MARA.MATNR
  • PPH_DDL_MAT_CTRL_0.MANDT == MARA.MANDT
Segmentation Strategy
  • Segmentation Strategy
  • ?
  • Client
  • PPH_DDL_MAT_CTRL_0.SGT_COVSA == SGT_COVS_T.SGT_COVS
  • PPH_DDL_MAT_CTRL_0.[column in domain "WERKS_D"] == SGT_COVS_T.WERKS
  • PPH_DDL_MAT_CTRL_0.MANDT == SGT_COVS_T.MANDT
Segmentation Structure
  • Segmentation Structure
  • Client