A_CmplSubsqntProcessFlow

DDL: A_CMPLSUBSQNTPROCESSFLOW Type: view_entity CONSUMPTION Package: VDM_CMH_SD
17 Fields 2 Data Sources 1 OData Services

CMH Subsequent Documents entity

A_CmplSubsqntProcessFlow is a Consumption CDS View that provides data about "CMH Subsequent Documents entity" in SAP S/4HANA. It reads from 2 data sources (I_SDDocumentCategoryText, I_SDDocumentMultiLevelProcFlow) and exposes 17 fields with key field DocRelationshipUUID. It is exposed through 1 OData service (API_CMPLPROCESSFLOWDETAIL_3). Part of development package VDM_CMH_SD.

Data Sources (2)

SourceAliasJoin Type
I_SDDocumentCategoryText _Category inner
I_SDDocumentMultiLevelProcFlow SubsequentProcFlowDocItem from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CMH Subsequent Documents entity view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entitySet.name SubsequentProcFlowDocItem view
OData.entityType.name SubsequentProcFlowDocItem_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_CMPLPROCESSFLOWDETAIL_3

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY DocRelationshipUUID I_SDDocumentMultiLevelProcFlow DocRelationshipUUID SM Doc Rel UUID
PrecedingDocument I_SDDocumentMultiLevelProcFlow PrecedingDocument SD Document
PrecedingDocumentItem I_SDDocumentMultiLevelProcFlow PrecedingDocumentItem Item
SubsequentDocument I_SDDocumentMultiLevelProcFlow SubsequentDocument SD Sched. Agmt
SubsequentDocumentItem I_SDDocumentMultiLevelProcFlow SubsequentDocumentItem Subsequent Item
SubsqntDocItmPrecdgDocument _SDDocMultiLevelProcFlow PrecedingDocument SD Document
SubsqntDocItmPrecdgDocItem _SDDocMultiLevelProcFlow PrecedingDocumentItem Item
SubsequentDocumentCategory I_SDDocumentMultiLevelProcFlow SubsequentDocumentCategory Subs.Doc.Categ.
DocumentDescription I_SDDocumentCategoryText SDDocumentCategoryName
SubsequentDocStatus _ProcessFlowStatus SubsequentDocStatus
SubsequentDocStatusDesc _ProcessFlowStatus SDProcessStatusDesc
ProcessFlowLevel I_SDDocumentMultiLevelProcFlow ProcessFlowLevel Level Number
InspectionDocument _ComplaintInspection InspectionDocument
ReturnsInspectionItem _ComplaintInspection ReturnsInspectionItem
InspDocCategoryValue _ComplaintInspection SubsequentDocumentCategory Subs.Doc.Categ.
ReturnsInspectionStatusText _ComplaintInspection ReturnsInspectionStatusText
CustomerReturnType _ComplaintInspection CustomerReturnType

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 A_CmplSubsqntProcessFlow.
-- 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 A_CmplSubsqntProcessFlow AS
SELECT
  SubsequentProcFlowDocItem.DocRelationshipUUID AS DocRelationshipUUID,
  SubsequentProcFlowDocItem.PrecedingDocument AS PrecedingDocument,
  SubsequentProcFlowDocItem.PrecedingDocumentItem AS PrecedingDocumentItem,
  SubsequentProcFlowDocItem.SubsequentDocument AS SubsequentDocument,
  SubsequentProcFlowDocItem.SubsequentDocumentItem AS SubsequentDocumentItem,
  _SDDocMultiLevelProcFlow.PrecedingDocument AS SubsqntDocItmPrecdgDocument,
  _SDDocMultiLevelProcFlow.PrecedingDocumentItem AS SubsqntDocItmPrecdgDocItem,
  SubsequentProcFlowDocItem.SubsequentDocumentCategory AS SubsequentDocumentCategory,
  _Category.SDDocumentCategoryName AS DocumentDescription,
  _ProcessFlowStatus.SubsequentDocStatus AS SubsequentDocStatus,
  _ProcessFlowStatus.SDProcessStatusDesc AS SubsequentDocStatusDesc,
  SubsequentProcFlowDocItem.ProcessFlowLevel AS ProcessFlowLevel,
  _ComplaintInspection.InspectionDocument AS InspectionDocument,
  _ComplaintInspection.ReturnsInspectionItem AS ReturnsInspectionItem,
  _ComplaintInspection.SubsequentDocumentCategory AS InspDocCategoryValue,
  _ComplaintInspection.ReturnsInspectionStatusText AS ReturnsInspectionStatusText,
  _ComplaintInspection.CustomerReturnType AS CustomerReturnType
FROM I_SDDocumentMultiLevelProcFlow AS SubsequentProcFlowDocItem
INNER JOIN I_SDDocumentCategoryText AS _Category ON /* join condition not captured in parsed metadata */
;

Learn More