| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TSWACT | OIL-TSW: TSW is active | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_TSWACT | Allow NULL? |
| 3 | PLSQCH | TSW: Flag to indicate changes in planning rel. data | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_PLSQCH | Allow NULL? |
| 4 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 5 | ERZEIT | Time of creation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OI0_ERTIM | Allow NULL? |
| 6 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 7 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 8 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OI0_AETIM | Allow NULL? |
| 9 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 10 | BLOIND | Blocking indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_BLOIND | Allow NULL? |
| 11 | DELIND | Deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_DELIND | Allow NULL? |
| 12 | CLSHIP | OIL TSW : Automatically close shipment flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_CLSHIP | Allow NULL? |
| 13 | RDREAL | Real-time Stock Projection indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_REALTIME | Allow NULL? |
| 14 | EXTDET | External Details | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_EXTDET | Allow NULL? |
| 15 | RDLOGIC | Stock Projection calculation logic identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDLOGIC | Allow NULL? |
| 16 | RDFCL | OIL-TSW: Corrective Rack forecast issue logic indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDFCL | Allow NULL? |
| 17 | RDPAST | Stock Projection Worksheet past days' inventory indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDPAST | Allow NULL? |
| 18 | RDNOMDAT | Nomination Stock Projection date indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDNOMDAT | Allow NULL? |
| 19 | RDDISAG | Stock Projection disaggregation specifier | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDDISAG | Allow NULL? |
| 20 | SCHEDREL | OIL-TSW: Scheduling relevance check flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_SCHEDREL | Allow NULL? |
| 21 | LOCCONTROL | OIL-TSW: Scheduling TSW Details location check flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_LOCCONTROL | Allow NULL? |
| 22 | NOMICU | OIL-TSW: Nomination item additional fields pop-up activation | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_NOMICU | Allow NULL? |
| 23 | NOMHCU | OIL-TSW: Nomination header add. fields pop-up activation | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_NOMHCU | Allow NULL? |
| 24 | MMOTCHK | OIL-TSW: Scheduling multiple MOT check | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_MMOTCHK | Allow NULL? |
| 25 | LOCMATCU | OIL-TSW: Location/material add. fields screen activation | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_LOCMATCU | Allow NULL? |
| 26 | TSMATCU | OIL-TSW: TransportSys/material add. fields screen activation | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_TSMATCU | Allow NULL? |
| 27 | TSWDCHK | TSW check in SD / MM document transactions | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_TSWDCHK | Allow NULL? |
| 28 | EXDETMOT | Transfer external details MoT to TSW multiple MoTs | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_EXDETMOT | Allow NULL? |
| 29 | NOMDATCHK | Check scheduled date against the TSW Details date range | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_NOMDATCHK | Allow NULL? |
| 30 | PLLOCFLAG | OIL TSW: Location valid on all assigned planning locations | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_PLANFLAG | Allow NULL? |
| 31 | RDPLMICO | Plus/minus combined in the SPW | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDPLMICO | Allow NULL? |
| 32 | RDMULT | All 'Multiple' items in the SPW drilled down/up | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDMULT | Allow NULL? |
| 33 | RDDECS | Number of decimals in the SPW | char | 1 | 0 | NUMC | (N'0') | Yes | | OIJ_RDDECS | Allow NULL? |
| 34 | RDPHYS | OIL-TSW: Physical inventory in both columns | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDPHYS | Allow NULL? |
| 35 | RDSTART | Stock Projection start day flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDSTART | Allow NULL? |
| 36 | HEEL | Heel field name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | OIJ_HEEL | Allow NULL? |
| 37 | RDAUTOWL | Generate Stock Projection worklist automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDAUTOWL | Allow NULL? |
| 38 | RDREP | Use 'Report into inventory' functionality | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDREP | Allow NULL? |
| 39 | CONSIDER_ROUTE | Consider Route | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_CONS_ROUTE | Allow NULL? |
| 40 | RDTREE | Stock Projection object selection is based on ALV tree | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_RDTREE | Allow NULL? |
| 41 | SPFLTVAL | Stock projection filter value for BADI | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | OIJ_SP_FLTVAL | OIJ_SPFLTVAL | Allow NULL? |
| 42 | SPDOCWHIF | Indicator: Ability to view/maintain documents in what-if pop | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_SPDOCWHIF | Allow NULL? |
| 43 | ETA_EV_TYPE | Event Type for ETA | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TOIGE | OIJ_ETA_EV_TYPE | Allow NULL? |
| 44 | PS_SITYP_DMD | Default Schedule type for Pegging to Stock of Demand Items | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TOIJ_EL_SITYPES | OIJ_PS_SITYP | Allow NULL? |
| 45 | PS_DOCIND_DMD | Reference document indicator for Pegging to Stock of Demand | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_PS_DOCIND | Allow NULL? |
| 46 | PS_SITYP_SUP | Default Schedule type for Pegging to Stock of Supply Avails | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TOIJ_EL_SITYPES | OIJ_PS_SITYP_SUP | Allow NULL? |
| 47 | PS_DOCIND_SUP | Reference document indicator for Pegging to Stock of Supply | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_PS_DOCIND_SUP | Allow NULL? |
| 48 | BFDEPTH | Bifurcation Depth | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | OIJ_BFDEPTH | |
| 49 | START_SEQ | Start of Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | OIJ_SESTART | Allow NULL? |
| 50 | INCRE_SEQ | Increment of Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | OIJ_SEINCRE | Allow NULL? |
| 51 | PRF_GRUPPE | Profile group (sort graphics profiles) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBCG | BCPRFGROUP | Allow NULL? |
| 52 | PRF_NAME | Name of graphics profile | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | TBCG | BCPRFNAME | Allow NULL? |
| 53 | PRF_INDEX | Profile index for the graphics profile | char | 1 | 0 | CHAR | (N' ') | Yes | TBCG | BCPRFINDEX | Allow NULL? |
| 54 | AMEND_MIN_QTY | Amendment quantity minimum | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_AMEND_MIN_QTY | |
| 55 | AMEND_MIN_QTY_U | Amendment minimum quantity UOM | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIJ_AMEND_MIN_QTY_U | Allow NULL? |
| 56 | LB_ROUTE_CHK_OBJ | LB Route check objects (Location / Transport system) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIJ_LB_ROUTE_CHK_OBJ | Allow NULL? |
| 57 | LB_ROUTE_PUB | LB Publish with / without route | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_LB_ROUTE_PUB | Allow NULL? |
| 58 | DOCCO | Documents in TSW-SPW Are Consumed by Goods Movements | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_DOCCO | Allow NULL? |
| 59 | SPAUTOFC | Generate Rack Forecast Automatically in Stock Projection | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_SPAUTOFC | Allow NULL? |
| 60 | UPD_REFDOC | Reference Document Update | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_UPD_SCHED_IND | Allow NULL? |
| 61 | GTS | Check on GTS (Global Trade Services) valid partners | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_GTS | Allow NULL? |
| 62 | METER_RECON_FLAG | TSW-TD meter reconciliation flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_METER_RECON_FLAG | Allow NULL? |
| 63 | LATELCK_3WP | 3WP LOCK STRATEGY | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_3WP_LOCKSTRATEGY | Allow NULL? |
