SAP ABAP Table J_1BPRNFESTX (Print fiscal document - taxes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC-BR (Application Component) Brazil
     ⤷ J1BA (Package) Localization Brazil

Basic Data

Table Category	INTTAB	Structure
Structure	J_1BPRNFESTX	Table Relationship Diagram
Short Description	Print fiscal document - taxes

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Nota Fiscal tax per item
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	DOCNUM	☐	J_1BDOCNUM	J_1BDOCNUM	NUMC	10	0	Document Number	J_1BNFDOC
4	ITMNUM	☐	J_1BITMNUM	J_1BITMNUM	NUMC	6	0	Document Item Number
5	TAXTYP	☐	J_1BTAXTYP	J_1BTAXTYP	CHAR	4	0	Tax Type	J_1BAJ
6	BASE	☐	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
7	RATE	☐	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
8	TAXVAL	☐	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
9	EXCBAS	☐	J_1BEXCBAS	J_1BEXCBAS	CURR	15	2	Excluded base amount
10	OTHBAS	☐	J_1BOTHBAS	J_1BOTHBAS	CURR	15	2	Other base amount
11	STATTX	☐	J_1BSTATTX	XFELD	CHAR	1	0	Indicator: Statistical tax item
12	RECTYPE	☐	J_1BTXRT	J_1BTXRT	CHAR	1	0	Nota Fiscal tax record type
13	FACTOR	☐	J_1BTXIPF	DEC4_2	DEC	6	2	Number of units
14	UNIT	☐	J_1BTXIPU	MEINS	UNIT	3	0	Pauta Unit	T006
15	TAX_LOC	☐	J_1BTXJCD	J_1BTXJCD	CHAR	15	0	Tax Jurisdiction Code For Brazilian Tax Calculation	J_1BTXJUR
16	SERVTYPE_IN	☐	J_1BSERVTYPE_IN	J_1BSERVTYPE_IN	CHAR	16	0	Official Service Type for Brazil (Incoming)	J_1BSERVTYPES1
17	SERVTYPE_OUT	☐	J_1BSERVTYPE_OUT	J_1BSERVTYPE_OUT	CHAR	16	0	Official Service Type for Brazil (Outgoing)	J_1BSERVTYPES2
18	WITHHOLD	☐	J_1BTXWHT	XFELD	CHAR	1	0	Withholding Tax (Brazil)
19	TAXINNET	☐	J_1BTAXINNET	XFELD	CHAR	1	0	Tax Already Included in Net Value
20	WHTCOLLCODE	☐	J_1BWHTCOLL	WITHCD2	CHAR	16	0	Official Withholding Tax Collection Code
21	BASERED1	☐	J_1BTXBASE	J_1BTXBASE	DEC	6	2	Tax base (%)
22	BASERED2	☐	J_1BTXBASE	J_1BTXBASE	DEC	6	2	Tax base (%)
23	RATE4DEC	☐	J_1BTXRATE4DEC	J_1BTXRATE4DEC	DEC	8	4	Tax Rate with 4 Decimal Places
24	FACTOR4DEC	☐	J_1BTXPF4DEC	DEC4_2	DEC	6	2	Number of Units for Pauta with 4 DP (for Reporting Only)
25	UNIT4DEC	☐	J_1BTXPU4DEC	MEINS	UNIT	3	0	UoM for Pauta with 4 Decimal Places (for Reporting Only)	*
26	TAX_DIFFERENCE	☐	J_1BTXDIFF	J_1BTAXVAL	CURR	15	2	Tax difference used for NF item calculation (PIS/COFINS)
27	SRATE	☐	J_1BTXSTPR	J_1BTXRATE	DEC	6	2	Sub.Trib. surcharge percentage rate
28	PAUTA_BASE	☐	J_1BTXPAUTA_BASE_4DEC	J_1BQUAN_16_4	QUAN	16	4	Pauta Base Four Decimals
29	TAXGRP	☐	J_1BTAXGRP	J_1BTAXGRP	CHAR	4	0	Tax group
30	TAXOFF	☐	J_1BTAXOFFSET	XFELD	CHAR	1	0	Offset condition for tax calculation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1BPRNFESTX	DOCNUM	J_1BNFDOC	DOCNUM	KEY	1	CN
2	J_1BPRNFESTX	MANDT	T000	MANDT	KEY	1	CN
3	J_1BPRNFESTX	SERVTYPE_IN	J_1BSERVTYPES1	SERVTYPE_IN	KEY	1	CN
4	J_1BPRNFESTX	SERVTYPE_OUT	J_1BSERVTYPES2	SERVTYPE_OUT	KEY	1	CN
5	J_1BPRNFESTX	TAXTYP	J_1BAJ	TAXTYP	KEY	1	CN
6	J_1BPRNFESTX	TAX_LOC	J_1BTXJUR	TAXJURCODE	KEY	1	CN
7	J_1BPRNFESTX	UNIT	T006	MSEHI	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in	607