I_ProdSpecPropertyHeader

DDL: I_PRODSPECPROPERTYHEADER SQL: IPRODSPECPRPHDR Type: view COMPOSITE Package: VDM_PLMB_SPC_PROP_CUST_OP

Product Specification Property Header

I_ProdSpecPropertyHeader is a Composite CDS View that provides data about "Product Specification Property Header" in SAP S/4HANA. It reads from 2 data sources (I_SpecCstmPropertyDefinition, R_ProdSpecPrptyHdrWithUsage) and exposes 16 fields with key fields ProdSpecPrptyDefID, ProdSpecPrptyHeader, ProdSpecPrptyHdrChangeState. It has 1 association to related views. Part of development package VDM_PLMB_SPC_PROP_CUST_OP.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_SpecCstmPropertyDefinition cust inner
R_ProdSpecPrptyHdrWithUsage header from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ProdSpecPrptyCharcValue _ProdSpecPrptyCharcValue _ProdSpecPrptyCharcValue.ProdSpecPrptyDefID = $projection.ProdSpecPrptyDefID and _ProdSpecPrptyCharcValue.ProdSpecPrptyHeader = $projection.ProdSpecPrptyHeader and _ProdSpecPrptyCharcValue.ProdSpecPrptyHdrChangeState = $projection.ProdSpecPrptyHdrChangeState

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPRODSPECPRPHDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Specification Property Header view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProdSpecPrptyDefID I_SpecCstmPropertyDefinition ProdSpecPrptyDefID
KEY ProdSpecPrptyHeader ProdSpecPrptyHeader
KEY ProdSpecPrptyHdrChangeState ProdSpecPrptyHdrChangeState
ClfnObjectID
ProductSpecificationInternalID ProductSpecificationInternalID
ProdSpecPrptyHdrValAssgmtType ProdSpecPrptyHdrValAssgmtType
ProdSpecPrptyHdrSortSequence ProdSpecPrptyHdrSortSequence
ProdSpecPrptyHdrChangeNumber ProdSpecPrptyHdrChangeNumber
ProdSpecPrptyHdrIsDeleted ProdSpecPrptyHdrIsDeleted
ProdSpecPrptyHdrRating ProdSpecPrptyHdrRating
ProdSpecPrptyHdrValidityArea ProdSpecPrptyHdrValidityArea
ProdSpecPrptyHdrValdtyStrtDte ProdSpecPrptyHdrValdtyStrtDte
ProdSpecPrptyHdrValdtyEndDte ProdSpecPrptyHdrValdtyEndDte
_ProductSpecification _ProductSpecification
_ProdSpecNonHistoric _ProdSpecNonHistoric
_ProdSpecPrptyCharcValue _ProdSpecPrptyCharcValue 
@AbapCatalog.sqlViewName: 'IPRODSPECPRPHDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Product Specification Property Header'
define view I_ProdSpecPropertyHeader
  as select from R_ProdSpecPrptyHdrWithUsage  as header

    inner join   I_SpecCstmPropertyDefinition as cust on  cust.ProdSpecPrptyDefValAssgmtType = header.ProdSpecPrptyHdrValAssgmtType
                                                      and cust.ProdSpecPrptyDefRating        = header.ProdSpecPrptyHdrRating
                                                      and cust.ProdSpecPrptyDefValidityArea  = header.ProdSpecPrptyHdrValidityArea

  association [1..*] to I_ProdSpecPrptyCharcValue as _ProdSpecPrptyCharcValue on  _ProdSpecPrptyCharcValue.ProdSpecPrptyDefID          = $projection.ProdSpecPrptyDefID
                                                                              and _ProdSpecPrptyCharcValue.ProdSpecPrptyHeader         = $projection.ProdSpecPrptyHeader
                                                                              and _ProdSpecPrptyCharcValue.ProdSpecPrptyHdrChangeState = $projection.ProdSpecPrptyHdrChangeState

{
  key cust.ProdSpecPrptyDefID,
  key ProdSpecPrptyHeader,
  key ProdSpecPrptyHdrChangeState,

      concat(ProdSpecPrptyHeader, ProdSpecPrptyHdrChangeState) as ClfnObjectID,

      ProductSpecificationInternalID,

      ProdSpecPrptyHdrValAssgmtType,
      ProdSpecPrptyHdrSortSequence,
      ProdSpecPrptyHdrChangeNumber,
      ProdSpecPrptyHdrIsDeleted,

      ProdSpecPrptyHdrRating,
      ProdSpecPrptyHdrValidityArea,

      ProdSpecPrptyHdrValdtyStrtDte,
      ProdSpecPrptyHdrValdtyEndDte,

      /* Associations */
      _ProductSpecification,
      _ProdSpecNonHistoric,
      _ProdSpecPrptyCharcValue
}
where
  _ValueAssignmentType.SpecValAssgmtCategory = 'A' // Valuation Assignment Category 'A' is dedicated for classification based valuation instances

Learn More