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

SAP table FDS1 has 4 primary key fields being MANDT,VBELN,POSNR,ETENR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
ETENR Schedule Line Number NUMC 4 0 ETENR
PERIV Fiscal Year Variant CHAR 2 0 PERIV
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
BUKRS Company Code CHAR 4 0 BUKRS
WAERK SD Document Currency CUKY 5 0 WAERK
HWAER Local Currency CUKY 5 0 HWAER
KUNAG Sold-to Party CHAR 10 0 KUNAG
KUNRG Payer CHAR 10 0 KUNRG
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZLSCH Payment Method CHAR 1 0 DZLSCH
FKDAT Billing Date DATS 8 0 FKDAT
FBUDA Date on which services are rendered DATS 8 0 FBUDA
KURSK Exchange Rate for Price Determination DEC 9 5 KURSK
GSBER Business Area CHAR 4 0 GSBER
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
POSMENGE Cumulative order quantity in sales units QUAN 15 3 KWMENG
ERLMENGE_L Completed quantity (delivery) QUAN 13 3 ERLMENGE_L
ERLMENGE_F Invoiced quantity in basic unit of measure QUAN 13 3 ERLMENGE_F
FAKLMENG Invoiced delivery quantity in base unit of measure QUAN 13 3 FAKLMENG
EDATU Schedule line date DATS 8 0 EDATU
BESTMENGE Confirmed Quantity QUAN 13 3 BMENG
WADAT Goods Issue Date DATS 8 0 WADAT
MEINS Base Unit of Measure UNIT 3 0 MEINS
UNFMENG Invoiced quantity on division level QUAN 13 3 EINZFAKT
PREIS Unit Price in Foreign Currency per Unit Quantity CURR 23 2 EINZPREISF
HPREI Unit Price in Local Currency per Unit Quantity CURR 23 2 EINZPREISH
EBENE Planning Level CHAR 2 0 FDLEV
FDGRV Planning Group CHAR 10 0 FDGRP
DATUM Planning Date DATS 8 0 FDTAG
DMSHB Amount in local currency CURR 23 2 DMSHW
WRSHB Amount in Planning Currency CURR 23 2 WRSHW

FDS1 foreign key relationships

Table Field Check Table Check Field
0 FDS1 MANDT T000 Clients MANDT