SAP ABAP Table OIREUPLPXXXX (SSR PC: DTF table for item information)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
     ⤷ OIR_E (Package) SSR Card processing (IS-Oil Sevice Station Retailing)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIREUPLPXXXX	Table Relationship Diagram
Short Description	SSR PC: DTF table for item information

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	.INCLUDE	☑				0	0	Key item fields for the DTF table
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	UPLNR	☑	OIRE_UPLNR	CHAR10	CHAR	10	0	SSR PC: DTF payment card transaction number (internal)
5	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
6	.INCLUDE	☐				0	0	Item fields of the DTF table
7	BLMNR	☐	OIRE_BLMNR	CHAR18	CHAR	18	0	SSR PC: Material group/number at the business location
8	STYP	☐	OIRA_STYP	OIRA_STYP	CHAR	4	0	Service type	OIRASTYP
9	MENGE	☐	OIRE_MENGE	MENG13V	QUAN	13	3	SSR PC: Quantity sold at the business location
10	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
11	BRTPR	☐	OIRE_BRTPR	WERTV6	CURR	11	2	SSR PC: price (rate per unit of measure) of the article
12	BRTWR	☐	OIRE_BRTWR	WERTV7	CURR	13	2	SSR PC: Gross value
13	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	EANNR	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
15	KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	*
16	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
17	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
18	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
19	DCIND	☐	OIRE_DCIND_ITM	OIRE_DCIND	CHAR	1	0	SSR PC: DTF Debit/credit item indicator for a PC transaction
20	LINKYEAR	☐	OIRA_JAHR	GJAHR	NUMC	4	0	Document link number year
21	LINKNR	☐	OIRA_LINKNR	NUMC10	NUMC	10	0	Link number
22	ITLINKNR	☐	OIRA_ITLINKNR	POSNR	NUMC	6	0	Item link number	*
23	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIREUPLPXXXX	MANDT	T000	MANDT
2	OIREUPLPXXXX	MATNR	MARA	MATNR
3	OIREUPLPXXXX	STYP	OIRASTYP	STYP
4	OIREUPLPXXXX	VRKME	T006	MSEHI

History

Last changed by/on	SAP	20050224
SAP Release Created in