SAP ABAP Table OIHEDA (Actual line item table, IS-OIL Excise Duty Special Ledger)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIH (Package) TDP Tariffs, Duties and Permits

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIHEDA	Table Relationship Diagram
Short Description	Actual line item table, IS-OIL Excise Duty Special Ledger

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	RCLNT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	GL_SIRID	☑	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
3	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
4	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
5	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
6	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
8	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
9	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
10	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
11	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
12	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
13	DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
14	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	RWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
16	RBWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
17	RBWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
18	ROITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	*
19	ROIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
20	ROITAXFRO	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	*
21	ROITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	*
22	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
23	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
24	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
25	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
26	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
27	SBUKRS	☐	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	T001
28	SWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
29	SBWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
30	SBWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
31	SOITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	*
32	SOIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
33	SOITAXFRO	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	*
34	SOITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	*
35	SACCT	☐	PRACCT	SAKNR	CHAR	10	0	Partner account number	*
36	SBUSA	☐	PPARGB	GSBER	CHAR	4	0	Trading Partner Business Area of the Business Partner	TGSB
37	SCNTR	☐	PKOSTL	KOSTL	CHAR	10	0	Partner cost center	*
38	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
39	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
40	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
41	KSL	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
42	MSL	☐	QUAN1	MENG8	QUAN	15	3	Quantity
43	ASL	☐	QUAN2	MENG8	QUAN	15	3	Additional Quantity
44	AUNIT	☐	AUNIT	MEINS	UNIT	3	0	Additional unit of measure	T006
45	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
46	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
47	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
48	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
49	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
50	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
51	REFRYEAR	☐	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
52	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
53	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
54	REFACTIV	☐	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
55	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
56	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
57	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
58	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
59	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
60	ROIPRICIE	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	*
61	ROITXVAL0	☐	OIH_TXVAL0	OIH_TXVAL	CURR	13	2	Excise duty tax value 0
62	ROITXVAL1	☐	OIH_TXVAL1	OIH_TXVAL	CURR	13	2	Excise duty tax value 1
63	ROITXVAL2	☐	OIH_TXVAL2	OIH_TXVAL	CURR	13	2	Excise duty tax value 2
64	ROITXVAL3	☐	OIH_TXVAL3	OIH_TXVAL	CURR	13	2	Excise duty tax value 3
65	ROITXVAL4	☐	OIH_TXVAL4	OIH_TXVAL	CURR	13	2	Excise duty tax value 4
66	ROITXVAL5	☐	OIH_TXVAL5	OIH_TXVAL	CURR	13	2	Excise duty tax value 5
67	ROITXVAL6	☐	OIH_TXVAL6	OIH_TXVAL	CURR	13	2	Excise duty tax value 6
68	ROIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
69	ROITAXCON	☐	OIH_TAXCON	OIH_TAXCON	CURR	13	2	Excise duty tax from pricing conditions
70	ROITAXVAL	☐	OIH_TAXVAL	OIH_TXVAL	CURR	13	2	Excise duty value in material inventory account
71	ROIOILCON2	☐	OIH_OILCN2	OIH_OILCON	DEC	5	2	Oil content of a material as a percentage (2)
72	ROIUOMQT	☐	OIH_UOMQT	MEINS	UNIT	3	0	Base quantity for excise duty rate (e.g.per 1 or 100 UoM)	*
73	ROITAXQT	☐	OIH_TAXQT	MENGE	QUAN	13	3	Excise duty tax quantity in STBME
74	ROIFUTQT	☐	OIH_FUTQT	MENGE	QUAN	13	3	Future tax quantity
75	ROIFUTTX	☐	OIH_FUTTX	OIH_TXVAL	CURR	13	2	Future tax value
76	ROIFUTDT	☐	OIH_FUTDT	DATUM	DATS	8	0	Future tax date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIHEDA	AUNIT	T006	MSEHI	REF	C	CN
2	OIHEDA	AWTYP	TTYP	AWTYP	REF	C	CN
3	OIHEDA	DOCTY	T889	DOCTY	REF	C	CN
4	OIHEDA	LOGSYS	TBDLS	LOGSYS	REF	C	CN
5	OIHEDA	RBUKRS	T001	BUKRS	REF	C	CN
6	OIHEDA	RBUSA	TGSB	GSBER	REF	C	CN
7	OIHEDA	RCLNT	T000	MANDT	KEY	1	CN
8	OIHEDA	RFAREA	TFKB	FKBER	REF	C	CN
9	OIHEDA	RLDNR	T881	RLDNR	REF	C	CN
10	OIHEDA	RTCUR	TCURC	WAERS	REF	C	CN
11	OIHEDA	RUNIT	T006	MSEHI	REF	C	CN
12	OIHEDA	RVERS	T894	RVERS	REF	C	CN
13	OIHEDA	SBUKRS	T001	BUKRS	REF	C	CN
14	OIHEDA	SBUSA	TGSB	GSBER	REF	C	CN
15	OIHEDA	SFAREA	TFKB	FKBER	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in