CRMS4_IU_I_UOP

DDL: CRMS4_IU_I_UOP Type: view_entity
40 Fields 2 Data Sources

Utilities Operand

CRMS4_IU_I_UOP is a CDS View that provides data about "Utilities Operand" in SAP S/4HANA. It reads from 2 data sources (te221, I_UtilsOperand) and exposes 40 fields with key field UtilsBillingOperand.

Data Sources (2)

SourceAliasJoin Type
te221 _Operand inner
I_UtilsOperand I_UtilsOperand from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Utilities Operand view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY UtilsBillingOperand I_UtilsOperand UtilsBillingOperand Operand
UtilitiesDivision I_UtilsOperand UtilitiesDivision Insurance LOB
UtilsOperandCategory I_UtilsOperand UtilsOperandCategory Operand cat.
UtilsMeasurementUnit I_UtilsOperand UtilsMeasurementUnit Unit of meas.
UtilsOperandGroup I_UtilsOperand UtilsOperandGroup Operand group
Orgwert te221 orgwert Two values
Tazuord te221 tazuord RType required
Rundung te221 rundung Rounding
Rundart te221 rundart Rounding Cat.
Leistall te221 leistall All demand vals
Leistmonat te221 leistmonat Demand/month
Bzgart te221 bzgart Ref. value type
Umzugkz te221 umzugkz Move-In/Out
Histsteu te221 histsteu History
Ablesgrup te221 ablesgrup MR group
Gewkey te221 gewkey Weighting key
Selcontrol te221 selcontrol Access Operand
PeakNo te221 peak_no No. of peaks
Seasonflag te221 seasonflag Season demand
FranType te221 fran_type Franch.fee cat.
RegOperand te221 reg_operand Regist. operand
DemandAsIs te221 demand_as_is Demand unchg.
Allhistory te221 allhistory Complete hist.
Use_Udefval1 te221 use_udefval1 Use value 1
Use_Udefval2 te221 use_udefval2 Use value 2
Use_Udefval3 te221 use_udefval3 Use value 3
Use_Udefval4 te221 use_udefval4 Use value 4
Actfactind te221 actfactind Demand active
Nodialoginst te221 nodialoginst Not instln
Nodialogrcat te221 nodialogrcat Not rate cat.
Nodialograte te221 nodialograte Not rate
Conrel te221 conrel Con.-rel. op.
Rtpoperand te221 rtpoperand RTP operand
Prodrel te221 prodrel ProdRel-Operand
Wasterel te221 wasterel Spec. Val. Prov
Constype te221 constype Consumptn Type
Bwrel te221 bwrel BW-Relevant
ProrateDaily te221 prorate_daily Daily Proratn
Erchvrel te221 erchvrel ERCHV Operand
Condirel te221 condirel Cond. Billing Oper.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view CRMS4_IU_I_UOP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW CRMS4_IU_I_UOP AS
SELECT
  I_UtilsOperand.UtilsBillingOperand AS UtilsBillingOperand,
  I_UtilsOperand.UtilitiesDivision AS UtilitiesDivision,
  I_UtilsOperand.UtilsOperandCategory AS UtilsOperandCategory,
  I_UtilsOperand.UtilsMeasurementUnit AS UtilsMeasurementUnit,
  I_UtilsOperand.UtilsOperandGroup AS UtilsOperandGroup,
  _Operand.orgwert AS Orgwert,
  _Operand.tazuord AS Tazuord,
  _Operand.rundung AS Rundung,
  _Operand.rundart AS Rundart,
  _Operand.leistall AS Leistall,
  _Operand.leistmonat AS Leistmonat,
  _Operand.bzgart AS Bzgart,
  _Operand.umzugkz AS Umzugkz,
  _Operand.histsteu AS Histsteu,
  _Operand.ablesgrup AS Ablesgrup,
  _Operand.gewkey AS Gewkey,
  _Operand.selcontrol AS Selcontrol,
  _Operand.peak_no AS PeakNo,
  _Operand.seasonflag AS Seasonflag,
  _Operand.fran_type AS FranType,
  _Operand.reg_operand AS RegOperand,
  _Operand.demand_as_is AS DemandAsIs,
  _Operand.allhistory AS Allhistory,
  _Operand.use_udefval1 AS Use_Udefval1,
  _Operand.use_udefval2 AS Use_Udefval2,
  _Operand.use_udefval3 AS Use_Udefval3,
  _Operand.use_udefval4 AS Use_Udefval4,
  _Operand.actfactind AS Actfactind,
  _Operand.nodialoginst AS Nodialoginst,
  _Operand.nodialogrcat AS Nodialogrcat,
  _Operand.nodialograte AS Nodialograte,
  _Operand.conrel AS Conrel,
  _Operand.rtpoperand AS Rtpoperand,
  _Operand.prodrel AS Prodrel,
  _Operand.wasterel AS Wasterel,
  _Operand.constype AS Constype,
  _Operand.bwrel AS Bwrel,
  _Operand.prorate_daily AS ProrateDaily,
  _Operand.erchvrel AS Erchvrel,
  _Operand.condirel AS Condirel
FROM I_UtilsOperand
INNER JOIN te221 AS _Operand ON /* join condition not captured in parsed metadata */
;

Learn More