SAP ABAP Table VBPAVB (Reference structure for XVBPA/YVBPA)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ (Package) Application development R/3 RV central functions

Basic Data

Table Category	INTTAB	Structure
Structure	VBPAVB	Table Relationship Diagram
Short Description	Reference structure for XVBPA/YVBPA

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	Sales Document: Partner
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
4	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
5	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
6	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
7	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
8	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
9	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
10	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
11	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
12	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
13	ADRDA	☐	ADRDA	ADRDA	CHAR	1	0	Address indicator
14	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
15	HITYP	☐	HITYP_KH	HITYP	CHAR	1	0	Customer Hierarchy Category	THIT
16	PRFRE	☐	PRFRE	XFELD	CHAR	1	0	Relevant for Pricing ID
17	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
18	HISTUNR	☐	HISTUNR	NUM2	NUMC	2	0	Level number within hierarchy
19	KNREF	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
20	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
21	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy
22	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
23	PARVW_FF	☐	PARTNER_FF	XFELD	CHAR	1	0	Indicator 'Further Partners in this Function' (VBPA2)
24	ADRNP	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	ADRP
25	KALE	☐	KALE	KALE	CHAR	1	0	Maintain appointments in calendar
26	.INCLUDE	☐				0	0	Sales Document Partner: Dynamic Part
27	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
28	.INCLUDE	☐				0	0	Sales Document Partner: Dynamic Part
29	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
30	NRART	☐	NRART	NRART	CHAR	2	0	Type of partner number	TVPA
31	FEHGR	☐	FEHGR	FEHGR	CHAR	2	0	Incompletion procedure for sales document	TVUV
32	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
33	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
34	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
35	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
36	CNTPA	☐	CNT_PARVW	INT6	NUMC	6	0	Counter for partner functions
37	REFOBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
38	REFOBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
39	REFLOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
40	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
41	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
42	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
43	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
44	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
45	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	*
46	J_1KFREPRE	☐	REPRES	REPRES	CHAR	10	0	Name of Representative
47	J_1KFTBUS	☐	GESTYP	GESTYP	CHAR	30	0	Type of Business	*
48	J_1KFTIND	☐	INDTYP	INDTYP	CHAR	30	0	Type of Industry	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBPAVB	ADRNP	ADRP	PERSNUMBER	REF	1	CN
2	VBPAVB	FEHGR	TVUV	FEHGR
3	VBPAVB	HITYP	THIT	HITYP	REF	C	CN
4	VBPAVB	KUNNR	KNA1	KUNNR	REF	C	CN
5	VBPAVB	LAND1	T005	LAND1	REF	C	CN
6	VBPAVB	LIFNR	LFA1	LIFNR	REF	C	CN
7	VBPAVB	MANDT	T000	MANDT	KEY	1	CN
8	VBPAVB	NRART	TVPA	NRART
9	VBPAVB	PARVW	TPAR	PARVW	KEY	1	CN
10	VBPAVB	POSNR	VBUP	POSNR	KEY	1	CN
11	VBPAVB	SPRAS	T002	SPRAS
12	VBPAVB	VBELN	VBUK	VBELN	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in