I_EquipMatlSrlNumberStatus

DDL: I_EQUIPMATLSRLNUMBERSTATUS SQL: IEQMATSRLNUMSTAT Type: view COMPOSITE
24 Fields 1 Data Sources

Status of Material Serial Number

I_EquipMatlSrlNumberStatus is a Composite CDS View that provides data about "Status of Material Serial Number" in SAP S/4HANA. It reads from 1 data source (P_EquipMatlSerialNumStatusAggr) and exposes 24 fields with key fields Material, SerialNumber.

Data Sources (1)

SourceAliasJoin Type
P_EquipMatlSerialNumStatusAggr EquipMatlSerialNumStatusAggr from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IEQMATSRLNUMSTAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Status of Material Serial Number view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Material P_EquipMatlSerialNumStatusAggr Material Vehicle Model
KEY SerialNumber P_EquipMatlSerialNumStatusAggr SerialNumber Serial Number
MaintObjectInternalID P_EquipMatlSerialNumStatusAggr MaintObjectInternalID Object number
MatlSrlNmbrIsAvailable
MatlSrlNmbrIsDeleted
MatlSrlNmbrIsMrkdForDeltn
MatlSrlNmbrIsInactive
MatlSrlNmbrIsInstalled
MatlSrlNmbrIsAllcToParent
MatlSrlNmbrIsInWarehouse
MatlSrlNmbrIsAssgdToDeliv
MatlSrlNmbrIsAtCustomer
MatlSrlNmbrIsLocked
MatlSrlNmbrIsUndrCnstrctn
MatlSrlNmbrIsOnHold
MatlSrlNmbrIsIDUndefined
MatlSrlNmbrIsAssgdToJITCall
MatlSrlNmbrDocIsCreated
MatlSrlNmbrHndlgUntIsAssgd
MatlSrlNmbrInvtryIsActv
MatlSrlNmbrUUIDIsGnrtd
MatlSrlNmbrUUIDIsAttached
MatlSrlNmbrUUIDIsSent
MatlSrlNmbrUUIDIsConfd

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_EquipMatlSrlNumberStatus.
-- 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.
-- SQL view name: IEQMATSRLNUMSTAT

CREATE VIEW I_EquipMatlSrlNumberStatus AS
SELECT
  EquipMatlSerialNumStatusAggr.Material AS Material,
  EquipMatlSerialNumStatusAggr.SerialNumber AS SerialNumber,
  EquipMatlSerialNumStatusAggr.MaintObjectInternalID AS MaintObjectInternalID,
  cast( MatlSrlNmbrIsAvailable as xfeld preserving type ) AS MatlSrlNmbrIsAvailable,
  cast( MatlSrlNmbrIsDeleted as xfeld preserving type ) AS MatlSrlNmbrIsDeleted,
  cast( MatlSrlNmbrIsMrkdForDeltn as xfeld preserving type ) AS MatlSrlNmbrIsMrkdForDeltn,
  cast( MatlSrlNmbrIsInactive as xfeld preserving type ) AS MatlSrlNmbrIsInactive,
  cast( MatlSrlNmbrIsInstalled as xfeld preserving type ) AS MatlSrlNmbrIsInstalled,
  cast( MatlSrlNmbrIsAllcToParent as xfeld preserving type ) AS MatlSrlNmbrIsAllcToParent,
  cast( MatlSrlNmbrIsInWarehouse as xfeld preserving type ) AS MatlSrlNmbrIsInWarehouse,
  cast( MatlSrlNmbrIsAssgdToDeliv as xfeld preserving type ) AS MatlSrlNmbrIsAssgdToDeliv,
  cast( MatlSrlNmbrIsAtCustomer as xfeld preserving type ) AS MatlSrlNmbrIsAtCustomer,
  cast( MatlSrlNmbrIsLocked as xfeld preserving type ) AS MatlSrlNmbrIsLocked,
  cast( MatlSrlNmbrIsUndrCnstrctn as xfeld preserving type ) AS MatlSrlNmbrIsUndrCnstrctn,
  cast( MatlSrlNmbrIsOnHold as xfeld preserving type ) AS MatlSrlNmbrIsOnHold,
  cast( MatlSrlNmbrIsIDUndefined as xfeld preserving type ) AS MatlSrlNmbrIsIDUndefined,
  cast( MatlSrlNmbrIsAssgdToJITCall as xfeld preserving type ) AS MatlSrlNmbrIsAssgdToJITCall,
  cast( MatlSrlNmbrDocIsCreated as xfeld preserving type ) AS MatlSrlNmbrDocIsCreated,
  cast( MatlSrlNmbrHndlgUntIsAssgd as xfeld preserving type ) AS MatlSrlNmbrHndlgUntIsAssgd,
  cast( MatlSrlNmbrInvtryIsActv as xfeld preserving type ) AS MatlSrlNmbrInvtryIsActv,
  cast( MatlSrlNmbrUUIDIsGnrtd as xfeld preserving type ) AS MatlSrlNmbrUUIDIsGnrtd,
  cast( MatlSrlNmbrUUIDIsAttached as xfeld preserving type ) AS MatlSrlNmbrUUIDIsAttached,
  cast( MatlSrlNmbrUUIDIsSent as xfeld preserving type ) AS MatlSrlNmbrUUIDIsSent,
  cast( MatlSrlNmbrUUIDIsConfd as xfeld preserving type ) AS MatlSrlNmbrUUIDIsConfd
FROM P_EquipMatlSerialNumStatusAggr AS EquipMatlSerialNumStatusAggr
;

Learn More