SAP ABAP Table V_OIJRDSEL3 (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | V_OIJRDSEL3 |
Table Relationship Diagram 
|
| Short Description | Generated Table for View |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | LOCID |
OIJ_LOCID | OIJ_LOCID | CHAR | 10 | 0 | Location ID | OIJLOC | |
| 3 | PMATNR |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 4 | ODINDO |
OIJ_ODINDO | XFELD | CHAR | 1 | 0 | OIL-TSW: Location is origin flag | ||
| 5 | ODINDD |
OIJ_ODINDD | XFELD | CHAR | 1 | 0 | OIL-TSW: Location destination flag | ||
| 6 | PWERK |
OIJ_PWERK | WERKS | CHAR | 4 | 0 | Plant for location Stock Projection and Replenishment Planng | T001W | |
| 7 | CHARG |
OIJ_CHARG | CHARG | CHAR | 10 | 0 | Batch / Valuation type | MCHB | |
| 8 | RDUOM |
OIJ_RDUOM | MEINS | UNIT | 3 | 0 | Stock Projection unit of measure (UoM) | T006 | |
| 9 | RDCONV |
OIJ_RDCONV | NUMC5 | NUMC | 5 | 0 | OIL-TSW: Stock Projection conversion factor | ||
| 10 | PERIOD |
OIJ_PERIOD | ANZTA | NUMC | 3 | 0 | OIL-TSW: Rolling period | ||
| 11 | PAST |
OIJ_PAST | ANZTA | NUMC | 3 | 0 | OIL-TSW: Number of days in the past | ||
| 12 | TOLPCT |
OIJ_BUTOL | DEC3_1 | DEC | 4 | 1 | Quantity tolerance under (%) | ||
| 13 | TOLABS |
OIJ_TOLABS | MENG13 | QUAN | 13 | 3 | Absolute tolerance qty under | ||
| 14 | PHY_INV_FLG |
OIJ_FLG | XFELD | CHAR | 1 | 0 | OIL-TSW: Flag indicating physical inventory input | ||
| 15 | PHY_INV |
OIJ_PHY_INV | MENG13V | QUAN | 13 | 3 | OIL-TSW: Phy inventory at loc.(from external source) | ||
| 16 | PHY_DATE |
OIJ_PHY_DATE | DATUM | DATS | 8 | 0 | OIL-TSW: Date for last physical inventory update | ||
| 17 | FCPAST |
OIJ_FCPAST | ANZTA | NUMC | 3 | 0 | OIL-TSW: History horizon for automated rack issue forecast | ||
| 18 | FCOFFSET |
OIJ_FCOFFSET | ANZTA | NUMC | 3 | 0 | OIL-TSW: Number of offset days in forecast calculation | ||
| 19 | FCTYPE |
OIJ_FCTYPE | OIJ_FCTYPE | CHAR | 4 | 0 | OIL-TSW: Rack issue forecast type | ||
| 20 | PHYTMS |
OIJ_PHYTMS | TSTAMP | NUMC | 14 | 0 | Timestamp for previous physical inventory update | ||
| 21 | SRCTYPE |
OIJ_SRCTYPE | OIJ_SRCTYPE | CHAR | 1 | 0 | OIL-TSW: Physical inventory type / source | OIJSRCTYPE | |
| 22 | FCHORIZ |
OIJ_FCHORIZ | OIJ_FCHORIZ | NUMC | 3 | 0 | Oil-TSW: Rack issue / Throughput forecast history horizon | ||
| 23 | RVP |
OIJ_RVP | DEC2_1 | DEC | 3 | 1 | RVP value | ||
| 24 | PLTYP |
OIJ_PLTYP | OIJ_PLTYP | CHAR | 3 | 0 | OIL-TSW: Planning type | ||
| 25 | CALFLG |
OIJ_CALFLG | OIJ_CALFLG | CHAR | 1 | 0 | OIL-TSW: Calendar use indicator | ||
| 26 | PLCAL |
OIJ_PLCAL | OIJ_PLCAL | CHAR | 3 | 0 | Planning calendar | ||
| 27 | MAXLOT |
OIJ_MAXLOT | MENG13 | QUAN | 13 | 3 | OIL-TSW: Planning maximum batch (lot) size | ||
| 28 | MINLOT |
OIJ_MINLOT | MENG13 | QUAN | 13 | 3 | OIL-TSW: Planning minimum batch (lot) size | ||
| 29 | INCLOT |
OIJ_INCLOT | MENG13 | QUAN | 13 | 3 | OIL-TSW: Planning incremental batch (lot) size - rounding | ||
| 30 | MAXINV |
OIJ_MAXINV | MENG13V | QUAN | 13 | 3 | OIL-TSW: Planning maximum inventory level | ||
| 31 | TARGET |
OIJ_TGTINV | MENG13V | QUAN | 13 | 3 | OIL-TSW: Planning target inventory level | ||
| 32 | REORDER |
OIJ_REORD | MENG13V | QUAN | 13 | 3 | OIL-TSW: Planning reorder point inventory level | ||
| 33 | SAFETY |
OIJ_SFTINV | MENG13V | QUAN | 13 | 3 | OIl-TSW: Planning safety inventory level | ||
| 34 | UNPUMP |
OIJ_UNPUMP | MENG13V | QUAN | 13 | 3 | OIL-TSW: Unpumpable (blocked) inventory | ||
| 35 | MININV |
OIJ_MININV | MENG13V | QUAN | 13 | 3 | OIL-TSW: Planning minimum inventory level | ||
| 36 | STSYST |
OIJ_STSYST | OIJ_TSYST | CHAR | 10 | 0 | OIL-TSW: Planning source transport system | OIJTS | |
| 37 | OFFPER |
OIJ_OFFPER | OIJ_PERIOD | QUAN | 3 | 0 | OIL-TSW: Planning source offset period | ||
| 38 | OFFUOM |
OIJ_OFFUOM | MEINS | UNIT | 3 | 0 | OIL-TSW: Planning source offset period UoM | T006 | |
| 39 | FCCAL |
OIJ_FCCAL | WFCID | CHAR | 2 | 0 | OIL-TSW: Stock Projection rack forecast calendar | TFACD | |
| 40 | FCPRF |
OIJ_FCPRF | OIJ_FCPRF | CHAR | 3 | 0 | OIL-TSW: Stock Projection rack forecast profile | OIJFCPRF | |
| 41 | TANKUPD |
OIJ_TANKUPD | XFELD | CHAR | 1 | 0 | Flag to indicate update by tank interface file | ||
| 42 | SFTLVL |
OIJ_SFTLVL | MENG13V | QUAN | 13 | 3 | Preferred Safety Level | ||
| 43 | HRLVL |
OIJ_HRLVL | MENG13V | QUAN | 13 | 3 | Preferred Headroom Level | ||
| 44 | PPTYP |
OIJ_PPTYP | OIJ_PPTYP | CHAR | 4 | 0 | Production planning type | ||
| 45 | BALANCE |
OIJ_BALANCE | XFELD | CHAR | 1 | 0 | Indicator to supress balance quantities in Stock Projection | ||
| 46 | RDACT |
OIJ_RDACT | XFELD | CHAR | 1 | 0 | Stock Projection activation indicator | ||
| 47 | TSYST |
OIJ_TSYST | OIJ_TSYST | CHAR | 10 | 0 | Transport system | OIJTS |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | V_OIJRDSEL3 | CHARG |  MCHB |
CHARG |
|||
| 2 | V_OIJRDSEL3 | FCCAL | TFACD |
IDENT |
1 | CN | |
| 3 | V_OIJRDSEL3 | FCPRF | OIJFCPRF |
FCPRF |
|||
| 4 | V_OIJRDSEL3 | LOCID | OIJLOC |
LOCID |
KEY | 1 | CN |
| 5 | V_OIJRDSEL3 | MANDT | T000 |
MANDT |
|||
| 6 | V_OIJRDSEL3 | OFFUOM | T006 |
MSEHI |
REF | 1 | CN |
| 7 | V_OIJRDSEL3 | PMATNR | MARA |
MATNR |
KEY | 1 | CN |
| 8 | V_OIJRDSEL3 | PWERK | T001W |
WERKS |
REF | 1 | CN |
| 9 | V_OIJRDSEL3 | RDUOM | T006 |
MSEHI |
REF | 1 | CN |
| 10 | V_OIJRDSEL3 | SRCTYPE | OIJSRCTYPE |
SRCTYPE |
KEY | 1 | CN |
| 11 | V_OIJRDSEL3 | STSYST | OIJTS |
TSYST |
REF | 1 | CN |
| 12 | V_OIJRDSEL3 | TSYST | OIJTS |
TSYST |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20091125 |
| SAP Release Created in |
