I_ClfnCharcValueOverwrite

DDL: I_CLFNCHARCVALUEOVERWRITE Type: view_entity Package: NGC_CORE_VDM
33 Fields

Classification Characteristic Value Overwrite

I_ClfnCharcValueOverwrite is a CDS View that provides data about "Classification Characteristic Value Overwrite" in SAP S/4HANA. Part of development package NGC_CORE_VDM.

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Classification Characteristic Value Overwrite view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID Characteristic CharcInternalID Characteristic Internal ID
KEY OverwrittenCharcInternalID OverwrittenCharcValue CharcInternalID Characteristic Internal ID
KEY CharcValuePositionNumber OverwrittenCharcValue CharcValuePositionNumber
CharcValue OverwrittenCharcValue CharcValue Char. Value
TimeIntervalNumber OverwrittenCharcValue TimeIntervalNumber Int. counter
CharcValueParentPositionNumber OverwrittenCharcValue CharcValueParentPositionNumber
CharcValueHasChild OverwrittenCharcValue CharcValueHasChild
CharcValueIntervalType OverwrittenCharcValue CharcValueIntervalType Code
CharcFromNumericValue OverwrittenCharcValue CharcFromNumericValue Value from
CharcToNumericValue OverwrittenCharcValue CharcToNumericValue Value to
IsDefaultValue OverwrittenCharcValue IsDefaultValue
CharcFromNumericValueUnit OverwrittenCharcValue CharcFromNumericValueUnit Internal UoM
CharcToNumericValueUnit OverwrittenCharcValue CharcToNumericValueUnit Internal UoM
CharcFromDecimalValue OverwrittenCharcValue CharcFromDecimalValue LowrBndry Nmrc
CharcToDecimalValue OverwrittenCharcValue CharcToDecimalValue UprBndry Nmrc
CharcFromDate OverwrittenCharcValue CharcFromDate LowrBndry Date
CharcToDate OverwrittenCharcValue CharcToDate UprBndry Date
CharcFromTime OverwrittenCharcValue CharcFromTime LowrBndry Time
CharcToTime OverwrittenCharcValue CharcToTime UprBndry Time
CharcFromAmount OverwrittenCharcValue CharcFromAmount LowrBndry Crcy
CharcToAmount OverwrittenCharcValue CharcToAmount UprBndry Crcy
Currency OverwrittenCharcValue Currency Valuation Crcy
LongTextID OverwrittenCharcValue LongTextID Text ID
ChangeNumber OverwrittenCharcValue ChangeNumber Change Number
ValidityStartDate OverwrittenCharcValue ValidityStartDate Validity Start Date
ValidityEndDate OverwrittenCharcValue ValidityEndDate ValidTo
IsDeleted OverwrittenCharcValue IsDeleted TRUE
DocumentInfoRecordDocNumber OverwrittenCharcValue DocumentInfoRecordDocNumber Document
DocumentInfoRecordDocPart OverwrittenCharcValue DocumentInfoRecordDocPart Document Part
DocumentInfoRecordDocVersion OverwrittenCharcValue DocumentInfoRecordDocVersion Doc. Version
DocumentInfoRecordDocType OverwrittenCharcValue DocumentInfoRecordDocType Document Type
CharcIdentificationCode OverwrittenCharcValue CharcIdentificationCode
_Currency OverwrittenCharcValue _Currency

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 I_ClfnCharcValueOverwrite.
-- 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 I_ClfnCharcValueOverwrite AS
SELECT
  Characteristic.CharcInternalID AS CharcInternalID,
  OverwrittenCharcValue.CharcInternalID AS OverwrittenCharcInternalID,
  OverwrittenCharcValue.CharcValuePositionNumber AS CharcValuePositionNumber,
  OverwrittenCharcValue.CharcValue AS CharcValue,
  OverwrittenCharcValue.TimeIntervalNumber AS TimeIntervalNumber,
  OverwrittenCharcValue.CharcValueParentPositionNumber AS CharcValueParentPositionNumber,
  OverwrittenCharcValue.CharcValueHasChild AS CharcValueHasChild,
  OverwrittenCharcValue.CharcValueIntervalType AS CharcValueIntervalType,
  OverwrittenCharcValue.CharcFromNumericValue AS CharcFromNumericValue,
  OverwrittenCharcValue.CharcToNumericValue AS CharcToNumericValue,
  OverwrittenCharcValue.IsDefaultValue AS IsDefaultValue,
  OverwrittenCharcValue.CharcFromNumericValueUnit AS CharcFromNumericValueUnit,
  OverwrittenCharcValue.CharcToNumericValueUnit AS CharcToNumericValueUnit,
  OverwrittenCharcValue.CharcFromDecimalValue AS CharcFromDecimalValue,
  OverwrittenCharcValue.CharcToDecimalValue AS CharcToDecimalValue,
  OverwrittenCharcValue.CharcFromDate AS CharcFromDate,
  OverwrittenCharcValue.CharcToDate AS CharcToDate,
  OverwrittenCharcValue.CharcFromTime AS CharcFromTime,
  OverwrittenCharcValue.CharcToTime AS CharcToTime,
  OverwrittenCharcValue.CharcFromAmount AS CharcFromAmount,
  OverwrittenCharcValue.CharcToAmount AS CharcToAmount,
  OverwrittenCharcValue.Currency AS Currency,
  OverwrittenCharcValue.LongTextID AS LongTextID,
  OverwrittenCharcValue.ChangeNumber AS ChangeNumber,
  OverwrittenCharcValue.ValidityStartDate AS ValidityStartDate,
  OverwrittenCharcValue.ValidityEndDate AS ValidityEndDate,
  OverwrittenCharcValue.IsDeleted AS IsDeleted,
  OverwrittenCharcValue.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  OverwrittenCharcValue.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  OverwrittenCharcValue.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  OverwrittenCharcValue.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  OverwrittenCharcValue.CharcIdentificationCode AS CharcIdentificationCode,
  OverwrittenCharcValue._Currency AS _Currency
;

Learn More