/UCOM/C_MCM_Connobj_VH

DDL: /UCOM/C_MCM_CONNOBJ_VH SQL: /UCOM/CCONOBJVH Type: view_entity CONSUMPTION
9 Fields 1 Data Sources

Connection Object Lookup

/UCOM/C_MCM_Connobj_VH is a Consumption CDS View that provides data about "Connection Object Lookup" in SAP S/4HANA. It reads from 1 data source (/UCOM/I_MCM_Connobj_VH) and exposes 9 fields with key field UtilitiesConnectionObject.

Data Sources (1)

SourceAliasJoin Type
/UCOM/I_MCM_Connobj_VH /UCOM/I_MCM_Connobj_VH from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label Connection Object Lookup view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesConnectionObject Connection Object
Street _Adrc street Street Code
HouseNumber _Adrc house_num1 House Number
PostalCode _Adrc post_code1 Postal Code
City _Adrc city1 City
District _Address District District Court
Country _Adrc country Venue: Ctry/Reg
HouseNumberSupplementText _Address HouseNumberSupplementText Supplement
Address Address

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 /UCOM/C_MCM_Connobj_VH.
-- 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: /UCOM/CCONOBJVH

CREATE VIEW /UCOM/C_MCM_Connobj_VH AS
SELECT
  cast( FunctionalLocation as abap.char(30)) AS UtilitiesConnectionObject,
  _Adrc.street AS Street,
  _Adrc.house_num1 AS HouseNumber,
  _Adrc.post_code1 AS PostalCode,
  _Adrc.city1 AS City,
  _Address.District AS District,
  _Adrc.country AS Country,
  _Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  cast( '' as abap.char( 256 )) AS Address
FROM /UCOM/I_MCM_Connobj_VH
;

Learn More