I_ACMUniversalTicketItem

DDL: I_ACMUNIVERSALTICKETITEM SQL: IUNIVTI Type: view BASIC
6 Fields 1 Data Sources

Universal Ticket Item

I_ACMUniversalTicketItem is a Basic CDS View that provides data about "Universal Ticket Item" in SAP S/4HANA. It reads from 1 data source (oij_el_ticket_i) and exposes 6 fields with key fields ACMUniversalTicketKey, ACMUniversalTicketItem, ACMUniversalTicketVersion, ACMUniversalTicketPurpose.

Data Sources (1)

SourceAliasJoin Type
oij_el_ticket_i oij_el_ticket_i from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IUNIVTI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Universal Ticket Item view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ACMUniversalTicketKey ticket_key Ticket key
KEY ACMUniversalTicketItem ticket_item Single-Character Flag
KEY ACMUniversalTicketVersion ticket_version Ticket version
KEY ACMUniversalTicketPurpose ticket_purpose Ticket Purpose
ACMUniversalTicketStatus status Workflow Status
ACMUniversalTicketReturnCode tktsubrc Return code

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 I_ACMUniversalTicketItem.
-- 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.
-- SQL view name: IUNIVTI

CREATE VIEW I_ACMUniversalTicketItem AS
SELECT
  ticket_key AS ACMUniversalTicketKey,
  ticket_item AS ACMUniversalTicketItem,
  ticket_version AS ACMUniversalTicketVersion,
  ticket_purpose AS ACMUniversalTicketPurpose,
  status AS ACMUniversalTicketStatus,
  tktsubrc AS ACMUniversalTicketReturnCode
FROM oij_el_ticket_i
;

Learn More