CRMS4_IUCH_SRCH

DDL: CRMS4_IUCH_SRCH Type: view_entity
22 Fields 1 Data Sources

Utilities Sales Contract Reporting Framework Search

CRMS4_IUCH_SRCH is a CDS View that provides data about "Utilities Sales Contract Reporting Framework Search" in SAP S/4HANA. It reads from 1 data source (CRMS4_IU_C_CTH) and exposes 22 fields with key fields objtype_h, object_id.

Data Sources (1)

SourceAliasJoin Type
CRMS4_IU_C_CTH CRMS4_IU_C_CTH from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Utilities Sales Contract Reporting Framework Search view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY objtype_h objtype_h Trans. Cat.
KEY object_id object_id Transaction ID
object_type objtype_h Trans. Cat.
header_guid header_guid Unique Identifier
guid header_guid Unique Identifier
process_type process_type Type of Data
posting_date posting_date Posting Date
created_at_h created_at_h Created On
created_by_h created_by_h Created By
changed_at_h changed_at_h Changed On
changed_by_h changed_by_h Changed By
btx_class btx_class Trans.Classification
auth_scope auth_scope Authorization Scope
object_id_ok object_id_ok ID Valid
verify_date verify_date Verify Date
stat_error stat_error Error Status
stat_open stat_open Open
contend_max contend_max
bu_partner sold_to_party Sold-to Party
_BusinessPartner _BusinessPartner
_ContractItem _ContractItem
_ContractPeriod _ContractPeriod

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_IUCH_SRCH.
-- 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_IUCH_SRCH AS
SELECT
  objtype_h,
  object_id,
  objtype_h AS object_type,
  header_guid,
  header_guid AS guid,
  process_type,
  posting_date,
  created_at_h,
  created_by_h,
  changed_at_h,
  changed_by_h,
  btx_class,
  auth_scope,
  object_id_ok,
  verify_date,
  stat_error,
  stat_open,
  contend_max,
  sold_to_party AS bu_partner
FROM CRMS4_IU_C_CTH
;

Learn More