SAP TWD01 Table in S/4 HANA - Treasury: Securities Account Master Data









TWD01 is a standard SAP Table which is used to store Treasury: Securities Account Master Data data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TWD01 table(ECC)

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: TWD01


TWD01 table structure field list

Below is the full TWD01 field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field


Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP SHLP Field
MANDTClientMANDTCLNT3(0) T000MANDT
BUKRSCompany CodeBUKRSCHAR4(0) T001BUKRSBUKC_T001BUKRS
RLDEPOSecurities AccountVRLDEPOCHAR10(0) RLDEPODEP
VERKONTOClearing AccountVERKONTOCHAR15(0) ABNKR
RDEPOTNRSecurities account no.ABNKRCHAR15(0) ABNKR
XLDEPOSecurities Account IDXLDEPOCHAR30(0) XLDEPO
RERTRKInternal bank accountRERTRKCHAR10(0) SKB1ALPHASAKNR
RDPBANKDepository BankRDEPOTBANKCHAR10(0) Assigned to domainALPHABU_PARTNER
RBGUEBeneficiaryRBGUENSTCHAR10(0) Assigned to domainALPHABU_PARTNERBPABUPAPARTNER
SSPERRVCHAR2(0)
DSPERRBlock flag untilDSPERRDATS8(0) DATUM
RGSBERBusiness AreaGSBERCHAR4(0) TGSBGSBERGSB
SSKZBBAV stock indicatorSSKZBNUMC1(0) TZ11SSKZB
JVERMSTNet worth tax indicatorJVERMSTCHAR1(0) JANEI
SUDECInsurance Line of Business IndicatorSUDECNUMC2(0) TW05SUDEC
DEDECDate of entry in premium reserve fundDEDECDATS8(0) DATUM
RFGEBReleaser of master record (person)RFGEB_NEWCHAR10(0) Assigned to domainALPHABU_PARTNERBPABUPAPARTNER
DFREIDate of releaseDFREIDATS8(0) DATUM
TFREITime of releaseTFREITIMS6(0) TIMES
RERFEntered ByRERFCHAR12(0) SYCHAR12
DERFFirst Entered OnDERFDATS8(0) DATUM
TERFTime of CreationTERFTIMS6(0) TIMES
REHERSource of Initial EntryREHERCHAR10(0) CHAR10
RBEAREmployee IDRBEARCHAR12(0) SYCHAR12
DBEARLast Edited OnDBEARDATS8(0) DATUM
TBEARLast Edited AtTBEARTIMS6(0) TIMES
RBHEREditing SourceRBHERCHAR10(0) CHAR10
RPORTBPortfolioRPORTBCHAR10(0) TWPOBRPORTBT50H_RPORTB_CORERPORTB
SOBJEKTInternal key for objectVVKEYOBJCHAR10(0) VVKEY
SROLEXTDEPDummy functionDUMMY_3CHAR3(0) CHAR3
SROLEXTBEGDummy functionDUMMY_3CHAR3(0) CHAR3
VVSLOEKZDeletion indicatorVVSLOEKZNUMC1(0) VVSLOEKZ
SSPERRBlock type for restraint on disposalSSPERRCHAR3(0) TW17SSPERR
RAHABKIShort Key for Own House BankTB_RHABKICHAR5(0) T012HBKID
RAHKTIDShort Key for House Bank AccountTB_RHKTIDCHAR5(0) T012KHKTID
SEC_ACC_GRPSecurities Account GroupTPM_SEC_ACCT_GRPCHAR10(0) TRGT_SECACCGRPTPM_SEC_ACCT_GRPTPM_SHPL_SEC_ACC_GRPSEC_ACCT_GRP
STATUSStatus of a Security AccountTPM_SEC_ACC_STATUSNUMC1(0) TPM_SEC_ACC_STATUS
STATUS_RBEAREmployee IDRBEARCHAR12(0) SYCHAR12
STATUS_DBEARLast Edited OnDBEARDATS8(0) DATUM
STATUS_TBEARLast Edited AtTBEARTIMS6(0) TIMES
SECACC_TYPESecurities Account TypeTPM_SECACC_TYPECHAR3(0) TRSC_SECACC_TYPETPM_SECACC_TYPE
EXT_SEC_ACC_NOExternal Securities Account IDTPM_RECON_SWIFT_SEC_ACC_NOCHAR35(0) TPM_RECON_SWIFT_SEC_ACC_NO
FLG_NO_TAX_MAPFIFO Reevaluation: No Mapping to Tax Security AccountTPM_FLG_NO_TAX_MAPPINGCHAR1(0) XFELD
.INCLU--AP0(0)
BUDATEffective From Date for Statutory Reporting - MasterISSR_BUDATDATS8(0) DATUM
COUNTRY_VARStatutory Reporting VariantISSR_REP_COUNTRYCHAR4(0) TISSR_MARECOISSR_REP_COUNTRYREP_COUNTRY
SPARTEInsurance Line of Business IndicatorISSR_VERS_SPARTECHAR2(0) TISSR_SPARTEISSR_VERS_SPARTE
STOCKBAVAsset IndicatorISSR_STOCKBAVCHAR1(0) TISSR_STOCKBAVISSR_STOCKBAV




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!