I_SPECCSTMPROPERTYDEFINITION

CDS View

Spec. (Custom) Property Definition

I_SPECCSTMPROPERTYDEFINITION is a CDS View in S/4HANA. Spec. (Custom) Property Definition. It contains 1 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 1 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_ProdSpecPrptyCharcAssignment view inner COMPOSITE Prod Spec Property Charc Assignment
A_ProdSpecPrptyDefinition view from COMPOSITE Prod Spec Property Definition
I_ProdSpecPropertyHeader view inner COMPOSITE Product Specification Property Header
P_SpecAPICustomDefinedAttrib view union COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
KEY ProdSpecPrptyDefID ProdSpecPrptyDefID 1 
@AbapCatalog.sqlViewName: 'ISPCCUSTPRPTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

@EndUserText.label: 'Spec. (Custom) Property Definition'
define view I_SpecCstmPropertyDefinition
  as select from /plmi/spc_ca_def

  association [1..*] to I_ProdSpecPropertyHeader as _ProdSpecPropertyHeader on _ProdSpecPropertyHeader.ProdSpecPrptyDefID = $projection.ProdSpecPrptyDefID
{
  key prodspecprptydefid            as ProdSpecPrptyDefID,
      prodspecprptydefvalassgmttype as ProdSpecPrptyDefValAssgmtType,
      prodspecprptydefrating        as ProdSpecPrptyDefRating,
      prodspecprptydefvalidityarea  as ProdSpecPrptyDefValidityArea,

      /* Association */
      _ProdSpecPropertyHeader
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PLMI/SPC_CA_DEF"
],
"ASSOCIATED":
[
"I_PRODSPECPROPERTYHEADER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More