C_OpnCtlgAttribute

DDL: C_OPNCTLGATTRIBUTE SQL: COPNCTLGATTRIBTE Type: view CONSUMPTION
7 Fields 1 Data Sources

Catalog Item Attribute

C_OpnCtlgAttribute is a Consumption CDS View that provides data about "Catalog Item Attribute" in SAP S/4HANA. It reads from 1 data source (I_OpnCtlgAttribute) and exposes 7 fields with key fields OpnCtlgItemID, Language, OpnCtlgAttribUUID.

Data Sources (1)

SourceAliasJoin Type
I_OpnCtlgAttribute I_OpnCtlgAttribute from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName COPNCTLGATTRIBTE view
VDM.viewType #CONSUMPTION view
ClientDependent true view
Search.searchable true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Catalog Item Attribute view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY OpnCtlgItemID OpnCtlgItemID Catalog Item Key
KEY Language Language Language
KEY OpnCtlgAttribUUID OpnCtlgAttribUUID Atrribute Guid
OpnCtlgIntCatalogName OpnCtlgIntCatalogName Catagory Name
OpnCtlgAttribName OpnCtlgAttribName Attribute Name
OpnCtlgAttribValue OpnCtlgAttribValue Attribute Value
OpnCtlgAttribUnit OpnCtlgAttribUnit Attribute Unit

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_OpnCtlgAttribute.
-- 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: COPNCTLGATTRIBTE

CREATE VIEW C_OpnCtlgAttribute AS
SELECT
  OpnCtlgItemID,
  Language,
  OpnCtlgAttribUUID,
  OpnCtlgIntCatalogName,
  OpnCtlgAttribName,
  OpnCtlgAttribValue,
  OpnCtlgAttribUnit
FROM I_OpnCtlgAttribute
;

Learn More