JBDTRIDAT SAP (Flow Structure Underlying for Selection from TIF) Structure details

Dictionary Type: Structure
Description: Flow Structure Underlying for Selection from TIF




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




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

JBDTRIDAT 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 "Flow Structure Underlying for Selection from TIF" 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_JBDTRIDAT TYPE JBDTRIDAT.

The JBDTRIDAT table consists of various fields, each holding specific information or linking keys about Flow Structure Underlying for Selection from TIF data available in SAP. These include MANDT (Client), RANTYP (Contract Type), BUKRS (Company Code), RANL (Security ID Number).. 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 JBDTRIDAT 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 MANDTCLNT3Assigned to domainMANDT
RANTYPContract Type RANTYPCHAR1RANTYP
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
RFHAFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
RANLVDContract Number RANLCHAR13ALPHARANLRAN
RLDEPOSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
BBWHRAmount in position currency BBWHRCURR13(2) WERTV7
SBWHRPosition Currency/Transaction Currency TB_BWHRCUKY5Assigned to domainWAERS
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
BCWHRSettlement Amount BCWHRCURR13(2) WERTV7
SCWHRSettlement Currency SCWHRCUKY5Assigned to domainWAERS
BHWHRAmount in local currency BHWHRCURR13(2) WERTV7
SHWHRLocal currency VVSHWHRCUKY5Assigned to domainWAERS
SBEWARTFlow Type SBEWARTCHAR4Assigned to domainSBEWART
DIS_FLOWTYPEUpdate Type TPM_DIS_FLOWTYPECHAR8Assigned to domainTPM_DIS_FLOWTYPE
DFAELLDue date DFAELLDATS8DATUM
DDISPOPayment Date DDISPODATS8DATUM
DBERVONStart of Calculation Period DBERVONDATS8DATUM
DBERBISEnd of Calculation Period DBERBISDATS8DATUM
ABASTAGENumber of base days in a calculation period ABASTAGENUMC6INT6
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
DPKONDDetermination date for percentage rate of condition items VVDPKONDDATS8DATUM
SZSREFReference Interest Rate SZSREFCHAR10Assigned to domainZIREFKU
PKONDInterest rate as a percentage TB_PKONDDEC10(7) DECV3_7
BKONDInterest rate as amount TB_BKONDCURR13(2) WERTV7
SWHRKONDInterest Currency TB_WHRKONDCUKY5Assigned to domainWAERS
BBASISCalculation base amount BBASISCURR13(2) WERTV7
SFORMREFFormula Reference TB_XFORMBECHAR4Assigned to domainT_FORMBE
RBANKKBank account RBANKKCHAR10Assigned to domainALPHASAKNRBKT
DBUDATPosting Date in the Document BUDATDATS8DATUM
RSOLLAccount for debit posting RSOLLCHAR10Assigned to domainALPHASAKNR
RHABENAccount for credit posting RHABENCHAR10Assigned to domainALPHASAKNR
SPLANISTPlan/actual record/record to be released indicator SPLANISTCHAR1SPLANIST
SZSREFVZ+/- sign / reference interest rate operator SZSREFVZCHAR1SZSREFVZ
ATAGENumber of days VVATAGENUMC6INT6
SBEWZITIFlow category SBEWZITICHAR4Assigned to domainSBEWZITI
ASTUECKNumber of units for unit-quoted securities ASTUECKDEC15(5) ASTUECK
BNWHRNominal amount BNWHRCURR13(2) WERTV7
DBESTANDPosition value date DBESTANDDATS8DATUM
SSOLHABDebit/credit indicator VVSSOLHABCHAR1VVSSOLHAB
DVALUTCalculation Date DVALUTDATS8DATUM
RPNNRDaybook no. VVRPNNRCHAR10VVRPNNR
NORDEROrder Number NORDERNUMC8NUM8ORD
SVORGANGSecurities-Activity RVORGANGCHAR8RVORGANG
RKONTRAReference to Counterparty RKONTRA_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SVORGKZActivity indicator for debit/credit control VVSVORGKZNUMC2VVSVORGKZ
KURS1Exchange rate KURSFDEC9(5) EXCRTKURSF
KURS2Exchange rate KURSFDEC9(5) EXCRTKURSF
SRUNITCurrency unit VVSRUNITCHAR5Assigned to domainVVSRUNIT
KWKURSSecurity price VVKWKURSDEC15(6) VVKWKURS
PWKURSSecurity price for percentage quotation PWKURSDEC10(7) PWKURS
DORDEROrder day DORDERDATS8DATUM
SSTORNOReversal indicator SSTORNOCHAR1SSTORNO
PEFFZINSEffective Interest Rate PEFFZINSDEC10(7) DEC3_7
RDEALERTrader RDEALERCHAR12Assigned to domainRDEALER
RREFKONTAccount Assignment Reference in Financial Assets Management RREFKONTCHAR8Assigned to domainUSTRUKRE
PSTRIKEStrike for cap/floor TB_PSTRIKEDEC10(7) DECV3_7
SBERFIMACalculation category for cash flow calculator SBEWFIMACHAR4Assigned to domainSBEWFIMA
JSOFVERRImmediate settlement JSOFVERRCHAR1TFMSOFVERR
DZFESTInterest rate fixing date TB_DZFESTDATS8DATUM
DSCHLUSSDate of business closing VVDSCHLUSSDATS8DATUM
TSCHLUSSTime of business closing VVTSCHLUSSTIMS6UZEIT
SREFZITIRefer.flow category in accrual/deferral flow records VVSREFZITICHAR4Assigned to domainSBEWZITI
RKONDGRDirection of Transaction TB_RKONDGRNUMC1T_RKONDGR
SEXCLVONExclusive Indicator for the Start of a Calculation Period VVSEXCLVONNUMC1VVSEXCLVON
SULTVONMonth-End Indicator for Start of a Calculation Period VVSULTVONCHAR1VVSULT
SINCLBISInclusive Indicator for the End of a Calculation Period VVSINCLBISNUMC1VVSINCLBIS
SULTBISMonth-End Indicator for the End of a Calculation Period VVSULTBISCHAR1VVSULT
S_SSDREFReference flow category in borrower's note loan flow records VVS_SSDREFCHAR4Assigned to domainSBEWZITI
DBPERIODPeriod start VVDBPERIODDATS8DATUM
SPAEXCLExclusive Indicator for Start Date of a Period TFMSPAEXCLNUMC1TFMSPAEXCL
SPAULTMonth-End Indicator for Start Date of a Period TFMSPAULTCHAR1VVSULT
DEPERIODPeriod End VVDEPERIODDATS8DATUM
SPEINCLInclusive Indicator for End Date of a Period TFMSPEINCLNUMC1TFMSPEINCL
SPEULTMonth-End Indicator for End of a Period TFMSPEULTCHAR1VVSULT
AMMRHYFrequency in months AMMRHYNUMC3NUMC03
SOFFSETFixer offset for variable interest rate reference TV_SOFFSETDEC10(7) DECV3_7
URFHAUnderlying transaction TB_URFHACHAR13Assigned to domainALPHAT_RFHAFAU
FIKTKZInclude Fictitious Cash Flows TV_FIKTKZCHAR1TV_FIKTKZ
CTY_FLOW_CATCommodity Flow Leg Category FTR_CTY_FLOW_CATNUMC1FTR_CTY_FLOW_CAT
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
QUANTITYQuantity FTR_QUANQUAN13(3) FTR_QUAN
UNIT_OF_MEASUREUnit of Measure for the Commodity TPM_CTY_UOMUNIT3T006CUNITMEINS
WEIGHTAGEWeightage of the Pricing Item FTR_PRICE_WEIGHTDEC8(5) FTR_PRICE_WEIGHTAGE
PAYMENT_DATEDate on which the Payment will be made FTR_PAYMENT_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
PRICING_DATE Date on which the Item will be priced FTR_PRICING_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
DELIVERY_DATEDate on which the Item will be delivered FTR_DELIVERY_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
CTY_PRICECommodity Price FTR_COMPRICEDEC13(5) FTR_COMPRICE
PRICE_CURRExposure Amount Currency FTR_EXPOSURE_CURRCUKY5TCURCWAERS
PRICE_UOQPrice Unit of Quotation FTR_PRICE_UNIT_OF_QUOTDEC5FTR_PRICE_UNIT_OF_QUOT
PRICE_UOMUnit of Measure for the Commodity TPM_CTY_UOMUNIT3T006CUNITMEINS
SPREADCommodity Spread FTR_COMSPREADDEC13(5) FTR_COMPRICE
QUOT_SRCQuotation Source TCR_CTY_QUOTSRCCHAR2TRCOCC_QUOTSRCTCR_CTY_QUOTSRC
QUOT_TYPECommodity Quotation Type TCR_CTY_QUOTTYPECHAR5TRCOCC_QUOTTYPETCR_CTY_QUOTTYPE
QUOT_TIMEPrice Quotation Time FTR_QUOTATION_TIMETIMS6TIME
DCSIDDerivative Contract Specification ID TBA_DCSIDCHAR6Assigned to domainTBA_DCSIDTBA_DCSIDTBAH_DCS
MICMarket Identifier Code TBA_MICCHAR4Assigned to domainTBA_MICTBA_MICTBAH_MIC
PRICETYPEType of Price Quotation TBA_PRICETYPECHAR2Assigned to domainVVSKURSARTRATETYPE_F4
TENORTime to Maturity TBA_TENORCHAR10Assigned to domainTBA_TENORTBAH_TENOR
KEYDATEDCS Key Date TBA_KEYDATEDATS8DATE

Key field Non-key field



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

As JBDTRIDAT 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 JBDTRIDAT as there is no data to select.

How to access SAP table JBDTRIDAT

Within an ECC or HANA version of SAP you can also view further information about JBDTRIDAT 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!