I_Productsalestextwd

DDL: I_PRODUCTSALESTEXTWD SQL: IPRDSALESTEXTWD Type: view TRANSACTIONAL
10 Fields 1 Data Sources

Product BO - Product SalesText Node

I_Productsalestextwd is a Transactional CDS View that provides data about "Product BO - Product SalesText Node" in SAP S/4HANA. It reads from 1 data source (I_Productsalestext) and exposes 10 fields with key fields Product, Language, LongTextID, ProductDistributionChnl, ProductSalesOrg.

Data Sources (1)

SourceAliasJoin Type
I_Productsalestext SalesText from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPRDSALESTEXTWD view
EndUserText.label Product BO - Product SalesText Node view
Search.searchable true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Product I_Productsalestext Product Product Sold
KEY Language I_Productsalestext Language Report Text Language
KEY LongTextID I_Productsalestext LongTextID Text ID
KEY ProductDistributionChnl I_Productsalestext ProductDistributionChnl Distr. Channel
KEY ProductSalesOrg I_Productsalestext ProductSalesOrg Sales Org.
ProductForEdit I_Productsalestext Product Product Sold
LanguageForEdit I_Productsalestext Language Report Text Language
LongTextIDForEdit I_Productsalestext LongTextID Text ID
LongText I_Productsalestext LongText Text Name
LanguageISOCode I_Productsalestext LanguageISOCode Language ISO Code

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_Productsalestextwd.
-- 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: IPRDSALESTEXTWD

CREATE VIEW I_Productsalestextwd AS
SELECT
  SalesText.Product AS Product,
  SalesText.Language AS Language,
  SalesText.LongTextID AS LongTextID,
  SalesText.ProductDistributionChnl AS ProductDistributionChnl,
  SalesText.ProductSalesOrg AS ProductSalesOrg,
  SalesText.Product AS ProductForEdit,
  SalesText.Language AS LanguageForEdit,
  SalesText.LongTextID AS LongTextIDForEdit,
  SalesText.LongText AS LongText,
  SalesText.LanguageISOCode AS LanguageISOCode
FROM I_Productsalestext AS SalesText
;

Learn More