C_ObjValDetnCharacteristicTP

DDL: C_OBJVALDETNCHARACTERISTICTP Type: view_entity CONSUMPTION
16 Fields 1 Data Sources 1 Associations

Characteristic

C_ObjValDetnCharacteristicTP is a Consumption CDS View that provides data about "Characteristic" in SAP S/4HANA. It reads from 1 data source (R_ObjValDetnCharacteristicTP) and exposes 16 fields with key field ObjValDetnCharacteristicUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_ObjValDetnCharacteristicTP R_ObjValDetnCharacteristicTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_Prodalloccharcctlgpathdsp _MngCharcCatalogPathDisplay $projection.ProdAllocCharcCtlgPathIntID = _MngCharcCatalogPathDisplay.ProdAllocCharcCtlgPathIntID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
EndUserText.label Characteristic view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ObjValDetnCharacteristicUUID ObjValDetnCharacteristicUUID Characteristic UUID
ObjValDetnCharcCombinationUUID ObjValDetnCharcCombinationUUID Combination UUID
ObjValDetnOrdinalValue ObjValDetnOrdinalValue Ordinal Number Value
ProdAllocCharcCtlgPathUUID ProdAllocCharcCtlgPathUUID Product Allocation Characteristic Catalog Path UUID
ProdAllocCharcCtlgPathIntID ProdAllocCharcCtlgPathIntID Catalog Path Internal ID
CharcValExistenceCheckType _ProdAllocCharcCtlgPath CharcValExistenceCheckType Value Existence Check Type
CharcValExistenceCheckTypeDesclocalized
ProdAllocCharcCatalogUseType _ProdAllocCharcCtlgPath ProdAllocCharcCatalogUseType Catalog Use Type
ProdAllocCharcCatalogType _Combination ProdAllocCharcCatalogType Catalog Type
ProdAllocCharcCtlgParPathIntID _ProdAllocCharcCtlgPath ProdAllocCharcCtlgParPathIntID Catalog Parent Path Internal ID
ProdAllocCharcCatalogCharcType _ProdAllocCharcCtlgPath ProdAllocCharcCatalogCharcType Characteristic Type
ProdAllocCharcCatalogPathType _ProdAllocCharcCtlgPath ProdAllocCharcCatalogPathType Characteristic Path Type
ProdAllocCharcCtlgPathSelName _ProdAllocCharcCtlgPath ProdAllocCharcCtlgPathSelName Path Selection Name
ProdAllocCharcCatalogPath _ProdAllocCharcCtlgPath ProdAllocCharcCatalogPath Charc Catalog Path
_ProdAllocCharcCtlgPath _ProdAllocCharcCtlgPath
_MngCharcCatalogPathDisplay _MngCharcCatalogPathDisplay

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_ObjValDetnCharacteristicTP.
-- 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_ObjValDetnCharacteristicTP AS
SELECT
  ObjValDetnCharacteristicUUID,
  ObjValDetnCharcCombinationUUID,
  ObjValDetnOrdinalValue,
  ProdAllocCharcCtlgPathUUID,
  ProdAllocCharcCtlgPathIntID,
  _ProdAllocCharcCtlgPath.CharcValExistenceCheckType AS CharcValExistenceCheckType,
  _ProdAllocCharcCtlgPath._CharcValExistenceCheckType._Text.CharcValExistenceCheckTypeDesc : localized AS CharcValExistenceCheckTypeDesclocalized,
  _ProdAllocCharcCtlgPath.ProdAllocCharcCatalogUseType AS ProdAllocCharcCatalogUseType,
  _Combination.ProdAllocCharcCatalogType AS ProdAllocCharcCatalogType,
  _ProdAllocCharcCtlgPath.ProdAllocCharcCtlgParPathIntID AS ProdAllocCharcCtlgParPathIntID,
  _ProdAllocCharcCtlgPath.ProdAllocCharcCatalogCharcType AS ProdAllocCharcCatalogCharcType,
  _ProdAllocCharcCtlgPath.ProdAllocCharcCatalogPathType AS ProdAllocCharcCatalogPathType,
  _ProdAllocCharcCtlgPath.ProdAllocCharcCtlgPathSelName AS ProdAllocCharcCtlgPathSelName,
  _ProdAllocCharcCtlgPath.ProdAllocCharcCatalogPath AS ProdAllocCharcCatalogPath
FROM R_ObjValDetnCharacteristicTP
LEFT OUTER JOIN C_Prodalloccharcctlgpathdsp AS _MngCharcCatalogPathDisplay ON ProdAllocCharcCtlgPathIntID = _MngCharcCatalogPathDisplay.ProdAllocCharcCtlgPathIntID  -- association [1..1]
;

Learn More