P_CustomerMaterialLongText

DDL: P_CUSTOMERMATERIALLONGTEXT SQL: PSDCUSTMATTXT Type: view BASIC Package: ODATA_SD_CUSTOMER_MATERIAL
8 Fields 2 Data Sources

Customer Material Text Active Entity

P_CustomerMaterialLongText is a Basic CDS View that provides data about "Customer Material Text Active Entity" in SAP S/4HANA. It reads from 2 data sources (custmat_txt, stxl) and exposes 8 fields with key fields SalesOrganization, DistributionChannel, Customer, Material, Language. Part of development package ODATA_SD_CUSTOMER_MATERIAL.

Data Sources (2)

SourceAliasJoin Type
custmat_txt custmat_txt left_outer
stxl stxl from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PSDCUSTMATTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization
KEY DistributionChannel
KEY Customer
KEY Material
KEY Language
LongTextID stxl tdid Text ID Header
LongText custmat_txt longtext Text Name
LanguageISOCode

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 P_CustomerMaterialLongText.
-- 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: PSDCUSTMATTXT

CREATE VIEW P_CustomerMaterialLongText AS
SELECT
  substring(stxl.tdname, 1, 4) AS SalesOrganization,
  substring(stxl.tdname, 5, 2) AS DistributionChannel,
  substring(stxl.tdname, 7, 10) AS Customer,
  substring(stxl.tdname, 17, 40) AS Material,
  cast( stxl.tdspras as spras ) AS Language,
  stxl.tdid AS LongTextID,
  custmat_txt.longtext AS LongText,
  cast('' as laiso) AS LanguageISOCode
FROM stxl
LEFT OUTER JOIN custmat_txt ON /* join condition not captured in parsed metadata */
;

Learn More