SAP ABAP Table ROIRI_S412 (Margin report data selection structure)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
     ⤷ OIR_I (Package) SSR Settlement/Invoicing (IS-Oil Service Station Retailing)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIRI_S412	Table Relationship Diagram
Short Description	Margin report data selection 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	.INCLUDE	☐				0	0	SSR Margin Report
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	SSOUR	☐	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
4	VRSIO	☐	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
5	SPMON	☐	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
6	SPTAG	☐	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
7	SPWOC	☐	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
8	SPBUP	☐	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
9	OIRIPBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	OISTYP	☐	OIRA_STYP	OIRA_STYP	CHAR	4	0	Service type	OIRASTYP
12	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
13	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
14	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
15	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
16	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
17	OIRCOMMNET	☐	OIRI_COMMNET	WERTV8	CURR	15	2	SSR - Location net commission
18	OIRCOMMVAT	☐	OIRI_COMMVAT	WERTV8	CURR	15	2	SSR - Location vat on commission
19	OIRPFEENET	☐	OIRI_PARTFEENET	WERTV8	CURR	15	2	SSR - Location net participation fee
20	OIRPFEEVAT	☐	OIRI_PARTFEEVAT	WERTV8	CURR	15	2	SSR - Location net participation vat
21	OIRFUGR	☐	OIRI_FUELGR	WERTV8	CURR	15	2	SSR-Location fuel sales gross
22	OIREBV	☐	OIRI_EBV	WERTV8	CURR	15	2	EBV cost
23	OIRFCFEES	☐	OIRI_FCFEES	WERTV8	CURR	15	2	SSR Fleet Card processing fees
24	OIRCHFEES	☐	OIRI_CHFEES	WERTV8	CURR	15	2	SSR Clearing house processing fees
25	OIRFREIGHT	☐	OIRI_FREIGHT	WERTV8	CURR	15	2	Freight cost
26	OIRPURPR	☐	OIRI_PURPRICE	WERTV8	CURR	15	2	Purchase cost of material
27	OIRFUNET	☐	OIRI_FUELNET	WERTV8	CURR	15	2	Fuel sales net
28	OIRFUVAT	☐	OIRI_FUELVAT	WERTV8	CURR	15	2	Fuel sales vat
29	MCUPD	☐	MCUPD	X	CHAR	1	0	Indicator whether statistical record was updated
30	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
31	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
32	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIRI_S412	BASME	T006	MSEHI
2	ROIRI_S412	MANDT	T000	MANDT	KEY
3	ROIRI_S412	MATNR	MARA	MATNR	KEY
4	ROIRI_S412	OIRIPBLNR	OIFSPBL	PBLNR	KEY
5	ROIRI_S412	OISTYP	OIRASTYP	STYP	KEY
6	ROIRI_S412	STWAE	TCURC	WAERS
7	ROIRI_S412	VRKME	T006	MSEHI
8	ROIRI_S412	WAERK	TCURC	WAERS

History

Last changed by/on	SAP	20050224
SAP Release Created in	46C