VZBEST SAP (Treasury general portfolio structure) Structure details
Description: Treasury general portfolio structure
Structure field list including key, data, relationships and ABAP select examples
VZBEST 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 "Treasury general portfolio 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_VZBEST TYPE VZBEST.
The VZBEST table consists of various fields, each holding specific information or linking keys about Treasury general portfolio structure data available in SAP. These include RANTYP (Contract Type), BUKRS (Company Code), RKEY1 (Key part 1), RKEY2 (Key part 2).. 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 VZBEST 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 | T000 | MANDT | |||
RANTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RKEY1 | Key part 1 | VVRKEY13 | CHAR | 13 | CHAR13 | ||||
RKEY2 | Key part 2 | VVRKEY10 | CHAR | 10 | CHAR10 | ||||
SRECTYPE | Record Type | VVSRECTYPE | CHAR | 2 | VVSRECTYPE | ||||
RANL | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
RLDEPO | Securities Account | RLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ACC_CCD_CORE | |
RPORTB | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
SANLF | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
SGSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | TW11 | SBILK | |||
SGLZB | SCB asset group indicator | SGLZB | CHAR | 4 | TW07 | SGLZB | |||
RKLAMMER | Classification Number for Finance Projects | RKLAMMER | CHAR | 13 | ALPHA | RANL | |||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
STILGART | Repayment Type Indicator | STILGART | NUMC | 1 | STILGART | ||||
PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10(7) | DEC3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
SZINSTYP | Interest type: fixed, variable, other | VVSZINSTYP | CHAR | 1 | VVSZINSTYP | ||||
PKOND | Interest rate as a percentage | TB_PKOND | DEC | 10(7) | DECV3_7 | ||||
BKOND | Interest rate as amount | TB_BKOND | CURR | 13(2) | WERTV7 | ||||
SWHRKOND | Interest Currency | TB_WHRKOND | CUKY | 5 | TCURC | WAERS | |||
SZSREF | Reference Interest Rate | SZSREF | CHAR | 10 | T056R | ZIREFKU | |||
SNOTTYPE | Quotation type for option, future, security etc. | TB_NOTTYPE | CHAR | 1 | T_NOTTYPE | ||||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
SWERTTYP | Security Type ID | SWERTTYP | NUMC | 1 | Assigned to domain | SAKTTYP | |||
REWHR | Issue currency | REWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | AT10 | T_SFHAART | T02 | C_AT10 | |
SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 3 | AT01 | T_SFGTYP | |||
RREFKONT | Acct Assignment Ref. for Operative Valn Area and Loan | TB_REFKONT | CHAR | 8 | T037S | USTRU | |||
SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | NUMC | 2 | AT02 | T_SFGZUTY | C_AT02 | ||
SSTATI | Status of data record | SSTATI | NUMC | 2 | TZC37 | STATI | |||
SOPTAUS | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
SABRMET | Settlement Method for Option, Warrant, and Future | TB_ABRMET | CHAR | 1 | T_SABRMET | ||||
SETTLFL | Settlement indicator | TI_SETTLFL | CHAR | 1 | T_SETTLFL | ||||
OSTRIKE | Strike amount of option, warrant | TB_OSTRIKE | CURR | 13(2) | WERTV7 | ||||
OFWAERS | Strike currency of option, warrant, future | TB_OFWAERS | CUKY | 5 | TCURC | WAERS | |||
URANTYP | Underlying contract type | TI_URANTYP | CHAR | 1 | RANTYP | ||||
USANLF | Underlying product category | TB_USANLF | NUMC | 3 | TZAF | VVSANLF | |||
USFGZUTYP | Underlying activity category | TB_USFGZUT | NUMC | 2 | AT02 | T_SFGZUTY | |||
USGSART | Product type of underlying | TB_USGSART | CHAR | 3 | TZPA | VVSART | |||
USFHAART | Transaction Type of Underlying | TB_USFHAAR | CHAR | 3 | AT10 | T_SFHAART | |||
URGATT | Underlying ID for option/warrant/future | TB_URGATT | CHAR | 13 | VTIUL | ALPHA | T_URGATT | ||
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
BNOMINAL | Nominal amount in position currency | BNOMINAL | CURR | 15(2) | WERTV8_TR | ||||
SBWHR | Position Currency/Transaction Currency | TB_BWHR | CUKY | 5 | TCURC | WAERS | |||
SHWHR | Local currency | VVSHWHR | CUKY | 5 | TCURC | WAERS | |||
BKAUFWR | Acquisition value in position currency | BKAUFWR | CURR | 15(2) | WERTV8_TR | ||||
BKAUFHW | Acquisition value in local currency | BKAUFHW | CURR | 15(2) | WERTV8_TR | ||||
BBUCHWR | Book value in position currency | BBUCHWR | CURR | 15(2) | WERTV8_TR | ||||
BBUCHHW | Book value in local currency | BBUCHHW | CURR | 15(2) | WERTV8_TR | ||||
BKOSTWR | Capitalized incid.costs acquisition value in pos. currency | BKOSTWR | CURR | 15(2) | WERTV8_TR | ||||
BKOSTHW | Capitalized incid.costs acquisition value in local currency | BKOSTHW | CURR | 15(2) | WERTV8_TR | ||||
BKSTBWR | Book value of capitalized incid. costs in position currency | VVBKSTBWR | CURR | 15(2) | WERTV8_TR | ||||
BKSTBHW | Book value of activated incid. costs in local currency | VVBKSTBHW | CURR | 15(2) | WERTV8_TR | ||||
BNOMS | Nominal value | BNOMS | CURR | 13(2) | BWHR | ||||
BKURSWEFW | Market value of position in position currency | TB_BKURSWR | CURR | 15(2) | WERTV8_TR | ||||
BKURSWEHW | Market value of position in local currency | TB_BKURSHW | CURR | 15(2) | WERTV8_TR | ||||
WGSCHFT | Currency of transaction | TB_WGSCHFT | CUKY | 5 | Assigned to domain | WAERS | |||
WGSCHFT1 | Currency of Outgoing Side | TB_WGSCHF1 | CUKY | 5 | Assigned to domain | WAERS | |||
WGSCHFT2 | Currency of Incoming Side | TB_WGSCHF2 | CUKY | 5 | Assigned to domain | WAERS | |||
KKURS | Rate of Forex Transaction | TB_KKURS | DEC | 13(9) | TB_KKURS | ||||
RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | Assigned to domain | VVRHANDPL | WHP | ||
RANLVD | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
BVKWR | Contract Capital in Position Currency | VVBVKWR | CURR | 15(2) | WERTV8_TR | ||||
BVKHW | Contract capital in local currency | VVBVKHW | CURR | 15(2) | WERTV8_TR | ||||
BZKWR | Current Commitment Capital in Position Currency | VVBZKWR | CURR | 15(2) | WERTV8_TR | ||||
BZKHW | Commitment capital in local currency | VVBZKHW | CURR | 15(2) | WERTV8_TR | ||||
BRPWR | Rem. Capital Acc. to Debit Position in Position Currency | VVBRPWR | CURR | 15(2) | WERTV8_TR | ||||
BRPHW | Remaining Capital Acc. to Debit Position in Local Currency | VVBRPHW | CURR | 15(2) | WERTV8_TR | ||||
BRIWR | Effective Capital in Position Currency | VVBRIWR | CURR | 15(2) | WERTV8_TR | ||||
BRIHW | Effective Capital in Local Currency | VVBRIHW | CURR | 15(2) | WERTV8_TR | ||||
BRVWR | Available Capital in Position Currency | VVBRVWR | CURR | 15(2) | WERTV8_TR | ||||
BRVHW | Available Capital in Local Currency | VVBRVHW | CURR | 15(2) | WERTV8_TR | ||||
BMIWR | Capital Reduction in Position Currency | VVBMIWR | CURR | 15(2) | WERTV8_TR | ||||
BMIHW | Reductions in local currency | VVBMIHW | CURR | 15(2) | WERTV8_TR | ||||
BATWR | Unsched. Repayment: Debit Position in Position Currency | VVBATSWR | CURR | 15(2) | WERTV8_TR | ||||
BATHW | Unscheduled Repayment: Debit Position in Local Currency | VVBATSHW | CURR | 15(2) | WERTV8_TR | ||||
BATZWR | Unsched. Repayment: Incoming Payments in Position Currency | VVBATZWR | CURR | 15(2) | WERTV8_TR | ||||
BATZHW | Unscheduled Repayment: Incoming Payments in Local Currency | VVBATZHW | CURR | 15(2) | WERTV8_TR | ||||
BPTWR | Scheduled Repayment: Debit Position in Position Currency | VVBPTSWR | CURR | 15(2) | WERTV8_TR | ||||
BPTHW | Scheduled Repayment: Debit Position in Local Currency | VVBPTSHW | CURR | 15(2) | WERTV8_TR | ||||
BPTZWR | Scheduled Repayment: Incoming Payment in Position Currency | VVBPTZWR | CURR | 15(2) | WERTV8_TR | ||||
BPTZHW | Scheduled Repayment: Incoming Payment in Local Currency | VVBPTZHW | CURR | 15(2) | WERTV8_TR | ||||
BAVWR | Disbursement Obligation in Position Currency | VVBAVWR | CURR | 15(2) | WERTV8_TR | ||||
BAVHW | Disbursement Obligation in Local Currency | VVBAVHW | CURR | 15(2) | WERTV8_TR | ||||
BVAWR | Value-Dated Capital in Position Currency | VVBVAWR | CURR | 15(2) | WERTV8_TR | ||||
BVAHW | Value-Dated Capital in Local Currency | VVBVAHW | CURR | 15(2) | WERTV8_TR | ||||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
SKLASS | Classification | VVKLASS | NUMC | 3 | Assigned to domain | SWPKLASS | |||
KBKOND | Interest amount | TB_KBKOND | DEC | 15(6) | VVKWKURS | ||||
BNOMI1 | Nominal amount of outgoing side | TB_BNOMI1 | CURR | 15(2) | WERTV8_TR | ||||
BNOMI2 | Nominal amount of incoming side | TB_BNOMI2 | CURR | 15(2) | WERTV8_TR | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
PARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
SROLEXT | Dummy function | DUMMY_3 | CHAR | 3 | CHAR3 | ||||
SRECHTSF | Indicator for legal form | SRECHTSF | NUMC | 2 | Assigned to domain | SBETTYP | |||
SRECHTST | Indicator for legal entity | SRECHTST | NUMC | 2 | Assigned to domain | SRECHTST | |||
SRATING | Rating indicator | SRATING | CHAR | 3 | Assigned to domain | SRATING | |||
BRSCH | Industry sector | BU_INDSECT | CHAR | 10 | Assigned to domain | BU_INDSECT | H_TB023 | ||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
RKONTRA | Reference to Counterparty | RKONTRA_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
XKONTRA | Text field for contracting party | XKONTRA | CHAR | 10 | CHAR10 | ||||
XDPBANK | Depositary bank search term in partner management | RDBANK | CHAR | 10 | CHAR10 | ||||
DEFSZ | Date of fixed period end | VVDEFSZ | DATS | 8 | DATUM | ||||
RDEPOTNR | Securities account no. | ABNKR | CHAR | 15 | ABNKR | ||||
RDPBANK | Depository Bank | RDEPOTBANK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | ||
RGSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
DKEMI | Issuer call date | DKEMI | DATS | 8 | DATUM | ||||
VERKONTO | No. of bank giro acct, security acct no. in US secur.accts | VERKONTO | CHAR | 15 | ABNKR | ||||
BSALDO | Remaining Balance of a Contract (Account) | BSALDO | CURR | 13(2) | WERTV7 | ||||
SOFTYP | Options/futures category | TI_SOFTYP | NUMC | 2 | T_SOFTYP | ||||
RDEALER | Trader | RDEALER | CHAR | 12 | Assigned to domain | RDEALER | |||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
CTY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
CTY_QUANTITY | Quantity | FTR_QUAN | QUAN | 13(3) | FTR_QUAN | ||||
CTY_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FORWARD_DATE | Forward Date | FTR_FWDDATE | DATS | 8 | DATS |
Key field | Non-key field |
How do I retrieve data from SAP structure VZBEST using ABAP code?
As VZBEST 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 VZBEST as there is no data to select.How to access SAP table VZBEST
Within an ECC or HANA version of SAP you can also view further information about VZBEST 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