FTAS_RFTBJL00_ITEMS SAP (Field Information for ALV Display RFTBJL00) Structure details

Dictionary Type: Structure
Description: Field Information for ALV Display RFTBJL00




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




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

FTAS_RFTBJL00_ITEMS 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 "Field Information for ALV Display RFTBJL00" 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_FTAS_RFTBJL00_ITEMS TYPE FTAS_RFTBJL00_ITEMS.

The FTAS_RFTBJL00_ITEMS table consists of various fields, each holding specific information or linking keys about Field Information for ALV Display RFTBJL00 data available in SAP. These include SGSART (Product Type), SFHAART (Financial Transaction Type), SFGTYP (Transaction Category), RFHA (Financial Transaction).. 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: Cannot Be Enhanced


SAP FTAS_RFTBJL00_ITEMS 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
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SGSARTProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
SFGTYPTransaction Category TB_SFGTYPNUMC3Assigned to domainT_SFGTYP
RFHAFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
KONTRHBusiness Partner Number TB_KUNNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
BP_NAMEName 1 (surname for persons, otherwise company name) BP_NAME1CHAR40TEXT40
RANTYPContract Type RANTYPCHAR1RANTYP
SANLFProduct Category SANLFNUMC3Assigned to domainVVSANLF
RPORTBPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
ZUONRFinance Project TB_TFPROJCHAR13T_TFPROJ
RDEALERTrader RDEALERCHAR12Assigned to domainRDEALER
SCONFIRMName for Confirmation Status TB_XCONFCHAR10TEXT10
SRECONFIRMName for counterconfirmation status TB_XRECONFCHAR10TEXT10
DVTRABContract Conclusion Date TB_DVTRABDATS8DATUM
DATUMEntered On TB_DCRDATDATS8DATUM
SFGZUSTTTransaction Activity Category TB_SFGZUTYNUMC2Assigned to domainT_SFGZUTYC_AT02
ACTIVITY_CATName of activity category TB_XTTEXTCHAR30TEXT30
XAKTIVExplanatory short text DDTEXTCHAR60DDTEXT
RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
XALKZShort name XALKZCHAR15XKBEZ
RLDEPOSecurities Account VRLDEPOCHAR10Assigned to domainRLDEPODEP
SNWHRCurrency of nominal amount SNWHRCUKY5Assigned to domainWAERS
BNWHRNominal amount TB_BNWHRCURR13(2) WERTV7
BPPRCSecurity Price for Percentage Quotation TB_BPPRCDEC15(6) VVPKTKUR
ASTUECKNo. of Units for Financial Instruments TB_ASTUECKDEC15(5) ASTUECK
BUPRCSecurity Price Without Currency Ref. with Unit Quotation TB_BUPRCDEC15(6) VVPKTKUR
SRUNITCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
USERNAMEEntered by TB_CRUSERCHAR12SYCHAR12
WANLAGEPosition Currency TB_WBSTNDCUKY5Assigned to domainWAERS
BANLAGETotal capital amount in position currency upto key date TB_BKGWRVSCURR15(2) WERTV8_TR
DBLFZTerm Start TB_DBLFZDATS8DATUM
DBLFZ_PTerm Start TB_DBLFZDATS8DATUM
DELFZTerm End TB_DELFZDATS8DATUM
PZINSPercentage rate for condition items PKONDDEC10(7) DECV3_7
START_DATETerm Start TB_DBLFZDATS8DATUM
WGSCHFTCurrency of transaction TB_WGSCHFTCUKY5Assigned to domainWAERS
BNWHR_WGSCHFTNominal amount TB_BNWHRCURR13(2) WERTV7
PKONDPercentage rate for condition items PKONDDEC10(7) DECV3_7
BZBETR_WGSCHFTPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
DETAILSCarrier field for icons ICON_TEXTCHAR132SYCHAR132
XFORMELFormula TB_CORR_XFORMELCHAR132TEXT132
AMNT_LIMITFTR Facility: Limit Amount on Key Date TB_FC_AMOUNT_LIMITCURR17(2) T_POS_AMOUNT
AMNT_USEDFTR Facility: Utilization on Key Date TB_FC_AMOUNT_USEDCURR17(2) T_POS_AMOUNT
DZTERMPayment or Delivery Date TB_DZTERMDATS8DATUMT33
WLWAERSLeading currency TB_WLWAERSCUKY5Assigned to domainWAERS
TEXT_251Text field, length 4 TEXT4CHAR4UDCHA4
WFWAERSFollowing Currency TB_WFWAERSCUKY5Assigned to domainWAERS
KKURSRate of Forex Transaction TB_KKURSDEC13(9) TB_KKURS
WZBETR1Payment Currency TB_WZBETRCUKY5Assigned to domainWAERS
BZBETR1Payment amount in payment currency TB_BZBETRCURR13(2) WERTV7
WZBETR2Payment Currency TB_WZBETRCUKY5Assigned to domainWAERS
BZBETR2Payment amount in payment currency TB_BZBETRCURR13(2) WERTV7
WZBETRPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
BZBETRPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
SZSREFReference Interest Rate SZSREFCHAR10Assigned to domainZIREFKU
TEXT_ZI1Text (15 characters) TEXT15CHAR15TEXT15
ACTIVITY_CAT_SWAPName of activity category TB_XTTEXTCHAR30TEXT30
XAKTIV_SWAPExplanatory short text DDTEXTCHAR60DDTEXT
WZBETR_SWAPPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
BZBETR_SWAPPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
DBLFZ_SWAPTerm Start TB_DBLFZDATS8DATUM
DELFZ_SWAPTerm End TB_DELFZDATS8DATUM
XFORMEL_SWAPFormula TB_CORR_XFORMELCHAR132TEXT132
TEXT_ZI2Text (15 characters) TEXT15CHAR15TEXT15
VAR_FORMELText (10 Characters) TEXT10CHAR10TEXT10
BETICKTick as amount TI_BETICKCURR13(2) WERTV7
WWTICKTick Value Currency TI_WWTICKCUKY5Assigned to domainWAERS
BWTICKTick value TI_BWTICKCURR13(2) WERTV7
DVERFALLExpiration date TI_DVERFDATS8DATUM
PPTICKTick in percentage points TI_PPTICKDEC10(7) DECV3_7
PITICKTick in index points TI_PITICKDEC11(6) T_PKTKUR
PEFFZINSEffective Interest Rate TB_PYIELDDEC10(7) DECV3_7
QUANTITYChar 20 CHAR20CHAR20CHAR20
BPRICEPrice per unit TB_BPRICECURR13(2) WERTV7
WPRICEPrice currency TB_WPRICECUKY5Assigned to domainWAERS
PWKURSPrice as percentage quotation TB_PWKURSDEC10(7) DEC3_7
VVBASISPrice in points TB_VVBASISDEC11(6) T_PKTKUR
XSETTLFLExplanatory short text DDTEXTCHAR60DDTEXT
XNOTTYPEExplanatory short text DDTEXTCHAR60DDTEXT
XABRMETExplanatory short text DDTEXTCHAR60DDTEXT
XPUTCALLExplanatory short text DDTEXTCHAR60DDTEXT
XOPTAUSExplanatory short text DDTEXTCHAR60DDTEXT
BSTRIKEStrike as amount TI_BSTRIKECURR13(2) WERTV7
WSTRIKEStrike Currency TI_WSTRIKECUKY5Assigned to domainWAERS
PSTRIKEStrike in points TI_PKSTRIKDEC9(4) DEC5_4
IPSTRIKEStrike as inverted percentage notation TI_IPSTRIKDEC10(7) DECV3_7
VTIOF_XNAMEName of option/future TB_XOFNAMECHAR30T_XTEXT30
VTIOF_DMATURExpiration date TB_DMATURDATS8DATUM
SOPTAUS_TEXTShort text exercise type (American or European) TI_XOPTAUSCHAR15TEXT15
PRKKURSCurrency option premium with price in points TI_PRKURDEC13(9) TB_KKURS
BINDEXValue of a point TB_BINDEXCURR13(2) BWHR
BNWHR_WPRICENominal amount TB_BNWHRCURR13(2) WERTV7
QTYQuantity FTR_QUANQUAN13(3) FTR_QUAN
UNITUnit of measure TRCO_COMM_UOMUNIT3Assigned to domainTRCO_COMM_UOM
PRICECommodity Price FTR_COMPRICEDEC13(5) FTR_COMPRICE
COMM_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
TEXT_250Text (10 Characters) TEXT10CHAR10TEXT10
UNDERLYING_SEC_XFHAARTName of Transaction Type TB_FATEXTCHAR30T_XTEXT30
UNDERLYING_SEC_RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
UNDERLYING_SEC_XALKZShort name XALKZCHAR15XKBEZ
UNDERLYING_SEC_BNWHRNominal amount TB_BNWHRCURR13(2) WERTV7
UNDERLYING_SEC_WPRICEPrice currency TB_WPRICECUKY5Assigned to domainWAERS
UNDERLYING_SEC_BPPRCSecurity Price for Percentage Quotation TB_BPPRCDEC15(6) VVPKTKUR
UNDERLYING_SEC_ASTUECKNo. of Units for Financial Instruments TB_ASTUECKDEC15(5) ASTUECK
UNDERLYING_SEC_BUPRCSecurity Price Without Currency Ref. with Unit Quotation TB_BUPRCDEC15(6) VVPKTKUR
UNDERLYING_SEC_SRUNITCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
TEXT2_250Text (10 Characters) TEXT10CHAR10TEXT10
UNDERLYING_SEC2_XFHAARTName of Transaction Type TB_FATEXTCHAR30T_XTEXT30
UNDERLYING_SEC2_RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
UNDERLYING_SEC2_XALKZShort name XALKZCHAR15XKBEZ
UNDERLYING_SEC2_BNWHRNominal amount TB_BNWHRCURR13(2) WERTV7
UNDERLYING_SEC2_WPRICEPrice currency TB_WPRICECUKY5Assigned to domainWAERS
UNDERLYING_SEC2_BPPRCSecurity Price for Percentage Quotation TB_BPPRCDEC15(6) VVPKTKUR
UNDERLYING_SEC2_ASTUECKNo. of Units for Financial Instruments TB_ASTUECKDEC15(5) ASTUECK
UNDERLYING_SEC2_BUPRCSecurity Price Without Currency Ref. with Unit Quotation TB_BUPRCDEC15(6) VVPKTKUR
UNDERLYING_SEC2_SRUNITCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
TEXT_254Character field, length 32 CHAR32CHAR32CHAR32
UNDERLYING_TXTPUTCALText field: Put/Call TI_XPUTCALCHAR10T_CHAR10
UNDERLYING_DZTERMPayment or Delivery Date TB_DZTERMDATS8DATUMT33
UNDERLYING_WLWAERSLeading currency TB_WLWAERSCUKY5Assigned to domainWAERS
UNDERLYING_WFWAERSFollowing Currency TB_WFWAERSCUKY5Assigned to domainWAERS
UNDERLYING_KKURSRate of Forex Transaction TB_KKURSDEC13(9) TB_KKURS
TEXT_252Text field of length 8 TEXT8CHAR8TEXT8
UNDERLYING_WZBETR1Payment Currency TB_WZBETRCUKY5Assigned to domainWAERS
UNDERLYING_BZBETR1Payment amount in payment currency TB_BZBETRCURR13(2) WERTV7
TEXT_253Text field, length 4 TEXT4CHAR4UDCHA4
UNDERLYING_WZBETR2Payment Currency TB_WZBETRCUKY5Assigned to domainWAERS
UNDERLYING_BZBETR2Payment amount in payment currency TB_BZBETRCURR13(2) WERTV7
TEXT2_254Character field, length 32 CHAR32CHAR32CHAR32
UNDERLYING2_TXTPUTCALText field: Put/Call TI_XPUTCALCHAR10T_CHAR10
UNDERLYING2_DZTERMPayment or Delivery Date TB_DZTERMDATS8DATUMT33
UNDERLYING2_WLWAERSLeading currency TB_WLWAERSCUKY5Assigned to domainWAERS
TEXT2_251Text field, length 4 TEXT4CHAR4UDCHA4
UNDERLYING2_WFWAERSFollowing Currency TB_WFWAERSCUKY5Assigned to domainWAERS
UNDERLYING2_KKURSRate of Forex Transaction TB_KKURSDEC13(9) TB_KKURS
TEXT2_252Text field of length 8 TEXT8CHAR8TEXT8
UNDERLYING2_WZBETR1Payment Currency TB_WZBETRCUKY5Assigned to domainWAERS
UNDERLYING2_BZBETR1Payment amount in payment currency TB_BZBETRCURR13(2) WERTV7
TEXT2_253Text field, length 4 TEXT4CHAR4UDCHA4
UNDERLYING2_WZBETR2Payment Currency TB_WZBETRCUKY5Assigned to domainWAERS
UNDERLYING2_BZBETR2Payment amount in payment currency TB_BZBETRCURR13(2) WERTV7
L_XSGSARTText (10 Characters) TEXT10CHAR10TEXT10
WZBETR_2Payment Currency TB_WZBETRCUKY5Assigned to domainWAERS
BZBETR_2Payment amount in payment currency TB_BZBETRCURR13(2) WERTV7
UNDERLYING_FRA_XFHAARTName of Transaction Type TB_FATEXTCHAR30T_XTEXT30
UNDERLYING_FRA_XSGSART_SHORTText (10 Characters) TEXT10CHAR10TEXT10
UNDERLYING_FRA_BNOMINALPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
UNDERLYING_FRA_PKONDAgreed interest rate - financial product TB_PZINSSVDEC10(7) DECV3_7
UNDERLYING_FRA_SZSREFReference Interest Rate SZSREFCHAR10Assigned to domainZIREFKU
UNDERLYING_FRA2_XFHAARTName of Transaction Type TB_FATEXTCHAR30T_XTEXT30
UNDERLYING_FRA2_XSGSART_SHORTText (10 Characters) TEXT10CHAR10TEXT10
UNDERLYING_FRA2_BNOMINALPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
UNDERLYING_FRA2_PKONDAgreed interest rate - financial product TB_PZINSSVDEC10(7) DECV3_7
UNDERLYING_FRA2_SZSREFReference Interest Rate SZSREFCHAR10Assigned to domainZIREFKU
UNDERLYING_OP_TXTPUTCALINText field: Put/Call (internal view) TI_XPUTCALINCHAR10T_CHAR10
UNDERLYING_OP_XFHAARTName of Transaction Type TB_FATEXTCHAR30T_XTEXT30
UNDERLYING_OP_XSGSART_SHORTText (10 Characters) TEXT10CHAR10TEXT10
UNDERLYING_OP_DMATURExpiration date TB_DMATURDATS8DATUM
UNDERLYING_OP_WLWAERSLeading currency TB_WLWAERSCUKY5Assigned to domainWAERS
UNDERLYING_OP_WFWAERSFollowing Currency TB_WFWAERSCUKY5Assigned to domainWAERS
TEXT_255Text (10 Characters) TEXT10CHAR10TEXT10
UNDERLYING_OP_BZBETRPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
UNDERLYING_OP_WZBETRPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
UNDERLYING_OP_XSTRIKEStrike price of an option (display) TB_XSTRIKECHAR20T_CHAR20
UNDERLYING_OP2_TXTPUTCALINText field: Put/Call (internal view) TI_XPUTCALINCHAR10T_CHAR10
UNDERLYING_OP2_XFHAARTName of Transaction Type TB_FATEXTCHAR30T_XTEXT30
UNDERLYING_OP2_XSGSART_SHORTText (10 Characters) TEXT10CHAR10TEXT10
UNDERLYING_OP2_DMATURExpiration date TB_DMATURDATS8DATUM
UNDERLYING_OP2_WLWAERSLeading currency TB_WLWAERSCUKY5Assigned to domainWAERS
UNDERLYING_OP2_WFWAERSFollowing Currency TB_WFWAERSCUKY5Assigned to domainWAERS
TEXT2_255Text (10 Characters) TEXT10CHAR10TEXT10
UNDERLYING_OP2_BZBETRPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
UNDERLYING_OP2_WZBETRPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
UNDERLYING_OP2_XSTRIKEStrike price of an option (display) TB_XSTRIKECHAR20T_CHAR20
TABNAME2-Digit Numeric Value NUM2NUMC2NUM2
STTLM_FREQCOMS: Settlement Frequency FTR_COMS_SETTLE_FREQUENCYINT13
SELL_COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
BUY_COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
SELL_PRICEPrice Reference FTR_PRICEREFCHAR27FTR_PRICEREF
BUY_PRICEPrice Reference FTR_PRICEREFCHAR27FTR_PRICEREF
SELL_PRICE_UNITCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
BUY_PRICE_UNITCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
SELL_FIXING_DATEInterest rate fixing date TB_DZFESTDATS8DATUM
BUY_FIXING_DATEInterest rate fixing date TB_DZFESTDATS8DATUM
SELL_QUANQuantity FTR_QUANQUAN13(3) FTR_QUAN
BUY_QUANQuantity FTR_QUANQUAN13(3) FTR_QUAN
SELL_UNITUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
BUY_UNITUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
LAST_FIXING_DATEInterest rate fixing date TB_DZFESTDATS8DATUM

Key field Non-key field



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

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

How to access SAP table FTAS_RFTBJL00_ITEMS

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