SE11 ABAP Dictionary SE11 VRKPA

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

VRKPA

Sales Index: Bills by Partner Functions
SAP SAP Transparent Table 17 Fields
Primary Key:
MANDT KUNDE PARVW VKORG FKDAT VTWEG FKART KUNNR KUNAG VBTYP ERNAM VBELN

Dictionary Fields Fields

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

Related References & SQL

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

Interactive ERD Diagrams
SAP SD - Billing Tables Relation → SAP SD Table Mapping & Document Flow →
Standard T-Codes
SE11 SE16
Related Tables
KNA1 VBAK VBRK VBRP VRPMA VKDFS VBSK VBSS
ANSI SQL Query 
SELECT a.KUNDE,
       a.PARVW,
       a.VKORG,
       a.FKDAT,
       a.VTWEG,
       a.FKART,
       a.KUNNR
FROM VRKPA AS a
WHERE a.KUNDE = '0001'
  AND a.PARVW = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~kunde,
       a~parvw,
       a~vkorg,
       a~fkdat,
       a~vtweg,
       a~fkart,
       a~kunnr
  FROM vrkpa AS a
  WHERE a~kunde = '0001'
  and a~parvw = '0001'
  INTO TABLE @DATA(lt_vrkpa)
  UP TO 100 ROWS.