I_SPECSTDCOMPOSITIONDEFINITION

CDS View

Spec. Composition (Standard) Definition

I_SPECSTDCOMPOSITIONDEFINITION is a CDS View in S/4HANA. Spec. Composition (Standard) Definition. 8 CDS views read from this table.

Used by 8 CDS view(s)

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_AllergenStatement view inner BASIC Allergen Statement
I_NutrientReferenceQuantity view inner BASIC Nutrient Reference Quantity
I_NutrientStatement view inner BASIC Nutrient Statement
I_ProdSpecAllergenCmpstnHeader view inner COMPOSITE Prod. Spec. Allergen Comp. Hdr
I_ProdSpecNutrientCmpstnHdr view inner COMPOSITE Product Specification Nut. Comp. Hdr.
I_ProdSpecStdCmpstnHeader view inner COMPOSITE Product Specification Std. Comp. Hdr.
P_PureSubstanceComponentType view from COMPOSITE Pure Subst. Component Type
P_SpecAPICustomDefinedAttrib view union COMPOSITE Spec. API Custom Defined Attributes 
@AbapCatalog.sqlViewName: 'ISPCSTDCOMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.viewType: #BASIC

@EndUserText.label: 'Spec. Composition (Standard) Definition'
define view I_SpecStdCompositionDefinition
  as select from /plmi/spc_sc_def
{
  key prodspeccmpstnheadertype       as ProdSpecCompositionType,
      prodspeccmpstnhdrvalassgmttype as ProdSpecCmpstnHdrValAssgmtType,
      prodspeccmpstnhdrrating        as ProdSpecCmpstnHdrRating,
      prodspeccmpstnhdrvalidityarea  as ProdSpecCmpstnHdrValidityArea,
      prodspeccmpstnspectype         as ProdSpecCmpstnSpecType,
      prodspeccmpstngroupspectype    as ProdSpecCmpstnGroupSpecType
}

Learn More