I_PRODSPECSTDCMPSTNHEADER

CDS View

Product Specification Std. Comp. Hdr.

I_PRODSPECSTDCMPSTNHEADER is a CDS View in S/4HANA. Product Specification Std. Comp. Hdr.. It contains 3 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 3 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProdSpecStdCmpstn view inner COMPOSITE Product Specification Std. Composition
I_ProdSpecStdCmpstnHeaderTP view_entity from TRANSACTIONAL Product Specification Std. Comp. Hdr. (TP)

Fields (3)

KeyField CDS FieldsUsed in Views
_ProdSpecificationLastChange _ProdSpecificationLastChange 1
ProdSpecCmpstnHeader ProdSpecCmpstnHeader 1
ProductSpecificationInternalID ProductSpecificationInternalID 1 
@AbapCatalog.sqlViewName: 'IPRODSPCOMPSH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

@EndUserText.label: 'Product Specification Std. Comp. Hdr.'
define view I_ProdSpecStdCmpstnHeader
  as select from R_ProdSpecCmpstnHdrWithUsage   as HeaderWUsage

    inner join   I_SpecStdCompositionDefinition as SpecStdCompositionDefinition on  SpecStdCompositionDefinition.ProdSpecCompositionType        = 'STANDARD_COMPOSITION'
                                                                                and SpecStdCompositionDefinition.ProdSpecCmpstnHdrValAssgmtType = HeaderWUsage.ProdSpecCmpstnHdrValAssgmtType
                                                                                and SpecStdCompositionDefinition.ProdSpecCmpstnHdrRating        = HeaderWUsage.ProdSpecCmpstnHdrRating
                                                                                and SpecStdCompositionDefinition.ProdSpecCmpstnHdrValidityArea  = HeaderWUsage.ProdSpecCmpstnHdrValidityArea

  association [0..*] to I_ProdSpecStdCmpstn as _ProdSpecStdCmpstn on  _ProdSpecStdCmpstn.ProdSpecCmpstnHeader          = $projection.ProdSpecCmpstnHeader
                                                                  and _ProdSpecStdCmpstn.ProdSpecCompItemValdtyStrtDte <= $projection.ProdSpecCmpstnHdrValdtyStrtDte
                                                                  and _ProdSpecStdCmpstn.ProdSpecCompItemValdtyEndDte  >= $projection.ProdSpecCmpstnHdrValdtyEndDte

{
  key ProdSpecCmpstnHeader,
  key ProdSpecCmpstnHdrChangeState,

      ProductSpecificationInternalID,

      ProdSpecCmpstnHdrChangeNumber,
      ProdSpecCmpstnHdrSortSequence,

      ProdSpecCmpstnHdrValdtyStrtDte,
      ProdSpecCmpstnHdrValdtyEndDte,
      ProdSpecCmpstnHdrIsDeleted,

      HeaderWUsage.ProdSpecCmpstnHdrValAssgmtType,
      HeaderWUsage.ProdSpecCmpstnHdrRating,
      HeaderWUsage.ProdSpecCmpstnHdrValidityArea,

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

      // Associations

      _ProductSpecification,
      _ProdSpecNonHistoric,
      _ProdSpecificationLastChange
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SPECSTDCOMPOSITIONDEFINITION",
"I_SPECVALASSGMTREFERENCEVALUE",
"R_PRODSPECCMPSTNHDRWITHUSAGE"
],
"ASSOCIATED":
[
"I_PRODSPECIFICATIONLASTCHANGE",
"I_PRODSPECNONHISTORIC",
"I_PRODSPECSTDCMPSTN",
"I_PRODUCTSPECIFICATION"
],
"BASE":
[
"R_PRODSPECCMPSTNHDRWITHUSAGE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More