SE11 ABAP Dictionary SE11 VKDFS

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

VKDFS

SD Index: Billing Initiator
SAP SAP Transparent Table 18 Fields
Primary Key:
MANDT FKTYP VKORG FKDAT KUNNR FKART LLAND VBELN

Dictionary Fields Fields

(18 dari 18 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
FKTYP
KEY BillCateg. CHAR 1 - - Billing category
3
VKORG
KEY Sales org. CHAR 4 - - Sales Organization
4
FKDAT
KEY Bill. Date DATS 8 - - Billing date for billing index and printout
5
KUNNR
KEY Sold-to pt CHAR 10 - KNA1 Sold-to party
6
FKART
KEY Bill. Type CHAR 4 - - Billing Type
7
LLAND
KEY Dest. Ctry CHAR 3 - - Country of Destination
8
VBELN
KEY SD Doc. CHAR 10 - VBAK Sales and Distribution Document Number
9
VBTYP
- Doc.cat. CHAR 1 - - SD document category
10
ADRNR
- Address CHAR 10 - - Address number of the sold-to party
11
SORTKRI
- Sort term CHAR 20 - - Sort Criterion
12
FAKSK
- Bill.block CHAR 2 - - Billing block in SD document
13
VTWEG
- Distr. Chl CHAR 2 - - Distribution Channel
14
SPART
- Division CHAR 2 - - Division
15
VSTEL
- Ship Point CHAR 4 - - Shipping Point/Receiving Point
16
PDSTK
- POD status CHAR 1 - - POD status on header level
17
NETWR
- Net CURR 15 2 - Net Value in Document Currency
18
WAERK
- Currency CUKY 5 - TCURC SD Document Currency

Related References & SQL

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

Interactive ERD Diagrams
SAP SD - Billing Tables Relation → SAP SD - Sales Tables Relation → SAP SD Table Mapping & Document Flow →
Standard T-Codes
SE11 SE16
Related Tables
KNA1 VBAK TCURC VBRK VBRP VRKPA VRPMA VBSK
ANSI SQL Query 
SELECT a.FKTYP,
       a.VKORG,
       a.FKDAT,
       a.KUNNR,
       a.FKART,
       a.LLAND,
       a.VBELN
FROM VKDFS AS a
WHERE a.FKTYP = '0001'
  AND a.VKORG = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~fktyp,
       a~vkorg,
       a~fkdat,
       a~kunnr,
       a~fkart,
       a~lland,
       a~vbeln
  FROM vkdfs AS a
  WHERE a~fktyp = '0001'
  and a~vkorg = '0001'
  INTO TABLE @DATA(lt_vkdfs)
  UP TO 100 ROWS.