I_PRODSPECTYPE

CDS View

Product Specification Type

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

Used by 4 CDS view(s) 1 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_ProdSpecType view from CONSUMPTION Product Specification Type
I_ProdSpecDescNonHistoric view inner COMPOSITE Product Specification Desc. Non Hist.
I_ProdSpecNonHistoric view inner COMPOSITE Product Specification Non Historic
I_ProductSpecification view inner COMPOSITE Product Specification

Fields (1)

KeyField CDS FieldsUsed in Views
SpecificationType ProdSpecType 1 
@AbapCatalog.sqlViewName: 'IPRODSPECTYP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #CUSTOMIZING

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #COMPOSITE

@EndUserText.label: 'Product Specification Type'

/* Entries in I_SpecSemanticTypeDefinition have priority over I_SpecTypeAssignedCategory, if they are defined in
   that customizing.

   The first union branch left joins with an always true condition and for each entry there will be nulls if
   I_SpecSemanticTypeDefinition has no records. If there are records in there, the first branch will yield no results
   and the records will be taken from the second union branch.
*/
define view I_ProdSpecType
  as select distinct from   I_SpecTypeAssignedCategory   as typeCateg
    left outer to many join I_SpecSemanticTypeDefinition as def on typeCateg.SpecificationType = typeCateg.SpecificationType
{
  key typeCateg.SpecificationType,
      _SpecificationType
}
where
  (
       SpecificationCategory = 'REAL'
    or SpecificationCategory = 'RAW'
    or SpecificationCategory = 'PACKAGE'
    or SpecificationCategory = 'STREAM'
  )
  and  def.SpecificationType is null

union select from I_SpecSemanticTypeDefinition
{
  key SpecificationType,
      _SpecificationType
}
where
  SpecificationSemanticType = 'PROD_SPEC'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SPECSEMANTICTYPEDEFINITION",
"I_SPECTYPEASSIGNEDCATEGORY"
],
"ASSOCIATED":
[
"I_SPECTYPE"
],
"BASE":
[
"I_SPECTYPEASSIGNEDCATEGORY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More