TERTVWERKO

Transparent Table Application Table
33 Fields 1 CDS Views

Executable Rights (Header)

TERTVWERKO is an SAP database table in S/4HANA. Executable Rights (Header). It contains 33 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 (33)

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
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
price_index TIDX_INDEX_NAME Price Index Name
strike_in_points IDXSTAND Index Value
basicrate_long PBASKURS_LONG Basic Rate
price_long BBASPREI_LONG Exercise Price

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]
    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]
    PRICE_INDEX,       -- Price Index Name [TIDX_INDEX_NAME]
    STRIKE_IN_POINTS,  -- Index Value [IDXSTAND]
    BASICRATE_LONG,    -- Basic Rate [PBASKURS_LONG]
    PRICE_LONG,        -- Exercise Price [BBASPREI_LONG]
    PRIMARY KEY (MANDT, RIGHTNUMBER)
);

Learn More