SAP ABAP Table ROIRC_DIFFERENCES (SSR Pricing - Location price cluster differences/Material)

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)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIRC_DIFFERENCES	Table Relationship Diagram
Short Description	SSR Pricing - Location price cluster differences/Material

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	PRICE_CONTROL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
2	PRICE_LINE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
3	MATCHECK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
4	LPRCLU	☐	OIRC_LPRCLU	OIRC_LPRCLU	CHAR	10	0	SSR Pricing - Location price cluster	OIRCLPC
5	LPRCLU_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
6	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
7	PBLNR_TEXT	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
8	ADDRNUM	☐	OIF_ADNUM	AD_ADDRNUM	CHAR	10	0	Address No. in ADRC	*
9	RNBT	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	OIRARNBT
10	RNBT_TEXT	☐	OIRA_DESCR	TEXT50	CHAR	50	0	Descriptive text
11	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	MATNR_TEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
13	MATHANDGRP	☐	OIRA_MATHANDGRP	OIRA_MATHANDGRP	CHAR	2	0	Material handling group (IS-Oil SSR)	OIRAMATHANDGRPD
14	MDIFFGR	☐	OIRC_MDIFFGR	OIRC_MDIFFGR	CHAR	10	0	SSR Pricing - material difference price group	OIRCMDPG
15	MDIFFGR_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
16	MATNR_R	☐	OIRC_MATNR_R	MATNR	CHAR	18	0	SSR Pricing - reference price material	MARA
17	MATNR_R_TEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
18	MATNR_D	☐	OIRC_MATNR_D	MATNR	CHAR	18	0	SSR Pricing - dependent price material	MARA
19	MATNR_D_TEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
20	SFDIFFGR	☐	OIRC_SFDIFFGR	OIRC_SFDIFFGR	CHAR	10	0	SSR Pricing - service type difference price group	OIRCSDPG
21	SFDIFFGR_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
22	STYPE_R	☐	OIRC_STYPE_R	OIRA_STYP	CHAR	4	0	SSR Pricing - Reference service type	OIRASTYP
23	STYPE_R_TEXT	☐	OIRA_DESCR	TEXT50	CHAR	50	0	Descriptive text
24	STYPE_D	☐	OIRC_STYPE_D	OIRA_STYP	CHAR	4	0	SSR Pricing - Dependent service type	OIRASTYP
25	STYPE_D_TEXT	☐	OIRA_DESCR	TEXT50	CHAR	50	0	Descriptive text
26	COMPPBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIRBPBLB
27	COMPPBLNR_TEXT	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
28	KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	TCURC
29	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
30	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
31	RATE	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
32	RATE_MAX	☐	GKWRT	WERTV6	CURR	11	2	Upper limit for the condition rate
33	RATE_MIN	☐	MXWRT	WERTV6	CURR	11	2	Lower limit of the condition rate/amount
34	IND_LIMIT	☐	OIRC_IND_LIMIT	OIRC_IND_MM	CHAR	1	0	SSR Pricing - Price upper limit indicator
35	KALVG	☐	OIRC_KALVG	OIRC_KALVG	CHAR	1	0	SSR Pricing - Margins procedure assigned to business type	*
36	KALKS	☐	OIRC_KALKS	OIRC_KALKS	CHAR	1	0	SSR Pricing - Margins procedure assigned to this location	*
37	KSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
38	PBLNR_DEP	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
39	PBLNR_DEP_TEXT	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIRC_DIFFERENCES	COMPPBLNR	OIRBPBLB	PBLNR	KEY
2	ROIRC_DIFFERENCES	KMEIN	T006	MSEHI	KEY
3	ROIRC_DIFFERENCES	KONWA	TCURC	WAERS	KEY
4	ROIRC_DIFFERENCES	LPRCLU	OIRCLPC	LPRCLU	KEY
5	ROIRC_DIFFERENCES	MATHANDGRP	OIRAMATHANDGRPD	MATHANDGRP	REF	1	CN
6	ROIRC_DIFFERENCES	MATNR	MARA	MATNR
7	ROIRC_DIFFERENCES	MATNR_D	MARA	MATNR	REF	1	CN
8	ROIRC_DIFFERENCES	MATNR_R	MARA	MATNR
9	ROIRC_DIFFERENCES	MDIFFGR	OIRCMDPG	MDIFFGR
10	ROIRC_DIFFERENCES	PBLNR	OIFSPBL	PBLNR	KEY
11	ROIRC_DIFFERENCES	RNBT	OIRARNBT	RNBT	KEY
12	ROIRC_DIFFERENCES	SFDIFFGR	OIRCSDPG	SFDIFFGR
13	ROIRC_DIFFERENCES	STYPE_D	OIRASTYP	STYP
14	ROIRC_DIFFERENCES	STYPE_R	OIRASTYP	STYP

History

Last changed by/on	SAP	20130529
SAP Release Created in