P_AdvncdPlngLocmapMdma

Join of /SAPAPO/LOCMAP, P_PRDSCM_MDMA_MDLV, MARC | view: PAPLOCMDMA | Extraction: Not supported | Component: Detailed Scheduling
Tables used: /SAPAPO/LOCMAP, /SAPAPO/MATPLSTA, MARC, MDFDDB, T460A, MDLV, MDMA
Column Name Description
locid Internal Location Number for Customer, Supplier, or Plant
loctype Location Type Show values
mandt FK Client
Column Name Description
Column Name Description
eisbe Safety Stock
minbe Reorder Point
mabst Maximum Stock Level
bstfe Fixed lot size
bstmi Minimum Lot Size
bstma Maximum Lot Size
bstrf Rounding value for purchase order quantity
scm_conhap Handling Capacity Consumption in Unit of Measure (Gds Rcpt)
scm_conhap_out Handling Capacity Consumption in Unit of Measure (Gds Issue)
scm_min_pass_amount Minimum Passing Amount for Continuous I/O Pegging
scm_safty_v Safety Stock for Virtual Child Location
scm_ppsaftystk Safety Stock at Parent Location
scm_ppsaftystk_v Safety Stock of Parent Location Virtual Child Location
scm_repsafty Repair Safety Stock
scm_repsafty_v Repair Safety Stock for Virtual Child Location
scm_reord_v Reorder Point for Virtual Child Location
scm_maxstock_v Maximum Stock Level for Virtual Child Locations
scm_coninp Consumption of Storage Capacity per Unit of Material
Column Name Description
mfxdt Manual firming date
Column Name Description
loctype Location Type Show values
beskz Procurement Type Show values
diber Indicator: MRP area exists Show values
vrmod Consumption mode Show values
sbdkz Dependent requirements ind. for individual and coll. reqmts Show values
miskz Mixed MRP indicator Show values
scm_fixpeg_prod_set Retain Fixed Pegging for Product on Document Change Show values
scm_get_alerts Alert Relevance of Product Show values
scm_peg_strategy Pegging strategy for dynamic pegging Show values
scm_peg_wo_alert_fst Avoid Alerts in Pegging Show values
scm_shelf_life_loc Use Location-Dependent Shelf Life of Product when Planning Show values
scm_whatbom Plan Explosion Show values
shflg Safety time indicator (with or without safety time) Show values
loekz Deletion Indicator Show values
scm_tpop Third-Party Order Processing Show values
scm_sft_lock Indicator for Safety Stock Override Show values
maxdos_flg Is Max Dos Active Show values
saftystock_method Method for Calculating Safety Stock Show values
Column Name Description Domain name
locno Location /SAPAPO/LOCNO
wzeit Total replenishment lead time (in workdays) DEC3
dzeit In-house production time DEC3
bearz Processing time DEC3_2
ruezt Setup and teardown time DEC3_2
tranz Interoperation time DEC3_2
lvorm null
cuobj Internal object number CUOBJ
webaz Goods receipt processing time in days DEC3
plifz Planned Delivery Time in Days DEC3
lgrad Service level DEC2_1
fxhor Planning time fence FXHOR
ausss Assembly scrap in percent DEC3_2
shzet Safety Time (in Workdays) NUMC2
vint1 Consumption period: backward VRINT
vint2 Consumption period: forward VRINT
uneto Underdelivery tolerance limit DEC2_1
ueeto Overdelivery tolerance limit DEC2_1
scm_GRPRT Goods Receipt Processing Time TSTRDURAG
scm_GIPRT Goods Issue Processing Time TSTRDURAG
scm_heur_id PPC Heuristics
scm_matlocid_guid22 Internal Number (UID) for Location Product /SAPAPO/MATLOCID
scm_maturity_dur Location-Dependent Maturation Time TSTRDURAG
scm_package_id Planning Package to Which Product Belongs
scm_peg_future_alert Alert threshold for early receipts TSTRDURAN
scm_peg_past_alert Alert threshold for delayed receipts TSTRDURAN
scm_reldt Replenishment Lead Time in Calendar Days /SAPAPO/DEC3
scm_reord_dur Reorder Days' Supply (in Workdays) TSTRDURAG
scm_res_net_name Resource Network CHAR40
scm_rrp_type PP Planning Procedure
scm_scost Product-Dependent Storage Costs /SAPAPO/DEC13
scm_shelf_life_dur Location-Dependent Shelf Life TSTRDURAG
scm_shlf_lfe_req_max Maximum Shelf Life Required: Location-Dependent TSTRDURAG
scm_shlf_lfe_req_min Minimum Shelf Life Required: Location-Dependent TSTRDURAG
scm_sspen Penalty Costs for Safety Stock Violation /SAPAPO/DEC13
scm_stra1 Requirement Strategy /SAPAPO/STRA1
scm_target_dur Target Days' Supply in Workdays TSTRDURAG
scm_tstrid Planning Calendar for Periodic Lot Sizing Procedure /SAPAPO/TSTRID
dummy_plnt_incl_eew_ps MD product plant extensible field element PLNT_INCL_EEW
scm_rrp_sel_group Planning Group
scm_intsrc_prof Profile for Interactive Sourcing
scm_prio Priority of Product /SAPAPO/PRIO
scm_profid Conversion Rule /SAPAPO/MAT_PROF_ID
scm_thruput_time Throughput Time TSTRDURAG
scm_scost_prcnt Cost Factor for Stockholding Costs /SAPAPO/PERCENT_SCOST
scm_proc_cost Procurement Costs for Product /SAPAPO/DEC13
scm_ndcostwe Goods Receiving Costs
scm_ndcostwa Goods Issue Costs
maxdos_pen Penalty exceeding time dependent Max Days' of Supply /SAPAPO/DEC13
Master Data Relations Join Conditions
MRP area ID
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == MDLV.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.BERID == MDLV.BERID
Source of Supply
  • Source of Supply
  • Client
  • P_ADVNCDPLNGLOCMAPMDMA.BWSCL == TMBW1.BWSCL
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == TMBW1.MANDT
MRP Group
  • MRP Group
  • Client
  • Plant
  • P_ADVNCDPLNGLOCMAPMDMA.DISGR == T438M.MTART
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == T438M.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.WERKS == T438M.WERKS
Lot Sizing Procedure within Materials Planning
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == T439A.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.DISLS == T439A.DISLS
MRP Controller
  • MRP Controller
  • Plant
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == T024D.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.DISPO == T024D.DISPO
  • P_ADVNCDPLNGLOCMAPMDMA.WERKS == T024D.WERKS
Purchasing Group
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == T024.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.EKGRP == T024.EKGRP
Scheduling margin key
  • Scheduling Margin Key for Floats
  • Client
  • Plant
  • P_ADVNCDPLNGLOCMAPMDMA.FHORI == T436A.FHORI
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == T436A.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.WERKS == T436A.WERKS
Production unit
  • Production unit
  • Client
  • P_ADVNCDPLNGLOCMAPMDMA.FRTME == T006.MSEHI
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == T006.MANDT
Loading group
  • Loading Group
  • Client
  • P_ADVNCDPLNGLOCMAPMDMA.LADGR == TLGR.LADGR
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == TLGR.MANDT
Value Table for ABC Indicator
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == TMABC.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.MAABC == TMABC.MAABC
Client P_ADVNCDPLNGLOCMAPMDMA.MANDT == T000.MANDT
Material Number
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == MARA.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.MATNR == MARA.MATNR
Checking Group for Availability Check
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == TMVF.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.MTVFP == TMVF.MTVFP
Rounding Profile
  • Rounding Profile
  • Client
  • ?
  • ?
  • P_ADVNCDPLNGLOCMAPMDMA.RDPRF == RDPR.RDPRF
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == RDPR.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.[column in domain "RDZAE"] == RDPR.RDZAE
  • P_ADVNCDPLNGLOCMAPMDMA.[column in domain "WERKS_D"] == RDPR.WERKS
Unit of Measure of Lot Size
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == T006.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.SCM_LSUOM == T006.MSEHI
Configurable material
  • Configurable material
  • Client
  • P_ADVNCDPLNGLOCMAPMDMA.STDPD == MARA.MATNR
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == MARA.MANDT
Planning Strategy Group
  • Planning Strategy Group
  • Client
  • P_ADVNCDPLNGLOCMAPMDMA.STRGR == T461P.STRGR
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == T461P.MANDT
Plant
  • P_ADVNCDPLNGLOCMAPMDMA.MANDT == T001W.MANDT
  • P_ADVNCDPLNGLOCMAPMDMA.WERKS == T001W.WERKS