SAP ABAP Table VDPFLOW (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VDPFLOW	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	DLINR	☑	AD01DLINR	AD01DLINR	NUMC	20	0	Number of the Dynamic Item
3	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
4	POPER	☑	AD01PERIOD	JAHRPER	NUMC	7	0	Posting period
5	TWAER	☑	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
6	MEINH	☑	CO_MEINH	MEINS	UNIT	3	0	Unit of Measure	T006
7	MANUAL	☑	XFELD	XFELD	CHAR	1	0	Checkbox
8	KSTAR	☑	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
9	KOSTL	☑	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
10	LSTAR	☑	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
11	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	STAGR	☑	STAGR	STAGR	CHAR	6	0	Statistical key figure	TKA03
13	FIPOS	☑	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
14	WRTTP	☑	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
15	VERSN	☑	VERSN	COVERSI	CHAR	3	0	Version	TKVS
16	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
17	PRODU	☑	PRODN	MATNR	CHAR	18	0	Product number	MARA
18	FAKTF	☑	FAKTF	FAKTF	CHAR	2	0	Billing Form
19	BEMOT	☑	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
20	BELNR	☑	CO_BELNR	CO_BELNR	CHAR	10	0	Document Number
21	BUZEI	☑	CO_BUZEI	BUZEI	NUMC	3	0	Posting row
22	ARBPL	☑	ARBPL	ARBPL	CHAR	8	0	Work center
23	AWERK	☑	AD01AWERK	WERKS	CHAR	4	0	Plant of Work Center	T001W
24	PRZNR	☑	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	CBPR
25	ASNUM	☑	ASNUM	ASNUM	CHAR	18	0	Activity Number	ASMD
26	PERNR	☑	HR_PERNR	PERNR	NUMC	8	0	Personnel Number
27	/CBAD/ORIG_OBJNR	☑	/CBAD/ORIG_OBJNR	J_OBJNR	CHAR	22	0	CBAD Original Object Number
28	/CBAD/BILL_WBS	☑	/CBAD/PS_POSNR	PS_POSNR	NUMC	8	0	CBAD WBS Element
29	PRS_WORK_PERIOD	☑	PRS_WORK_PERIOD	PRS_WORK_PERIOD	NUMC	7	0	Work Period (Internal Representation)
30	GSBER	☑	GSBER	GSBER	CHAR	4	0	Business Area
31	PARGB	☑	PARGB	GSBER	CHAR	4	0	Trading partner's business area
32	PRCTR	☑	PRCTR	PRCTR	CHAR	10	0	Profit Center
33	PPRCTR	☑	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center
34	ORDERED_PROD	☑	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
35	CATEGORY_ID	☑	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
36	AWSYS	☑	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document
37	SERV_AGENT_ID	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
38	REF_OBJECT_ID	☑	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
39	REF_OBJECT_ITEM	☑	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
40	ORIG_OBJNR	☑	DPICB_OBJNR	J_OBJNR	CHAR	22	0	Object Number of Original Object
41	FAREA	☑	FM_FAREA	FKBER	CHAR	16	0	Functional Area
42	RGRANT_NBR	☑	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
43	WBS_ELEMENT	☑	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element
44	ORDERID	☑	AUFNR	AUFNR	CHAR	12	0	Order Number
45	FUNDS_CTR	☑	FISTL	FISTL	CHAR	16	0	Funds Center
46	FUND	☑	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
47	SPONSORED_PROG	☑	GM_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Sponsored Program
48	SPONSORED_CLASS	☑	GM_SPONSORED_CLASS	GM_SPONSORED_CLASS	CHAR	20	0	Sponsored Class
49	GL_SIRID	☑	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
50	REFDOCNR	☑	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
51	REFDOCLN	☑	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
52	SGTXT	☑	SGTXT	TEXT50	CHAR	50	0	Item Text
53	GM_VALUETYPE	☑	GM_VALUETYPE	GM_VALUETYPE	CHAR	2	0	GM Value Type
54	ASSETMAINO	☑	BF_ANLN1	BF_ANLN1	CHAR	12	0	Main Asset Number
55	ASSETSUBNO	☑	BF_ANLN2	BF_ANLN2	CHAR	4	0	Asset Subnumber
56	DLISRC	☑	AD01DLISRC	AD01DLISRC	CHAR	4	0	Dynamic Item Source	AD01SRC
57	PROFNR	☑	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	AD01C_PROF
58	TIMESTMP	☑	RKE_HZSTMP	RKE_TSTMP	DEC	16	0	Time created (Greenwich Meantime)
59	SF_DLIUS	☑	AD01USAGE	AD01USAGE	NUMC	2	0	Usage of the DI profile
60	EF_VBELN	☑	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
61	EF_VBPOS	☑	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
62	SF_IN_WTGBTR	☐	EB_FKWRT	WERTV8	CURR	15	2	Amount referenced for invoicing
63	SF_IN_WOGBTR	☐	EB_FKWRT	WERTV8	CURR	15	2	Amount referenced for invoicing
64	SF_IN_WKGBTR	☐	EB_FKWRT	WERTV8	CURR	15	2	Amount referenced for invoicing
65	SF_IN_MEGBTR	☐	EB_FKMNG	MENGV8	QUAN	15	3	Quantity billed
66	SF_NO_WTGBTR	☐	AD01NOWRT	WERTV8	CURR	15	2	Sum never
67	SF_NO_WOGBTR	☐	AD01NOWRT	WERTV8	CURR	15	2	Sum never
68	SF_NO_WKGBTR	☐	AD01NOWRT	WERTV8	CURR	15	2	Sum never
69	SF_NO_MEGBTR	☐	AD01NOMNG	MENGV8	QUAN	15	3	Quantity never
70	EF_IN_WTGBTR	☐	EB_FKWRT	WERTV8	CURR	15	2	Amount referenced for invoicing
71	EF_IN_WOGBTR	☐	EB_FKWRT	WERTV8	CURR	15	2	Amount referenced for invoicing
72	EF_IN_WKGBTR	☐	EB_FKWRT	WERTV8	CURR	15	2	Amount referenced for invoicing
73	EF_IN_MEGBTR	☐	EB_FKMNG	MENGV8	QUAN	15	3	Quantity billed
74	EF_BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator
75	EF_RETRO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
76	EF_DOPEN	☐	AD01DOPENSIGN	AD01DOPENSIGN	CHAR	1	0	Indicator: DOPEN Status in Single Flow
77	EF_FKDAT_ACTIVE	☐	AD01FKDAT_ACTIVE	XFIELD	CHAR	1	0	Billing Date is Updated in Document Flow
78	EF_FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
79	EF_TO_DATE	☐	AD01BTODAT	DATUM	DATS	8	0	To Date
80	EF_TIMESTMP	☐	RKE_HZSTMP	RKE_TSTMP	DEC	16	0	Time created (Greenwich Meantime)
81	EF_TO_WTGBTR	☐	EB_FKWRT	WERTV8	CURR	15	2	Amount referenced for invoicing
82	EF_TO_WOGBTR	☐	EB_FKWRT	WERTV8	CURR	15	2	Amount referenced for invoicing
83	EF_TO_WKGBTR	☐	EB_FKWRT	WERTV8	CURR	15	2	Amount referenced for invoicing
84	EF_TO_MEGBTR	☐	EB_FKMNG	MENGV8	QUAN	15	3	Quantity billed
85	EF_AUMOT	☐	AUMOT	AD01COSTYP	CHAR	2	0	Apportionment reason
86	SF_RV_WTGBTR1	☐	AD01RVWRT	WERTV8	CURR	15	2	Simulation subtotal
87	SF_RV_WTGBTR2	☐	AD01RVWRT	WERTV8	CURR	15	2	Simulation subtotal
88	SF_RV_WTGBTR3	☐	AD01RVWRT	WERTV8	CURR	15	2	Simulation subtotal
89	SF_RV_WTGBTR4	☐	AD01RVWRT	WERTV8	CURR	15	2	Simulation subtotal
90	SF_RV_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDPFLOW	ASNUM	ASMD	ASNUM
2	VDPFLOW	AWERK	T001W	WERKS
3	VDPFLOW	BEMOT	TBMOT	BEMOT
4	VDPFLOW	DLISRC	AD01SRC	DLISRC	KEY	1	CN
5	VDPFLOW	EF_VBELN	VBUK	VBELN	KEY	1	CN
6	VDPFLOW	EF_VBPOS	VBUP	POSNR	KEY	1	CN
7	VDPFLOW	FIPOS	FMFPO	FIPOS
8	VDPFLOW	KOSTL	CSKS	KOSTL
9	VDPFLOW	KSTAR	CSKA	KSTAR
10	VDPFLOW	LSTAR	CSLA	LSTAR
11	VDPFLOW	MANDT	T000	MANDT	KEY	1	CN
12	VDPFLOW	MATNR	MARA	MATNR	KEY	1	CN
13	VDPFLOW	MEINH	T006	MSEHI	KEY	1	CN
14	VDPFLOW	OBJNR	ONR00	OBJNR	KEY	1	CN
15	VDPFLOW	PRODU	MARA	MATNR
16	VDPFLOW	PROFNR	AD01C_PROF	PROFNR	KEY	1	CN
17	VDPFLOW	PRZNR	CBPR	PRZNR
18	VDPFLOW	SF_RV_WAERS	TCURC	WAERS	KEY	1	CN
19	VDPFLOW	STAGR	TKA03	STAGR
20	VDPFLOW	TWAER	TCURC	WAERS	KEY	1	CN
21	VDPFLOW	VERSN	TKVS	VERSI
22	VDPFLOW	WERKS	T001W	WERKS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in