I_JITInbCallCompGrpDocRef

DDL: I_JITINBCALLCOMPGRPDOCREF Type: view_entity BASIC Package: NJIT_MODEL_INBOUNDCALL

JIT Inbound Call Component Group Doc Ref

I_JITInbCallCompGrpDocRef is a Basic CDS View (Dimension) that provides data about "JIT Inbound Call Component Group Doc Ref" in SAP S/4HANA. It reads from 1 data source (njit_call_d_dref) and exposes 20 fields with key field JITDocRefUUID. It has 5 associations to related views. Part of development package NJIT_MODEL_INBOUNDCALL.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
njit_call_d_dref njit_call_d_dref from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_DeliveryDocumentItem _DeliveryDocumentItem $projection.BusinessTransactionDocument = _DeliveryDocumentItem.DeliveryDocument and $projection.BusinessTransactionDocItem = _DeliveryDocumentItem.DeliveryDocumentItem
[1..1] I_JITHandlingUnitHeader _JITHandlingUnitHeader $projection.BusinessTransactionDocument = _JITHandlingUnitHeader.HandlingUnitExternalID and $projection.BusinessTransactionDocType = 'X'
[1..1] I_JITInboundCall _JITInboundCall $projection.JITHeaderUUID = _JITInboundCall.JITHeaderUUID
[0..1] I_JITBusTransDocType _JITBusTransDocType $projection.BusinessTransactionDocType = _JITBusTransDocType.BusinessTransactionDocType
[0..1] I_JITBusTransDocItemType _JITBusTransDocItemType $projection.BusinessTransacDocItmTypeCode = _JITBusTransDocItemType.BusinessTransacDocItmTypeCode

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
EndUserText.label JIT Inbound Call Component Group Doc Ref view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey JITDocRefUUID view
ObjectModel.sapObjectNodeType.name JITInbCallCompGrpDocRef view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #BASIC view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY JITDocRefUUID db_key
JITHeaderUUID root_key
JITCallCompGrpUUID parent_key
InternalJITCallNumber int_call_num
CompGrpNumber comp_grp_num
JITCallItemNumber call_item_num
BusinessTransactionDocType btd_type_code
BusinessTransactionDocument btd_id
BusinessTransactionDocItem btd_item_id
BusinessTransacDocItmTypeCode btd_item_type_code
BusinessTransactionDocStatus btd_status
LogicalSystemID logsys
LastChangeDateTime lchg_date_time
BusinessTransactionDocUUID businesstransactiondocuuid
_JITInbCallComponentGroup _JITInbCallComponentGroup
_DeliveryDocumentItem _DeliveryDocumentItem
_JITInboundCall _JITInboundCall
_JITHandlingUnitHeader _JITHandlingUnitHeader
_JITBusTransDocType _JITBusTransDocType
_JITBusTransDocItemType _JITBusTransDocItemType 
@AccessControl                          : { authorizationCheck      : #MANDATORY,
                                            personalData.blocking   : #REQUIRED }
@Analytics                              : { dataCategory            : #DIMENSION,
                                            internalName            : #LOCAL }
@EndUserText.label                      : 'JIT Inbound Call Component Group Doc Ref'
@Metadata.allowExtensions               : true
@Metadata.ignorePropagatedAnnotations   : true
@ObjectModel                            : { modelingPattern         : #ANALYTICAL_DIMENSION,
                                            representativeKey       : 'JITDocRefUUID',
                                            sapObjectNodeType.name  : 'JITInbCallCompGrpDocRef',
                                            supportedCapabilities   : [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ],
                                            usageType               : { dataClass       : #TRANSACTIONAL,
                                                                        serviceQuality  : #A,
                                                                        sizeCategory    : #XXL }
                                          }
@VDM.viewType                           : #BASIC
define view entity I_JITInbCallCompGrpDocRef
  as select from njit_call_d_dref
  association        to parent I_JITInbCallComponentGroup as _JITInbCallComponentGroup on  $projection.JITCallCompGrpUUID = _JITInbCallComponentGroup.JITCallCompGrpUUID
  association [1..1] to I_DeliveryDocumentItem            as _DeliveryDocumentItem     on  $projection.BusinessTransactionDocument = _DeliveryDocumentItem.DeliveryDocument
                                                                                       and $projection.BusinessTransactionDocItem  = _DeliveryDocumentItem.DeliveryDocumentItem
  association [1..1] to I_JITHandlingUnitHeader           as _JITHandlingUnitHeader    on  $projection.BusinessTransactionDocument = _JITHandlingUnitHeader.HandlingUnitExternalID
                                                                                       and $projection.BusinessTransactionDocType  = 'X'
  association [1..1] to I_JITInboundCall                  as _JITInboundCall           on  $projection.JITHeaderUUID = _JITInboundCall.JITHeaderUUID

  association [0..1] to I_JITBusTransDocType              as _JITBusTransDocType       on  $projection.BusinessTransactionDocType = _JITBusTransDocType.BusinessTransactionDocType
  association [0..1] to I_JITBusTransDocItemType          as _JITBusTransDocItemType   on  $projection.BusinessTransacDocItmTypeCode = _JITBusTransDocItemType.BusinessTransacDocItmTypeCode
{
  key db_key                     as JITDocRefUUID,
      @ObjectModel.foreignKey.association : '_JITInboundCall'
      root_key                   as JITHeaderUUID,
      @ObjectModel.foreignKey.association : '_JITInbCallComponentGroup'
      parent_key                 as JITCallCompGrpUUID,
      int_call_num               as InternalJITCallNumber,
      comp_grp_num               as CompGrpNumber,
      call_item_num              as JITCallItemNumber,
      @ObjectModel.foreignKey.association : '_JITBusTransDocType'
      btd_type_code              as BusinessTransactionDocType,
      btd_id                     as BusinessTransactionDocument,
      btd_item_id                as BusinessTransactionDocItem,
      @ObjectModel.foreignKey.association : '_JITBusTransDocItemType'
      btd_item_type_code         as BusinessTransacDocItmTypeCode,
      btd_status                 as BusinessTransactionDocStatus,
      logsys                     as LogicalSystemID,
      lchg_date_time             as LastChangeDateTime,
      businesstransactiondocuuid as BusinessTransactionDocUUID,
      //associations

      _JITInbCallComponentGroup,
      _DeliveryDocumentItem,
      _JITInboundCall,
      _JITHandlingUnitHeader,
      _JITBusTransDocType,
      _JITBusTransDocItemType
}
where
      _JITInboundCall.JITScenario = '1'
  and comp_grp_num                is not initial
  and call_item_num               is initial

Learn More