I_ProdSpecCmpstnHeader

DDL: I_PRODSPECCMPSTNHEADER SQL: IPRODSPECCMPHDR Type: view COMPOSITE

Prod. Spec. Compostion Hdr.

I_ProdSpecCmpstnHeader is a Composite CDS View that provides data about "Prod. Spec. Compostion Hdr." in SAP S/4HANA. It reads from 3 data sources (I_SpecCstmCmpstnDefinition, R_ProdSpecCmpstnHdrWithUsage, I_SpecValAssgmtType) and exposes 18 fields with key fields ProdSpecCmpstnHeader, ProdSpecCmpstnHdrChangeState, ProdSpecCompositionType. It has 1 association to related views.

3 data source(s) 18 fields

Data Sources (3)

SourceAliasJoin Type
I_SpecCstmCmpstnDefinition cust inner
R_ProdSpecCmpstnHdrWithUsage ProdSpecCmpstnHdrWithUsage from
I_SpecValAssgmtType vat inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ProdSpecCmpstn _ProdSpecCmpstn _ProdSpecCmpstn.ProdSpecCmpstnHeader = $projection.ProdSpecCmpstnHeader and _ProdSpecCmpstn.ProdSpecCompItemValdtyStrtDte <= $projection.ProdSpecCmpstnHdrValdtyStrtDte and _ProdSpecCmpstn.ProdSpecCompItemValdtyEndDte >= $projection.ProdSpecCmpstnHdrValdtyEndDte

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPRODSPECCMPHDR 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 Prod. Spec. Compostion Hdr. view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProdSpecCmpstnHeader ProdSpecCmpstnHeader
KEY ProdSpecCmpstnHdrChangeState ProdSpecCmpstnHdrChangeState
KEY ProdSpecCompositionType I_SpecCstmCmpstnDefinition ProdSpecCompositionType
ProductSpecificationInternalID ProductSpecificationInternalID
ProdSpecCmpstnHdrChangeNumber ProdSpecCmpstnHdrChangeNumber
ProdSpecCmpstnHdrSortSequence ProdSpecCmpstnHdrSortSequence
ProdSpecCmpstnHdrValdtyStrtDte ProdSpecCmpstnHdrValdtyStrtDte
ProdSpecCmpstnHdrValdtyEndDte ProdSpecCmpstnHdrValdtyEndDte
ProdSpecCmpstnHdrIsDeleted ProdSpecCmpstnHdrIsDeleted
ProdSpecCmpstnHdrValAssgmtType R_ProdSpecCmpstnHdrWithUsage ProdSpecCmpstnHdrValAssgmtType
ProdSpecCmpstnHdrRating R_ProdSpecCmpstnHdrWithUsage ProdSpecCmpstnHdrRating
ProdSpecCmpstnHdrValidityArea R_ProdSpecCmpstnHdrWithUsage ProdSpecCmpstnHdrValidityArea
ProdSpecCmpstnHdrRefValueCode
ProdSpecCmpstnHdrRefValueDim
_ProductSpecification _ProductSpecification
_ProdSpecNonHistoric _ProdSpecNonHistoric
_ProdSpecCmpstn _ProdSpecCmpstn
_ProdSpecificationLastChange _ProdSpecificationLastChange 
@AbapCatalog.sqlViewName: 'IPRODSPECCMPHDR'
@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: 'Prod. Spec. Compostion Hdr.'
define view I_ProdSpecCmpstnHeader
  as select from R_ProdSpecCmpstnHdrWithUsage as ProdSpecCmpstnHdrWithUsage

    inner join   I_SpecCstmCmpstnDefinition   as cust on  cust.ProdSpecCmpstnHdrValAssgmtType = ProdSpecCmpstnHdrWithUsage.ProdSpecCmpstnHdrValAssgmtType
                                                      and cust.ProdSpecCmpstnHdrRating        = ProdSpecCmpstnHdrWithUsage.ProdSpecCmpstnHdrRating
                                                      and cust.ProdSpecCmpstnHdrValidityArea  = ProdSpecCmpstnHdrWithUsage.ProdSpecCmpstnHdrValidityArea

    inner join   I_SpecValAssgmtType          as vat  on ProdSpecCmpstnHdrWithUsage.ProdSpecCmpstnHdrValAssgmtType = vat.SpecValAssgmtType

  association [1..*] to I_ProdSpecCmpstn as _ProdSpecCmpstn on  _ProdSpecCmpstn.ProdSpecCmpstnHeader          = $projection.ProdSpecCmpstnHeader
                                                            and _ProdSpecCmpstn.ProdSpecCompItemValdtyStrtDte <= $projection.ProdSpecCmpstnHdrValdtyStrtDte
                                                            and _ProdSpecCmpstn.ProdSpecCompItemValdtyEndDte  >= $projection.ProdSpecCmpstnHdrValdtyEndDte

{
  key    ProdSpecCmpstnHeader,
  key    ProdSpecCmpstnHdrChangeState,
  key    cust.ProdSpecCompositionType,

         ProductSpecificationInternalID,

         ProdSpecCmpstnHdrChangeNumber,
         ProdSpecCmpstnHdrSortSequence,

         ProdSpecCmpstnHdrValdtyStrtDte,
         ProdSpecCmpstnHdrValdtyEndDte,
         ProdSpecCmpstnHdrIsDeleted,

         ProdSpecCmpstnHdrWithUsage.ProdSpecCmpstnHdrValAssgmtType,
         ProdSpecCmpstnHdrWithUsage.ProdSpecCmpstnHdrRating,
         ProdSpecCmpstnHdrWithUsage.ProdSpecCmpstnHdrValidityArea,

         cast(ProdSpecCmpstnHdrWithUsage.SpecValAssgmtRefValueCode as /plmb/spc_comp_hdr_ref_v_code preserving type )                                  as ProdSpecCmpstnHdrRefValueCode,
         cast(ProdSpecCmpstnHdrWithUsage._SpecValAssgmtReferenceValue.SpecValAssgmtRefValueDimension as /plmb/spc_comp_hdr_ref_v_dim preserving type ) as ProdSpecCmpstnHdrRefValueDim,

         //Associations

         _ProductSpecification,
         _ProdSpecNonHistoric,
         _ProdSpecCmpstn,
         _ProdSpecificationLastChange

}
where
  vat.SpecValAssgmtCategory = 'C'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SPECCSTMCMPSTNDEFINITION",
"I_SPECVALASSGMTREFERENCEVALUE",
"I_SPECVALASSGMTTYPE",
"R_PRODSPECCMPSTNHDRWITHUSAGE"
],
"ASSOCIATED":
[
"I_PRODSPECCMPSTN",
"I_PRODSPECIFICATIONLASTCHANGE",
"I_PRODSPECNONHISTORIC",
"I_PRODUCTSPECIFICATION"
],
"BASE":
[
"R_PRODSPECCMPSTNHDRWITHUSAGE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More