VWPANLA

Transparent Table Application Table
55 Fields 4 CDS Views

Asset master for securities

VWPANLA is an SAP database table in S/4HANA. Asset master for securities. It contains 55 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CmmdtyOrderFutureIDVH view from BASIC Commodity Order Future ID
I_SecurityClass view from BASIC Security Class
P_DrvtvSecurityIDData view from BASIC
VFCP_DDL_TRM view left_outer

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ranl vvranlw Security Class
sanlf sanlf Prod. Category
sstati sec_status Status
ranlalt1 ranlalt1s Alternat. no. 1
ranlalt2 ranlalt2s Alternat. no. 2
gsart vvsart Product Type
sbrsch brsch Industry
swerttyp swerttyp Security Type
sboernot sboernot Listed
wlomb wlomb Elig. as coll.
jdeck jdeck Hedge fund
wpfan wpfan Pledgeable
sstbe sstbe Tax Treatment
loevm loevm Delete
jabmi jabmi Joint part.vote
xalkz xalkz Short Name
xallb xallb Long Name
repke repke_new Issuer
bempreis bempreis Issue Price
rewhr rewhr Issue Currency
pemkurs pemkurs Issue rate
snoti snoti Quotation
pkuab pkuab Price dev. in %
bkuab bkuab Price deviation
dandpfl dandpfl Oblig. to offer
dandre dandre Right to Offer
sobjekt vvkeyobj Object key
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
srolext alwpkl Sec. Classific.
vvsloekz vvsloekz Deletion indic.
jmuendel vvjmuend Eligible
smoverw smoverw Poss.cust.type
siherk char2 Component of the Version Number
kbempreis vvkbempr Issue Price
sdepostat vvdepostat Sec. acct stat.
sfundi vvsfundi Funded
swphgmpf vvswphgmpf Report. oblig.
risin vvrisin Intern.ID no.
institute bp_sol_ins Cred.Stndg Inst
rating bp_rating Rating
price_index tidx_index_name Price Index Name
price_idx_bdate tidx_index_base_date Price Idx Base Date
coicode coicode CI code
coiland coiland CI Country/Region
sfimamethod vvsfimamethod Cash Flow Calc
unit_tick vv_unit_tick Min.Num.Units
tax_classification tba_tax_classification Tax Classif.

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.

-- Asset master for securities
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VWPANLA (
    MANDT,               -- Client [mandt]
    RANL,                -- Security Class [vvranlw]
    SANLF,               -- Prod. Category [sanlf]
    SSTATI,              -- Status [sec_status]
    RANLALT1,            -- Alternat. no. 1 [ranlalt1s]
    RANLALT2,            -- Alternat. no. 2 [ranlalt2s]
    GSART,               -- Product Type [vvsart]
    SBRSCH,              -- Industry [brsch]
    SWERTTYP,            -- Security Type [swerttyp]
    SBOERNOT,            -- Listed [sboernot]
    WLOMB,               -- Elig. as coll. [wlomb]
    JDECK,               -- Hedge fund [jdeck]
    WPFAN,               -- Pledgeable [wpfan]
    SSTBE,               -- Tax Treatment [sstbe]
    LOEVM,               -- Delete [loevm]
    JABMI,               -- Joint part.vote [jabmi]
    XALKZ,               -- Short Name [xalkz]
    XALLB,               -- Long Name [xallb]
    REPKE,               -- Issuer [repke_new]
    BEMPREIS,            -- Issue Price [bempreis]
    REWHR,               -- Issue Currency [rewhr]
    PEMKURS,             -- Issue rate [pemkurs]
    SNOTI,               -- Quotation [snoti]
    PKUAB,               -- Price dev. in % [pkuab]
    BKUAB,               -- Price deviation [bkuab]
    DANDPFL,             -- Oblig. to offer [dandpfl]
    DANDRE,              -- Right to Offer [dandre]
    SOBJEKT,             -- Object key [vvkeyobj]
    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]
    SROLEXT,             -- Sec. Classific. [alwpkl]
    VVSLOEKZ,            -- Deletion indic. [vvsloekz]
    JMUENDEL,            -- Eligible [vvjmuend]
    SMOVERW,             -- Poss.cust.type [smoverw]
    SIHERK,              -- Component of the Version Number [char2]
    KBEMPREIS,           -- Issue Price [vvkbempr]
    SDEPOSTAT,           -- Sec. acct stat. [vvdepostat]
    SFUNDI,              -- Funded [vvsfundi]
    SWPHGMPF,            -- Report. oblig. [vvswphgmpf]
    RISIN,               -- Intern.ID no. [vvrisin]
    INSTITUTE,           -- Cred.Stndg Inst [bp_sol_ins]
    RATING,              -- Rating [bp_rating]
    PRICE_INDEX,         -- Price Index Name [tidx_index_name]
    PRICE_IDX_BDATE,     -- Price Idx Base Date [tidx_index_base_date]
    COICODE,             -- CI code [coicode]
    COILAND,             -- CI Country/Region [coiland]
    SFIMAMETHOD,         -- Cash Flow Calc [vvsfimamethod]
    UNIT_TICK,           -- Min.Num.Units [vv_unit_tick]
    TAX_CLASSIFICATION,  -- Tax Classif. [tba_tax_classification]
    PRIMARY KEY (MANDT, RANL)
);

Learn More