SAP ABAP Table ROIRC_MRUPLD (SSR Meters - Upload structure)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
⤷ OIR_C (Package) SSR Fuels processing (IS-Oil Sevice Station Retailing)
⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
⤷ OIR_C (Package) SSR Fuels processing (IS-Oil Sevice Station Retailing)
Basic Data
Table Category | INTTAB | Structure |
Structure | ROIRC_MRUPLD | Table Relationship Diagram |
Short Description | SSR Meters - Upload structure |
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 | RNBT | OIRA_RNBT | OIRA_RNBT | CHAR | 4 | 0 | Business type | OIRARNBT | |
2 | PBLNR | OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | * | |
3 | .INCLUDE | 0 | 0 | SSR Meters - Rejected records | |||||
4 | GMMNR | OII_GMMNR | OII_GMMNR | CHAR | 20 | 0 | GMM: Number of general meter | OIIGMMK | |
5 | ETMSTM | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
6 | METEV | OII_METEV | OII_METEV | CHAR | 2 | 0 | GMM: History record type | OIIGMMET | |
7 | .INCLUDE | 0 | 0 | SSR Meters - Meter history data | |||||
8 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
9 | MCOUNT | OIRC_MCOUNT | OII_MCOUNT | NUMC | 12 | 0 | GMM: Meter counter reading | ||
10 | CONFAC | OII_CONFAC | OII_CONFAC | DEC | 10 | 5 | GMM: Conversion factor | ||
11 | BASME | OII_BASME | MEINS | UNIT | 3 | 0 | Base UoM of material at event entry | * | |
12 | MENGE | OIRC_MENGE | MENG13V | QUAN | 13 | 3 | SSR Fuels - Sales flow quantity | ||
13 | XMCOUNT | OII_XMCOUN | OII_XMCOUN | NUMC | 12 | 0 | GMM: Previous meter reading | ||
14 | XMATNR | OII_XMATNR | MATNR | CHAR | 18 | 0 | GMM: Previous material assigned | * | |
15 | XCONFAC | OII_XCONFA | OII_CONFAC | DEC | 10 | 5 | GMM: Previous conversion factor | ||
16 | .INCLUDE | 0 | 0 | SSR Meters - Meter history data extension | |||||
17 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
18 | PARFN | OIF_PARFN | OIF_PARFN | CHAR | 4 | 0 | MRN business partner role / relation type | * | |
19 | FTMSTM | OIF_FTMSTM | OIF_TMSTM | NUMC | 14 | 0 | Start of partner function validity period: time stamp | ||
20 | PARPOS | OIF_PARPOS | OIF_PARPOS | NUMC | 3 | 0 | Partner counter | ||
21 | TTMSTM | OIF_TTMSTM | OIF_TMSTM | NUMC | 14 | 0 | End of partner function validity period - timestamp | ||
22 | METREV | OIRC_METREV | OIRC_METREV | CHAR | 2 | 0 | SSR: Meter event type | OIRC_GMME | |
23 | SEQNR | OII_GSEQNR | OII_SEQNR | CHAR | 10 | 0 | GMM: Sequence number of meter assigned to customer | ||
24 | PR_NUMBER | OIRC_PR_NUMBER | CHAR10 | CHAR | 10 | 0 | SSR Fuels - Process number | ||
25 | MRDATE | OIRC_DATUM | DATUM | DATS | 8 | 0 | SSR Fuels - local date | ||
26 | MRTIME | OIRC_UZEIT | UZEIT | TIMS | 6 | 0 | SSR Fuels - Local time | ||
27 | TIME_ZONE | OIRC_TIMEZONE | TZNZONE | CHAR | 6 | 0 | SSR Fuels - Service station time zone | * | |
28 | SERVTYP | OIRA_STYP | OIRA_STYP | CHAR | 4 | 0 | Service type | * | |
29 | EQUNR | OII_EQUNR | EQUNR | CHAR | 18 | 0 | Equipment number | EQUI | |
30 | KBETR | OIRC_KBETR | WERTV6 | CURR | 11 | 2 | SSR Meters - Actual price | ||
31 | KONWA | KONWA | WAERS | CUKY | 5 | 0 | Rate unit (currency or percentage) | TCURC | |
32 | KPEIN | KPEIN | KPEIN | DEC | 5 | 0 | Condition pricing unit | ||
33 | KMEIN | KMEIN | MEINS | UNIT | 3 | 0 | Condition Unit | T006 | |
34 | KWERT | KWERT | WERTV7 | CURR | 13 | 2 | Condition Value | ||
35 | XPARFN | OIF_PARFN | OIF_PARFN | CHAR | 4 | 0 | MRN business partner role / relation type | * | |
36 | XFTMSTM | OIF_FTMSTM | OIF_TMSTM | NUMC | 14 | 0 | Start of partner function validity period: time stamp | ||
37 | XPARPOS | OIF_PARPOS | OIF_PARPOS | NUMC | 3 | 0 | Partner counter | ||
38 | XTTMSTM | OIF_TTMSTM | OIF_TMSTM | NUMC | 14 | 0 | End of partner function validity period - timestamp | ||
39 | XSERVTYP | OIRC_XSTYP | OIRA_STYP | CHAR | 4 | 0 | SSR Meters - Previous service type | * | |
40 | XKBETR | OIRC_XKBETR | WERTV6 | CURR | 11 | 2 | SSR Meters - Previous condition value | ||
41 | XKONWA | OIRC_XKONWA | WAERS | CUKY | 5 | 0 | SSR Meters - Previous condition currency | * | |
42 | XKPEIN | OIRC_XKPEIN | KPEIN | DEC | 5 | 0 | SSR Meters - Previous condition pricing unit | ||
43 | XKMEIN | OIRC_XKMEIN | MEINS | UNIT | 3 | 0 | SSR Meters - Previous condition unit | * | |
44 | XKWERT | OIRC_XKWERT | WERTV7 | CURR | 13 | 2 | SSR Meters - Previous condition value | ||
45 | VKDAT | OIRE_VKDAT | DATS | DATS | 8 | 0 | SSR PC: Sales date at the service station | ||
46 | STATUS_UPDATE | OIRA_SKIP_ST_UPD | XFELD | CHAR | 1 | 0 | SSR: Indicator to cancel process status update | ||
47 | LINKNR | OIRA_LINKNR | NUMC10 | NUMC | 10 | 0 | Link number | ||
48 | ITLINKNR | OIRA_ITLINKNR | POSNR | NUMC | 6 | 0 | Item link number | * | |
49 | LINKYEAR | OIRA_JAHR | GJAHR | NUMC | 4 | 0 | Document link number year | ||
50 | KBETR_TARGET | OIRC_KBETR_TARGET | WERTV6 | CURR | 11 | 2 | SSR Pricing - Target price | ||
51 | KONWA_TARGET | OIRC_KONWA_TARGET | WAERS | CUKY | 5 | 0 | SSR Pricing - Target price currency | * | |
52 | KPEIN_TARGET | OIRC_KPEIN_TARGET | KPEIN | DEC | 5 | 0 | SSR Pricing - Target price pricing unit | ||
53 | KMEIN_TARGET | OIRC_KMEIN_TARGET | MEINS | UNIT | 3 | 0 | SSR Pricing - Target price condition unit | * | |
54 | ONLINE | OIRC_ONLINE | YESNO | CHAR | 1 | 0 | SSR Meters - On-line process indicator | ||
55 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
56 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
57 | MRDATE_TARGET | OIRC_DATUM | DATUM | DATS | 8 | 0 | SSR Fuels - local date | ||
58 | MRTIME_TARGET | OIRC_UZEIT | UZEIT | TIMS | 6 | 0 | SSR Fuels - Local time | ||
59 | .INCLUDE | 0 | 0 | Standard status field set (BDRP) | |||||
60 | ERDAT | OII_ERDAT | DATS | DATS | 8 | 0 | Date record created | ||
61 | ERZEIT | OII_ERZEIT | TIME | TIMS | 6 | 0 | Time record created | ||
62 | ERNAM | OII_ERNAM | USNAM | CHAR | 12 | 0 | User who created record | ||
63 | AEDAT | OII_AEDAT | DATS | DATS | 8 | 0 | Date record changed | ||
64 | AEZEIT | OII_AEZEIT | TIME | TIMS | 6 | 0 | Time record changed | ||
65 | AENAM | OII_AENAM | USNAM | CHAR | 12 | 0 | User who changed record | ||
66 | BLOIND | OII_BLOIND | XFELD | CHAR | 1 | 0 | Blocking indicator | ||
67 | DELIND | OII_DELIND | XFELD | CHAR | 1 | 0 | Deletion indicator | ||
68 | PROC_TYPE | OIRC_IND_PROC | OIRC_IND_PROC | CHAR | 1 | 0 | SSR Fuels - Process type | ||
69 | TOL_STATUS | OIRC_CHKST | CHAR04 | CHAR | 4 | 0 | SSR Fuels - Status check light | ||
70 | STCODE | OIRC_STCODE_SAP | OIRC_STCODE_SAP | CHAR | 2 | 0 | SSR Fuels - Status code | * | |
71 | BEZEI | BEZEI40 | TEXT40 | CHAR | 40 | 0 | Description | ||
72 | BLOCK | OIRC_IND_BLK | OIRC_IND_BLK | CHAR | 1 | 0 | SSR Fuels - Indicator that identifies a blocking status | ||
73 | BLOCK_RELEASE | OIRC_IND_BLKRLS | OIRC_IND_BLKRLS | CHAR | 1 | 0 | SSR Fuels - Indicator for blocking status release | ||
74 | USR_IND | OIRC_USR_IND | YESNO | CHAR | 1 | 0 | SSR Fuels - User error indicator | ||
75 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
76 | ITMSTM | OII_ITMSTM | TZNTSTMPS | DEC | 15 | 0 | GMM: Inverse timestamp | ||
77 | REC_SEQNR | OIRC_SEQNR | OIRC_SEQNR | NUMC | 5 | 0 | SSR Fuels - Sequential number | ||
78 | MRDATE_TO | DATUM | DATUM | DATS | 8 | 0 | Date | ||
79 | MRTIME_TO | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
80 | TMSTM | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
81 | TMSTM_TO | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
82 | STYP_DESCR | OIRA_DESCR | TEXT50 | CHAR | 50 | 0 | Descriptive text | ||
83 | NRDIG | OII_NRDIG | OII_NRDIG | NUMC | 2 | 0 | GMM: Number of digits in meter counter |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIRC_MRUPLD | EQUNR | EQUI | EQUNR | |||
2 | ROIRC_MRUPLD | GMMNR | OIIGMMK | GMMNR | KEY | 1 | CN |
3 | ROIRC_MRUPLD | KMEIN | T006 | MSEHI | |||
4 | ROIRC_MRUPLD | KONWA | TCURC | WAERS | |||
5 | ROIRC_MRUPLD | MATNR | MARA | MATNR | REF | 1 | CN |
6 | ROIRC_MRUPLD | METEV | OIIGMMET | METEV | |||
7 | ROIRC_MRUPLD | METREV | OIRC_GMME | METREV | REF | 1 | CN |
8 | ROIRC_MRUPLD | RNBT | OIRARNBT | RNBT |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |