C_ProdStrucVariantType

DDL: C_PRODSTRUCVARIANTTYPE SQL: CPSVARTYPE Type: view CONSUMPTION Package: VDM_PLMB_PSM

Prodcut Structure Variant Type

C_ProdStrucVariantType is a Consumption CDS View that provides data about "Prodcut Structure Variant Type" in SAP S/4HANA. It reads from 2 data sources (I_ProdStrucVariantType, I_ProdStrucPPEVariantType) and exposes 2 fields with key field ProductStructureVariantType. Part of development package VDM_PLMB_PSM.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_ProdStrucVariantType _CustomizeVariantType from
I_ProdStrucPPEVariantType _DefaultVariantType left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPSVARTYPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey ProductStructureVariantType view
ObjectModel.dataCategory #TEXT view
EndUserText.label Prodcut Structure Variant Type view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ProductStructureVariantType I_ProdStrucVariantType ProductStructureVariantType
Language I_ProdStrucPPEVariantType Language 
@AbapCatalog.sqlViewName: 'CPSVARTYPE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.representativeKey: 'ProductStructureVariantType'
@ObjectModel.dataCategory: #TEXT
@EndUserText.label: 'Prodcut Structure Variant Type'
define view C_ProdStrucVariantType 
   as select from I_ProdStrucVariantType as _CustomizeVariantType
    left outer join I_ProdStrucPPEVariantType as _DefaultVariantType on _CustomizeVariantType.ProductStructureVariantType = _DefaultVariantType.ProductStructureVariantType
                                                                     and _DefaultVariantType.Language = $session.system_language
{
  key _CustomizeVariantType.ProductStructureVariantType,
      case
        when _CustomizeVariantType.ProdStrucVarTypeDescription is null
            then _DefaultVariantType.ProdStrucVarTypeDescription
        else _CustomizeVariantType.ProdStrucVarTypeDescription
      end as ProdStrucVarTypeDescription,
      @UI.hidden: true
      _DefaultVariantType.Language
}

Learn More