I_PRODUCTTYPE

CDS View

Product Type

I_PRODUCTTYPE is a CDS View in S/4HANA. Product Type. It contains 6 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 6 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_ExciseTaxProductType view from BASIC Product Type and Text
A_ProductType view from COMPOSITE Product type view
Crms4v_Product view left_outer Common Product Data with All Texts
I_ProductTypeVH view from COMPOSITE Product Type Value Help
I_ProdValnClassByProdTypeVH view inner COMPOSITE Value Help: Valuation Class for Product Type
I_SubscrpnProductTypeVH view from COMPOSITE Value help view for Subscription Product Type

Fields (6)

KeyField CDS FieldsUsed in Views
KEY ProductType ProductType 3
_Text _Text 1
AuthorizationGroup AuthorizationGroup,ProductTypeAuthorizationGroup 3
MaintenanceStatus MaintenanceStatus 1
ProductTypeCode ProductTypeCode 1
ReferenceProductType ReferenceProductType 1 
@AbapCatalog:{
  sqlViewName: 'IPRODTYPE',
  compiler.compareFilter: true,
  preserveKey: true,
  buffering: {
    status: #ACTIVE,
    type: #GENERIC,
    numberOfKeyFields: 1
  }
 }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_ProductType_2'
@EndUserText.label: 'Product Type'
@ObjectModel:{
  representativeKey: 'ProductType',
  usageType: {
    serviceQuality: #A,
    sizeCategory : #L,
    dataClass: #CUSTOMIZING
  },
  dataCategory: #VALUE_HELP,
  supportedCapabilities: [ #SQL_DATA_SOURCE,
                           #CDS_MODELING_DATA_SOURCE,
                           #CDS_MODELING_ASSOCIATION_TARGET,
                           #SEARCHABLE_ENTITY,
                           #VALUE_HELP_PROVIDER,
                           #ANALYTICAL_DIMENSION,
                           #EXTRACTION_DATA_SOURCE
  ]
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
@Analytics:{
    dataCategory: #DIMENSION,
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture.automatic: true
    }
}
@Consumption.ranked: true

define view I_Producttype
  as select from t134
  association [0..*] to I_ProductTypeText as _Text            on $projection.ProductType = _Text.ProductType
  association [0..1] to I_ProductTypeCode as _ProductTypeCode on $projection.ProductTypeCode = _ProductTypeCode.ProductTypeCode

{
      @ObjectModel.text.association: '_Text'
      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
       }
  key cast(t134.mtart as producttype preserving type ) as ProductType,
      @ObjectModel.foreignKey.association:'_ProductTypeCode'
      prod_type_code                                   as ProductTypeCode,
      t134.begru                                       as AuthorizationGroup,
      t134.pstat                                       as MaintenanceStatus,
      t134.mtref                                       as ReferenceProductType,
      t134.kkref                                       as AcctCategoryRef,
      _Text,
      _ProductTypeCode

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T134"
],
"ASSOCIATED":
[
"I_PRODUCTTYPECODE",
"I_PRODUCTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More