I_ComplaintProcessFlowStatus

DDL: I_COMPLAINTPROCESSFLOWSTATUS Type: view_entity COMPOSITE
12 Fields 3 Data Sources

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.

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 SD Document
KEY DocumentItemNumber I_SalesDocumentItemBasic SalesDocumentItem Item
KEY SalesDocumentItemCategory I_SalesDocumentItemBasic SalesDocumentItemCategory Item Category
SDProcessStatusDesc
DeliveryDocumentasSalesDocument
KEY DocumentItemNumber I_DeliveryDocumentItem DeliveryDocumentItem Item
KEY SalesDocumentItemCategory I_DeliveryDocumentItem DeliveryDocumentItemCategory Item Category
SDProcessStatusDesc
KEY DocumentItemNumber DocumentItemNumber Item
KEY SalesDocumentItemCategory DeliveryDocumentItemCategory Item Category
SDProcessStatusDesc OverallBillingStatusDesc
SubsequentDocStatus PBEE BDR Status

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ComplaintProcessFlowStatus.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ComplaintProcessFlowStatus AS
SELECT
  I_SalesDocumentItem.SalesDocument AS SalesDocument,
  I_SalesDocumentItem.SalesDocumentItem AS DocumentItemNumber,
  I_SalesDocumentItem.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  _SDProcessStatus._Text[1: Language = $session.system_language].SDProcessStatusDesc AS SDProcessStatusDesc,
  cast(_SDProcessStatus.SDProcessStatus as char20) as SubsequentDocStatus AS DeliveryDocumentasSalesDocument,
  cast(DocumentBillingStatus as char20) AS SubsequentDocStatus
FROM I_SalesDocumentItemBasic AS I_SalesDocumentItem
-- UNION with additional select branch(es): I_DeliveryDocumentItem, I_ComplaintBillingStatus
;

Learn More