I_MasterWarranty

DDL: I_MASTERWARRANTY SQL: IMASTERWARRANTY Type: view BASIC
19 Fields 1 Data Sources 3 Associations

Master Warranty

I_MasterWarranty (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Asset Management

I_MasterWarranty is a Basic CDS View (Dimension) that provides data about "Master Warranty" in SAP S/4HANA. It reads from 1 data source (bgmk) and exposes 19 fields with key field MasterWarranty. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-EQM-SF-WA
CapabilitiesData Source for Defining CDS Entities
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
bgmk bgmk from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_MasterWarrantyText _MasterWarrantyText $projection.MasterWarranty = _MasterWarrantyText.MasterWarranty
[0..1] I_WarrantyType _WarrantyType $projection.WarrantyType = _WarrantyType.WarrantyType
[0..1] E_MasterWarranty _Extension $projection.MasterWarranty = _Extension.MasterWarranty

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMASTERWARRANTY view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Warranty view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
ObjectModel.representativeKey MasterWarranty view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MasterWarranty mganr Master warranty number
WarrantyType gaart Warranty type
ValidityStartDate datab Validity period
ValidityEndDate datbi Validity period
ExternalWarranty exgar External warranty number
WarrantySortField gasor Warranty sort field
WarrantyGroup gagrp Warranty group
CreationDate erdat Record Created On
CreatedByUser ernam Name of Person Responsible for Creating the Object
LastChangeDate aedat Last Changed On
LastChangedByUser aenam Name of Person Who Changed Object
AuthorizationGroup begru Authorization Group
IsDeleted lvorm Deletion Indicator
ObjectInternalID objnr Val. Obj. No.
PartnerSchema pargr Partner Determination Procedure
Language lange Language key for creation
MasterWarrantyChangeDateTime lastchangedatetime Last Changed On
_MasterWarrantyText _MasterWarrantyText
_WarrantyType _WarrantyType

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_MasterWarranty.
-- 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: IMASTERWARRANTY

CREATE VIEW I_MasterWarranty AS
SELECT
  mganr AS MasterWarranty,
  gaart AS WarrantyType,
  datab AS ValidityStartDate,
  datbi AS ValidityEndDate,
  exgar AS ExternalWarranty,
  gasor AS WarrantySortField,
  gagrp AS WarrantyGroup,
  erdat AS CreationDate,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aenam AS LastChangedByUser,
  begru AS AuthorizationGroup,
  lvorm AS IsDeleted,
  objnr AS ObjectInternalID,
  pargr AS PartnerSchema,
  lange AS Language,
  lastchangedatetime AS MasterWarrantyChangeDateTime
FROM bgmk
LEFT OUTER JOIN I_MasterWarrantyText AS _MasterWarrantyText ON MasterWarranty = _MasterWarrantyText.MasterWarranty  -- association [0..*]
LEFT OUTER JOIN I_WarrantyType AS _WarrantyType ON WarrantyType = _WarrantyType.WarrantyType  -- association [0..1]
LEFT OUTER JOIN E_MasterWarranty AS _Extension ON MasterWarranty = _Extension.MasterWarranty  -- association [0..1]
;

Learn More