I_PRSPCOMPEXCPTNCODEBYCMPSTN

CDS View

Exception Code for Components by Cmpstn

I_PRSPCOMPEXCPTNCODEBYCMPSTN is a CDS View in S/4HANA. Exception Code for Components by Cmpstn. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_PrSpCompExcptnCodeByCmpstn view from COMPOSITE Exception Code for Components by Cmpstn 
@AbapCatalog.sqlViewName: 'IPRSEXCCMPSTN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

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

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

@EndUserText.label: 'Exception Code for Components by Cmpstn'
define view I_PrSpCompExcptnCodeByCmpstn
  as
  // C based VATs

  select from  P_ProdSpecCmpstnObjParamPrio
    inner join I_SpecObjParamExcptnCodeAssgmt on  P_ProdSpecCmpstnObjParamPrio.SpecificationCategory         = I_SpecObjParamExcptnCodeAssgmt.SpecificationCategory
                                              and P_ProdSpecCmpstnObjParamPrio.SpecificationContextParameter = I_SpecObjParamExcptnCodeAssgmt.SpecificationContextParameter
                                              and P_ProdSpecCmpstnObjParamPrio.SpecValAssgmtType             = I_SpecObjParamExcptnCodeAssgmt.SpecValAssgmtType

  association [1..1] to I_ProdSpecCompositionTypeAll as _ProdSpecCompositionTypeAll on $projection.ProdSpecCompositionType = _ProdSpecCompositionTypeAll.ProdSpecCompositionType
{
  key ProdSpecCompositionType,
  key cast(SpecComponentExceptionCode as /plmb/spc_comp_exception_code preserving type ) as ProdSpecComponentExceptionCode,
      _ProdSpecCompositionTypeAll

}
// RMS_D and RMS_N based VATs

union select from I_SpecCstmCmpstnDefinition     as compositionDefinition
  inner join      I_SpecValAssgmtType            as vat  on compositionDefinition.ProdSpecCmpstnHdrValAssgmtType = vat.SpecValAssgmtType
  inner join      I_RecipeCalcExcptnCodePriority as calc on compositionDefinition.ProdSpecCmpstnSpecType = calc.SpecificationType

association [1..1] to I_ProdSpecCompositionTypeAll as _ProdSpecCompositionTypeAll on $projection.ProdSpecCompositionType = _ProdSpecCompositionTypeAll.ProdSpecCompositionType
{
  key ProdSpecCompositionType,
  key cast(SpecComponentExceptionCode as /plmb/spc_comp_exception_code preserving type ) as ProdSpecComponentExceptionCode,
      _ProdSpecCompositionTypeAll
}
where
     vat.SpecValAssgmtCategory = 'RMS_N'
  or vat.SpecValAssgmtCategory = 'RMS_D'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECIPECALCEXCPTNCODEPRIORITY",
"I_SPECCSTMCMPSTNDEFINITION",
"I_SPECOBJPARAMEXCPTNCODEASSGMT",
"I_SPECVALASSGMTTYPE",
"P_PRODSPECCMPSTNOBJPARAMPRIO"
],
"ASSOCIATED":
[
"I_PRODSPECCOMPOSITIONTYPEALL"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More