SAP table TWD01 (Treasury: Securities Account Master Data)

SAP table TWD01 has 3 primary key fields being MANDT,BUKRS,RLDEPO.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
RLDEPO Securities Account CHAR 10 0 VRLDEPO
VERKONTO Clearing Account CHAR 15 0 VERKONTO
RDEPOTNR Securities account no. CHAR 15 0 ABNKR
XLDEPO Securities Account ID CHAR 30 0 XLDEPO
RERTRK Internal bank account CHAR 10 0 SKB1 RERTRK
RDPBANK Depository Bank CHAR 10 0 * RDEPOTBANK
RBGUE Beneficiary CHAR 10 0 * RBGUENST
SSPERRV CHAR 2 0
DSPERR Block flag until DATS 8 0 DSPERR
RGSBER Business Area CHAR 4 0 TGSB GSBER
SSKZB BAV stock indicator NUMC 1 0 TZ11 SSKZB
JVERMST Net worth tax indicator CHAR 1 0 JVERMST
SUDEC Insurance Line of Business Indicator NUMC 2 0 TW05 SUDEC
DEDEC Date of entry in premium reserve fund DATS 8 0 DEDEC
RFGEB Releaser of master record (person) CHAR 10 0 * RFGEB_NEW
DFREI Date of release DATS 8 0 DFREI
TFREI Time of release TIMS 6 0 TFREI
RERF Entered By CHAR 12 0 RERF
DERF First Entered On DATS 8 0 DERF
TERF Time of Creation TIMS 6 0 TERF
REHER Source of Initial Entry CHAR 10 0 REHER
RBEAR Employee ID CHAR 12 0 RBEAR
DBEAR Last Edited On DATS 8 0 DBEAR
TBEAR Last Edited At TIMS 6 0 TBEAR
RBHER Editing Source CHAR 10 0 RBHER
RPORTB Portfolio CHAR 10 0 TWPOB RPORTB
SOBJEKT Internal key for object CHAR 10 0 VVKEYOBJ
SROLEXTDEP Dummy function CHAR 3 0 DUMMY_3
SROLEXTBEG Dummy function CHAR 3 0 DUMMY_3
VVSLOEKZ Deletion indicator NUMC 1 0 VVSLOEKZ
0 Active
1 Deletion flag
SSPERR Block type for restraint on disposal CHAR 3 0 TW17 SSPERR
RAHABKI Short Key for Own House Bank CHAR 5 0 T012 TB_RHABKI
RAHKTID Short Key for House Bank Account CHAR 5 0 T012K TB_RHKTID
SEC_ACC_GRP Securities Account Group CHAR 10 0 TRGT_SECACCGRP TPM_SEC_ACCT_GRP
STATUS Status of a Security Account NUMC 1 0 TPM_SEC_ACC_STATUS
0 Active
1 Closed
STATUS_RBEAR Employee ID CHAR 12 0 RBEAR
STATUS_DBEAR Last Edited On DATS 8 0 DBEAR
STATUS_TBEAR Last Edited At TIMS 6 0 TBEAR
SECACC_TYPE Securities Account Type CHAR 3 0 TRSC_SECACC_TYPE TPM_SECACC_TYPE
EXT_SEC_ACC_NO External Securities Account ID CHAR 35 0 TPM_RECON_SWIFT_SEC_ACC_NO
FLG_NO_TAX_MAP FIFO Reevaluation: No Mapping to Tax Security Account CHAR 1 0 TPM_FLG_NO_TAX_MAPPING
BUDAT Effective From Date for Statutory Reporting - Master DATS 8 0 ISSR_BUDAT
COUNTRY_VAR Statutory Reporting Variant CHAR 4 0 TISSR_MARECO ISSR_REP_COUNTRY
SPARTE Insurance Line of Business Indicator CHAR 2 0 TISSR_SPARTE ISSR_VERS_SPARTE
STOCKBAV Asset Indicator CHAR 1 0 TISSR_STOCKBAV ISSR_STOCKBAV

TWD01 foreign key relationships

Table Field Check Table Check Field
0 TWD01 BUKRS T001 Company Codes BUKRS
1 TWD01 COUNTRY_VAR TISSR_MARECO ISSR: Definition of Statutory Reporting Variant MANDT
0 TWD01 RAHABKI T012 House Banks BUKRS
1 TWD01 RAHKTID T012K House Bank Accounts MANDT
1 TWD01 RAHKTID T012K House Bank Accounts BUKRS
1 TWD01 RAHKTID T012K House Bank Accounts HBKID
1 TWD01 RAHKTID T012K House Bank Accounts HKTID
0 TWD01 RERTRK SKB1 G/L account master (company code) MANDT
0 TWD01 RERTRK SKB1 G/L account master (company code) BUKRS
1 TWD01 RGSBER TGSB Business Areas MANDT
1 TWD01 RGSBER TGSB Business Areas GSBER
0 TWD01 RPORTB TWPOB Portfolio position MANDT
0 TWD01 RPORTB TWPOB Portfolio position BUKRS
0 TWD01 RPORTB TWPOB Portfolio position RPORTB
1 TWD01 SECACC_TYPE TRSC_SECACC_TYPE Securities Account Type MANDT
0 TWD01 SEC_ACC_GRP TRGT_SECACCGRP Securities Account Groups (Definition) MANDT
0 TWD01 SEC_ACC_GRP TRGT_SECACCGRP Securities Account Groups (Definition) SEC_ACCT_GRP
1 TWD01 SPARTE TISSR_SPARTE ISSR: Line of Insurance MANDT
1 TWD01 SPARTE TISSR_SPARTE ISSR: Line of Insurance SPARTE
0 TWD01 SSKZB TZ11 Stock indicator MANDT
1 TWD01 SSPERR TW17 Blocking flag MANDT
0 TWD01 STOCKBAV TISSR_STOCKBAV ISSR: Stock Indicator Definition BAV MANDT
1 TWD01 SUDEC TW05 Insurance branch MANDT
1 TWD01 SUDEC TW05 Insurance branch SUDEC