SAP ABAP Table OIH_J1B_RAF (Brazil: Refinery taxation table)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TDP (Application Component) Tariffs, Duties and Permits
     ⤷ OIH_CV_BR (Package) Oil country version Brazil
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIH_J1B_RAF   Table Relationship Diagram
Short Description Brazil: Refinery taxation table    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
3 SHIPTO J_1BTXREG J_1BTXREG CHAR 3   0   Tax Region J_1BTREGX
4 OIHVTYPE OIH_J1B_VTYP OIH_J1B_VTYP CHAR 1   0   Vendor type (refinery/mill/other) (Brazil)  
5 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
6 MTXGR OIH_J1B_MTXGR OIH_J1B_MTXGR CHAR 4   0   Material tax group OIH2M_J1B
7 VALIDFROM J_1BTXDATF DATUM_INV CHAR 8   0   Date from which the tax rule is valid  
8 VALIDTO J_1BTXDATT DATUM_INV CHAR 8   0   Date to which the tax rule is valid  
9 STPR_INTRA OIH_J1BSTPR_INTRA J_1BTXRATE DEC 6   2   Sub.Trib. surcharge percentage rate intrastate  
10 STPR_INTER OIH_J1BSTPR_INTER J_1BTXRATE DEC 6   2   Sub.Trib. surcharge percentage rate interstate =gross margin  
11 TXLW1 J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS J_1BATL1
12 OIHREFST OIH_REFST_END OIH_REFST CHAR 1   0   Brazil: Refinery ST applied to end customer  
13 TXLW1_INTER J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS J_1BATL1
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIH_J1B_RAF LAND1 T005 LAND1 KEY 1 CN
2 OIH_J1B_RAF MANDT T000 MANDT KEY 1 CN
3 OIH_J1B_RAF MATNR MARA MATNR KEY 1 CN
4 OIH_J1B_RAF MTXGR OIH2M_J1B OIHMTXGR KEY 1 CN
5 OIH_J1B_RAF SHIPTO J_1BTREGX TXREG KEY 1 CN
6 OIH_J1B_RAF TXLW1 J_1BATL1 TAXLAW    
7 OIH_J1B_RAF TXLW1_INTER J_1BATL1 TAXLAW    
History
Last changed by/on SAP  20130529 
SAP Release Created in