P_PureSubstanceComponentType

DDL: P_PURESUBSTANCECOMPONENTTYPE SQL: PPURESUBSTCOMPT Type: view COMPOSITE Package: VDM_PLMB_SPC_BAS_OP

Pure Subst. Component Type

P_PureSubstanceComponentType is a Composite CDS View that provides data about "Pure Subst. Component Type" in SAP S/4HANA. It reads from 1 data source (I_SpecStdCompositionDefinition) and exposes 3 fields with key fields SpecificationCategory, SpecificationContextParameter, SpecValAssgmtType. Part of development package VDM_PLMB_SPC_BAS_OP.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_SpecStdCompositionDefinition specStdCompositionDefinition from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPURESUBSTCOMPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.private true view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SpecificationCategory
KEY SpecificationContextParameter
KEY SpecValAssgmtType 
@AbapCatalog.sqlViewName: 'PPURESUBSTCOMPT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.private: true
@VDM.lifecycle.contract.type: #NONE
@VDM.viewType: #COMPOSITE

define view P_PureSubstanceComponentType
  as select from           I_SpecStdCompositionDefinition as specStdCompositionDefinition
    left outer to one join I_SpecObjParameterAssignment   as custSpecific on  custSpecific.SpecValAssgmtType             = specStdCompositionDefinition.ProdSpecCmpstnHdrValAssgmtType
                                                                          and custSpecific.SpecificationCategory         = 'SUBSTANCE'
                                                                          and custSpecific.SpecificationContextParameter = 'SUB_COMP_STD_DIALOG'
    left outer to one join I_SpecObjParameterAssignment   as custDefault  on  custDefault.SpecValAssgmtType             = ''
                                                                          and custDefault.SpecificationCategory         = 'SUBSTANCE'
                                                                          and custDefault.SpecificationContextParameter = 'SUB_COMP_STD_DIALOG'

{
  key coalesce( custSpecific.SpecificationCategory, custDefault.SpecificationCategory )                 as SpecificationCategory,
  key coalesce( custSpecific.SpecificationContextParameter, custDefault.SpecificationContextParameter ) as SpecificationContextParameter,
  key coalesce( custSpecific.SpecValAssgmtType, custDefault.SpecValAssgmtType )                         as SpecValAssgmtType
}
where
  specStdCompositionDefinition.ProdSpecCompositionType = 'STANDARD_COMPOSITION'

Learn More