C_TicketInspectorVH

DDL: C_TICKETINSPECTORVH SQL: CTKTINSPCTRVH Type: view CONSUMPTION
19 Fields 1 Data Sources

Ticket Inspector Value Help

C_TicketInspectorVH is a Consumption CDS View that provides data about "Ticket Inspector Value Help" in SAP S/4HANA. It reads from 1 data source (I_TicketInspectorVH) and exposes 19 fields with key fields TransportSystem, LocationId, NominationInspector.

Data Sources (1)

SourceAliasJoin Type
I_TicketInspectorVH I_TicketInspectorVH from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CTKTINSPCTRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Ticket Inspector Value Help view
Consumption.ranked true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY TransportSystem TransportSystem Transport System
KEY LocationId LocationId Location
KEY NominationInspector NominationInspector Inspector
CustomerPartnerDescription CustomerPartnerDescription Name
AuthorizationGroup AuthorizationGroup AuthorizGroup
SupplierAccountGroup SupplierAccountGroup Account group
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
DataController1 _Supplier DataController1 Data Controller
DataController2 _Supplier DataController2 Data Controller
DataController3 _Supplier DataController3 Data Controller
DataController4 _Supplier DataController4 Data Controller
DataController5 _Supplier DataController5 Data Controller
DataController6 _Supplier DataController6 Data Controller
DataController7 _Supplier DataController7 Data Controller
DataController8 _Supplier DataController8 Data Controller
DataController9 _Supplier DataController9 Data Controller
DataController10 _Supplier DataController10 Data Controller
DataControllerSet _Supplier DataControllerSet Data Ctrlr. Set
_Supplier _Supplier

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 C_TicketInspectorVH.
-- 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: CTKTINSPCTRVH

CREATE VIEW C_TicketInspectorVH AS
SELECT
  TransportSystem,
  LocationId,
  NominationInspector,
  CustomerPartnerDescription,
  AuthorizationGroup,
  SupplierAccountGroup,
  IsBusinessPurposeCompleted,
  _Supplier.DataController1 AS DataController1,
  _Supplier.DataController2 AS DataController2,
  _Supplier.DataController3 AS DataController3,
  _Supplier.DataController4 AS DataController4,
  _Supplier.DataController5 AS DataController5,
  _Supplier.DataController6 AS DataController6,
  _Supplier.DataController7 AS DataController7,
  _Supplier.DataController8 AS DataController8,
  _Supplier.DataController9 AS DataController9,
  _Supplier.DataController10 AS DataController10,
  _Supplier.DataControllerSet AS DataControllerSet
FROM I_TicketInspectorVH
;

Learn More