JBIUDERIV SAP (Transfer Structure for Derivatives) Structure details

Dictionary Type: Structure
Description: Transfer Structure for Derivatives




ABAP Code to SELECT data from JBIUDERIV
Related tables to JBIUDERIV
Access table JBIUDERIV




Structure field list including key, data, relationships and ABAP select examples

JBIUDERIV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Transfer Structure for Derivatives" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_JBIUDERIV TYPE JBIUDERIV.

The JBIUDERIV table consists of various fields, each holding specific information or linking keys about Transfer Structure for Derivatives data available in SAP. These include MANDT (Client), BUKRS (Company Code), RFHA (Financial Transaction), CRUSER (Entered by).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP JBIUDERIV structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RFHAFinancial Transaction TB_RFHACHAR13VTBFHAALPHAT_RFHAFANVTBA
CRUSEREntered by TB_CRUSERCHAR12SYCHAR12
DCRDATEntered On TB_DCRDATDATS8DATUM
TCRTIMEntry Time TB_TCRTIMTIMS6UZEIT
UPUSERLast Changed by TB_UPUSERCHAR12SYCHAR12
DUPDATChanged on TB_DUPDATDATS8DATUM
TUPTIMTime changed TB_TUPTIMTIMS6UZEIT
RANTYPContract Type RANTYPCHAR1RANTYP
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
SFGTYPTransaction Category TB_SFGTYPNUMC3AT01T_SFGTYP
SGSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3AT10T_SFHAARTT02C_AT10
RGATTClass TI_RGATTCHAR13ALPHAT_RGATTT04
RMAIDMaster Agreement TB_RMAIDCHAR10VTBMAALPHAT_RMAIDTMAVTMA
RFHAZUNRNumber status of activity TB_RFHAZUNNUMC5T_RFHAZU
RFHAZULLast Active Transaction Activity TB_RFHAZULNUMC5T_RFHAZU
SAKTIVActive Status of Transaction or Activity TB_SAKTIVNUMC1T_SAKTIV
KONTRHBusiness Partner Number TB_KUNNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SROLEXT3-Byte field CHAR3CHAR3Assigned to domainCHAR3
RGARANTGuarantor of Financial Transaction TB_RGARANT_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Management RREFKONT_OBSOLETECHAR8T037SUSTRUKRE
RREFKONT2Obsolete: Accnt Assignment Ref. in Fin. Assets Management RREFKONT_OBSOLETECHAR8T037SUSTRUKRE
RPORTBPortfolio RPORTBCHAR10TWPOBRPORTBT50H_RPORTB_CORE
WGSCHFTCurrency of transaction TB_WGSCHFTCUKY5TCURCWAERS
WGSCHFT1Currency of Outgoing Side TB_WGSCHF1CUKY5Assigned to domainWAERS
WGSCHFT2Currency of Incoming Side TB_WGSCHF2CUKY5Assigned to domainWAERS
AMTINPUTNote field for traded amount forex transactions TB_AMTINCHAR1TX_AMTIN
DBLFZTerm Start TB_DBLFZDATS8DATUM
SKALIDFactory calendar SKALIDCHAR2TFACDWFCIDH_TFACD
SKALID2Factory calendar SKALIDCHAR2TFACDWFCIDH_TFACD
JLIMITLimit indicator TB_JLIMITCHAR1XFELD
AKUENDPeriod of Notice TB_AKUENDNUMC2T_AKUEND
SKUENDUnit of Period of Notice TB_SKUENDNUMC1T_SKUEND
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
RLDEPOSecurities Account VRLDEPOCHAR10TWD01RLDEPODEP
ZUONRFinance Project TB_TFPROJCHAR13T_TFPROJ
DELFZTerm End TB_DELFZDATS8DATUM
ABWTYPProcessing Category TB_ABWTYPCHAR5AT05T_ABWTYP
TBEGRUAuthorization Group TBEGRUCHAR4TRBRGTRBEGRU
VRFHAReference transaction (Rollover/premature settlement) TB_VORFHACHAR13Assigned to domainALPHAT_RFHA
SINCLBECalculation Period: Start Inclusive vs. End Inclusive TB_SINCLBECHAR1T_SINCLBE
SNPVCALNPV Calculation TB_SNPVCALCHAR1T_SNPVCAL
SRNDNGRounding of Amount from Generated Flows TB_SRNDNGCHAR1TFM_SROUND
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
SFRGZUSTTransaction Release: Release Status TB_FRGZUSTCHAR1T_FRGZUST
RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
RCOMVALCLGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4TRGC_COM_VALCLTPM_COM_VAL_CLASSCVC
FACILITYNRTransaction Number of Facility TB_FACILITYNRCHAR13VTBFHAALPHAT_RFHAF4_FTR_FC
FACILITYBUKRSCompany Code of Facility TB_FACILITYBUKRSCHAR4T001BUKRSH_T001
POSACCFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10TRFT_POS_ACCOUNTTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
RCOMVALCL2General Valuation Class TPM_COM_VAL_CLASSNUMC4TRGC_COM_VALCLTPM_COM_VAL_CLASSCVC
FUNDFund FM_FUNDCHAR10Assigned to domainBP_GEBERFIC
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
TIMESTAMP_DEALUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TRCOT_CTY_MASTERTPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
RPORTB2Portfolio RPORTBCHAR10TWPOBRPORTBT50H_RPORTB_CORE
COMMODITY_ID1Commodity ID TRCO_COMM_IDCHAR18TRCOT_CTY_MASTERTPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
COMMODITY_ID2Commodity ID TRCO_COMM_IDCHAR18TRCOT_CTY_MASTERTPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
CLEARING_OPTIONCentral Clearing Option (TREA) TPM_TREA_CLEARING_OPTNUMC1TPM_TREA_CLEARING_OPT
CLEARING_STATUSClearing Status (TREA) TPM_TREA_CLEARING_STATUSNUMC1TPM_TREA_CLEARING_STATUS
CLEARING_DATEPlanned Clearing Date TPM_TREA_CLEARING_DATEDATS8TPM_TREA_CLEARING_DATE
EXT_ACCOUNTExternal Account TPM_EXT_ACCOUNTCHAR10TPM_EXT_ACCOUNTTREA_EATREATH_EXT_ACCOUNT
CLEAR_DATE_ACTActual Clearing Date TPM_TREA_CLEARING_DATE_ACTDATS8TPM_TREA_CLEARING_DATE
SCONDITIONIndicates Whether Financial Trans. Is Based on a Condition FTR_CONDITION_USEDCHAR1FTR_CONDITION_USED
RISK_MITIGATINGRisk Mitigation Indicator FTR_THRESHOLD_RISK_MITIGATINGCHAR1FLAG
.INCLU--AP 0
.INCLU--AP 0
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
VBELNSales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
VBELPSales document item VBELPNUMC6Assigned to domainPOSNR
RFHAZUTransaction activity TB_RFHAZUNUMC5T_RFHAZUFAS
SFGZUSTTTransaction Activity Category TB_SFGZUTYNUMC2AT02T_SFGZUTYC_AT02
SFUNKTVTransition Function from Directly Preceding Activity TB_SFUNKTVCHAR4AT60T_FUNKTION
SFUNKTLLatest function used in editing activity TB_SFUNKTLCHAR4AT60T_FUNKTION
ROFHAZUPrevious Activity TB_ROFHAZUNUMC5T_RFHAZU
RFHAZUXPrevious activity, which is supplemented by current activity TB_RFHAZUXNUMC5T_RFHAZU
SSTOGRDReason for Reversal SSTOGRDCHAR2TZSTSSTOGRD
RDEALERTrader RDEALERCHAR12TZDEARDEALER
DVTRABContract Conclusion Date TB_DVTRABDATS8DATUM
TVTRABTime of contract conclusion TB_TVTRABTIMS6UZEIT
GSPPARTContact Person TB_GSPPARTCHAR19TEXT19
XAKTFile Number XAKTCHAR32CHAR32
NORDEXTExternal Reference TB_NORDEXTCHAR16FTI_CHAR16LOW
SINCLEEnd of Term Inclusive Indicator TB_SINCLECHAR1XFELD
DZSTNDLast activity transition date (e.g. for rollover) TB_DZSTNDDATS8DATUM
SZNSPROInterest Handling with Rollover TB_SZNSPRONUMC1T_SZNSPRO
DZNSSTDPayment date for deferred interest TB_DZNSSTDDATS8DATUM
KKURSRate of Forex Transaction TB_KKURSDEC13(9) TB_KKURS
KKASSASpot Rate TB_KKASSADEC13(9) TB_KKURS
KSWAPSwap Rate TB_KSWAPDEC13(9) T_SWKURS
WLWAERSLeading currency TB_WLWAERSCUKY5TCURCWAERS
WFWAERSFollowing Currency TB_WFWAERSCUKY5TCURLWAERS
LIMITARTLimit type TB_LIMITARCHAR2ATORT_LIMITAR
LIMITDATLimit date TB_LIMITDADATS8DATUM
LIWAERSReference currency for limit TB_LIWAERSCUKY5TCURCWAERS
KWLIQUILiquidity effect for rollover TX_KWLIQDEC13(9) T_SWKURS
RKONDGRDirection of Transaction TB_RKONDGRNUMC1T_RKONDGR
RKONDCondition TB_KONDNUMC4T_KOND
DGUEL_KPCondition Item Valid From DGUEL_KPDATS8DATUM
NSTUFELevel number of condition item for recurring payments NSTUFENUMC2NUMC2
SALTKONDUnit for supplementary condition items TB_SALKONDNUMC4SKONDGRP
SZINSANPCross-referenced condition grp for interest rate adjustment SZINSANPNUMC4SKONDGRP
JNULLKONCondition Form JNULLKONCHAR1SKONDF
SKOARTCondition Type (Smallest Subdivision of Condition Records) SKOARTNUMC4TZK01SKOART
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
SBKKLASClassification of flows and conditions TB_SBKKLASCHAR1T_SBKKLAS
SBKTYPCategory of Flows and Conditions TB_SBKTYPCHAR2AT08T_SBKTYP
PKONDPercentage rate for condition items PKONDDEC10(7) DECV3_7
BKONDCondition item currency amount BKONDCURR13(2) WERTV7
SWHRKONDCurrency of Condition Item SWHRKONDCUKY5TCURCWAERS
SBASISCalculation base indicator SBASISCHAR4Assigned to domainVVSBASIS
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
SZSREFReference Interest Rate SZSREFCHAR10T056RZIREFKU
SFORMREFFormula Reference TB_XFORMBECHAR4Assigned to domainT_FORMBE
SVARNAMEVariable Name TB_VARNAMECHAR4T_XFELD04
AMMRHYFrequency in months AMMRHYNUMC3NUMC03
ATTRHYFrequency in Days ATTRHYNUMC3NUMC03
DVALUTCalculation Date DVALUTDATS8DATUM
SVULTMonth-end indicator for calculation date VVSBULTCHAR1JFLAGG
SVWERKWorking Day Shift for Calculation Day TB_SVWERKNUMC1T_SWERK
SVMETHMethod for determining the next value date TB_SVMETHNUMC1T_SVMETH
AVGSTAGENumber of Days for Relative Calculation of Value Date TB_AVGSTAGINT410T_GSTAGE
DFAELLDue date DFAELLDATS8DATUM
SFULTMonth-End Indicator for Due Date SFULTCHAR1VVSULT
SFWERKWorking Day Shift for Due Date TB_SFWERKNUMC1T_SWERK
SFMETHMethod for determining the next due date TB_SFMETHNUMC1T_SFMETH
AFGSTAGENumber of days for rel. determination of due date TB_AFGSTAGINT410T_GSTAGE
SDWERKWorking Day Shift for Payment Date TB_SDWERKNUMC1T_SWERK
DZFESTInterest rate fixing date TB_DZFESTDATS8DATUM
AZGSTAGENo. of days for relative determinatn of interest fixing TB_AZGSTAGINT410T_GSTAGE
DZSREFReference interest rate fixing date TB_ZSREFDATS8DATUM
SHERKUNFTDisplay Area of Flow or Condition TB_SHERKCHAR4T_XFELD04
SRHYTHMFrequency Indicator TB_SRHYTHMNUMC1T_SRHYTHM
SBERFIMACalculation category for cash flow calculator SBEWFIMACHAR4AT40SBEWFIMA
SZWERKShift to working day for interest fixing date VVSZWERKNUMC1T_SWERK
RHANDPLExchange VVRHANDPLCHAR10Assigned to domainVVRHANDPLWHP
SKURSARTRate/Price Type - Treasury Instruments TI_KURSARTCHAR2Assigned to domainVVSKURSARTRATETYPE_F4
SFVMETHUpdate method for calculation date/due date TB_SFVMETHNUMC2T_SFVMETH
SERBTERMFiMa indicator: Date and frequency inheritance for condition TFMERBTERMCHAR1TFMERBTERM
SFRANZShift Due Date TFMSFRANZNUMC1TFMSFRANZ
MODEMode of Data Flow JBSMODECHAR1JBSMODE

Key field Non-key field



How do I retrieve data from SAP structure JBIUDERIV using ABAP code?

As JBIUDERIV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on JBIUDERIV as there is no data to select.

How to access SAP table JBIUDERIV

Within an ECC or HANA version of SAP you can also view further information about JBIUDERIV and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!