TBCO_SL SAP (Output Structure for Securities Lending) Structure details
Description: Output Structure for Securities Lending
Structure field list including key, data, relationships and ABAP select examples
TBCO_SL 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 "Output Structure for Securities Lending" 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_SL TYPE TBCO_SL.
The TBCO_SL table consists of various fields, each holding specific information or linking keys about Output Structure for Securities Lending 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_SL 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 | ||||
.INCLU-_CD | 0 | ||||||||
MANDT_CD | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
RANL_CD | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
SANLF_CD | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
SSTATI_CD | Status of a security | SEC_STATUS | NUMC | 2 | SEC_STATUS | ||||
RANLALT1_CD | RANLALT1 | RANLALT1S | CHAR | 13 | CHAR13S | RAN | |||
RANLALT2_CD | Alternative identification 2 | RANLALT2S | CHAR | 13 | CHAR13S | RAN | |||
GSART_CD | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
SBRSCH_CD | Industry key | BRSCH | CHAR | 4 | T016 | BRSCH | |||
SWERTTYP_CD | Security Type ID | SWERTTYP | NUMC | 1 | TW20 | SAKTTYP | |||
SBOERNOT_CD | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | JANEI | ||||
WLOMB_CD | Indicator eligible as collateral | WLOMB | CHAR | 1 | JANEI | ||||
JDECK_CD | Regulatory reporting BPV (hedge fund Y/N) | JDECK | CHAR | 1 | JANEI | ||||
WPFAN_CD | Indicator pledgeable | WPFAN | CHAR | 1 | JANEI | ||||
SSTBE_CD | Tax treatment indicator | SSTBE | CHAR | 1 | JANEI | ||||
LOEVM_CD | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
JABMI_CD | Joint partner vote indicator | JABMI | CHAR | 1 | JANEI | ||||
XALKZ_CD | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
XALLB_CD | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
REPKE_CD | Issuer Identity Key | REPKE_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
BEMPREIS_CD | Issue Price | BEMPREIS | CURR | 10(2) | VVBNENNW | ||||
REWHR_CD | Issue currency | REWHR | CUKY | 5 | TCURC | WAERS | |||
PEMKURS_CD | Issue rate in percent | PEMKURS | DEC | 10(7) | DEC3_7 | ||||
SNOTI_CD | Quotation Indicator | SNOTI | NUMC | 1 | SNOTI | ||||
PKUAB_CD | Price deviation in percent | PKUAB | DEC | 10(7) | DEC3_7 | ||||
BKUAB_CD | Absolute price deviation | BKUAB | CURR | 10(2) | WHRBTRG | ||||
DANDPFL_CD | Obligation to offer for sale until | DANDPFL | DATS | 8 | DATUM | ||||
DANDRE_CD | Right to offer until | DANDRE | DATS | 8 | DATUM | ||||
SOBJEKT_CD | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
RERF_CD | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF_CD | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF_CD | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER_CD | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR_CD | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR_CD | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR_CD | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER_CD | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SROLEXT_CD | General Security Classification | ALWPKL | CHAR | 3 | TW22 | ALWPKL | |||
VVSLOEKZ_CD | Deletion indicator | VVSLOEKZ | NUMC | 1 | VVSLOEKZ | ||||
JMUENDEL_CD | Eligibility indicator | VVJMUEND | CHAR | 1 | JANEI | ||||
SMOVERW_CD | Possible custody type | SMOVERW | CHAR | 2 | TW50 | SMOVERW | |||
SIHERK_CD | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
KBEMPREIS_CD | Issue price independent of currency | VVKBEMPR | DEC | 15(6) | VVKWKURS | ||||
SDEPOSTAT_CD | Securities account statistics key | VVDEPOSTAT | NUMC | 2 | TW51 | VVDEPOSTA | |||
SFUNDI_CD | Indicator: Funded | VVSFUNDI | CHAR | 1 | JANEI | ||||
SWPHGMPF_CD | Securities trading law reporting obligation indicator | VVSWPHGMPF | CHAR | 1 | JANEI | ||||
RISIN_CD | International securities ID number (no longer used) | VVRISIN | CHAR | 13 | RISIN | ||||
INSTITUTE_CD | Institute Providing Credit Standing Information | BP_SOL_INS | CHAR | 4 | TP07 | BP_SOL_INS | |||
RATING_CD | Rating | BP_RATING | CHAR | 3 | TP06 | BP_RATING | |||
PRICE_INDEX_CD | Name of Price Index | TIDX_INDEX_NAME | CHAR | 15 | TIDX_PRICE_INDEX | TIDX_INDEX_NAME | |||
PRICE_IDX_BDATE_CD | Price Index Base Date | TIDX_INDEX_BASE_DATE | DATS | 8 | DATPER | ||||
.INCLU--AP | 0 | ||||||||
.INCLU-_PI | 0 | ||||||||
MANDT_PI | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS_PI | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RANL_PI | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
RLDEPO_PI | Securities Account | VRLDEPO | CHAR | 10 | TWD01 | RLDEPO | DEP | ||
SSTATI_PI | Status of data record | SSTATI | NUMC | 2 | Assigned to domain | STATI | |||
XDKBZ_PI | Sec.acct position short description | XDKBZ | CHAR | 15 | XKBEZ | ||||
RREFKONT_PI | Account Assignment Reference in Financial Assets Management | RREFKONT | CHAR | 8 | T037S | USTRU | KRE | ||
SVERWA_PI | Custody type | SVERWA | CHAR | 1 | Assigned to domain | SVERWA | |||
DANDPFL_PI | Obligation to offer for sale until | DANDPFL | DATS | 8 | DATUM | ||||
DANDRE_PI | Right to offer until | DANDRE | DATS | 8 | DATUM | ||||
SFIBG_PI | Asset Grouping Indicator | SFIBG | NUMC | 4 | TW08 | SFIBG | |||
SGLZB_PI | SCB asset group indicator | SGLZB | CHAR | 4 | TW07 | SGLZB | |||
SBILK_PI | Balance Sheet Indicator | SBILK | CHAR | 2 | TW11 | SBILK | |||
JSPRI_PI | Intercorporate privilege indicator | JSPRI | CHAR | 1 | JANEI | ||||
JBTEI_PI | Shareholding indicator | JBTEI | CHAR | 1 | JANEI | ||||
RFGEB_PI | Releaser of master record (person) | RFGEB_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
DFREI_PI | Date of release | DFREI | DATS | 8 | DATUM | ||||
TFREI_PI | Time of release | TFREI | TIMS | 6 | TIMES | ||||
RERF_PI | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF_PI | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF_PI | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER_PI | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR_PI | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR_PI | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBHER_PI | Origin indicator for table | TBHER | CHAR | 1 | TBHER | ||||
RBHER_PI | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SBESANT_PI | Holding | SBESANT | CHAR | 2 | TZBA | SBESANT | |||
JBETEIL_PI | Shareholding indicator | JBETEIL | CHAR | 1 | JANEI | ||||
VVSLOEKZ_PI | Deletion indicator | VVSLOEKZ | NUMC | 1 | VVSLOEKZ | ||||
SKWG14NEU_PI | Position grouping acc. Para 14 GBA (Sec. and loans) | VVSKWG14 | CHAR | 2 | VVSKWG14 | ||||
SMOVERW_PI | Custody type | TB_SVERWA | CHAR | 2 | TW50 | SMOVERW | |||
TBEAR_PI | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
DERIV_CAT_PI | Position management procedure | TPM_DERIV_CAT | NUMC | 3 | TPM_DERIV_CAT | ||||
.INCLU-_AD | 0 | ||||||||
MANDT_AD | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS_AD | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RLDEPO_AD | Securities Account | VRLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ||
VERKONTO_AD | No. of bank giro acct, security acct no. in US secur.accts | VERKONTO | CHAR | 15 | ABNKR | ||||
RDEPOTNR_AD | Securities account no. | ABNKR | CHAR | 15 | ABNKR | ||||
XLDEPO_AD | Securities account ID | XLDEPO | CHAR | 30 | XLDEPO | ||||
RERTRK_AD | Internal bank account | RERTRK | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
RDPBANK_AD | Depository Bank | RDEPOTBANK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
RBGUE_AD | Beneficiary | RBGUENST | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
SSPERRV_AD | 0 | ||||||||
DSPERR_AD | Block flag until | DSPERR | DATS | 8 | DATUM | ||||
RGSBER_AD | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SSKZB_AD | BAV stock indicator | SSKZB | NUMC | 1 | TZ11 | SSKZB | |||
JVERMST_AD | Net worth tax indicator | JVERMST | CHAR | 1 | JANEI | ||||
SUDEC_AD | Insurance Line of Business Indicator | SUDEC | NUMC | 2 | TW05 | SUDEC | |||
DEDEC_AD | Date of entry in premium reserve fund | DEDEC | DATS | 8 | DATUM | ||||
RFGEB_AD | Releaser of master record (person) | RFGEB_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
DFREI_AD | Date of release | DFREI | DATS | 8 | DATUM | ||||
TFREI_AD | Time of release | TFREI | TIMS | 6 | TIMES | ||||
RERF_AD | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF_AD | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF_AD | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER_AD | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR_AD | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR_AD | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR_AD | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER_AD | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
RPORTB_AD | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
SOBJEKT_AD | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
SROLEXTDEP_AD | Dummy function | DUMMY_3 | CHAR | 3 | CHAR3 | ||||
SROLEXTBEG_AD | Dummy function | DUMMY_3 | CHAR | 3 | CHAR3 | ||||
VVSLOEKZ_AD | Deletion indicator | VVSLOEKZ | NUMC | 1 | VVSLOEKZ | ||||
SSPERR_AD | Block type for restraint on disposal | SSPERR | CHAR | 3 | TW17 | SSPERR | |||
RAHABKI_AD | Short key for own house bank | TB_RHABKI | CHAR | 5 | T012 | HBKID | |||
RAHKTID_AD | Short key for house bank account | TB_RHKTID | CHAR | 5 | T012K | HKTID | |||
SEC_ACC_GRP_AD | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | TRGT_SECACCGRP | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
STATUS_AD | Status of a Security Account | TPM_SEC_ACC_STATUS | NUMC | 1 | TPM_SEC_ACC_STATUS | ||||
STATUS_RBEAR_AD | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
STATUS_DBEAR_AD | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
STATUS_TBEAR_AD | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
SECACC_TYPE_AD | Securities Account Type | TPM_SECACC_TYPE | CHAR | 3 | TRSC_SECACC_TYPE | TPM_SECACC_TYPE | |||
EXT_SEC_ACC_NO_AD | External Securities Account ID | TPM_RECON_SWIFT_SEC_ACC_NO | CHAR | 35 | TPM_RECON_SWIFT_SEC_ACC_NO | ||||
FLG_NO_TAX_MAP_AD | Refifotage: No Mapping toTax Security Account | TPM_FLG_NO_TAX_MAPPING | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
BUDAT_AD | ISSR_BUDAT | DATS | 8 | DATUM | |||||
COUNTRY_VAR_AD | ISSR_REP_COUNTRY | CHAR | 4 | TISSR_MARECO | ISSR_REP_COUNTRY | REP_COUNTRY | |||
SPARTE_AD | Insurance Line of Business Indicator | ISSR_VERS_SPARTE | CHAR | 2 | TISSR_SPARTE | ISSR_VERS_SPARTE | |||
STOCKBAV_AD | BAV Stock Indicator | ISSR_STOCKBAV | CHAR | 1 | TISSR_STOCKBAV | ISSR_STOCKBAV | |||
ADDRNUMBER_AD | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ANRED_AD | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1_AD | Name 1 of an address | NAME1_ADRS | CHAR | 40 | TEXT40 | ||||
NAME2_AD | Name 2 of an address | NAME2_ADRS | CHAR | 40 | TEXT40 | ||||
NAME3_AD | Name 3 of an address | NAME3_ADRS | CHAR | 40 | TEXT40 | ||||
NAME4_AD | Name 4 of an address | NAME4_ADRS | CHAR | 40 | TEXT40 | ||||
STRAS_AD | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH_AD | PO box | PFACH_BAS | CHAR | 10 | PFACH | ||||
PSTL2_AD | PO Box postal code | PSTL2_BAS | CHAR | 10 | PSTLZ | ||||
PFORT_AD | PO Box city | PFORT_ADRS | CHAR | 40 | TEXT40 | ||||
LAND1_AD | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
PSTLZ_AD | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
ORT01_AD | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02_AD | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
REGIO_AD | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
SPRAS_AD | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
INLND_AD | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
ANZZL_AD | Number of lines in address | ANZEI | DEC | 2 | ANZEI | ||||
PRIOR_AD | Address lines priority | PRITY_ADRS | CHAR | 9 | CHAR9 | ||||
WAREN_AD | Delivery address ID | WAREN | CHAR | 1 | WAREN | ||||
.INCLU-_AL | 0 | ||||||||
MANDT_AL | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS_AL | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RLDEPO_AL | Securities Account | VRLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ||
VERKONTO_AL | No. of bank giro acct, security acct no. in US secur.accts | VERKONTO | CHAR | 15 | ABNKR | ||||
RDEPOTNR_AL | Securities account no. | ABNKR | CHAR | 15 | ABNKR | ||||
XLDEPO_AL | Securities account ID | XLDEPO | CHAR | 30 | XLDEPO | ||||
RERTRK_AL | Internal bank account | RERTRK | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
RDPBANK_AL | Depository Bank | RDEPOTBANK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
RBGUE_AL | Beneficiary | RBGUENST | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
SSPERRV_AL | 0 | ||||||||
DSPERR_AL | Block flag until | DSPERR | DATS | 8 | DATUM | ||||
RGSBER_AL | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SSKZB_AL | BAV stock indicator | SSKZB | NUMC | 1 | TZ11 | SSKZB | |||
JVERMST_AL | Net worth tax indicator | JVERMST | CHAR | 1 | JANEI | ||||
SUDEC_AL | Insurance Line of Business Indicator | SUDEC | NUMC | 2 | TW05 | SUDEC | |||
DEDEC_AL | Date of entry in premium reserve fund | DEDEC | DATS | 8 | DATUM | ||||
RFGEB_AL | Releaser of master record (person) | RFGEB_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
DFREI_AL | Date of release | DFREI | DATS | 8 | DATUM | ||||
TFREI_AL | Time of release | TFREI | TIMS | 6 | TIMES | ||||
RERF_AL | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF_AL | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF_AL | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER_AL | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR_AL | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR_AL | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR_AL | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER_AL | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
RPORTB_AL | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
SOBJEKT_AL | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
SROLEXTDEP_AL | Dummy function | DUMMY_3 | CHAR | 3 | CHAR3 | ||||
SROLEXTBEG_AL | Dummy function | DUMMY_3 | CHAR | 3 | CHAR3 | ||||
VVSLOEKZ_AL | Deletion indicator | VVSLOEKZ | NUMC | 1 | VVSLOEKZ | ||||
SSPERR_AL | Block type for restraint on disposal | SSPERR | CHAR | 3 | TW17 | SSPERR | |||
RAHABKI_AL | Short key for own house bank | TB_RHABKI | CHAR | 5 | T012 | HBKID | |||
RAHKTID_AL | Short key for house bank account | TB_RHKTID | CHAR | 5 | T012K | HKTID | |||
SEC_ACC_GRP_AL | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | TRGT_SECACCGRP | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
STATUS_AL | Status of a Security Account | TPM_SEC_ACC_STATUS | NUMC | 1 | TPM_SEC_ACC_STATUS | ||||
STATUS_RBEAR_AL | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
STATUS_DBEAR_AL | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
STATUS_TBEAR_AL | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
SECACC_TYPE_AL | Securities Account Type | TPM_SECACC_TYPE | CHAR | 3 | TRSC_SECACC_TYPE | TPM_SECACC_TYPE | |||
EXT_SEC_ACC_NO_AL | External Securities Account ID | TPM_RECON_SWIFT_SEC_ACC_NO | CHAR | 35 | TPM_RECON_SWIFT_SEC_ACC_NO | ||||
FLG_NO_TAX_MAP_AL | Refifotage: No Mapping toTax Security Account | TPM_FLG_NO_TAX_MAPPING | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
BUDAT_AL | ISSR_BUDAT | DATS | 8 | DATUM | |||||
COUNTRY_VAR_AL | ISSR_REP_COUNTRY | CHAR | 4 | TISSR_MARECO | ISSR_REP_COUNTRY | REP_COUNTRY | |||
SPARTE_AL | Insurance Line of Business Indicator | ISSR_VERS_SPARTE | CHAR | 2 | TISSR_SPARTE | ISSR_VERS_SPARTE | |||
STOCKBAV_AL | BAV Stock Indicator | ISSR_STOCKBAV | CHAR | 1 | TISSR_STOCKBAV | ISSR_STOCKBAV | |||
ADDRNUMBER_AL | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ANRED_AL | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1_AL | Name 1 of an address | NAME1_ADRS | CHAR | 40 | TEXT40 | ||||
NAME2_AL | Name 2 of an address | NAME2_ADRS | CHAR | 40 | TEXT40 | ||||
NAME3_AL | Name 3 of an address | NAME3_ADRS | CHAR | 40 | TEXT40 | ||||
NAME4_AL | Name 4 of an address | NAME4_ADRS | CHAR | 40 | TEXT40 | ||||
STRAS_AL | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH_AL | PO box | PFACH_BAS | CHAR | 10 | PFACH | ||||
PSTL2_AL | PO Box postal code | PSTL2_BAS | CHAR | 10 | PSTLZ | ||||
PFORT_AL | PO Box city | PFORT_ADRS | CHAR | 40 | TEXT40 | ||||
LAND1_AL | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
PSTLZ_AL | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
ORT01_AL | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02_AL | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
REGIO_AL | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
SPRAS_AL | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
INLND_AL | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
ANZZL_AL | Number of lines in address | ANZEI | DEC | 2 | ANZEI | ||||
PRIOR_AL | Address lines priority | PRITY_ADRS | CHAR | 9 | CHAR9 | ||||
WAREN_AL | Delivery address ID | WAREN | CHAR | 1 | WAREN | ||||
XREPKE | Name and address of issuer | TB_XISSUER | CHAR | 80 | TEXT80 | ||||
REPKE_ADDRNO | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
XRANLALT1_L | ATAB tables long name | XLANGBEZ | CHAR | 60 | XLBEZ | ||||
XRANLALT1_S | Short name for ATAB tables | XKURZBEZ | CHAR | 15 | XKBEZ | ||||
XRANLALT2_L | ATAB tables long name | XLANGBEZ | CHAR | 60 | XLBEZ | ||||
XRANLALT2_S | Short name for ATAB tables | XKURZBEZ | CHAR | 15 | XKBEZ | ||||
SKUEND | Unit of Period of Notice | TB_SKUEND | NUMC | 1 | T_SKUEND | ||||
XSKUEND | Short Description of Repository Objects | AS4TEXT | CHAR | 60 | AS4TEXT | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
XZBMETH | Description of interest calculation method | TM_XZINSBM | CHAR | 60 | TEXT60 | ||||
SRHYTHM | Frequency Indicator | TB_SRHYTHM | NUMC | 1 | T_SRHYTHM | ||||
XRHYTHM | Frequency indicator: description | TM_XRHYTHM | CHAR | 60 | TEXT60 | ||||
PZINS | Interest Rate | TB_PZINS | DEC | 10(7) | DECV3_7 | ||||
BKOND | Condition item currency amount | BKOND | CURR | 13(2) | WERTV7 | ||||
SWHRKOND | Currency of Condition Item | SWHRKOND | CUKY | 5 | Assigned to domain | WAERS | |||
SFHAZBA | Flow Type | TB_SFHAZBA | CHAR | 4 | Assigned to domain | SBEWART | |||
XBEWART | Name of flow type | XBEWART | CHAR | 30 | TEXT30 | ||||
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
BNWHR | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
WPRICE | Price currency | TB_WPRICE | CUKY | 5 | Assigned to domain | WAERS | |||
BUPRC | Security Price Without Currency Ref. with Unit Quotation | TB_BUPRC | DEC | 15(6) | VVPKTKUR | ||||
BPPRC | Security Price for Percentage Quotation | TB_BPPRC | DEC | 15(6) | VVPKTKUR | ||||
BZBETR | Payment amount in payment currency | TB_BZBETR | CURR | 13(2) | WERTV7 | ||||
WZBETR | Payment Currency | TB_WZBETR | CUKY | 5 | Assigned to domain | WAERS | |||
WHWBETR | Local currency | TB_WHWBETR | CUKY | 5 | Assigned to domain | WAERS | |||
SZNSPRO | Interest Handling with Rollover | TB_SZNSPRO | NUMC | 1 | T_SZNSPRO | ||||
DZNSSTD | Payment date for deferred interest | TB_DZNSSTD | DATS | 8 | DATUM | ||||
SDISP_SL | Data Output for a Securities Loan | TB_SDISP_SL | CHAR | 1 | BOOLE | ||||
KZWKURS | Payment currency rate | TB_KZWKURS | DEC | 9(5) | EXCRT | UKURS |
Key field | Non-key field |
How do I retrieve data from SAP structure TBCO_SL using ABAP code?
As TBCO_SL 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_SL as there is no data to select.How to access SAP table TBCO_SL
Within an ECC or HANA version of SAP you can also view further information about TBCO_SL 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