SE11 ABAP Dictionary SE11 VBLK

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

VBLK

SD Document: Delivery Note Header
SAP SD Transparent Table 12 Fields
Primary Key:
MANDT VBELN

Dictionary Fields Fields

(12 dari 12 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
VBELN
KEY Delivery CHAR 10 - VBAK Delivery
3
LFART
- Del. type CHAR 4 - - Delivery Type
4
VSTEL
- Ship Point CHAR 4 - - Shipping Point/Receiving Point
5
LFDAT
- Deliv.date DATS 8 - - Delivery date
6
FKDAT
- Bill. Date DATS 8 - - Billing date for billing index and printout
7
LDDAT
- Loadg Date DATS 8 - - Loading Date
8
WADAT
- GI Date DATS 8 - - Goods Issue Date
9
TDDAT
- TrpPlanDt DATS 8 - - Transportation Planning Date
10
KBDAT
- PO date DATS 8 - - Purchase order date
11
ROUTE
- Prop.route CHAR 6 - - Proposed delivery route
12
ROUTI
- Act.route CHAR 6 - - Actual delivery route

Related References & SQL

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

Interactive ERD Diagrams
SAP SD - Shipping Tables Relation → SAP SD Table Mapping & Document Flow →
Standard T-Codes
SE11 SE16
Related Tables
VBAK LIKP LIPS VTTP VTTK VEPO VEKP VTFA
ANSI SQL Query 
SELECT a.VBELN,
       a.LFART,
       a.VSTEL,
       a.LFDAT,
       a.FKDAT,
       a.LDDAT
FROM VBLK AS a
WHERE a.VBELN = '0000004987';
ABAP OpenSQL (7.40+) 
SELECT a~vbeln,
       a~lfart,
       a~vstel,
       a~lfdat,
       a~fkdat,
       a~lddat
  FROM vblk AS a
  WHERE a~vbeln = '0000004987'
  INTO TABLE @DATA(lt_vblk)
  UP TO 100 ROWS.