| 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 | F_PR | SSR - processing profile ID | nvarchar | 2 | 0 | CHAR | (N' ') | No | | OIRC_F_PR | Allow NULL? |
| 3 | PARFN | SSR - process business partner role | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | OIFBRF1 | OIRC_PARFN | Allow NULL? |
| 4 | BWTAR | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T149D | BWTAR_D | Allow NULL? |
| 5 | HANTYG | Handling type for transfer gain | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | OIH5 | OIH_HANTYG | Allow NULL? |
| 6 | HANTYL | Handling type for transfer loss | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | OIH5 | OIH_HANTYL | Allow NULL? |
| 7 | IND_MMD | SSR: Material movements defaults | char | 1 | 0 | CHAR | (N' ') | Yes | | OIRC_IND_MMD | Allow NULL? |
| 8 | LOGDOC_PBLIND | Location indicator for logistics document definition | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | OIRC_LD_PBLIND | OIRC_LOGDOC_PBLIND | Allow NULL? |
| 9 | LOGDOCDSCH | SSR Logistics document creation schedule | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | OIRC_LOGDOCSCH | Allow NULL? |
| 10 | LOGDOCSDEF | SSR Logistics document - schedule determination methods | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | OIRC_LOGDOCS_VAL | OIRC_LOGDOCS_BADI | Allow NULL? |
| 11 | TSTMP | Oil/Gas Test Temperature: Observed Density | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TSTMP | |
| 12 | TSTEH | Test Temperature Unit (Density): Measurement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TSTEH | Allow NULL? |
| 13 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MTTMP | |
| 14 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_MTTEH | Allow NULL? |
| 15 | THVAL | Heating value at test conditions (natural gas): observed | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_THVAL | |
| 16 | TDICHEH | Unit for densities of petroleum products and natural gas | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_DNEH | Allow NULL? |
| 17 | TDICH | Oil/Gas Test Density | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TDICH | |
| 18 | MTPRES | Oil/gas material pressure: observed quantity | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MTPRES | |
| 19 | MTPRESEH | Oil/gas material pressure unit: observed quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_MTPRESEH | Allow NULL? |
| 20 | TPRED | Oil/gas test pressure: metering (obs. density) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TPRED | |
| 21 | TPREDEH | Oil/Gas test press. unit: metering (density) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TPREDEH | Allow NULL? |
| 22 | TPRHV | Natural gas test pressure: combustion (obs. heating value ) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TPRHV | |
| 23 | TPRHVEH | Natural gas test pressure unit: combustion ( heating value ) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TPRHVEH | Allow NULL? |
| 24 | TTMPHV | Natural gas test temperature: combustion (obs. heat. value ) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TTMPHV | |
| 25 | TTMPHVEH | Natural gas test temp. unit: combustion (heating value) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TTMPHVEH | Allow NULL? |
| 26 | ATPRES | Atmospheric pressure of the air surrounding a product | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_ATPRES | |
| 27 | ATPRESEH | Atmospheric pressure unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_ATPRESEH | Allow NULL? |
| 28 | VAPRES | Vapor pressure of liquid petroleum gases (LPG) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_VAPRES | |
| 29 | VAPRESEH | Vapor pressure unit (LPG) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_VAPRESEH | Allow NULL? |
| 30 | THVALEH | Heating value unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_HVEH | Allow NULL? |
| 31 | MTCOMBTMP | Natural gas material combustion temp.: observed quantity | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MTCOMBTMP | |
| 32 | MTCOMBTEH | Natural gas material combustion temp. unit: obs. quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_MTCOMBTEH | Allow NULL? |
| 33 | MTCOMBPRES | Natural gas material combustion pressure: observed quantity | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MTCOMBPRES | |
| 34 | MTCOMBPRESEH | Natural gas material combustion pres. unit: oberved quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_MTCOMBPRESEH | Allow NULL? |
| 35 | TSTMPCAL | Natural gas: Calorimeter test temperature (density) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TSTMPCAL | |
| 36 | TSTMPCALEH | Natural gas: unit for calorimeter test temperature (density) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TSTMPCALEH | Allow NULL? |
| 37 | TPREDCAL | Natural gas: Calorimeter test pressure (density) | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_TPREDCAL | |
| 38 | TPREDCALEH | Natural gas: Unit for calorimeter test pressure (density) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_TPREDCALEH | Allow NULL? |
| 39 | HYDRO | Hydrometer Correction Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_HYDRO | Allow NULL? |
| 40 | ABIND | Air Bouyancy Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIB_ABIND | Allow NULL? |
| 41 | ABFAC | Air Bouyancy Factor | decimal | 3 | 1 | DEC | ((0)) | Yes | | OIB_ABFAC | |
| 42 | MCF | Meter correction factor | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_MCF1 | |
| 43 | BSWCN | BSW % | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BSWCN | |
| 44 | BSWCNEH | BSW % unit (volume %, mol %, mass % or proportion ) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIB_BSWCNEH | Allow NULL? |
| 45 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIB_HVCLS | Allow NULL? |
| 46 | HVCLS_TO | Heating value class (calorific value class) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIB_HVCLS | Allow NULL? |
| 47 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | GUID_32 | Allow NULL? |
| 48 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VRKME | Allow NULL? |
| 49 | METREV | SSR Meters: end period meter event type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | OIRC_GMME | OIRC_EPEVENT | Allow NULL? |
| 50 | E_TIMEF | SSR Meters - end period event time from | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OIRC_E_TIMEF | Allow NULL? |
| 51 | E_TIMET | SSR Meters - end period event time to | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OIRC_E_TIMET | Allow NULL? |
| 52 | MRDSCH | SSR Meters - Meter reading schedule | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | OIRC_MRDSCH | Allow NULL? |
| 53 | MRSDEF | SSR Meters - Schedule determination methods | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | OIRC_MS_VAL | OIRC_MS_BADI | Allow NULL? |
| 54 | MRCHK | SSR Meters - user check methods | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | OIRC_MC_VAL | OIRC_MC_BADI | Allow NULL? |
| 55 | PCTOL | SSR Meters - Price change tolerance (in minutes) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OIRC_PCTOL | Allow NULL? |
| 56 | DCTOL | SSR Meters - dealer change tolerance (in minutes) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OIRC_DCTOL | Allow NULL? |
| 57 | SOCEV | SSR Stocks - Default SOC event | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | OIISOCE | OIRC_SOCEV | Allow NULL? |
| 58 | IND_DRM | SSR Stocks: maintenance control for dip readings | char | 1 | 0 | CHAR | (N' ') | Yes | | OIRC_IND_DRM | Allow NULL? |
| 59 | DRSSCH | SSR Stocks - dip readings schedule | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | OIRC_DRDSCH | Allow NULL? |
| 60 | DRSDEF | SSR Stocks - schedule determination methods | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | OIRC_DS_VAL | OIRC_DS_BADI | Allow NULL? |
| 61 | PROWL | Warning loss percentage tolerance limit | decimal | 5 | 2 | DEC | ((0)) | Yes | | OIH_WLOSS | |
| 62 | PROEL | Error loss percentage tolerance limit | decimal | 5 | 2 | DEC | ((0)) | Yes | | OIH_ELOSS | |
| 63 | PROWG | Warning gain percentage tolerance limit | decimal | 5 | 2 | DEC | ((0)) | Yes | | OIH_WGAIN | |
| 64 | PROEG | Error gain percentage tolerance limit | decimal | 5 | 2 | DEC | ((0)) | Yes | | OIH_EGAIN | |
| 65 | TOLROUT | SSR Stocks - Tolerance quantity base methods | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | OIRC_DT_VAL | OIRC_DT_BADI | Allow NULL? |
| 66 | DRCHK | SSR stocks - user check methods | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | OIRC_DC_VAL | OIRC_DC_BADI | Allow NULL? |
| 67 | INVCAL | SSR Invoicing - invoicing calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | OIRI_INVCAL | Allow NULL? |
| 68 | INVMETH | Invoicing method for SSR Invoicing | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | OIRIMTYP | OIRI_INVMETH | Allow NULL? |
| 69 | EOMCAL | SSR Invoicing - calendar ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIRI_EOMCAL | Allow NULL? |
| 70 | COMMCAL | Calendar for monthly commission recalculation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | OIRI_COMMCAL | Allow NULL? |
| 71 | ZLSCH | Payment method | char | 1 | 0 | CHAR | (N' ') | Yes | T042Z | OIRI_ZLSCH | Allow NULL? |
| 72 | BVTYP | Partner bank type for invoicing items | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | OIRI_BVTYP | Allow NULL? |
| 73 | LOGDOCDSCH_DR | SSR Logistics document creation schedule (Dip reading) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | OIRC_LOGDOCSCH_DR | Allow NULL? |
| 74 | LOGDOCSDEF_DR | SSR Logistics document - schedule determination methods | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | OIRC_LOGDDR_VAL | OIRC_LOGDOCSDR_BADI | Allow NULL? |
| 75 | ROLLOVER_CHECK | SSR Meters - Rollover control methods | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | OIRC_RC_VAL | OIRC_RC_BADI | Allow NULL? |
| 76 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | OIRC_WST | OIRC_LIVAR | Allow NULL? |
| 77 | DIALOG_CHECK | SSR Meters - Dialog save methods | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | OIRC_MMR_VAL | OIRC_MMR_BADI | Allow NULL? |
