SAP ABAP Table OIH_J1B_PPR (Brazil Tax: Pondered average price table for final consume)
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_PPR   Table Relationship Diagram
Short Description Brazil Tax: Pondered average price table for final consume    
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 TXREG 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 PRICE OIH_J1B_PMPF_PRICE OIH_J1B_PRICE DEC 15   4   PMPF price  
10 FACTOR J_1BTXSTF DEC4_2 DEC 6   2   Number of units for Sub.Trib. calc. (price per n units)  
11 UNIT OIH_J1B_PRUNIT MEINS UNIT 3   0   Unit for price (Brazil tax) *
12 TXLW1 J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS J_1BATL1
13 OIHREFST OIH_REFST_END OIH_REFST CHAR 1   0   Brazil: Refinery ST applied to end customer  
14 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_PPR LAND1 T005 LAND1 KEY 1 CN
2 OIH_J1B_PPR MANDT T000 MANDT KEY 1 CN
3 OIH_J1B_PPR MATNR MARA MATNR    
4 OIH_J1B_PPR MTXGR OIH2M_J1B OIHMTXGR KEY 1 CN
5 OIH_J1B_PPR TXLW1 J_1BATL1 TAXLAW    
6 OIH_J1B_PPR TXLW1_INTER J_1BATL1 TAXLAW    
7 OIH_J1B_PPR TXREG J_1BTREGX TXREG KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 46C