SAP ABAP Table VBPA (Sales Document: Partner)

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	TRANSP	Transparent table
Transparent table	VBPA	Table Relationship Diagram
Short Description	Sales Document: Partner

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	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
3	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
4	PARVW	☑	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
5	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
6	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
7	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
8	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
9	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
10	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
11	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
12	ADRDA	☐	ADRDA	ADRDA	CHAR	1	0	Address indicator
13	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
14	HITYP	☐	HITYP_KH	HITYP	CHAR	1	0	Customer Hierarchy Category	THIT
15	PRFRE	☐	PRFRE	XFELD	CHAR	1	0	Relevant for Pricing ID
16	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
17	HISTUNR	☐	HISTUNR	NUM2	NUMC	2	0	Level number within hierarchy
18	KNREF	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
19	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
20	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy
21	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
22	PARVW_FF	☐	PARTNER_FF	XFELD	CHAR	1	0	Indicator 'Further Partners in this Function' (VBPA2)
23	ADRNP	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	ADRP
24	KALE	☐	KALE	KALE	CHAR	1	0	Maintain appointments in calendar

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBPA	ADRNP	ADRP	PERSNUMBER	REF	1	CN
2	VBPA	HITYP	THIT	HITYP	REF	C	CN
3	VBPA	KUNNR	KNA1	KUNNR	REF	C	CN
4	VBPA	LAND1	T005	LAND1	REF	C	CN
5	VBPA	LIFNR	LFA1	LIFNR	REF	C	CN
6	VBPA	MANDT	T000	MANDT	KEY	1	CN
7	VBPA	PARVW	TPAR	PARVW	KEY	1	CN
8	VBPA	POSNR	VBUP	POSNR	KEY	1	CN
9	VBPA	VBELN	VBUK	VBELN	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in