SAP Table J11TRDSVV stores RF-VV R/2 Loans: Master Datadata

  

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!


SAP J11TRDSVV dictionary attributes

Object Name: J11TRDSVV
Dictionary Type: Structure
Description: RF-VV R/2 Loans: Master Data


J11TRDSVV field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
ABNKRCHAR15(0) Bank Reference (e.g. account number)
ACTIOCHAR1(0) Action in R/3
AGRPPCHAR8(0) Grouping Indicator
AKTDMNUMC13(0) Acquisition Value Local Curr.
AKTWRNUMC13(0) Acquisition Value Foreign Curr.
ALANDCHAR3(0) Country Key
ANLAGCHAR1(0) Product Category
ANNUICHAR1(0) Indicator: Same Rate
ARCHICHAR1(0) Archiving Category
ARDATCHAR8(0) Archiving Date
AREFNCHAR8(0) Reference Number
ATEX1CHAR25(0) Description 1
ATEX2CHAR25(0) Decription 2
AUFNRNUMC8(0) Order Number
AUFPSNUMC2(0) Item Number of Order
AUSW2CHAR60(0) Field Selection
AUSWACHAR60(0) Field Selection
AUSZACHAR1(0) Disbursement Made
AVERMCHAR10(0) Agents
BARTECHAR1(0) Calculation Base for Provision
BASISNUMC1(0) Indicator for Calculation
BATCHCHAR1(0) Status for Batch Update
BDATVCHAR8(0) Date of Specified Valuation
BETRGNUMC13(0) Amount of Condition
BITXTNUMC8(0) Internal Long Text Number
BKRUECHAR8(0) Bank Account
BNDATCHAR8(0) New Negotiation Date
BPROVNUMC8(0) Provision Commission
BSAKNCHAR8(0) Balance Sheet Account
BUHALCHAR1(0) Control of RF Postings
BUKRSCHAR2(0) Company code
BUWDMNUMC13(0) Book Value in LC Only
BUWWRNUMC13(0) Book Value in FC
DANARNUMC2(0) Form
DANLANUMC3(0) Premium Reserve Allocation
DENDECHAR8(0) Term End for Annuities
DEPWENUMC13(0) Nominval Value of Sec.Acct
DISAGCHAR1(0) Discount COllection
DKENNCHAR2(0) Indicator
DKURECHAR1(0) Determination of Rate Gain/Loss
DOFFENUMC13(0) Open Local Currency Amount
DUNABNUMC2(0) Subsection
DVBETNUMC13(0) Contract Value or Nominal Value
EBENECHAR2(0) Planning Level
FINDINUMC1(0) Cash Flow and CM Update
FIPROCHAR13(0) Bracket Number for Finance Project
G2BETNUMC13(0) Recurring Costs 2 as Fx.Amount
G2DATCHAR8(0) Second Date for Recurr.Costs
G2PERNUMC2(0) Periodic Rhythm in Month
GABT3CHAR2(0) No.of Department III
GAMTSCHAR28(0) Magistrates Court Area
GBANDCHAR7(0) Volume(s) of Land Register
GBLATCHAR14(0) Page(s) of Land Book
GBLNRCHAR2(0) Sequence number
GBORTCHAR25(0) Location of Affected Property
GBSTRCHAR30(0) Street and Housenumber of Debited Property
GEABUCHAR8(0) Rejection User
GEABXCHAR1(0) Rejection Indicator
GEDA2CHAR8(0) Authorization Date 2
GEDATCHAR8(0) Authorization Date 1
GEINDCHAR8(0) Date of Entry
GENE1CHAR1(0) Indicator 1 Authorization
GENE2CHAR1(0) Authorization Indicator 2
GENEHCHAR1(0) Approval Indicator
GESNRCHAR4(0) Company Reference Number
GETAGNUMC2(0) Business Day Determination
GEUS2CHAR8(0) Authorization User 2
GEUSECHAR8(0) Authorization User 1
GFLURCHAR3(0) Parcel
GFSTKCHAR3(0) Parcel of Land
GGEMACHAR28(0) LocSubDist.
GLOEDCHAR8(0) Date of Deletion
GOARTCHAR2(0) Type of Object
GRANGCHAR4(0) Ranking
GRBAMCHAR28(0) Land Register in Mag.Court
GSARTCHAR3(0) Transaction Type
GSBERCHAR2(0) Business Area
GTGGHCHAR1(0) Business Day Determination
GUELTCHAR8(0) Validity of Condition
HIERONUMC3(0) Exit Level
HKONTCHAR8(0) General Ledger Account
IDATACHAR8(0) Date Entered
IDATBCHAR8(0) Date of Last Change
INDATCHAR8(0) Date of Next Repayment Run
INKLUCHAR1(0) Int.Days Inclusive
INSTDCHAR10(0) Business Partner
IUSEACHAR8(0) Created by
IUSEBCHAR8(0) Last Changed by
JSOFVERRCHAR1(0) Immediate Settlement
KENNRCHAR13(0) ID number
KONIDCHAR8(0) Securities acct ID
KOSTLCHAR8(0) Cost Center
KURS1NUMC9(0) Rate Specif.for Contract Val.
KZITICHAR1(0) Flag, Whether Only Dividend Bill
LAND1CHAR3(0) Country Key
LAUSZNUMC3(0) Clearing Number
LFDNRNUMC3(0) Sequence number
LFZBECHAR8(0) Start of Term
LFZENCHAR8(0) End of Term
LGRIDCHAR3(0) ID of a Limit Group
LINIECHAR13(0) Line Contract
LTXCHAR30(0) Long Text
LVLNRNUMC2(0) Sequence number
MIGDATECHAR8(0) Migration Date
MODIFCHAR2(0) Company Code Modification
MWSKZCHAR2(0) Value Added Tax Indicator
NBUDACHAR8(0) Next Posting Day
NIVERCHAR1(0) No Summarization
NLFDNNUMC3(0) Sequence number
NULLKCHAR1(0) Indicator for a Null Condition
NUMKBCHAR2(0) Number Range for Flow
NUMKRCHAR2(0) Number Range
NUM_AKTDMNUMC1(0) Decimal Places of AKTDM
NUM_AKTWRNUMC1(0) Decimal Places of AKTWR
NUM_BETRGNUMC1(0) Decimal Places of BETRG
NUM_BPROVNUMC1(0) Decimal Places of BPROV
NUM_BUWDMNUMC1(0) Decimal Places of BUWDM
NUM_BUWWRNUMC1(0) Decimal Places of BUWWR
NUM_DEPWENUMC1(0) Decimal Places of DEPWE
NUM_DOFFENUMC1(0) Decimal Places of DOFFE
NUM_DVBETNUMC1(0) Decimal Places of DVBET
NUM_G2BETNUMC1(0) Decimal Places of G2BET
NUM_KURS1NUMC1(0) Decimal Places of KURS1
NUM_SICHKNUMC1(0) Decimal Places of SICHK
NUM_SICHVNUMC1(0) Decimal Places of SICHV
NUM_SOLZUNUMC1(0) Decimal Places of SOLZU
NUM_TBZINNUMC1(0) Decimal Places of TBZIN
NUM_TDISANUMC1(0) Decimal Places of TDISA
NUM_TNIBENUMC1(0) Decimal Places of TNIBE
NUM_VKUAKNUMC1(0) Decimal Places of VKUAK
NUM_VKUPRNUMC1(0) Decimal Places of VKUPR
NUM_VKURENUMC1(0) Decimal Places of VKRUE
NUM_VPROVNUMC1(0) Decimal Places of VPROV
NUM_VVENONUMC1(0) Decimal Places of VVENO
NUM_VZIPENUMC1(0) Decimal Places of VZIPE
NUM_WCOURNUMC1(0) Decimal Places of WCOUR
NUM_WKAPENUMC1(0) Decimal Places of WKAPE
NUM_WKORPNUMC1(0) Decimal Places of WKORP
NUM_WKURVNUMC1(0) Decimal Places of WKURV
NUM_WUMSTNUMC1(0) Decimal Places of WUMST
NUM_WVBETNUMC1(0) Decimal Places of WVBET
NUM_ZASTRNUMC1(0) Decimal Places of ZASTR
NUM_ZCAPNUMC1(0) Decimal Places of ZCAP
NUM_ZFLORNUMC1(0) Decimal Places of ZFLOR
NUM_ZQUELNUMC1(0) Decimal Places of ZQUEL
NUM_ZSAEFNUMC1(0) Decimal Places of ZSAEF
NUM_ZSATZNUMC1(0) Decimal Places of ZSATZ
NUM_ZSEMINUMC1(0) Decimal Places of ZSEMI
NUM_ZSINTNUMC1(0) Decimal Places of ZSINT
NUM_ZSPLINUMC1(0) Decimal Places of ZSPLI
OWAERCHAR5(0) Issuing Currency for Securities
PROARCHAR1(0) Finance Project Type
PROJNCHAR16(0) Project Number
RAHMECHAR13(0) Master Agreement
REGELCHAR2(0) Bank Working Day Rule
RESE1CHAR4(0) free
REVALNUMC2(0) Accrued Interest Day
SICHKNUMC9(0) Hedged Rate
SICHVNUMC13(0) Hedging Volume
SOLZUNUMC5(0) Reunification Tax
SPRASCHAR1(0) Language Key
STALTCHAR1(0) Old Status
STATICHAR1(0) Contract Status
STSCHLCHAR2(0) Control Key
STYPECHAR1(0) Status Category
SUMDDCHAR8(0) Date of Totals Update
SZASTCHAR1(0) Interest Income Tax Calculation
TARTECHAR1(0) Repayment Type
TBBISCHAR8(0) Provision Interest to
TBEINCHAR1(0) Loan Commitment Interest
TBPERNUMC2(0) Periodic Rhythm in Months
TBVONCHAR8(0) Provision Date from
TBZINNUMC8(0) Loan Commitment Interest Rate in %
TDISANUMC9(0) Disbursement Rate in %
TGESPCHAR25(0) Contact
TKUARCHAR1(0) Termination Type
TKUENCHAR8(0) Termination Date
TLZBNCHAR12(0) German State Central Bank - Loan Reporting Number
TNIBENUMC13(0) Non-Acceptance Compensation
TNIGUCHAR1(0) Reason for Non-Acceptance
TNISDCHAR8(0) Non-Acceptance Compensation
TSIH1CHAR3(0) Description, Security
TST0SCHAR1(0) Initial Status of TST0
TST5SCHAR1(0) Initial Status of TST5
TURDACHAR8(0) Document Date
TURNRCHAR15(0) Document Number
TURRUCHAR8(0) Document Returned
TVORSCHAR1(0) Interest Calculation Marker
TXNAUCHAR1(0) Investment Type
TZUSACHAR8(0) Date of Loan Commitment
ULTGHCHAR1(0) Last Day of the Month - Marker
ULTIMCHAR1(0) Last Day of the Month - Marker for Outbox
UMSKZCHAR1(0) Special G/L Indicator
USTRUCHAR8(0) Account Assignment Reference
VABTRNUMC2(0) Number of Assignments
VADATCHAR8(0) Variable Interest Date
VAN1DCHAR8(0) Offer Accepted on
VAN2DCHAR8(0) Offer Can be Taken up
VANGDCHAR8(0) Offer Made on
VANGECHAR1(0) Marker, Whether Offer Made
VANSDCHAR8(0) Written acceptance on
VANTDCHAR8(0) Accepted by Telephone on
VANVOCHAR1(0) Acceptance Marker
VARADCHAR8(0) SB Applic.on
VARGDCHAR8(0) Supervisory Board Authoriz.on
VARIDNUMC4(0) SB Template Identification
VAUSDCHAR8(0) Inclusion of Document in Security
VAVADCHAR8(0) .
VBAADCHAR8(0) .
VBAGDCHAR8(0) .
VBAIDCHAR20(0) .
VDSBDCHAR8(0) .
VELNRCHAR2(0) Sequence number
VENDKCHAR25(0) .
VERDACHAR2(0) .
VGBANCHAR1(0) .
VKREDCHAR8(0) .
VKUAKNUMC9(0) .
VKUBDCHAR8(0) .
VKUKZCHAR1(0) Indicators
VKUPRNUMC9(0) .
VKURENUMC9(0) .
VKUVDCHAR8(0) .
VLVANCHAR2(0) .
VLVBTNUMC4(0) .
VLVIDNUMC2(0) .
VLVKZCHAR1(0) Indicators
VLVLZCHAR3(0) .
VLVNECHAR24(0) .
VLVNRCHAR12(0) .
VLVSUNUMC14(0) .
VLVTACHAR10(0) .
VORGACHAR2(0) .
VOZEICHAR1(0) Sign for Item
VPROVNUMC8(0) Agent Commission
VREKDCHAR8(0) .
VUABECHAR1(0) .
VUBTHCHAR1(0) .
VUGBACHAR1(0) .
VUGBBCHAR1(0) .
VUKABCHAR1(0) .
VUMURCHAR1(0) .
VUNPBCHAR1(0) .
VUSCHCHAR1(0) .
VUSOUCHAR1(0) .
VVABDCHAR8(0) .
VVALDCHAR8(0) .
VVBEICHAR1(0) .
VVBPOCHAR1(0) .
VVBSOCHAR1(0) .
VVBURCHAR1(0) .
VVEBECHAR1(0) .
VVEKZCHAR1(0) Indicators
VVENONUMC13(0) .
VVEUECHAR1(0) .
VVEWPCHAR13(0) .
VVPRTCHAR1(0) .
VZIPENUMC5(0) .
WAARTCHAR1(0) Asset Type
WAERSCHAR5(0) Currency Key
WCOURNUMC8(0) .
WERKSCHAR2(0) Plant
WFCIDCHAR2(0) Factory calendar key
WKAPENUMC5(0) .
WKORPNUMC5(0) .
WKURVNUMC15(0) .
WUMSTNUMC5(0) .
WVBETCHAR13(0) .
WVERACHAR1(0) .
ZAHIDCHAR2(0) Payment Meth.ID Account of Payee
ZASTRNUMC5(0) .
ZBASICHAR10(0) .
ZBEGICHAR8(0) .
ZCAPNUMC8(0) .
ZDIDACHAR8(0) .
ZFLORNUMC8(0) .
ZIAUSCHAR1(0) .
ZIERMCHAR1(0) Effective Interest Method
ZIZINCHAR1(0) .
ZKALECHAR1(0) .
ZPABGCHAR1(0) .
ZPERINUMC2(0) .
ZPINTCHAR1(0) .
ZQUELNUMC5(0) .
ZRPERNUMC2(0) Periodic Rhythm in Months
ZRUNDNUMC1(0) .
ZSAEFNUMC8(0) .
ZSAMMCHAR1(0) .
ZSATZNUMC8(0) .
ZSEMINUMC8(0) Issue Yield
ZSINTNUMC8(0) .
ZSPLINUMC8(0) .
ZSRVZCHAR1(0) .
ZSTARCHAR8(0) .
ZVARICHAR1(0) .
ZVINTCHAR1(0) .
ZVPTTNUMC2(0) .