SAP ABAP Table OIRC_PRCHK (SSR Pricing - Price check)

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	TRANSP	Transparent table
Transparent table	OIRC_PRCHK	Table Relationship Diagram
Short Description	SSR Pricing - Price check

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	PBLNR	☑	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
3	RNBT	☑	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	OIRBPBLB
4	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	SERVTYP	☑	OIRA_STYP	OIRA_STYP	CHAR	4	0	Service type	OIRASTYP
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	*
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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIRC_PRCHK	KMEIN	T006	MSEHI	REF	1	CN
2	OIRC_PRCHK	KONWA	TCURC	WAERS	REF	1	CN
3	OIRC_PRCHK	MANDT	T000	MANDT	KEY	1	CN
4	OIRC_PRCHK	MATNR	MARA	MATNR	KEY	1	CN
5	OIRC_PRCHK	PBLNR	OIFSPBL	PBLNR	KEY	1	CN
6	OIRC_PRCHK	RNBT	OIRBPBLB	RNBT	KEY	1	CN
7	OIRC_PRCHK	SERVTYP	OIRASTYP	STYP	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in