I_CLFNCHARCVALFORKEYDATETP
TP for Classification Characteristic Value
I_CLFNCHARCVALFORKEYDATETP is a CDS View in S/4HANA. TP for Classification Characteristic Value. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_ClfnCharcValueForKeyDate | view_entity | from | CONSUMPTION | Characteristic Values |
| Bscl_AUSP | view | left_outer | Used by generated classification views | |
| BSCL_IBSYMBOL_P | view_entity | left_outer | Used by generated configurationviews |
//@ClientHandling.algorithm: #SESSION_VARIABLE
//@AbapCatalog.sqlViewName: 'INGCCHR05TP'
//@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TP for Classification Characteristic Value'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.representativeKey: 'CharcInternalID'
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
//@AbapCatalog.preserveKey: true
//@ObjectModel.createEnabled: true
//@ObjectModel.updateEnabled: true
//@ObjectModel.deleteEnabled: true
//@ObjectModel.writeActiveImplementedBy: 'ABAP:CL_NGC_RAP_CHR'
//@ObjectModel.entityChangeStateId: 'CharcLastChangedDateTime'
//@ObjectModel.transactionalProcessingEnabled: true
define view entity I_ClfnCharcValForKeyDateTP
with parameters
// @Semantics.businessDate.at: true
@Environment.systemField: #SYSTEM_DATE
@Consumption.hidden: true
P_KeyDate :sydate
as select from I_ClfnCharcValueForKeyDate( P_KeyDate: $parameters.P_KeyDate ) as CharacteristicValue
composition [0..*] of I_ClfnCharcValDescForKeyDateTP as _CharcValueDesc
// association [0..*] to I_ClfnCharcValDescForKeyDateTP as _CharcValueDesc
// on $projection.CharcInternalID = _CharcValueDesc.CharcInternalID
// and $projection.CharcValuePositionNumber = _CharcValueDesc.CharcValuePositionNumber
association to parent I_ClfnCharcForKeyDateTP as _Characteristic
on $projection.CharcInternalID = _Characteristic.CharcInternalID
{
key CharacteristicValue.CharcInternalID,
@ObjectModel.foreignKey.association: null
key CharacteristicValue.CharcValuePositionNumber,
CharacteristicValue.CharcValueDependency,
CharacteristicValue.CharcValue,
CharacteristicValue.CharcFromNumericValue,
CharacteristicValue.CharcToNumericValue,
CharacteristicValue.IsDefaultValue,
CharacteristicValue.CharcFromNumericValueUnit,
CharacteristicValue.CharcToNumericValueUnit,
// CharacteristicValue.CharcFromDecimalValue,
// CharacteristicValue.CharcToDecimalValue,
// CharacteristicValue.CharcFromDate,
// CharacteristicValue.CharcToDate,
// CharacteristicValue.CharcFromTime,
// CharacteristicValue.CharcToTime,
// @Semantics.amount.currencyCode: 'Currency'
// CharacteristicValue.CharcFromAmount,
// @Semantics.amount.currencyCode: 'Currency'
// CharacteristicValue.CharcToAmount,
// @Semantics.currencyCode: true
// CharacteristicValue.Currency,
CharacteristicValue.LongTextID,
CharacteristicValue.ChangeNumber,
// Renamed to keep API view compatible
CharacteristicValue.DocumentInfoRecordDocType as DocumentType,
CharacteristicValue.DocumentInfoRecordDocNumber as DocNumber,
CharacteristicValue.DocumentInfoRecordDocPart as DocumentPart,
CharacteristicValue.DocumentInfoRecordDocVersion as DocumentVersion,
CharacteristicValue.ValidityStartDate,
CharacteristicValue.ValidityEndDate,
// @ObjectModel.readOnly: true
$parameters.P_KeyDate as KeyDate,
_Characteristic( P_KeyDate: $parameters.P_KeyDate ).CharcLastChangedDateTime,
// @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_CharcValueDesc,
// @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
_Characteristic
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARCFORKEYDATETP",
"I_CLFNCHARCVALUEFORKEYDATE"
],
"ASSOCIATED":
[
"I_CLFNCHARCFORKEYDATETP",
"I_CLFNCHARCVALDESCFORKEYDATETP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/