SE11 ABAP Dictionary SE11 VBLB

Data SE16 SE16

VBLB

Sales document: Release order data
SAP SD Transparent Table 57 Fields
Primary Key:
MANDT VBELN POSNR ABRLI ABART

Dictionary Fields Fields

(57 dari 57 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
ABRLI
KEY IntDlvScNo NUMC 4 - - Internal delivery schedule number
5
ABART
KEY Rel.type CHAR 1 - - Release type
6
DOCNUM
- IDoc no. NUMC 16 - - IDoc number
7
ABEFZ
- CmlQtyRcvd QUAN 15 3 - Cumulative Quantity Received by Customer
8
ABRAB
- Valid from DATS 8 - - Dlv. sched. valid from
9
ABRBI
- Valid to DATS 8 - - SA rel. valid to
10
LABNK
- Dlv.sched. CHAR 17 - - Customer number for forecast / JIT dlv. sched.
11
ABRDT
- DlvSchDate DATS 8 - - Delivery Schedule Date
12
TERSL
- Dates CHAR 1 - - Date key for schedule line dates
13
LFDKD
- LastDlvDte DATS 8 - - Date of last delivery posted by the customer
14
LFNKD
- Last dlv. CHAR 10 - - Last delivery confirmed by the customer
15
ABFDA
- StartProd. DATS 8 - - Start of production go-ahead
16
ABFDE
- EndProd. DATS 8 - - End of production go-ahead
17
ABMDA
- StartMatGA DATS 8 - - Start of material go-ahead
18
ABMDE
- End MatGA DATS 8 - - End of material go-ahead
19
ABLLI
- Last ROr NUMC 4 - - Last internal release order number
20
HIFFZ
- HighCmlPQt QUAN 15 3 - Highest cumulative production go-ahead quantity
21
HIFFZLI
- SchedPCmlQ NUMC 4 - - Internal schedule no.for highest prod.go-ahead cml.qty
22
HIMFZ
- HghstCMQty QUAN 15 3 - Highest cumulative material go-ahead quantity
23
HIMFZLI
- SchdMCmlQy NUMC 4 - - Internal schedule number for highest mat.go-ahead cml.qty
24
ERDAT
- On DATS 8 - - Date on Which Record Was Created
25
ERZEI
- Time TIMS 6 - - Entry time
26
ERNAM
- Created CHAR 12 - - Name of Person who Created the Object
27
HILFZ
- HghstDGAQt QUAN 15 3 - Highest delivery go-ahead cumulative quantity
28
HILFZLI
- Schd.DGAQt NUMC 4 - - Internal schedule number for highest dlv.go-ahead cml.qty
29
ABHOR
- JIT hor. DATS 8 - - JIT horizon
30
GJKUN
- Fisc.year NUMC 4 - - Customer fiscal year
31
VJKUN
- Prev.year NUMC 4 - - Customer fiscal year which is not yet closed
32
AKMFZ
- ActCMGoAhQ QUAN 15 3 - Actual cumulative material go-ahead quantity
33
AKFFZ
- ActlCPGoAQ QUAN 15 3 - Actual cumulative production go-ahead quantity
34
AKLFZ
- ActCDlvGoQ QUAN 15 3 - Actual cumulative delivery go-ahead quantity
35
KRITB
- HPrioStock CHAR 1 - - Key for high priority stock
36
LABKY
- Req.status CHAR 1 - - Requirements status key
37
VBRST
- ConsumpPnt CHAR 14 - - Customer point of consumption
38
EDLLS
- Issue CHAR 20 - - Last dlv. note sent by ext. service agent to the customer
39
EDLDT
- ExtAgtDate DATS 8 - - Date of last delivery sent by external agent to customer
40
LFMKD
- LastDlvQty QUAN 13 3 - Last delivery quantity received by the customer
41
UMVKZ
- Numerator DEC 5 - - Numerator (factor) for conversion of sales quantity into SKU
42
UMVKN
- Denominat. DEC 5 - - Denominator (Divisor) for Conversion of Sales Qty into SKU
43
USR01
- Data 1 CHAR 35 - - Additional data field 1 for delivery schedules
44
USR02
- Data 2 CHAR 35 - - Additional data field 2 for delivery schedules
45
USR03
- Data 3 CHAR 35 - - Additional data field 3 for delivery schedules
46
USR04
- Data 4 CHAR 10 - - Additional data field 4 for delivery schedules
47
USR05
- Data 5 CHAR 10 - - Additional data field 5 for delivery schedules
48
CYEFZ
- CQ at zero QUAN 15 3 - Cumulative quantity reached on date zero setting made
49
CYDAT
- Zero date DATS 8 - - Date on which cumulative received quantity set to zero
50
MFLAUF
- Mat.Go.Val NUMC 3 - - Material go-ahead - validity period
51
MFEIN
- MtlGoUnit CHAR 1 - - Material go-ahead - unit validity period
52
FFLAUF
- PrGo-ValPd NUMC 3 - - Production go-ahead - validity period
53
FFEIN
- ProdGoUnit CHAR 1 - - Production go-ahead - Unit validity period
54
ABRDT_ORG
- DlvSchDate DATS 8 - - Delivery schedule date of creation
55
LFMAIS
- PUS number CHAR 20 - - Last pick-up sheet sent by the customer
56
MAIDT
- PUS date DATS 8 - - Date of last pick-up sheet
57
AEDAT
- Chngd DATS 8 - - Changed On

Related References & SQL

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

Standard T-Codes
ANSI SQL Query
SELECT a.VBELN,
       a.POSNR,
       a.ABRLI,
       a.ABART,
       a.DOCNUM,
       a.ABEFZ,
       a.ABRAB
FROM VBLB AS a
WHERE a.VBELN = '0000004987'
  AND a.POSNR = '0001';
ABAP OpenSQL (7.40+)
SELECT a~vbeln,
       a~posnr,
       a~abrli,
       a~abart,
       a~docnum,
       a~abefz,
       a~abrab
  FROM vblb AS a
  WHERE a~vbeln = '0000004987'
  and a~posnr = '0001'
  INTO TABLE @DATA(lt_vblb)
  UP TO 100 ROWS.
Mencari di seluruh SAP Knowledge Hub...
Tidak ditemukan hasil untuk ""
Cek "" langsung di Kamus SE11