In this post, I will try and describe everything you need to know about the SAP j11dabe1 table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for J11DABE1 what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from J11DABE1....Right lets get started!
Object Name: J11DABE1
Dictionary Type: Structure
Description: TR-EDT: Transfer of Flow Data
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| ACTIO | CHAR | 1(0) | Action in R/3 | |||||||||
| ARCHI | CHAR | 1(0) | Archiving category | |||||||||
| AUGLZ | NUMC | 3(0) | Clearing number | |||||||||
| AVERM | CHAR | 10(0) | Business partner | |||||||||
| BELNR | CHAR | 8(0) | RF document number | |||||||||
| BSAKN | CHAR | 8(0) | Balance sheet account | |||||||||
| BSZIN | CHAR | 8(0) | Interest to.. | |||||||||
| BUDAT | CHAR | 8(0) | Posting date | |||||||||
| BUKRS | CHAR | 2(0) | Company code | |||||||||
| BUPER | CHAR | 2(0) | Posting month for special period | |||||||||
| DATUM | CHAR | 8(0) | Interest value date | |||||||||
| DIDAT | CHAR | 8(0) | Planning day | |||||||||
| DMIHB | NUMC | 13(0) | Amount in local currency | |||||||||
| DMSHB | NUMC | 11(0) | Local currency amount | |||||||||
| EBENE | CHAR | 2(0) | Planning level | |||||||||
| FDUPD | CHAR | 1(0) | Flag - record to cash mgmt? | |||||||||
| GRUPP | CHAR | 8(0) | Bank account for planning | |||||||||
| HABEW | CHAR | 1(0) | Main flow | |||||||||
| HABKO | CHAR | 8(0) | Account for credit posting | |||||||||
| IDENT | CHAR | 8(0) | Document number | |||||||||
| INHAB | NUMC | 2(0) | Bracket for purchase/sale | |||||||||
| INSTD | CHAR | 10(0) | Customer posted to | |||||||||
| KENNR | CHAR | 13(0) | ID number | |||||||||
| KONID | CHAR | 8(0) | Securities acct ID | |||||||||
| KURSA | NUMC | 9(0) | Exchange rate specification | |||||||||
| KURSB | NUMC | 9(0) | Exchange rate specification | |||||||||
| KURSF | NUMC | 9(0) | Exchange rate specification | |||||||||
| LFDNR | NUMC | 3(0) | Sequence number | |||||||||
| LFZ | CHAR | 4(0) | Term for interest calculation | |||||||||
| MIGDATE | NUMC | 8(0) | Migration date | |||||||||
| NUM_DMIHB | NUMC | 1(0) | Decimal place of DMIHB | |||||||||
| NUM_DMSHB | NUMC | 1(0) | Decimal place of DMSHB | |||||||||
| NUM_KURSA | NUMC | 1(0) | Decimal place of KURSA | |||||||||
| NUM_KURSB | NUMC | 1(0) | Decimal place of KURSB | |||||||||
| NUM_KURSF | NUMC | 1(0) | Decimal place of KURSF | |||||||||
| NUM_W2SHB | NUMC | 1(0) | Decimal place of W2SHB | |||||||||
| NUM_WBEFW | NUMC | 1(0) | Decimal place of WBEFW | |||||||||
| NUM_WBEKU | NUMC | 1(0) | Decimal place of WBEKU | |||||||||
| NUM_WKURA | NUMC | 1(0) | Decimal place of WKURA | |||||||||
| NUM_WNEST | NUMC | 1(0) | Decimal place of WNEST | |||||||||
| NUM_WRIHB | NUMC | 1(0) | Decimal place of WRIHB | |||||||||
| NUM_WRSHB | NUMC | 1(0) | Decimal place of WRSHB | |||||||||
| NUM_ZIBAS | NUMC | 1(0) | Decimal place of ZIBAS | |||||||||
| NUM_ZSAEF | NUMC | 1(0) | Decimal place of ZSAEF | |||||||||
| NUM_ZSATZ | NUMC | 1(0) | Decimal place of ZSATZ | |||||||||
| ONAEN | CHAR | 1(0) | ID of a manual | |||||||||
| ONBUC | CHAR | 1(0) | Flagged for online posting | |||||||||
| ORDAT | CHAR | 8(0) | Order date | |||||||||
| ORGRP | CHAR | 2(0) | Grouping for business partner | |||||||||
| ORNUM | CHAR | 10(0) | Single transaction ref. | |||||||||
| REFID | CHAR | 8(0) | ID number of reference rate | |||||||||
| REQU0 | CHAR | 1(0) | General indicator | |||||||||
| REQU1 | CHAR | 1(0) | Exch.rate fix.for curr.transl. | |||||||||
| REQU3 | CHAR | 1(0) | Exch.rate fix.for curr.transl. | |||||||||
| RESAL | CHAR | 1(0) | Flow for remaining balance | |||||||||
| RFDAT | CHAR | 8(0) | Posting date | |||||||||
| RFTIM | CHAR | 6(0) | Posting time | |||||||||
| SHKZG | CHAR | 1(0) | Debit/Credit indicator for OI | |||||||||
| SICHK | CHAR | 1(0) | Indicator - hedging transaction | |||||||||
| SOLKO | CHAR | 8(0) | Account for debit posting | |||||||||
| SPDAT | CHAR | 8(0) | Lock date | |||||||||
| STATI | CHAR | 1(0) | Contract status | |||||||||
| STUCK | CHAR | 1(0) | Indicator - accrued interest | |||||||||
| STYPE | CHAR | 1(0) | Server type | |||||||||
| STZTG | CHAR | 1(0) | Days-calculation method | |||||||||
| SUMKZ | CHAR | 1(0) | Totals record from summarization run | |||||||||
| TXNAU | CHAR | 1(0) | Investment type | |||||||||
| UDATA | CHAR | 8(0) | Creation date | |||||||||
| UDATB | CHAR | 8(0) | Last change date | |||||||||
| UMBWA | CHAR | 2(0) | Flow type from which the rec. | |||||||||
| USERA | CHAR | 8(0) | Created by | |||||||||
| USERB | CHAR | 8(0) | Last changed by | |||||||||
| USERO | CHAR | 8(0) | User | |||||||||
| USTRU | CHAR | 8(0) | G/L account (CHAR) | |||||||||
| UTIMA | CHAR | 6(0) | Time of creation | |||||||||
| VARAD | CHAR | 8(0) | SB applic.on | |||||||||
| VARGD | CHAR | 8(0) | Supervisory board authoriz.on | |||||||||
| VARID | NUMC | 4(0) | SB template identification | |||||||||
| VORGA | CHAR | 2(0) | Activity type | |||||||||
| VOZIN | CHAR | 8(0) | Interest calc. from... | |||||||||
| VTYPE | CHAR | 1(0) | Processing type | |||||||||
| W2SHB | NUMC | 13(0) | Foreign currency | |||||||||
| WAERR | CHAR | 5(0) | Currency key - position currency | |||||||||
| WAERS | CHAR | 5(0) | Currency key | |||||||||
| WBEFW | NUMC | 9(0) | Last FC valuation rate | |||||||||
| WBEKU | NUMC | 15(0) | Security price | |||||||||
| WKURA | NUMC | 15(0) | Security price | |||||||||
| WNEST | NUMC | 13(0) | Nominal amount in contract curr. | |||||||||
| WRIHB | NUMC | 13(0) | Amount actually paid | |||||||||
| WRSHB | NUMC | 13(0) | Foreign currency (contr.curr.) | |||||||||
| ZAHID | CHAR | 2(0) | Payment meth.ID, account of payee | |||||||||
| ZATAG | CHAR | 8(0) | Payment date | |||||||||
| ZIBAS | NUMC | 13(0) | Calculation base for interest | |||||||||
| ZISAL | CHAR | 1(0) | Flow in interest base | |||||||||
| ZIZPT | CHAR | 1(0) | Flow results in interest payment | |||||||||
| ZSAEF | NUMC | 8(0) | Effective int.rate | |||||||||
| ZSATZ | NUMC | 8(0) | Interest rate |