I_SubscrpnOrdItmFUPContrItm

DDL: I_SUBSCRPNORDITMFUPCONTRITM Type: view_entity COMPOSITE

Item FUP Contract

I_SubscrpnOrdItmFUPContrItm is a Composite CDS View that provides data about "Item FUP Contract" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemSuccssr_2) and exposes 9 fields with key fields SubscriptionOrder, SubscriptionOrderItem, ServiceDocumentItmRelationUUID, ServiceDocItmRltnSqncNumber. It has 2 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemSuccssr_2 I_ServiceDocumentItemSuccssr_2 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ServiceDocumentItemEnhcd _SourceItemDoc $projection.SubscriptionOrderItemCharUUID = _SourceItemDoc.ServiceDocumentItemCharUUID
[1..1] I_SubscriptionOrder _SubscriptionOrder $projection.SubscriptionOrder = _SubscriptionOrder.SubscriptionOrder

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Item FUP Contract view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionOrder _SourceItemDoc ServiceDocument
KEY SubscriptionOrderItem _SourceItemDoc ServiceDocumentItem
KEY ServiceDocumentItmRelationUUID ServiceDocumentItmRelationUUID
KEY ServiceDocItmRltnSqncNumber ServiceDocItmRltnSqncNumber
SubscriptionOrderItemCharUUID ServiceDocumentItemCharUUID
SubscriptionContract _ServiceDocItm ServiceDocument
SubscriptionContractItem _ServiceDocItm ServiceDocumentItem
SubscriptionContractExternalID _ServiceDocItm SubscriptionContract
_SubscriptionOrder _SubscriptionOrder 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}

@EndUserText.label: 'Item FUP Contract'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}
define view entity I_SubscrpnOrdItmFUPContrItm
  as select from I_ServiceDocumentItemSuccssr_2
  association [1..1] to I_ServiceDocumentItemEnhcd as _SourceItemDoc on $projection.SubscriptionOrderItemCharUUID = _SourceItemDoc.ServiceDocumentItemCharUUID
  association [1..1] to I_SubscriptionOrder        as _SubscriptionOrder on $projection.SubscriptionOrder = _SubscriptionOrder.SubscriptionOrder
{
  key     _SourceItemDoc.ServiceDocument      as SubscriptionOrder,
  key     _SourceItemDoc.ServiceDocumentItem  as SubscriptionOrderItem,
  key     ServiceDocumentItmRelationUUID,
  key     ServiceDocItmRltnSqncNumber,
          ServiceDocumentItemCharUUID  as SubscriptionOrderItemCharUUID,
          _ServiceDocItm.ServiceDocument      as SubscriptionContract,
          _ServiceDocItm.ServiceDocumentItem  as SubscriptionContractItem,
          @ObjectModel.readOnly: true
          _ServiceDocItm.SubscriptionContract as SubscriptionContractExternalID,

          //Association

          _SubscriptionOrder
}
where
      _SourceItemDoc.ServiceObjectType = 'BUS2000265'
  and _ServiceDocItm.ServiceObjectType = 'BUS2000266'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTITEMENHCD",
"I_SERVICEDOCUMENTITEMSUCCSSR_2"
],
"ASSOCIATED":
[
"I_SUBSCRIPTIONORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More