SAP Table FDS1

Cash Management & Forecast: Line Items of SD Documents

FDS1 (Cash Management & Forecast: Line Items of SD Documents) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FDS1 to other SAP tables.

FDS1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
ETENR Delivery Schedule Line Number ETENR NUMC 4 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
BUKRS Company Code BUKRS CHAR 4 0
WAERK SD Document Currency WAERK CUKY 5 0
HWAER Local Currency HWAER CUKY 5 0
KUNAG Sold-to party KUNAG CHAR 10 0
KUNRG Payer KUNRG CHAR 10 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZLSCH Payment Method DZLSCH CHAR 1 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
FBUDA Date on which services rendered FBUDA DATS 8 0
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
GSBER Business Area GSBER CHAR 4 0
VGBEL Document number of the reference document VGBEL CHAR 10 0
VGPOS Item number of the reference item VGPOS NUMC 6 0
POSMENGE Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
ERLMENGE_L Completed quantity (delivery) ERLMENGE_L QUAN 13 3
ERLMENGE_F Invoiced quantity in basic unit of measure ERLMENGE_F QUAN 13 3
FAKLMENG Invoiced delivery quantity in base unit of measure FAKLMENG QUAN 13 3
EDATU Schedule line date EDATU DATS 8 0
BESTMENGE Confirmed Quantity BMENG QUAN 13 3
WADAT Goods Issue Date WADAT DATS 8 0
MEINS Base Unit of Measure MEINS UNIT 3 0
UNFMENG Invoiced quantity on division level EINZFAKT QUAN 13 3
PREIS Unit price in foreign currency per unit quantity EINZPREISF CURR 15 2
HPREI Unit price in local currency per unit quantity EINZPREISH CURR 15 2
EBENE Planning level FDLEV CHAR 2 0
FDGRV Planning Group FDGRP CHAR 10 0
DATUM Planning date FDTAG DATS 8 0
DMSHB Amount in local currency DMSHW CURR 15 2
WRSHB Amount in planned currency WRSHW CURR 15 2

FDS1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FDS1 MANDT FDS1 MANDT T000 Clients MANDT