SAP ABAP Table ROIRHLOCMASTERDATAITEMS (Item details for location master data transfer by ALE)

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.)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIRHLOCMASTERDATAITEMS	Table Relationship Diagram
Short Description	Item details for location master data transfer by ALE

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	LOCATIONID	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
2	BUSINESSTYPE	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	*
3	STORE	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
4	BUSTYPE_OPENHOURS	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	*
5	W11BOS	☐	OII_W11BOS	TIME	TIMS	6	0	Monday:time sales begin 1
6	W11EOS	☐	OII_W11EOS	TIME	TIMS	6	0	Monday time sales end 1
7	W12BOS	☐	OII_W12BOS	TIME	TIMS	6	0	Monday:time sales begin 2
8	W12EOS	☐	OII_W12EOS	TIME	TIMS	6	0	Monday:time sales end 2
9	W21BOS	☐	OII_W21BOS	TIME	TIMS	6	0	Tuesday:time sales begin 1
10	W21EOS	☐	OII_W21EOS	TIME	TIMS	6	0	Tuesday:time sales end 1
11	W22BOS	☐	OII_W22BOS	TIME	TIMS	6	0	Tuesday:time sales begin 2
12	W22EOS	☐	OII_W22EOS	TIME	TIMS	6	0	Tuesday:time sales end 2
13	W31BOS	☐	OII_W31BOS	TIME	TIMS	6	0	Wednesday:time sales begin 1
14	W31EOS	☐	OII_W31EOS	TIME	TIMS	6	0	Wednesday:time sales end 1
15	W32BOS	☐	OII_W32BOS	TIME	TIMS	6	0	Wednesday:time sales begin 2
16	W32EOS	☐	OII_W32EOS	TIME	TIMS	6	0	Wednesday:time sales end 2
17	W41BOS	☐	OII_W41BOS	TIME	TIMS	6	0	Thursday:time sales begin 1
18	W41EOS	☐	OII_W41EOS	TIME	TIMS	6	0	Thursday:time sales end 1
19	W42BOS	☐	OII_W42BOS	TIME	TIMS	6	0	Thursday:time sales begin 2
20	W42EOS	☐	OII_W42EOS	TIME	TIMS	6	0	Thursday:time sales end 2
21	W51BOS	☐	OII_W51BOS	TIME	TIMS	6	0	Friday:time sales begin 1
22	W51EOS	☐	OII_W51EOS	TIME	TIMS	6	0	Friday:time sales end 1
23	W52BOS	☐	OII_W52BOS	TIME	TIMS	6	0	Friday:time sales begin 2
24	W52EOS	☐	OII_W52EOS	TIME	TIMS	6	0	Friday:time sales end 2
25	W61BOS	☐	OII_W61BOS	TIME	TIMS	6	0	Saturday:time sales begin 1
26	W62BOS	☐	OII_W62BOS	TIME	TIMS	6	0	Saturday:time sales begin 2
27	W62EOS	☐	OII_W62EOS	TIME	TIMS	6	0	Saturday:time sales end 2
28	W71BOS	☐	OII_W71BOS	TIME	TIMS	6	0	Sunday:time sales begin 1
29	W71EOS	☐	OII_W71EOS	TIME	TIMS	6	0	Sunday:time sales end 1
30	W72BOS	☐	OII_W72BOS	TIME	TIMS	6	0	Sunday:time sales begin 2
31	W72EOS	☐	OII_W72EOS	TIME	TIMS	6	0	Sunday:time sales end 2
32	W81BOS	☐	OII_W81BOS	TIME	TIMS	6	0	Public holiday: time sales begin 1
33	W81EOS	☐	OII_W81EOS	TIME	TIMS	6	0	Public holiday: time sales end 1
34	W82BOS	☐	OII_W82BOS	TIME	TIMS	6	0	Public holiday: time sales begin 2
35	W82EOS	☐	OII_W82EOS	TIME	TIMS	6	0	Public holiday: time sales end 2
36	BUSTYPE_COMP	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	*
37	COMPETITORID	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
38	NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
39	BRAND	☐	OIRB_BRAND	OIRB_BRAND	CHAR	5	0	Location brand	*
40	VALIDTO	☐	OIRB_DATETO	DATUM	DATS	8	0	Valid to date
41	VALIDFROM	☐	OIRB_DATEFROM	DATUM	DATS	8	0	Valid from date
42	DOMID	☐	OIRB_DOMID	CHAR2	CHAR	2	0	Dominance indicator
43	DIST	☐	OIRB_DIST	NUMC4	NUMC	4	0	Distance from competitor's location
44	DISTUOM	☐	OIRB_DISTUOM	MEINS	UNIT	3	0	Distance unit of measurement	*
45	DISTUOMISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
46	EXTCOMPNR	☐	OIRB_EXTCOMPNR	NUMC2	NUMC	2	0	External competitor number at location
47	BUSTYPE_MATSTYP	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	*
48	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
49	MATERIALTEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
50	SERVICETYPE	☐	OIRA_STYP	OIRA_STYP	CHAR	4	0	Service type	*
51	SERVICETYPETEXT	☐	OIRA_DESCR	TEXT50	CHAR	50	0	Descriptive text
52	.INCLUDE	☐				0	0	Business loca details-Accepted payment cards(IS-Oil, SSR)
53	CC_LOW	☐	OIRH_LOW_CC	CHAR25	CHAR	25	0	Payment cards from
54	CC_HIGH	☐	OIRH_HIGH_CC	CHAR25	CHAR	25	0	Payment cards to
55	CC_TYPE	☐	OIRE_CCINS	OIRE_CCINS	CHAR	4	0	SSR PC: Payment card type	*
56	CC_TYPETEXT	☐	OIRH_CCTYPET	CHAR20	CHAR	20	0	Card type description
57	FLOORLIMIT_BL	☐	OIRH_FLBL	OIRH_DEC23_2	DEC	23	2	Black list check amount
58	FLOORLIMIT_CH	☐	OIRH_FLCH	OIRH_DEC23_2	DEC	23	2	Clearing house check amount
59	BLACKLISTPLACE	☐	OIRE_BLPLACE	OIRE_BLPLACE	CHAR	2	0	SSR PC: Black list storage place	*
60	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
61	CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
62	CC_VALID_F	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
63	CC_VALID_T	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
64	MERCHANTID	☐	OIRE_SSMID	OIRE_SSMID	CHAR	20	0	SSR PC: Service station merchant ID
65	MERCHANTIDTEXT	☐	OIRE_SSMIDTX	OIRE_SSMIDTX	CHAR	50	0	SSR PC: Service station merchant ID text

History

Last changed by/on	SAP	20130529
SAP Release Created in