A_MrchdsCatCharcValRstrcn_2

DDL: A_MRCHDSCATCHARCVALRSTRCN_2 Type: view_entity CONSUMPTION
21 Fields 1 Data Sources

Merchandise Cat Charc Value Restriction

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

Data Sources (1)

SourceAliasJoin Type
R_MrchdsCatCharcValRstrcnTP R_MrchdsCatCharcValRstrcnTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name MrchdsCatCharcValRstrcn_Type view
Metadata.ignorePropagatedAnnotations true view
Search.searchable false view
EndUserText.label Merchandise Cat Charc Value Restriction view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY MerchandiseCategory MerchandiseCategory
KEY Characteristic Characteristic Field Name
KEY ClfnCharcValuePositionNumber ClfnCharcValuePositionNumber Counter
ClfnObjectID ClfnObjectID
CharcInternalID CharcInternalID Characteristic Internal ID
CharcValue CharcValue Char. Value
CharcFromNumericValue CharcFromNumericValue Value from
CharcFromNumericValueUnit CharcFromNumericValueUnit Internal UoM
CharcToNumericValue CharcToNumericValue Value to
CharcToNumericValueUnit CharcToNumericValueUnit Internal UoM
CharcValueIntervalType CharcValueIntervalType Code
IsDeleted IsDeleted TRUE
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 A_MrchdsCatCharcValRstrcn_2.
-- 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 A_MrchdsCatCharcValRstrcn_2 AS
SELECT
  MerchandiseCategory,
  Characteristic,
  ClfnCharcValuePositionNumber,
  ClfnObjectID,
  CharcInternalID,
  CharcValue,
  CharcFromNumericValue,
  CharcFromNumericValueUnit,
  CharcToNumericValue,
  CharcToNumericValueUnit,
  CharcValueIntervalType,
  IsDeleted,
  CharcFromDecimalValue,
  CharcToDecimalValue,
  CharcFromAmount,
  CharcToAmount,
  Currency,
  CharcFromDate,
  CharcToDate,
  CharcFromTime,
  CharcToTime
FROM R_MrchdsCatCharcValRstrcnTP
;

Learn More