TRST_CLASPOS

Transparent Table Application Table
39 Fields 3 CDS Views

Treasury: Class position in Securities Account

TRST_CLASPOS is an SAP database table in S/4HANA. Treasury: Class position in Securities Account. It contains 39 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_SecuritiesAcctClPosMstrData view_entity from BASIC Class Position in Securities Account
I_TrsyScrtyClScrtyAccountPos view from BASIC Trsy Scrty Class Scrty Account Pos
P_SecurityFinancialObject view from COMPOSITE

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY os_guid TPM_SEC_CLASPOS ClassPosSecAcct
company_code BUKRS Company Code
security_account VRLDEPO Securities Acct
security_id VVRANLW Security Class
portfolio RPORTB Portfolio
grnt_num GM_GRANT_NBR Grant
fund FM_FUND Fund
com_val_class TPM_COM_VAL_CLASS Gen. Valn Class
pos_cat TPM_TRS_POS_CAT Posit. Cat.
objnr J_OBJNR Object number
smoverw TB_SVERWA Custody Type
dandpfl DANDPFL Oblig. to offer
dandre DANDRE Right to Offer
sfibg SFIBG Asset Grouping
sbesant SBESANT Holding
jspri JSPRI Intercor.Privil
jbeteil JBETEIL Shareholding
sglzb SGLZB SCB Asset Group
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
flg_update_data TPM_TRS_FLG_UPDATE_DATA Chg SecA PI
flg_master_data_changed TPM_TRS_FLG_MASTER_DATA_CHANGE Master Data Changed
flow_group_id TPM_FLOW_GROUP_ID Flow Group ID
wbs_element PS_PSP_PNR WBS Element
cost_center KOSTL Cost Center
profit_center PRCTR Profit Center
functional_area FKBER Functional Area
custom_diff_term_1 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val.
custom_diff_term_2 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val.
custom_diff_term_3 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val.
custom_diff_term_4 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val.
custom_diff_term_5 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val.

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: Class position in Securities Account
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRST_CLASPOS (
    MANDT,                    -- Client [MANDT]
    OS_GUID,                  -- ClassPosSecAcct [TPM_SEC_CLASPOS]
    COMPANY_CODE,             -- Company Code [BUKRS]
    SECURITY_ACCOUNT,         -- Securities Acct [VRLDEPO]
    SECURITY_ID,              -- Security Class [VVRANLW]
    PORTFOLIO,                -- Portfolio [RPORTB]
    GRNT_NUM,                 -- Grant [GM_GRANT_NBR]
    FUND,                     -- Fund [FM_FUND]
    COM_VAL_CLASS,            -- Gen. Valn Class [TPM_COM_VAL_CLASS]
    POS_CAT,                  -- Posit. Cat. [TPM_TRS_POS_CAT]
    OBJNR,                    -- Object number [J_OBJNR]
    SMOVERW,                  -- Custody Type [TB_SVERWA]
    DANDPFL,                  -- Oblig. to offer [DANDPFL]
    DANDRE,                   -- Right to Offer [DANDRE]
    SFIBG,                    -- Asset Grouping [SFIBG]
    SBESANT,                  -- Holding [SBESANT]
    JSPRI,                    -- Intercor.Privil [JSPRI]
    JBETEIL,                  -- Shareholding [JBETEIL]
    SGLZB,                    -- SCB Asset Group [SGLZB]
    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]
    FLG_UPDATE_DATA,          -- Chg SecA PI [TPM_TRS_FLG_UPDATE_DATA]
    FLG_MASTER_DATA_CHANGED,  -- Master Data Changed [TPM_TRS_FLG_MASTER_DATA_CHANGE]
    FLOW_GROUP_ID,            -- Flow Group ID [TPM_FLOW_GROUP_ID]
    WBS_ELEMENT,              -- WBS Element [PS_PSP_PNR]
    COST_CENTER,              -- Cost Center [KOSTL]
    PROFIT_CENTER,            -- Profit Center [PRCTR]
    FUNCTIONAL_AREA,          -- Functional Area [FKBER]
    CUSTOM_DIFF_TERM_1,       -- Cust.Diff.Term Val. [TPM_CUST_DIFF_TERM_VALUE]
    CUSTOM_DIFF_TERM_2,       -- Cust.Diff.Term Val. [TPM_CUST_DIFF_TERM_VALUE]
    CUSTOM_DIFF_TERM_3,       -- Cust.Diff.Term Val. [TPM_CUST_DIFF_TERM_VALUE]
    CUSTOM_DIFF_TERM_4,       -- Cust.Diff.Term Val. [TPM_CUST_DIFF_TERM_VALUE]
    CUSTOM_DIFF_TERM_5,       -- Cust.Diff.Term Val. [TPM_CUST_DIFF_TERM_VALUE]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More