C_IntcoValueChainDocumentTP

DDL: C_INTCOVALUECHAINDOCUMENTTP Type: view_entity CONSUMPTION Package: CA_VCM_MNTR_RAP
24 Fields 1 Data Sources 9 Associations

Intercompany Value Chain Document

C_IntcoValueChainDocumentTP is a Consumption CDS View that provides data about "Intercompany Value Chain Document" in SAP S/4HANA. It reads from 1 data source (I_IntcoValueChainDocument) and exposes 24 fields with key fields ValueChainStepInstanceUUID, ValueChainDocumentItemOrigin, ValueChainBusinessObject. It has 9 associations to related views. Part of development package CA_VCM_MNTR_RAP.

Data Sources (1)

SourceAliasJoin Type
I_IntcoValueChainDocument Document from

Associations (9)

CardinalityTargetAliasCondition
[0..1] R_ValueChainStepInstanceTP _Step _Step.ValueChainStepInstanceUUID = $projection.ValueChainStepInstanceUUID and _Step.ValueChainInstanceUUID = $projection.ValueChainInstanceUUID
[0..1] I_ValueChainStepBusObj _StepBusObj _StepBusObj.ValueChainStepBusinessObject = $projection.ValueChainStepBusinessObject
[0..1] I_IntcoValueChainDocStatus _Status $projection.IntcoValueChainDocumentStatus = _Status.IntcoValueChainDocumentStatus
[0..*] I_IntcoValChnDocConncn _Predecessor _Predecessor.ValueChainStepInstanceUUID = $projection.ValueChainStepInstanceUUID and _Predecessor.ValueChainDocumentItemOrigin = $projection.ValueChainDocumentItemOrigin and _Predecessor.ValueChainBusinessObject = $projection.ValueChainBusinessObject and _Predecessor.ValueChainInstanceUUID = $projection.ValueChainInstanceUUID
[0..1] I_ValueChainStepBusObj _PredecessorStepBusObj _PredecessorStepBusObj.ValueChainStepBusinessObject = $projection.ValueChainPredecessorStpBusObj
[0..1] I_ValueChainStepInstanceSched _Schedule _Schedule.ValueChainStepInstanceUUID = $projection.ValueChainStepInstanceUUID
[0..1] I_ValueChainStepType _ValueChainStepType _ValueChainStepType.ValueChainType = $projection.ValueChainType and _ValueChainStepType.ValueChainTypeVersion = $projection.ValueChainTypeVersion and _ValueChainStepType.ValueChainStepType = $projection.ValueChainStepType
[0..*] C_IntcoValueChainDocumentItmTP _Item
[0..*] C_IntcoValChnMntrDocItmHier _DocumentHier

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
EndUserText.label Intercompany Value Chain Document view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY ValueChainStepInstanceUUID ValueChainStepInstanceUUID
KEY ValueChainDocumentItemOrigin ValueChainDocumentItemOrigin
KEY ValueChainBusinessObject ValueChainBusinessObject
ValueChainStepBusinessObject ValueChainStepBusinessObject
ValueChainInstanceUUID ValueChainInstanceUUID
ValueChainStepPredecessorUUID _Step ValueChainStepPredecessorUUID
ValueChainPredecessorStpBusObj ValueChainPredecessorStpBusObj
NumberOfValueChainDocItems NumberOfValueChainDocItems
NumberOfCancelledValChnDocItms NumberOfCancelledValChnDocItms
IsReversalDocument IsReversalDocument Reverse
ValueChainStepInstanceStatus _Step ValueChainStepInstanceStatus
ValueChainType _Instance ValueChainType
ValueChainTypeVersion _Instance ValueChainTypeVersion
ValueChainStepType _Step ValueChainStepType
_Item _Item
_DocumentHier _DocumentHier
_Step _Step
_StepBusObj _StepBusObj
_Instance _Instance
_Predecessor _Predecessor
_PredecessorStepBusObj _PredecessorStepBusObj
_Status _Status
_Schedule _Schedule
_ValueChainStepType _ValueChainStepType

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 C_IntcoValueChainDocumentTP.
-- 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 C_IntcoValueChainDocumentTP AS
SELECT
  ValueChainStepInstanceUUID,
  ValueChainDocumentItemOrigin,
  ValueChainBusinessObject,
  ValueChainStepBusinessObject,
  ValueChainInstanceUUID,
  _Step.ValueChainStepPredecessorUUID AS ValueChainStepPredecessorUUID,
  ValueChainPredecessorStpBusObj,
  NumberOfValueChainDocItems,
  NumberOfCancelledValChnDocItms,
  IsReversalDocument,
  _Step.ValueChainStepInstanceStatus AS ValueChainStepInstanceStatus,
  _Instance.ValueChainType AS ValueChainType,
  _Instance.ValueChainTypeVersion AS ValueChainTypeVersion,
  _Step.ValueChainStepType AS ValueChainStepType
FROM I_IntcoValueChainDocument AS Document
LEFT OUTER JOIN R_ValueChainStepInstanceTP AS _Step ON _Step.ValueChainStepInstanceUUID = ValueChainStepInstanceUUID AND _Step.ValueChainInstanceUUID = ValueChainInstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_ValueChainStepBusObj AS _StepBusObj ON _StepBusObj.ValueChainStepBusinessObject = ValueChainStepBusinessObject  -- association [0..1]
LEFT OUTER JOIN I_IntcoValueChainDocStatus AS _Status ON IntcoValueChainDocumentStatus = _Status.IntcoValueChainDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_IntcoValChnDocConncn AS _Predecessor ON _Predecessor.ValueChainStepInstanceUUID = ValueChainStepInstanceUUID AND _Predecessor.ValueChainDocumentItemOrigin = ValueChainDocumentItemOrigin AND _Predecessor.ValueChainBusinessObject = ValueChainBusinessObject AND _Predecessor.ValueChainInstanceUUID = ValueChainInstanceUUID  -- association [0..*]
LEFT OUTER JOIN I_ValueChainStepBusObj AS _PredecessorStepBusObj ON _PredecessorStepBusObj.ValueChainStepBusinessObject = ValueChainPredecessorStpBusObj  -- association [0..1]
LEFT OUTER JOIN I_ValueChainStepInstanceSched AS _Schedule ON _Schedule.ValueChainStepInstanceUUID = ValueChainStepInstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_ValueChainStepType AS _ValueChainStepType ON _ValueChainStepType.ValueChainType = ValueChainType AND _ValueChainStepType.ValueChainTypeVersion = ValueChainTypeVersion AND _ValueChainStepType.ValueChainStepType = ValueChainStepType  -- association [0..1]
LEFT OUTER JOIN C_IntcoValueChainDocumentItmTP AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_IntcoValChnMntrDocItmHier AS _DocumentHier ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More