CRMS4_IU_C_UDA

DDL: CRMS4_IU_C_UDA Type: view_entity
33 Fields 1 Data Sources

Utilities Disconnection Activity

CRMS4_IU_C_UDA is a CDS View that provides data about "Utilities Disconnection Activity" in SAP S/4HANA. It reads from 1 data source (CRMS4_IU_I_UDA) and exposes 33 fields with key fields Discno, Discact.

Data Sources (1)

SourceAliasJoin Type
CRMS4_IU_I_UDA CRMS4_IU_I_UDA from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Utilities Disconnection Activity view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY Discno Discno Disconnect.doc.
KEY Discact Discact Discon.activity
Discacttyp Discacttyp Disc.act.categ.
Actdate Actdate Disc.activ.date
Acttime Acttime Single-Character Flag
Ordstate Ordstate Order status
Neworder Neworder New order
Ordernum Ordernum Purchasing Doc.
BcContact BcContact Contact
ChargeOpbel ChargeOpbel Document Number
Orderact Orderact Discon.activity
Bbpchanged Bbpchanged BB change
Disccanceld Disccanceld Reversed
Vacantact Vacantact Vacancy activ.
Amiact Amiact AMI activity
Amireqid Amireqid Request ID
Amiflagged Amiflagged AMI Flag
InterimBilling InterimBilling Create IB
AprvlReqd AprvlReqd Notif. Required
AprvdDate AprvdDate Agreed Date
AprvdTime AprvdTime Agreed Time
AprvlDate AprvlDate Notif. Date
AprvlTime AprvlTime Notif. Time
AprvlAgent AprvlAgent Notif. Agent
Workitem Workitem Work Item ID
AprvlSrc AprvlSrc Notif. Source
Ordercode Ordercode Order Code
Orderwerk Orderwerk PM plant order
CreaUser CreaUser Created By User
CreaDate CreaDate Creation Date
ChanUser ChanUser Changed By User
ChanDate ChanDate Changing Date
_DisconnectionDocument _DisconnectionDocument

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_C_UDA.
-- 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_C_UDA AS
SELECT
  Discno,
  Discact,
  Discacttyp,
  Actdate,
  Acttime,
  Ordstate,
  Neworder,
  Ordernum,
  BcContact,
  ChargeOpbel,
  Orderact,
  Bbpchanged,
  Disccanceld,
  Vacantact,
  Amiact,
  Amireqid,
  Amiflagged,
  InterimBilling,
  AprvlReqd,
  AprvdDate,
  AprvdTime,
  AprvlDate,
  AprvlTime,
  AprvlAgent,
  Workitem,
  AprvlSrc,
  Ordercode,
  Orderwerk,
  CreaUser,
  CreaDate,
  ChanUser,
  ChanDate
FROM CRMS4_IU_I_UDA
;

Learn More