SAP ABAP Table VBFAL_ALV (Sales Document Flow with ALV Tree / Copy of VBFAL + Extras)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS-GF (Application Component) Basic Functions
     ⤷ VZR (Package) Application development R/3 reporting RV central

Basic Data

Table Category	INTTAB	Structure
Structure	VBFAL_ALV	Table Relationship Diagram
Short Description	Sales Document Flow with ALV Tree / Copy of VBFAL + Extras

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	VBELV	☑			CHAR	20	0
2	POSNV	☑			NUMC	10	0
3	VBELN	☑			CHAR	20	0
4	POSNN	☑			NUMC	10	0
5	KZVOR	☐			CHAR	1	0
6	KZDET	☐			CHAR	1	0
7	APPLI	☐			CHAR	2	0
8	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
9	VBTYP_N	☑	VBTYP_N	VBTYP	CHAR	1	0	Document category of subsequent document
10	RFMNG	☐	RFMNG	MENG15	QUAN	15	3	Referenced quantity in base unit of measure
11	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
12	RFWRT	☐	RFWRT	WERTV8	CURR	15	2	Reference value
13	WAERS	☐	WAERS_V	WAERS	CUKY	5	0	Statistics currency	TCURC
14	VBTYP_V	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
15	PLMIN	☐	PLMIN	PLMIN	CHAR	1	0	Quantity is calculated positively, negatively or not at all
16	TAQUI	☐	TAQUI	XFELD	CHAR	1	0	ID: MM-WM transfer order confirmed
17	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
18	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
19	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
20	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
21	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
22	PLART	☐	PLART	PLART	CHAR	1	0	Planning type	*
23	STUFE	☐	STUFE_VBFA	NUM2	NUMC	2	0	Level of the document flow record
24	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
25	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
26	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
27	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
28	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
29	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
30	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
31	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	FPLA
32	FPLTR	☐	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards	*
33	RFMNG_FLO	☐	RFMNG_FLTV	RFMNG_FLO	FLTP	16	16	Referenced quantity in sales unit (float)
34	RFMNG_FLT	☐	RFMNG_FLT	RFMNG_FLO	FLTP	16	16	Referenced quantity in base unit of measure (float)
35	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
36	ABGES	☐	ABGES_CM	FLTP	FLTP	16	16	Guaranteed (factor between 0 and 1)
37	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
38	SONUM	☐	LVS_SONUM	LVS_SONUM	CHAR	16	0	Special Stock Number
39	KZBEF	☐	LVS_KZBEF	XFELD	CHAR	1	0	Indicator Inventory Management active
40	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
41	WBSTA	☐	WBSTA	STATV	CHAR	1	0	Goods movement status
42	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
43	GJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
44	OBJ_BEZEI	☐	BEZEI20	TEXT20	CHAR	20	0	Description
45	POS_VTEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
46	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
47	STATUS	☐	BELEG_STATUS	TEXT20	CHAR	20	0	Status of Document in the Document Flow
48	OBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
49	OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
50	LOGSYS_AIP	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
51	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
52	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
53	BEZKO	☐	BEZKO	TEXT20	CHAR	20	0	Description of the document type
54	BEZPO	☐	BEZPO	TEXT20	CHAR	20	0	Description of the item category
55	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
56	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
57	LOGSYS_A	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
58	LOGSYS_B	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
59	LOGSYS_V	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
60	LOGSYS_N	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
61	RELTYPE	☐	BINRELTYP	BINRELTYP	CHAR	4	0	Relationship type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBFAL_ALV	BWART	T156	BWART	REF	C	CN
2	VBFAL_ALV	FPLNR	FPLA	FPLNR	REF	C	CN
3	VBFAL_ALV	LGNUM	T300	LGNUM	REF	C	CN
4	VBFAL_ALV	MATNR	MARA	MATNR	REF	C	CN
5	VBFAL_ALV	MEINS	T006	MSEHI	REF	C	CN
6	VBFAL_ALV	VRKME	T006	MSEHI	REF	C	CN
7	VBFAL_ALV	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	500