SAP ABAP Table S412 (SSR Margin Report)

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	TRANSP	Transparent table
Transparent table	S412	Table Relationship Diagram
Short Description	SSR Margin Report

Delivery and Maintenance

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

History

Last changed by/on	SAP	20050224
SAP Release Created in	472