C_ObjValDetnAccess

DDL: C_OBJVALDETNACCESS Type: view_entity CONSUMPTION
19 Fields 1 Data Sources

Access

C_ObjValDetnAccess is a Consumption CDS View that provides data about "Access" in SAP S/4HANA. It reads from 1 data source (I_ObjValDetnAccess) and exposes 19 fields with key field ObjValDetnAccessUUID.

Data Sources (1)

SourceAliasJoin Type
I_ObjValDetnAccess I_ObjValDetnAccess from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Access view
ObjectModel.representativeKey ObjValDetnAccessUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ObjValDetnAccessUUID ObjValDetnAccessUUID Access UUID
ObjValDetnCharcCombinationUUID ObjValDetnCharcCombinationUUID Combination UUID
ObjValDetnUsage ObjValDetnUsage Usage
ObjValDetnAccessSequenceValue ObjValDetnAccessSequenceValue Sort Sequence
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
ObjValDetnUsageType ObjValDetnUsageType Usage Type
ObjValDetnUsageTypeDescription
ObjValDetnActivationStatus ObjValDetnActivationStatus Status
ObjValDetnActivationStatusDesc
_Combination _Combination
_Usage _Usage
_UsageType _UsageType
_Status _Status
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_CharcValCombn _CharcValCombn

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_ObjValDetnAccess.
-- 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 C_ObjValDetnAccess AS
SELECT
  ObjValDetnAccessUUID,
  ObjValDetnCharcCombinationUUID,
  ObjValDetnUsage,
  ObjValDetnAccessSequenceValue,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  ObjValDetnUsageType,
  _UsageType._Text[1:Language=$session.system_language].ObjValDetnUsageTypeDescription AS ObjValDetnUsageTypeDescription,
  ObjValDetnActivationStatus,
  _Status._Text[1:Language=$session.system_language].ObjValDetnActivationStatusDesc AS ObjValDetnActivationStatusDesc
FROM I_ObjValDetnAccess
;

Learn More