SE11 ABAP Dictionary SE11 VTFA

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

VTFA

Shipment Document Flow
SAP SAP Transparent Table 16 Fields
Primary Key:
MANDT TKNUM VBELV POSNV VBTYP_V VBELN POSNN VBTYP_N

Dictionary Fields Fields

(16 dari 16 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
TKNUM
KEY Shipment CHAR 10 - - Shipment Number
3
VBELV
KEY Predecessr CHAR 10 - - Preceding sales and distribution document
4
POSNV
KEY PrecItem NUMC 6 - - Preceding item of an SD document
5
VBTYP_V
KEY Doc.cat. CHAR 1 - - Document category of preceding SD document
6
VBELN
KEY FollOn doc CHAR 10 - VBAK Subsequent sales and distribution document
7
POSNN
KEY SubseqItem NUMC 6 - - Subsequent item of an SD document
8
VBTYP_N
KEY SubsDocCat CHAR 1 - - Document category of subsequent document
9
RFMNG
- Quantity QUAN 15 3 - Referenced quantity in base unit of measure
10
MEINS
- Unit UNIT 3 - - Base Unit of Measure
11
ERDAT
- On DATS 8 - - Date on Which Record Was Created
12
ERZET
- Time TIMS 6 - - Entry time
13
AEDAT
- Chngd DATS 8 - - Changed On
14
RFMNG_FLO
- Quantity FLTP 16 16 - Referenced quantity in sales unit (float)
15
RFMNG_FLT
- Quantity FLTP 16 16 - Referenced quantity in base unit of measure (float)
16
VRKME
- Sales unit UNIT 3 - - Sales unit

Related References & SQL

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

Interactive ERD Diagrams
SAP SD - Shipping Tables Relation →
Standard T-Codes
SE11 SE16
Related Tables
VBAK LIKP LIPS VTTP VTTK VBLK VEPO VEKP
ANSI SQL Query 
SELECT a.TKNUM,
       a.VBELV,
       a.POSNV,
       a.VBTYP_V,
       a.VBELN,
       a.POSNN,
       a.VBTYP_N
FROM VTFA AS a
WHERE a.TKNUM = '0001'
  AND a.VBELV = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~tknum,
       a~vbelv,
       a~posnv,
       a~vbtyp_v,
       a~vbeln,
       a~posnn,
       a~vbtyp_n
  FROM vtfa AS a
  WHERE a~tknum = '0001'
  and a~vbelv = '0001'
  INTO TABLE @DATA(lt_vtfa)
  UP TO 100 ROWS.