C_MrchdsCatCharcValRstrcnMigrt

DDL: C_MRCHDSCATCHARCVALRSTRCNMIGRT Type: view_entity CONSUMPTION
16 Fields 1 Data Sources

Mrchds Cat Charc Value Restriction

C_MrchdsCatCharcValRstrcnMigrt is a Consumption CDS View that provides data about "Mrchds Cat Charc Value Restriction" in SAP S/4HANA. It reads from 1 data source (R_MrchdsCatCharcValRstrcnTP) and exposes 16 fields with key fields MerchandiseCategory, Characteristic, ClfnCharcValuePositionNumber.

Data Sources (1)

SourceAliasJoin Type
R_MrchdsCatCharcValRstrcnTP R_MrchdsCatCharcValRstrcnTP from

Annotations (6)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Mrchds Cat Charc Value Restriction view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MerchandiseCategory MerchandiseCategory
KEY Characteristic Characteristic Field Name
KEY ClfnCharcValuePositionNumber ClfnCharcValuePositionNumber Counter
CharcValue CharcValue Char. Value
CharcValueIntervalType CharcValueIntervalType Code
CharcFromNumericValueUnit CharcFromNumericValueUnit Internal UoM
CharcToNumericValueUnit CharcToNumericValueUnit Internal UoM
CharcFromDecimalValue CharcFromDecimalValue LowrBndry Nmrc
CharcToDecimalValue CharcToDecimalValue UprBndry Nmrc
CharcFromAmount CharcFromAmount LowrBndry Crcy
CharcToAmount CharcToAmount UprBndry Crcy
Currency Currency Valuation Crcy
CharcFromDate CharcFromDate LowrBndry Date
CharcToDate CharcToDate UprBndry Date
CharcFromTime CharcFromTime LowrBndry Time
CharcToTime CharcToTime UprBndry Time

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 C_MrchdsCatCharcValRstrcnMigrt.
-- 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 C_MrchdsCatCharcValRstrcnMigrt AS
SELECT
  MerchandiseCategory,
  Characteristic,
  ClfnCharcValuePositionNumber,
  CharcValue,
  CharcValueIntervalType,
  CharcFromNumericValueUnit,
  CharcToNumericValueUnit,
  CharcFromDecimalValue,
  CharcToDecimalValue,
  CharcFromAmount,
  CharcToAmount,
  Currency,
  CharcFromDate,
  CharcToDate,
  CharcFromTime,
  CharcToTime
FROM R_MrchdsCatCharcValRstrcnTP
;

Learn More