SE11 ABAP Dictionary SE11 VBUP

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

VBUP

Sales Document: Item Status
SAP SD Transparent Table 43 Fields
Primary Key:
MANDT VBELN POSNR

Dictionary Fields Fields

(43 dari 43 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
POSNR
KEY Item NUMC 6 - - Item number of the SD document
4
RFSTA
- Ref.status CHAR 1 - - Reference status
5
RFGSA
- Ref.status CHAR 1 - - Overall status of reference
6
BESTA
- Confirmed CHAR 1 - - Confirmation Status of Document Item
7
LFSTA
- Dlv.status CHAR 1 - - Delivery status
8
LFGSA
- Dlv.status CHAR 1 - - Overall delivery status of the item
9
WBSTA
- GoodsMovmt CHAR 1 - - Goods movement status
10
FKSTA
- BillStatus CHAR 1 - - Billing status of delivery-related billing documents
11
FKSAA
- BillStatus CHAR 1 - - Billing Status for Order-Related Billing Documents
12
ABSTA
- Rej.status CHAR 1 - - Rejection status for SD item
13
GBSTA
- Overall.st CHAR 1 - - Overall processing status of the SD document item
14
KOSTA
- Pick.stat CHAR 1 - - Picking status/Putaway status
15
LVSTA
- WM status CHAR 1 - - Status of warehouse management activities
16
UVALL
- Item CHAR 1 - - General Incompletion Status of Item
17
UVVLK
- ItemDlvDat CHAR 1 - - Incompletion status of the item with regard to delivery
18
UVFAK
- ItemBilDat CHAR 1 - - Item Incompletion Status with Respect to Billing
19
UVPRS
- Pricing CHAR 1 - - Pricing for item is incomplete
20
FKIVP
- Interco.BS CHAR 1 - - Intercompany Billing Status
21
UVP01
- ItemRes1 CHAR 1 - - Customer reserves 1: Item status
22
UVP02
- ItemRes2 CHAR 1 - - Customer reserves 2: Item status
23
UVP03
- ItemRes3 CHAR 1 - - Item reserves 3: Item status
24
UVP04
- ItemRes4 CHAR 1 - - Item reserves 4: Item status
25
UVP05
- ItemRes5 CHAR 1 - - Customer reserves 5: Item status
26
PKSTA
- PackStatus CHAR 1 - - Packing status of item
27
KOQUA
- Confirmat. CHAR 1 - - Confirmation status of picking/putaway
28
COSTA
- ConfStatus CHAR 1 - - Confirmation status for ALE
29
CMPPI
- Fin. doc. CHAR 1 - - Status of credit check against financial document
30
CMPPJ
- ExptCredIn CHAR 1 - - Status of credit check against export credit insurance
31
UVPIK
- ItDataPick CHAR 1 - - Incomplete status of item for picking/putaway
32
UVPAK
- ItDataPckg CHAR 1 - - Incomplete status of item for packaging
33
UVWAK
- ItmData:GM CHAR 1 - - Incomplete status of item regarding goods issue
34
DCSTA
- Delay stat CHAR 1 - - Delay status
35
RRSTA
- RD status CHAR 1 - - Revenue determination status
36
VLSTP
- Dectr.whse CHAR 1 - - Decentralized whse processing
37
FSSTA
- BBlockStat CHAR 1 - - Billing block status for items
38
LSSTA
- DlvBlkStat CHAR 1 - - Delivery block status for item
39
PDSTA
- POD status CHAR 1 - - POD status on item level
40
MANEK
- Completion CHAR 1 - - Manual Completion of Contract
41
HDALL
- DlyItmNC CHAR 1 - - Inbound Delivery Item Not Yet Complete (on Hold)
42
LTSPS
- LTSPS CHAR 1 - - Indicator : stockable type switched into standard product
43
MILL_VS_VSSTA
- Status CHAR 1 - - Status of sales order item

Related References & SQL

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

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
SE11 SE16
Related Tables
VBAK VBRK VBRP VRKPA VRPMA VKDFS VBSK VBSS
ANSI SQL Query 
SELECT a.VBELN,
       a.POSNR,
       a.RFSTA,
       a.RFGSA,
       a.BESTA,
       a.LFSTA,
       a.LFGSA
FROM VBUP AS a
WHERE a.VBELN = '0000004987'
  AND a.POSNR = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~vbeln,
       a~posnr,
       a~rfsta,
       a~rfgsa,
       a~besta,
       a~lfsta,
       a~lfgsa
  FROM vbup AS a
  WHERE a~vbeln = '0000004987'
  and a~posnr = '0001'
  INTO TABLE @DATA(lt_vbup)
  UP TO 100 ROWS.