SAP ABAP Table J_1BNFSTX (Nota Fiscal tax per item)

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_1BNFSTX	Table Relationship Diagram
Short Description	Nota Fiscal tax per item

Delivery and Maintenance

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

History

Last changed by/on	SAP	20131127
SAP Release Created in