I_SALESDOCUMENTSUBSQNTPROCFLOW

CDS View

Subsequent Process Flow of Sales Doc

I_SALESDOCUMENTSUBSQNTPROCFLOW is a CDS View in S/4HANA. Subsequent Process Flow of Sales Doc. It contains 8 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 8 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SalesOrderSubsqntProcFlow view_entity from COMPOSITE Subsequent Process Flow of Sales Order
I_SlsQtanSubsqntProcFlow view_entity from COMPOSITE Sales Quotation Subsequent Process Flow

Fields (8)

KeyField CDS FieldsUsed in Views
KEY DocRelationshipUUID DocRelationshipUUID 2
KEY SalesDocument SalesOrder,SalesQuotation 2
CreationDate CreationDate 2
CreationTime CreationTime 2
LastChangeDate LastChangeDate 2
ProcessFlowLevel ProcessFlowLevel 2
SubsequentDocument SubsequentDocument 2
SubsequentDocumentCategory SubsequentDocumentCategory 2 
@EndUserText.label: 'Subsequent Process Flow of Sales Doc'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
}
@Metadata.ignorePropagatedAnnotations: true

define view entity I_SalesDocumentSubsqntProcFlow
  as select from I_SDDocumentMultiLevelProcFlow as SubsequentProcFlow 
  
    inner join   I_SalesDocumentBasic           as SalesDocument on  SalesDocument.SalesDocument      = SubsequentProcFlow.PrecedingDocument 
                                                                 and SalesDocument.SDDocumentCategory = SubsequentProcFlow.PrecedingDocumentCategory                                                                     

    association [1..1] to I_SalesDocument       as _SalesDocument on _SalesDocument.SalesDocument = $projection.SalesDocument 
{

  key SubsequentProcFlow.PrecedingDocument         as SalesDocument,
  key SubsequentProcFlow.DocRelationshipUUID,
       
      SubsequentProcFlow.SubsequentDocument,
 
      SubsequentProcFlow.SubsequentDocumentCategory,
      SubsequentProcFlow.PrecedingDocumentCategory as SDDocumentCategory,
      
      SubsequentProcFlow.ProcessFlowLevel,

      @Semantics.systemDate.createdAt: true
      SubsequentProcFlow.CreationDate,
      @Semantics.systemTime.createdAt: true
      SubsequentProcFlow.CreationTime,
      @Semantics.systemDate.lastChangedAt: true
      SubsequentProcFlow.LastChangeDate,

      // For Access control

      @Consumption.hidden: true
      SalesDocument.SalesDocumentType,
      @Consumption.hidden: true
      SalesDocument.SalesOrganization,
      @Consumption.hidden: true
      SalesDocument.DistributionChannel,
      @Consumption.hidden: true
      SalesDocument.OrganizationDivision,

      //Associations

      _SalesDocument
      
}  where SubsequentProcFlow.PrecedingDocumentItem = '000000';

Learn More