In this post, I will try and describe everything you need to know about the SAP j11trdsvv 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 J11TRDSVV 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 J11TRDSVV....Right lets get started!
Object Name: J11TRDSVV
Dictionary Type: Structure
Description: RF-VV R/2 Loans: Master Data
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| ABNKR | CHAR | 15(0) | Bank Reference (e.g. account number) | |||||||||
| ACTIO | CHAR | 1(0) | Action in R/3 | |||||||||
| AGRPP | CHAR | 8(0) | Grouping Indicator | |||||||||
| AKTDM | NUMC | 13(0) | Acquisition Value Local Curr. | |||||||||
| AKTWR | NUMC | 13(0) | Acquisition Value Foreign Curr. | |||||||||
| ALAND | CHAR | 3(0) | Country Key | |||||||||
| ANLAG | CHAR | 1(0) | Product Category | |||||||||
| ANNUI | CHAR | 1(0) | Indicator: Same Rate | |||||||||
| ARCHI | CHAR | 1(0) | Archiving Category | |||||||||
| ARDAT | CHAR | 8(0) | Archiving Date | |||||||||
| AREFN | CHAR | 8(0) | Reference Number | |||||||||
| ATEX1 | CHAR | 25(0) | Description 1 | |||||||||
| ATEX2 | CHAR | 25(0) | Decription 2 | |||||||||
| AUFNR | NUMC | 8(0) | Order Number | |||||||||
| AUFPS | NUMC | 2(0) | Item Number of Order | |||||||||
| AUSW2 | CHAR | 60(0) | Field Selection | |||||||||
| AUSWA | CHAR | 60(0) | Field Selection | |||||||||
| AUSZA | CHAR | 1(0) | Disbursement Made | |||||||||
| AVERM | CHAR | 10(0) | Agents | |||||||||
| BARTE | CHAR | 1(0) | Calculation Base for Provision | |||||||||
| BASIS | NUMC | 1(0) | Indicator for Calculation | |||||||||
| BATCH | CHAR | 1(0) | Status for Batch Update | |||||||||
| BDATV | CHAR | 8(0) | Date of Specified Valuation | |||||||||
| BETRG | NUMC | 13(0) | Amount of Condition | |||||||||
| BITXT | NUMC | 8(0) | Internal Long Text Number | |||||||||
| BKRUE | CHAR | 8(0) | Bank Account | |||||||||
| BNDAT | CHAR | 8(0) | New Negotiation Date | |||||||||
| BPROV | NUMC | 8(0) | Provision Commission | |||||||||
| BSAKN | CHAR | 8(0) | Balance Sheet Account | |||||||||
| BUHAL | CHAR | 1(0) | Control of RF Postings | |||||||||
| BUKRS | CHAR | 2(0) | Company code | |||||||||
| BUWDM | NUMC | 13(0) | Book Value in LC Only | |||||||||
| BUWWR | NUMC | 13(0) | Book Value in FC | |||||||||
| DANAR | NUMC | 2(0) | Form | |||||||||
| DANLA | NUMC | 3(0) | Premium Reserve Allocation | |||||||||
| DENDE | CHAR | 8(0) | Term End for Annuities | |||||||||
| DEPWE | NUMC | 13(0) | Nominval Value of Sec.Acct | |||||||||
| DISAG | CHAR | 1(0) | Discount COllection | |||||||||
| DKENN | CHAR | 2(0) | Indicator | |||||||||
| DKURE | CHAR | 1(0) | Determination of Rate Gain/Loss | |||||||||
| DOFFE | NUMC | 13(0) | Open Local Currency Amount | |||||||||
| DUNAB | NUMC | 2(0) | Subsection | |||||||||
| DVBET | NUMC | 13(0) | Contract Value or Nominal Value | |||||||||
| EBENE | CHAR | 2(0) | Planning Level | |||||||||
| FINDI | NUMC | 1(0) | Cash Flow and CM Update | |||||||||
| FIPRO | CHAR | 13(0) | Bracket Number for Finance Project | |||||||||
| G2BET | NUMC | 13(0) | Recurring Costs 2 as Fx.Amount | |||||||||
| G2DAT | CHAR | 8(0) | Second Date for Recurr.Costs | |||||||||
| G2PER | NUMC | 2(0) | Periodic Rhythm in Month | |||||||||
| GABT3 | CHAR | 2(0) | No.of Department III | |||||||||
| GAMTS | CHAR | 28(0) | Magistrates Court Area | |||||||||
| GBAND | CHAR | 7(0) | Volume(s) of Land Register | |||||||||
| GBLAT | CHAR | 14(0) | Page(s) of Land Book | |||||||||
| GBLNR | CHAR | 2(0) | Sequence number | |||||||||
| GBORT | CHAR | 25(0) | Location of Affected Property | |||||||||
| GBSTR | CHAR | 30(0) | Street and Housenumber of Debited Property | |||||||||
| GEABU | CHAR | 8(0) | Rejection User | |||||||||
| GEABX | CHAR | 1(0) | Rejection Indicator | |||||||||
| GEDA2 | CHAR | 8(0) | Authorization Date 2 | |||||||||
| GEDAT | CHAR | 8(0) | Authorization Date 1 | |||||||||
| GEIND | CHAR | 8(0) | Date of Entry | |||||||||
| GENE1 | CHAR | 1(0) | Indicator 1 Authorization | |||||||||
| GENE2 | CHAR | 1(0) | Authorization Indicator 2 | |||||||||
| GENEH | CHAR | 1(0) | Approval Indicator | |||||||||
| GESNR | CHAR | 4(0) | Company Reference Number | |||||||||
| GETAG | NUMC | 2(0) | Business Day Determination | |||||||||
| GEUS2 | CHAR | 8(0) | Authorization User 2 | |||||||||
| GEUSE | CHAR | 8(0) | Authorization User 1 | |||||||||
| GFLUR | CHAR | 3(0) | Parcel | |||||||||
| GFSTK | CHAR | 3(0) | Parcel of Land | |||||||||
| GGEMA | CHAR | 28(0) | LocSubDist. | |||||||||
| GLOED | CHAR | 8(0) | Date of Deletion | |||||||||
| GOART | CHAR | 2(0) | Type of Object | |||||||||
| GRANG | CHAR | 4(0) | Ranking | |||||||||
| GRBAM | CHAR | 28(0) | Land Register in Mag.Court | |||||||||
| GSART | CHAR | 3(0) | Transaction Type | |||||||||
| GSBER | CHAR | 2(0) | Business Area | |||||||||
| GTGGH | CHAR | 1(0) | Business Day Determination | |||||||||
| GUELT | CHAR | 8(0) | Validity of Condition | |||||||||
| HIERO | NUMC | 3(0) | Exit Level | |||||||||
| HKONT | CHAR | 8(0) | General Ledger Account | |||||||||
| IDATA | CHAR | 8(0) | Date Entered | |||||||||
| IDATB | CHAR | 8(0) | Date of Last Change | |||||||||
| INDAT | CHAR | 8(0) | Date of Next Repayment Run | |||||||||
| INKLU | CHAR | 1(0) | Int.Days Inclusive | |||||||||
| INSTD | CHAR | 10(0) | Business Partner | |||||||||
| IUSEA | CHAR | 8(0) | Created by | |||||||||
| IUSEB | CHAR | 8(0) | Last Changed by | |||||||||
| JSOFVERR | CHAR | 1(0) | Immediate Settlement | |||||||||
| KENNR | CHAR | 13(0) | ID number | |||||||||
| KONID | CHAR | 8(0) | Securities acct ID | |||||||||
| KOSTL | CHAR | 8(0) | Cost Center | |||||||||
| KURS1 | NUMC | 9(0) | Rate Specif.for Contract Val. | |||||||||
| KZITI | CHAR | 1(0) | Flag, Whether Only Dividend Bill | |||||||||
| LAND1 | CHAR | 3(0) | Country Key | |||||||||
| LAUSZ | NUMC | 3(0) | Clearing Number | |||||||||
| LFDNR | NUMC | 3(0) | Sequence number | |||||||||
| LFZBE | CHAR | 8(0) | Start of Term | |||||||||
| LFZEN | CHAR | 8(0) | End of Term | |||||||||
| LGRID | CHAR | 3(0) | ID of a Limit Group | |||||||||
| LINIE | CHAR | 13(0) | Line Contract | |||||||||
| LTX | CHAR | 30(0) | Long Text | |||||||||
| LVLNR | NUMC | 2(0) | Sequence number | |||||||||
| MIGDATE | CHAR | 8(0) | Migration Date | |||||||||
| MODIF | CHAR | 2(0) | Company Code Modification | |||||||||
| MWSKZ | CHAR | 2(0) | Value Added Tax Indicator | |||||||||
| NBUDA | CHAR | 8(0) | Next Posting Day | |||||||||
| NIVER | CHAR | 1(0) | No Summarization | |||||||||
| NLFDN | NUMC | 3(0) | Sequence number | |||||||||
| NULLK | CHAR | 1(0) | Indicator for a Null Condition | |||||||||
| NUMKB | CHAR | 2(0) | Number Range for Flow | |||||||||
| NUMKR | CHAR | 2(0) | Number Range | |||||||||
| NUM_AKTDM | NUMC | 1(0) | Decimal Places of AKTDM | |||||||||
| NUM_AKTWR | NUMC | 1(0) | Decimal Places of AKTWR | |||||||||
| NUM_BETRG | NUMC | 1(0) | Decimal Places of BETRG | |||||||||
| NUM_BPROV | NUMC | 1(0) | Decimal Places of BPROV | |||||||||
| NUM_BUWDM | NUMC | 1(0) | Decimal Places of BUWDM | |||||||||
| NUM_BUWWR | NUMC | 1(0) | Decimal Places of BUWWR | |||||||||
| NUM_DEPWE | NUMC | 1(0) | Decimal Places of DEPWE | |||||||||
| NUM_DOFFE | NUMC | 1(0) | Decimal Places of DOFFE | |||||||||
| NUM_DVBET | NUMC | 1(0) | Decimal Places of DVBET | |||||||||
| NUM_G2BET | NUMC | 1(0) | Decimal Places of G2BET | |||||||||
| NUM_KURS1 | NUMC | 1(0) | Decimal Places of KURS1 | |||||||||
| NUM_SICHK | NUMC | 1(0) | Decimal Places of SICHK | |||||||||
| NUM_SICHV | NUMC | 1(0) | Decimal Places of SICHV | |||||||||
| NUM_SOLZU | NUMC | 1(0) | Decimal Places of SOLZU | |||||||||
| NUM_TBZIN | NUMC | 1(0) | Decimal Places of TBZIN | |||||||||
| NUM_TDISA | NUMC | 1(0) | Decimal Places of TDISA | |||||||||
| NUM_TNIBE | NUMC | 1(0) | Decimal Places of TNIBE | |||||||||
| NUM_VKUAK | NUMC | 1(0) | Decimal Places of VKUAK | |||||||||
| NUM_VKUPR | NUMC | 1(0) | Decimal Places of VKUPR | |||||||||
| NUM_VKURE | NUMC | 1(0) | Decimal Places of VKRUE | |||||||||
| NUM_VPROV | NUMC | 1(0) | Decimal Places of VPROV | |||||||||
| NUM_VVENO | NUMC | 1(0) | Decimal Places of VVENO | |||||||||
| NUM_VZIPE | NUMC | 1(0) | Decimal Places of VZIPE | |||||||||
| NUM_WCOUR | NUMC | 1(0) | Decimal Places of WCOUR | |||||||||
| NUM_WKAPE | NUMC | 1(0) | Decimal Places of WKAPE | |||||||||
| NUM_WKORP | NUMC | 1(0) | Decimal Places of WKORP | |||||||||
| NUM_WKURV | NUMC | 1(0) | Decimal Places of WKURV | |||||||||
| NUM_WUMST | NUMC | 1(0) | Decimal Places of WUMST | |||||||||
| NUM_WVBET | NUMC | 1(0) | Decimal Places of WVBET | |||||||||
| NUM_ZASTR | NUMC | 1(0) | Decimal Places of ZASTR | |||||||||
| NUM_ZCAP | NUMC | 1(0) | Decimal Places of ZCAP | |||||||||
| NUM_ZFLOR | NUMC | 1(0) | Decimal Places of ZFLOR | |||||||||
| NUM_ZQUEL | NUMC | 1(0) | Decimal Places of ZQUEL | |||||||||
| NUM_ZSAEF | NUMC | 1(0) | Decimal Places of ZSAEF | |||||||||
| NUM_ZSATZ | NUMC | 1(0) | Decimal Places of ZSATZ | |||||||||
| NUM_ZSEMI | NUMC | 1(0) | Decimal Places of ZSEMI | |||||||||
| NUM_ZSINT | NUMC | 1(0) | Decimal Places of ZSINT | |||||||||
| NUM_ZSPLI | NUMC | 1(0) | Decimal Places of ZSPLI | |||||||||
| OWAER | CHAR | 5(0) | Issuing Currency for Securities | |||||||||
| PROAR | CHAR | 1(0) | Finance Project Type | |||||||||
| PROJN | CHAR | 16(0) | Project Number | |||||||||
| RAHME | CHAR | 13(0) | Master Agreement | |||||||||
| REGEL | CHAR | 2(0) | Bank Working Day Rule | |||||||||
| RESE1 | CHAR | 4(0) | free | |||||||||
| REVAL | NUMC | 2(0) | Accrued Interest Day | |||||||||
| SICHK | NUMC | 9(0) | Hedged Rate | |||||||||
| SICHV | NUMC | 13(0) | Hedging Volume | |||||||||
| SOLZU | NUMC | 5(0) | Reunification Tax | |||||||||
| SPRAS | CHAR | 1(0) | Language Key | |||||||||
| STALT | CHAR | 1(0) | Old Status | |||||||||
| STATI | CHAR | 1(0) | Contract Status | |||||||||
| STSCHL | CHAR | 2(0) | Control Key | |||||||||
| STYPE | CHAR | 1(0) | Status Category | |||||||||
| SUMDD | CHAR | 8(0) | Date of Totals Update | |||||||||
| SZAST | CHAR | 1(0) | Interest Income Tax Calculation | |||||||||
| TARTE | CHAR | 1(0) | Repayment Type | |||||||||
| TBBIS | CHAR | 8(0) | Provision Interest to | |||||||||
| TBEIN | CHAR | 1(0) | Loan Commitment Interest | |||||||||
| TBPER | NUMC | 2(0) | Periodic Rhythm in Months | |||||||||
| TBVON | CHAR | 8(0) | Provision Date from | |||||||||
| TBZIN | NUMC | 8(0) | Loan Commitment Interest Rate in % | |||||||||
| TDISA | NUMC | 9(0) | Disbursement Rate in % | |||||||||
| TGESP | CHAR | 25(0) | Contact | |||||||||
| TKUAR | CHAR | 1(0) | Termination Type | |||||||||
| TKUEN | CHAR | 8(0) | Termination Date | |||||||||
| TLZBN | CHAR | 12(0) | German State Central Bank - Loan Reporting Number | |||||||||
| TNIBE | NUMC | 13(0) | Non-Acceptance Compensation | |||||||||
| TNIGU | CHAR | 1(0) | Reason for Non-Acceptance | |||||||||
| TNISD | CHAR | 8(0) | Non-Acceptance Compensation | |||||||||
| TSIH1 | CHAR | 3(0) | Description, Security | |||||||||
| TST0S | CHAR | 1(0) | Initial Status of TST0 | |||||||||
| TST5S | CHAR | 1(0) | Initial Status of TST5 | |||||||||
| TURDA | CHAR | 8(0) | Document Date | |||||||||
| TURNR | CHAR | 15(0) | Document Number | |||||||||
| TURRU | CHAR | 8(0) | Document Returned | |||||||||
| TVORS | CHAR | 1(0) | Interest Calculation Marker | |||||||||
| TXNAU | CHAR | 1(0) | Investment Type | |||||||||
| TZUSA | CHAR | 8(0) | Date of Loan Commitment | |||||||||
| ULTGH | CHAR | 1(0) | Last Day of the Month - Marker | |||||||||
| ULTIM | CHAR | 1(0) | Last Day of the Month - Marker for Outbox | |||||||||
| UMSKZ | CHAR | 1(0) | Special G/L Indicator | |||||||||
| USTRU | CHAR | 8(0) | Account Assignment Reference | |||||||||
| VABTR | NUMC | 2(0) | Number of Assignments | |||||||||
| VADAT | CHAR | 8(0) | Variable Interest Date | |||||||||
| VAN1D | CHAR | 8(0) | Offer Accepted on | |||||||||
| VAN2D | CHAR | 8(0) | Offer Can be Taken up | |||||||||
| VANGD | CHAR | 8(0) | Offer Made on | |||||||||
| VANGE | CHAR | 1(0) | Marker, Whether Offer Made | |||||||||
| VANSD | CHAR | 8(0) | Written acceptance on | |||||||||
| VANTD | CHAR | 8(0) | Accepted by Telephone on | |||||||||
| VANVO | CHAR | 1(0) | Acceptance Marker | |||||||||
| VARAD | CHAR | 8(0) | SB Applic.on | |||||||||
| VARGD | CHAR | 8(0) | Supervisory Board Authoriz.on | |||||||||
| VARID | NUMC | 4(0) | SB Template Identification | |||||||||
| VAUSD | CHAR | 8(0) | Inclusion of Document in Security | |||||||||
| VAVAD | CHAR | 8(0) | . | |||||||||
| VBAAD | CHAR | 8(0) | . | |||||||||
| VBAGD | CHAR | 8(0) | . | |||||||||
| VBAID | CHAR | 20(0) | . | |||||||||
| VDSBD | CHAR | 8(0) | . | |||||||||
| VELNR | CHAR | 2(0) | Sequence number | |||||||||
| VENDK | CHAR | 25(0) | . | |||||||||
| VERDA | CHAR | 2(0) | . | |||||||||
| VGBAN | CHAR | 1(0) | . | |||||||||
| VKRED | CHAR | 8(0) | . | |||||||||
| VKUAK | NUMC | 9(0) | . | |||||||||
| VKUBD | CHAR | 8(0) | . | |||||||||
| VKUKZ | CHAR | 1(0) | Indicators | |||||||||
| VKUPR | NUMC | 9(0) | . | |||||||||
| VKURE | NUMC | 9(0) | . | |||||||||
| VKUVD | CHAR | 8(0) | . | |||||||||
| VLVAN | CHAR | 2(0) | . | |||||||||
| VLVBT | NUMC | 4(0) | . | |||||||||
| VLVID | NUMC | 2(0) | . | |||||||||
| VLVKZ | CHAR | 1(0) | Indicators | |||||||||
| VLVLZ | CHAR | 3(0) | . | |||||||||
| VLVNE | CHAR | 24(0) | . | |||||||||
| VLVNR | CHAR | 12(0) | . | |||||||||
| VLVSU | NUMC | 14(0) | . | |||||||||
| VLVTA | CHAR | 10(0) | . | |||||||||
| VORGA | CHAR | 2(0) | . | |||||||||
| VOZEI | CHAR | 1(0) | Sign for Item | |||||||||
| VPROV | NUMC | 8(0) | Agent Commission | |||||||||
| VREKD | CHAR | 8(0) | . | |||||||||
| VUABE | CHAR | 1(0) | . | |||||||||
| VUBTH | CHAR | 1(0) | . | |||||||||
| VUGBA | CHAR | 1(0) | . | |||||||||
| VUGBB | CHAR | 1(0) | . | |||||||||
| VUKAB | CHAR | 1(0) | . | |||||||||
| VUMUR | CHAR | 1(0) | . | |||||||||
| VUNPB | CHAR | 1(0) | . | |||||||||
| VUSCH | CHAR | 1(0) | . | |||||||||
| VUSOU | CHAR | 1(0) | . | |||||||||
| VVABD | CHAR | 8(0) | . | |||||||||
| VVALD | CHAR | 8(0) | . | |||||||||
| VVBEI | CHAR | 1(0) | . | |||||||||
| VVBPO | CHAR | 1(0) | . | |||||||||
| VVBSO | CHAR | 1(0) | . | |||||||||
| VVBUR | CHAR | 1(0) | . | |||||||||
| VVEBE | CHAR | 1(0) | . | |||||||||
| VVEKZ | CHAR | 1(0) | Indicators | |||||||||
| VVENO | NUMC | 13(0) | . | |||||||||
| VVEUE | CHAR | 1(0) | . | |||||||||
| VVEWP | CHAR | 13(0) | . | |||||||||
| VVPRT | CHAR | 1(0) | . | |||||||||
| VZIPE | NUMC | 5(0) | . | |||||||||
| WAART | CHAR | 1(0) | Asset Type | |||||||||
| WAERS | CHAR | 5(0) | Currency Key | |||||||||
| WCOUR | NUMC | 8(0) | . | |||||||||
| WERKS | CHAR | 2(0) | Plant | |||||||||
| WFCID | CHAR | 2(0) | Factory calendar key | |||||||||
| WKAPE | NUMC | 5(0) | . | |||||||||
| WKORP | NUMC | 5(0) | . | |||||||||
| WKURV | NUMC | 15(0) | . | |||||||||
| WUMST | NUMC | 5(0) | . | |||||||||
| WVBET | CHAR | 13(0) | . | |||||||||
| WVERA | CHAR | 1(0) | . | |||||||||
| ZAHID | CHAR | 2(0) | Payment Meth.ID Account of Payee | |||||||||
| ZASTR | NUMC | 5(0) | . | |||||||||
| ZBASI | CHAR | 10(0) | . | |||||||||
| ZBEGI | CHAR | 8(0) | . | |||||||||
| ZCAP | NUMC | 8(0) | . | |||||||||
| ZDIDA | CHAR | 8(0) | . | |||||||||
| ZFLOR | NUMC | 8(0) | . | |||||||||
| ZIAUS | CHAR | 1(0) | . | |||||||||
| ZIERM | CHAR | 1(0) | Effective Interest Method | |||||||||
| ZIZIN | CHAR | 1(0) | . | |||||||||
| ZKALE | CHAR | 1(0) | . | |||||||||
| ZPABG | CHAR | 1(0) | . | |||||||||
| ZPERI | NUMC | 2(0) | . | |||||||||
| ZPINT | CHAR | 1(0) | . | |||||||||
| ZQUEL | NUMC | 5(0) | . | |||||||||
| ZRPER | NUMC | 2(0) | Periodic Rhythm in Months | |||||||||
| ZRUND | NUMC | 1(0) | . | |||||||||
| ZSAEF | NUMC | 8(0) | . | |||||||||
| ZSAMM | CHAR | 1(0) | . | |||||||||
| ZSATZ | NUMC | 8(0) | . | |||||||||
| ZSEMI | NUMC | 8(0) | Issue Yield | |||||||||
| ZSINT | NUMC | 8(0) | . | |||||||||
| ZSPLI | NUMC | 8(0) | . | |||||||||
| ZSRVZ | CHAR | 1(0) | . | |||||||||
| ZSTAR | CHAR | 8(0) | . | |||||||||
| ZVARI | CHAR | 1(0) | . | |||||||||
| ZVINT | CHAR | 1(0) | . | |||||||||
| ZVPTT | NUMC | 2(0) | . |