SE11 ABAP Dictionary SE11 VAPMA

Popular:

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

VAPMA

Sales Index: Order Items by Material

SAP SAP Transparent Table 19 Fields

Primary Key:

MANDT MATNR VKORG TRVOG AUDAT VTWEG SPART AUART KUNNR VKBUR VKGRP BSTNK ERNAM VBELN POSNR

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	MATNR	KEY	Material	CHAR	18	-	MARA	Material Number
3	VKORG	KEY	Sales org.	CHAR	4	-	-	Sales Organization
4	TRVOG	KEY	Trans.Grp	CHAR	1	-	-	Transaction group
5	AUDAT	KEY	Doc. Date	DATS	8	-	-	Document Date (Date Received/Sent)
6	VTWEG	KEY	Distr. Chl	CHAR	2	-	-	Distribution Channel
7	SPART	KEY	Division	CHAR	2	-	-	Division
8	AUART	KEY	SalesDocTy	CHAR	4	-	-	Sales Document Type
9	KUNNR	KEY	Sold-to pt	CHAR	10	-	KNA1	Sold-to party
10	VKBUR	KEY	Sales Off.	CHAR	4	-	-	Sales Office
11	VKGRP	KEY	Sales Grp	CHAR	3	-	-	Sales Group
12	BSTNK	KEY	Pur. Order	CHAR	20	-	-	Customer purchase order number
13	ERNAM	KEY	Created	CHAR	12	-	-	Name of Person who Created the Object
14	VBELN	KEY	SD Doc.	CHAR	10	-	VBAK	Sales and Distribution Document Number
15	POSNR	KEY	Item	NUMC	6	-	-	Item number of the SD document
16	WERKS	-	Plant	CHAR	4	-	T001W	Plant
17	ADRNR	-	Address	CHAR	10	-	-	Address number of the sold-to party
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 VAPMA.

Interactive ERD Diagrams

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

Standard T-Codes

SE11 SE16

Related Tables

MARA KNA1 VBAK T001W VBAP VBEP VBEH VBKD

ANSI SQL Query

SELECT a.MATNR,
       a.VKORG,
       a.TRVOG,
       a.AUDAT,
       a.VTWEG,
       a.SPART,
       a.AUART
FROM VAPMA AS a
WHERE a.MATNR = 'FG-100'
  AND a.VKORG = '0001';

ABAP OpenSQL (7.40+)

SELECT a~matnr,
       a~vkorg,
       a~trvog,
       a~audat,
       a~vtweg,
       a~spart,
       a~auart
  FROM vapma AS a
  WHERE a~matnr = 'fg-100'
  and a~vkorg = '0001'
  INTO TABLE @DATA(lt_vapma)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VAPMA

VAPMA

Dictionary Fields Fields

Related References & SQL