VZBEST SAP (Treasury general portfolio structure) Structure details

Dictionary Type: Structure
Description: Treasury general portfolio structure




ABAP Code to SELECT data from VZBEST
Related tables to VZBEST
Access table VZBEST




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
MANDTClient MANDTCLNT3T000MANDT
RANTYPContract Type RANTYPCHAR1RANTYP
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RKEY1Key part 1 VVRKEY13CHAR13CHAR13
RKEY2Key part 2 VVRKEY10CHAR10CHAR10
SRECTYPERecord Type VVSRECTYPECHAR2VVSRECTYPE
RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
RLDEPOSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
RPORTBPortfolio RPORTBCHAR10TWPOBRPORTBT50H_RPORTB_CORE
RFHAFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
SGSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
SBILKBalance Sheet Indicator SBILKCHAR2TW11SBILK
SGLZBSCB asset group indicator SGLZBCHAR4TW07SGLZB
RKLAMMERClassification Number for Finance Projects RKLAMMERCHAR13ALPHARANL
DBLFZStart of Term DBLFZDATS8DATUM
DELFZEnd of Term DELFZDATS8DATUM
STILGARTRepayment Type Indicator STILGARTNUMC1STILGART
PEFFZINSEffective Interest Rate PEFFZINSDEC10(7) DEC3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
SZINSTYPInterest type: fixed, variable, other VVSZINSTYPCHAR1VVSZINSTYP
PKONDInterest rate as a percentage TB_PKONDDEC10(7) DECV3_7
BKONDInterest rate as amount TB_BKONDCURR13(2) WERTV7
SWHRKONDInterest Currency TB_WHRKONDCUKY5TCURCWAERS
SZSREFReference Interest Rate SZSREFCHAR10T056RZIREFKU
SNOTTYPEQuotation type for option, future, security etc. TB_NOTTYPECHAR1T_NOTTYPE
XALKZShort name XALKZCHAR15XKBEZ
SWERTTYPSecurity Type ID SWERTTYPNUMC1Assigned to domainSAKTTYP
REWHRIssue currency REWHRCUKY5Assigned to domainWAERS
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3AT10T_SFHAARTT02C_AT10
SFGTYPTransaction Category TB_SFGTYPNUMC3AT01T_SFGTYP
RREFKONTAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8T037SUSTRU
SFGZUSTTTransaction Activity Category TB_SFGZUTYNUMC2AT02T_SFGZUTYC_AT02
SSTATIStatus of data record SSTATINUMC2TZC37STATI
SOPTAUSExercise Type (American or European) SOPTAUSNUMC1SOPTAUS
SABRMETSettlement Method for Option, Warrant, and Future TB_ABRMETCHAR1T_SABRMET
SETTLFLSettlement indicator TI_SETTLFLCHAR1T_SETTLFL
OSTRIKEStrike amount of option, warrant TB_OSTRIKECURR13(2) WERTV7
OFWAERSStrike currency of option, warrant, future TB_OFWAERSCUKY5TCURCWAERS
URANTYPUnderlying contract type TI_URANTYPCHAR1RANTYP
USANLFUnderlying product category TB_USANLFNUMC3TZAFVVSANLF
USFGZUTYPUnderlying activity category TB_USFGZUTNUMC2AT02T_SFGZUTY
USGSARTProduct type of underlying TB_USGSARTCHAR3TZPAVVSART
USFHAARTTransaction Type of Underlying TB_USFHAARCHAR3AT10T_SFHAART
URGATTUnderlying ID for option/warrant/future TB_URGATTCHAR13VTIULALPHAT_URGATT
ASTUECKNumber of units for unit-quoted securities ASTUECKDEC15(5) ASTUECK
BNOMINALNominal amount in position currency BNOMINALCURR15(2) WERTV8_TR
SBWHRPosition Currency/Transaction Currency TB_BWHRCUKY5TCURCWAERS
SHWHRLocal currency VVSHWHRCUKY5TCURCWAERS
BKAUFWRAcquisition value in position currency BKAUFWRCURR15(2) WERTV8_TR
BKAUFHWAcquisition value in local currency BKAUFHWCURR15(2) WERTV8_TR
BBUCHWRBook value in position currency BBUCHWRCURR15(2) WERTV8_TR
BBUCHHWBook value in local currency BBUCHHWCURR15(2) WERTV8_TR
BKOSTWRCapitalized incid.costs acquisition value in pos. currency BKOSTWRCURR15(2) WERTV8_TR
BKOSTHWCapitalized incid.costs acquisition value in local currency BKOSTHWCURR15(2) WERTV8_TR
BKSTBWRBook value of capitalized incid. costs in position currency VVBKSTBWRCURR15(2) WERTV8_TR
BKSTBHWBook value of activated incid. costs in local currency VVBKSTBHWCURR15(2) WERTV8_TR
BNOMSNominal value BNOMSCURR13(2) BWHR
BKURSWEFWMarket value of position in position currency TB_BKURSWRCURR15(2) WERTV8_TR
BKURSWEHWMarket value of position in local currency TB_BKURSHWCURR15(2) WERTV8_TR
WGSCHFTCurrency of transaction TB_WGSCHFTCUKY5Assigned to domainWAERS
WGSCHFT1Currency of Outgoing Side TB_WGSCHF1CUKY5Assigned to domainWAERS
WGSCHFT2Currency of Incoming Side TB_WGSCHF2CUKY5Assigned to domainWAERS
KKURSRate of Forex Transaction TB_KKURSDEC13(9) TB_KKURS
RHANDPLExchange VVRHANDPLCHAR10Assigned to domainVVRHANDPLWHP
RANLVDContract Number RANLCHAR13ALPHARANLRAN
BVKWRContract Capital in Position Currency VVBVKWRCURR15(2) WERTV8_TR
BVKHWContract capital in local currency VVBVKHWCURR15(2) WERTV8_TR
BZKWRCurrent Commitment Capital in Position Currency VVBZKWRCURR15(2) WERTV8_TR
BZKHWCommitment capital in local currency VVBZKHWCURR15(2) WERTV8_TR
BRPWRRem. Capital Acc. to Debit Position in Position Currency VVBRPWRCURR15(2) WERTV8_TR
BRPHWRemaining Capital Acc. to Debit Position in Local Currency VVBRPHWCURR15(2) WERTV8_TR
BRIWREffective Capital in Position Currency VVBRIWRCURR15(2) WERTV8_TR
BRIHWEffective Capital in Local Currency VVBRIHWCURR15(2) WERTV8_TR
BRVWRAvailable Capital in Position Currency VVBRVWRCURR15(2) WERTV8_TR
BRVHWAvailable Capital in Local Currency VVBRVHWCURR15(2) WERTV8_TR
BMIWRCapital Reduction in Position Currency VVBMIWRCURR15(2) WERTV8_TR
BMIHWReductions in local currency VVBMIHWCURR15(2) WERTV8_TR
BATWRUnsched. Repayment: Debit Position in Position Currency VVBATSWRCURR15(2) WERTV8_TR
BATHWUnscheduled Repayment: Debit Position in Local Currency VVBATSHWCURR15(2) WERTV8_TR
BATZWRUnsched. Repayment: Incoming Payments in Position Currency VVBATZWRCURR15(2) WERTV8_TR
BATZHWUnscheduled Repayment: Incoming Payments in Local Currency VVBATZHWCURR15(2) WERTV8_TR
BPTWRScheduled Repayment: Debit Position in Position Currency VVBPTSWRCURR15(2) WERTV8_TR
BPTHWScheduled Repayment: Debit Position in Local Currency VVBPTSHWCURR15(2) WERTV8_TR
BPTZWRScheduled Repayment: Incoming Payment in Position Currency VVBPTZWRCURR15(2) WERTV8_TR
BPTZHWScheduled Repayment: Incoming Payment in Local Currency VVBPTZHWCURR15(2) WERTV8_TR
BAVWRDisbursement Obligation in Position Currency VVBAVWRCURR15(2) WERTV8_TR
BAVHWDisbursement Obligation in Local Currency VVBAVHWCURR15(2) WERTV8_TR
BVAWRValue-Dated Capital in Position Currency VVBVAWRCURR15(2) WERTV8_TR
BVAHWValue-Dated Capital in Local Currency VVBVAHWCURR15(2) WERTV8_TR
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
SKLASSClassification VVKLASSNUMC3Assigned to domainSWPKLASS
KBKONDInterest amount TB_KBKONDDEC15(6) VVKWKURS
BNOMI1Nominal amount of outgoing side TB_BNOMI1CURR15(2) WERTV8_TR
BNOMI2Nominal amount of incoming side TB_BNOMI2CURR15(2) WERTV8_TR
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
SORTLSort field SORTLCHAR10CHAR10
PARTNRBusiness Partner Number BP_PARTNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SROLEXTDummy function DUMMY_3CHAR3CHAR3
SRECHTSFIndicator for legal form SRECHTSFNUMC2Assigned to domainSBETTYP
SRECHTSTIndicator for legal entity SRECHTSTNUMC2Assigned to domainSRECHTST
SRATINGRating indicator SRATINGCHAR3Assigned to domainSRATING
BRSCHIndustry sector BU_INDSECTCHAR10Assigned to domainBU_INDSECTH_TB023
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
RKONTRAReference to Counterparty RKONTRA_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
XKONTRAText field for contracting party XKONTRACHAR10CHAR10
XDPBANKDepositary bank search term in partner management RDBANKCHAR10CHAR10
DEFSZDate of fixed period end VVDEFSZDATS8DATUM
RDEPOTNRSecurities account no. ABNKRCHAR15ABNKR
RDPBANKDepository Bank RDEPOTBANKCHAR10BUT000ALPHABU_PARTNER
RGSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
DKEMIIssuer call date DKEMIDATS8DATUM
VERKONTONo. of bank giro acct, security acct no. in US secur.accts VERKONTOCHAR15ABNKR
BSALDORemaining Balance of a Contract (Account) BSALDOCURR13(2) WERTV7
SOFTYPOptions/futures category TI_SOFTYPNUMC2T_SOFTYP
RDEALERTrader RDEALERCHAR12Assigned to domainRDEALER
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
CTY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
CTY_QUANTITYQuantity FTR_QUANQUAN13(3) FTR_QUAN
CTY_UOMUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
FORWARD_DATEForward Date FTR_FWDDATEDATS8DATS

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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!