SAP ABAP Table FDS1 (Cash Management & Forecast: Line Items of SD Documents)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ FF (Package) Cash Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FDS1	Table Relationship Diagram
Short Description	Cash Management & Forecast: Line Items of SD Documents

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
3	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
4	ETENR	☑	ETENR	ETENR	NUMC	4	0	Schedule line	*
5	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
6	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
8	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
9	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
10	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
11	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
12	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
13	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
14	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
15	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
16	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
17	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
18	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
19	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
20	POSMENGE	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
21	ERLMENGE_L	☐	ERLMENGE_L	MENG13	QUAN	13	3	Completed quantity (delivery)
22	ERLMENGE_F	☐	ERLMENGE_F	MENG13	QUAN	13	3	Invoiced quantity in basic unit of measure
23	FAKLMENG	☐	FAKLMENG	MENG13	QUAN	13	3	Invoiced delivery quantity in base unit of measure
24	EDATU	☐	EDATU	DATUM	DATS	8	0	Schedule line date
25	BESTMENGE	☐	BMENG	MENG13	QUAN	13	3	Confirmed quantity
26	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
27	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
28	UNFMENG	☐	EINZFAKT	MENG13	QUAN	13	3	Invoiced quantity on division level
29	PREIS	☐	EINZPREISF	WERTV8	CURR	15	2	Unit price in foreign currency per unit quantity
30	HPREI	☐	EINZPREISH	WERTV8	CURR	15	2	Unit price in local currency per unit quantity
31	EBENE	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	*
32	FDGRV	☐	FDGRP	FDGRP	CHAR	10	0	Planning Group	*
33	DATUM	☐	FDTAG	DATUM	DATS	8	0	Planning Date
34	DMSHB	☐	DMSHW	WERTV8	CURR	15	2	Amount in local currency
35	WRSHB	☐	WRSHW	WERTV8	CURR	15	2	Amount in planned currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FDS1	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in