R_EquipMatlSrlNmbrWarrantyTP

DDL: R_EQUIPMATLSRLNMBRWARRANTYTP Type: view_entity TRANSACTIONAL
13 Fields 1 Data Sources

Material Serial Number Warranty - TP

R_EquipMatlSrlNmbrWarrantyTP is a Transactional CDS View that provides data about "Material Serial Number Warranty - TP" in SAP S/4HANA. It reads from 1 data source (I_EquipMatlSrlNumberWarranty) and exposes 13 fields with key fields Material, SerialNumber, Equipment, WarrantyCategory.

Data Sources (1)

SourceAliasJoin Type
I_EquipMatlSrlNumberWarranty EquipmentData from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Material Serial Number Warranty - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name Equipment view

Fields (13)

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
AuthorizationGroup AuthorizationGroup AuthorizGroup
_WarrantyType _WarrantyType
_MasterWarranty _MasterWarranty

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

Learn More