SAP ABAP Table OIH_J1B_APR (Brazil tax: Acquisition price 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_APR   Table Relationship Diagram
Short Description Brazil tax: Acquisition price 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 PLANT WERKS_D WERKS CHAR 4   0   Plant T001W
3 TXREG J_1BTXREG J_1BTXREG CHAR 3   0   Tax Region J_1BTREGX
4 PRODUCT MATNR MATNR CHAR 18   0   Material Number MARA
5 MTXGR OIH_J1B_MTXGR OIH_J1B_MTXGR CHAR 4   0   Material tax group OIH2M_J1B
6 VENDOR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
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 APRICE OIH_J1B_APRICE OIH_J1B_PRICE DEC 15   4   Acquisition price per unit  
10 APRICE_P OIH_J1B_APRICE_P OIH_J1B_PRICE DEC 15   4   Acq.price including charges per unit  
11 FACTOR J_1BTXSTF DEC4_2 DEC 6   2   Number of units for Sub.Trib. calc. (price per n units)  
12 UNIT OIH_J1B_PRUNIT MEINS UNIT 3   0   Unit for price (Brazil tax) T006
13 OPTYPE OIH_J1B_INT OIH_J1B_OPER_SALES CHAR 1   0   Inter / intra operation type  
14 LOWEST_APR OIH_J1B_LOWEST_APR XFELD CHAR 1   0   Indicator lowest Acquisition price  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIH_J1B_APR MANDT T000 MANDT KEY 1 CN
2 OIH_J1B_APR MTXGR OIH2M_J1B OIHMTXGR KEY 1 CN
3 OIH_J1B_APR PLANT T001W WERKS KEY 1 CN
4 OIH_J1B_APR PRODUCT MARA MATNR KEY 1 CN
5 OIH_J1B_APR TXREG J_1BTREGX TXREG    
6 OIH_J1B_APR UNIT T006 MSEHI KEY 1 CN
7 OIH_J1B_APR VENDOR LFA1 LIFNR    
History
Last changed by/on SAP  20110901 
SAP Release Created in