SAP ABAP Table ROIR_HLBT_ALV (Structure for Business Type level ALV Display(IS-OIL, SSR))
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
⤷ OIR_H (Package) SSR Interfaces/Internet/BAPIs (IS-Oil ServiceStationRetail.)
⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
⤷ OIR_H (Package) SSR Interfaces/Internet/BAPIs (IS-Oil ServiceStationRetail.)
Basic Data
Table Category | INTTAB | Structure |
Structure | ROIR_HLBT_ALV | Table Relationship Diagram |
Short Description | Structure for Business Type level ALV Display(IS-OIL, SSR) |
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 | .INCLUDE | 0 | 0 | Business location at business type level (IS-OIL SSR) | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PBLNR | OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | OIFSPBL | |
4 | RNBT | OIRA_RNBT | OIRA_RNBT | CHAR | 4 | 0 | Business type | OIRARNBT | |
5 | BRAND | OIRB_BRAND | OIRB_BRAND | CHAR | 5 | 0 | Location brand | OIRBBRAND | |
6 | LOCVALUE | OIRB_VAL | OIRB_VAL | CHAR | 2 | 0 | Relative location value | OIRBPBLVAL | |
7 | LOCVDIFF | OIRB_LOCVDIFF | OIRB_LOCVDIFF | CHAR | 2 | 0 | Location value differentiator | OIRBPBLVALD | |
8 | STD_STYP | OIRA_STD_STYP | OIRA_STYP | CHAR | 4 | 0 | Standard service type | OIRASTYP | |
9 | LOCAA | OIRB_LAA | OIRB_LAA | CHAR | 5 | 0 | Location area assignment | OIRBLAA | |
10 | PR_AUTGR | OIRC_PR_AUTGR | CHAR4 | CHAR | 4 | 0 | SSR Pricing - Authorization group | ||
11 | LPRCLU | OIRC_LPRCLU | OIRC_LPRCLU | CHAR | 10 | 0 | SSR Pricing - Location price cluster | OIRCLPC | |
12 | SFDIFFGR | OIRC_SFDIFFGR | OIRC_SFDIFFGR | CHAR | 10 | 0 | SSR Pricing - service type difference price group | OIRCSDPG | |
13 | MDIFFGR | OIRC_MDIFFGR | OIRC_MDIFFGR | CHAR | 10 | 0 | SSR Pricing - material difference price group | OIRCMDPG | |
14 | F_PR | OIRC_F_PR | OIRC_F_PR | CHAR | 2 | 0 | SSR - processing profile ID | OIRC_FUELS_PR | |
15 | INV_BLOCK | OIRC_IND_IBL | OIRC_IND_IBL | CHAR | 1 | 0 | SSR Meters - invoicing block indicator | ||
16 | BL_DATE_FROM | OIRC_IB_D_FROM | DATE | DATS | 8 | 0 | SSR Meters - Invoicing block date from | ||
17 | BL_TIME_FROM | OIRC_IB_T_FROM | TIME | TIMS | 6 | 0 | SSR Meters - Invoicing block time from | ||
18 | BL_DATE_TO | OIRC_IB_D_TO | DATE | DATS | 8 | 0 | SSR Meters - Invoicing block date to | ||
19 | BL_TIME_TO | OIRC_IB_T_TO | TIME | TIMS | 6 | 0 | SSR Meters - Invoicing block time to | ||
20 | ACC_GROUP | OIRC_ACC_GR | OIRC_ACC_GR | CHAR | 2 | 0 | SSR Meters - meter access profile ID | OIRC_ACCGR | |
21 | MATHANDGRP | OIRA_MATHANDGRP | OIRA_MATHANDGRP | CHAR | 2 | 0 | Material handling group (IS-Oil SSR) | OIRAMATHANDGRPD | |
22 | .INCLUDE | 0 | 0 | Conversion Group Structure-Field Conversion(IS-OIL, SSR) | |||||
23 | CONVGR | OIRH_CONVGR | CHAR4 | CHAR | 4 | 0 | SSR Interface conversion group definition (IS-Oil, SSR) | OIRHCVGRDEFC | |
24 | LOGSYS | OIRH_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system for EDI | TBDLS | |
25 | .INCLUDE | 0 | 0 | Object link data status fields (IS-Oil MRN) | |||||
26 | ERDAT | OIF_ERDAT | DATS | DATS | 8 | 0 | Date Record Created on (Date) | ||
27 | ERZEIT | OIF_ERZEIT | TIME | TIMS | 6 | 0 | Time Record Created at (Time) | ||
28 | ERNAM | OIF_ERNAM | USNAM | CHAR | 12 | 0 | User who Created Record | ||
29 | AEDAT | OIF_AEDAT | DATS | DATS | 8 | 0 | Date Record Changed on (Date) | ||
30 | AEZEIT | OIF_AEZEIT | TIME | TIMS | 6 | 0 | Time when Record Was Changed | ||
31 | AENAM | OIF_AENAM | USNAM | CHAR | 12 | 0 | User who Changed Record | ||
32 | BLOIND | OIF_BLOIND | XFELD | CHAR | 1 | 0 | Block Indicator | ||
33 | DELIND | OIF_DELIND | XFELD | CHAR | 1 | 0 | Deletion indicator | ||
34 | NAME1 | AD_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 | ||
35 | NAME2 | AD_NAME2 | TEXT40 | CHAR | 40 | 0 | Name 2 | ||
36 | NAME3 | AD_NAME3 | TEXT40 | CHAR | 40 | 0 | Name 3 | ||
37 | NAME4 | AD_NAME4 | TEXT40 | CHAR | 40 | 0 | Name 4 | ||
38 | CITY1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
39 | CITY2 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
40 | POST_CODE1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
41 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
42 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
43 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
44 | TIME_ZONE | AD_TZONE | TZNZONE | CHAR | 6 | 0 | Address time zone | * | |
45 | TEL_NUMBER | AD_TLNMBR1 | CHAR30 | CHAR | 30 | 0 | First telephone no.: dialling code+number | ||
46 | KOKRS_CC | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
47 | KOSTL_CC | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
48 | DATBI_CC | DATBI | DATUM | DATS | 8 | 0 | Valid To Date | ||
49 | BEZEI_CC | BEZEI | TEXT25 | CHAR | 25 | 0 | Name of the controlling area | ||
50 | ABTEI_CC | ABTEI | ABTEI | CHAR | 12 | 0 | Department | ||
51 | VERAK_CC | VERAK | VERAK | CHAR | 20 | 0 | Person Responsible | ||
52 | NAME_CC | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
53 | KOKRS_PC | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
54 | PRCTR_PC | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
55 | DATBI_PC | DATBI | DATUM | DATS | 8 | 0 | Valid To Date | ||
56 | DATAB_PC | DATAB | DATUM | DATS | 8 | 0 | Valid-From Date | ||
57 | BEZEI_PC | BEZEI | TEXT25 | CHAR | 25 | 0 | Name of the controlling area | ||
58 | ABTEI_PC | ABTEIL | ABTEI | CHAR | 12 | 0 | Department | ||
59 | NAME1_PC | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
60 | VERAPC_PC | VERAPC | VERAK | CHAR | 20 | 0 | Person Responsible for Profit Center | ||
61 | BUKRS_AM | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
62 | ANLN1_AM | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
63 | ANLN2_AM | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
64 | TXT50_AM | TXA50_ANLT | TEXT50 | CHAR | 50 | 0 | Asset description | ||
65 | ANLKL_AM | ANLKL | ANLKL | CHAR | 8 | 0 | Asset Class | * | |
66 | TXK50_AM | TXT50_ANKT | TEXT50 | CHAR | 50 | 0 | Asset class description | ||
67 | TPLNR_FL | TPLNR | TPLNR | CHAR | 30 | 0 | Functional Location | * | |
68 | PLTXT_FL | PLTXT | TEXT40 | CHAR | 40 | 0 | Description of functional location | ||
69 | TPLMA_FL | TPLMA | TPLNR | CHAR | 30 | 0 | Superior functional location | * | |
70 | WERKS_SL | OIF_WERKSL | WERKS | CHAR | 4 | 0 | Plant for storage location assignment entry (IS-Oil MRN) | * | |
71 | LGORT_SL | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
72 | NAME1_SL | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
73 | BWKEY_SL | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | * | |
74 | BUKRS_SL | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
75 | BUTXT_SL | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
76 | LGOBE_SL | LGOBE | TEXT16 | CHAR | 16 | 0 | Description of Storage Location | ||
77 | SPART_SL | SPART | SPART | CHAR | 2 | 0 | Division | * | |
78 | VTXTK_SL | VTXTK | TEXT20 | CHAR | 20 | 0 | Name | ||
79 | WERKS_PA | OIF_WERKSW | WERKS | CHAR | 4 | 0 | Plant assignment entry (IS-Oil MRN) | * | |
80 | NAME1_PA | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
81 | BWKEY_PA | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | * | |
82 | BUKRS_PA | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
83 | DESC_LAA | OIRB_DESCR | TEXT50 | CHAR | 50 | 0 | Descriptive text | ||
84 | LOCREG | OIRB_REGION | OIRB_REGION | CHAR | 4 | 0 | Location region | * | |
85 | DESCR_REG | OIRB_DESCR | TEXT50 | CHAR | 50 | 0 | Descriptive text | ||
86 | LOCAREA | OIRB_AREA | OIRB_AREA | CHAR | 4 | 0 | Location area | * | |
87 | DESCR_AREA | OIRB_DESCR | TEXT50 | CHAR | 50 | 0 | Descriptive text | ||
88 | LOCSAREA | OIRB_SAREA | OIRB_SAREA | CHAR | 4 | 0 | Location sub-area | * | |
89 | DESCR_SAREA | OIRB_DESCR | TEXT50 | CHAR | 50 | 0 | Descriptive text | ||
90 | LOCVALUET | OIRB_DESCR | TEXT50 | CHAR | 50 | 0 | Descriptive text | ||
91 | LOCVDIFFT | OIRB_DESCR | TEXT50 | CHAR | 50 | 0 | Descriptive text | ||
92 | LPRCLUT | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
93 | SFDIFFGRT | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
94 | MDIFFGRT | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
95 | F_PRT | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
96 | MATHANDGRPT | OIRA_DESCR | TEXT50 | CHAR | 50 | 0 | Descriptive text | ||
97 | STATUS | OIRB_STATUS | OIRB_STATUS | CHAR | 2 | 0 | Location status | * | |
98 | STATUST | OIRA_DESCR | TEXT50 | CHAR | 50 | 0 | Descriptive text |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIR_HLBT_ALV | ACC_GROUP | OIRC_ACCGR | ACCGR | |||
2 | ROIR_HLBT_ALV | BRAND | OIRBBRAND | BRANDID | REF | ||
3 | ROIR_HLBT_ALV | CONVGR | OIRHCVGRDEFC | CONVGR | |||
4 | ROIR_HLBT_ALV | F_PR | OIRC_FUELS_PR | F_PR | |||
5 | ROIR_HLBT_ALV | LOCAA | OIRBLAA | LOCAA | |||
6 | ROIR_HLBT_ALV | LOCVALUE | OIRBPBLVAL | LOCVALUE | REF | ||
7 | ROIR_HLBT_ALV | LOCVDIFF | OIRBPBLVALD | LOCVDIFF | REF | ||
8 | ROIR_HLBT_ALV | LOGSYS | TBDLS | LOGSYS | |||
9 | ROIR_HLBT_ALV | LPRCLU | OIRCLPC | LPRCLU | REF | ||
10 | ROIR_HLBT_ALV | MANDT | T000 | MANDT | |||
11 | ROIR_HLBT_ALV | MATHANDGRP | OIRAMATHANDGRPD | MATHANDGRP | |||
12 | ROIR_HLBT_ALV | MDIFFGR | OIRCMDPG | MDIFFGR | REF | ||
13 | ROIR_HLBT_ALV | PBLNR | OIFSPBL | PBLNR | KEY | 1 | CN |
14 | ROIR_HLBT_ALV | RNBT | OIRARNBT | RNBT | KEY | 1 | CN |
15 | ROIR_HLBT_ALV | SFDIFFGR | OIRCSDPG | SFDIFFGR | REF | ||
16 | ROIR_HLBT_ALV | STD_STYP | OIRASTYP | STYP | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |