I_ChgOrdItmPrdcssrContrItm

DDL: I_CHGORDITMPRDCSSRCONTRITM Type: view_entity COMPOSITE

Item predecessor Contract

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

Data Sources (1)

SourceAliasJoin Type
crmd_brelvonai crmd_brelvonai from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ServiceDocumentItemEnhcd _SubscriptionOrderItem $projection.ServiceDocItmSuccssrCharUUID = _SubscriptionOrderItem.ServiceDocumentItemCharUUID
[1..1] I_ServiceDocumentItemEnhcd _ServiceDocPredecessorItm $projection.ServiceDocumentItemCharUUID = _ServiceDocPredecessorItm.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 predecessor Contract view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionOrder _SubscriptionOrderItem ServiceDocument
KEY SubscriptionOrderItem _SubscriptionOrderItem ServiceDocumentItem
KEY ServiceDocumentItmRelationUUID relationid
KEY ServiceDocItmRltnSqncNumber posno
ServiceDocumentItemCharUUID
ServiceDocItmSuccssrCharUUID
ServiceDocumentItmRelationType breltyp
ServiceDocumentItemObjectType objtype_a
ServiceDocumentItmRelationKind vona_kind
ServiceDocItmSuccssrBusObjType objtype_b
_ServiceDocPredecessorItm _ServiceDocPredecessorItm
_SubscriptionOrderItem _SubscriptionOrderItem
_SubscriptionOrder _SubscriptionOrder
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}

@EndUserText.label: 'Item predecessor Contract'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view entity I_ChgOrdItmPrdcssrContrItm
  as select from crmd_brelvonai
  association [1..1] to I_ServiceDocumentItemEnhcd as _SubscriptionOrderItem    on $projection.ServiceDocItmSuccssrCharUUID = _SubscriptionOrderItem.ServiceDocumentItemCharUUID
  association [1..1] to I_ServiceDocumentItemEnhcd as _ServiceDocPredecessorItm on $projection.ServiceDocumentItemCharUUID = _ServiceDocPredecessorItm.ServiceDocumentItemCharUUID
  association [1..1] to I_SubscriptionOrder        as _SubscriptionOrder        on $projection.SubscriptionOrder = _SubscriptionOrder.SubscriptionOrder
{
  key _SubscriptionOrderItem.ServiceDocument                     as SubscriptionOrder,
  key _SubscriptionOrderItem.ServiceDocumentItem                 as SubscriptionOrderItem,
  key relationid                                                 as ServiceDocumentItmRelationUUID,
  key posno                                                      as ServiceDocItmRltnSqncNumber,

      cast(objkey_a as crms4_object_charguid32 preserving type ) as ServiceDocumentItemCharUUID,

      cast(objkey_b as crms4_object_charguid32 preserving type ) as ServiceDocItmSuccssrCharUUID,
      breltyp                                                    as ServiceDocumentItmRelationType,

      objtype_a                                                  as ServiceDocumentItemObjectType,
      vona_kind                                                  as ServiceDocumentItmRelationKind,
      objtype_b                                                  as ServiceDocItmSuccssrBusObjType,

      //Associations

      _ServiceDocPredecessorItm,
      _SubscriptionOrderItem,
      _SubscriptionOrder

}
where
  objtype_b = 'BUS2000155'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTITEMENHCD",
"CRMD_BRELVONAI"
],
"ASSOCIATED":
[
"I_SERVICEDOCUMENTITEMENHCD",
"I_SUBSCRIPTIONORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/