SAP ABAP Table ROIRC_PRUPLD (SSR Pricing - Upload structure)

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_PRUPLD	Table Relationship Diagram
Short Description	SSR Pricing - Upload 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	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIRBPBLPBL
2	RNBT	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	OIRARNBT
3	COMNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	SERVTYP	☐	OIRA_STYP	OIRA_STYP	CHAR	4	0	Service type	*
6	.INCLUDE	☐				0	0	SSR Pricing - Price check
7	TMSTM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
8	TIME_ZONE	☐	OIRC_TIMEZONE	TZNZONE	CHAR	6	0	SSR Fuels - Service station time zone	*
9	P_DATE	☐	OIRC_DATUM	DATUM	DATS	8	0	SSR Fuels - local date
10	P_TIME	☐	OIRC_UZEIT	UZEIT	TIMS	6	0	SSR Fuels - Local time
11	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
12	KBETR	☐	OIRC_KBETR_ACTUAL	WERTV6	CURR	11	2	SSR Pricing - Actual price
13	KBETR_TARGET	☐	OIRC_KBETR_TARGET	WERTV6	CURR	11	2	SSR Pricing - Target price
14	KONWA	☐	OIRC_KONWA_ACTUAL	WAERS	CUKY	5	0	SSR Pricing - Actual price currency	TCURC
15	KPEIN	☐	OIRC_KPEIN_ACTUAL	KPEIN	DEC	5	0	SSR Pricing - Actual price pricing unit
16	KMEIN	☐	OIRC_KMEIN_ACTUAL	MEINS	UNIT	3	0	SSR Pricing - Actual price condition unit	T006
17	KBETR_DIFF	☐	OIRC_KBETR_DIFF	WERTV6	CURR	11	2	SSR Pricing - Difference target/actual price
18	PROC_TYPE	☐	OIRC_IND_PROC	OIRC_IND_PROC	CHAR	1	0	SSR Fuels - Process type
19	TOL_STATUS	☐	OIRC_PRSTCHK	CHAR04	CHAR	4	0	SSR Fuels - Price status check light
20	STCODE	☐	OIRC_STCODE_SAP	OIRC_STCODE_SAP	CHAR	2	0	SSR Fuels - Status code	OIRC_STATUS
21	BEZEI	☐	BEZEI40	TEXT40	CHAR	40	0	Description
22	USR_IND	☐	OIRC_USR_IND	YESNO	CHAR	1	0	SSR Fuels - User error indicator
23	.INCLUDE	☐				0	0	Standard status field set (BDRP)
24	ERDAT	☐	OII_ERDAT	DATS	DATS	8	0	Date record created
25	ERZEIT	☐	OII_ERZEIT	TIME	TIMS	6	0	Time record created
26	ERNAM	☐	OII_ERNAM	USNAM	CHAR	12	0	User who created record
27	AEDAT	☐	OII_AEDAT	DATS	DATS	8	0	Date record changed
28	AEZEIT	☐	OII_AEZEIT	TIME	TIMS	6	0	Time record changed
29	AENAM	☐	OII_AENAM	USNAM	CHAR	12	0	User who changed record
30	BLOIND	☐	OII_BLOIND	XFELD	CHAR	1	0	Blocking indicator
31	DELIND	☐	OII_DELIND	XFELD	CHAR	1	0	Deletion indicator
32	ADDRESS	☐	CHAR57	CHAR57	CHAR	57	0	Character field length 57
33	KSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	T685
34	KWERT	☐	KWERT	WERTV7	CURR	13	2	Condition Value
35	MRDATE	☐	OIRC_DATUM	DATUM	DATS	8	0	SSR Fuels - local date
36	MRTIME	☐	OIRC_UZEIT	UZEIT	TIMS	6	0	SSR Fuels - Local time
37	MRDATE_TO	☐	DATUM	DATUM	DATS	8	0	Date
38	MRTIME_TO	☐	UZEIT	UZEIT	TIMS	6	0	Time
39	TMSTM_TO	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
40	SAVEFAILED	☐	OIRC_SAVED	CHAR1	CHAR	1	0	Condition data not saved successfullly
41	CHDOCNUM	☐	OIRC_CHDOCNUM	OIRC_CHDOCNUM	CHAR	10	0	SSR price change document number
42	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
43	STYP_DESCR	☐	OIRA_DESCR	TEXT50	CHAR	50	0	Descriptive text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIRC_PRUPLD	COMNR	OIFSPBL	PBLNR
2	ROIRC_PRUPLD	KMEIN	T006	MSEHI	REF	1	CN
3	ROIRC_PRUPLD	KONWA	TCURC	WAERS	REF	1	CN
4	ROIRC_PRUPLD	KSCHL	T685	KSCHL
5	ROIRC_PRUPLD	MATNR	MARA	MATNR	REF	1	CN
6	ROIRC_PRUPLD	PBLNR	OIRBPBLPBL	PBLNR	REF	1	CN
7	ROIRC_PRUPLD	RNBT	OIRARNBT	RNBT
8	ROIRC_PRUPLD	STCODE	OIRC_STATUS	STCODE	REF		CN

History

Last changed by/on	SAP	20130529
SAP Release Created in