I_CustomerMaterialLongTextTP

DDL: I_CUSTOMERMATERIALLONGTEXTTP SQL: ICUSTMATLNGTXTTP Type: view TRANSACTIONAL Package: ODATA_SD_CUSTOMER_MATERIAL

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.

1 data source(s) 15 fields

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
KEY SalesOrganization P_CustomerMaterialLongText SalesOrganization
KEY DistributionChannel P_CustomerMaterialLongText DistributionChannel
KEY Customer P_CustomerMaterialLongText Customer
KEY Material
KEY Language P_CustomerMaterialLongText Language
SalesOrganizationForEdit P_CustomerMaterialLongText SalesOrganization
DistributionChannelForEdit P_CustomerMaterialLongText DistributionChannel
CustomerForEdit P_CustomerMaterialLongText Customer
MaterialForEdit
LanguageForEdit P_CustomerMaterialLongText Language
LongTextIDForEdit P_CustomerMaterialLongText LongTextID
LongText P_CustomerMaterialLongText LongText
LanguageISOCode P_CustomerMaterialLongText LanguageISOCode
_CustomerMaterialText _CustomerMaterialText 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ICUSTMATLNGTXTTP'
@AbapCatalog.compiler.compareFilter: true
@Search.searchable: false
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Customer Material BO Draft Text Node'
@VDM.viewType:#TRANSACTIONAL
@ObjectModel: {
  draftEnabled: true,
  writeDraftPersistence: 'ICUSMATTXTDRAFT',
  semanticKey:           ['Material','SalesOrganization','DistributionChannel','Customer'],
  representativeKey:     ['Material','SalesOrganization','DistributionChannel','Customer'],
  createEnabled:         true,
  deleteEnabled:         true,
  updateEnabled:         true,
  usageType.serviceQuality: #C,
  usageType.sizeCategory : #L,
  usageType.dataClass: #TRANSACTIONAL,
  dataCategory: #TEXT
}  

define view I_CustomerMaterialLongTextTP as select from P_CustomerMaterialLongText as CustomerMaterial
association [1..1] to I_CustomerMaterialTP as _CustomerMaterialText on $projection.SalesOrganization = _CustomerMaterialText.SalesOrganization 
                                                     and $projection.DistributionChannel = _CustomerMaterialText.DistributionChannel
                                                     and $projection.Customer = _CustomerMaterialText.Customer
                                                     and $projection.Material = _CustomerMaterialText.Material
{

 @ObjectModel.readOnly:true
  key CustomerMaterial.LongTextID,
      @ObjectModel.readOnly:true
  key CustomerMaterial.SalesOrganization,
  @ObjectModel.readOnly:true
  key CustomerMaterial.DistributionChannel,
  @ObjectModel.readOnly:true
  key CustomerMaterial.Customer,
  @ObjectModel.readOnly:true
  key cast (CustomerMaterial.Material as productnumber preserving type) as Material,
      @ObjectModel.readOnly:true
      @Semantics.language: true
  key CustomerMaterial.Language,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      CustomerMaterial.SalesOrganization    as SalesOrganizationForEdit,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      CustomerMaterial.DistributionChannel    as DistributionChannelForEdit,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      CustomerMaterial.Customer    as CustomerForEdit,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      cast (CustomerMaterial.Material as productnumber preserving type) as MaterialForEdit,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
//    @Semantics.language: true

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      CustomerMaterial.Language   as LanguageForEdit,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @ObjectModel.mandatory: true
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      CustomerMaterial.LongTextID as LongTextIDForEdit,
      @Semantics.text: true
      CustomerMaterial.LongText,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: true 
      CustomerMaterial.LanguageISOCode,
      @ObjectModel.association.type:[#TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT]
      _CustomerMaterialText
}

Learn More