I_WarrantyCounter

DDL: I_WARRANTYCOUNTER SQL: IWARRANTYCNTR Type: view BASIC
9 Fields 1 Data Sources 2 Associations

Warranty Counter

I_WarrantyCounter is a Basic CDS View (Dimension) that provides data about "Warranty Counter" in SAP S/4HANA. It reads from 1 data source (bgmz) and exposes 9 fields with key fields MasterWarranty, MasterWarrantyItem, WarrantyCounterItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
bgmz bgmz from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MasterWarranty _MasterWarranty $projection.MasterWarranty = _MasterWarranty.MasterWarranty
[0..1] I_MasterWarrantyItem _MasterWarrantyItem $projection.MasterWarranty = _MasterWarrantyItem.MasterWarranty and $projection.MasterWarrantyItem = _MasterWarrantyItem.MasterWarrantyItem

Annotations (11)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MasterWarranty mganr Master warranty
KEY MasterWarrantyItem posnm Item number
KEY WarrantyCounterItem gazps WarrCount.Itm
WarrantyCounter gazna WarrCounter
CharcInternalID gazal IntNoWarrtyCntr
WarrantyCounterValue gazwt WarrCountValue
WrntyCntrValUnitOfMsmt recdu DocMeasUnit
_MasterWarranty _MasterWarranty
_MasterWarrantyItem _MasterWarrantyItem

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_WarrantyCounter.
-- 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: IWARRANTYCNTR

CREATE VIEW I_WarrantyCounter AS
SELECT
  mganr AS MasterWarranty,
  posnm AS MasterWarrantyItem,
  gazps AS WarrantyCounterItem,
  gazna AS WarrantyCounter,
  gazal AS CharcInternalID,
  gazwt AS WarrantyCounterValue,
  recdu AS WrntyCntrValUnitOfMsmt
FROM bgmz
LEFT OUTER JOIN I_MasterWarranty AS _MasterWarranty ON MasterWarranty = _MasterWarranty.MasterWarranty  -- association [0..1]
LEFT OUTER JOIN I_MasterWarrantyItem AS _MasterWarrantyItem ON MasterWarranty = _MasterWarrantyItem.MasterWarranty AND MasterWarrantyItem = _MasterWarrantyItem.MasterWarrantyItem  -- association [0..1]
;

Learn More