I_SPECSTDCOMPOSITIONDEFINITION
Spec. Composition (Standard) Definition
I_SPECSTDCOMPOSITIONDEFINITION is a CDS View in S/4HANA. Spec. Composition (Standard) Definition. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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 | |
| P_SpecAPICustomDefinedAttrib | view | union | COMPOSITE |
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PLMI/SPC_SC_DEF"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/