SECURITY_DB SAP (Update securities) Structure details
Description: Update securities
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 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RANL | Security ID Number | VVRANLW | CHAR | 13 | ALPHA | WP_RANL | RAN | SECURITY_F4 | |
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
SSTATI | Status of a security | SEC_STATUS | NUMC | 2 | SEC_STATUS | ||||
RANLALT1 | RANLALT1 | RANLALT1S | CHAR | 13 | CHAR13S | RAN | |||
RANLALT2 | Alternative identification 2 | RANLALT2S | CHAR | 13 | CHAR13S | RAN | |||
GSART | Product Type | VVSART | CHAR | 3 | VVSART | SAN | VVSART_APPL_BAS | ||
SBRSCH | Industry key | BRSCH | CHAR | 4 | BRSCH | ||||
SWERTTYP | Security Type ID | SWERTTYP | NUMC | 1 | SAKTTYP | ||||
SBOERNOT | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | JANEI | ||||
WLOMB | Indicator eligible as collateral | WLOMB | CHAR | 1 | JANEI | ||||
JDECK | Regulatory reporting BPV (hedge fund Y/N) | JDECK | CHAR | 1 | JANEI | ||||
WPFAN | Indicator pledgeable | WPFAN | CHAR | 1 | JANEI | ||||
SSTBE | Tax treatment indicator | SSTBE | CHAR | 1 | JANEI | ||||
LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
JABMI | Joint partner vote indicator | JABMI | CHAR | 1 | JANEI | ||||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
XALLB | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
REPKE | Issuer Identity Key | REPKE_NEW | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
BEMPREIS | Issue Price | BEMPREIS | CURR | 10(2) | VVBNENNW | ||||
REWHR | Issue currency | REWHR | CUKY | 5 | WAERS | ||||
PEMKURS | Issue rate in percent | PEMKURS | DEC | 10(7) | DEC3_7 | ||||
SNOTI | Quotation Indicator | SNOTI | NUMC | 1 | SNOTI | ||||
PKUAB | Price deviation in percent | PKUAB | DEC | 10(7) | DEC3_7 | ||||
BKUAB | Absolute price deviation | BKUAB | CURR | 10(2) | WHRBTRG | ||||
DANDPFL | Obligation to offer for sale until | DANDPFL | DATS | 8 | DATUM | ||||
DANDRE | Right to offer until | DANDRE | DATS | 8 | DATUM | ||||
SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SROLEXT | General Security Classification | ALWPKL | CHAR | 3 | ALWPKL | ||||
VVSLOEKZ | Deletion indicator | VVSLOEKZ | NUMC | 1 | VVSLOEKZ | ||||
JMUENDEL | Eligibility indicator | VVJMUEND | CHAR | 1 | JANEI | ||||
SMOVERW | Possible custody type | SMOVERW | CHAR | 2 | SMOVERW | ||||
SIHERK | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
KBEMPREIS | Issue price independent of currency | VVKBEMPR | DEC | 15(6) | VVKWKURS | ||||
SDEPOSTAT | Securities account statistics key | VVDEPOSTAT | NUMC | 2 | VVDEPOSTA | ||||
SFUNDI | Indicator: Funded | VVSFUNDI | CHAR | 1 | JANEI | ||||
SWPHGMPF | Securities trading law reporting obligation indicator | VVSWPHGMPF | CHAR | 1 | JANEI | ||||
RISIN | International securities ID number (no longer used) | VVRISIN | CHAR | 13 | RISIN | ||||
INSTITUTE | Institute Providing Credit Standing Information | BP_SOL_INS | CHAR | 4 | BP_SOL_INS | ||||
RATING | Rating | BP_RATING | CHAR | 3 | BP_RATING | ||||
PRICE_INDEX | Name of Price Index | TIDX_INDEX_NAME | CHAR | 15 | TIDX_INDEX_NAME | ||||
PRICE_IDX_BDATE | Price Index Base Date | TIDX_INDEX_BASE_DATE | DATS | 8 | DATPER | ||||
.INCLU--AP | 0 | ||||||||
AKTI | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RANL | Security ID Number | VVRANLW | CHAR | 13 | ALPHA | WP_RANL | RAN | SECURITY_F4 | |
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
AAAAKTIE | Number of stocks issued | AAAAKTIE | DEC | 12 | DEC12 | ||||
PDIVBER | Dividend rights per unit in percentage terms | PDIVBER | DEC | 10(7) | DEC3_7 | ||||
SAKAR | Stock category | SAKAR | NUMC | 1 | SAKAR | ||||
DEBEG | Issue start date | DEBEG | DATS | 8 | DATUM | ||||
SVBRE | Stock form indicator | SVBRE | NUMC | 1 | SVBRE | ||||
SSRBE | Restriction of voting power indicator | SSRBE | CHAR | 1 | JANEI | ||||
BNEWE | Nominal value per share | BNEWE | CURR | 10(2) | VVBNENNW | ||||
PAKTQUO | Quota for par-value stock | PAKTQUO | DEC | 10(7) | DEC3_7 | ||||
SAING | Foreign Investment Law indicator | SAING | CHAR | 1 | JANEI | ||||
SFOTY | Fund type indicator | SFOTY | NUMC | 1 | SFOTY | ||||
SOEFF | Public fund indicator | SOEFF | CHAR | 1 | JANEI | ||||
PAUSG | Issue premium in percentage | PAUSG | DEC | 10(7) | DEC3_7 | ||||
SARTBET | Type of shareholding | SARTBET | NUMC | 2 | SARTBET | ||||
SKONBET | Details about structure of shareholding | SKONBET | NUMC | 2 | SKONBET | ||||
SFOART | Fund category indicator | VVSFOART | CHAR | 2 | VVSFOART | ||||
BFONVOL | Fund volume | BFONVOL | CURR | 15(2) | WERT8 | ||||
KBNEWE | Nominal Value per Stock (Independent of Currency) | VVBNEWE | DEC | 15(6) | VVKWKURS | ||||
ANLE | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RANL | Security ID number | WP_RANL | CHAR | 13 | ALPHA | WP_RANL | RAN | SECURITY_F4 | |
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
SWPKLASS | Classification of bond | SWPKLASS | NUMC | 3 | SWPKLASS | ||||
DEBEG | Issue start date | DEBEG | DATS | 8 | DATUM | ||||
DENDF | Final due date | DENDF | DATS | 8 | DATUM | ||||
BEMIBET | Issue volumes | BEMIBET | CURR | 10(2) | WHRBTRG | ||||
BNOMS | Nominal value | BNOMS | CURR | 13(2) | BWHR | ||||
BNHAE | Nominal per trading unit | BNHAE | CURR | 13(2) | BWHR | ||||
RNWHR | Nominal currency | RNWHR | CUKY | 5 | WAERS | ||||
DKEMI | Issuer call date | DKEMI | DATS | 8 | DATUM | ||||
DKOBL | Bondholder call date | DKOBL | DATS | 8 | DATUM | ||||
SOPTVERT | Indicator whether issuer or bond holder has option right | SOPTVERT | NUMC | 1 | SOPTVERT | ||||
BATRT | Number of cutting days | BATRT | NUMC | 3 | NUMC03 | ||||
SCUEX | Cum/ex indicator | SCUEX | NUMC | 1 | SCUEX | ||||
BOPHE | Number of warrants per nominal value | BOPHE | NUMC | 3 | NUM03 | ||||
BAUFP | Premium when converting a convertible bond | BAUFP | CURR | 13(2) | BWHR | ||||
RWAUF | Currency markup | RWAUF | CUKY | 5 | WAERS | ||||
DWAFB | Conversion period until | DWAFB | DATS | 8 | DATUM | ||||
DWAFV | Conversion period from | DWAFV | DATS | 8 | DATUM | ||||
BWAVN | Conversion ratio - Denominator | BWAVN | DEC | 9(4) | DEC5_4 | ||||
BWAVZ | Conversion ratio - Numerator | BWAVZ | DEC | 9(4) | DEC5_4 | ||||
JAUSL | Drawing Indicator | JAUSL | CHAR | 1 | JANEI | ||||
DAUSL | Drawing date | DAUSL | DATS | 8 | DATUM | ||||
BEIVO | Total issue amount | VVBEIVO | CURR | 13(2) | BWHR | ||||
ANABT | Max. no. of assignments | VVANABT | NUMC | 3 | NUMC03 | ||||
BMINABT | Minimum assignment amount | VVMINABT | CURR | 13(2) | BWHR | ||||
JVERKBE | Sales restriction | VVJVERK | CHAR | 1 | JANEI | ||||
BDEBET | Coverage amount | VVBDEBE | CURR | 13(2) | BWHR | ||||
JWEIM | Resale to reserve carrier permitted | VVJWEIM | CHAR | 1 | JANEI | ||||
JRUECK | Subject to return | VVJRUECK | CHAR | 1 | JANEI | ||||
JANZWE | Resale report | VVJANZWE | CHAR | 1 | JANEI | ||||
JNACHR | Secondary loans ID | VVJNACHR | CHAR | 1 | JANE | ||||
SET_NAME | Redemption Schedule Set | RDPT_SET_NAME | CHAR | 15 | RDPT_SET_NAME | RDPT_SET_NAME | RDPT_F4_SET | ||
ROUNDING_RULE | Rounding Rule | TPM_ROUNDING_RULE | CHAR | 4 | TPM_ROUNDING_RULE | ||||
POOL_ID | Pool ID | VVPOOLID | CHAR | 13 | |||||
EXP_MAT_DATE | Expected End of Term | VVEXPMATDATE | DATS | 8 | DATE | ||||
TRANCHE_CLASSIF | Tranche Classification | VVTRANCHECL | NUMC | 3 | VVTRANCHECL | ||||
CALC_BEGIN | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
TERM | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
DLAVO | Term from | DLAVO | DATS | 8 | DATUM | ||||
DLABI | Term to | DLABI | DATS | 8 | DATUM | ||||
SOPTTYP | Indicator: Option Category | SOPTTYP | NUMC | 1 | SOPTTYP | ||||
DVERFALL | Expiration date for forward exchange transactions | DVERFALL | DATS | 8 | DATUM | ||||
DEBEG | Issue start date | DEBEG | DATS | 8 | DATUM | ||||
SVERROPT | Option Settlement Indicator | SVERROPT | NUMC | 1 | SVERROPT | ||||
BOVNE | Option ratio - Denominator | BOVNE | DEC | 9(4) | DEC5_4 | ||||
BOVZA | Option ratio - numerator | BOVZA | DEC | 9(4) | DEC5_4 | ||||
SINDEART | Securities Index | IDX | CHAR | 10 | CHAR10 | ||||
BBASPREI | Exercise price | BBASPREI | CURR | 13(2) | BWHR | ||||
RWHRBAS | Exercise price currency | RWHRBAS | CUKY | 5 | WAERS | ||||
SOPTAUS | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
AMINDEST | Exercise minimum | AMINDEST | DEC | 15(5) | ASTUECK | ||||
PBASKURS | Basic rate | PBASKURS | DEC | 10(7) | DEC3_7 | ||||
BINDEX | Index point per monetary unit | BINDEX | CURR | 13(2) | BWHR | ||||
RINDWHR | Index currency | RINDWHR | CUKY | 5 | WAERS | ||||
BBEZEIN | Reference units | VVBBEZEIN | CURR | 13(2) | BWHR | ||||
RBEZWHR | Reference unit currency | VVRBEZEIN | CUKY | 5 | WAERS | ||||
BBASIS | Index base | VVBASIS | DEC | 8(3) | DEC5_3 | ||||
OPTANLF | Warrant product category | OPTANLF | NUMC | 1 | OPTANLF | ||||
DERI | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RANL | Security ID Number | VVRANLW | CHAR | 13 | ALPHA | WP_RANL | RAN | SECURITY_F4 | |
SGSART | Product Type | VVSART | CHAR | 3 | VVSART | SAN | VVSART_APPL_BAS | ||
DJAHR | Expiration year | TI_DJAHR | NUMC | 4 | GJAHR | GJAHR | |||
DMONAT | Expiration month | TI_DMOANT | NUMC | 2 | T_DMOANT | ||||
SOFTYP | Options/futures category | TI_SOFTYP | NUMC | 2 | T_SOFTYP | ||||
SOPTTYP | Original option category (on closing) | TV_OPTTYP | NUMC | 3 | T_OPTTYP | ||||
SABRMET | Settlement Method Option | TI_SABRMET | CHAR | 1 | T_SABRMET | ||||
SMARGART | Margin type | TB_MARGART | CHAR | 5 | T_MARGART | ||||
SNOTTYPE | Quotation type option/future | TI_NOTTYPE | CHAR | 1 | T_NOTTYPE | ||||
PPTICK | Tick in percentage points | TI_PPTICK | DEC | 10(7) | DECV3_7 | ||||
BETICK | Tick as amount | TI_BETICK | CURR | 13(2) | WERTV7 | ||||
PITICK | Tick in index points | TI_PITICK | DEC | 11(6) | T_PKTKUR | ||||
BWTICK | Tick value | TI_BWTICK | CURR | 13(2) | WERTV7 | ||||
WWTICK | Tick Value Currency | TI_WWTICK | CUKY | 5 | WAERS | ||||
SPUTCALL | Put/call indicator | TI_SPUTCAL | NUMC | 1 | T_SPUTCAL | ||||
SSETTLFL | Settlement indicator | TI_SETTLFL | CHAR | 1 | T_SETTLFL | ||||
SOPTAUS | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
DVERFALL | Expiration date | TI_DVERF | DATS | 8 | DATUM | ||||
DLHANDEL | Last trade date | TI_DLHAND | DATS | 8 | DATUM | ||||
DERFUELL | Settlement date | TI_DERFUE | DATS | 8 | DATUM | ||||
SKALID | Factory calendar | SKALID | CHAR | 2 | WFCID | H_TFACD | |||
BNOMS | Nominal value | BNOMS | CURR | 13(2) | BWHR | ||||
RNWHR | Nominal currency | RNWHR | CUKY | 5 | WAERS | ||||
PKOND | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
SZSREF | Reference Interest Rate | SZSREF | CHAR | 10 | ZIREFKU | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
DENDF | Final due date | DENDF | DATS | 8 | DATUM | ||||
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
URANL | Security ID Number | VVRANLW | CHAR | 13 | ALPHA | WP_RANL | RAN | SECURITY_F4 | |
UINDEX | Securities Index | IDX | CHAR | 10 | CHAR10 | ||||
BPINDEX | Value of an index point | TI_BPINDEX | CURR | 13(2) | WERTV7 | ||||
WPINDEX | Index point currency | TI_WPINDEX | CUKY | 5 | WAERS | ||||
BSTRIKE | Strike as amount | TI_BSTRIKE | CURR | 13(2) | WERTV7 | ||||
WSTRIKE | Strike Currency | TI_WSTRIKE | CUKY | 5 | WAERS | ||||
PKSTRIKE | Strike in points | TI_PKSTRIK | DEC | 9(4) | DEC5_4 | ||||
IPSTRIKE | Strike as inverted percentage notation | TI_IPSTRIK | DEC | 10(7) | DECV3_7 | ||||
.INCLU--AP | 0 | ||||||||
DEBEG | Issue start date | DEBEG | DATS | 8 | DATUM | ||||
BNWHR | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
SNWHR | Currency of nominal amount | SNWHR | CUKY | 5 | WAERS | ||||
BWTICK_FINE | Tick Value | TPM_BWTICK_FINE | DEC | 13(7) | DEC13_7 | ||||
BETICK_CTY | Tick Amount (Commodity) | TI_BETICK_COMMODITY | DEC | 13(7) | DEC13_7 | ||||
BWTICK_CTY | Tick Value (Commodity) | TI_BWTICK_COMMODITY | DEC | 13(7) | DEC13_7 | ||||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
CONTRACT_SIZE | Contract Size | TPM_CTY_CONTRACT_SIZE | QUAN | 13(3) | FTR_QUAN | ||||
CONTRACT_SZ_UNIT | Mengeneinheit der Kontraktgröße | TPM_CTY_CONTRACT_SIZE_UNIT | UNIT | 3 | TRCO_COMM_UOM | ||||
QUANTITY | Quantity | FTR_QUAN | QUAN | 13(3) | FTR_QUAN | ||||
QUANTITY_UNIT | Unit of measure | TRCO_COMM_UOM | UNIT | 3 | TRCO_COMM_UOM | ||||
FIRST_NOTICE_DAY | First Notice Day | FIRST_NOTICE_DAY | DATS | 8 | FIRST_NOTICE_DAY | ||||
BETICK_CTY_CUNIT | Currency unit | VVSRUNIT | CHAR | 5 | VVSRUNIT | ||||
DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | TBA_DCSID | TBA_DCSID | TBAH_DCS | ||
KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | TBA_MIC | TBA_MIC | TBAH_MIC | ||
UNDERLYING_KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
SKOKO | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
SSTATI | Status of data record | SSTATI | NUMC | 2 | STATI | ||||
KZAHLAKT | Pay-in rate | KZAHLAKT | DEC | 10(7) | DEC3_7 | ||||
BZAHLAKT | Amount Deposited | BZAHLAKT | CURR | 10(2) | WHRBTRG | ||||
DREST | Balance payment date | DREST | DATS | 8 | DATUM | ||||
SZAHLDIV | Dividend form of payment | SZAHLDIV | NUMC | 1 | SZAHLDIV | ||||
DDBAB | Date from which entitled to dividends | DDBAB | DATS | 8 | DATUM | ||||
RDIVNR | Dividend coupon number | RDIVNR | NUMC | 3 | NUM03 | ||||
BAUSGLCH | Clearing amount for swap | BABTA | CURR | 10(2) | WHRBTRG | ||||
SWHRAUSG | Clearing amount currency | SWHRAUSG | CUKY | 5 | WAERS | ||||
DXGUELT | Trading until | DTGBI | DATS | 8 | DATUM | ||||
DTSCHAB | Swap period from | DTFVO | DATS | 8 | DATUM | ||||
DXTAUSCH | Swap period to | DTFBI | DATS | 8 | DATUM | ||||
ATCHNEN | Swap ratio - denominator | BTVNE | DEC | 9(4) | DEC5_4 | ||||
ATSHZAE | Swap ratio - numerator | BTVZA | DEC | 9(4) | DEC5_4 | ||||
PWANLRAB | Reinvestment discount percent | PWARB | DEC | 10(7) | DEC3_7 | ||||
JTHESAU | Reinvestment indicator | STHES | CHAR | 1 | JANEI | ||||
DBFRB | Date subscription period until | DBFRB | DATS | 8 | DATUM | ||||
DBFRV | Subscription period from | DBFRV | DATS | 8 | DATUM | ||||
BBPRU | Underlying subscription price | BBPRU | CURR | 10(2) | VVBNENNW | ||||
RWBZP | Subscription price currency | RWBZP | CUKY | 5 | WAERS | ||||
RWBZP_T | 30 Characters | CHAR30 | CHAR | 30 | CHAR30 | ||||
DBHAB | Date of subscription rights trading until | DBHAB | DATS | 8 | DATUM | ||||
DBHAV | Date of subscription rights trading from | DBHAV | DATS | 8 | DATUM | ||||
BBVHN | Subscription ratio - Denominator | BBVHN | DEC | 9(4) | DEC5_4 | ||||
BBVHZ | Subscription ratio - Numerator | BBVHZ | DEC | 9(4) | DEC5_4 | ||||
BVNJA | Advantage/disadvantage dividend of new stock | BVNJA | CURR | 10(2) | WHRBTRG | ||||
KREAK | Post Subscription Rights | KREAK | DEC | 15(6) | VVKWKURS | ||||
ZKOKO | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
RKEY1 | Key part 1 | RKEY1 | CHAR | 13 | RKEY1 | ||||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
NLFD_ANG | Offer consecutive number | NLFD_ANG | NUMC | 3 | LFNR3 | ||||
SSTATI | Status of data record | SSTATI | NUMC | 2 | STATI | ||||
SKOKOART | Type of Condition Header | SKOKOART | NUMC | 2 | SKOKOART | ||||
STILGRHY | Payment cycle | STILGRHY | NUMC | 2 | SRHYT | ||||
STILGART | Repayment Type Indicator | STILGART | NUMC | 1 | STILGART | ||||
SDISEIN | Type of Discount Withholding | SDISEIN | CHAR | 1 | SDISEIN | ||||
KZAHLUNG | Pay-in/disbursement rate | KZAHLUNG | DEC | 10(7) | DEC3_7 | ||||
BZAHLUNG | Pay-in/disbursement amount | BZAHLUNG | CURR | 13(2) | BWHR | ||||
SWHRZHLG | Currency of payment amount | SWHRZHLG | CUKY | 5 | WAERS | ||||
BZUSAGE | Commitment capital | BZUSAGE | CURR | 13(2) | WERTV7 | ||||
SWHRZUSA | Currency of commitment amount | SWHRZUSA | CUKY | 5 | WAERS | ||||
PEFFZINS | Effective Interest Rate | TB_EFF_RATE | DEC | 10(7) | DECV3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
SDISKO | Discounted | SDISKO | CHAR | 1 | SDISKO | ||||
DKUEND | Date of notice | DKUEND | DATS | 8 | DATUM | ||||
SKUEND | Reason for Notice | SKUEND | NUMC | 3 | SKUEART | ||||
DKUENDDG | Earliest Possible Date for Notice Given by the Lender | DKUENDDG | DATS | 8 | DATUM | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DBLFZ_ORIGIN | Original Term Start | DBLFZ_ORIGIN | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
DRESAM | Reservation of Conditions On | DRESAM | DATS | 8 | DATUM | ||||
DRESBIS | Reservation of Conditions Until | DRESBIS | DATS | 8 | DATUM | ||||
DANGAM | Offer creation date | DANGAM | DATS | 8 | DATUM | ||||
DANGBIS | Offer Effective To | DANGBIS | DATS | 8 | DATUM | ||||
SANGVOR | Offer/Acceptance Reservation Indicator | SANGVOR | NUMC | 2 | SANGVOR | ||||
JANNAHME | Offer Acceptance Indicator | JANNAHME | CHAR | 1 | JANEI | ||||
SANNAHME | Type of offer acceptance indicator | SANNAHME | NUMC | 2 | SKONTAKT | ||||
DANNAHME | Date of acceptance of offer | DANNAHME | DATS | 8 | DATUM | ||||
JVERTRAG | Indicator: Contract Created? | JVERTRAG | CHAR | 1 | JANEI | ||||
DVERTRAM | Contract creation date | DVERTRAM | DATS | 8 | DATUM | ||||
DVERTBIS | Return contract by | DVERTBIS | DATS | 8 | DATUM | ||||
PMANEFFZ | Internal Effective Interest Rate | TB_EFF_RATE_INT | DEC | 10(7) | DECV3_7 | ||||
SEFFM2 | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SKUEGL | Notice Arrangement Lender | VVSKUEGL | NUMC | 3 | VVSKUEGL | ||||
RPNR | Activity number/rollover number | VVRPNR | NUMC | 8 | NUMC08 | ||||
DEFSZ | Date of fixed period end | VVDEFSZ | DATS | 8 | DATUM | ||||
DGES | Earliest Notice Date in acc. with the Legal Right of Notice | VVDGES | DATS | 8 | DATUM | ||||
SGESAUS | Legal Right of Notice Excluded | VVSGESAUS | CHAR | 1 | XFELD | ||||
SZKZ | Special int. ID for int. on arrears for remaining balance | VVSZKZ | CHAR | 1 | VVSZKZ | ||||
NANGEBOT | Offer consecutive number | NLFD_ANG | NUMC | 3 | LFNR3 | ||||
SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
ZVRHYEFF | Int.sttlmnt frequency for effective int.rate calc.in months | VVZVRHYEFF | NUMC | 3 | NUMC03 | ||||
PVGLEFFZ | Comparative Effective Interest | TB_EFF_RATE_COM | DEC | 10(7) | DECV3_7 | ||||
SULTEFSZ | Month-end indicator for end of fixed period | VVSULTEFSZ | CHAR | 1 | VVSULT | ||||
DABEFFZ | Date when calculation of effective rate starts | VVDABEFFZ | DATS | 8 | DATUM | ||||
DKUENDDN | Earliest Possible Date for Notice Given by the Borrower | VVDKUENDDN | DATS | 8 | DATUM | ||||
SKUEDN | Notice Arrangement Borrower | VVSKUEDN | NUMC | 3 | VVSKUEDN | ||||
SKUEART | Notice Type for the Loan | VVSKUEART | NUMC | 3 | VVSKUEART | ||||
DMARKTZINS | ISB: Market Rate Date: Market Interest Rate for NPV Calc. | DMARKTZINS | DATS | 8 | DATS | ||||
SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | WFCID | H_TFACD | |||
EDEFFZINS | Relevant for Closely Defined Effective Interest | TB_EFF_RATE_ED | DEC | 10(7) | DECV3_7 | ||||
EDEFFMETH | Effective Interest Method - Acc. to EU Gdline Int.Statistics | EFFMETH | CHAR | 1 | EFFMETH | ||||
JAHREFFZINS | Relevant for Yearly Eff. Interest Acc Guideline 87/102/EU | TB_EFF_RATE_YEAR | DEC | 10(7) | DECV3_7 | ||||
JAHREFFMETH | Effective Interest Method - Acc. to EU Gdline Int.Statistics | EFFMETH | CHAR | 1 | EFFMETH | ||||
PEFFZINS_ORIGIN | Original Effective Interest Rate | TB_EFF_RATE_ORIG | DEC | 10(7) | DECV3_7 | ||||
.INCLU--AP | 0 | ||||||||
ORIGINAL_TERM | Original Term in Months | TB_VIEW_ORIGINAL_TERM | NUMC | 3 | |||||
OVERALL_RUNTIME | Overall Term | TB_VIEW_OVERALL_RUNTIME | NUMC | 3 | |||||
ORIG_CREDIT_SUM | Original Total Loan Amount | TB_VIEW_ORIGINAL_CREDIT_SUM | CURR | 13(2) | WERTV7 | ||||
DATE_REPAYMENT | Start Date for Repayment | TB_VIEW_DATE_REPAYMENT | DATS | 8 | DATUM | ||||
DATE_FIRST_RATE | Due Date for First Installment to Include a Repayment Amount | TB_VIEW_DATE_FIRST_RATE | DATS | 8 | DATUM | ||||
DAY_OF_PAYMENT | Day of Installment Payment | TB_VIEW_DAY_OF_PAYMENT | NUMC | 2 | T_VIEW_DAY_OF_PAYMENT | ||||
CLEARING_RATE | Amount for Final Loan Installment Payment | TB_VIEW_CLEARING_RATE | CURR | 13(2) | WERTV7 | ||||
EFF_INT_L_PYMNP | Effective Interest Rate for Last Change to Installment Plan | TB_MODEL_EFFECTIV_INTERSTS_PPC | DEC | 10(7) | DEC3_7 | ||||
DEFF_INT_L_PYMNP | Key Date for Last Change to Installment Plan | TB_MODEL_DATE_LAST_PAYMENTPLAN | DATS | 8 | DATUM | ||||
REPAY_DELAY | Model Calculation: DE for Periods of Repayment Suspension | TB_MODEL_REPAY_DELAY | NUMC | 2 | |||||
CALCULATED_PARAM | Calculate Installment Amount or Number of Installments? | TB_MODEL_P_RATE_OR_TERM | CHAR | 4 | T_MODEL_P_RATE_OR_TERM | ||||
CURR_CREDIT_SUM | Current Total Loan Amount | TB_VIEW_CURRENT_CREDIT_SUM | CURR | 13(2) | WERTV7 | ||||
BROUNDUNIT | Rounding Unit for Amounts | TB_BROUNDUNIT_A | DEC | 13(7) | TFMSRUNIT | ||||
SROUND | Rounding Category (Round up, Round Down or Number Rounding) | TB_SROUND_A | CHAR | 1 | TFM_SROUND | ||||
BOVERLIMIT | Drawing Tolerance as Amount | TB_COMP_OVERLIMIT_AMOUNT | CURR | 13(2) | WERTV7 | ||||
POVERLIMIT | Drawing Tolerance as a Percentage | TB_COMP_OVERLIMT_PERCENT | DEC | 10(7) | DECV3_7 | ||||
CONTAB | Condition Table | TB_FICO_CONTAB | CHAR | 8 | T_FICO_CONTAB | FVD_FICO_CONTAB | |||
CONTAB_VERSION | Version Number for a Condition Table | TB_FICO_CONTAB_VERSION | NUMC | 4 | T_FICO_CONTAB_VERSION | ||||
TERM_PAYMENT | Category of Last Installment | TB_TERM_PAYMENT | CHAR | 1 | T_TERM_PAYMENT | ||||
PAPR_ORIGIN | Original U.S. Effective Interest Rate | TB_PAPR_ORIGIN | DEC | 10(7) | DECV3_7 | ||||
BONO | 0 | ||||||||
TWX2 | 0 | ||||||||
ANAN | 0 | ||||||||
BEFRI | 0 | ||||||||
KOPO | 0 | ||||||||
KOPA | 0 | ||||||||
VZGPO | 0 | ||||||||
SHARE_CAPITAL | 0 | ||||||||
RATING | 0 | ||||||||
POOLDATA | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
POOL_ID | Pool ID | VVPOOLID | CHAR | 13 | |||||
CLASSIFICATION | Asset Pool Classification | VVPOOLCL | NUMC | 3 | VVPOOLCL | ||||
TOTAL_VOLUME | Nominal Amount | TPM_NOMINAL_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
TOTAL_VOLUME_CUR | Nominal Currency | TPM_NOMINAL_CURR | CUKY | 5 | WAERS | ||||
REINV_PERIOD | Reinvestment Period | TPM_REINV_PERIOD | DATS | 8 | DATS | ||||
POOLRATING | 0 | ||||||||
POOLREMARKS | 0 | ||||||||
TIERLEVEL | 0 | ||||||||
RIGHTS | 0 | ||||||||
FREE_ATTR | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RANL | Security ID Number | VVRANLW | CHAR | 13 | ALPHA | WP_RANL | RAN | SECURITY_F4 | |
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
GSART | Product Type | VVSART | CHAR | 3 | VVSART | SAN | VVSART_APPL_BAS | ||
ATTRIBUTE_LI01 | Value of the Free Attribute (20 Characters) | VWP_ATTR_LONG | CHAR | 20 | VWP_ATTR_LONG | ||||
ATTRIBUTE_LI02 | Value of the Free Attribute (20 Characters) | VWP_ATTR_LONG | CHAR | 20 | VWP_ATTR_LONG | ||||
ATTRIBUTE_LI03 | Value of the Free Attribute (20 Characters) | VWP_ATTR_LONG | CHAR | 20 | VWP_ATTR_LONG | ||||
ATTRIBUTE_LI04 | Value of the Free Attribute (20 Characters) | VWP_ATTR_LONG | CHAR | 20 | VWP_ATTR_LONG | ||||
ATTRIBUTE_LI05 | Value of the Free Attribute (20 Characters) | VWP_ATTR_LONG | CHAR | 20 | VWP_ATTR_LONG | ||||
ATTRIBUTE_SI01 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWP_ATTR_SHORT | ||||
ATTRIBUTE_SI02 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWP_ATTR_SHORT | ||||
ATTRIBUTE_SI03 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWP_ATTR_SHORT | ||||
ATTRIBUTE_SI04 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWP_ATTR_SHORT | ||||
ATTRIBUTE_SI05 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWP_ATTR_SHORT | ||||
ATTRIBUTE_SI06 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWP_ATTR_SHORT | ||||
ATTRIBUTE_SI07 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWP_ATTR_SHORT | ||||
ATTRIBUTE_SI08 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWP_ATTR_SHORT | ||||
ATTRIBUTE_SI09 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWP_ATTR_SHORT | ||||
ATTRIBUTE_SI10 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWP_ATTR_SHORT | ||||
ATTRIBUTE_FR01 | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ATTRIBUTE_FR02 | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ATTRIBUTE_FR03 | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ATTRIBUTE_FR04 | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ATTRIBUTE_FR05 | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ATTRIBUTE_DI01 | Value of the Free Attribute (Date) | VWP_ATTR_DATE | DATS | 8 | VWP_ATTR_DATE | ||||
ATTRIBUTE_DI02 | Value of the Free Attribute (Date) | VWP_ATTR_DATE | DATS | 8 | VWP_ATTR_DATE | ||||
ATTRIBUTE_CU01 | Value of the Free Attribute (Currency) | VWP_ATTR_CURR | CUKY | 5 | WAERS | ||||
ATTRIBUTE_CU02 | Value of the Free Attribute (Currency) | VWP_ATTR_CURR | CUKY | 5 | WAERS | ||||
ATTRIBUTE_DTFR | Value of the Free Attribute (Date) | VWP_ATTR_DATE | DATS | 8 | VWP_ATTR_DATE | ||||
ATTRIBUTE_DTTO | Value of the Free Attribute (Date) | VWP_ATTR_DATE | DATS | 8 | VWP_ATTR_DATE | ||||
.INCLU--AP | 0 | ||||||||
COVERAGE_ELIG | Coverage Eligibility Entry | /TRMKR/COVERAGE_ELIG | CHAR | 2 | /TRMKR/COVERAGE_ELIG | ||||
EMBD_DERIVATIVE | Embedded Derivative | /TRMKR/EMBD_DERIVATIVE | CHAR | 30 | /TRMKR/EMBD_DERIVATIVE | ||||
ORIG_ISSUE_CURR | Original Issue Currency | /TRMKR/ISSUE_CURR | CUKY | 5 | WAERS | ||||
QUOT_BREAKDOWN | Quotation Breakdown | /TRMKR/QUOT_BREAKDOWN | CHAR | 2 | /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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects