TZBZ

Transparent Table Customizing Table
35 Fields 1 CDS Views

Company code: Additional data

TZBZ is an SAP database table in S/4HANA. Company code: Additional data. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TreasuryCompanyCodeSetting view from BASIC Treasury Company Code Additional Data

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
jkonsoli jkonsoli dummy
jkgewab jkgewab Gains depreciat
xbavreg xbavreg BAV RegisterNo.
leitwaers leitwaers Leading curr.
vvrhandpl vvrhandpl Exchange
rkursber rkursber Rate Calculatn
rfgeb rfgeb_new Releaser
dfrei dfrei Release date
tfrei tfrei Time release
rerf rerf Entered By
derf derf First Enterd On
terf terf Time
reher reher Source.In.Entry
rbear rbear Last Changed By
dbear dbear Last Edited On
tbear tbear Last Edited At
rbher rbher Editing Source
vvddper vvddper Per.-end clos.
vvdwper vvdwper Per.-end clos.
rhandpl rhandpl Exchange
panre vvpanre Allow. price gain
vvjbav vvjbav Reg.rep.active
vvjzbnkp vvjzbnkp HdBnkDataMaint.
callt callt Batch input ind.
sident vvsident Ident.No.Indic.
sleerv vvsleerv Short Sales Possible
akursart vvkursausw Price Type for Eval.
xland vvxland C / R Variant
sstandinst sstandinst Stand. instr.
rswift swift SWIFT/BIC
skalid skalid Calendar
umsdatum datum Date
vvrateconv tcr_rateconv RateTypeUse:FinTrans

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Company code: Additional data
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TZBZ (
    MANDT,       -- Client [mandt]
    BUKRS,       -- Company Code [bukrs]
    JKONSOLI,    -- dummy [jkonsoli]
    JKGEWAB,     -- Gains depreciat [jkgewab]
    XBAVREG,     -- BAV RegisterNo. [xbavreg]
    LEITWAERS,   -- Leading curr. [leitwaers]
    VVRHANDPL,   -- Exchange [vvrhandpl]
    RKURSBER,    -- Rate Calculatn [rkursber]
    RFGEB,       -- Releaser [rfgeb_new]
    DFREI,       -- Release date [dfrei]
    TFREI,       -- Time release [tfrei]
    RERF,        -- Entered By [rerf]
    DERF,        -- First Enterd On [derf]
    TERF,        -- Time [terf]
    REHER,       -- Source.In.Entry [reher]
    RBEAR,       -- Last Changed By [rbear]
    DBEAR,       -- Last Edited On [dbear]
    TBEAR,       -- Last Edited At [tbear]
    RBHER,       -- Editing Source [rbher]
    VVDDPER,     -- Per.-end clos. [vvddper]
    VVDWPER,     -- Per.-end clos. [vvdwper]
    RHANDPL,     -- Exchange [rhandpl]
    PANRE,       -- Allow. price gain [vvpanre]
    VVJBAV,      -- Reg.rep.active [vvjbav]
    VVJZBNKP,    -- HdBnkDataMaint. [vvjzbnkp]
    CALLT,       -- Batch input ind. [callt]
    SIDENT,      -- Ident.No.Indic. [vvsident]
    SLEERV,      -- Short Sales Possible [vvsleerv]
    AKURSART,    -- Price Type for Eval. [vvkursausw]
    XLAND,       -- C / R Variant [vvxland]
    SSTANDINST,  -- Stand. instr. [sstandinst]
    RSWIFT,      -- SWIFT/BIC [swift]
    SKALID,      -- Calendar [skalid]
    UMSDATUM,    -- Date [datum]
    VVRATECONV,  -- RateTypeUse:FinTrans [tcr_rateconv]
    PRIMARY KEY (MANDT, BUKRS)
);

Learn More