A_EquipMatlSrlNmbrVndrWrnty

DDL: A_EQUIPMATLSRLNMBRVNDRWRNTY Type: view_entity CONSUMPTION
10 Fields 1 Data Sources

Material Serial Number Vendor Warranty

A_EquipMatlSrlNmbrVndrWrnty is a Consumption CDS View that provides data about "Material Serial Number Vendor Warranty" in SAP S/4HANA. It reads from 1 data source (R_EquipMatlSrlNmbrVndrWrntyTP) and exposes 10 fields with key fields Material, SerialNumber, Equipment, WarrantyCategory.

Data Sources (1)

SourceAliasJoin Type
R_EquipMatlSrlNmbrVndrWrntyTP R_EquipMatlSrlNmbrVndrWrntyTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Material Serial Number Vendor Warranty view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name MaterialSerialNumberVendorWarranty_Type view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY SerialNumber SerialNumber Serial Number
KEY Equipment Equipment Equipment check
KEY WarrantyCategory WarrantyCategory
WarrantyType WarrantyType
MasterWarranty MasterWarranty
WarrantyStartDate WarrantyStartDate
WarrantyEndDate WarrantyEndDate
WrntyIsInhtdFromSuperiorObject WrntyIsInhtdFromSuperiorObject
WrntyIsPassedOnToChildObject WrntyIsPassedOnToChildObject

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_EquipMatlSrlNmbrVndrWrnty.
-- 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_EquipMatlSrlNmbrVndrWrnty AS
SELECT
  Material,
  SerialNumber,
  Equipment,
  WarrantyCategory,
  WarrantyType,
  MasterWarranty,
  WarrantyStartDate,
  WarrantyEndDate,
  WrntyIsInhtdFromSuperiorObject,
  WrntyIsPassedOnToChildObject
FROM R_EquipMatlSrlNmbrVndrWrntyTP
;

Learn More