I_EWM_SerialNumberHeader_2

DDL: I_EWM_SERIALNUMBERHEADER_2 Type: view_entity BASIC
7 Fields 1 Data Sources 2 Associations

Serial Number Header

I_EWM_SerialNumberHeader_2 is a Basic CDS View (Dimension) that provides data about "Serial Number Header" in SAP S/4HANA. It reads from 1 data source (/scwm/serh2) and exposes 7 fields with key fields EWMWarehouse, EntitledToDisposeParty, ProductUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/scwm/serh2 /scwm/serh2 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EWM_WarehouseNumber_2 _Warehouse $projection.EWMWarehouse = _Warehouse.EWMWarehouse
[0..1] I_BusinessPartner _BusinessPartner $projection.EntitledToDisposeParty = _BusinessPartner.BusinessPartner

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.technicalName IEWMSERH3 view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey ProductUUID view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
EndUserText.label Serial Number Header view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY EWMWarehouse lgnum Whse Number
KEY EntitledToDisposeParty entitled Party Ent. to Disp.
KEY ProductUUID Product ID
SerialNumberRequiredLevel stock Serial No. Reqm
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted Purpose Completed
_Warehouse _Warehouse
_BusinessPartner _BusinessPartner

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_EWM_SerialNumberHeader_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 I_EWM_SerialNumberHeader_2 AS
SELECT
  lgnum AS EWMWarehouse,
  entitled AS EntitledToDisposeParty,
  cast( matid as matid_no_conv preserving type ) AS ProductUUID,
  stock AS SerialNumberRequiredLevel,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM /scwm/serh2
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _Warehouse ON EWMWarehouse = _Warehouse.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON EntitledToDisposeParty = _BusinessPartner.BusinessPartner  -- association [0..1]
;

Learn More