PROD_PLNT_ADVPLN

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- I_PRODUCTWD I_PRODUCTPLANTADVPLANWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_PLNT_ADVPLN (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    PARENTDRAFTUUID,                 -- Key [/bobf/uuid]
    ROOTDRAFTUUID,                   -- Key [/bobf/uuid]
    PRODUCT,                         -- Product [productnumber]
    PLANT,                           -- Plant [werks_d]
    PRODUCTFOREDIT,                  -- Product [productnumber]
    PLANTFOREDIT,                    -- Plant [werks_d]
    LOCPRODGOODSRECEIPTPROCHOURS,    -- GR Processng Time [cmd_prd_good_rcpt_proc_time_n]
    LOCPRODGOODSRCPTPROCHOURSCALC,   -- GR Processng Time [cmd_prd_good_rcpt_proc_time]
    LOCPRODGOODSISSUEPROCHOURS,      -- GI Processng Time [cmd_prd_good_issue_proc_time_n]
    LOCPRODGOODSISSUEPROCHOURSCALC,  -- GI Processng Time [cmd_prd_good_issue_proc_time]
    LOCPRODSTORAGECOSTVALUE,         -- Prod.Stor. Costs [/sapapo/scost]
    REPLENISHMENTLEADTIMEDAYS,       -- Repl. Lead Time [/sapapo/reldt]
    PPPLANNINGPROCEDURE,             -- PP Plng Proced. [/sapapo/pps_planning_type]
    PRODNPLNGHEURISTIC,              -- Heuristic [/sapapo/prod_heur_id]
    PRODUCTPLANNINGPACKAGE,          -- Plan. Package [/sapapo/prod_heur_packid]
    SFTYSTKVIOLTNPNLTYCOSTVALUE,     -- Safety Stk Pen. [/sapapo/sspen]
    PRODUCTALERTRELEVANCECODE,       -- Product Alerts [/sapapo/get_alerts_for_prod]
    RESOURCENETWORKNAME,             -- Network name [/sapapo/resnet_netname]
    GRHANDLINGCAPACITYQUANTITY,      -- GR Handlg Cap. Cons. [/sapapo/snpconhap]
    GRHANDLINGCAPACITYUNIT,          -- UoM:HandlCap GR [/sapapo/hunit]
    GIHANDLINGCAPACITYQUANTITY,      -- GI Handlg Cap. Cons. [/sapapo/snpconhap_out]
    GIHANDLINGCAPACITYUNIT,          -- UoM:HandlCap GI [/sapapo/hunit_out]
    ISLOCDEPENDENTSHELFLIFEUSED,     -- Shelf Life(Loc) [/sapapo/shelf_life_loc_flag]
    SHELFLIFELOCDEPENDENT,           -- Loc. Shelf Life [cmd_prd_shelf_life_dur_l_n]
    SHELFLIFELOCDEPENDENTCALC,       -- Loc. Shelf Life [cmd_prd_shelf_life_dur_l]
    MATURATIONDURNLOCDEPENDENT,      -- Loc. Matur.Time [cmd_prd_maturity_dur_l_n]
    MATURATIONDURNLOCDEPENDENTCALC,  -- Loc. Matur.Time [cmd_prd_maturity_dur_l]
    RQDMINSHELFLIFELOCDEPDNT,        -- Min. Shelf Life [cmd_prd_shelf_life_req_min_l_n]
    RQDMINSHELFLIFELOCDEPDNTCALC,    -- Min. Shelf Life [cmd_prd_shelf_life_req_min_l]
    RQDMAXSHELFLIFELOCDEPDNT,        -- Max. Shelf Life [cmd_prd_shelf_life_req_max_l_n]
    RQDMAXSHELFLIFELOCDEPDNTCALC,    -- Max. Shelf Life [cmd_prd_shelf_life_req_max_l]
    LOTSIZEUNIT,                     -- Lot Size Unit [/sapapo/lsuom]
    REORDERDAYSSUPPLYINWORKDAYS,     -- Reorder DS [cmd_prd_reord_dur_n]
    REORDERDAYSSUPPLYINWORKDAYCALC,  -- Reorder DS [cmd_prd_reord_dur]
    TARGETDAYSSUPPLYINWORKDAYS,      -- Trgt Days' Sup. [cmd_prd_target_dur_n]
    TARGETDAYSSUPPLYINWORKDAYSCALC,  -- Trgt Days' Sup. [cmd_prd_target_dur]
    PLNGCALENDARPERDCLOTSIZING,      -- Per.LS Plng Cal [/sapapo/lot_tstrid]
    REQUIREMENTSTRATEGY,             -- Requirement Str. [/sapapo/stra1]
    ALERTTHLDFORDLYDRCPTDURNINHRS,   -- Pegg.AlertBackH [md_prod_dm_peg_past_alert_hrs]
    ALERTTHLDFORDLYDRCPTDURNINMINS,  -- Pegg.AlertBackM [md_prod_dm_peg_past_alert_mins]
    ALERTTHLDEARLYRCPTDURNINHRS,     -- Pegg.AlertBackH [md_prod_dm_peg_futur_alert_hrs]
    ALERTTHLDEARLYRCPTDURNINMINS,    -- Pegg.AlertBackM [md_prod_dm_peg_futur_alert_min]
    PEGGINGSTRATEGY,                 -- Peggng Strategy [/sapapo/peg_strategy]
    ISALERTSINPEGGINGAVOIDED,        -- Checkbox [xfeld]
    ISFIXEDPEGGINGFORPRODRETAINED,   -- Fixed Pegging [/sapapo/dm_fixpeg_prod_setting]
    BOMTYPEEXPLOSIONUSED,            -- Plan Explosion [/sapapo/whatbom]
    ISADVANCEDPLANNINGUSED,          -- Advanced Planning [ppskz]
    PRODUCTPLANNINGGROUP,            -- Planning Group [/sapapo/rrp_sel_group]
    ISTOTALQTYSTOCKELEMENT,          -- Entire Stock [/sapapo/ges_bst_use]
    ISTOTALQTYRECEIPTELEMENT,        -- Entire Receipt [/sapapo/ges_mng_use]
    MINPASSINGAMTCONTINUOUSPEGGING,  -- Min Passing Amt [/sapapo/min_pass_amount]
    CONVERSIONRULE,                  -- Conversion Rule [/sapapo/prof_exec_check_p]
    PRODUCTPRIORITY,                 -- Priority [/sapapo/prio]
    INTERACTIVESOURCINGPROFILE,      -- Profile [/sapapo/cdps_intsrc_prof]
    PRODUCTPROCUREMENTCOSTSVAL,      -- Procuremt Costs [/sapapo/proc_cost]
    GOODSRECEIPTHANDLINGCOST,        -- GR Costs [ndcostwe]
    GOODSISSUEHANDLINGCOST,          -- GI Costs [ndcostwa]
    CONSUMPTIONOFSTORAGECAPACITY,    -- Stor. Consumptn [/sapapo/snpconinp]
    CONSUMPTIONOFSTORAGECAPUNIT,     -- Unit of Meas. [/sapapo/unit]
    GIPOSTINGISSYNCHRONOUS,          -- Sync.GI Posting [/sapapo/ppc_gmsync]
    ADVANCEPLANNINGSCOPEVALUE,       -- Scp Limitation [/sapapo/matplsta_scope]
    ADVANCEPLANNINGSCOPEPROFILEID,   -- Scope Profile [/sapapo/scope_profile_id]
    MAXDAYSOFSUPPLYPENALTYAMOUNT,    -- Penalty MaxDoS [ppo_maxdos_penalty]
    MAXDAYSOFSUPPLYISACTIVE,         -- Is Max Dos Active [ppo_maxdos_flag]
    ADVNCDPLNGSFTYSTKMETH,           -- Safety Stock Method [/sapapo/msdp_sb_method]
    ADVNCDPLNGTGTSTKLVLMETH,         -- Targ.Stk Lvl Md [/sapapo/target_method]
    ADVNCDPLNGPERIODFACTORVALUE,     -- Period Factor [/sapapo/rrp_req_cover_type]
    PERIODFACTORISUSED,              -- Use Period Fac. [/sapapo/rrp_req_cover_flag]
    SFTYSTKMETHISAUTOMLYDTMND,       -- Checkbox [xfeld]
    TIMEDEPDNTSTKLVLPERDFACTORVAL,   -- Period Factor TDS [period_factor_tds]
    ADVNCDPLNGPPDSHORIZONINDAYS,     -- PP/DS Horizon [/sapapo/convh]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);