P_SPECASSIGNEDHEADERSTATUSLTST

CDS View

P_SPECASSIGNEDHEADERSTATUSLTST is a CDS View in S/4HANA. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SpecAssignedHeaderStatus view inner BASIC Specification Assigned Header Status
@AbapCatalog.sqlViewName: 'PSPECASGHDRLAT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.lifecycle.contract.type: #NONE
@VDM.viewType: #BASIC
define view P_SpecAssignedHeaderStatusLtst
  as select from /plmb/sam_objst
{
  key cast (object_id as eserecn  ) as SpecificationInternalID,
      max(counter)                  as LatestCounter

}
where
      otype_name = 'PLM_RSPSUB'
  and due_entry  = ''
group by
  object_id