In this post, I will try and describe everything you need to know about the SAP j11sdab 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 J11SDAB 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 J11SDAB....Right lets get started!
Object Name: J11SDAB
Dictionary Type: Structure
Description: Send Structure for TR-EDT Receiver Structure JBIUDAB
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| BUKRS | BUKRS | CHAR | 4(0) | T001 | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | ||
| RANL | RANL | CHAR | 13(0) | Contract Number | RANL | RAN | FVVW | |||||
| MANDT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | |||||
| STYPE | STYPE_BEW | CHAR | 1(0) | Record Category for TR-EDT: Loan Flows | STYPE_BEW | |||||||
| SKOART | SKOART | NUMC | 4(0) | TZK01 | Condition Type (Smallest Subdivision of Condition Records) | SKOART | FVV | |||||
| SBEWART | SBEWART | CHAR | 4(0) | TZB0A | Flow Type | SBEWART | FVV | |||||
| VVSBBEZ | VVSBBEZ | NUMC | 3(0) | TZB07 | Indicator for the relevance of the relationship | VVSBBEZ | ||||||
| SPLANIST | SPLANIST | CHAR | 1(0) | Plan/actual record/record to be released indicator | SPLANIST | FVV | ||||||
| RPARTNR | BP_PARTNR_NEW | CHAR | 10(0) | BUT000 | Business Partner Number | BU_PARTNER | BPA | BUPA | PARTNER | |||
| DBUDAT | BUDAT | DATS | 8(0) | Posting Date in the Document | DATUM | FB | ||||||
| DBLDAT | BLDAT | DATS | 8(0) | Document Date in Document | DATUM | FB | ||||||
| DVALUT | DVALUT | DATS | 8(0) | Calculation Date | DATUM | FVV | ||||||
| DFAELL | DFAELL | DATS | 8(0) | Due date | DATUM | FVV | ||||||
| DDISPO | DDISPO | DATS | 8(0) | Payment Date | DATUM | FVV | ||||||
| DVERRECH | VVDVERRECH | DATS | 8(0) | Settlement date | DATUM | FVV | ||||||
| SINCL | VVSINCL | NUMC | 1(0) | Inclusive indicator for beginning and end of a period | VVSINCL | |||||||
| SINCLVERR | VVSINCLVER | NUMC | 1(0) | Inclusive Indicator for Clearing Date | VVSINCLVER | |||||||
| SINCLBIS | VVSINCLBIS | NUMC | 1(0) | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | |||||||
| SEXCLVON | VVSEXCLVON | NUMC | 1(0) | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | |||||||
| NO_SINCL_CHANGE | XFELD | CHAR | 1(0) | Checkbox | XFELD | FB | ||||||
| DBERVON | DBERVON | DATS | 8(0) | Start of Calculation Period | DATUM | FVVD | ||||||
| DBERBIS | DBERBIS | DATS | 8(0) | End of Calculation Period | DATUM | FVVD | ||||||
| BHWHR | UEBBWHR | NUMC | 13(0) | Amount that Changes Position in Local Currency | NUMC13 | |||||||
| N_BHWHR | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| BBWHR | UEBBBHR | NUMC | 13(0) | Amount that Changes the Position | NUMC13 | |||||||
| N_BBWHR | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| SBWHR | UB_SBWHR | CHAR | 5(0) | Currency of position amount | CHAR5 | FVV | ||||||
| BNWHR | UEBBWHR | NUMC | 13(0) | Amount that Changes Position in Local Currency | NUMC13 | |||||||
| N_BNWHR | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| SNWHR | UB_SNWHR | CHAR | 5(0) | Currency of nominal amount | CHAR5 | FVV | ||||||
| BCWHR | UEBBCHR | NUMC | 13(0) | Settlement amount in foreign currency | NUM13 | |||||||
| N_BCWHR | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| SCWHR | UB_SCWHR | CHAR | 5(0) | Currency of payment amount | CHAR5 | FVV | ||||||
| BBASIS | UEBBASIS | NUMC | 13(0) | Calculation base for conditions | NUM13 | FVVD | ||||||
| N_BBASIS | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| SZEGEN | SZEGEN | NUMC | 2(0) | TD21 | Generate incoming payment immediately | SZEGEN | ||||||
| RBELKPFD | RBELKPFD | CHAR | 10(0) | VDBEKI | Document Number of Document Header (Loan) | RBELKPFD | FVV | |||||
| DGUEL_KK | DGUEL | DATS | 8(0) | Date Condition Effective from | DATUM | FVVW | ||||||
| DGUEL_KP | DGUEL | DATS | 8(0) | Date Condition Effective from | DATUM | FVVW | ||||||
| DBPERIOD | VVDBPERIOD | DATS | 8(0) | Period start | DATUM | |||||||
| SPAEXCL | TFMSPAEXCL | NUMC | 1(0) | Exclusive Indicator for Start Date of a Period | TFMSPAEXCL | |||||||
| SPAULT | TFMSPAULT | CHAR | 1(0) | Month-End Indicator for Start Date of a Period | VVSULT | |||||||
| DEPERIOD | VVDEPERIOD | DATS | 8(0) | Period End | DATUM | |||||||
| SPEINCL | TFMSPEINCL | NUMC | 1(0) | Inclusive Indicator for End Date of a Period | TFMSPEINCL | |||||||
| SPEULT | TFMSPEULT | CHAR | 1(0) | Month-End Indicator for End of a Period | VVSULT | |||||||
| SZBMETH | SZBMETH | CHAR | 1(0) | Interest Calculation Method | SZBMETH | FVV | ||||||
| SREFBEW | SREFBEW | CHAR | 4(0) | TZB0A | Reference flow type | SBEWART | ||||||
| RREFKONT | RREFKONT | CHAR | 8(0) | T037S | Account Assignment Reference in Financial Assets Management | USTRU | KRE | FVV | ||||
| GSBER | GSBER | CHAR | 4(0) | TGSB | Business Area | GSBER | GSB | FB | ||||
| ZAHLS | DZAHLS | CHAR | 1(0) | T008 | Block Key for Payment | ZAHLS | FB | |||||
| MANSP | MANSP | CHAR | 1(0) | T040S | Dunning block | MANSP | FB | |||||
| RSOLL | RSOLL | CHAR | 10(0) | SKA1 | Account for debit posting | SAKNR | FVV | |||||
| RHABEN | RHABEN | CHAR | 10(0) | SKA1 | Account for credit posting | SAKNR | FVV | |||||
| SWOHER | SWOHER | CHAR | 1(0) | Source of flow record | CHAR1 | FVV | ||||||
| STICHTAG | VVSTICHTAG | DATS | 8(0) | Key date for data transfer | DATUM | |||||||
| OP_BBWHR | UEBBBHR | NUMC | 13(0) | Amount that Changes the Position | NUMC13 | |||||||
| N_OP_BBWHR | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| OP_BHWHR | UEBBWHR | NUMC | 13(0) | Amount that Changes Position in Local Currency | NUMC13 | |||||||
| N_OP_BHWHR | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| OP_BNWHR | UEBBWHR | NUMC | 13(0) | Amount that Changes Position in Local Currency | NUMC13 | |||||||
| N_OP_BNWHR | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| OP_BCWHR | UEBBCHR | NUMC | 13(0) | Settlement amount in foreign currency | NUM13 | |||||||
| N_OP_BCWHR | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| OP_DDISPO | DDISPO | DATS | 8(0) | Payment Date | DATUM | FVV | ||||||
| OP_DBUDAT | BUDAT | DATS | 8(0) | Posting Date in the Document | DATUM | FB | ||||||
| SSTORNO | SSTORNO | CHAR | 1(0) | Reversal indicator | SSTORNO | FVV | ||||||
| SSTOGRD | SSTOGRD | CHAR | 2(0) | TZST | Reason for Reversal | SSTOGRD | FVV | |||||
| SZART | SZART_LO | CHAR | 1(0) | Payment transaction for loans | SZART_LO | |||||||
| KURS2 | UB_KURSF | NUMC | 9(0) | Exchange rate | KURSC | FB | ||||||
| N_KURS2 | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| ZLSCH | DZLSCH | CHAR | 1(0) | * | Payment Method | ZLSCH | FB | |||||
| DFAELL_OLD_EXT | TB_EXTENS_DFAELL_OLD | DATS | 8(0) | Old Due Date | DATUM | |||||||
| DDISPO_OLD_EXT | TB_EXTENS_DDISPO_OLD | DATS | 8(0) | Old Payment Date | DATUM | |||||||
| RBO_EXT | RBO | CHAR | 15(0) | Business Operation Number (Loans) | RBO | |||||||
| SVORGANG | SVORFALL | CHAR | 4(0) | Business Operation (Activity) | SVORFALL | FVV | ||||||
| ABASTAGE | ABASTAGE | NUMC | 6(0) | Number of base days in a calculation period | INT6 | |||||||
| PKOND | UB_PKOND | NUMC | 10(0) | Percentage rate for condition items | NUM10 | FVV | ||||||
| N_PKOND | UB_KOMMA | NUMC | 1(0) | Number of decimal places from legacy system | NUM1 | |||||||
| DPKOND | VVDPKOND | DATS | 8(0) | Determination date for percentage rate of condition items | DATUM | FVV | ||||||
| SSTCKKZ_X | BOOLEAN | CHAR | 1(0) | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | KA | ||||||
| JSOFVERR_X | BOOLEAN | CHAR | 1(0) | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | KA | ||||||
| ALT_BUCHEN | VVJAUSWA | CHAR | 1(0) | Control whether field selection from TZPA or TZPAB is used | JANEI | |||||||
| SDBMODE | TRUBMODBEW | CHAR | 1(0) | Transfer mode - flow data | TRUBMODBEW |