SE11 ABAP Dictionary SE11 VRPMA

Popular:

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

VRPMA

SD Index: Billing Items per Material

SAP SAP Transparent Table 16 Fields

Primary Key:

MANDT MATNR VKORG FKDAT VTWEG FKART KUNNR KUNAG VBTYP 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	FKDAT	KEY	Bill. Date	DATS	8	-	-	Billing date for billing index and printout
5	VTWEG	KEY	Distr. Chl	CHAR	2	-	-	Distribution Channel
6	FKART	KEY	Bill. Type	CHAR	4	-	-	Billing Type
7	KUNNR	KEY	Payer	CHAR	10	-	KNA1	Payer
8	KUNAG	KEY	Sold-to pt	CHAR	10	-	-	Sold-to party
9	VBTYP	KEY	Doc.cat.	CHAR	1	-	-	SD document category
10	ERNAM	KEY	Created	CHAR	12	-	-	Name of Person who Created the Object
11	VBELN	KEY	Bill.Doc.	CHAR	10	-	VBAK	Billing Document
12	POSNR	KEY	Item	NUMC	6	-	-	Billing item
13	FKTYP	-	BillCateg.	CHAR	1	-	-	Billing category
14	ADRNR	-	Address	CHAR	10	-	-	Address nummer of the payer
15	BELNR	-	DocumentNo	CHAR	10	-	-	Accounting Document Number
16	GJAHR	-	Fiscal Yr	NUMC	4	-	-	Fiscal Year

Related References & SQL

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

Interactive ERD Diagrams

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

Standard T-Codes

SE11 SE16

Related Tables

MARA KNA1 VBAK VBRK VBRP VRKPA VKDFS VBSK

ANSI SQL Query

SELECT a.MATNR,
       a.VKORG,
       a.FKDAT,
       a.VTWEG,
       a.FKART,
       a.KUNNR,
       a.KUNAG
FROM VRPMA AS a
WHERE a.MATNR = 'FG-100'
  AND a.VKORG = '0001';

ABAP OpenSQL (7.40+)

SELECT a~matnr,
       a~vkorg,
       a~fkdat,
       a~vtweg,
       a~fkart,
       a~kunnr,
       a~kunag
  FROM vrpma AS a
  WHERE a~matnr = 'fg-100'
  and a~vkorg = '0001'
  INTO TABLE @DATA(lt_vrpma)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VRPMA

VRPMA

Dictionary Fields Fields

Related References & SQL