SAP ABAP Table OIH_J1B_SAL (Brazil: Check table for tax codes in sales process)
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_SAL   Table Relationship Diagram
Short Description Brazil: Check table for tax codes in sales process    
Delivery and Maintenance
Pool/cluster      
Delivery Class G   Customizing table, protected against SAP Upd., only INS all. 
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 *
2 INT_OP OIH_J1B_INT OIH_J1B_OPER_SALES CHAR 1   0   Inter / intra operation type  
3 OIHVTYPE OIH_J1B_VTYP OIH_J1B_VTYP CHAR 1   0   Vendor type (refinery/mill/other) (Brazil)  
4 CUST_GROUP OIH_J1B_CTXGR OIH_J1B_CTXGR CHAR 4   0   Customer tax group OIH2C_J1B
5 MAT_TAX_GR OIH_J1B_MTXGR OIH_J1B_MTXGR CHAR 4   0   Material tax group OIH2M_J1B
6 PRICE_CONTROL OIH_J1B_PR_CNTRL XFELD CHAR 1   0   Price controlled  
7 TAXATION_ORIG OIH_J1B_TAX_ORIG XFELD CHAR 1   0   Taxation at origin  
8 TAXATION_DEST OIH_J1B_TAX_DEST XFELD CHAR 1   0   Taxation at destination  
9 OIHCV03 OIH_CONV_03 XFELD CHAR 1   0   Convenio 03  
10 OIHCV80O OIH_CONV_80O XFELD CHAR 1   0   Convenio 80 at origin  
11 OIHCV80D OIH_CONV_80D XFELD CHAR 1   0   Convenio 80 at destin.  
12 ZONA_FRANCA OIH_J1B_ZFR XFELD CHAR 1   0   Flag indicating whether operation involves Zona Franca  
13 ORDER_TYPE AUART AUART CHAR 4   0   Sales Document Type TVAK
14 ITEM_CAT PSTYV PSTYV CHAR 4   0   Sales document item category TVPT
15 TAX_CODE J_1BTXSDC_ J_1BTXSDC CHAR 2   0   SD tax code J_1BTXSDC
16 OIHCREDIPI OIH_J1B_TXCREDIP ANKREUZ CHAR 1   0   IPI credit allowed  
17 DEFAULT_TXCD OIH_J1B_TX_DEFAULT XFELD CHAR 1   0   Default Tax Code for Brazil Localization  
18 TXLW1 J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS J_1BATL1
19 TXLW2 J_1BTAXLW2 J_1BTAXLW2 CHAR 3   0   Tax law: IPI J_1BATL2
20 LEG_CLAIM OIH_J1B_ICREF XFELD CHAR 1   0   Indicator: customer is legal claimant for this case  
21 PUR_NOTAX OIH_J1B_PURNOTAX XFELD CHAR 1   0   Indicator: for this oper. no tax paid when purchasing  
22 PISCOF_EXC OIH_J1B_PICO_EXC XFELD CHAR 1   0   PIS/COFINS exception for reading OIH_J1B_PIS  
23 TXLW4 J_1BTAXLW4 J_1BTAXLW4 CHAR 3   0   COFINS Tax Law J_1BATL4A
24 TXLW5 J_1BTAXLW5 J_1BTAXLW5 CHAR 3   0   PIS Tax Law J_1BATL5
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIH_J1B_SAL CUST_GROUP OIH2C_J1B OIHCTXGR 1 CN
2 OIH_J1B_SAL ITEM_CAT TVPT PSTYV    
3 OIH_J1B_SAL MAT_TAX_GR OIH2M_J1B OIHMTXGR 1 CN
4 OIH_J1B_SAL ORDER_TYPE TVAK AUART 1 CN
5 OIH_J1B_SAL TAX_CODE J_1BTXSDC TAXCODE 1 CN
6 OIH_J1B_SAL TXLW1 J_1BATL1 TAXLAW    
7 OIH_J1B_SAL TXLW2 J_1BATL2 TAXLAW    
8 OIH_J1B_SAL TXLW4 J_1BATL4A TAXLAW    
9 OIH_J1B_SAL TXLW5 J_1BATL5 TAXLAW    
History
Last changed by/on SAP  20080505 
SAP Release Created in