PROP

Transparent Table Application Table
54 Fields 4 CDS Views

Forecast Parameters

PROP is an SAP database table in S/4HANA. Forecast Parameters. It contains 54 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ProdPlntFcstParameters view inner BASIC Basic view for Forecast Parameters
PPH_E_PROW view inner
rrp_e_FcRlt view right_outer RRP: Select Forecast Values for RLT
rrp_e_FcTrc view right_outer RRP: Select Forecast Values for TRC

Fields (54)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pnum1 PNUM1 Pointer param
KEY hsnum HSNUM History number
KEY versp VERSP Version
pnum2 PNUM2 Results pointer
propr PROPR Forecast Prof.
modaw MODAW Model selection
modav MODAV Model slct pro.
kzpar KZPAR Parameter optim
opgra OPGRA Optimiz.level
kzini KZINI Initialization
prmod PRMOD Forecast model
alpha ALPHA Alpha factor
beta1 BETA1 Beta factor
gamma GAMMA Gamma factor
delta DELTA Delta factor
epsil EPSIL Epsilon factor
siggr SIGGR Tracking limit
prdat PRDAT Last forecast
peran PERAN Hist. periods
perin PERIN Init. periods
perio PERIO Periods/season
perex PEREX Per. ex-post
anzpr ANZPR Fcst periods
fimon FIMON Fixed periods
gwert GWERT Basic value
gwer1 GWER2 BasicValue2.Ord
gwer2 GWER2 BasicValue2.Ord
vmgwe VMGWE Previous period
vmgw1 VMGW2 BVal 2 ord. PP
vmgw2 VMGW2 BVal 2 ord. PP
twert TWERT Trend value
vmtwe VMTWE Previous period
prmad PRMAD Mean absol. dev
vmmad VMMAD Previous period
fsumm FSUMM Error total
vmfsu VMFSU Previous period
gewgr GEWGR Weighting group
thkof THKOF Theil coeffic.
ausna AUSNA Exceptions
proab PROAB Forecast flow
vbkez VBKEZ Use consumption
statu VSSTA Status
vetxt VETXT Version descr.
prwug PRWUG Lower limit
prwog PRWOG Upper Limit
prros PRROS Sale rate
prkum PRKUM Cum.forec.res.
przgf PRZGF Pointer:Factor
aktpe AKTPE Current period
fausr FAUSR Outlier corr.
sigma SIGMX Sigma factor
flgexc FLGEXC Outliers
flgcor FLGCOR Corrected values

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.

-- Forecast Parameters
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROP (
    MANDT,   -- Client [MANDT]
    PNUM1,   -- Pointer param [PNUM1]
    HSNUM,   -- History number [HSNUM]
    VERSP,   -- Version [VERSP]
    PNUM2,   -- Results pointer [PNUM2]
    PROPR,   -- Forecast Prof. [PROPR]
    MODAW,   -- Model selection [MODAW]
    MODAV,   -- Model slct pro. [MODAV]
    KZPAR,   -- Parameter optim [KZPAR]
    OPGRA,   -- Optimiz.level [OPGRA]
    KZINI,   -- Initialization [KZINI]
    PRMOD,   -- Forecast model [PRMOD]
    ALPHA,   -- Alpha factor [ALPHA]
    BETA1,   -- Beta factor [BETA1]
    GAMMA,   -- Gamma factor [GAMMA]
    DELTA,   -- Delta factor [DELTA]
    EPSIL,   -- Epsilon factor [EPSIL]
    SIGGR,   -- Tracking limit [SIGGR]
    PRDAT,   -- Last forecast [PRDAT]
    PERAN,   -- Hist. periods [PERAN]
    PERIN,   -- Init. periods [PERIN]
    PERIO,   -- Periods/season [PERIO]
    PEREX,   -- Per. ex-post [PEREX]
    ANZPR,   -- Fcst periods [ANZPR]
    FIMON,   -- Fixed periods [FIMON]
    GWERT,   -- Basic value [GWERT]
    GWER1,   -- BasicValue2.Ord [GWER2]
    GWER2,   -- BasicValue2.Ord [GWER2]
    VMGWE,   -- Previous period [VMGWE]
    VMGW1,   -- BVal 2 ord. PP [VMGW2]
    VMGW2,   -- BVal 2 ord. PP [VMGW2]
    TWERT,   -- Trend value [TWERT]
    VMTWE,   -- Previous period [VMTWE]
    PRMAD,   -- Mean absol. dev [PRMAD]
    VMMAD,   -- Previous period [VMMAD]
    FSUMM,   -- Error total [FSUMM]
    VMFSU,   -- Previous period [VMFSU]
    GEWGR,   -- Weighting group [GEWGR]
    THKOF,   -- Theil coeffic. [THKOF]
    AUSNA,   -- Exceptions [AUSNA]
    PROAB,   -- Forecast flow [PROAB]
    VBKEZ,   -- Use consumption [VBKEZ]
    STATU,   -- Status [VSSTA]
    VETXT,   -- Version descr. [VETXT]
    PRWUG,   -- Lower limit [PRWUG]
    PRWOG,   -- Upper Limit [PRWOG]
    PRROS,   -- Sale rate [PRROS]
    PRKUM,   -- Cum.forec.res. [PRKUM]
    PRZGF,   -- Pointer:Factor [PRZGF]
    AKTPE,   -- Current period [AKTPE]
    FAUSR,   -- Outlier corr. [FAUSR]
    SIGMA,   -- Sigma factor [SIGMX]
    FLGEXC,  -- Outliers [FLGEXC]
    FLGCOR,  -- Corrected values [FLGCOR]
    PRIMARY KEY (MANDT, PNUM1, HSNUM, VERSP)
);

Learn More