SAP ABAP Table J_1BNFPDET (Interface: partner name and address)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	J_1BNFPDET	Table Relationship Diagram
Short Description	Interface: partner name and address

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	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
2	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
3	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
4	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
5	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
6	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
7	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
8	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
9	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
10	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
11	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
12	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
13	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
14	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
15	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
16	TELF1	☐	TLFNR	TEXT30	CHAR	30	0	Addresses: telephone no.
17	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
18	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
19	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
20	INDUST	☐	J_1BINDUS1	J_1BINDUS1	CHAR	2	0	Customer's CFOP category
21	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
22	CGC	☐	J_1BCGC	J_1BCGC	NUMC	14	0	CNPJ Number
23	CPF	☐	J_1BCPF	J_1BCPF	NUMC	11	0	CPF number
24	STAINS	☐	J_1BSTAINS	J_1BSTAINS	CHAR	18	0	State Tax Number
25	MUNINS	☐	J_1BMUNINS	J_1BMUNINS	CHAR	20	0	Municipal Tax Number
26	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
27	HAUSN	☐	HAUSN_BAS	CHAR6	CHAR	6	0	House number
28	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
29	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
30	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
31	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1BNFPDET	LAND1	T005	LAND1
2	J_1BNFPDET	REGIO	T005S	BLAND
3	J_1BNFPDET	SPRAS	T002	SPRAS
4	J_1BNFPDET	TXJCD	TTXJ	TXJCD	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	605