I_SubscrpnContrItmSuccessor

DDL: I_SUBSCRPNCONTRITMSUCCESSOR Type: view_entity COMPOSITE
13 Fields 1 Data Sources 3 Associations

Follow-Up of Subscription Contract Item

I_SubscrpnContrItmSuccessor is a Composite CDS View that provides data about "Follow-Up of Subscription Contract Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemSuccessor) and exposes 13 fields with key fields SubscriptionContract, SubscriptionContractItem, ServiceDocumentItmRelationUUID, ServiceDocItmRltnSqncNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemSuccessor I_ServiceDocumentItemSuccessor from

Associations (3)

CardinalityTargetAliasCondition
[1] I_ServiceDocumentItemEnhcd _ContractItem $projection.ServiceDocumentItemCharUUID = _ContractItem.ServiceDocumentItemCharUUID
[1] I_ServiceDocumentItemEnhcd _ServiceDocFollowUpItm $projection.ServiceDocItmSuccssrCharUUID = _ServiceDocFollowUpItm.ServiceDocumentItemCharUUID
[1] I_SubscriptionContract _SubscriptionContract $projection.SubscriptionContract = _SubscriptionContract.SubscriptionContract

Annotations (7)

NameValueLevelField
EndUserText.label Follow-Up of Subscription Contract Item view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionContract _ContractItem ServiceDocument Transaction ID
KEY SubscriptionContractItem _ContractItem ServiceDocumentItem Service Document
KEY ServiceDocumentItmRelationUUID ServiceDocumentItmRelationUUID GUID link
KEY ServiceDocItmRltnSqncNumber ServiceDocItmRltnSqncNumber Sequential no.
ServiceDocumentItemCharUUID Object ID
ServiceDocItmSuccssrCharUUID Object ID
ServiceDocumentItmRelationType ServiceDocumentItmRelationType Rel. Type
ServiceDocumentItemObjectType ServiceDocumentItemObjectType Object Type
ServiceDocumentItmRelationKind ServiceDocumentItmRelationKind Type VONA
ServiceDocItmSuccssrBusObjType ServiceDocItmSuccssrBusObjType Object Type
_ContractItem _ContractItem
_ServiceDocFollowUpItm _ServiceDocFollowUpItm
_SubscriptionContract _SubscriptionContract

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_SubscrpnContrItmSuccessor.
-- 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_SubscrpnContrItmSuccessor AS
SELECT
  _ContractItem.ServiceDocument AS SubscriptionContract,
  _ContractItem.ServiceDocumentItem AS SubscriptionContractItem,
  ServiceDocumentItmRelationUUID,
  ServiceDocItmRltnSqncNumber,
  cast(ServiceDocumentItemCharUUID as crms4_object_charguid32 preserving type ) AS ServiceDocumentItemCharUUID,
  cast(ServiceDocItmSuccssrCharUUID as crms4_object_charguid32 preserving type ) AS ServiceDocItmSuccssrCharUUID,
  ServiceDocumentItmRelationType,
  ServiceDocumentItemObjectType,
  ServiceDocumentItmRelationKind,
  ServiceDocItmSuccssrBusObjType
FROM I_ServiceDocumentItemSuccessor
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _ContractItem ON ServiceDocumentItemCharUUID = _ContractItem.ServiceDocumentItemCharUUID  -- association [1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _ServiceDocFollowUpItm ON ServiceDocItmSuccssrCharUUID = _ServiceDocFollowUpItm.ServiceDocumentItemCharUUID  -- association [1]
LEFT OUTER JOIN I_SubscriptionContract AS _SubscriptionContract ON SubscriptionContract = _SubscriptionContract.SubscriptionContract  -- association [1]
;

Learn More