A_ProdSpecComponent

DDL: A_PRODSPECCOMPONENT SQL: APRODSPECOMP Type: view COMPOSITE

Components for Product Specification Compositions

A_ProdSpecComponent is a Composite CDS View that provides data about "Components for Product Specification Compositions" in SAP S/4HANA. It reads from 1 data source (I_ProdSpecComponent) and exposes 14 fields with key field ProdSpecComponentInternalID. It has 3 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_ProdSpecComponent I_ProdSpecComponent from

Associations (3)

CardinalityTargetAliasCondition
[1..*] A_ProdSpecCmpstnTypeSpecType _ProdSpecCmpstnTypeSpecType $projection.SpecificationType = _ProdSpecCmpstnTypeSpecType.SpecificationType
[0..*] A_ProdSpecComponentDescription _ProdSpecComponentDescription $projection.ProdSpecComponentInternalID = _ProdSpecComponentDescription.ProdSpecComponentInternalID
[0..1] A_ProdSpecComponentBaseUoM _ProdSpecComponentBaseUoM $projection.ProdSpecComponentInternalID = _ProdSpecComponentBaseUoM.ProdSpecComponentInternalID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName APRODSPECOMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
EndUserText.label Components for Product Specification Compositions view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProdSpecComponentInternalID ProdSpecComponentInternalID
ProdSpecComponent ProdSpecComponent
SpecificationType SpecificationType
SpecificationIsDeleted SpecificationIsDeleted
SpecificationLastChangeDate SpecificationLastChangeDate
ProdSpecCompVersIndepLstChgDte
ProdSpecCompVersIndepLstChgTme
_ProdSpecCmpstnTypeSpecType _ProdSpecCmpstnTypeSpecType
_LogAccMObjectTypeActive _LogAccMObjectTypeActive
_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn
_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt
_Specification _Specification
_ProdSpecComponentDescription _ProdSpecComponentDescription
_ProdSpecComponentBaseUoM _ProdSpecComponentBaseUoM 
@AbapCatalog.sqlViewName: 'APRODSPECOMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

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

@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Components for Product Specification Compositions'

define view A_ProdSpecComponent
  as select from I_ProdSpecComponent
  association [1..*] to A_ProdSpecCmpstnTypeSpecType   as _ProdSpecCmpstnTypeSpecType   on $projection.SpecificationType = _ProdSpecCmpstnTypeSpecType.SpecificationType
  association [0..*] to A_ProdSpecComponentDescription as _ProdSpecComponentDescription on $projection.ProdSpecComponentInternalID = _ProdSpecComponentDescription.ProdSpecComponentInternalID
  association [0..1] to A_ProdSpecComponentBaseUoM     as _ProdSpecComponentBaseUoM     on $projection.ProdSpecComponentInternalID = _ProdSpecComponentBaseUoM.ProdSpecComponentInternalID

{
  key ProdSpecComponentInternalID,
      ProdSpecComponent,
      SpecificationType,

      SpecificationIsDeleted,
      SpecificationLastChangeDate,
      
      cast( _SpecificationLastChange.SpecificationLastChangeDate as /PLMB/SPC_VRSN_INDEP_LSTCHG_D preserving type ) as ProdSpecCompVersIndepLstChgDte,
      cast( _SpecificationLastChange.SpecificationLastChangeTime as /PLMB/SPC_VRSN_INDEP_LSTCHG_T preserving type ) as ProdSpecCompVersIndepLstChgTme,
      
      /* Associations */
      _ProdSpecCmpstnTypeSpecType,

      @Consumption.hidden: true
      _LogAccMObjectTypeActive,
      @Consumption.hidden: true
      _LogAccMObjectUserAuthzn,
      @Consumption.hidden: true
      _LogAccMObjSecureIDAssgmt,
      @Consumption.hidden: true
      _Specification,

      _ProdSpecComponentDescription,
      _ProdSpecComponentBaseUoM
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODSPECCOMPONENT",
"I_SPECIFICATIONLASTCHANGE"
],
"ASSOCIATED":
[
"A_PRODSPECCMPSTNTYPESPECTYPE",
"A_PRODSPECCOMPONENTBASEUOM",
"A_PRODSPECCOMPONENTDESCRIPTION",
"I_LOGACCMOBJECTTYPEACTIVE",
"I_LOGACCMOBJECTUSERAUTHZN",
"I_LOGACCMOBJSECUREIDASSGMT",
"I_SPECIFICATION"
],
"BASE":
[
"I_PRODSPECCOMPONENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More