I_ComplaintProcessFlowStatus

DDL: I_COMPLAINTPROCESSFLOWSTATUS Type: view_entity COMPOSITE

Complaint Process Flow Status

I_ComplaintProcessFlowStatus is a Composite CDS View that provides data about "Complaint Process Flow Status" in SAP S/4HANA. It reads from 3 data sources (I_ComplaintBillingStatus, I_DeliveryDocumentItem, I_SalesDocumentItemBasic) and exposes 12 fields with key fields SalesDocument, DocumentItemNumber, SalesDocumentItemCategory, DocumentItemNumber, SalesDocumentItemCategory.

3 data source(s) 12 fields

Data Sources (3)

SourceAliasJoin Type
I_ComplaintBillingStatus BillingDocumentItemBasic union
I_DeliveryDocumentItem DeliveryDocumentItem union
I_SalesDocumentItemBasic I_SalesDocumentItem from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Complaint Process Flow Status view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentItemBasic SalesDocument
KEY DocumentItemNumber I_SalesDocumentItemBasic SalesDocumentItem
KEY SalesDocumentItemCategory I_SalesDocumentItemBasic SalesDocumentItemCategory
SDProcessStatusDesc
DeliveryDocumentasSalesDocument
KEY DocumentItemNumber I_DeliveryDocumentItem DeliveryDocumentItem
KEY SalesDocumentItemCategory I_DeliveryDocumentItem DeliveryDocumentItemCategory
SDProcessStatusDesc
KEY DocumentItemNumber DocumentItemNumber
KEY SalesDocumentItemCategory DeliveryDocumentItemCategory
SDProcessStatusDesc OverallBillingStatusDesc
SubsequentDocStatus 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {

   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Complaint Process Flow Status'
define view entity I_ComplaintProcessFlowStatus
  as select from I_SalesDocumentItemBasic as I_SalesDocumentItem
{
  key  I_SalesDocumentItem.SalesDocument                                                  as SalesDocument,
  key  I_SalesDocumentItem.SalesDocumentItem                                              as DocumentItemNumber,
  key  I_SalesDocumentItem.SalesDocumentItemCategory                                      as SalesDocumentItemCategory,
       _SDProcessStatus._Text[1: Language = $session.system_language].SDProcessStatusDesc as SDProcessStatusDesc,

        cast(_SDProcessStatus.SDProcessStatus as char20) as SubsequentDocStatus


}

union select from I_DeliveryDocumentItem as DeliveryDocumentItem
{
  key DeliveryDocumentItem.DeliveryDocument                                              as SalesDocument,
  key DeliveryDocumentItem.DeliveryDocumentItem                                          as DocumentItemNumber,
  key DeliveryDocumentItem.DeliveryDocumentItemCategory                                  as SalesDocumentItemCategory,
      _SDProcessStatus._Text[1: Language = $session.system_language].SDProcessStatusDesc as SDProcessStatusDesc,
       cast(_SDProcessStatus.SDProcessStatus as char20) as SubsequentDocStatus


}

union select from I_ComplaintBillingStatus as BillingDocumentItemBasic

{
  key SalesDocument,
  key DocumentItemNumber,
  key DeliveryDocumentItemCategory as SalesDocumentItemCategory,
      OverallBillingStatusDesc     as SDProcessStatusDesc,
      cast(DocumentBillingStatus as char20) as SubsequentDocStatus
}

Learn More