TWD01

Transparent Table Application Table
43 Fields 1 CDS Views

Treasury: Securities Account Master Data

TWD01 is an SAP database table in S/4HANA. Treasury: Securities Account Master Data. It contains 43 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SecurityAccount view from BASIC Security Account

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY rldepo vrldepo Securities Acct
verkonto verkonto Clrng Acct
rdepotnr abnkr Sec.acct number
xldepo xldepo Securities Acct ID
rertrk rertrk Internal acct
rdpbank rdepotbank Depository Bank
rbgue rbguenst Beneficiary
ssperrv abap.char
dsperr dsperr Blck flag until
rgsber gsber Business Area
sskzb sskzb Stock ID
jvermst jvermst Net worth tax
sudec sudec Insur. branch
dedec dedec PremResFEntry
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
rportb rportb Portfolio
sobjekt vvkeyobj Object key
srolextdep dummy_3 Dummy
srolextbeg dummy_3 Dummy
vvsloekz vvsloekz Deletion indic.
ssperr ssperr Type of block
rahabki tb_rhabki House Bank
rahktid tb_rhktid House Bank Acct
sec_acc_grp tpm_sec_acct_grp Sec.AcctGrp
status tpm_sec_acc_status Status
status_rbear rbear Last Changed By
status_dbear dbear Last Edited On
status_tbear tbear Last Edited At
secacc_type tpm_secacc_type Sec. Acct Type
ext_sec_acc_no tpm_recon_swift_sec_acc_no Ext.Sec.Acct ID
flg_no_tax_map tpm_flg_no_tax_mapping No MappingToTax

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.

-- Treasury: Securities Account Master Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TWD01 (
    MANDT,           -- Client [mandt]
    BUKRS,           -- Company Code [bukrs]
    RLDEPO,          -- Securities Acct [vrldepo]
    VERKONTO,        -- Clrng Acct [verkonto]
    RDEPOTNR,        -- Sec.acct number [abnkr]
    XLDEPO,          -- Securities Acct ID [xldepo]
    RERTRK,          -- Internal acct [rertrk]
    RDPBANK,         -- Depository Bank [rdepotbank]
    RBGUE,           -- Beneficiary [rbguenst]
    SSPERRV,         -- abap.char
    DSPERR,          -- Blck flag until [dsperr]
    RGSBER,          -- Business Area [gsber]
    SSKZB,           -- Stock ID [sskzb]
    JVERMST,         -- Net worth tax [jvermst]
    SUDEC,           -- Insur. branch [sudec]
    DEDEC,           -- PremResFEntry [dedec]
    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]
    RPORTB,          -- Portfolio [rportb]
    SOBJEKT,         -- Object key [vvkeyobj]
    SROLEXTDEP,      -- Dummy [dummy_3]
    SROLEXTBEG,      -- Dummy [dummy_3]
    VVSLOEKZ,        -- Deletion indic. [vvsloekz]
    SSPERR,          -- Type of block [ssperr]
    RAHABKI,         -- House Bank [tb_rhabki]
    RAHKTID,         -- House Bank Acct [tb_rhktid]
    SEC_ACC_GRP,     -- Sec.AcctGrp [tpm_sec_acct_grp]
    STATUS,          -- Status [tpm_sec_acc_status]
    STATUS_RBEAR,    -- Last Changed By [rbear]
    STATUS_DBEAR,    -- Last Edited On [dbear]
    STATUS_TBEAR,    -- Last Edited At [tbear]
    SECACC_TYPE,     -- Sec. Acct Type [tpm_secacc_type]
    EXT_SEC_ACC_NO,  -- Ext.Sec.Acct ID [tpm_recon_swift_sec_acc_no]
    FLG_NO_TAX_MAP,  -- No MappingToTax [tpm_flg_no_tax_mapping]
    PRIMARY KEY (MANDT, BUKRS, RLDEPO)
);

Learn More