P_LATESTGIRLTDMATDOCDATE

CDS View

Latest Goods Issue Related Material Document Date

P_LATESTGIRLTDMATDOCDATE is a CDS View in S/4HANA. Latest Goods Issue Related Material Document Date. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_LatestGIRltdMatDocDateTime view inner BASIC Latest Goods Issue Related Material Document Date and Time

Fields (1)

KeyField CDS FieldsUsed in Views
MaxCreationDate MaxCreationDate 1 
@AbapCatalog.sqlViewName: 'PLTSTGIRLTDDAT'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC

define view P_LatestGIRltdMatDocDate 
as select from I_SDDocumentProcessFlow as Flow   
{
  key Flow.PrecedingDocument,
  key Flow.PrecedingDocumentCategory,
  max(CreationDate) as MaxCreationDate  
}
  
where Flow.SubsequentDocumentCategory = 'R'         
   or Flow.SubsequentDocumentCategory = 'h'
   
group by PrecedingDocument,
         PrecedingDocumentCategory

Learn More