SE11 ABAP Dictionary SE11 VAKPA

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

VAKPA

Sales Index: Orders by Partner Function
SAP SAP Transparent Table 19 Fields
Primary Key:
MANDT KUNDE PARVW VKORG TRVOG AUDAT VKBUR VKGRP VTWEG SPART AUART BSTNK KUNNR ERNAM VBELN

Dictionary Fields Fields

(19 dari 19 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
KUNDE
KEY Partner CHAR 10 - - Partner number (KUNNR, LIFNR, or PERNR)
3
PARVW
KEY Function CHAR 2 - - Partner Function
4
VKORG
KEY Sales org. CHAR 4 - - Sales Organization
5
TRVOG
KEY Trans.Grp CHAR 1 - - Transaction group
6
AUDAT
KEY Doc. Date DATS 8 - - Document Date (Date Received/Sent)
7
VKBUR
KEY Sales Off. CHAR 4 - - Sales Office
8
VKGRP
KEY Sales Grp CHAR 3 - - Sales Group
9
VTWEG
KEY Distr. Chl CHAR 2 - - Distribution Channel
10
SPART
KEY Division CHAR 2 - - Division
11
AUART
KEY SalesDocTy CHAR 4 - - Sales Document Type
12
BSTNK
KEY Pur. Order CHAR 20 - - Customer purchase order number
13
KUNNR
KEY Sold-to pt CHAR 10 - KNA1 Sold-to party
14
ERNAM
KEY Created CHAR 12 - - Name of Person who Created the Object
15
VBELN
KEY SD Doc. CHAR 10 - VBAK Sales and Distribution Document Number
16
ADRNR_AG
- Address CHAR 10 - - Address number of the sold-to party
17
ADRNR
- Address CHAR 10 - - Address
18
DATAB
- Valid from DATS 8 - - Quotation or contract valid from
19
DATBI
- Valid to DATS 8 - - Quotation or contract valid to

Related References & SQL

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

Interactive ERD Diagrams
SAP SD - Sales Tables Relation → SAP SD Table Mapping & Document Flow →
Standard T-Codes
SE11 SE16
Related Tables
KNA1 VBAK VBAP VBEP VBEH VBKD STXH STXL
ANSI SQL Query 
SELECT a.KUNDE,
       a.PARVW,
       a.VKORG,
       a.TRVOG,
       a.AUDAT,
       a.VKBUR,
       a.VKGRP
FROM VAKPA AS a
WHERE a.KUNDE = '0001'
  AND a.PARVW = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~kunde,
       a~parvw,
       a~vkorg,
       a~trvog,
       a~audat,
       a~vkbur,
       a~vkgrp
  FROM vakpa AS a
  WHERE a~kunde = '0001'
  and a~parvw = '0001'
  INTO TABLE @DATA(lt_vakpa)
  UP TO 100 ROWS.