I_WarrantyCounter

DDL: I_WARRANTYCOUNTER Type: view_entity BASIC Package: DWA
10 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 10 fields with key fields MasterWarranty, MasterWarrantyItem, WarrantyCounterItem. It has 2 associations to related views. Part of development package DWA.

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 (10)

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

Fields (10)

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
MstrWrntyCntrSortingOrderValue rangf Sort
_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.

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,
  rangf AS MstrWrntyCntrSortingOrderValue
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