SAP ABAP Table J_1BTXPIS (Tax Calculation: PIS)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC-BR (Application Component) Brazil
     ⤷ J1BA (Package) Localization Brazil
Basic Data
Table Category TRANSP    Transparent table 
Transparent table J_1BTXPIS   Table Relationship Diagram
Short Description Tax Calculation: PIS    
Delivery and Maintenance
Pool/cluster      
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
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 CLIENT MANDT MANDT CLNT 3   0   Client T000
2 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
3 GRUOP J_1BTXGRP J_1BTXGRP NUMC 2   0   Tax Group for Dynamic Tax Exceptions J_1BTXGRUOP
4 VALUE J_1BVALUE J_1BVALUE CHAR 20   0   Dynamic Key Field  
5 VALUE2 J_1BVALUE2 J_1BVALUE2 CHAR 20   0   Dynamic Key Field  
6 VALUE3 J_1BVALUE3 J_1BVALUE3 CHAR 20   0   Dynamic Key Field  
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 RATE J_1BTXRATE J_1BTXRATE DEC 6   2   Tax Rate  
10 BASE J_1BTXBASE J_1BTXBASE DEC 6   2   Tax base (%)  
11 AMOUNT J_1BTXCPA J_1BTXRATE DEC 6   2   COFINS Rate Per Unit (Pauta)  
12 FACTOR J_1BTXCPF DEC4_2 DEC 6   2   COFINS Number of Units  
13 UNIT J_1BTXCPU MEINS UNIT 3   0   COFINS Pauta Unit T006
14 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
15 TAXLAW J_1BTAXLW5 J_1BTAXLW5 CHAR 3   0   PIS Tax Law J_1BATL5
16 RATE4DEC J_1BTXRATE4DEC J_1BTXRATE4DEC DEC 8   4   Tax Rate with 4 Decimal Places  
17 AMOUNT4DEC J_1BAMOUNT4DEC J_1BTXRATE4DEC DEC 8   4   Rate Per Unit (Pauta) with 4 Decimal Places  
18 FACTOR4DEC J_1BTXPF4DEC DEC4_2 DEC 6   2   Number of Units for Pauta with 4 DP (for Reporting Only)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 J_1BTXPIS CLIENT T000 MANDT    
2 J_1BTXPIS COUNTRY T005 LAND1    
3 J_1BTXPIS GRUOP J_1BTXGRUOP GRUOP 1 CN
4 J_1BTXPIS TAXLAW J_1BATL5 TAXLAW KEY 1 CN
5 J_1BTXPIS UNIT T006 MSEHI    
6 J_1BTXPIS WAERS TCURC WAERS KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 606