I_SpecAssignedHeaderStatus

DDL: I_SPECASSIGNEDHEADERSTATUS SQL: ISPECASGHDRST Type: view BASIC

Specification Assigned Header Status

I_SpecAssignedHeaderStatus is a Basic CDS View that provides data about "Specification Assigned Header Status" in SAP S/4HANA. It reads from 2 data sources (/plmb/sam_objst, P_SpecAssignedHeaderStatusLtst) and exposes 7 fields with key field SpecificationInternalID. It has 4 associations to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
/plmb/sam_objst objstatus from
P_SpecAssignedHeaderStatusLtst P_SpecAssignedHeaderStatusLtst inner

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SpecHeaderStatus _SpecificationHeaderStatus $projection.SpecificationHeaderStatus = _SpecificationHeaderStatus.SpecificationHeaderStatus
[0..*] I_Specification _Specification $projection.SpecificationInternalID = _Specification.SpecificationInternalID
[0..*] I_SpecHeaderStatusText _SpecHeaderStatusText $projection.SpecificationHeaderStatus = _SpecHeaderStatusText.SpecificationHeaderStatus
[0..1] I_SpecHeaderStatusSchema _SpecHeaderStatusSchema $projection.SpecificationHdrStsSchema = _SpecHeaderStatusSchema.SpecificationHdrStsSchema

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISPECASGHDRST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Specification Assigned Header Status view
ObjectModel.representativeKey SpecificationInternalID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SpecificationInternalID
SpecificationHeaderStatus status_id
SpecificationHdrStsSchema schema_id
_SpecificationHeaderStatus _SpecificationHeaderStatus
_SpecHeaderStatusText _SpecHeaderStatusText
_Specification _Specification
_SpecHeaderStatusSchema _SpecHeaderStatusSchema 
@AbapCatalog.sqlViewName: 'ISPECASGHDRST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Specification Assigned Header Status'

@ObjectModel: {
   representativeKey: 'SpecificationInternalID',
   usageType: {
     dataClass:      #MASTER,
     serviceQuality: #A,
     sizeCategory:   #L
   }
}

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

@Metadata.ignorePropagatedAnnotations:true 
define view I_SpecAssignedHeaderStatus
  as select from /plmb/sam_objst as objstatus
    inner join   P_SpecAssignedHeaderStatusLtst on  objstatus.object_id = P_SpecAssignedHeaderStatusLtst.SpecificationInternalID
                                                and objstatus.counter   = P_SpecAssignedHeaderStatusLtst.LatestCounter

  association [0..1] to I_SpecHeaderStatus       as _SpecificationHeaderStatus on $projection.SpecificationHeaderStatus = _SpecificationHeaderStatus.SpecificationHeaderStatus
  association [0..*] to I_Specification          as _Specification             on $projection.SpecificationInternalID = _Specification.SpecificationInternalID
  association [0..*] to I_SpecHeaderStatusText   as _SpecHeaderStatusText      on $projection.SpecificationHeaderStatus = _SpecHeaderStatusText.SpecificationHeaderStatus
  association [0..1] to I_SpecHeaderStatusSchema as _SpecHeaderStatusSchema    on $projection.SpecificationHdrStsSchema = _SpecHeaderStatusSchema.SpecificationHdrStsSchema
{
      @ObjectModel.text.association: '_SpecHeaderStatusText'
  key cast (object_id as eserecn) as SpecificationInternalID,

      @ObjectModel.foreignKey.association: '_SpecificationHeaderStatus'
      status_id                   as SpecificationHeaderStatus,
      
      @ObjectModel.foreignKey.association: '_SpecHeaderStatusSchema'
      schema_id                   as SpecificationHdrStsSchema,
      

      _SpecificationHeaderStatus,
      _SpecHeaderStatusText,
      _Specification,
      _SpecHeaderStatusSchema
}
where
  otype_name = 'PLM_RSPSUB'

Learn More