SE11 ABAP Dictionary SE11 VBUK

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

VBUK

Sales Document: Header Status and Administrative Data
SAP SD Transparent Table 81 Fields
Primary Key:
MANDT VBELN

Dictionary Fields Fields

(81 dari 81 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
VBELN
KEY SD Doc. CHAR 10 - VBAK Sales and Distribution Document Number
3
RFSTK
- Refer.stat CHAR 1 - - Reference document header status
4
RFGSK
- TotRefStat CHAR 1 - - Total reference status of all items
5
BESTK
- Confirmed CHAR 1 - - Confirmation status
6
LFSTK
- Dlv.status CHAR 1 - - Delivery status
7
LFGSK
- OverallDlv CHAR 1 - - Overall delivery status for all items
8
WBSTK
- GoodsMvt CHAR 1 - - Total goods movement status
9
FKSTK
- BillStatus CHAR 1 - - Billing status
10
FKSAK
- BillStatOr CHAR 1 - - Billing status (order-related billing document)
11
BUCHK
- PostngStat CHAR 1 - - Posting Status of Billing Document
12
ABSTK
- Rej.status CHAR 1 - - Overall rejection status of all document items
13
GBSTK
- OverallSt. CHAR 1 - - Overall processing status of document
14
KOSTK
- Ovr.PickSt CHAR 1 - - Overall picking / putaway status
15
LVSTK
- TotStat WM CHAR 1 - - Overall status of warehouse management activities
16
UVALS
- Item data CHAR 1 - - Total incompletion status of all items in general
17
UVVLS
- ItemDlvDat CHAR 1 - - Total incompletion status of all items: Delivery
18
UVFAS
- ItemBilDat CHAR 1 - - Total incompletion status of all items: Billing
19
UVALL
- HeaderData CHAR 1 - - General incompletion status of the header
20
UVVLK
- HeadDlvDat CHAR 1 - - Header incompletion status concerning delivery
21
UVFAK
- HeadBilDat CHAR 1 - - Header incompletion status with respect to billing
22
UVPRS
- Pricing CHAR 1 - - Document is incomplete with respect to pricing
23
VBTYP
- Doc.cat. CHAR 1 - - SD document category
24
VBOBJ
- Object CHAR 1 - - SD document object
25
AEDAT
- Chngd DATS 8 - - Changed On
26
FKIVK
- TotStatus CHAR 1 - - Billing totals status for intercompany billing
27
RELIK
- InvLstStat CHAR 1 - - Invoice list status of billing document
28
UVK01
- HdrRes1 CHAR 1 - - Customer reserves 1: Header status
29
UVK02
- HdrRes2 CHAR 1 - - Customer reserves 2: Header status
30
UVK03
- HdrRes3 CHAR 1 - - Customer reserves 3: Header status
31
UVK04
- HdrRes4 CHAR 1 - - Custmer reserves 4: Header status
32
UVK05
- HdrRes5 CHAR 1 - - Customer reserves 5: Header status
33
UVS01
- TotalRes1 CHAR 1 - - Customer reserves 1: Sum of all items
34
UVS02
- TotlRes2 CHAR 1 - - Customer reserves 2: Sum of all items
35
UVS03
- TotlRes3 CHAR 1 - - Customer reserves 3: Sum of all items
36
UVS04
- TotlRes4 CHAR 1 - - Customer reserves 4: Sum of all items
37
UVS05
- TotlRes5 CHAR 1 - - Customer reserves 5: Sum of all items
38
PKSTK
- PackStatus CHAR 1 - - Overall packing status of all items
39
CMPSA
- Static CHAR 1 - - Status of static credit limit check
40
CMPSB
- Dynamic CHAR 1 - - Status of dynamic credit limit check in the credit horizon
41
CMPSC
- Value CHAR 1 - - Status of credit check against maximum document value
42
CMPSD
- Pmnt terms CHAR 1 - - Status of credit check against terms of payment
43
CMPSE
- Customer CHAR 1 - - Status of credit check against customer review date
44
CMPSF
- Open items CHAR 1 - - Status of credit check against open items due
45
CMPSG
- OldestItem CHAR 1 - - Status of credit check against oldest open items
46
CMPSH
- Dunn.Level CHAR 1 - - Status of credit check against highest dunning level
47
CMPSI
- Fin. doc. CHAR 1 - - Status of credit check against financial document
48
CMPSJ
- ExptCredIn CHAR 1 - - Status of credit check against export credit insurance
49
CMPSK
- Paymt card CHAR 1 - - Status of credit check against payment card authorization
50
CMPSL
- Reserve CHAR 1 - - Status of credit check of reserves 4
51
CMPS0
- Reserve CHAR 1 - - Status of credit check for customer reserve 1
52
CMPS1
- Reserve CHAR 1 - - Status of credit check for customer reserve 2
53
CMPS2
- Reserve CHAR 1 - - Status of credit check for customer reserve 3
54
CMGST
- CredStatus CHAR 1 - - Overall status of credit checks
55
TRSTA
- TrnsPlnSta CHAR 1 - - Transportation planning status
56
KOQUK
- Confirmat. CHAR 1 - - Status of pick confirmation
57
COSTA
- ConfStatus CHAR 1 - - Confirmation status for ALE
58
SAPRL
- Release CHAR 4 - - SAP Release
59
UVPAS
- ItDataPckg CHAR 1 - - Totals incomplete status for all items: packaging
60
UVPIS
- ItDataPkg CHAR 1 - - Totals incomplete status for all items: Picking
61
UVWAS
- ItmData:GM CHAR 1 - - Total incomplete status of all items: post goods movement
62
UVPAK
- Head.pckg CHAR 1 - - Header incomplete status for packaging
63
UVPIK
- Head.pick. CHAR 1 - - Header incomplete status for picking/putaway
64
UVWAK
- Head.GM CHAR 1 - - Post header incomplete status for goods movement
65
UVGEK
- HeadDngGds CHAR 1 - - UNUSED
66
CMPSM
- Obsolete CHAR 1 - - Credit check data is obsolete
67
DCSTK
- Delay stat CHAR 1 - - Delay status
68
VESTK
- HU in stk CHAR 1 - - Handling Unit Placed in Stock
69
VLSTK
- Stat.Whse CHAR 1 - - Distribution Status (Decentralized Warehouse Processing)
70
RRSTA
- RD status CHAR 1 - - Revenue determination status
71
BLOCK
- Indicator: Document preselected for archiving CHAR 1 - - Indicator: Document preselected for archiving
72
FSSTK
- OvBBlkStat CHAR 1 - - Overall billing block status
73
LSSTK
- Dlv. blk CHAR 1 - - Overall delivery block status
74
SPSTG
- Block st. CHAR 1 - - Overall blocked status
75
PDSTK
- POD status CHAR 1 - - POD status on header level
76
FMSTK
- FM status CHAR 1 - - Status Funds Management
77
MANEK
- Completion CHAR 1 - - Manual Completion of Contract
78
SPE_TMPID
- T CHAR 1 - - Temporary inbound delivery
79
HDALL
- H CHAR 1 - - Inbound delivery header not yet complete (on Hold)
80
HDALS
- H CHAR 1 - - At least one of ID items not yet complete (on Hold)
81
CMPS_CM
- SAP CrMa CHAR 1 - - Status of Credit Check SAP Credit Management

Related References & SQL

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

Interactive ERD Diagrams
SAP SD - Billing Tables Relation → SAP SD - Sales Tables Relation → SAP SD - Shipping Tables Relation → SAP SD Table Mapping & Document Flow →
Standard T-Codes
VA03 VL03N VKM3
Related Tables
VBAK VBRK VBRP VRKPA VRPMA VKDFS VBSK VBSS
ANSI SQL Query 
SELECT a.VBELN,
       a.RFSTK,
       a.RFGSK,
       a.BESTK,
       a.LFSTK,
       a.LFGSK
FROM VBUK AS a
WHERE a.VBELN = '0000004987';
ABAP OpenSQL (7.40+) 
SELECT a~vbeln,
       a~rfstk,
       a~rfgsk,
       a~bestk,
       a~lfstk,
       a~lfgsk
  FROM vbuk AS a
  WHERE a~vbeln = '0000004987'
  INTO TABLE @DATA(lt_vbuk)
  UP TO 100 ROWS.