SAP ABAP Table ROIRI_MARG_ALV (Structure for alv display of location master(IS-OIL, SSR))

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_MARG_ALV	Table Relationship Diagram
Short Description	Structure for alv display of location master(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	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
2	PBLTYP	☐	OIF_PBLTYP	OIF_PBLTYP	CHAR	4	0	Business Location Type (IS-Oil MRN)	*
3	NAME1	☐	OIF_PBNAM1	CHAR35	CHAR	35	0	Internal name field
4	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
5	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
6	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
7	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
8	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
9	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
10	BEZEI_REGION	☐	OIRA_REG_BEZEI20	TEXT20	CHAR	20	0	Descriptive text for the region
11	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	*
12	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
13	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
14	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
15	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
16	LOCAA	☐	OIRB_LAA	OIRB_LAA	CHAR	5	0	Location area assignment	OIRBLAA
17	DESC_LAA	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
18	LOCREG	☐	OIRB_REGION	OIRB_REGION	CHAR	4	0	Location region	*
19	DESCR_REG	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
20	LOCAREA	☐	OIRB_AREA	OIRB_AREA	CHAR	4	0	Location area	*
21	DESCR_AREA	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
22	LOCSAREA	☐	OIRB_SAREA	OIRB_SAREA	CHAR	4	0	Location sub-area	*
23	DESCR_SAREA	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
24	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
25	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
26	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
27	OIRCOMMNET	☐	OIRI_COMMNET	WERTV8	CURR	15	2	SSR - Location net commission
28	OIRCOMMVAT	☐	OIRI_COMMVAT	WERTV8	CURR	15	2	SSR - Location vat on commission
29	OIRPFEENET	☐	OIRI_PARTFEENET	WERTV8	CURR	15	2	SSR - Location net participation fee
30	OIRPFEEVAT	☐	OIRI_PARTFEEVAT	WERTV8	CURR	15	2	SSR - Location net participation vat
31	OIRFUGR	☐	OIRI_FUELGR	WERTV8	CURR	15	2	SSR-Location fuel sales gross
32	OIREBV	☐	OIRI_EBV	WERTV8	CURR	15	2	EBV cost
33	OIRFCFEES	☐	OIRI_FCFEES	WERTV8	CURR	15	2	SSR Fleet Card processing fees
34	OIRCHFEES	☐	OIRI_CHFEES	WERTV8	CURR	15	2	SSR Clearing house processing fees
35	OIRFREIGHT	☐	OIRI_FREIGHT	WERTV8	CURR	15	2	Freight cost
36	OIRPURPR	☐	OIRI_PURPRICE	WERTV8	CURR	15	2	Purchase cost of material
37	OIRFUNET	☐	OIRI_FUELNET	WERTV8	CURR	15	2	Fuel sales net
38	OIRFUVAT	☐	OIRI_FUELVAT	WERTV8	CURR	15	2	Fuel sales vat
39	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
40	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
41	PRICE	☐	OIRI_PRICE	WERTV8	CURR	15	2	Average product sales price
42	MARGIN1	☐	OIRI_MARGIN_ELEMENT	WERTV8	CURR	15	2	Margin element value
43	MARGIN2	☐	OIRI_MARGIN_ELEMENT	WERTV8	CURR	15	2	Margin element value
44	MARGIN3	☐	OIRI_MARGIN_ELEMENT	WERTV8	CURR	15	2	Margin element value
45	MARGIN4	☐	OIRI_MARGIN_ELEMENT	WERTV8	CURR	15	2	Margin element value
46	REL_MARGIN1	☐	OIRI_MARGIN_ELEMENT	WERTV8	CURR	15	2	Margin element value
47	REL_MARGIN2	☐	OIRI_MARGIN_ELEMENT	WERTV8	CURR	15	2	Margin element value
48	REL_MARGIN3	☐	OIRI_MARGIN_ELEMENT	WERTV8	CURR	15	2	Margin element value
49	REL_MARGIN4	☐	OIRI_MARGIN_ELEMENT	WERTV8	CURR	15	2	Margin element value
50	BASIS	☐	OIRI_BASIS	CHAR005	CHAR	5	0	Relative margin calculation basis

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIRI_MARG_ALV	LOCAA	OIRBLAA	LOCAA

History

Last changed by/on	SAP	20130529
SAP Release Created in