SAP ABAP Table OIRADBT (Document base table)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
     ⤷ OIR (Package) SSR Service Station Retailing (master/overall)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIRADBT	Table Relationship Diagram
Short Description	Document base table

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	*
2	LINKNR	☑	OIRA_LINKNR	NUMC10	NUMC	10	0	Link number
3	ITLINKNR	☑	OIRA_ITLINKNR	POSNR	NUMC	6	0	Item link number	*
4	LINKYEAR	☑	OIRA_JAHR	GJAHR	NUMC	4	0	Document link number year
5	.INCLUDE	☐				0	0	Document Base Table data fields
6	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
7	DATATYPE	☐	OIRA_DATATYPE	OIRA_DATATYPE	CHAR	3	0	Data type
8	SRCETAB	☐	OIRA_SRCETAB	OIRA_SRCETAB	CHAR	16	0	Source table
9	RNBT	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	*
10	PARFN	☐	OIF_PARFN	OIF_PARFN	CHAR	4	0	MRN business partner role / relation type	*
11	FTMSTM	☐	OIF_FTMSTM	OIF_TMSTM	NUMC	14	0	Start of partner function validity period: time stamp
12	PARPOS	☐	OIF_PARPOS	OIF_PARPOS	NUMC	3	0	Partner counter
13	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
14	STYP	☐	OIRA_STYP	OIRA_STYP	CHAR	4	0	Service type	*
15	VKDAT	☐	OIRE_VKDAT	DATS	DATS	8	0	SSR PC: Sales date at the service station
16	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
17	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
18	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
19	CHOBJ	☐	OIRE_CHOBJ	OIRE_CHOBJ	CHAR	6	0	SSR PC: Clearing house	*
20	SSR_CCINS	☐	OIRE_CCINS	OIRE_CCINS	CHAR	4	0	SSR PC: Payment card type	*
21	STORNO	☐	OIRE_STORNO	CHAR1	CHAR	1	0	SSR PC: Reversal indicator
22	COMPFL	☐	OIRA_COMPFL	CHAR1	CHAR	1	0	Complaint indicator for OIRADBT entries
23	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
24	DCIND	☐	OIRA_DCIND	OIRE_DCIND	CHAR	1	0	Debit/Credit indicator
25	KBETR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
26	KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	*
27	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
28	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
29	MENGE	☐	OIRE_MENGE	MENG13V	QUAN	13	3	SSR PC: Quantity sold at the business location
30	BRTWR	☐	OIRE_BRTWR	WERTV7	CURR	13	2	SSR PC: Gross value
31	STPARTPROC	☐	OIRE_SETTRANPARTPROC	YESNO	CHAR	1	0	Partially processed indicator for Settlement transmission
32	SEQNR	☐	OII_GSEQNR	OII_SEQNR	CHAR	10	0	GMM: Sequence number of meter assigned to customer
33	TNKNR	☐	OII_BSEQNR	OII_SEQNR	CHAR	10	0	Sequence number of SO assigned to business location
34	HDRNR	☐	OIRE_UPLNR	CHAR10	CHAR	10	0	SSR PC: DTF payment card transaction number (internal)
35	ITMNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
36	GMMNR	☐	OII_GMMNR	OII_GMMNR	CHAR	20	0	GMM: Number of general meter	*
37	ITMSTM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
38	METREV	☐	OIRC_METREV	OIRC_METREV	CHAR	2	0	SSR: Meter event type	*
39	TRANSYEAR	☐	OIRA_JAHR	GJAHR	NUMC	4	0	Document link number year
40	SOCNR	☐	OII_SOCNR	OII_SOCNR	CHAR	20	0	SOC: Storage object characteristic segment number	*
41	ETMSTM	☐	OIRC_TMSTM	TZNTSTMPS	DEC	15	0	SSR Stocks - Tank dip time stamp
42	SOCEV	☐	OII_SOCEV	OII_SOCEV	CHAR	2	0	SOC event	*
43	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
44	SRCD_DATE	☐	OIRA_SRCD_DATE	DATUM	DATS	8	0	SSR - Source data date
45	SRCD_TIME	☐	OIRA_SRCD_TIME	UZEIT	TIMS	6	0	SSR - Source date time
46	COUNTER	☐	OIRA_COUNTER	OIRA_COUNTER	INT4	10	0	Transaction counter
47	PROCIND	☐	OIRA_PROCIND	OIRA_PROCIND	CHAR	1	0	Processed record indicator
48	.INCLUDE	☐				0	0	Customer fields in the DBT
49	OIRA_CUST	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
50	.INCLUDE	☐				0	0	Indicator fields for DBT
51	IS01	☐	OIRA_IND	CHAR1	CHAR	1	0	Subsequent process indicator for document base table
52	MM01	☐	OIRA_IND	CHAR1	CHAR	1	0	Subsequent process indicator for document base table
53	MM02	☐	OIRA_IND	CHAR1	CHAR	1	0	Subsequent process indicator for document base table
54	PC02	☐	OIRA_IND	CHAR1	CHAR	1	0	Subsequent process indicator for document base table
55	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20110901
SAP Release Created in