I_WrntyClaimItemTypeCatalogTxt

DDL: I_WRNTYCLAIMITEMTYPECATALOGTXT Type: view_entity BASIC Package: VDM_LO_WTY

Warranty Item Type Catalog - Text

I_WrntyClaimItemTypeCatalogTxt (Basic)

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

Warranty Management

I_WrntyClaimItemTypeCatalogTxt is a Basic CDS View that provides data about "Warranty Item Type Catalog - Text" in SAP S/4HANA. It reads from 1 data source (/sapcem/kattext) and exposes 6 fields with key fields WrntyCatalogCode, WrntyNumberInCatalog, Language. It has 2 associations to related views. Part of development package VDM_LO_WTY.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessWarranty Management
Application ComponentLO-WTY
CapabilitiesData Source for Data Extraction,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageWarranty Management for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering questions about all relevant aspects of warranty item type catalog.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
/sapcem/kattext /sapcem/kattext from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_WrntyClaimItemTypeCatalog _WrntyClaimItemTypeCatalog $projection.WrntyCatalogCode = _WrntyClaimItemTypeCatalog.WrntyCatalogCode
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Warranty Item Type Catalog - Text view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #TEXT view
Analytics.technicalName IWRNTYITMTCLGTXT view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY WrntyCatalogCode katkz Catalog Code
KEY WrntyNumberInCatalog katnr Number in Catalog
KEY Language langu Primary lang.
WrntyNumberInCatalogText ltext Catalog Text for Structure Display
_Language _Language
_WrntyClaimItemTypeCatalog _WrntyClaimItemTypeCatalog

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_WrntyClaimItemTypeCatalogTxt.
-- 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_WrntyClaimItemTypeCatalogTxt AS
SELECT
  katkz AS WrntyCatalogCode,
  katnr AS WrntyNumberInCatalog,
  langu AS Language,
  ltext AS WrntyNumberInCatalogText
FROM /sapcem/kattext
LEFT OUTER JOIN I_WrntyClaimItemTypeCatalog AS _WrntyClaimItemTypeCatalog ON WrntyCatalogCode = _WrntyClaimItemTypeCatalog.WrntyCatalogCode  -- association [1..*]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;