R_SubscrpnOrdItmFUPSlsOrdItmTP

DDL: R_SUBSCRPNORDITMFUPSLSORDITMTP Type: view_entity TRANSACTIONAL Package: CRMS4_SOM_LEGACY
8 Fields 1 Data Sources

Item Followup Sales Order Item - TP

R_SubscrpnOrdItmFUPSlsOrdItmTP is a Transactional CDS View that provides data about "Item Followup Sales Order Item - TP" in SAP S/4HANA. It reads from 1 data source (I_SubscrpnOrdItmFUPSlsOrdItm) and exposes 8 fields with key fields SubscriptionOrder, SubscriptionOrderItem, ServiceDocumentItmRelationUUID, ServiceDocItmRltnSqncNumber. Part of development package CRMS4_SOM_LEGACY.

Data Sources (1)

SourceAliasJoin Type
I_SubscrpnOrdItmFUPSlsOrdItm I_SubscrpnOrdItmFUPSlsOrdItm from

Annotations (8)

NameValueLevelField
EndUserText.label Item Followup Sales Order Item - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionOrder SubscriptionOrder Transaction ID
KEY SubscriptionOrderItem SubscriptionOrderItem Service Document
KEY ServiceDocumentItmRelationUUID ServiceDocumentItmRelationUUID
KEY ServiceDocItmRltnSqncNumber ServiceDocItmRltnSqncNumber
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
_SubscriptionOrderTP _SubscriptionOrderTP
_SubscriptionOrderItemTP _SubscriptionOrderItemTP

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 R_SubscrpnOrdItmFUPSlsOrdItmTP.
-- 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 R_SubscrpnOrdItmFUPSlsOrdItmTP AS
SELECT
  SubscriptionOrder,
  SubscriptionOrderItem,
  ServiceDocumentItmRelationUUID,
  ServiceDocItmRltnSqncNumber,
  SalesOrder,
  SalesOrderItem
FROM I_SubscrpnOrdItmFUPSlsOrdItm
;

Learn More