I_ProductTypeText
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)
| Source | Alias | Join Type |
|---|---|---|
| t134t | t134t | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_Producttype | _ProductType | $projection.ProductType = _ProductType.ProductType |
| [0..1] | I_Language | _Language | $projection.Language = _Language.Language |
Annotations (21)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| UI_RFM_PO_MNG | UI_RFM_PO_MNG | V2 | C1 | NOT_RELEASED |
Fiori Apps (1)
| App ID | App Name | Type | Description |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA