TE221

Transparent Table Customizing Table
41 Fields 2 CDS Views

Operanden

TE221 is an SAP database table in S/4HANA. Operanden. It contains 41 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CRMS4_IU_I_UOP view_entity inner Utilities Operand
I_UtilsOperand view from BASIC Utilities Billing Operand

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY operand e_operand Operand
sparte sparte Division
optyp e_optyp Operand cat.
mass e_mass Unit of meas.
orgwert orgwert Two values
tazuord tazuord RType required
rundung e_rundung Rounding
rundart rundart Rounding Cat.
leistall leistall All demand vals
leistmonat leistmonat Demand/month
bzgart bzgart Ref. value type
umzugkz umzugkz Move-In/Out
histsteu histsteu History
ablesgrup ablesgrup MR group
gewkey gewkey_pr Weighting key
selcontrol selcontrol Access Operand
peak_no peak_no No. of peaks
seasonflag seasonflag Season demand
fran_type fran_type Franch.fee cat.
reg_operand reg_operand Regist. operand
demand_as_is demand_as_is Demand unchg.
allhistory allhistory Complete hist.
use_udefval1 use_udefval1 Use value 1
use_udefval2 use_udefval2 Use value 2
use_udefval3 use_udefval3 Use value 3
use_udefval4 use_udefval4 Use value 4
opgroup opgroup Operand group
actfactind actfactind Demand active
nodialoginst nodialoginst Not instln
nodialogrcat nodialogrcat Not rate cat.
nodialograte nodialograte Not rate
conrel conrel Con.-rel. op.
rtpoperand rtpoperand RTP operand
prodrel prodrel ProdRel-Operand
wasterel wasterel Spec. Val. Prov
constype e_constype Consumptn Type
bwrel e_bwrel BW-Relevant
prorate_daily prorate_daily Daily Proratn
erchvrel e_erchvrel ERCHV Operand
condirel e_condirel Cond. Billing Oper.

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.

-- Operanden
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TE221 (
    MANDT,          -- Client [mandt]
    OPERAND,        -- Operand [e_operand]
    SPARTE,         -- Division [sparte]
    OPTYP,          -- Operand cat. [e_optyp]
    MASS,           -- Unit of meas. [e_mass]
    ORGWERT,        -- Two values [orgwert]
    TAZUORD,        -- RType required [tazuord]
    RUNDUNG,        -- Rounding [e_rundung]
    RUNDART,        -- Rounding Cat. [rundart]
    LEISTALL,       -- All demand vals [leistall]
    LEISTMONAT,     -- Demand/month [leistmonat]
    BZGART,         -- Ref. value type [bzgart]
    UMZUGKZ,        -- Move-In/Out [umzugkz]
    HISTSTEU,       -- History [histsteu]
    ABLESGRUP,      -- MR group [ablesgrup]
    GEWKEY,         -- Weighting key [gewkey_pr]
    SELCONTROL,     -- Access Operand [selcontrol]
    PEAK_NO,        -- No. of peaks [peak_no]
    SEASONFLAG,     -- Season demand [seasonflag]
    FRAN_TYPE,      -- Franch.fee cat. [fran_type]
    REG_OPERAND,    -- Regist. operand [reg_operand]
    DEMAND_AS_IS,   -- Demand unchg. [demand_as_is]
    ALLHISTORY,     -- Complete hist. [allhistory]
    USE_UDEFVAL1,   -- Use value 1 [use_udefval1]
    USE_UDEFVAL2,   -- Use value 2 [use_udefval2]
    USE_UDEFVAL3,   -- Use value 3 [use_udefval3]
    USE_UDEFVAL4,   -- Use value 4 [use_udefval4]
    OPGROUP,        -- Operand group [opgroup]
    ACTFACTIND,     -- Demand active [actfactind]
    NODIALOGINST,   -- Not instln [nodialoginst]
    NODIALOGRCAT,   -- Not rate cat. [nodialogrcat]
    NODIALOGRATE,   -- Not rate [nodialograte]
    CONREL,         -- Con.-rel. op. [conrel]
    RTPOPERAND,     -- RTP operand [rtpoperand]
    PRODREL,        -- ProdRel-Operand [prodrel]
    WASTEREL,       -- Spec. Val. Prov [wasterel]
    CONSTYPE,       -- Consumptn Type [e_constype]
    BWREL,          -- BW-Relevant [e_bwrel]
    PRORATE_DAILY,  -- Daily Proratn [prorate_daily]
    ERCHVREL,       -- ERCHV Operand [e_erchvrel]
    CONDIREL,       -- Cond. Billing Oper. [e_condirel]
    PRIMARY KEY (MANDT, OPERAND)
);

Learn More