SAP table JBDZSTR (Cash Flow)

SAP table JBDZSTR has 6 primary key fields being MANDT,OBJNR,DZSGLT,SZSART,RZSBAR,DZSBEW.

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
OBJNR Object Number for Financial Transactions CHAR 22 0 JBDZSKO JBOBJNR
DZSGLT Validity date of cash flow DATS 8 0 JBDZSGLT
SZSART Cash flow category CHAR 1 0 JBSZSART
1 Approval
2 Settlement
3 Type 1 cash flow disturbance
4 Single tranches of a position
5 Type 1 cash flow disturbance (online entry)
6 Disbursement
7 Roll over
8 Type 2 cash flow disturbance
9 Money Market
L Residual flow (type one cash flow disturbance)
R Partial settlement without residual payment (RM)
RZSBAR Flow type within cash flow CHAR 4 0 TZB0A JBRZSBAR
DZSBEW Funds flow date within cash flow DATS 8 0 JBDZSBEW
WWAERS Currency CUKY 5 0 TCURC JBWWAERS
BZSBTR Flow amount within cash flow CURR 17 2 JBBZSBTR
SVORZE +/- sign in funds flow CHAR 1 0 JBSVORZE
BEFKAP Effective capital on payment dates CURR 17 2 JBBEFKAP
SNOTLD Indicator for simulated flow CHAR 1 0 JBSSIMKZ
DSTGBS New payment date DATS 8 0 JBDSTGBS
BZKBZZ NIM contribution for interval between two payment dates CURR 17 2 JBBZKBZZ
DERFAS Created on DATS 8 0 JBDERFAS
TERFAS Time of entry TIMS 6 0 JBTERFAS

JBDZSTR foreign key relationships

Table Field Check Table Check Field
0 JBDZSTR MANDT T000 Clients MANDT
1 JBDZSTR OBJNR JBDZSKO Cash Flow Header OBJNR
0 JBDZSTR RZSBAR TZB0A Definition of flow types MANDT
0 JBDZSTR RZSBAR TZB0A Definition of flow types RANTYP
0 JBDZSTR RZSBAR TZB0A Definition of flow types SBEWART
1 JBDZSTR WWAERS TCURC Currency Codes MANDT
1 JBDZSTR WWAERS TCURC Currency Codes WAERS