I_WrntyClaimVersionDocFlow

DDL: I_WRNTYCLAIMVERSIONDOCFLOW SQL: IWTYCLMVERDOCFLW Type: view BASIC

Data for Wrnty Claim Document Flow

I_WrntyClaimVersionDocFlow is a Basic CDS View that provides data about "Data for Wrnty Claim Document Flow" in SAP S/4HANA. It reads from 1 data source (I_WrntyClaimVersion) and exposes 18 fields with key fields WarrantyClaimNumber, WrntyVersionNumber, WrntyClaimHeaderUUID.

Data Sources (1)

SourceAliasJoin Type
I_WrntyClaimVersion I_WrntyClaimVersion from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWTYCLMVERDOCFLW view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Data for Wrnty Claim Document Flow view
VDM.viewType #BASIC view
ObjectModel.representativeKey WrntyClaimHeaderUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY WarrantyClaimNumber _WrntyClaimHeader WarrantyClaimNumber Claim
KEY WrntyVersionNumber WrntyVersionNumber Version
KEY WrntyClaimHeaderUUID I_WrntyClaimVersion WrntyClaimHeaderUUID Internal Number
WarrantyClaimType _WrntyClaimHeader WarrantyClaimType WtyClmType
WrntyClaimSourceObjectNumber _WrntyClaimHeader WrntyClaimSourceObjectNumber Source object
WrntyClaimTypeText
WrntyClaimHeaderText _WrntyClaimHeader WrntyClaimHeaderText Info. Clm Head.
WarrantyClaimVersionPartner WarrantyClaimVersionPartner Partner
PurchasingOrganization PurchasingOrganization Purchasing Organization
Plant _WrntyClaimHeader Plant Valuation Area
WrntySupplier _WrntyClaimHeader WrntySupplier Partner(Suplr)
CompanyCode SalesOrganization Sales Organization
FiscalYear
AccountingDocumentCategory
_WrntyClaimHeader _WrntyClaimHeader
_Supplier _WrntyClaimHeader _Supplier
_Customer _WrntyClaimHeader _Customer
WarrantyCustomer _WrntyClaimHeader WarrantyCustomer Partner

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_WrntyClaimVersionDocFlow.
-- 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: IWTYCLMVERDOCFLW

CREATE VIEW I_WrntyClaimVersionDocFlow AS
SELECT
  _WrntyClaimHeader.WarrantyClaimNumber AS WarrantyClaimNumber,
  WrntyVersionNumber,
  I_WrntyClaimVersion.WrntyClaimHeaderUUID AS WrntyClaimHeaderUUID,
  _WrntyClaimHeader.WarrantyClaimType AS WarrantyClaimType,
  _WrntyClaimHeader.WrntyClaimSourceObjectNumber AS WrntyClaimSourceObjectNumber,
  _WrntyClaimHeader._ClaimType._Text[1:Language=$session.system_language].WrntyClaimTypeText AS WrntyClaimTypeText,
  _WrntyClaimHeader.WrntyClaimHeaderText AS WrntyClaimHeaderText,
  WarrantyClaimVersionPartner,
  PurchasingOrganization,
  _WrntyClaimHeader.Plant AS Plant,
  _WrntyClaimHeader.WrntySupplier AS WrntySupplier,
  SalesOrganization AS CompanyCode,
  cast(substring(_WrntyClaimHeader.WrntyClaimCreationDate, 1, 4) as numc4) AS FiscalYear,
  cast('A' as bstat_d) AS AccountingDocumentCategory,
  _WrntyClaimHeader._Supplier AS _Supplier,
  _WrntyClaimHeader._Customer AS _Customer,
  _WrntyClaimHeader.WarrantyCustomer AS WarrantyCustomer
FROM I_WrntyClaimVersion
;