I_ProdSpecPropertyHeader

DDL: I_PRODSPECPROPERTYHEADER SQL: IPRODSPECPRPHDR Type: view COMPOSITE

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.

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 

/*+[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