I_PRODSPECPROPERTYHEADER

CDS View

Product Specification Property Header

I_PRODSPECPROPERTYHEADER is a CDS View in S/4HANA. Product Specification Property Header. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProdSpecPropertyHeaderTP view_entity from TRANSACTIONAL Product Specification Property Header TP
I_ProdSpecPrptyCharcValue view from COMPOSITE Product Specification Property Value by Characteristic 
@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 

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SPECCSTMPROPERTYDEFINITION",
"I_SPECVALASSGMTTYPE",
"R_PRODSPECPRPTYHDRWITHUSAGE"
],
"ASSOCIATED":
[
"I_PRODSPECNONHISTORIC",
"I_PRODSPECPRPTYCHARCVALUE",
"I_PRODUCTSPECIFICATION"
],
"BASE":
[
"R_PRODSPECPRPTYHDRWITHUSAGE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More