SAP ABAP Table TIVBPVENDORGEN (Vendor Preassignment (General Data))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-BP (Application Component) Business Partner
     ⤷ RE_BP_BP (Package) RE: Business Partner

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TIVBPVENDORGEN	Table Relationship Diagram
Short Description	Vendor Preassignment (General Data)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	*
2	APPL	☑	REBPAPPL	BP_APPL	CHAR	4	0	Business Partner: Application Category	TPZ12
3	.INCLUDE	☐				0	0	Vendor Master (General Section)
4	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
5	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
6	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
7	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
8	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
9	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
10	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
11	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
12	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
13	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
14	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
15	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
16	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
17	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
18	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	T077K
19	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
20	LNRZA	☐	LNRZA	LIFNR	CHAR	10	0	Account Number of the Alternative Payee	LFA1
21	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
22	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
23	SPERM	☐	SPERM_X	XFELD	CHAR	1	0	Centrally imposed purchasing block
24	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
25	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
26	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
27	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
28	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
29	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
30	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
31	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
32	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
33	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
34	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
35	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
36	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
37	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
38	FISKN	☐	FISKN_K	LIFNR	CHAR	10	0	Account number of the master record with fiscal address	LFA1
39	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
40	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
41	SPERQ	☐	QSPERRFKT	QSPERRFKT	CHAR	2	0	Function That Will Be Blocked	TQ04A
42	GBORT	☐	GBORT_Q	TEXT25	CHAR	25	0	Place of birth of the person subject to withholding tax
43	GBDAT	☐	GBDAT_Q	DATUM	DATS	8	0	Date of birth of the person subject to withholding tax
44	SEXKZ	☐	SEXKZ	SEXKZ	CHAR	1	0	Key for the Sex of the Person Subject to Withholding Tax
45	KRAUS	☐	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
46	REVDB	☐	REVDB_CM	DATUM	DATS	8	0	Last review (external)
47	QSSYS	☐	QSSYS_IST	QSSYSFAM	CHAR	4	0	Vendor's QM system	TQ02B
48	KTOCK	☐	KTOCK	KTOKK	CHAR	4	0	Reference Account Group for One-Time Account (Vendor)	T077K
49	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
50	WERKS	☐	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)	*
51	LTSNA	☐	LTSNA	XFELD	CHAR	1	0	Indicator: vendor sub-range relevant
52	WERKR	☐	WERKR	XFELD	CHAR	1	0	Indicator: plant level relevant
53	PLKAL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
54	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
55	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
56	SPERZ	☐	SPERZ	XFELD	CHAR	1	0	Payment Block
57	SCACD	☐	SCACD	SCACD	CHAR	4	0	Standard carrier access code
58	SFRGR	☐	SFRGR	SFRGR	CHAR	4	0	Forwarding Agent Freight Group	TSFG
59	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
60	XLFZA	☐	XLFZA	XFELD	CHAR	1	0	Indicator: Alternative payee using account number
61	DLGRP	☐	DLGRP	DLGRP	CHAR	4	0	Service agent procedure group	TVFCD
62	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
63	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	J_1ATODC
64	REGSS	☐	J_1AREGSS	XFELD	CHAR	1	0	Registered for Social Insurance
65	ACTSS	☐	J_1AACTSS	J_1AACTSS	CHAR	3	0	Activity Code for Social Insurance	J_1AACT
66	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
67	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
68	IPISP	☐	J_1BINDEQU	XFELD	CHAR	1	0	Tax Split
69	TAXBS	☐	TAXBS	TAXBS	NUMC	1	0	Tax Base in Percentage
70	PROFS	☐	PROFS	TEXT30	CHAR	30	0	Profession
71	STGDL	☐	STGDL	STGDL	CHAR	2	0	Shipment: statistics group, transportation service agent	VTSGD
72	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
73	LFURL	☐	URL	TEXT132	CHAR	132	0	Uniform resource locator
74	J_1KFREPRE	☐	REPRES	REPRES	CHAR	10	0	Name of Representative
75	J_1KFTBUS	☐	GESTYP	GESTYP	CHAR	30	0	Type of Business	BUSTYPE
76	J_1KFTIND	☐	INDTYP	INDTYP	CHAR	30	0	Type of Industry	INDUSTYPE
77	CONFS	☐	CONFS_X	CHAR1	CHAR	1	0	Status of Change Authorization (Central)
78	UPDAT	☐	UPDAT_RF	DATUM	DATS	8	0	Date on Which the Changes Were Confirmed
79	UPTIM	☐	UPTIM_RF	AS4TIME	TIMS	6	0	Time of Last Change Confirmation
80	NODEL	☐	NODEL_X	XFELD	CHAR	1	0	Central deletion block for master record
81	QSSYSDAT	☐	QQSSYSDAT	QQSSYSDAT	DATS	8	0	Validity date of certification
82	PODKZB	☐	PODKZB	PODKZB	CHAR	1	0	Vendor indicator relevant for proof of delivery
83	FISKU	☐	FISKU	LIFNR	CHAR	10	0	Account Number of Master Record of Tax Office Responsible	LFA1
84	STENR	☐	STENR	CHAR18	CHAR	18	0	Tax Number at Responsible Tax Authority

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TIVBPVENDORGEN	ACTSS	J_1AACT	J_1AACT		1	CN
2	TIVBPVENDORGEN	APPL	TPZ12	APPL	KEY	1	CN
3	TIVBPVENDORGEN	BRSCH	T016	BRSCH	REF	C	CN
4	TIVBPVENDORGEN	DLGRP	TVFCD	DLGRP	REF	1	CN
5	TIVBPVENDORGEN	FISKN	LFA1	LIFNR	REF	C	CN
6	TIVBPVENDORGEN	FISKU	LFA1	LIFNR	KEY	C	CN
7	TIVBPVENDORGEN	FITYP	J_1AFITP	J_1AFITP		1	CN
8	TIVBPVENDORGEN	J_1KFTBUS	BUSTYPE	GESTYP	REF	C	CN
9	TIVBPVENDORGEN	J_1KFTIND	INDUSTYPE	INDTYPE	REF	C	CN
10	TIVBPVENDORGEN	KTOCK	T077K	KTOKK	REF	C	CN
11	TIVBPVENDORGEN	KTOKK	T077K	KTOKK	REF	1	CN
12	TIVBPVENDORGEN	KUNNR	KNA1	KUNNR	REF	C	CN
13	TIVBPVENDORGEN	LNRZA	LFA1	LIFNR	REF	C	CN
14	TIVBPVENDORGEN	LZONE	TZONE	ZONE1	REF	C	CN
15	TIVBPVENDORGEN	PLKAL	TFACD	IDENT	REF	C	CN
16	TIVBPVENDORGEN	QSSYS	TQ02B	QSSYSFAM	REF	C	CN
17	TIVBPVENDORGEN	SFRGR	TSFG	SFRGR	REF	C	CN
18	TIVBPVENDORGEN	SPERQ	TQ04A	SPERRFKT	REF	1	CN
19	TIVBPVENDORGEN	SPRAS	T002	SPRAS	REF	1	CN
20	TIVBPVENDORGEN	STCDT	J_1ATODC	J_1ATODC		1	CN
21	TIVBPVENDORGEN	STGDL	VTSGD	STGDL
22	TIVBPVENDORGEN	TXJCD	TTXJ	TXJCD	REF	C	CN
23	TIVBPVENDORGEN	VBUND	T880	RCOMP	REF	C	CN

History

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