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