I_ValueChainDocumentFlow

DDL: I_VALUECHAINDOCUMENTFLOW Type: view_entity COMPOSITE

Docflow for VCM Bus obj and Items

I_ValueChainDocumentFlow (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_ValueChainDocumentFlow is a Composite CDS View that provides data about "Docflow for VCM Bus obj and Items" in SAP S/4HANA. It reads from 2 data sources (I_ValueChainBusObjItem, I_ValueChainStepInstance) and exposes 26 fields with key fields ValueChainStepInstanceUUID, ValueChainBusinessObject, ValueChainBusinessObjectItem. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for VCM
StatusVCM_VALUE_CHAIN_STEP_STATUS
Purpose
This CDS view helps you identify all the documents involved in a single chain item within the same value chain. Additionally, it can be used to navigate other documents linked to the same item GUID. For example, if you are at one step and want to find information about another step, this CDS view can be utilized.

Authorization
Users who want to use this CDS view must have the following authorization object assigned: C_VCM_INST .

Structure
CDS View Parameters This CDS view requires following three specific inputs: P_ValueChainStepBusinessObject : Represents the type of business object, such as: SALES_ORDER BILLING_DOCUMENT MATERIAL_DOCUMENT PURCHASE_ORDER SUPPLIER_INVOICE STOCK_TRANSPORT_ORDER OUTBOUND_DELIVERY INBOUND_DELIVERY P_ValueChainBusinessObject : Indicates the ID of the business object document, with leading zeroes for accurate identification. Example If a business object document, such as a sales order, requires a 10-digit ID and the number is 12345, it is stored with leading zeroes as 0000012345. Only for material documents or supplier invoices, the document number is combined with the posting year. For instance, if the supplier invoice number is 5100000000 and the posting year is 2025, the business object value is 51000000002025. P_ValueChainBusinessObject : Refers to the item ID of the business object document, with leading zeroes for accurate identification. Example To enter line item 10 of a sales order, use the 6-digit format for line items and enter it as 000010. Important Fields Important fields in this view include the following: Field Name Data Element Description Inputs ValueChainStepInstanceUUID VCM_STEP_UUID UUID of Value Chain Step ValueChainBusinessObject VCM_BUSINESS_OBJECT_ID ID of Business Object ValueChainBusinessObjectItem VCM_BUSINESS_OBJECT_ITEM_ID Item ID of Business Object Chain Related Fields ValueChainInstanceUUID VCM_INSTANCE_UUID UUID of Value Chain Instance ValueChainType VCM_VALUE_CHAIN_TYPE Value Chain Type ValueChainTypeVersion VCM_VERSION_NUMBER Version of Value Chain FinancialChain FCH_FINANCIAL_CHAIN_ID Financial Chain ID ValueChainInstanceStatus VCM_VALUE_CHAIN_STATUS Processing Stage of Value Chain – Runtime. C – Completed E – Processed with Errors PD – Pending PR – In Process O – Open RE – Reprocessing ValueChainTriggerObject VCM_BUSINESS_OBJECT_ID ID of Triggering Business Object Item Related Fields ValueChainItemUUID VCM_VC_ITEM_UUID UUID of Value Chain Item. ValueChainItemStatus VCM_VALUE_CHAIN_ITEM_STATUS Processing Stage of Value Chain Item – Runtime. A – Active I - Inactive Step Related Fields ValueChainStepType VCM_STEP_TYPE_ID ID of value chain step type. ValueChainStepChainElementID VCM_CHAIN_ELEMENT_ID ID of Value Chain step chain element. ValueChainStepInstanceStatus VCM_VALUE_CHAIN_STEP_STATUS Processing Stage of Process Step – Runtime. ValueChainStepBusinessObject VCM_BUSINESS_OBJECT Business Object of Value Chain Step. Such as: SALES_ORDER BILLING_DOCUMENT MATERIAL_DOCUMENT PURCHASE_ORDER SUPPLIER_INVOICE STOCK_TRANSPORT_ORDER OUTBOUND_DELIVERY INBOUND_DELIVERY ValueChainBusinessObjectCat VCM_BUSINESS_OBJECT_CAT Business Object Category. Such as: GI Goods Issue GI_ICO Goods Issue - Intercompany GR Goods Receipt GR_ICO Goods Receipt - Intercompany GT Goods Transfer IsDeleted VCM_ITEM_DELETED Item Deleted IsCancelled VCM_ITEM_CANCELLED Item Cancelled IsReversalDocument VCM_IS_AMENDMENT Is Amendment Predecessor Step Related Fields ValueChainStepPredecessorUUID VCM_PREDECESSOR_STEP_UUID UUID of Value Chain Predecessor Step. ValueChainStepPredecessor VCM_STEP_TYPE_ID Process Step ID of Predecessor Step of Value Chain. ValChnPrdcssrStepChnElementID VCM_CHAIN_ELEMENT_ID Block Number of Predecessor Step of Value Chain. ValChnPrdcssrStepBusObjCatID VCM_BUSINESS_OBJECT_CAT Business Object Category of Value Chain Predecessor step . Such as: GI Goods Issue GI_ICO Goods Issue - Intercompany GR Goods Receipt GR_ICO Goods Receipt - Intercompany GT Goods Transfer ValueCha

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentCA-VCM
CapabilitiesTransactional Provider
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_ValueChainBusObjItem hierarchy inner
I_ValueChainStepInstance step left_outer

Parameters (3)

NameTypeDefault
P_ValueChainStepBusinessObject vcm_business_object
P_ValueChainBusinessObject vcm_business_object_id
P_ValueChainBusinessObjectItem vcm_business_object_item_id

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ValueChainStepInstance _prdcssrStep step.ValueChainStepPredecessorUUID = _prdcssrStep.ValueChainStepInstanceUUID
[1..1] I_ValueChainItem _ValChnItem item.ValueChainItemUUID = _ValChnItem.ValueChainItemUUID
[1..1] I_ValueChainBusObjItem _PrdcssrItem hierarchy.ValueChainPredecessorStpBusObj = _PrdcssrItem.ValueChainStepBusinessObject and hierarchy.ValueChainPredecessorBusObj = _PrdcssrItem.ValueChainBusinessObject and hierarchy.ValueChainPrdcssrBusObjItem = _PrdcssrItem.ValueChainBusinessObjectItem

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Docflow for VCM Bus obj and Items view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
ObjectModel.modelingPattern #NONE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ValueChainStepInstanceUUID I_ValueChainBusObjItem ValueChainStepInstanceUUID UUID of Value Chain Step
KEY ValueChainBusinessObject I_ValueChainBusObjItem ValueChainBusinessObject ID of Business Object Instance
KEY ValueChainBusinessObjectItem I_ValueChainBusObjItem ValueChainBusinessObjectItem Item ID of Business Object Instance
ValueChainInstanceUUID I_ValueChainBusObjItem ValueChainInstanceUUID UUID of Value Chain Instance
ValueChainType Value Chain Type
ValueChainTypeVersion Version of Value Chain
FinancialChain Financial Chain ID
ValueChainInstanceStatus Processing Stage of Value Chain - Runtime
ValueChainTriggerObject ID of Business Object Instance
ValueChainItemUUID I_ValueChainBusObjItem ValueChainItemUUID UUID of Value Chain Item
ValueChainItemStatus _ValChnItem ValueChainItemStatus Processing Stage of Value Chain Item - Runtime
ValueChainStepType I_ValueChainStepInstance ValueChainStepType VSS Sol. Step Type
ValueChainStepChainElementID I_ValueChainStepInstance ValueChainStepChainElementID Block Number
ValueChainStepInstanceStatus I_ValueChainStepInstance ValueChainStepInstanceStatus Processing Stage of Process Step - Runtime
ValueChainStepBusinessObject I_ValueChainBusObjItem ValueChainStepBusinessObject Business Object of Value Chain
ValueChainBusinessObjectCat I_ValueChainBusObjItem ValueChainBusinessObjectCat Business Object Category
IsDeleted I_ValueChainBusObjItem IsDeleted Item Deleted
IsCancelled I_ValueChainBusObjItem IsCancelled Boolean Variable (X = True, - = False, Space = Unknown)
IsReversalDocument I_ValueChainBusObjItem IsReversalDocument Is Amendment
ValueChainStepPredecessorUUID I_ValueChainStepInstance ValueChainStepPredecessorUUID UUID of Value Chain Predecessor Step
ValueChainStepPredecessor _prdcssrStep ValueChainStepType VSS Sol. Step Type
ValChnPrdcssrStepChnElementID _prdcssrStep ValueChainStepChainElementID Block Number
ValChnPrdcssrStepBusObjCatID _PrdcssrItem ValueChainBusinessObjectCat Business Object Category
ValueChainPredecessorBusObj I_ValueChainBusObjItem ValueChainPredecessorBusObj ID of Business Object Instance
ValueChainPrdcssrBusObjItem I_ValueChainBusObjItem ValueChainPrdcssrBusObjItem Item ID of Business Object Instance
ValueChainPredecessorStpBusObj I_ValueChainBusObjItem ValueChainPredecessorStpBusObj Business Object of Value Chain

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_ValueChainDocumentFlow.
-- 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.
-- Parameters: P_ValueChainStepBusinessObject : vcm_business_object, P_ValueChainBusinessObject : vcm_business_object_id, P_ValueChainBusinessObjectItem : vcm_business_object_item_id

CREATE VIEW I_ValueChainDocumentFlow AS
SELECT
  hierarchy.ValueChainStepInstanceUUID AS ValueChainStepInstanceUUID,
  hierarchy.ValueChainBusinessObject AS ValueChainBusinessObject,
  hierarchy.ValueChainBusinessObjectItem AS ValueChainBusinessObjectItem,
  hierarchy.ValueChainInstanceUUID AS ValueChainInstanceUUID,
  hierarchy._Instance.ValueChainType AS ValueChainType,
  hierarchy._Instance.ValueChainTypeVersion AS ValueChainTypeVersion,
  hierarchy._Instance.FinancialChain AS FinancialChain,
  hierarchy._Instance.ValueChainInstanceStatus AS ValueChainInstanceStatus,
  hierarchy._Instance.ValueChainBusinessObject AS ValueChainTriggerObject,
  hierarchy.ValueChainItemUUID AS ValueChainItemUUID,
  _ValChnItem.ValueChainItemStatus AS ValueChainItemStatus,
  step.ValueChainStepType AS ValueChainStepType,
  step.ValueChainStepChainElementID AS ValueChainStepChainElementID,
  step.ValueChainStepInstanceStatus AS ValueChainStepInstanceStatus,
  hierarchy.ValueChainStepBusinessObject AS ValueChainStepBusinessObject,
  hierarchy.ValueChainBusinessObjectCat AS ValueChainBusinessObjectCat,
  hierarchy.IsDeleted AS IsDeleted,
  hierarchy.IsCancelled AS IsCancelled,
  hierarchy.IsReversalDocument AS IsReversalDocument,
  step.ValueChainStepPredecessorUUID AS ValueChainStepPredecessorUUID,
  _prdcssrStep.ValueChainStepType AS ValueChainStepPredecessor,
  _prdcssrStep.ValueChainStepChainElementID AS ValChnPrdcssrStepChnElementID,
  _PrdcssrItem.ValueChainBusinessObjectCat AS ValChnPrdcssrStepBusObjCatID,
  hierarchy.ValueChainPredecessorBusObj AS ValueChainPredecessorBusObj,
  hierarchy.ValueChainPrdcssrBusObjItem AS ValueChainPrdcssrBusObjItem,
  hierarchy.ValueChainPredecessorStpBusObj AS ValueChainPredecessorStpBusObj
INNER JOIN I_ValueChainBusObjItem AS hierarchy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ValueChainStepInstance AS step ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ValueChainStepInstance AS _prdcssrStep ON step.ValueChainStepPredecessorUUID = _prdcssrStep.ValueChainStepInstanceUUID  -- association [1..1]
LEFT OUTER JOIN I_ValueChainItem AS _ValChnItem ON item.ValueChainItemUUID = _ValChnItem.ValueChainItemUUID  -- association [1..1]
LEFT OUTER JOIN I_ValueChainBusObjItem AS _PrdcssrItem ON hierarchy.ValueChainPredecessorStpBusObj = _PrdcssrItem.ValueChainStepBusinessObject AND hierarchy.ValueChainPredecessorBusObj = _PrdcssrItem.ValueChainBusinessObject AND hierarchy.ValueChainPrdcssrBusObjItem = _PrdcssrItem.ValueChainBusinessObjectItem  -- association [1..1]
;