SAP ABAP Table OIH_J1B_PIC (Brazil: Printing exceptions for ICMS)
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_PIC   Table Relationship Diagram
Short Description Brazil: Printing exceptions for ICMS    
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 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
6 CGROUP OIH_J1B_CTXGR OIH_J1B_CTXGR CHAR 4   0   Customer tax group OIH2C_J1B
7 TAXTYPE OIH_J1B_TXTYP OIH_J1B_TXTYP CHAR 1   0   General taxation type for sub. trib.  
8 OPTYPE OIH_J1B_INT OIH_J1B_OPER_SALES CHAR 1   0   Inter / intra operation type  
9 VALIDFROM J_1BTXDATF DATUM_INV CHAR 8   0   Date from which the tax rule is valid  
10 VALIDTO J_1BTXDATT DATUM_INV CHAR 8   0   Date to which the tax rule is valid  
11 PRINT_AT OIH_J1B_IPRINT OIH_J1B_IPRINT CHAR 1   0   Indicator where to print ICMS  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIH_J1B_PIC CGROUP OIH2C_J1B OIHCTXGR    
2 OIH_J1B_PIC KUNNR KNA1 KUNNR KEY 1 CN
3 OIH_J1B_PIC LAND1 T005 LAND1 KEY 1 CN
4 OIH_J1B_PIC MANDT T000 MANDT KEY 1 CN
5 OIH_J1B_PIC TXREG J_1BTREGX TXREG KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in