SE11 ABAP Dictionary SE11 VBFA

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

VBFA

Sales Document Flow

SAP SD Transparent Table 41 Fields

Primary Key:

MANDT VBELV POSNV VBELN POSNN VBTYP_N

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	VBELV	KEY	Predecessr	CHAR	10	-	-	Preceding sales and distribution document
3	POSNV	KEY	PrecItem	NUMC	6	-	-	Preceding item of an SD document
4	VBELN	KEY	FollOn doc	CHAR	10	-	VBAK	Subsequent sales and distribution document
5	POSNN	KEY	SubseqItem	NUMC	6	-	-	Subsequent item of an SD document
6	VBTYP_N	KEY	SubsDocCat	CHAR	1	-	-	Document category of subsequent document
7	RFMNG	-	Quantity	QUAN	15	3	-	Referenced quantity in base unit of measure
8	MEINS	-	Unit	UNIT	3	-	-	Base Unit of Measure
9	RFWRT	-	Ref. value	CURR	15	2	-	Reference value
10	WAERS	-	Currency	CUKY	5	-	TCURC	Statistics currency
11	VBTYP_V	-	Doc.cat.	CHAR	1	-	-	Document category of preceding SD document
12	PLMIN	-	Pos./neg.	CHAR	1	-	-	Quantity is calculated positively, negatively or not at all
13	TAQUI	-	Confirm.ID	CHAR	1	-	-	ID: MM-WM transfer order confirmed
14	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
15	ERZET	-	Time	TIMS	6	-	-	Entry time
16	MATNR	-	Material	CHAR	18	-	MARA	Material Number
17	BWART	-	Mvmt Type	CHAR	3	-	-	Movement Type (Inventory Management)
18	BDART	-	Req.type	CHAR	2	-	-	Requirement type
19	PLART	-	Plan.type	CHAR	1	-	-	Planning type
20	STUFE	-	Level	NUMC	2	-	-	Level of the document flow record
21	LGNUM	-	Whse No.	CHAR	3	-	-	Warehouse Number / Warehouse Complex
22	AEDAT	-	Chngd	DATS	8	-	-	Changed On
23	FKTYP	-	BillCateg.	CHAR	1	-	-	Billing category
24	BRGEW	-	Gross	QUAN	15	3	-	Gross weight
25	GEWEI	-	WeightUnit	UNIT	3	-	-	Weight Unit
26	VOLUM	-	Volume	QUAN	15	3	-	Volume
27	VOLEH	-	VolumeUnit	UNIT	3	-	-	Volume unit
28	FPLNR	-	Bill.plan	CHAR	10	-	-	Billing plan number / invoicing plan number
29	FPLTR	-	Item	NUMC	6	-	-	Item for billing plan/invoice plan/payment cards
30	RFMNG_FLO	-	Quantity	FLTP	16	16	-	Referenced quantity in sales unit (float)
31	RFMNG_FLT	-	Quantity	FLTP	16	16	-	Referenced quantity in base unit of measure (float)
32	VRKME	-	Sales unit	UNIT	3	-	-	Sales unit
33	ABGES	-	Guaranteed	FLTP	16	16	-	Guaranteed (factor between 0 and 1)
34	SOBKZ	-	Spec.Stock	CHAR	1	-	-	Special Stock Indicator
35	SONUM	-	Sp.Stck No	CHAR	16	-	-	Special Stock Number
36	KZBEF	-	IM active	CHAR	1	-	-	Indicator Inventory Management active
37	NTGEW	-	Net	QUAN	13	3	-	Net Weight
38	LOGSYS	-	LogSystem	CHAR	10	-	-	Logical system
39	WBSTA	-	GoodsMovmt	CHAR	1	-	-	Goods movement status
40	CMETH	-	Conv. Meth	CHAR	1	-	-	Quantity Conversion Method
41	MJAHR	-	Mat. Year	NUMC	4	-	-	Material Document Year

Related References & SQL

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

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 VF03

Related Tables

VBAK TCURC MARA VBRK VBRP VRKPA VRPMA VKDFS

ANSI SQL Query

SELECT a.VBELV,
       a.POSNV,
       a.VBELN,
       a.POSNN,
       a.VBTYP_N,
       a.RFMNG,
       a.MEINS
FROM VBFA AS a
WHERE a.VBELV = '0001'
  AND a.POSNV = '0001';

ABAP OpenSQL (7.40+)

SELECT a~vbelv,
       a~posnv,
       a~vbeln,
       a~posnn,
       a~vbtyp_n,
       a~rfmng,
       a~meins
  FROM vbfa AS a
  WHERE a~vbelv = '0001'
  and a~posnv = '0001'
  INTO TABLE @DATA(lt_vbfa)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VBFA

VBFA

Dictionary Fields Fields

Related References & SQL