V_TZBZN SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




Table View field list including key, data, relationships and ABAP select examples

V_TZBZN is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The V_TZBZN table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include BUKRS (Company Code), JKGEWAB (Gains depreciation indicator), XBAVREG (BAV register number), RKURSBER (Rate calculation indicator).. 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: Not classified


SAP V_TZBZN table view 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
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
JKGEWABGains depreciation indicator JKGEWABCHAR1XFELD
XBAVREGBAV register number XBAVREGCHAR8CHAR8
RKURSBERRate calculation indicator RKURSBERCHAR2TCURBRKURSBERH_KURSBER
PANREAllowable price gain in percent VVPANREDEC10(7) DEC3_7
VVJBAVFlag: Regulatory reporting active VVJBAVCHAR1JANEI
VVJZBNKPCentral bank data maintenance indicator VVJZBNKPCHAR1KENZX
CALLTIndicator whether posting made directly with FBO1 or per BI CALLTCHAR1XFELD
SIDENTIdentification number assignment indicator VVSIDENTNUMC1VVSIDENT
SLEERVShort sales possible VVSLEERVCHAR1XFELD
LANDXCountry variant for regulatory reporting VVXLANDCHAR2VVXLAND
SSTANDINSTStanding instructions connection to counterparty bank acct SSTANDINSTCHAR1XFELD
BUTXTName of Company Code or Company BUTXTCHAR25TEXT25
ORT01City ORT01CHAR25TEXT25
KTOPLChart of Accounts KTOPLCHAR4T004KTOPLKPLC_KTOPL
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
XKURZBEZShort name for ATAB tables XKURZBEZCHAR15XKBEZ
KTPLTChart of accounts description KTPLTCHAR50TEXT50
KURST_SRate type (debit) KURST_SCHAR4TCURVKURST
KURST_HRate type (credit) KURST_HCHAR4TCURVKURST
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
XLANGBEZATAB tables long name XLANGBEZCHAR60XLBEZ
RSWIFTSWIFT/BIC for International Payments SWIFTCHAR11SWIFT
AKURSARTPrice type for evaluations VVKURSAUSWCHAR2TW56VVSKURSART
SKALIDFactory calendar SKALIDCHAR2TFACDWFCIDH_TFACD
IRA_PLAN_STRATPlanned Record Update Strategy TB_IRA_PLAN_STRATEGYCHAR2T_IRA_PLAN_STRATEGY
FX_DATEDate to determine the FX rate TPM_FX_DATECHAR2TPM_FX_DATE
VVRATECONVUse of Exchange Rate Type in Financial Transactions TCR_RATECONVCHAR1XFELD
SPA_PLAN_STRATPlanned Record Update Strategy (Security Prices) TB_SPA_PLAN_STRATEGYCHAR2T_SPA_PLAN_STRATEGY
CPA_PLAN_STRATPlanned Record Update Strategy (Commodity Prices) TB_CPA_PLAN_STRATEGYCHAR2T_CPA_PLAN_STRATEGY
CPA_CURVE_T_OUTCommodity Curve Type - Outgoing TB_CPA_CURVE_TYPE_OUTNUMC3JBC_CCURVE_TYPETB_CTY_CURVE_TYPECTY_CURVE_TYPE
CPA_CURVE_T_INCommodity Curve Type - Incoming TB_CPA_CURVE_TYPE_INNUMC3JBC_CCURVE_TYPETB_CTY_CURVE_TYPECTY_CURVE_TYPE
CREDITOR_IDCreditor ID FTVV_CRED_IDCHAR8FTVVD_CRED_ID
KWG14_SENDERKWG ยง14 Sender FTVV_KWG14_SENDERCHAR1FLAG
KWG14_XML_SIGNBaFin Identifier for XML Reporting FTVV_KWG14_XML_SIGNCHAR5FTVVD_KWG14_XML_SIGN

Key field Non-key field



How do I retrieve data from SAP table V_TZBZN using ABAP code

The following ABAP code Example will allow you to do a basic selection on V_TZBZN to SELECT all data from the table
DATA: WA_V_TZBZN TYPE V_TZBZN.

SELECT SINGLE *
FROM V_TZBZN
INTO CORRESPONDING FIELDS OF WA_V_TZBZN
WHERE...

How to access SAP table V_TZBZN

Within an ECC or HANA version of SAP you can also view further information about V_TZBZN 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!