SECURITY_CONDITION SAP (Condition items) Structure details
Description: Condition items
Related tables to SECURITY_CONDITION
Access table SECURITY_CONDITION
Structure field list including key, data, relationships and ABAP select examples
SECURITY_CONDITION 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 "Condition items" 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_CONDITION TYPE SECURITY_CONDITION.
The SECURITY_CONDITION table consists of various fields, each holding specific information or linking keys about Condition items data available in SAP. These include CONDITION_TYPE (Condition Type (Smallest Subdivision of Condition Records)), CONDITION_FORM (Condition Form), VALID_FROM (Condition Item Valid From), AMOUNT (Condition amount independent of currency).. 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_CONDITION 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 |
COND_KEY | Internal condition key | COND_KEY | NUMC | 6 | COND_KEY | ||||
CONDITION_TYPE | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | Assigned to domain | SKOART | |||
CONDITION_FORM | Condition Form | JNULLKON | CHAR | 1 | SKONDF | ||||
VALID_FROM | Condition Item Valid From | DGUEL_KP | DATS | 8 | DATUM | ||||
AMOUNT | Condition amount independent of currency | VVKBKOND | DEC | 15(6) | VVKWKURS | ||||
CURRENCY | Currency of Condition Item | SWHRKOND | CUKY | 5 | Assigned to domain | WAERS | |||
REF_INTEREST_RATE | Reference Interest Rate | SZSREF | CHAR | 10 | Assigned to domain | ZIREFKU | |||
REF_SIGN | +/- sign / reference interest rate operator | SZSREFVZ | CHAR | 1 | SZSREFVZ | ||||
PERCENTAGE_RATE | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
FORMULAR | 0 | ||||||||
INTEREST_CALC_METHOD | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
CALC_DATE | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
CALC_MONTH_END | Month-end indicator for calculation date | VVSBULT | CHAR | 1 | JFLAGG | ||||
CALC_INCLUSIV | Inclusive indicator for calculation date | TFMJSINCL | CHAR | 1 | TFMSINCL | ||||
CALC_CALENDAR_RULE | Shift calculation date to working day | VVSVWERK | NUMC | 1 | T_SWERK | ||||
CALC_DETERMINE_METHOD | Method for determining the next value date | VVSVMETH | NUMC | 1 | T_SVMETH | ||||
CALC_DATE_RELATED | Indicator for Pro Rata Temporis Calculations | VVSZEITANT | NUMC | 1 | VVSZEITANT | ||||
DUE_DATE | Due date | DFAELL | DATS | 8 | DATUM | ||||
DUE_MONTH_END | Month-End Indicator for Due Date | SFULT | CHAR | 1 | VVSULT | ||||
DUE_INCLUSIV | Inclusive Indicator for Due Date | VVSFINCL | NUMC | 1 | VVSINCL | ||||
DUE_CALENDAR_RULE | Shift due date to working day | VVSFWERK | NUMC | 1 | T_SWERK | ||||
DUE_DATE_RELATED | Indicator for due date-related FiMa calculations | VVSFANT | NUMC | 1 | VVSFANT | ||||
DUE_DETERMINE_METHOD | Method for determining the next due date | VVSFMETH | NUMC | 1 | T_SFMETH | ||||
FREQUENCY_MONTH | Frequency in months | AMMRHY | NUMC | 3 | NUMC03 | ||||
CALENDAR | Factory calendar | SKALID | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
CALENDAR2 | Calendar ID 2 (valid in connection with calendar ID 1) | VVSKALID2 | CHAR | 2 | Assigned to domain | WFCID | |||
CALENDARWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
FORMULAR_REFERENCE | Formula Reference | TB_XFORMBE | CHAR | 4 | Assigned to domain | T_FORMBE | |||
ROUND_TYPE | Rounding Category | TFM_SROUND | CHAR | 1 | TFM_SROUND | ||||
EXCHANGE_RATE | Exchange rate | VVKURSF | DEC | 9(5) | EXCRT | KURSF | |||
SETTLE_IMMEDIATELY | Immediate settlement | JSOFVERR | CHAR | 1 | TFMSOFVERR | ||||
EXP_INTEREST | Exponential Interest Calculation | TB_JZINSRE | CHAR | 1 | XFELD | ||||
PAYMENT_RATE | Payment Rate | TFM_PPAYMENT | DEC | 11(7) | TFM_PPAYMENT | ||||
PAY_CALENDAR_RULE | Working Day Shift for Payment Date | TB_SDWERK | NUMC | 1 | T_SWERK | ||||
PERCENTAGE_CALC | Percentage Calculation | TB_JPROZR | CHAR | 1 | XFELD | ||||
LEVEL | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | NUMC2 | ||||
AVGSTAGEVZ | +/- sign for number of working days for value date | AVGSTAGEVZ | CHAR | 1 | PLUSM | ||||
AFGSTAGEVZ | +/- sign for number of working days for due date | AFGSTAGEVZ | CHAR | 1 | PLUSM | ||||
AZGSTAGE | Number of working days for interest fixing | AZGSTAGE | NUMC | 2 | NUMC2 | ||||
AVGSTAGE | Number of working days for value date | AVGSTAGE | NUMC | 2 | NUMC2 | ||||
AFGSTAGE | Number of working days to due date | AFGSTAGE | NUMC | 2 | NUMC2 | ||||
BKOND | Condition item currency amount | BKOND | CURR | 13(2) | WERTV7 | ||||
RDIVNR | Dividend coupon number | RDIVNR | NUMC | 3 | NUM03 | ||||
ATTRHY | Frequency in Days | ATTRHY | NUMC | 3 | NUMC03 | ||||
SFRANZ | Shift Due Date | TFMSFRANZ | NUMC | 1 | TFMSFRANZ | ||||
SFANT | Indicator for due date-related FiMa calculations | VVSFANT | NUMC | 1 | VVSFANT | ||||
SFSTPER | Calculation method for first period of condition item | TFMSFSTPER | NUMC | 1 | TFMSPERMETH | ||||
SLSTPER | Calculation method for last period of condition item | TFMSLSTPER | NUMC | 1 | TFMSPERMETH | ||||
SBASIS | Calculation base reference | VVSBASIS | CHAR | 4 | Assigned to domain | VVSBASIS | |||
SKOPO | Detailed identification for condition items | VVSKOPO | NUMC | 2 | Assigned to domain | VVSKOPO | |||
MANSP | Dunning block | MANSP | CHAR | 1 | Assigned to domain | MANSP | |||
ZAHLS | Payment Block Key | DZLSPR | CHAR | 1 | Assigned to domain | ZAHLS | SPE | ||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
SPARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
RKONT | Quota number | RKONT | NUMC | 6 | RKONT | RKT | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
SBUST | Posting control key | VVSBUST | NUMC | 2 | VVSBUST | ||||
SZEGEN | Generate incoming payment immediately | SZEGEN | NUMC | 2 | Assigned to domain | SZEGEN | |||
SEXCLGUEL | Exclusive indicator for start date of condition position | TFMSEXCLKP | NUMC | 1 | VVSEXCLVON | ||||
SULTGUEL | Month-end indicator for start date of condition position | TFMSULT_KP | CHAR | 1 | VVSULT | ||||
AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | TFM_AMMRHYZV | NUMC | 2 | TFM_AMMRHYZV | ||||
BROUNDUNIT | Rounding Unit for Amounts | TFMBRUNIT | DEC | 13(7) | TFMSRUNIT | ||||
BBASISUNIT | Base Unit for Rounding | TFM_BBASISUNIT | CURR | 17(2) | TFM_WRTV9 |
Key field | Non-key field |
How do I retrieve data from SAP structure SECURITY_CONDITION using ABAP code?
As SECURITY_CONDITION 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_CONDITION as there is no data to select.How to access SAP table SECURITY_CONDITION
Within an ECC or HANA version of SAP you can also view further information about SECURITY_CONDITION 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