I_CACnsmpnItmClassGnrtdObjects

DDL: I_CACNSMPNITMCLASSGNRTDOBJECTS SQL: ICACITCATGENOB Type: view BASIC
6 Fields 1 Data Sources

Gen. Obj. für Klasse Verbr.pos.

I_CACnsmpnItmClassGnrtdObjects is a Basic CDS View that provides data about "Gen. Obj. für Klasse Verbr.pos." in SAP S/4HANA. It reads from 1 data source (dfkkbixcit_genob) and exposes 6 fields with key fields CACnsmpnItmClass, CACnsmpnItmStatus, ABAPObjectCategory, ABAPObjectType, ABAPObject.

Data Sources (1)

SourceAliasJoin Type
dfkkbixcit_genob dfkkbixcit_genob from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICACITCATGENOB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Gen. Obj. für Klasse Verbr.pos. view
ObjectModel.representativeKey CACnsmpnItmClass view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CACnsmpnItmClass dfkkbixcit_genob citcat Class
KEY CACnsmpnItmStatus dfkkbixcit_genob citstatus Status
KEY ABAPObjectCategory dfkkbixcit_genob pgmid Program Name
KEY ABAPObjectType dfkkbixcit_genob obj_type Type
KEY ABAPObject
CACnsmpnItmObjectType dfkkbixcit_genob cit_obj_type Int.Object Type

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_CACnsmpnItmClassGnrtdObjects.
-- 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: ICACITCATGENOB

CREATE VIEW I_CACnsmpnItmClassGnrtdObjects AS
SELECT
  dfkkbixcit_genob.citcat AS CACnsmpnItmClass,
  dfkkbixcit_genob.citstatus AS CACnsmpnItmStatus,
  dfkkbixcit_genob.pgmid AS ABAPObjectCategory,
  dfkkbixcit_genob.obj_type AS ABAPObjectType,
  cast( dfkkbixcit_genob.obj_name as sobj_name ) AS ABAPObject,
  dfkkbixcit_genob.cit_obj_type AS CACnsmpnItmObjectType
FROM dfkkbixcit_genob
;

Learn More