SAP ABAP Table OIJLOCMAT (OIL-TSW: Location Rundown/Planning material table)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
⤷ OIJ (Package) TSW Traders and Schedulers Workbench
⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
⤷ OIJ (Package) TSW Traders and Schedulers Workbench
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIJLOCMAT | Table Relationship Diagram |
Short Description | OIL-TSW: Location Rundown/Planning material table |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | LOCNAME | OIJ_LOCNAM | OIJ_LOCNAM | CHAR | 60 | 0 | Location name (used by system owner) | ||
5 | PMATNAME | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
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 | .INCLUDE | 0 | 0 | Rundown header material structure | |||||
9 | RDUOM | OIJ_RDUOM | MEINS | UNIT | 3 | 0 | Stock Projection unit of measure (UoM) | T006 | |
10 | RDCONV | OIJ_RDCONV | NUMC5 | NUMC | 5 | 0 | OIL-TSW: Stock Projection conversion factor | ||
11 | PERIOD | OIJ_PERIOD | ANZTA | NUMC | 3 | 0 | OIL-TSW: Rolling period | ||
12 | PAST | OIJ_PAST | ANZTA | NUMC | 3 | 0 | OIL-TSW: Number of days in the past | ||
13 | TOLPCT | OIJ_BUTOL | DEC3_1 | DEC | 4 | 1 | Quantity tolerance under (%) | ||
14 | TOLABS | OIJ_TOLABS | MENG13 | QUAN | 13 | 3 | Absolute tolerance qty under | ||
15 | PASTDATA | OIJ_SFPAST | ANZTA | NUMC | 3 | 0 | OIL-TSW: No. of days in past for safety stock calculation | ||
16 | PHY_INV_FLG | OIJ_FLG | XFELD | CHAR | 1 | 0 | OIL-TSW: Flag indicating physical inventory input | ||
17 | PHY_INV | OIJ_PHY_INV | MENG13V | QUAN | 13 | 3 | OIL-TSW: Phy inventory at loc.(from external source) | ||
18 | PHY_DATE | OIJ_PHY_DATE | DATUM | DATS | 8 | 0 | OIL-TSW: Date for last physical inventory update | ||
19 | FCPAST | OIJ_FCPAST | ANZTA | NUMC | 3 | 0 | OIL-TSW: History horizon for automated rack issue forecast | ||
20 | FCOFFSET | OIJ_FCOFFSET | ANZTA | NUMC | 3 | 0 | OIL-TSW: Number of offset days in forecast calculation | ||
21 | FCTYPE | OIJ_FCTYPE | OIJ_FCTYPE | CHAR | 4 | 0 | OIL-TSW: Rack issue forecast type | ||
22 | PHYTMS | OIJ_PHYTMS | TSTAMP | NUMC | 14 | 0 | Timestamp for previous physical inventory update | ||
23 | SRCTYPE | OIJ_SRCTYPE | OIJ_SRCTYPE | CHAR | 1 | 0 | OIL-TSW: Physical inventory type / source | OIJSRCTYPE | |
24 | FCHORIZ | OIJ_FCHORIZ | OIJ_FCHORIZ | NUMC | 3 | 0 | Oil-TSW: Rack issue / Throughput forecast history horizon | ||
25 | RVP | OIJ_RVP | DEC2_1 | DEC | 3 | 1 | RVP value | ||
26 | .INCLUDE | 0 | 0 | Planning data sub-structure | |||||
27 | PLTYP | OIJ_PLTYP | OIJ_PLTYP | CHAR | 3 | 0 | OIL-TSW: Planning type | ||
28 | CALFLG | OIJ_CALFLG | OIJ_CALFLG | CHAR | 1 | 0 | OIL-TSW: Calendar use indicator | ||
29 | PLCAL | OIJ_PLCAL | OIJ_PLCAL | CHAR | 3 | 0 | Planning calendar | * | |
30 | COVER | OIJ_COVER | OIJ_PERIOD | QUAN | 3 | 0 | OIL-TSW: Safety stock coverage period (in plan period UoM) | ||
31 | PLHOZ | OIJ_PLHOZ | OIJ_PERIOD | QUAN | 3 | 0 | OIL-TSW: Planning horizon | ||
32 | DATUOM | OIJ_DATUOM | MEINS | UNIT | 3 | 0 | OIL-TSW: Planning period UoM | T006 | |
33 | PTSYST | OIJ_PTSYST | OIJ_TSYST | CHAR | 10 | 0 | OIL-TSW: Planning transport system | OIJTS | |
34 | PLUOM | OIJ_PLUOM | MEINS | UNIT | 3 | 0 | OIL-TSW: Planning UoM | T006 | |
35 | CYCLE | OIJ_CYCPER | OIJ_PERIOD | QUAN | 3 | 0 | OIL-TSW: Planning cycle period | ||
36 | CYCUOM | OIJ_CYCUOM | MEINS | UNIT | 3 | 0 | OIL-TSW: Cycle period UoM | T006 | |
37 | MAXLOT | OIJ_MAXLOT | MENG13 | QUAN | 13 | 3 | OIL-TSW: Planning maximum batch (lot) size | ||
38 | MINLOT | OIJ_MINLOT | MENG13 | QUAN | 13 | 3 | OIL-TSW: Planning minimum batch (lot) size | ||
39 | INCLOT | OIJ_INCLOT | MENG13 | QUAN | 13 | 3 | OIL-TSW: Planning incremental batch (lot) size - rounding | ||
40 | INVUOM | OIJ_INVUOM | MEINS | UNIT | 3 | 0 | OIL-TSW: Planning inventory UoM | T006 | |
41 | MAXINV | OIJ_MAXINV | MENG13V | QUAN | 13 | 3 | OIL-TSW: Planning maximum inventory level | ||
42 | TARGET | OIJ_TGTINV | MENG13V | QUAN | 13 | 3 | OIL-TSW: Planning target inventory level | ||
43 | REORDER | OIJ_REORD | MENG13V | QUAN | 13 | 3 | OIL-TSW: Planning reorder point inventory level | ||
44 | SAFETY | OIJ_SFTINV | MENG13V | QUAN | 13 | 3 | OIl-TSW: Planning safety inventory level | ||
45 | UNPUMP | OIJ_UNPUMP | MENG13V | QUAN | 13 | 3 | OIL-TSW: Unpumpable (blocked) inventory | ||
46 | MININV | OIJ_MININV | MENG13V | QUAN | 13 | 3 | OIL-TSW: Planning minimum inventory level | ||
47 | STSYST | OIJ_STSYST | OIJ_TSYST | CHAR | 10 | 0 | OIL-TSW: Planning source transport system | OIJTS | |
48 | SLOCID | OIJ_SLOCID | OIJ_LOCID | CHAR | 10 | 0 | OIL-TSW: Planning source location ID | OIJLOC | |
49 | SPART | OIJ_SPART | OIJ_PARTNR | CHAR | 10 | 0 | OIl-TSW: Planning source partner (supplier) | ||
50 | SPOBJ | OIJ_SPOBJ | CHAR2 | CHAR | 2 | 0 | OIL-TSW: Planning source partner object type (vend/plant) | ||
51 | OFFPER | OIJ_OFFPER | OIJ_PERIOD | QUAN | 3 | 0 | OIL-TSW: Planning source offset period | ||
52 | OFFUOM | OIJ_OFFUOM | MEINS | UNIT | 3 | 0 | OIL-TSW: Planning source offset period UoM | T006 | |
53 | RADIONOSRC | OIJ_RADNSC | XFELD | CHAR | 1 | 0 | OIL-TSW: Radio button - no planning source | ||
54 | RADIOTSSRC | OIJ_RADTS | XFELD | CHAR | 1 | 0 | OIL-TSW: Radio button for TS sourcing | ||
55 | RADIOLOCSC | OIJ_RADLOC | XFELD | CHAR | 1 | 0 | OIL-TSW: Radio button for TSW location sourcing | ||
56 | PLANAMPEL | OIJ_PAMPEL | TEXT80 | CHAR | 80 | 0 | OIL-TSW: Traffic light indicating presence of plan details | ||
57 | PLANFLAG | OIJ_PLFLAG | XFELD | CHAR | 1 | 0 | OIL-TSW: Planning run flag (X = plan run done since RD) | ||
58 | SCFLAG | OIJ_SCFLAG | XFELD | CHAR | 1 | 0 | OIL_TSW : Source object planning run flag | ||
59 | SERVICE | OIJ_SRVC | DEC3 | DEC | 3 | 0 | OIL-TSW: Safety stock service level | ||
60 | COVPROF | OIJ_COVPRF | OIJ_COVPRF | CHAR | 3 | 0 | OIL-TSW: Safety stock coverage profile | OIJCOV | |
61 | CALPROF | OIJ_CALPRF | OIJ_CALPRF | CHAR | 3 | 0 | OIL-TSW: Safety stock calendar usage profile | OIJSCAL | |
62 | FACTORY | OIJ_FACTRY | WFCID | CHAR | 2 | 0 | OIL-TSW: Factory calendar ID | TFACD | |
63 | SFTTYPE | OIJ_SFTTYP | OIJ_SFTTYP | CHAR | 3 | 0 | OIL-TSW: Safety stock calculation type | OIJSFTYP | |
64 | HISTHOZ | OIJ_HISTHZ | ANZTA | NUMC | 3 | 0 | OIL-TSW: Safety stock history horizon | ||
65 | TSERVICE | OIJ_TSRVC | DEC3 | DEC | 3 | 0 | OIL-TSW: Target stock service level | ||
66 | TCOVPROF | OIJ_TCOVPRF | OIJ_TCOVPRF | CHAR | 3 | 0 | OIL-TSW: Target stock coverage profile | ||
67 | TCALPROF | OIJ_TCALPRF | OIJ_TCALPRF | CHAR | 3 | 0 | OIL-TSW: Target stock calendar usage profile | ||
68 | TFACTORY | OIJ_TFACTRY | WFCID | CHAR | 2 | 0 | OIL-TSW: Factory calendar ID for Target stock calculation | * | |
69 | TGTTYPE | OIJ_TGTTYP | OIJ_TGTTYP | CHAR | 3 | 0 | OIL-TSW: Target stock calculation type | OIJTGTYP | |
70 | THISTHOZ | OIJ_THISTHZ | ANZTA | NUMC | 3 | 0 | OIL-TSW: Target stock history horizon | ||
71 | FCCAL | OIJ_FCCAL | WFCID | CHAR | 2 | 0 | OIL-TSW: Stock Projection rack forecast calendar | TFACD | |
72 | FCPRF | OIJ_FCPRF | OIJ_FCPRF | CHAR | 3 | 0 | OIL-TSW: Stock Projection rack forecast profile | OIJFCPRF | |
73 | TANKUPD | OIJ_TANKUPD | XFELD | CHAR | 1 | 0 | Flag to indicate update by tank interface file | ||
74 | SFTLVL | OIJ_SFTLVL | MENG13V | QUAN | 13 | 3 | Preferred Safety Level | ||
75 | HRLVL | OIJ_HRLVL | MENG13V | QUAN | 13 | 3 | Preferred Headroom Level | ||
76 | SFTTDIND | OIJ_SFTTDIND | XFELD | CHAR | 1 | 0 | Calculate time-dependent safety stock | ||
77 | TGTTDIND | OIJ_TGTTDIND | XFELD | CHAR | 1 | 0 | Calculate time-dependent target stock | ||
78 | PPTYP | OIJ_PPTYP | OIJ_PPTYP | CHAR | 4 | 0 | Production planning type | ||
79 | BALANCE | OIJ_BALANCE | XFELD | CHAR | 1 | 0 | Indicator to supress balance quantities in Stock Projection | ||
80 | .INCLUDE | 0 | 0 | OIL-TSW: Structure for production version handling | |||||
81 | PVFLAG | OIJ_PVFLAG | XFELD | CHAR | 1 | 0 | OIL-TSW: Flag indicating that PV use is active | ||
82 | VERID | OIJ_VERID | VERID | CHAR | 4 | 0 | OIL-TSW: Version ID currently assigned | MKAL | |
83 | TODAT | OIJ_TDATE | DATUM | DATS | 8 | 0 | OIL-TSW: To date of active PV | ||
84 | FROMDAT | OIJ_FDATE | DATUM | DATS | 8 | 0 | OIL-TSW: From date of active PV | ||
85 | BOMALT | OIJ_BOMALT | ALTNR | CHAR | 2 | 0 | OIL-TSW: Alternative BOM | ||
86 | BOMUSE | OIJ_BOMUSE | STLAN | CHAR | 1 | 0 | OIL-TSW: BOM use indicator | T416 | |
87 | BOMMAT | OIJ_BOMMAT | MATNR | CHAR | 18 | 0 | OIL-TSW: BOM material assigned | MARA | |
88 | .INCLUDE | 0 | 0 | OIL-TSW: Standard status field set (TSW) | |||||
89 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
90 | ERZEIT | OI0_ERTIM | UZEIT | TIMS | 6 | 0 | Time of creation | ||
91 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
92 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
93 | AEZEIT | OI0_AETIM | UZEIT | TIMS | 6 | 0 | Time of day the record was changed | ||
94 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
95 | BLOIND | OIJ_BLOIND | XFELD | CHAR | 1 | 0 | Blocking indicator | ||
96 | DELIND | OIJ_DELIND | XFELD | CHAR | 1 | 0 | Deletion indicator | ||
97 | TCONS | OIJ_TCONS | XFELD | CHAR | 1 | 0 | Indicator for location/material time dependent data | ||
98 | .INCLUDE | 0 | 0 | TSW Scheduling Defaults | |||||
99 | AUTOCONFIRM | OIJ_AUTOCONF | XFELD | CHAR | 1 | 0 | Automatic confirmation Flag | ||
100 | .INCLUDE | 0 | 0 | IS-Oil/TSW: Substructure for consumption mode data | |||||
101 | VRMOD | VRMOD | VRMOD | CHAR | 1 | 0 | Consumption mode | ||
102 | VINT1 | VINT1 | VRINT | NUMC | 3 | 0 | Consumption period: backward | ||
103 | VINT2 | VINT2 | VRINT | NUMC | 3 | 0 | Consumption period: forward | ||
104 | DEFSITYP | OIJ_DEFSITYP | OIJ_SITYP | CHAR | 2 | 0 | Default schedule type | TOIJ_EL_SITYPES | |
105 | DEFDOCIND | OIJ_DOCIND | OIJ_DOCIND | CHAR | 1 | 0 | Reference document indicator (PSX) | ||
106 | .INCLUDE | 0 | 0 | Location Balancing sub-structure in OIJLOCMAT | |||||
107 | LBUOM | OIJ_LBUOM | MEINS | UNIT | 3 | 0 | Location Balancing UOM | * |
Foreign Keys
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in |