P_CharcCtlgClfnCharcValueBasic

DDL: P_CHARCCTLGCLFNCHARCVALUEBASIC Type: view_entity COMPOSITE Package: PROD_ALLOC_CHARC_CATALOG

Charac Catalog Classification Characteristic Value Basic

P_CharcCtlgClfnCharcValueBasic is a Composite CDS View that provides data about "Charac Catalog Classification Characteristic Value Basic" in SAP S/4HANA. It reads from 1 data source (I_ClfnCharcValue) and exposes 30 fields with key fields CharcInternalID, CharcValuePositionNumber, TimeIntervalNumber. Part of development package PROD_ALLOC_CHARC_CATALOG.

Data Sources (1)

SourceAliasJoin Type
I_ClfnCharcValue I_ClfnCharcValue from

Annotations (6)

NameValueLevelField
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID CharcInternalID
KEY CharcValuePositionNumber CharcValuePositionNumber
KEY TimeIntervalNumber TimeIntervalNumber
CharcValueParentPositionNumber CharcValueParentPositionNumber
CharcValueHasChild CharcValueHasChild
CharcValueIntervalType CharcValueIntervalType
CharcValue CharcValue
CharcFromNumericValue CharcFromNumericValue
CharcToNumericValue CharcToNumericValue
IsDefaultValue IsDefaultValue
CharcFromNumericValueUnit CharcFromNumericValueUnit
CharcToNumericValueUnit CharcToNumericValueUnit
CharcFromDecimalValue CharcFromDecimalValue
CharcToDecimalValue CharcToDecimalValue
CharcFromDate CharcFromDate
CharcToDate CharcToDate
CharcFromTime CharcFromTime
CharcToTime CharcToTime
CharcFromAmount CharcFromAmount
CharcToAmount CharcToAmount
Currency Currency
LongTextID LongTextID
ChangeNumber ChangeNumber
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
IsDeleted IsDeleted
DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber
DocumentInfoRecordDocPart DocumentInfoRecordDocPart
DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion
DocumentInfoRecordDocType DocumentInfoRecordDocType
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MASTER
define view entity P_CharcCtlgClfnCharcValueBasic
  as select from I_ClfnCharcValue
{
  key CharcInternalID,
  key CharcValuePositionNumber,
  key TimeIntervalNumber,
      CharcValueParentPositionNumber,
      CharcValueHasChild,
      CharcValueIntervalType,
      CharcValue,
      CharcFromNumericValue,
      CharcToNumericValue,
      IsDefaultValue,
      CharcFromNumericValueUnit,
      CharcToNumericValueUnit,
      CharcFromDecimalValue,
      CharcToDecimalValue,
      CharcFromDate,
      CharcToDate,
      CharcFromTime,
      CharcToTime,
      @Semantics.amount.currencyCode: 'CURRENCY' 
CharcFromAmount,
      @Semantics.amount.currencyCode: 'CURRENCY' 
CharcToAmount,
      Currency,
      LongTextID,
      ChangeNumber,
      ValidityStartDate,
      ValidityEndDate,
      IsDeleted,
      DocumentInfoRecordDocNumber,
      DocumentInfoRecordDocPart,
      DocumentInfoRecordDocVersion,
      DocumentInfoRecordDocType
}
where
      CharcValueIntervalType = '1'
  and CharcValueHasChild   = ''