I_CustomerMaterialLongTextTP

DDL: I_CUSTOMERMATERIALLONGTEXTTP SQL: ICUSTMATLNGTXTTP Type: view TRANSACTIONAL Package: ODATA_SD_CUSTOMER_MATERIAL
15 Fields 1 Data Sources 1 Associations

Customer Material BO Draft Text Node

I_CustomerMaterialLongTextTP is a Transactional CDS View that provides data about "Customer Material BO Draft Text Node" in SAP S/4HANA. It reads from 1 data source (P_CustomerMaterialLongText) and exposes 15 fields with key fields LongTextID, SalesOrganization, DistributionChannel, Customer, Material. It has 1 association to related views. Part of development package ODATA_SD_CUSTOMER_MATERIAL.

Data Sources (1)

SourceAliasJoin Type
P_CustomerMaterialLongText CustomerMaterial from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CustomerMaterialTP _CustomerMaterialText $projection.SalesOrganization = _CustomerMaterialText.SalesOrganization and $projection.DistributionChannel = _CustomerMaterialText.DistributionChannel and $projection.Customer = _CustomerMaterialText.Customer and $projection.Material = _CustomerMaterialText.Material

Annotations (16)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ICUSTMATLNGTXTTP view
AbapCatalog.compiler.compareFilter true view
Search.searchable false view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Customer Material BO Draft Text Node view
VDM.viewType #TRANSACTIONAL view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence ICUSMATTXTDRAFT view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #TEXT view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY LongTextID P_CustomerMaterialLongText LongTextID Text ID
KEY SalesOrganization P_CustomerMaterialLongText SalesOrganization Sales Organization
KEY DistributionChannel P_CustomerMaterialLongText DistributionChannel RefDistCh-Cust/Mat.
KEY Customer P_CustomerMaterialLongText Customer Sold-to Party
KEY Material
KEY Language P_CustomerMaterialLongText Language Report Text Language
SalesOrganizationForEdit P_CustomerMaterialLongText SalesOrganization Sales Organization
DistributionChannelForEdit P_CustomerMaterialLongText DistributionChannel RefDistCh-Cust/Mat.
CustomerForEdit P_CustomerMaterialLongText Customer Sold-to Party
MaterialForEdit
LanguageForEdit P_CustomerMaterialLongText Language Report Text Language
LongTextIDForEdit P_CustomerMaterialLongText LongTextID Text ID
LongText P_CustomerMaterialLongText LongText Text Name
LanguageISOCode P_CustomerMaterialLongText LanguageISOCode Language ISO Code
_CustomerMaterialText _CustomerMaterialText

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_CustomerMaterialLongTextTP.
-- 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: ICUSTMATLNGTXTTP

CREATE VIEW I_CustomerMaterialLongTextTP AS
SELECT
  CustomerMaterial.LongTextID AS LongTextID,
  CustomerMaterial.SalesOrganization AS SalesOrganization,
  CustomerMaterial.DistributionChannel AS DistributionChannel,
  CustomerMaterial.Customer AS Customer,
  cast (CustomerMaterial.Material as productnumber preserving type) AS Material,
  CustomerMaterial.Language AS Language,
  CustomerMaterial.SalesOrganization AS SalesOrganizationForEdit,
  CustomerMaterial.DistributionChannel AS DistributionChannelForEdit,
  CustomerMaterial.Customer AS CustomerForEdit,
  cast (CustomerMaterial.Material as productnumber preserving type) AS MaterialForEdit,
  CustomerMaterial.Language AS LanguageForEdit,
  CustomerMaterial.LongTextID AS LongTextIDForEdit,
  CustomerMaterial.LongText AS LongText,
  CustomerMaterial.LanguageISOCode AS LanguageISOCode
FROM P_CustomerMaterialLongText AS CustomerMaterial
LEFT OUTER JOIN I_CustomerMaterialTP AS _CustomerMaterialText ON SalesOrganization = _CustomerMaterialText.SalesOrganization AND DistributionChannel = _CustomerMaterialText.DistributionChannel AND Customer = _CustomerMaterialText.Customer AND Material = _CustomerMaterialText.Material  -- association [1..1]
;

Learn More