SAP ABAP Table OIHSLA (TDP (excise duty) special ledger actual line item table)

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	OIHSLA	Table Relationship Diagram
Short Description	TDP (excise duty) special ledger actual line item 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	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	☐	DOCLN	DOCLN	CHAR	3	0	Document line
14	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
16	RBWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
17	RWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
18	ROITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	OIH2
19	ROIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
20	ROITAXFRO	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	OIH4
21	ROITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	OIH4
22	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
23	ROIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
24	ROITXVAL0	☐	OIH_TXVAL0	OIH_TXVAL	CURR	13	2	Excise duty tax value 0
25	ROITXVAL1	☐	OIH_TXVAL1	OIH_TXVAL	CURR	13	2	Excise duty tax value 1
26	ROITXVAL2	☐	OIH_TXVAL2	OIH_TXVAL	CURR	13	2	Excise duty tax value 2
27	ROITXVAL3	☐	OIH_TXVAL3	OIH_TXVAL	CURR	13	2	Excise duty tax value 3
28	ROITXVAL4	☐	OIH_TXVAL4	OIH_TXVAL	CURR	13	2	Excise duty tax value 4
29	ROITXVAL5	☐	OIH_TXVAL5	OIH_TXVAL	CURR	13	2	Excise duty tax value 5
30	ROITXVAL6	☐	OIH_TXVAL6	OIH_TXVAL	CURR	13	2	Excise duty tax value 6
31	ROIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
32	ROITAXCON	☐	OIH_TAXCON	OIH_TAXCON	CURR	13	2	Excise duty tax from pricing conditions
33	ROITAXVAL	☐	OIH_TAXVAL	OIH_TXVAL	CURR	13	2	Excise duty value in material inventory account
34	ROIOILCON2	☐	OIH_OILCN2	OIH_OILCON	DEC	5	2	Oil content of a material as a percentage (2)
35	ROIUOMQT	☐	OIH_UOMQT	MEINS	UNIT	3	0	Base quantity for excise duty rate (e.g.per 1 or 100 UoM)	T006
36	ROITAXQT	☐	OIH_TAXQT	MENGE	QUAN	13	3	Excise duty tax quantity in STBME
37	ROIFUTQT	☐	OIH_FUTQT	MENGE	QUAN	13	3	Future tax quantity
38	ROIFUTTX	☐	OIH_FUTTX	OIH_TXVAL	CURR	13	2	Future tax value
39	ROIFUTDT	☐	OIH_FUTDT	DATUM	DATS	8	0	Future tax date
40	ROIFUTQT2	☐	OIH_FUTQT2	MENGE	QUAN	13	3	Future tax quantity 2
41	ROIFUTTX2	☐	OIH_FUTTX2	OIH_TXVAL	CURR	13	2	Future tax value 2
42	ROIFUTDT2	☐	OIH_FUTDT2	DATUM	DATS	8	0	Future tax date 2
43	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
44	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
45	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
46	KSL	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
47	MSL	☐	QUAN1	MENG8	QUAN	15	3	Quantity
48	AUNIT	☐	AUNIT	MEINS	UNIT	3	0	Additional unit of measure	T006
49	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
50	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
51	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
52	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
53	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
54	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
55	REFDOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
56	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
57	REFDOCLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
58	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
59	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
60	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
61	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
62	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
63	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
64	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
65	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIHSLA	AUNIT	T006	MSEHI	REF	C	CN
2	OIHSLA	DOCTY	T889	DOCTY	REF	C	CN
3	OIHSLA	LOGSYS	TBDLS	LOGSYS	REF	C	CN
4	OIHSLA	RBUKRS	T001	BUKRS	REF	C	CN
5	OIHSLA	RBUSA	TGSB	GSBER	REF	C	CN
6	OIHSLA	RBWTAR	T149D	BWTAR	REF	C	CN
7	OIHSLA	RCLNT	T000	MANDT	KEY	1	CN
8	OIHSLA	RLDNR	T881	RLDNR	REF	C	CN
9	OIHSLA	ROIHANTYP	OIH5	HANTYP	REF	C	CN
10	OIHSLA	ROITAXFRO	OIH4	TAXKEY	REF	C	CN
11	OIHSLA	ROITAXGRP	OIH2	TAXGRP	REF	C	CN
12	OIHSLA	ROITAXTO	OIH4	TAXKEY	REF	C	CN
13	OIHSLA	ROIUOMQT	T006	MSEHI	REF	C	CN
14	OIHSLA	RTCUR	TCURC	WAERS	REF	C	CN
15	OIHSLA	RUNIT	T006	MSEHI	REF	C	CN
16	OIHSLA	RVERS	T894	RVERS	REF	C	CN
17	OIHSLA	RWERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in