SE11 ABAP Dictionary SE11 VBEH

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

VBEH

Schedule line history
SAP SD Transparent Table 11 Fields
Primary Key:
MANDT VBELN POSNR ETENR ABRLI ABART

Dictionary Fields Fields

(11 dari 11 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
VBELN
KEY Sales Doc. CHAR 10 - VBAK Sales Document
3
POSNR
KEY Item NUMC 6 - - Sales Document Item
4
ETENR
KEY Schd. Line NUMC 4 - - Delivery Schedule Line Number
5
ABRLI
KEY IntDlvScNo NUMC 4 - - Internal delivery schedule number
6
ABART
KEY Rel.type CHAR 1 - - Release type
7
PRGRS
- Date type CHAR 1 - - Date type (day, week, month, interval)
8
EZEIT
- Arriv.time TIMS 6 - - Arrival time
9
EDATU
- Dlv.Date DATS 8 - - Schedule line date
10
WMENG
- Order qty QUAN 13 3 - Order quantity in sales units
11
ETART
- SchdLiType CHAR 1 - - Schedule line type EDI

Related References & SQL

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

Interactive ERD Diagrams
SAP SD - Sales Tables Relation → SAP SD Table Mapping & Document Flow →
Standard T-Codes
SE11 SE16
Related Tables
VBAK VBAP VBEP VBKD STXH STXL VBPA VAPMA
ANSI SQL Query 
SELECT a.VBELN,
       a.POSNR,
       a.ETENR,
       a.ABRLI,
       a.ABART,
       a.PRGRS,
       a.EZEIT
FROM VBEH AS a
WHERE a.VBELN = '0000004987'
  AND a.POSNR = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~vbeln,
       a~posnr,
       a~etenr,
       a~abrli,
       a~abart,
       a~prgrs,
       a~ezeit
  FROM vbeh AS a
  WHERE a~vbeln = '0000004987'
  and a~posnr = '0001'
  INTO TABLE @DATA(lt_vbeh)
  UP TO 100 ROWS.