TERTVWERKO

Transparent Table Application Table
24 Fields 1 CDS Views

Executable Rights (Header)

TERTVWERKO is an SAP database table in S/4HANA. Executable Rights (Header). It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ExecutableRightHeader view_entity from BASIC Executable Right Header

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY rightnumber ter_rightnumber ER number
righttype ter_righttype Rights Category
isactiv ter_activ Active flag
startdate dlavo Term from
enddate dlabi Term to
postingstate ter_status Status
ranlunderlying ter_ranlunder Underlying ID
ranlex ter_ranlex ID no. warr. bond ex
settlement sverropt Settlement
exercisetype sopttyp Option Category
price bbasprei Exercise price
currency1 rwhrbas ExercPriceCrcy
securitiesindex idx Securities ind.
indexbase vvbasis Index base
referenceunit vvbbezein Reference unit
currency2 vvrbezein Ref. unit curr.
basicrate pbaskurs Basic rate
rationumerator bovza Optn Ratio Num.
ratiodenominator bovne Optn Ratio Den.
shorttext kurztext Description
price_index tidx_index_name Price Index Name
strike_in_points idxstand Index Value
basicrate_long pbaskurs_long Basic Rate

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.

-- Executable Rights (Header)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TERTVWERKO (
    MANDT,             -- Client [mandt]
    RIGHTNUMBER,       -- ER number [ter_rightnumber]
    RIGHTTYPE,         -- Rights Category [ter_righttype]
    ISACTIV,           -- Active flag [ter_activ]
    STARTDATE,         -- Term from [dlavo]
    ENDDATE,           -- Term to [dlabi]
    POSTINGSTATE,      -- Status [ter_status]
    RANLUNDERLYING,    -- Underlying ID [ter_ranlunder]
    RANLEX,            -- ID no. warr. bond ex [ter_ranlex]
    SETTLEMENT,        -- Settlement [sverropt]
    EXERCISETYPE,      -- Option Category [sopttyp]
    PRICE,             -- Exercise price [bbasprei]
    CURRENCY1,         -- ExercPriceCrcy [rwhrbas]
    SECURITIESINDEX,   -- Securities ind. [idx]
    INDEXBASE,         -- Index base [vvbasis]
    REFERENCEUNIT,     -- Reference unit [vvbbezein]
    CURRENCY2,         -- Ref. unit curr. [vvrbezein]
    BASICRATE,         -- Basic rate [pbaskurs]
    RATIONUMERATOR,    -- Optn Ratio Num. [bovza]
    RATIODENOMINATOR,  -- Optn Ratio Den. [bovne]
    SHORTTEXT,         -- Description [kurztext]
    PRICE_INDEX,       -- Price Index Name [tidx_index_name]
    STRIKE_IN_POINTS,  -- Index Value [idxstand]
    BASICRATE_LONG,    -- Basic Rate [pbaskurs_long]
    PRIMARY KEY (MANDT, RIGHTNUMBER)
);

Learn More