C_CustomerReturnSerialNumberVH

DDL: C_CUSTOMERRETURNSERIALNUMBERVH Type: view_entity CONSUMPTION Package: ODATA_SD_RETURN_V2
10 Fields 1 Data Sources

Returns Order Serial Number

C_CustomerReturnSerialNumberVH is a Consumption CDS View that provides data about "Returns Order Serial Number" in SAP S/4HANA. It reads from 1 data source (I_Equipment) and exposes 10 fields with key field Equipment. Part of development package ODATA_SD_RETURN_V2.

Data Sources (1)

SourceAliasJoin Type
I_Equipment sn from

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Returns Order Serial Number view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_Equipment Equipment Equipment check
SerialNumber I_Equipment SerialNumber Serial Number
Product
Plant MaterialSerialNumber Plant Valuation Area
StorageLocation MaterialSerialNumber StorageLocation StorageLocation
Customer I_Equipment Customer Sold-to Party
Supplier I_Equipment Supplier Supplier
AuthorizationGroup I_Equipment AuthorizationGroup AuthorizGroup
_Customer I_Equipment _Customer
_Supplier I_Equipment _Supplier

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_CustomerReturnSerialNumberVH.
-- 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_CustomerReturnSerialNumberVH AS
SELECT
  sn.Equipment AS Equipment,
  sn.SerialNumber AS SerialNumber,
  cast(sn.Material as productnumber preserving type) AS Product,
  MaterialSerialNumber.Plant AS Plant,
  MaterialSerialNumber.StorageLocation AS StorageLocation,
  sn.Customer AS Customer,
  sn.Supplier AS Supplier,
  sn.AuthorizationGroup AS AuthorizationGroup,
  sn._Customer AS _Customer,
  sn._Supplier AS _Supplier
FROM I_Equipment AS sn
;

Learn More