HPA_MSW_Item_Text

DDL: HPA_MSW_ITEM_TEXT SQL: HPA_MSW_ITMT Type: view Package: HPA_FND_MSW_NO_TRANSL
3 Fields 1 Data Sources

Item Text

HPA_MSW_Item_Text is a CDS View that provides data about "Item Text" in SAP S/4HANA. It reads from 1 data source (hpai_msw_itemt) and exposes 3 fields with key fields id, language. Part of development package HPA_FND_MSW_NO_TRANSL.

Data Sources (1)

SourceAliasJoin Type
hpai_msw_itemt hpai_msw_itemt from

Annotations (13)

NameValueLevelField
EndUserText.label Item Text view
AbapCatalog.sqlViewName HPA_MSW_ITMT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey id view
ClientHandling.algorithm #NONE view
ClientHandling.type #CLIENT_INDEPENDENT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.numberOfKeyFields 000 view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
KEY language language Report Text Language
name name Zone name

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 HPA_MSW_Item_Text.
-- 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: HPA_MSW_ITMT

CREATE VIEW HPA_MSW_Item_Text AS
SELECT
  id,
  language,
  name
FROM hpai_msw_itemt
;

Learn More