P_CharcCtlgClfnCharcValueBasic

DDL: P_CHARCCTLGCLFNCHARCVALUEBASIC SQL: PCCTLGCLFNCVBV Type: view COMPOSITE

P_CharcCtlgClfnCharcValueBasic is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ClfnCharcValue) and exposes 30 fields with key fields CharcInternalID, CharcValuePositionNumber, TimeIntervalNumber.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnCharcValue I_ClfnCharcValue from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCCTLGCLFNCVBV view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
ClientHandling.algorithm #SESSION_VARIABLE 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 
@AbapCatalog.sqlViewName: 'PCCTLGCLFNCVBV'
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

define view 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,
      CharcFromAmount,
      CharcToAmount,
      Currency,
      LongTextID,
      ChangeNumber,
      ValidityStartDate,
      ValidityEndDate,
      IsDeleted,
      DocumentInfoRecordDocNumber,
      DocumentInfoRecordDocPart,
      DocumentInfoRecordDocVersion,
      DocumentInfoRecordDocType
}
where
      CharcValueIntervalType = '1'
  and CharcValueHasChild   = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARCVALUE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More