SE11 ABAP Dictionary SE11 VBPA

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

VBPA

Sales Document: Partner

SAP SD Transparent Table 24 Fields

Primary Key:

MANDT VBELN POSNR PARVW

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	VBELN	KEY	SD Doc.	CHAR	10	-	VBAK	Sales and Distribution Document Number
3	POSNR	KEY	Item	NUMC	6	-	-	Item number of the SD document
4	PARVW	KEY	Function	CHAR	2	-	-	Partner Function
5	KUNNR	-	Customer	CHAR	10	-	KNA1	Customer Number 1
6	LIFNR	-	Vendor	CHAR	10	-	LFA1	Account Number of Vendor or Creditor
7	PERNR	-	Pers.No.	NUMC	8	-	-	Personnel Number
8	PARNR	-	Partner	NUMC	10	-	-	Number of contact person
9	ADRNR	-	Address	CHAR	10	-	-	Address
10	ABLAD	-	Unl. Point	CHAR	25	-	-	Unloading Point
11	LAND1	-	Country	CHAR	3	-	T005	Country Key
12	ADRDA	-	Adress ID	CHAR	1	-	-	Address indicator
13	XCPDK	-	One-time	CHAR	1	-	-	Indicator: Is the account a one-time account?
14	HITYP	-	CustHType	CHAR	1	-	-	Customer hierarchy type
15	PRFRE	-	Price det.	CHAR	1	-	-	Relevant for price determination ID
16	BOKRE	-	Rebate	CHAR	1	-	-	Indicator: Customer Is Rebate-Relevant
17	HISTUNR	-	Hier.level	NUMC	2	-	-	Level number within hierarchy
18	KNREF	-	PartnDescr	CHAR	30	-	-	Customer description of partner (plant, storage location)
19	LZONE	-	Zone	CHAR	10	-	-	Transportation zone to or from which the goods are delivered
20	HZUOR	-	HierAssign	NUMC	2	-	-	Assignment to Hierarchy
21	STCEG	-	VAT Reg.No	CHAR	20	-	-	VAT Registration Number
22	PARVW_FF	-	F.partners	CHAR	1	-	-	Indicator 'further partners in this function' (VBPA2)
23	ADRNP	-	Person	CHAR	10	-	-	Person number
24	KALE	-	Appointm.	CHAR	1	-	-	Maintain appointments in calendar

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk VBPA.

Interactive ERD Diagrams

SAP SD - Sales Tables Relation → SAP SD Table Mapping & Document Flow →

Standard T-Codes

VA03 VA02

Related Tables

VBAK KNA1 LFA1 T005 VBAP VBEP VBEH VBKD

ANSI SQL Query

SELECT a.VBELN,
       a.POSNR,
       a.PARVW,
       a.KUNNR,
       a.LIFNR,
       a.PERNR,
       a.PARNR
FROM VBPA AS a
WHERE a.VBELN = '0000004987'
  AND a.POSNR = '0001';

ABAP OpenSQL (7.40+)

SELECT a~vbeln,
       a~posnr,
       a~parvw,
       a~kunnr,
       a~lifnr,
       a~pernr,
       a~parnr
  FROM vbpa AS a
  WHERE a~vbeln = '0000004987'
  and a~posnr = '0001'
  INTO TABLE @DATA(lt_vbpa)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VBPA

VBPA

Dictionary Fields Fields

Related References & SQL