SAP table JBDZSKO (Cash Flow Header)

SAP table JBDZSKO has 4 primary key fields being MANDT,OBJNR,DZSGLT,SZSART.

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 JBDOBJ1 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)
DSOFKALK Costing Date Immediate Procedure DATS 8 0 JBDSOFKALK
PAUSZK Disbursed Commitment Capital DEC 10 5 JBPAUSZK
IEFFZS Effective Interest Rate DEC 10 5 JBIEFFZS
IOPPGW Transfer Price acc. to Transaction Currency Yield Curve DEC 10 5 JBIOPPGW
IOPPHW Transfer Price according to Local Currency Yield Curve DEC 10 5 JBIOPPHW
IOPPKR Adjusted Transfer Price (Reserve Requirement) DEC 10 5 JBIOPPKR
IDUROPHW Additional Opportunity Interest (Local Currency) DEC 10 5 JBIDUROPHW
IDUROPGW Additional Opportunity Interest (Trans. Currency) DEC 10 5 JBIDUROPGW
NDURATHW Duration in Local Currency INT2 5 0 JBNDURATHW
NDURATGW Duration in Transaction Currency INT2 5 0 JBNDURATGW
SZBMETH Interest Calculation Method for Cash Flow Header CHAR 1 0 JBSZBMETH
BMARHW NPV Margin in Local Currency CURR 17 2 JBBMARHW
BMARBW NPV Margin CURR 17 2 JBBMARBW
BDSKHW NPV of Average Committed Effective Capital (LC) CURR 17 2 JBBDSKHW
BDSKBW NPV of Average Effective Committed Capital CURR 17 2 JBBDSKBW
SFSVAR Fixed/Variable Indicator CHAR 1 0 JBSFSVAR
1 Fixed
2 Variable
SEABRE Indicator - Final Settlement CHAR 1 0 JBSEABRE
BMRKBW NPV of Reserve Requirement Costs CURR 17 2 JBBMRKBW
DMARKTZINS ISB: Market Rate Date: Market Interest Rate for NPV Calc. DATS 8 0 DMARKTZINS
BRESBW Residual NPV - Cash Flow Disturbance CURR 17 2 JBBRESBW
SSOFKZ Indicator for Immediate Procedures CHAR 1 0 JBSSOFKZ
BEGEPRO Amount of Charges/Commission CURR 17 2 JBBEGEPRO
TMARKTZINS Market Interest Rate Time TIMS 6 0 JBTMARKTZINS
DZSEND End Date of Cash Flow DATS 8 0 JBDZSEND
BEGEPBW NPV of Charges/Commission in Transaction Currency CURR 17 2 JBBEGEPBW
BEGEPHW NPV of Charges/Commission in Local Currency CURR 17 2 JBBEGEPHW
CF_FR_FULL_DISB Indicator for Cash Flow from Full Disbursement CHAR 1 0 JBT_DTE_CF_FROM_FULL_DISB
ARCHIVE_STATUS Archivability Status CHAR 1 0 AFX_DTE_ARCHIVE_STATUS
ARCHIVE_FLUD Resubmission Date DATS 8 0 AFX_DTE_ARCHIVE_FLUD

JBDZSKO foreign key relationships

Table Field Check Table Check Field
0 JBDZSKO MANDT T000 Clients MANDT
1 JBDZSKO OBJNR JBDOBJ1 Object Table for Financial Transactions, General Part OBJNR