SAP table SEC_ACC_DYNPRO (Screen Structure for Class Master Data (Securities))

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
XDPBANK Text (80 Characters) CHAR 80 0 TEXT80
XAHKTID Text CHAR 50 0 TEXT1
XBGUE Text (80 Characters) CHAR 80 0 TEXT80
XGSBER Business area description CHAR 30 0 GTEXT
XBUKRS Name of Company Code or Company CHAR 25 0 BUTXT
XPORTB Portfolio Name CHAR 30 0 VVXPORTB
NOTE_FLAG Memo book entry text available CHAR 30 0 TNOTIZ
SEC_ACC_GRP_TXT Name of Securities Account Group CHAR 60 0 TPM_SEC_ACCT_GRP_NAME
SECACC_TYPE_TXT Name of Securities Account Type CHAR 30 0 * TPM_SA_TYPE_TEXT
SECACC_CAT Securities Account Category CHAR 1 0 TPM_SECACC_CAT
1 Asset Securities Account
2 Liability Securities Account
3 Lending Securities Account

SEC_ACC_DYNPRO foreign key relationships

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