TBCO_SEC SAP (Security order confirmation display structure) Structure details
Description: Security order confirmation display structure
Structure field list including key, data, relationships and ABAP select examples
TBCO_SEC 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 "Security order confirmation display structure" 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_TBCO_SEC TYPE TBCO_SEC.
The TBCO_SEC table consists of various fields, each holding specific information or linking keys about Security order confirmation display structure data available in SAP. These include MANDT (Client), BUKRS (Company Code), BUTXT (Name of Company Code or Company), BU_SWIFT (SWIFT Code for Company Code (Sender of Message)).. 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 (character-type or numeric)
SAP TBCO_SEC 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25 | TEXT25 | ||||
BU_SWIFT | SWIFT Code for Company Code (Sender of Message) | TB_BUSWIFT | CHAR | 11 | SWIFT | ||||
RANTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
SGSART | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
XSGSART | Name of product type | TB_XGSART | CHAR | 30 | TEXT30 | ||||
XSGSART_K | Short text for product type | TB_XGSART_K | CHAR | 10 | TEXT10 | ||||
XSGSART_E | Do not use this field (see documention) | TB_DONT_USE_TEXT30 | CHAR | 30 | TEXT30 | ||||
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | Assigned to domain | T_SFHAART | T02 | C_AT10 | |
XSFHAART | Name of Transaction Type | TB_FATEXT | CHAR | 30 | T_XTEXT30 | ||||
XSFHAART_E | Do not use this field (see documention) | TB_DONT_USE_TEXT30 | CHAR | 30 | TEXT30 | ||||
SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | NUMC | 2 | Assigned to domain | T_SFGZUTY | C_AT02 | ||
XSFGZUSTT | Name of activity category | TB_XTTEXT | CHAR | 30 | TEXT30 | ||||
XSFGZUSTTE | Do not use this field (see documention) | TB_DONT_USE_TEXT30 | CHAR | 30 | TEXT30 | ||||
SFUNKTV | Transition Function from Directly Preceding Activity | TB_SFUNKTV | CHAR | 4 | Assigned to domain | T_FUNKTION | |||
XSFUNKTV | Name of Treasury function | TB_XFUNKT | CHAR | 30 | TEXT30 | ||||
SFUNKTL | Latest function used in editing activity | TB_SFUNKTL | CHAR | 4 | Assigned to domain | T_FUNKTION | |||
XSFUNKTL | Name of Treasury function | TB_XFUNKT | CHAR | 30 | TEXT30 | ||||
XSFUNKTL_E | Do not use this field (see documention) | TB_DONT_USE_TEXT30 | CHAR | 30 | TEXT30 | ||||
LANGU_BEFORE | Language Key Before Cross-Language Search for SAPscript Form | TB_LANGU_BEFORE | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
LANGU_AFTER | Language Key After Cross-Language Search for SAPscript Form | TB_LANGU_AFTER | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
RFHAZU | Transaction activity | TB_RFHAZU | NUMC | 5 | T_RFHAZU | FAS | |||
RFHAZUL | Last Active Transaction Activity | TB_RFHAZUL | NUMC | 5 | T_RFHAZU | ||||
SFIXRFHAZU | Fixing activity (Indicator) | TB_SFIXRFHAZU | CHAR | 1 | XFELD | ||||
SFIRST | Indicator: 1st correspond. for activity, corr.type + medium? | TB_SFIRST | CHAR | 1 | XFELD | ||||
RLFDNR | Sequential No. VRBKORES Data Record per Activity (Key Field) | TB_RLFDNR | NUMC | 2 | T_LFDNR2 | ||||
SREPEAT | Repeat correspondence? | TB_REPEAT | CHAR | 1 | XFELD | ||||
DATUM | Entered On | TB_DCRDAT | DATS | 8 | DATUM | ||||
CRUSER | Entered by | TB_CRUSER | CHAR | 12 | SYCHAR12 | ||||
DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | DATUM | ||||
TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | UZEIT | ||||
UPUSER | Last Changed by | TB_UPUSER | CHAR | 12 | SYCHAR12 | ||||
DUPDAT | Changed on | TB_DUPDAT | DATS | 8 | DATUM | ||||
TUPTIM | Time changed | TB_TUPTIM | TIMS | 6 | UZEIT | ||||
DVTRAB | Contract Conclusion Date | TB_DVTRAB | DATS | 8 | DATUM | ||||
RMAID | Master Agreement | TB_RMAID | CHAR | 10 | Assigned to domain | ALPHA | T_RMAID | TMA | VTMA |
GSPPART | Contact Person | TB_GSPPART | CHAR | 19 | TEXT19 | ||||
DBLFZ | Term Start | TB_DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | Term End | TB_DELFZ | DATS | 8 | DATUM | ||||
KONTRH | Business Partner Number | TB_KUNNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
XKONTRH | Name and address of business partner | TB_XKONTRH | CHAR | 80 | TEXT80 | ||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_PERSNUM | CDT | ADDRESS |
FROMCOUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
ROLETYP | BP Role Category | BU_PARTNERROLECAT | CHAR | 6 | Assigned to domain | BU_ROLECAT | |||
XROLETYP | Description | BU_BEZ50 | CHAR | 50 | TEXT50 | ||||
RGARANT | Guarantor of Financial Transaction | TB_RGARANT_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
XRGARANT | Name and address of guarantor | TB_XGARANT | CHAR | 80 | TEXT80 | ||||
KO_FAX | Business partner fax number | TB_KOTELFX | CHAR | 31 | TEXT31 | ||||
KO_ADR_COUNTRY | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
KO_SWIFT | SWIFT Code of Counterparty (Receiver of Message) | TB_KOSWIFT | CHAR | 11 | SWIFT | ||||
KO_ADSMTP | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ZR_SWIFT | SWIFT code of payer/payee | TB_ZRSWIFT | CHAR | 11 | SWIFT | ||||
RPBANK | Partner bank details | TB_RPBANK | CHAR | 4 | BVTYP | ||||
PB_SWIFT | SWIFT code of partner bank | TB_PBSWIFT | CHAR | 11 | SWIFT | ||||
PB_IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
RAHABKI | Short key for own house bank | TB_RHABKI | CHAR | 5 | Assigned to domain | HBKID | |||
HB_SWIFT | House bank SWIFT code | TB_HBSWIFT | CHAR | 11 | SWIFT | ||||
HB_IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
RAHKTID | Short key for house bank account | TB_RHKTID | CHAR | 5 | Assigned to domain | HKTID | |||
RAHK_NO | Do Not Use | TB_RAHK_NO | CHAR | 18 | BANKN | ||||
RPCODE | Repetitive Code | RPCODE | CHAR | 20 | Assigned to domain | ALPHA | RPCODE | FIBL_RPCODE | |
SZART | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
NORDEXT | External Reference | TB_NORDEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
RDEALER | Trader | RDEALER | CHAR | 12 | Assigned to domain | RDEALER | |||
SSTOGRD | Reason for Reversal | SSTOGRD | CHAR | 2 | Assigned to domain | SSTOGRD | |||
XSSTOGRD | Short description for reversal reason | TB_XSTOGRD | CHAR | 15 | XKBEZ | ||||
SRNDNG | Rounding of Amount from Generated Flows | TB_SRNDNG | CHAR | 1 | TFM_SROUND | ||||
CORTYP | Correspondence type | TB_CORTYP | CHAR | 3 | Assigned to domain | T_CORTYP | T80 | ||
FORMULAR | Form Name | TDFORM | CHAR | 16 | TDFORM | ||||
SWIFT_DAT | Format for SWIFT files | TB_SWI_DAT | CHAR | 8 | TB_SWI_DAT | ||||
SANLF | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 3 | Assigned to domain | T_SFGTYP | |||
SAKTIV | Active Status of Transaction or Activity | TB_SAKTIV | NUMC | 1 | T_SAKTIV | ||||
RPORTB | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
ZUONR | Finance Project | TB_TFPROJ | CHAR | 13 | T_TFPROJ | ||||
RANL | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
RLDEPO | Securities Account | VRLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ||
PEFFZINS | Effective Interest Rate | TB_PYIELD | DEC | 10(7) | DECV3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
XEFFMETH | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
RCOMVALCL | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | Assigned to domain | TPM_COM_VAL_CLASS | CVC | ||
XRCOMVALCL | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
FACILITYNR | Transaction Number of Facility | TB_FACILITYNR | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | F4_FTR_FC | |
FACILITYBUKRS | Company Code of Facility | TB_FACILITYBUKRS | CHAR | 4 | Assigned to domain | BUKRS | H_T001 | ||
VRFHA | Reference transaction (Rollover/premature settlement) | TB_VORFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | ||
RRFHA | Reference transaction (general) | TB_RRFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | ||
RBUKRS | Company code of reference transaction | TB_RBUKRS | CHAR | 4 | Assigned to domain | BUKRS | |||
TRANS_KEY | Name | TDOBNAME | CHAR | 70 | TDOBNAME | ||||
SFORMCT | Form Category | TB_FRMCAT | NUMC | 1 | T_FRMCAT | ||||
BANKA_SB | Name of bank | BANKA | CHAR | 60 | TEXT60 | ||||
BRNCH_SB | Bank Branch | BRNCH | CHAR | 40 | TEXT40 | ||||
STRAS_SB | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
ORT01_SB | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
SWIFT_SB | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
BNKLZ_SB | Bank number | BANKL | CHAR | 15 | BANKL | BLZ | |||
BANKN_SK | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BNKN2_SK | Alternative Bank Acct Number (for Ambiguous Acct Number) | BNKN2 | CHAR | 24 | BNKN2 | ||||
IBAN_SK | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
SDISP_INTST | Output Interest Rate Flows (PDF) | TB_SDISP_INTST | CHAR | 1 | BOOLE | ||||
SDISP_BNOM | Output Other Nominal Flows (PDF) | TB_SDISP_BNOM | CHAR | 1 | BOOLE | ||||
SDISP_REF | Output Netting (PDF) | TB_SDISP_REF | CHAR | 1 | BOOLE | ||||
SDISP_ZS | Output Other Flows (PDF) | TB_SDISP_ZS | CHAR | 1 | BOOLE | ||||
SDISP_COND | Output Condition Data | TB_SDISP_COND | CHAR | 1 | BOOLE | ||||
SDISP_COND_SE | Output Conditions for Securities | TB_SDISP_COND_SE | CHAR | 1 | BOOLE | ||||
SDISP_COND_REP | Output Repayment Conditions (PDF) | TB_SDISP_COND_REP | CHAR | 1 | BOOLE | ||||
SDISP_RPAY | Output Repayments (PDF) | TB_SDISP_RPAY | CHAR | 1 | BOOLE | ||||
SDISP_BNOM_IN | Output Other Nominal Flows (PDF) | TB_SDISP_BNOM | CHAR | 1 | BOOLE | ||||
SDISP_DIVID_FW | Ausgabe der Dividende fließt in FST (PDF) | TB_SDISP_DIVID | CHAR | 1 | CHAR1 | ||||
SFIXRFHAZU_CS | Fixing activity (Indicator) | TB_SFIXRFHAZU | CHAR | 1 | XFELD | ||||
SFIXRFHAZU_TRS | Fixing activity (Indicator) | TB_SFIXRFHAZU | CHAR | 1 | XFELD | ||||
SDISP_BNOM_TRS | Display Data for Nominal Amount of Total Return Equity Swap | TB_SDISP_NOM_TRS | CHAR | 1 | BOOLE | ||||
SDISP_BNOM_TRS_IN | Display Data for Nominal Amount of Total Return Equity Swap | TB_SDISP_NOM_TRS | CHAR | 1 | BOOLE | ||||
SDISP_DIVID_TRS | Display Data for Dividend Flow of Total Return Swap | TB_SDISP_DIVID_TRS | CHAR | 1 | BOOLE | ||||
LTX | Status name | LTX | CHAR | 30 | TEXT30 | ||||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
XLDEPO | Securities account ID | XLDEPO | CHAR | 30 | XLDEPO | ||||
NORDER | Order Number | NORDER | NUMC | 8 | NUM8 | ORD | |||
SSTATI | Status of data record | SSTATI | NUMC | 2 | TZC37 | STATI | |||
DORDER | Order day | DORDER | DATS | 8 | DATUM | ||||
DVALUT | Interest Value Date/Calculation Date | VVDZINVAL | DATS | 8 | DATUM | ||||
DDISPO | Value date / planning day | VVDWERTST | DATS | 8 | DATUM | ||||
DBESTAND | Position value date | DBESTAND | DATS | 8 | DATUM | ||||
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
BWKURS | Security price for unit quotation | BWKURS | CURR | 13(2) | BWKURS | ||||
SNWHR | Currency of nominal amount | SNWHR | CUKY | 5 | TCURC | WAERS | |||
BNWHR | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
PWKURS | Security price for percentage quotation | PWKURS | DEC | 10(7) | PWKURS | ||||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | TCURC | WAERS | |||
BBWHR | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | ||||
SCWHR | Settlement Currency | SCWHR | CUKY | 5 | TCURC | WAERS | |||
BCWHR | Settlement Amount | BCWHR | CURR | 13(2) | WERTV7 | ||||
SHWHR | Local currency | VVSHWHR | CUKY | 5 | TCURC | WAERS | |||
BHWHR | Amount in local currency | BHWHR | CURR | 13(2) | WERTV7 | ||||
KURS1 | Exchange rate into settlement currency | VVKURS1 | DEC | 9(5) | KURSF | ||||
KURS2 | Exchange rate from settlement currency into local currency | VVKURS2 | DEC | 9(5) | KURSF | ||||
KCROSS | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
SSWHR | Stock price currency | VVSSWHR | CUKY | 5 | TCURC | WAERS | |||
BSWHR | Market value | VVBSWHR | CURR | 13(2) | WERTV7 | ||||
SLIMIT | Order notation | SLIMIT | CHAR | 1 | SLIMIT | ||||
BLIMIT | Limit price for unit quotation | BLIMIT | CURR | 13(2) | BWKURS | ||||
PLIMIT | Limit price for percentage quotation | PLIMIT | DEC | 10(7) | PWKURS | ||||
XORDZU | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
SBEWART | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
XBEWART | Name of flow type | XBEWART | CHAR | 30 | TEXT30 | ||||
JVERK6B | Sale in acc. with tax credit method | VVJVERK6B | CHAR | 1 | CHAR1 | ||||
SBEWZITI | Flow category | SBEWZITI | CHAR | 4 | TZB03 | SBEWZITI | |||
SRUNIT | Currency unit | VVSRUNIT | CHAR | 5 | TZUNI | VVSRUNIT | |||
KWKURS | Security price | VVKWKURS | DEC | 15(6) | VVKWKURS | ||||
RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | Assigned to domain | VVRHANDPL | WHP | ||
RBANKK | Bank account | RBANKK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | BKT | |
RZBANK | Paying Bank | VVRZBANK_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
XZUSATZ | Assignment | XZUSATZ | CHAR | 18 | CHAR18 | ||||
DSCHLUSS | Date of business closing | VVDSCHLUSS | DATS | 8 | DATUM | ||||
XRKONTRAH | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
REPKE | Issuer Identity Key | REPKE_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
XREPKE | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB |
Key field | Non-key field |
How do I retrieve data from SAP structure TBCO_SEC using ABAP code?
As TBCO_SEC 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 TBCO_SEC as there is no data to select.How to access SAP table TBCO_SEC
Within an ECC or HANA version of SAP you can also view further information about TBCO_SEC 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