SAP ABAP Table J_1BNFNAD (Nota Fiscal partners)

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_1BNFNAD	Table Relationship Diagram
Short Description	Nota Fiscal partners

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	PARVW	☑	J_1BPARVW	J_1BPARVW	CHAR	2	0	Nota Fiscal Partner Function	J_1BAD
4	PARID	☐	J_1BPARID	J_1BPARID	CHAR	10	0	Partner ID (Customer, Vendor, Business Place)
5	PARTYP	☐	J_1BPARTYP	J_1BPARTYP	CHAR	1	0	Nota Fiscal Partner Type
6	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
7	.INCLUDE	☐				0	0	Interface: partner name and address
8	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
9	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
10	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
11	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
12	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
13	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
14	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
15	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
16	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
17	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
18	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
19	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
20	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
21	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
22	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
23	TELF1	☐	TLFNR	TEXT30	CHAR	30	0	Addresses: telephone no.
24	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
25	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
26	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
27	INDUST	☐	J_1BINDUS1	J_1BINDUS1	CHAR	2	0	Customer's CFOP category
28	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
29	CGC	☐	J_1BCGC	J_1BCGC	NUMC	14	0	CNPJ Number
30	CPF	☐	J_1BCPF	J_1BCPF	NUMC	11	0	CPF number
31	STAINS	☐	J_1BSTAINS	J_1BSTAINS	CHAR	18	0	State Tax Number
32	MUNINS	☐	J_1BMUNINS	J_1BMUNINS	CHAR	20	0	Municipal Tax Number
33	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
34	HAUSN	☐	HAUSN_BAS	CHAR6	CHAR	6	0	House number
35	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
36	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
37	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
38	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
39	CTE_PARTNER	☐	J_1BCTE_TOMALI	J_1BCTE_TOMALI	CHAR	1	0	CT-e Partner in Fiscal Document

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1BNFNAD	DOCNUM	J_1BNFDOC	DOCNUM	KEY	1	CN
2	J_1BNFNAD	LAND1	T005	LAND1
3	J_1BNFNAD	MANDT	T000	MANDT	KEY	1	CN
4	J_1BNFNAD	PARVW	J_1BAD	PARVW	KEY	1	CN
5	J_1BNFNAD	REGIO	T005S	BLAND
6	J_1BNFNAD	SPRAS	T002	SPRAS
7	J_1BNFNAD	TXJCD	TTXJ	TXJCD	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in