I_ProductTypeText

DDL: I_PRODUCTTYPETEXT Type: view BASIC

Product Type - Text

I_ProductTypeText is a Basic CDS View that provides data about "Product Type - Text" in SAP S/4HANA. It reads from 1 data source (t134t) and exposes 5 fields with key fields ProductType, Language. It has 2 associations to related views. It is exposed through 1 OData service (UI_RFM_PO_MNG). It is used in 1 Fiori application: Manage Purchase Orders - Fashion.

Data Sources (1)

SourceAliasJoin Type
t134t t134t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Producttype _ProductType $projection.ProductType = _ProductType.ProductType
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName IPRODTYPTXT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
VDM.viewType #BASIC view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_ProductTypeText_2 view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Product Type - Text view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ProductType view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RFM_PO_MNG UI_RFM_PO_MNG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5391 Manage Purchase Orders - Fashion Transactional

Manage Purchase Orders - Fashion

Business Role: Purchaser (Retail)

With this app, you can now consolidate purchase order items into an existing purchase order based on the settings in the rule maintained using the Configure Purchase Order Consolidation Rule app.

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProductType
KEY Language t134t spras
MaterialTypeName Product Type Description
_Language _Language
_ProductType _ProductType
@AbapCatalog:{
  sqlViewName: 'IPRODTYPTXT',
  preserveKey: true,
  compiler.compareFilter: true,
  buffering:{
    status: #ACTIVE,
    type: #GENERIC,
    numberOfKeyFields: 1
  }
 }
//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }

@VDM.viewType: #BASIC
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_ProductTypeText_2'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Product Type - Text'
@ObjectModel:{
  dataCategory: #TEXT,
  representativeKey: 'ProductType',
  supportedCapabilities: [ #SQL_DATA_SOURCE,
                           #CDS_MODELING_DATA_SOURCE,
                           #CDS_MODELING_ASSOCIATION_TARGET,
                           #SEARCHABLE_ENTITY,
                           #LANGUAGE_DEPENDENT_TEXT,
                           #EXTRACTION_DATA_SOURCE
  ],
  usageType:{
    serviceQuality: #A,
    sizeCategory : #L,
    dataClass: #CUSTOMIZING
  }
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
@Analytics:{
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture.automatic: true
    }
}
define view I_ProductTypeText
  as select from t134t

  association [0..1] to I_Producttype as _ProductType on $projection.ProductType = _ProductType.ProductType
  association [0..1] to I_Language    as _Language    on $projection.Language = _Language.Language

{
      @ObjectModel.foreignKey.association: '_ProductType'
  key cast(t134t.mtart as producttype preserving type )     as ProductType,
      @Semantics.language: true
  key t134t.spras                                           as Language,
      @Semantics.text: true
      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      @EndUserText.label: 'Product Type Description'
      cast(t134t.mtbez as producttypename preserving type ) as MaterialTypeName,

      _Language,
      _ProductType
}