I_ProdSpecDescNonHistoric

DDL: I_PRODSPECDESCNONHISTORIC SQL: IPRODSPECDESCNH Type: view COMPOSITE Package: VDM_PLMB_SPC_BAS_OP

Product Specification Desc. Non Hist.

I_ProdSpecDescNonHistoric is a Composite CDS View that provides data about "Product Specification Desc. Non Hist." in SAP S/4HANA. It reads from 3 data sources (I_SpecIdnListingDefinition, I_ProdSpecNonHistoric, I_ProdSpecType) and exposes 4 fields with key field ProdSpecDescriptionInternalID. It has 2 associations to related views. Part of development package VDM_PLMB_SPC_BAS_OP.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
I_SpecIdnListingDefinition ListingCust inner
I_ProdSpecNonHistoric ProdSpecNH inner
I_ProdSpecType ProdSpecType inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProdSpecNonHistoric _ProdSpecNonHistoric _ProdSpecNonHistoric.ProductSpecificationInternalID = $projection.ProductSpecificationInternalID
[1..*] I_ProdSpecDescription _ProdSpecDescription _ProdSpecDescription.ProdSpecDescriptionInternalID = $projection.ProdSpecDescriptionInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPRODSPECDESCNH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Product Specification Desc. Non Hist. view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ProdSpecDescriptionInternalID SpecIdfgDescInternalID
ProductSpecificationInternalID SpecificationInternalID
_ProdSpecNonHistoric _ProdSpecNonHistoric
_ProdSpecDescription _ProdSpecDescription 
@AbapCatalog.sqlViewName: 'IPRODSPECDESCNH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

@EndUserText.label: 'Product Specification Desc. Non Hist.'
define view I_ProdSpecDescNonHistoric
  as select distinct from(
                 I_SpecIdentifier           as SpecIdentifier
      inner join I_SpecIdnListingDefinition as ListingCust  on  ListingCust.SpecificationIdnListing     = 'D_DEFAULT'
                                                            and ListingCust.SpecificationIdnListingPrio = '0001'
                                                            and ListingCust.SpecificationIdnListingPos  = '0002'
                                                            and ListingCust.SpecificationCategory       = ''
                                                            and ListingCust.SpecIdfgDescCategory        = SpecIdentifier.SpecIdfgDescCategory
                                                            and ListingCust.SpecIdfgDescType            = SpecIdentifier.SpecIdfgDescType
      inner join I_ProdSpecNonHistoric      as ProdSpecNH   on ProdSpecNH.ProductSpecificationInternalID = SpecIdentifier.SpecificationInternalID
      inner join I_ProdSpecType             as ProdSpecType on ProdSpecType.SpecificationType = ProdSpecNH.ProdSpecType
  )

  association [1..1] to I_ProdSpecNonHistoric as _ProdSpecNonHistoric on _ProdSpecNonHistoric.ProductSpecificationInternalID = $projection.ProductSpecificationInternalID
  association [1..*] to I_ProdSpecDescription as _ProdSpecDescription on _ProdSpecDescription.ProdSpecDescriptionInternalID = $projection.ProdSpecDescriptionInternalID

{
  key SpecIdfgDescInternalID  as ProdSpecDescriptionInternalID,

      SpecificationInternalID as ProductSpecificationInternalID,

      _ProdSpecNonHistoric,
      _ProdSpecDescription

} where SpecIdentifier.SpecIdfgDescIsDeleted = ''

Learn More