SAP ABAP Table OIHEDP (Plan 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	OIHEDP	Table Relationship Diagram
Short Description	Plan 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	RPMAX	☐	RPMAX	RPMAX	NUMC	3	0	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	TSLVT	☐	TSLVT9	WERTV9	CURR	17	2	Balance carried forward in transaction currency
40	TSL01	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
41	TSL02	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
42	TSL03	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
43	TSL04	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
44	TSL05	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
45	TSL06	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
46	TSL07	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
47	TSL08	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
48	TSL09	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
49	TSL10	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
50	TSL11	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
51	TSL12	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
52	TSL13	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
53	TSL14	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
54	TSL15	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
55	TSL16	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
56	HSLVT	☐	HSLVT9	WERTV9	CURR	17	2	Balance carried forward in local currency
57	HSL01	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
58	HSL02	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
59	HSL03	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
60	HSL04	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
61	HSL05	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
62	HSL06	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
63	HSL07	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
64	HSL08	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
65	HSL09	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
66	HSL10	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
67	HSL11	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
68	HSL12	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
69	HSL13	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
70	HSL14	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
71	HSL15	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
72	HSL16	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
73	KSLVT	☐	KSLVT9	WERTV9	CURR	17	2	Balance carried forward in group currency
74	KSL01	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
75	KSL02	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
76	KSL03	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
77	KSL04	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
78	KSL05	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
79	KSL06	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
80	KSL07	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
81	KSL08	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
82	KSL09	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
83	KSL10	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
84	KSL11	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
85	KSL12	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
86	KSL13	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
87	KSL14	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
88	KSL15	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
89	KSL16	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
90	MSLVT	☐	MSLVT	MENGV8	QUAN	15	3	Balance carried forward of quantity
91	MSL01	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
92	MSL02	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
93	MSL03	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
94	MSL04	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
95	MSL05	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
96	MSL06	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
97	MSL07	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
98	MSL08	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
99	MSL09	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
100	MSL10	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
101	MSL11	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
102	MSL12	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
103	MSL13	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
104	MSL14	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
105	MSL15	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
106	MSL16	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
107	ASLVT	☐	ASLVT	MENGV8	QUAN	15	3	Balance carried forward of additional quantity
108	ASL01	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
109	ASL02	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
110	ASL03	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
111	ASL04	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
112	ASL05	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
113	ASL06	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
114	ASL07	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
115	ASL08	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
116	ASL09	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
117	ASL10	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
118	ASL11	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
119	ASL12	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
120	ASL13	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
121	ASL14	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
122	ASL15	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
123	ASL16	☐	ASLXX	MENGV8	QUAN	15	3	Total of transactions of period in additional quantities
124	AUNIT	☐	AUNIT	MEINS	UNIT	3	0	Additional unit of measure	T006
125	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
126	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
127	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
128	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
129	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
130	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
131	REFRYEAR	☐	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
132	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
133	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
134	REFACTIV	☐	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
135	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
136	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
137	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
138	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
139	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in