1. Home
  2. Resources
  3. SAP Tables
  4. OIJ_SPTYPES - Stock Projection Types

SAP Table OIJ_SPTYPES

Stock Projection Types

OIJ_SPTYPES (Stock Projection Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIJ_SPTYPES to other SAP tables.

OIJ_SPTYPES table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SPTYPE Stock Projection type OIJ_SPTYPE CHAR 5 0
TIMEBUCKET Time Bucket OIJ_TIMEBUCKET OIJ_TIMEBUCKETS CHAR 5 0
SIM_SCHED_TYP Simulation Schedule category OIJ_SIM_SCHED_TYP CHAR 2 0
SB SP basic
SW SP by weeks
SM SP by months
SD Documents in SP
LB Location Balancing
DP APO Demand Planning Forecast - BASIC
DS APO Demand Planning Forecast - SROP by weeks
DY APO Demand Planning Forecast - YOP by months
PR BPD Partner receive
3P 3 Way Pegging
LO Location balancing Only
Z1 Customer reserve Z1
Z2 Customer reserve Z2
Z3 Customer reserve Z3
DEF_PERIOD Default rolling period OIJ_DEF_PERIOD NUMC 3 0
DEF_PAST Default number of days in the past OIJ_DEF_PAST NUMC 3 0
DP_SIM_SCHED_TYP Simulation type for APO DP Forecasts OIJ_DP_SIM_SCHED_TYP CHAR 2 0
SB SP basic
SW SP by weeks
SM SP by months
SD Documents in SP
LB Location Balancing
DP APO Demand Planning Forecast - BASIC
DS APO Demand Planning Forecast - SROP by weeks
DY APO Demand Planning Forecast - YOP by months
PR BPD Partner receive
3P 3 Way Pegging
LO Location balancing Only
Z1 Customer reserve Z1
Z2 Customer reserve Z2
Z3 Customer reserve Z3

OIJ_SPTYPES foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIJ_SPTYPES MANDT OIJ_SPTYPES MANDT T000 Clients MANDT
OIJ_SPTYPES TIMEBUCKET OIJ_SPTYPES MANDT OIJ_TIMEBUCKETS Time Buckets MANDT
OIJ_SPTYPES TIMEBUCKET OIJ_SPTYPES TIMEBUCKET OIJ_TIMEBUCKETS Time Buckets TIMEBUCKET