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.

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 Spec. API Custom Defined Attributes

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
}