SAP ABAP Table OIHEDT (Summary 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 OIHEDT   Table Relationship Diagram
Short Description Summary 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 RLDNR RLDNR RLDNR CHAR 2   0   Ledger T881
3 RRCTY RRCTY RRCTY CHAR 1   0   Record Type  
4 RVERS RVERS RVERS CHAR 3   0   Version T894
5 RYEAR GJAHR GJAHR NUMC 4   0   Fiscal Year  
6 ROBJNR GOBJNR_R OBJNR CHAR 18   0   Object number for objects (account assignment elements)  
7 COBJNR GOBJNR_C OBJNR CHAR 18   0   Object number for transaction attributes  
8 SOBJNR GOBJNR_S OBJNR CHAR 18   0   Object number for partner objects (accnt assignmnt elements)  
9 RTCUR RTCUR WAERS CUKY 5   0   Currency Key TCURC
10 RUNIT MEINS MEINS UNIT 3   0   Base Unit of Measure T006
11 DRCRK SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
12 RPMAX RPMAX RPMAX NUMC 3   0   Period  
13 RBUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
14 RWERKS WERKS_D WERKS CHAR 4   0   Plant *
15 RBWART BWART BWART CHAR 3   0   Movement type (inventory management) *
16 RBWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type *
17 ROITAXGRP OIH_TAXGRP OIH_TAXGRP CHAR 2   0   Excise Duty Group *
18 ROIHANTYP OIH_HANTYP OIH_HANTYP CHAR 2   0   Excise Duty Handling Type *
19 ROITAXFRO OIH_TAXFRO OIH_TAXKEY CHAR 2   0   Excise duty tax key for 'from' location *
20 ROITAXTO OIH_TAXTO OIH_TAXKEY CHAR 2   0   Excise duty tax key for 'to' location *
21 RACCT RACCT SAKNR CHAR 10   0   Account Number *
22 RBUSA GSBER GSBER CHAR 4   0   Business Area TGSB
23 RCNTR KOSTL KOSTL CHAR 10   0   Cost Center *
24 RFAREA FKBER FKBER CHAR 16   0   Functional Area TFKB
25 LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system TBDLS
26 SBUKRS PBUKRS BUKRS CHAR 4   0   Company code of partner T001
27 SWERKS WERKS_D WERKS CHAR 4   0   Plant *
28 SBWART BWART BWART CHAR 3   0   Movement type (inventory management) *
29 SBWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type *
30 SOITAXGRP OIH_TAXGRP OIH_TAXGRP CHAR 2   0   Excise Duty Group *
31 SOIHANTYP OIH_HANTYP OIH_HANTYP CHAR 2   0   Excise Duty Handling Type *
32 SOITAXFRO OIH_TAXFRO OIH_TAXKEY CHAR 2   0   Excise duty tax key for 'from' location *
33 SOITAXTO OIH_TAXTO OIH_TAXKEY CHAR 2   0   Excise duty tax key for 'to' location *
34 SACCT PRACCT SAKNR CHAR 10   0   Partner account number *
35 SBUSA PPARGB GSBER CHAR 4   0   Trading Partner Business Area of the Business Partner TGSB
36 SCNTR PKOSTL KOSTL CHAR 10   0   Partner cost center *
37 SFAREA SFKBER FKBER CHAR 16   0   Partner Functional Area TFKB
38 TSLVT TSLVT9 WERTV9 CURR 17   2   Balance carried forward in transaction currency  
39 TSL01 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
40 TSL02 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
41 TSL03 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
42 TSL04 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
43 TSL05 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
44 TSL06 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
45 TSL07 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
46 TSL08 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
47 TSL09 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
48 TSL10 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
49 TSL11 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
50 TSL12 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
51 TSL13 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
52 TSL14 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
53 TSL15 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
54 TSL16 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
55 HSLVT HSLVT9 WERTV9 CURR 17   2   Balance carried forward in local currency  
56 HSL01 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
57 HSL02 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
58 HSL03 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
59 HSL04 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
60 HSL05 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
61 HSL06 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
62 HSL07 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
63 HSL08 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
64 HSL09 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
65 HSL10 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
66 HSL11 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
67 HSL12 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
68 HSL13 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
69 HSL14 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
70 HSL15 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
71 HSL16 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
72 KSLVT KSLVT9 WERTV9 CURR 17   2   Balance carried forward in group currency  
73 KSL01 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
74 KSL02 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
75 KSL03 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
76 KSL04 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
77 KSL05 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
78 KSL06 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
79 KSL07 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
80 KSL08 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
81 KSL09 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
82 KSL10 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
83 KSL11 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
84 KSL12 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
85 KSL13 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
86 KSL14 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
87 KSL15 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
88 KSL16 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
89 MSLVT MSLVT MENGV8 QUAN 15   3   Balance carried forward of quantity  
90 MSL01 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
91 MSL02 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
92 MSL03 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
93 MSL04 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
94 MSL05 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
95 MSL06 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
96 MSL07 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
97 MSL08 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
98 MSL09 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
99 MSL10 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
100 MSL11 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
101 MSL12 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
102 MSL13 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
103 MSL14 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
104 MSL15 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
105 MSL16 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
106 ASLVT ASLVT MENGV8 QUAN 15   3   Balance carried forward of additional quantity  
107 ASL01 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
108 ASL02 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
109 ASL03 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
110 ASL04 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
111 ASL05 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
112 ASL06 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
113 ASL07 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
114 ASL08 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
115 ASL09 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
116 ASL10 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
117 ASL11 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
118 ASL12 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
119 ASL13 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
120 ASL14 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
121 ASL15 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
122 ASL16 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
123 AUNIT AUNIT MEINS UNIT 3   0   Additional unit of measure T006
124 CSPRED CSPRED SPRED CHAR 4   0   Distribution key for currency amounts T821S
125 QSPRED QSPRED SPRED CHAR 4   0   Distribution key for quantities T821S
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIHEDT AUNIT T006 MSEHI REF C CN
2 OIHEDT CSPRED T821S SPRED REF C CN
3 OIHEDT LOGSYS TBDLS LOGSYS REF C CN
4 OIHEDT QSPRED T821S SPRED REF C CN
5 OIHEDT RBUKRS T001 BUKRS REF C CN
6 OIHEDT RBUSA TGSB GSBER REF C CN
7 OIHEDT RCLNT T000 MANDT KEY 1 CN
8 OIHEDT RFAREA TFKB FKBER REF C CN
9 OIHEDT RLDNR T881 RLDNR KEY 1 CN
10 OIHEDT RTCUR TCURC WAERS KEY 1 CN
11 OIHEDT RUNIT T006 MSEHI KEY 1 CN
12 OIHEDT RVERS T894 RVERS KEY 1 CN
13 OIHEDT SBUKRS T001 BUKRS REF C CN
14 OIHEDT SBUSA TGSB GSBER REF C CN
15 OIHEDT SFAREA TFKB FKBER REF C CN
History
Last changed by/on SAP  20050224 
SAP Release Created in