VWPANLE
Interest-bearing securities
VWPANLE is an SAP database table in S/4HANA. Interest-bearing securities. It contains 40 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SecurityClassBond | view | from | BASIC | Security Class Bond |
Fields (40)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | ranl | wp_ranl | ID number | |||
| sanlf | sanlf | Prod. Category | ||||
| swpklass | swpklass | Classification | ||||
| debeg | debeg | Issue Start | ||||
| dendf | dendf | Final Due Date | ||||
| bemibet | bemibet | Issue Vol. | ||||
| bnoms | bnoms | Nominal Value | ||||
| bnhae | bnhae | Nom. trad. unit | ||||
| rnwhr | rnwhr | Nominal curr. | ||||
| dkemi | dkemi | Issuer call | ||||
| dkobl | dkobl | Bondhold.call | ||||
| soptvert | soptvert | Opt. allocation | ||||
| batrt | batrt | No. CuttingDays | ||||
| scuex | scuex | Cum/ex | ||||
| bophe | bophe | No. of Warrants | ||||
| baufp | baufp | Premium | ||||
| rwauf | rwauf | Currency markup | ||||
| dwafb | dwafb | Conversion untl | ||||
| dwafv | dwafv | Conversion from | ||||
| bwavn | bwavn | Conv.Rat.Denom. | ||||
| bwavz | bwavz | Conv.Rat.Numer. | ||||
| jausl | jausl | Drawing | ||||
| dausl | dausl | Drawing date | ||||
| beivo | vvbeivo | Issue volumes | ||||
| anabt | vvanabt | Max.no.ass. | ||||
| bminabt | vvminabt | MinimumAssign. | ||||
| jverkbe | vvjverk | Sales restrict. | ||||
| bdebet | vvbdebe | Cover.amnt | ||||
| jweim | vvjweim | ResaleReserve | ||||
| jrueck | vvjrueck | Subj.return | ||||
| janzwe | vvjanzwe | Resale report | ||||
| jnachr | vvjnachr | Secondary loans | ||||
| set_name | rdpt_set_name | Redem.Sched. Set | ||||
| rounding_rule | tpm_rounding_rule | Rounding Rule | ||||
| pool_id | vvpoolid | Pool ID | ||||
| exp_mat_date | vvexpmatdate | Expected End of Term | ||||
| tranche_classif | vvtranchecl | Tranche Class. | ||||
| calc_begin | dbervon | CalculationFrom | ||||
| uqb_calc | uqb_calc | Calc.with Nom.per TU |
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.
-- Interest-bearing securities
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VWPANLE (
MANDT, -- Client [mandt]
RANL, -- ID number [wp_ranl]
SANLF, -- Prod. Category [sanlf]
SWPKLASS, -- Classification [swpklass]
DEBEG, -- Issue Start [debeg]
DENDF, -- Final Due Date [dendf]
BEMIBET, -- Issue Vol. [bemibet]
BNOMS, -- Nominal Value [bnoms]
BNHAE, -- Nom. trad. unit [bnhae]
RNWHR, -- Nominal curr. [rnwhr]
DKEMI, -- Issuer call [dkemi]
DKOBL, -- Bondhold.call [dkobl]
SOPTVERT, -- Opt. allocation [soptvert]
BATRT, -- No. CuttingDays [batrt]
SCUEX, -- Cum/ex [scuex]
BOPHE, -- No. of Warrants [bophe]
BAUFP, -- Premium [baufp]
RWAUF, -- Currency markup [rwauf]
DWAFB, -- Conversion untl [dwafb]
DWAFV, -- Conversion from [dwafv]
BWAVN, -- Conv.Rat.Denom. [bwavn]
BWAVZ, -- Conv.Rat.Numer. [bwavz]
JAUSL, -- Drawing [jausl]
DAUSL, -- Drawing date [dausl]
BEIVO, -- Issue volumes [vvbeivo]
ANABT, -- Max.no.ass. [vvanabt]
BMINABT, -- MinimumAssign. [vvminabt]
JVERKBE, -- Sales restrict. [vvjverk]
BDEBET, -- Cover.amnt [vvbdebe]
JWEIM, -- ResaleReserve [vvjweim]
JRUECK, -- Subj.return [vvjrueck]
JANZWE, -- Resale report [vvjanzwe]
JNACHR, -- Secondary loans [vvjnachr]
SET_NAME, -- Redem.Sched. Set [rdpt_set_name]
ROUNDING_RULE, -- Rounding Rule [tpm_rounding_rule]
POOL_ID, -- Pool ID [vvpoolid]
EXP_MAT_DATE, -- Expected End of Term [vvexpmatdate]
TRANCHE_CLASSIF, -- Tranche Class. [vvtranchecl]
CALC_BEGIN, -- CalculationFrom [dbervon]
UQB_CALC, -- Calc.with Nom.per TU [uqb_calc]
PRIMARY KEY (MANDT, RANL)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA