SECURITY_DB SAP (Update securities) Structure details

Dictionary Type: Structure
Description: Update securities




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




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

SECURITY_DB 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 "Update securities" 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_SECURITY_DB TYPE SECURITY_DB.

The SECURITY_DB table consists of various fields, each holding specific information or linking keys about Update securities data available in SAP. These include MANDT (Client), RANL (Security ID Number), SANLF (Product Category), SSTATI (Status of a security).. 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: Can Be Enhanced (Deep)


SAP SECURITY_DB 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
ANLA 0
MANDTClient MANDTCLNT3MANDT
RANLSecurity ID Number VVRANLWCHAR13ALPHAWP_RANLRANSECURITY_F4
SANLFProduct Category SANLFNUMC3VVSANLF
SSTATIStatus of a security SEC_STATUSNUMC2SEC_STATUS
RANLALT1RANLALT1 RANLALT1SCHAR13CHAR13SRAN
RANLALT2Alternative identification 2 RANLALT2SCHAR13CHAR13SRAN
GSARTProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
SBRSCHIndustry key BRSCHCHAR4BRSCH
SWERTTYPSecurity Type ID SWERTTYPNUMC1SAKTTYP
SBOERNOTIndicator: Listed on an Exchange SBOERNOTCHAR1JANEI
WLOMBIndicator eligible as collateral WLOMBCHAR1JANEI
JDECKRegulatory reporting BPV (hedge fund Y/N) JDECKCHAR1JANEI
WPFANIndicator pledgeable WPFANCHAR1JANEI
SSTBETax treatment indicator SSTBECHAR1JANEI
LOEVMDeletion Indicator LOEVMCHAR1XFELD
JABMIJoint partner vote indicator JABMICHAR1JANEI
XALKZShort name XALKZCHAR15XKBEZ
XALLBLong name XALLBCHAR60XLBEZ
REPKEIssuer Identity Key REPKE_NEWCHAR10ALPHABU_PARTNERBPABUPA
BEMPREISIssue Price BEMPREISCURR10(2) VVBNENNW
REWHRIssue currency REWHRCUKY5WAERS
PEMKURSIssue rate in percent PEMKURSDEC10(7) DEC3_7
SNOTIQuotation Indicator SNOTINUMC1SNOTI
PKUABPrice deviation in percent PKUABDEC10(7) DEC3_7
BKUABAbsolute price deviation BKUABCURR10(2) WHRBTRG
DANDPFLObligation to offer for sale until DANDPFLDATS8DATUM
DANDRERight to offer until DANDREDATS8DATUM
SOBJEKTInternal key for object VVKEYOBJCHAR10VVKEY
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
SROLEXTGeneral Security Classification ALWPKLCHAR3ALWPKL
VVSLOEKZDeletion indicator VVSLOEKZNUMC1VVSLOEKZ
JMUENDELEligibility indicator VVJMUENDCHAR1JANEI
SMOVERWPossible custody type SMOVERWCHAR2SMOVERW
SIHERKVersion Number Component CHAR2CHAR2CHAR2
KBEMPREISIssue price independent of currency VVKBEMPRDEC15(6) VVKWKURS
SDEPOSTATSecurities account statistics key VVDEPOSTATNUMC2VVDEPOSTA
SFUNDIIndicator: Funded VVSFUNDICHAR1JANEI
SWPHGMPFSecurities trading law reporting obligation indicator VVSWPHGMPFCHAR1JANEI
RISINInternational securities ID number (no longer used) VVRISINCHAR13RISIN
INSTITUTEInstitute Providing Credit Standing Information BP_SOL_INSCHAR4BP_SOL_INS
RATINGRating BP_RATINGCHAR3BP_RATING
PRICE_INDEXName of Price Index TIDX_INDEX_NAMECHAR15TIDX_INDEX_NAME
PRICE_IDX_BDATEPrice Index Base Date TIDX_INDEX_BASE_DATEDATS8DATPER
.INCLU--AP 0
AKTI 0
MANDTClient MANDTCLNT3MANDT
RANLSecurity ID Number VVRANLWCHAR13ALPHAWP_RANLRANSECURITY_F4
SANLFProduct Category SANLFNUMC3VVSANLF
AAAAKTIENumber of stocks issued AAAAKTIEDEC12DEC12
PDIVBERDividend rights per unit in percentage terms PDIVBERDEC10(7) DEC3_7
SAKARStock category SAKARNUMC1SAKAR
DEBEGIssue start date DEBEGDATS8DATUM
SVBREStock form indicator SVBRENUMC1SVBRE
SSRBERestriction of voting power indicator SSRBECHAR1JANEI
BNEWENominal value per share BNEWECURR10(2) VVBNENNW
PAKTQUOQuota for par-value stock PAKTQUODEC10(7) DEC3_7
SAINGForeign Investment Law indicator SAINGCHAR1JANEI
SFOTYFund type indicator SFOTYNUMC1SFOTY
SOEFFPublic fund indicator SOEFFCHAR1JANEI
PAUSGIssue premium in percentage PAUSGDEC10(7) DEC3_7
SARTBETType of shareholding SARTBETNUMC2SARTBET
SKONBETDetails about structure of shareholding SKONBETNUMC2SKONBET
SFOARTFund category indicator VVSFOARTCHAR2VVSFOART
BFONVOLFund volume BFONVOLCURR15(2) WERT8
KBNEWENominal Value per Stock (Independent of Currency) VVBNEWEDEC15(6) VVKWKURS
ANLE 0
MANDTClient MANDTCLNT3MANDT
RANLSecurity ID number WP_RANLCHAR13ALPHAWP_RANLRANSECURITY_F4
SANLFProduct Category SANLFNUMC3VVSANLF
SWPKLASSClassification of bond SWPKLASSNUMC3SWPKLASS
DEBEGIssue start date DEBEGDATS8DATUM
DENDFFinal due date DENDFDATS8DATUM
BEMIBETIssue volumes BEMIBETCURR10(2) WHRBTRG
BNOMSNominal value BNOMSCURR13(2) BWHR
BNHAENominal per trading unit BNHAECURR13(2) BWHR
RNWHRNominal currency RNWHRCUKY5WAERS
DKEMIIssuer call date DKEMIDATS8DATUM
DKOBLBondholder call date DKOBLDATS8DATUM
SOPTVERTIndicator whether issuer or bond holder has option right SOPTVERTNUMC1SOPTVERT
BATRTNumber of cutting days BATRTNUMC3NUMC03
SCUEXCum/ex indicator SCUEXNUMC1SCUEX
BOPHENumber of warrants per nominal value BOPHENUMC3NUM03
BAUFPPremium when converting a convertible bond BAUFPCURR13(2) BWHR
RWAUFCurrency markup RWAUFCUKY5WAERS
DWAFBConversion period until DWAFBDATS8DATUM
DWAFVConversion period from DWAFVDATS8DATUM
BWAVNConversion ratio - Denominator BWAVNDEC9(4) DEC5_4
BWAVZConversion ratio - Numerator BWAVZDEC9(4) DEC5_4
JAUSLDrawing Indicator JAUSLCHAR1JANEI
DAUSLDrawing date DAUSLDATS8DATUM
BEIVOTotal issue amount VVBEIVOCURR13(2) BWHR
ANABTMax. no. of assignments VVANABTNUMC3NUMC03
BMINABTMinimum assignment amount VVMINABTCURR13(2) BWHR
JVERKBESales restriction VVJVERKCHAR1JANEI
BDEBETCoverage amount VVBDEBECURR13(2) BWHR
JWEIMResale to reserve carrier permitted VVJWEIMCHAR1JANEI
JRUECKSubject to return VVJRUECKCHAR1JANEI
JANZWEResale report VVJANZWECHAR1JANEI
JNACHRSecondary loans ID VVJNACHRCHAR1JANE
SET_NAMERedemption Schedule Set RDPT_SET_NAMECHAR15RDPT_SET_NAMERDPT_SET_NAMERDPT_F4_SET
ROUNDING_RULERounding Rule TPM_ROUNDING_RULECHAR4TPM_ROUNDING_RULE
POOL_IDPool ID VVPOOLIDCHAR13
EXP_MAT_DATEExpected End of Term VVEXPMATDATEDATS8DATE
TRANCHE_CLASSIFTranche Classification VVTRANCHECLNUMC3VVTRANCHECL
CALC_BEGINStart of Calculation Period DBERVONDATS8DATUM
TERM 0
MANDTClient MANDTCLNT3MANDT
RANLContract Number RANLCHAR13ALPHARANLRAN
SANLFProduct Category SANLFNUMC3VVSANLF
DLAVOTerm from DLAVODATS8DATUM
DLABITerm to DLABIDATS8DATUM
SOPTTYPIndicator: Option Category SOPTTYPNUMC1SOPTTYP
DVERFALLExpiration date for forward exchange transactions DVERFALLDATS8DATUM
DEBEGIssue start date DEBEGDATS8DATUM
SVERROPTOption Settlement Indicator SVERROPTNUMC1SVERROPT
BOVNEOption ratio - Denominator BOVNEDEC9(4) DEC5_4
BOVZAOption ratio - numerator BOVZADEC9(4) DEC5_4
SINDEARTSecurities Index IDXCHAR10CHAR10
BBASPREIExercise price BBASPREICURR13(2) BWHR
RWHRBASExercise price currency RWHRBASCUKY5WAERS
SOPTAUSExercise Type (American or European) SOPTAUSNUMC1SOPTAUS
AMINDESTExercise minimum AMINDESTDEC15(5) ASTUECK
PBASKURSBasic rate PBASKURSDEC10(7) DEC3_7
BINDEXIndex point per monetary unit BINDEXCURR13(2) BWHR
RINDWHRIndex currency RINDWHRCUKY5WAERS
BBEZEINReference units VVBBEZEINCURR13(2) BWHR
RBEZWHRReference unit currency VVRBEZEINCUKY5WAERS
BBASISIndex base VVBASISDEC8(3) DEC5_3
OPTANLFWarrant product category OPTANLFNUMC1OPTANLF
DERI 0
MANDTClient MANDTCLNT3MANDT
RANLSecurity ID Number VVRANLWCHAR13ALPHAWP_RANLRANSECURITY_F4
SGSARTProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
DJAHRExpiration year TI_DJAHRNUMC4GJAHRGJAHR
DMONATExpiration month TI_DMOANTNUMC2T_DMOANT
SOFTYPOptions/futures category TI_SOFTYPNUMC2T_SOFTYP
SOPTTYPOriginal option category (on closing) TV_OPTTYPNUMC3T_OPTTYP
SABRMETSettlement Method Option TI_SABRMETCHAR1T_SABRMET
SMARGARTMargin type TB_MARGARTCHAR5T_MARGART
SNOTTYPEQuotation type option/future TI_NOTTYPECHAR1T_NOTTYPE
PPTICKTick in percentage points TI_PPTICKDEC10(7) DECV3_7
BETICKTick as amount TI_BETICKCURR13(2) WERTV7
PITICKTick in index points TI_PITICKDEC11(6) T_PKTKUR
BWTICKTick value TI_BWTICKCURR13(2) WERTV7
WWTICKTick Value Currency TI_WWTICKCUKY5WAERS
SPUTCALLPut/call indicator TI_SPUTCALNUMC1T_SPUTCAL
SSETTLFLSettlement indicator TI_SETTLFLCHAR1T_SETTLFL
SOPTAUSExercise Type (American or European) SOPTAUSNUMC1SOPTAUS
DVERFALLExpiration date TI_DVERFDATS8DATUM
DLHANDELLast trade date TI_DLHANDDATS8DATUM
DERFUELLSettlement date TI_DERFUEDATS8DATUM
SKALIDFactory calendar SKALIDCHAR2WFCIDH_TFACD
BNOMSNominal value BNOMSCURR13(2) BWHR
RNWHRNominal currency RNWHRCUKY5WAERS
PKONDPercentage rate for condition items PKONDDEC10(7) DECV3_7
SZSREFReference Interest Rate SZSREFCHAR10ZIREFKU
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
DENDFFinal due date DENDFDATS8DATUM
ASTUECKNumber of units for unit-quoted securities ASTUECKDEC15(5) ASTUECK
URANLSecurity ID Number VVRANLWCHAR13ALPHAWP_RANLRANSECURITY_F4
UINDEXSecurities Index IDXCHAR10CHAR10
BPINDEXValue of an index point TI_BPINDEXCURR13(2) WERTV7
WPINDEXIndex point currency TI_WPINDEXCUKY5WAERS
BSTRIKEStrike as amount TI_BSTRIKECURR13(2) WERTV7
WSTRIKEStrike Currency TI_WSTRIKECUKY5WAERS
PKSTRIKEStrike in points TI_PKSTRIKDEC9(4) DEC5_4
IPSTRIKEStrike as inverted percentage notation TI_IPSTRIKDEC10(7) DECV3_7
.INCLU--AP 0
DEBEGIssue start date DEBEGDATS8DATUM
BNWHRNominal amount BNWHRCURR13(2) WERTV7
SNWHRCurrency of nominal amount SNWHRCUKY5WAERS
BWTICK_FINETick Value TPM_BWTICK_FINEDEC13(7) DEC13_7
BETICK_CTYTick Amount (Commodity) TI_BETICK_COMMODITYDEC13(7) DEC13_7
BWTICK_CTYTick Value (Commodity) TI_BWTICK_COMMODITYDEC13(7) DEC13_7
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
CONTRACT_SIZEContract Size TPM_CTY_CONTRACT_SIZEQUAN13(3) FTR_QUAN
CONTRACT_SZ_UNITMengeneinheit der Kontraktgröße TPM_CTY_CONTRACT_SIZE_UNITUNIT3TRCO_COMM_UOM
QUANTITYQuantity FTR_QUANQUAN13(3) FTR_QUAN
QUANTITY_UNITUnit of measure TRCO_COMM_UOMUNIT3TRCO_COMM_UOM
FIRST_NOTICE_DAYFirst Notice Day FIRST_NOTICE_DAYDATS8FIRST_NOTICE_DAY
BETICK_CTY_CUNITCurrency unit VVSRUNITCHAR5VVSRUNIT
DCSIDDerivative Contract Specification ID TBA_DCSIDCHAR6TBA_DCSIDTBA_DCSIDTBAH_DCS
KEYDATEDCS Key Date TBA_KEYDATEDATS8DATE
MICMarket Identifier Code TBA_MICCHAR4TBA_MICTBA_MICTBAH_MIC
UNDERLYING_KEYDATEDCS Key Date TBA_KEYDATEDATS8DATE
SKOKO 0
MANDTClient MANDTCLNT3MANDT
RANLContract Number RANLCHAR13ALPHARANLRAN
DGUEL_KKDate Condition Effective from DGUELDATS8DATUM
SANLFProduct Category SANLFNUMC3VVSANLF
SSTATIStatus of data record SSTATINUMC2STATI
KZAHLAKTPay-in rate KZAHLAKTDEC10(7) DEC3_7
BZAHLAKTAmount Deposited BZAHLAKTCURR10(2) WHRBTRG
DRESTBalance payment date DRESTDATS8DATUM
SZAHLDIVDividend form of payment SZAHLDIVNUMC1SZAHLDIV
DDBABDate from which entitled to dividends DDBABDATS8DATUM
RDIVNRDividend coupon number RDIVNRNUMC3NUM03
BAUSGLCHClearing amount for swap BABTACURR10(2) WHRBTRG
SWHRAUSGClearing amount currency SWHRAUSGCUKY5WAERS
DXGUELTTrading until DTGBIDATS8DATUM
DTSCHABSwap period from DTFVODATS8DATUM
DXTAUSCHSwap period to DTFBIDATS8DATUM
ATCHNENSwap ratio - denominator BTVNEDEC9(4) DEC5_4
ATSHZAESwap ratio - numerator BTVZADEC9(4) DEC5_4
PWANLRABReinvestment discount percent PWARBDEC10(7) DEC3_7
JTHESAUReinvestment indicator STHESCHAR1JANEI
DBFRBDate subscription period until DBFRBDATS8DATUM
DBFRVSubscription period from DBFRVDATS8DATUM
BBPRUUnderlying subscription price BBPRUCURR10(2) VVBNENNW
RWBZPSubscription price currency RWBZPCUKY5WAERS
RWBZP_T30 Characters CHAR30CHAR30CHAR30
DBHABDate of subscription rights trading until DBHABDATS8DATUM
DBHAVDate of subscription rights trading from DBHAVDATS8DATUM
BBVHNSubscription ratio - Denominator BBVHNDEC9(4) DEC5_4
BBVHZSubscription ratio - Numerator BBVHZDEC9(4) DEC5_4
BVNJAAdvantage/disadvantage dividend of new stock BVNJACURR10(2) WHRBTRG
KREAKPost Subscription Rights KREAKDEC15(6) VVKWKURS
ZKOKO 0
MANDTClient MANDTCLNT3MANDT
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
SANLFProduct Category SANLFNUMC3VVSANLF
RKEY1Key part 1 RKEY1CHAR13RKEY1
DGUEL_KKDate Condition Effective from DGUELDATS8DATUM
NLFD_ANGOffer consecutive number NLFD_ANGNUMC3LFNR3
SSTATIStatus of data record SSTATINUMC2STATI
SKOKOARTType of Condition Header SKOKOARTNUMC2SKOKOART
STILGRHYPayment cycle STILGRHYNUMC2SRHYT
STILGARTRepayment Type Indicator STILGARTNUMC1STILGART
SDISEINType of Discount Withholding SDISEINCHAR1SDISEIN
KZAHLUNGPay-in/disbursement rate KZAHLUNGDEC10(7) DEC3_7
BZAHLUNGPay-in/disbursement amount BZAHLUNGCURR13(2) BWHR
SWHRZHLGCurrency of payment amount SWHRZHLGCUKY5WAERS
BZUSAGECommitment capital BZUSAGECURR13(2) WERTV7
SWHRZUSACurrency of commitment amount SWHRZUSACUKY5WAERS
PEFFZINSEffective Interest Rate TB_EFF_RATEDEC10(7) DECV3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
SDISKODiscounted SDISKOCHAR1SDISKO
DKUENDDate of notice DKUENDDATS8DATUM
SKUENDReason for Notice SKUENDNUMC3SKUEART
DKUENDDGEarliest Possible Date for Notice Given by the Lender DKUENDDGDATS8DATUM
DBLFZStart of Term DBLFZDATS8DATUM
DBLFZ_ORIGINOriginal Term Start DBLFZ_ORIGINDATS8DATUM
DELFZEnd of Term DELFZDATS8DATUM
DRESAMReservation of Conditions On DRESAMDATS8DATUM
DRESBISReservation of Conditions Until DRESBISDATS8DATUM
DANGAMOffer creation date DANGAMDATS8DATUM
DANGBISOffer Effective To DANGBISDATS8DATUM
SANGVOROffer/Acceptance Reservation Indicator SANGVORNUMC2SANGVOR
JANNAHMEOffer Acceptance Indicator JANNAHMECHAR1JANEI
SANNAHMEType of offer acceptance indicator SANNAHMENUMC2SKONTAKT
DANNAHMEDate of acceptance of offer DANNAHMEDATS8DATUM
JVERTRAGIndicator: Contract Created? JVERTRAGCHAR1JANEI
DVERTRAMContract creation date DVERTRAMDATS8DATUM
DVERTBISReturn contract by DVERTBISDATS8DATUM
PMANEFFZInternal Effective Interest Rate TB_EFF_RATE_INTDEC10(7) DECV3_7
SEFFM2Effective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
SKUEGLNotice Arrangement Lender VVSKUEGLNUMC3VVSKUEGL
RPNRActivity number/rollover number VVRPNRNUMC8NUMC08
DEFSZDate of fixed period end VVDEFSZDATS8DATUM
DGESEarliest Notice Date in acc. with the Legal Right of Notice VVDGESDATS8DATUM
SGESAUSLegal Right of Notice Excluded VVSGESAUSCHAR1XFELD
SZKZSpecial int. ID for int. on arrears for remaining balance VVSZKZCHAR1VVSZKZ
NANGEBOTOffer consecutive number NLFD_ANGNUMC3LFNR3
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
ZVRHYEFFInt.sttlmnt frequency for effective int.rate calc.in months VVZVRHYEFFNUMC3NUMC03
PVGLEFFZComparative Effective Interest TB_EFF_RATE_COMDEC10(7) DECV3_7
SULTEFSZMonth-end indicator for end of fixed period VVSULTEFSZCHAR1VVSULT
DABEFFZDate when calculation of effective rate starts VVDABEFFZDATS8DATUM
DKUENDDNEarliest Possible Date for Notice Given by the Borrower VVDKUENDDNDATS8DATUM
SKUEDNNotice Arrangement Borrower VVSKUEDNNUMC3VVSKUEDN
SKUEARTNotice Type for the Loan VVSKUEARTNUMC3VVSKUEART
DMARKTZINSISB: Market Rate Date: Market Interest Rate for NPV Calc. DMARKTZINSDATS8DATS
SKALIDWTInterest Calendar TFMSKALIDWTCHAR2WFCIDH_TFACD
EDEFFZINSRelevant for Closely Defined Effective Interest TB_EFF_RATE_EDDEC10(7) DECV3_7
EDEFFMETHEffective Interest Method - Acc. to EU Gdline Int.Statistics EFFMETHCHAR1EFFMETH
JAHREFFZINSRelevant for Yearly Eff. Interest Acc Guideline 87/102/EU TB_EFF_RATE_YEARDEC10(7) DECV3_7
JAHREFFMETHEffective Interest Method - Acc. to EU Gdline Int.Statistics EFFMETHCHAR1EFFMETH
PEFFZINS_ORIGINOriginal Effective Interest Rate TB_EFF_RATE_ORIGDEC10(7) DECV3_7
.INCLU--AP 0
ORIGINAL_TERMOriginal Term in Months TB_VIEW_ORIGINAL_TERMNUMC3
OVERALL_RUNTIMEOverall Term TB_VIEW_OVERALL_RUNTIMENUMC3
ORIG_CREDIT_SUMOriginal Total Loan Amount TB_VIEW_ORIGINAL_CREDIT_SUMCURR13(2) WERTV7
DATE_REPAYMENTStart Date for Repayment TB_VIEW_DATE_REPAYMENTDATS8DATUM
DATE_FIRST_RATEDue Date for First Installment to Include a Repayment Amount TB_VIEW_DATE_FIRST_RATEDATS8DATUM
DAY_OF_PAYMENTDay of Installment Payment TB_VIEW_DAY_OF_PAYMENTNUMC2T_VIEW_DAY_OF_PAYMENT
CLEARING_RATEAmount for Final Loan Installment Payment TB_VIEW_CLEARING_RATECURR13(2) WERTV7
EFF_INT_L_PYMNPEffective Interest Rate for Last Change to Installment Plan TB_MODEL_EFFECTIV_INTERSTS_PPCDEC10(7) DEC3_7
DEFF_INT_L_PYMNPKey Date for Last Change to Installment Plan TB_MODEL_DATE_LAST_PAYMENTPLANDATS8DATUM
REPAY_DELAYModel Calculation: DE for Periods of Repayment Suspension TB_MODEL_REPAY_DELAYNUMC2
CALCULATED_PARAMCalculate Installment Amount or Number of Installments? TB_MODEL_P_RATE_OR_TERMCHAR4T_MODEL_P_RATE_OR_TERM
CURR_CREDIT_SUMCurrent Total Loan Amount TB_VIEW_CURRENT_CREDIT_SUMCURR13(2) WERTV7
BROUNDUNITRounding Unit for Amounts TB_BROUNDUNIT_ADEC13(7) TFMSRUNIT
SROUNDRounding Category (Round up, Round Down or Number Rounding) TB_SROUND_ACHAR1TFM_SROUND
BOVERLIMITDrawing Tolerance as Amount TB_COMP_OVERLIMIT_AMOUNTCURR13(2) WERTV7
POVERLIMITDrawing Tolerance as a Percentage TB_COMP_OVERLIMT_PERCENTDEC10(7) DECV3_7
CONTABCondition Table TB_FICO_CONTABCHAR8T_FICO_CONTABFVD_FICO_CONTAB
CONTAB_VERSIONVersion Number for a Condition Table TB_FICO_CONTAB_VERSIONNUMC4T_FICO_CONTAB_VERSION
TERM_PAYMENTCategory of Last Installment TB_TERM_PAYMENTCHAR1T_TERM_PAYMENT
PAPR_ORIGINOriginal U.S. Effective Interest Rate TB_PAPR_ORIGINDEC10(7) DECV3_7
BONO 0
TWX2 0
ANAN 0
BEFRI 0
KOPO 0
KOPA 0
VZGPO 0
SHARE_CAPITAL 0
RATING 0
POOLDATA 0
MANDTClient MANDTCLNT3MANDT
POOL_IDPool ID VVPOOLIDCHAR13
CLASSIFICATIONAsset Pool Classification VVPOOLCLNUMC3VVPOOLCL
TOTAL_VOLUMENominal Amount TPM_NOMINAL_AMTCURR21(2) TPM_AMOUNT
TOTAL_VOLUME_CURNominal Currency TPM_NOMINAL_CURRCUKY5WAERS
REINV_PERIODReinvestment Period TPM_REINV_PERIODDATS8DATS
POOLRATING 0
POOLREMARKS 0
TIERLEVEL 0
RIGHTS 0
FREE_ATTR 0
MANDTClient MANDTCLNT3MANDT
RANLSecurity ID Number VVRANLWCHAR13ALPHAWP_RANLRANSECURITY_F4
SANLFProduct Category SANLFNUMC3VVSANLF
GSARTProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
ATTRIBUTE_LI01Value of the Free Attribute (20 Characters) VWP_ATTR_LONGCHAR20VWP_ATTR_LONG
ATTRIBUTE_LI02Value of the Free Attribute (20 Characters) VWP_ATTR_LONGCHAR20VWP_ATTR_LONG
ATTRIBUTE_LI03Value of the Free Attribute (20 Characters) VWP_ATTR_LONGCHAR20VWP_ATTR_LONG
ATTRIBUTE_LI04Value of the Free Attribute (20 Characters) VWP_ATTR_LONGCHAR20VWP_ATTR_LONG
ATTRIBUTE_LI05Value of the Free Attribute (20 Characters) VWP_ATTR_LONGCHAR20VWP_ATTR_LONG
ATTRIBUTE_SI01Value of the Free Attribute (5 Characters) VWP_ATTR_SHORTCHAR5VWP_ATTR_SHORT
ATTRIBUTE_SI02Value of the Free Attribute (5 Characters) VWP_ATTR_SHORTCHAR5VWP_ATTR_SHORT
ATTRIBUTE_SI03Value of the Free Attribute (5 Characters) VWP_ATTR_SHORTCHAR5VWP_ATTR_SHORT
ATTRIBUTE_SI04Value of the Free Attribute (5 Characters) VWP_ATTR_SHORTCHAR5VWP_ATTR_SHORT
ATTRIBUTE_SI05Value of the Free Attribute (5 Characters) VWP_ATTR_SHORTCHAR5VWP_ATTR_SHORT
ATTRIBUTE_SI06Value of the Free Attribute (5 Characters) VWP_ATTR_SHORTCHAR5VWP_ATTR_SHORT
ATTRIBUTE_SI07Value of the Free Attribute (5 Characters) VWP_ATTR_SHORTCHAR5VWP_ATTR_SHORT
ATTRIBUTE_SI08Value of the Free Attribute (5 Characters) VWP_ATTR_SHORTCHAR5VWP_ATTR_SHORT
ATTRIBUTE_SI09Value of the Free Attribute (5 Characters) VWP_ATTR_SHORTCHAR5VWP_ATTR_SHORT
ATTRIBUTE_SI10Value of the Free Attribute (5 Characters) VWP_ATTR_SHORTCHAR5VWP_ATTR_SHORT
ATTRIBUTE_FR01Long name XALLBCHAR60XLBEZ
ATTRIBUTE_FR02Long name XALLBCHAR60XLBEZ
ATTRIBUTE_FR03Long name XALLBCHAR60XLBEZ
ATTRIBUTE_FR04Long name XALLBCHAR60XLBEZ
ATTRIBUTE_FR05Long name XALLBCHAR60XLBEZ
ATTRIBUTE_DI01Value of the Free Attribute (Date) VWP_ATTR_DATEDATS8VWP_ATTR_DATE
ATTRIBUTE_DI02Value of the Free Attribute (Date) VWP_ATTR_DATEDATS8VWP_ATTR_DATE
ATTRIBUTE_CU01Value of the Free Attribute (Currency) VWP_ATTR_CURRCUKY5WAERS
ATTRIBUTE_CU02Value of the Free Attribute (Currency) VWP_ATTR_CURRCUKY5WAERS
ATTRIBUTE_DTFRValue of the Free Attribute (Date) VWP_ATTR_DATEDATS8VWP_ATTR_DATE
ATTRIBUTE_DTTOValue of the Free Attribute (Date) VWP_ATTR_DATEDATS8VWP_ATTR_DATE
.INCLU--AP 0
COVERAGE_ELIGCoverage Eligibility Entry /TRMKR/COVERAGE_ELIGCHAR2/TRMKR/COVERAGE_ELIG
EMBD_DERIVATIVEEmbedded Derivative /TRMKR/EMBD_DERIVATIVECHAR30/TRMKR/EMBD_DERIVATIVE
ORIG_ISSUE_CURROriginal Issue Currency /TRMKR/ISSUE_CURRCUKY5WAERS
QUOT_BREAKDOWNQuotation Breakdown /TRMKR/QUOT_BREAKDOWNCHAR2/TRMKR/QUOT_BREAKDOWN

Key field Non-key field



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

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

How to access SAP table SECURITY_DB

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