I_SalesOrderItmSubsqntProcFlow

DDL: I_SALESORDERITMSUBSQNTPROCFLOW Type: view_entity COMPOSITE

Subsequent Process Flow of Sls Ordr Item

I_SalesOrderItmSubsqntProcFlow is a Composite CDS View that provides data about "Subsequent Process Flow of Sls Ordr Item" in SAP S/4HANA. It reads from 1 data source (I_SalesDocItmSubsqntProcFlow) and exposes 19 fields with key fields SalesOrder, SalesOrderItem, DocRelationshipUUID. It has 2 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocItmSubsqntProcFlow SubsequentProcFlowItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SalesOrder _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder
[1..1] I_SalesOrderItem _SalesOrderItem $projection.SalesOrder = _SalesOrderItem.SalesOrder and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem

Annotations (8)

NameValueLevelField
EndUserText.label Subsequent Process Flow of Sls Ordr Item view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesDocItmSubsqntProcFlow SalesDocument
KEY SalesOrderItem I_SalesDocItmSubsqntProcFlow SalesDocumentItem
KEY DocRelationshipUUID I_SalesDocItmSubsqntProcFlow DocRelationshipUUID
SubsequentDocument I_SalesDocItmSubsqntProcFlow SubsequentDocument
SubsequentDocumentItem I_SalesDocItmSubsqntProcFlow SubsequentDocumentItem
SubsequentDocumentCategory I_SalesDocItmSubsqntProcFlow SubsequentDocumentCategory
ProcessFlowLevel I_SalesDocItmSubsqntProcFlow ProcessFlowLevel
SubsqntDocItmPrecdgDocument SubsqntDocItmPrecdgDocument
SubsqntDocItmPrecdgDocItem SubsqntDocItmPrecdgDocItem
SubsqntDocItmPrecdgDocCategory SubsqntDocItmPrecdgDocCategory
CreationDate I_SalesDocItmSubsqntProcFlow CreationDate
CreationTime I_SalesDocItmSubsqntProcFlow CreationTime
LastChangeDate I_SalesDocItmSubsqntProcFlow LastChangeDate
SalesOrderType _SalesOrder SalesOrderType
SalesOrganization _SalesOrder SalesOrganization
DistributionChannel _SalesOrder DistributionChannel
OrganizationDivision _SalesOrder OrganizationDivision
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem 
@EndUserText.label: 'Subsequent Process Flow of Sls Ordr Item'
@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_SalesOrderItmSubsqntProcFlow
  as select from I_SalesDocItmSubsqntProcFlow as SubsequentProcFlowItem
  
  association [1..1] to I_SalesOrder     as _SalesOrder     on  $projection.SalesOrder     = _SalesOrder.SalesOrder
  association [1..1] to I_SalesOrderItem as _SalesOrderItem on  $projection.SalesOrder     = _SalesOrderItem.SalesOrder
                                                            and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem

{

  key SubsequentProcFlowItem.SalesDocument     as SalesOrder,
  key SubsequentProcFlowItem.SalesDocumentItem as SalesOrderItem,
  key SubsequentProcFlowItem.DocRelationshipUUID,
  
      SubsequentProcFlowItem.SubsequentDocument,
      SubsequentProcFlowItem.SubsequentDocumentItem,
      SubsequentProcFlowItem.SubsequentDocumentCategory,
      
      SubsequentProcFlowItem.ProcessFlowLevel,
      
      SubsqntDocItmPrecdgDocument,
      SubsqntDocItmPrecdgDocItem,
      SubsqntDocItmPrecdgDocCategory,

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

      // For Access control

      @Consumption.hidden: true
      _SalesOrder.SalesOrderType,
      @Consumption.hidden: true
      _SalesOrder.SalesOrganization,
      @Consumption.hidden: true
      _SalesOrder.DistributionChannel,
      @Consumption.hidden: true
      _SalesOrder.OrganizationDivision,

      //Associations

      _SalesOrder,
      _SalesOrderItem

}
where SubsequentProcFlowItem.SDDocumentCategory = 'C'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCITMSUBSQNTPROCFLOW",
"I_SALESORDER"
],
"ASSOCIATED":
[
"I_SALESORDER",
"I_SALESORDERITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More