SAP ABAP Table OILMCMSEG (IS-OIL data fields for MCMSEG)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_COMMON (Package) Common obj. in IS-Oil Downstream

Basic Data

Table Category	APPEND	Append structure
Append structure	OILMCMSEG	Table Relationship Diagram
Short Description	IS-OIL data fields for MCMSEG

Delivery and Maintenance

Pool/cluster	MCMSEG
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	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	OIH4
2	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	OIH4
3	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
4	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	OIH2
5	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
6	OIINVREC	☐	OIH_INVREC	X	CHAR	1	0	Indicator whether ED pricing is external (not used?)
7	OIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
8	OIOILCON2	☐	OIH_OILCN2	OIH_OILCON	DEC	5	2	Oil content of a material as a percentage (2)
9	OIFUTDT	☐	OIH_FUTDT	DATUM	DATS	8	0	Future tax date
10	OIFUTDT2	☐	OIH_FUTDT2	DATUM	DATS	8	0	Future tax date 2
11	OIUOMQT	☐	OIH_UOMQT	MEINS	UNIT	3	0	Base quantity for excise duty rate (e.g.per 1 or 100 UoM)	*
12	OITAXQT	☐	OIH_TAXQT	MENGE	QUAN	13	3	Excise duty tax quantity in STBME
13	OIFUTQT	☐	OIH_FUTQT	MENGE	QUAN	13	3	Future tax quantity
14	OITAXGRP2	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	OIH2
15	OIKNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
16	OIMATREF	☐	OIA_MATREF	OIA_MATREF	CHAR	20	0	Material group reference for exchange balance reporting
17	OIEXGPTR	☐	OIA_EXGPTR	LIFNR	CHAR	10	0	Exchange partner (vendor number)	*
18	OIMATPST	☐	OIA_MATPST	OIA_MATPST	CHAR	1	0	Posting rules for material
19	OIMATIE	☐	OIA_MATIE	OIA_MATIE	CHAR	1	0	Material internal / external posting indicator
20	OIEXGNUM	☐	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	*
21	OIEXGTYP	☐	OIA_EXGTYP	OIA_EXGTYP	CHAR	4	0	Exchange type	*
22	OIFEETOT	☐	OIA_FEETOT	OIA_FEETOT	CURR	13	2	Fee total
23	OIFEEPST	☐	OIA_FEEPST	OIA_FEEPST	CHAR	1	0	Posting rules for fees
24	OIFEEDT	☐	OIA_FEEDT	DATUM	DATS	8	0	Fee pricing condition date
25	OIEXGUPE	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
26	OISBREL	☐	OIA_SBREL	OIA_SBREL	NUMC	3	0	Sub product/ base product relevence indicator
27	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
28	OIBPQTY	☐	OIA_SBMNG	MENG15	QUAN	15	3	Base product quantity
29	OIBPMEINS	☐	OIA_SBMEIN	MEINS	UNIT	3	0	Base product quantity unit	T006
30	OIEXGSIGN	☐	OIA_EXGSGN	XFELD	CHAR	1	0	Sign for logical inventory update(override flag)
31	OIASTBW	☐	XSTBW	XFELD	CHAR	1	0	Reversal transaction type
32	OIBOMHEAD	☐	OIA_BOMHM	MATNR	CHAR	18	0	BoM header material number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OILMCMSEG	OIBPMEINS	T006	MSEHI
2	OILMCMSEG	OITAXFROM	OIH4	TAXKEY
3	OILMCMSEG	OITAXGRP	OIH2	TAXGRP
4	OILMCMSEG	OITAXGRP2	OIH2	TAXGRP
5	OILMCMSEG	OITAXTO	OIH4	TAXKEY

History

Last changed by/on	SAP	20050223
SAP Release Created in