Which tables does I_ClfnCharacteristicForKeyDate use?

I_ClfnCharacteristicForKeyDate reads from 1 data source(s): I_ClfnCharacteristic.

How many fields does I_ClfnCharacteristicForKeyDate have?

I_ClfnCharacteristicForKeyDate has 52 fields. Key fields: CharcInternalID.

I_ClfnCharacteristicForKeyDate

DDL: I_CLFNCHARACTERISTICFORKEYDATE SQL: INGCCHR2 Type: view COMPOSITE

Clfn Characteristic for Key Date

I_ClfnCharacteristicForKeyDate is a Composite CDS View that provides data about "Clfn Characteristic for Key Date" in SAP S/4HANA. It reads from 1 data source (I_ClfnCharacteristic) and exposes 52 fields with key field CharcInternalID. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ClfnCharacteristic	Characteristic	from

Parameters (1)

Name	Type	Default
P_KeyDate	sydate

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	I_ClfnCharcDescForKeyDate	_CharacteristicDesc	`_CharacteristicDesc.CharcInternalID = $projection.CharcInternalID`
[0..*]	I_ClfnCharcValueForKeyDate	_CharacteristicValue	`_CharacteristicValue.CharcInternalID = $projection.CharcInternalID`

Annotations (13)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	INGCCHR2	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Clfn Characteristic for Key Date	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.representativeKey	CharcInternalID	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (52)

Key	Field	Source Table	Source Field
KEY	CharcInternalID	I_ClfnCharacteristic	CharcInternalID
	Characteristic	I_ClfnCharacteristic	Characteristic
	CharcStatus	I_ClfnCharacteristic	CharcStatus
	CharcDataType	I_ClfnCharacteristic	CharcDataType
	CharcLength	I_ClfnCharacteristic	CharcLength
	CharcDecimals	I_ClfnCharacteristic	CharcDecimals
	CharcTemplate	I_ClfnCharacteristic	CharcTemplate
	ValueIsCaseSensitive	I_ClfnCharacteristic	ValueIsCaseSensitive
	CharcConversionRoutine	I_ClfnCharacteristic	CharcConversionRoutine
	CharcGroup	I_ClfnCharacteristic	CharcGroup
	EntryIsRequired	I_ClfnCharacteristic	EntryIsRequired
	MultipleValuesAreAllowed	I_ClfnCharacteristic	MultipleValuesAreAllowed
	CharcValueUnit	I_ClfnCharacteristic	CharcValueUnit
	Currency	I_ClfnCharacteristic	Currency
	CharcExponentValue	I_ClfnCharacteristic	CharcExponentValue
	ValueIntervalIsAllowed	I_ClfnCharacteristic	ValueIntervalIsAllowed
	AdditionalValueIsAllowed	I_ClfnCharacteristic	AdditionalValueIsAllowed
	NegativeValueIsAllowed	I_ClfnCharacteristic	NegativeValueIsAllowed
	ValidityStartDate	I_ClfnCharacteristic	ValidityStartDate
	ValidityEndDate	I_ClfnCharacteristic	ValidityEndDate
	ChangeNumber	I_ClfnCharacteristic	ChangeNumber
	DocumentInfoRecordDocType	I_ClfnCharacteristic	DocumentInfoRecordDocType
	DocumentInfoRecordDocNumber	I_ClfnCharacteristic	DocumentInfoRecordDocNumber
	DocumentInfoRecordDocVersion	I_ClfnCharacteristic	DocumentInfoRecordDocVersion
	DocumentInfoRecordDocPart	I_ClfnCharacteristic	DocumentInfoRecordDocPart
	CharcMaintAuthGrp	I_ClfnCharacteristic	CharcMaintAuthGrp
	CharcIsReadOnly	I_ClfnCharacteristic	CharcIsReadOnly
	CharcIsHidden	I_ClfnCharacteristic	CharcIsHidden
	CharcIsRestrictable	I_ClfnCharacteristic	CharcIsRestrictable
	CharcReferenceTable	I_ClfnCharacteristic	CharcReferenceTable
	CharcReferenceTableField	I_ClfnCharacteristic	CharcReferenceTableField
	CharcCheckTable	I_ClfnCharacteristic	CharcCheckTable
	CharcCheckFunctionModule	I_ClfnCharacteristic	CharcCheckFunctionModule
	CharcExponentFormat	I_ClfnCharacteristic	CharcExponentFormat
	CharcEntryIsNotFormatCtrld	I_ClfnCharacteristic	CharcEntryIsNotFormatCtrld
	CharcTemplateIsDisplayed	I_ClfnCharacteristic	CharcTemplateIsDisplayed
	CharcSelectedSet	I_ClfnCharacteristic	CharcSelectedSet
	Plant	I_ClfnCharacteristic	Plant
	CharcCatalogType	I_ClfnCharacteristic	CharcCatalogType
	CreatedByUser	I_ClfnCharacteristic	CreatedByUser
	CreationDate	I_ClfnCharacteristic	CreationDate
	LastChangedByUser	I_ClfnCharacteristic	LastChangedByUser
	LastChangeDate	I_ClfnCharacteristic	LastChangeDate
	CharcLastChangedDateTime	I_ClfnCharacteristic	CharcLastChangedDateTime
	_CharacteristicDesc		_CharacteristicDesc
	_CharacteristicValue		_CharacteristicValue
	_CharacteristicGroup		_CharacteristicGroup
	_CharacteristicStatus		_CharacteristicStatus
	_UnitOfMeasure		_UnitOfMeasure
	_Currency		_Currency
	_CreatedByUser		_CreatedByUser
	_LastChangedByUser		_LastChangedByUser

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'INGCCHR2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_CreatedByUser', '_LastChangedByUser']
@EndUserText.label: 'Clfn Characteristic for Key Date'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.representativeKey: 'CharcInternalID'
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.supportedCapabilities:
  [  #CDS_MODELING_DATA_SOURCE,
     #CDS_MODELING_ASSOCIATION_TARGET,
     #SQL_DATA_SOURCE                  ]
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */
define view I_ClfnCharacteristicForKeyDate
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_ClfnCharacteristic as Characteristic
      
      association [0..*] to I_ClfnCharcDescForKeyDate as _CharacteristicDesc 
        on  _CharacteristicDesc.CharcInternalID  = $projection.CharcInternalID  

      association [0..*] to I_ClfnCharcValueForKeyDate as _CharacteristicValue
        on _CharacteristicValue.CharcInternalID    = $projection.CharcInternalID
           
            
{
  key Characteristic.CharcInternalID,
      Characteristic.Characteristic,
      Characteristic.CharcStatus,
      Characteristic.CharcDataType,
      Characteristic.CharcLength,
      Characteristic.CharcDecimals,
      Characteristic.CharcTemplate,
      Characteristic.ValueIsCaseSensitive,
      Characteristic.CharcConversionRoutine,
      Characteristic.CharcGroup,
      Characteristic.EntryIsRequired,
      Characteristic.MultipleValuesAreAllowed,
      Characteristic.CharcValueUnit,
      Characteristic.Currency,
      Characteristic.CharcExponentValue,
      Characteristic.ValueIntervalIsAllowed,
      Characteristic.AdditionalValueIsAllowed,
      Characteristic.NegativeValueIsAllowed,
      @Semantics.businessDate.from: true
      Characteristic.ValidityStartDate,
      @Semantics.businessDate.to: true
      Characteristic.ValidityEndDate,         
      Characteristic.ChangeNumber, 
      Characteristic.DocumentInfoRecordDocType,
      Characteristic.DocumentInfoRecordDocNumber,
      Characteristic.DocumentInfoRecordDocVersion,
      Characteristic.DocumentInfoRecordDocPart,           
      Characteristic.CharcMaintAuthGrp,
      Characteristic.CharcIsReadOnly,
      Characteristic.CharcIsHidden,
      Characteristic.CharcIsRestrictable,
      Characteristic.CharcReferenceTable,
      Characteristic.CharcReferenceTableField,
      Characteristic.CharcCheckTable,
      Characteristic.CharcCheckFunctionModule,
      Characteristic.CharcExponentFormat,
      Characteristic.CharcEntryIsNotFormatCtrld,
      Characteristic.CharcTemplateIsDisplayed,
      Characteristic.CharcSelectedSet,
      Characteristic.Plant,
      Characteristic.CharcCatalogType,
      Characteristic.CreatedByUser,
      Characteristic.CreationDate,
      Characteristic.LastChangedByUser,
      Characteristic.LastChangeDate,     
      Characteristic.CharcLastChangedDateTime,
  
      _CharacteristicDesc,
      _CharacteristicValue,      
      _CharacteristicGroup,
      _CharacteristicStatus,
      _UnitOfMeasure,
      _Currency,
      _CreatedByUser,
      _LastChangedByUser
}
where Characteristic.ValidityStartDate   <= $parameters.P_KeyDate
and   Characteristic.ValidityEndDate     >= $parameters.P_KeyDate
and   Characteristic.IsDeleted = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARACTERISTIC"
],
"ASSOCIATED":
[
"I_CLFNCHARCDESCFORKEYDATE",
"I_CLFNCHARCGROUP",
"I_CLFNCHARCSTATUS",
"I_CLFNCHARCVALUEFORKEYDATE",
"I_CURRENCY",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"I_CLFNCHARACTERISTIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_ClfnCharacteristicForKeyDate view

I_ClfnCharacteristic view