SE11 ABAP Dictionary SE11 VBSS

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

VBSS

Collective Processing: Sales Documents
SAP SD Transparent Table 4 Fields
Primary Key:
MANDT SAMMG VBELN

Dictionary Fields Fields

(4 dari 4 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
SAMMG
KEY Group CHAR 10 - - Group
3
VBELN
KEY SD Doc. CHAR 10 - VBAK Sales and Distribution Document Number
4
SORTF
- Sort seq. CHAR 4 - - Sort sequence

Related References & SQL

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

Interactive ERD Diagrams
SAP SD - Billing Tables Relation → SAP SD Table Mapping & Document Flow →
Standard T-Codes
SE11 SE16
Related Tables
VBAK VBRK VBRP VRKPA VRPMA VKDFS VBSK NAST
ANSI SQL Query 
SELECT a.SAMMG,
       a.VBELN,
       a.SORTF
FROM VBSS AS a
WHERE a.SAMMG = '0001'
  AND a.VBELN = '0000004987';
ABAP OpenSQL (7.40+) 
SELECT a~sammg,
       a~vbeln,
       a~sortf
  FROM vbss AS a
  WHERE a~sammg = '0001'
  and a~vbeln = '0000004987'
  INTO TABLE @DATA(lt_vbss)
  UP TO 100 ROWS.