I_JITInbCallCompGrpDocRef

DDL: I_JITINBCALLCOMPGRPDOCREF Type: view_entity BASIC

JIT Inbound Call CG Document Reference

I_JITInbCallCompGrpDocRef is a Basic CDS View (Dimension) that provides data about "JIT Inbound Call CG Document Reference" in SAP S/4HANA. It reads from 1 data source (njit_call_d_dref) and exposes 17 fields with key field JITDocRefUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
njit_call_d_dref njit_call_d_dref from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_DeliveryDocumentItem _DeliveryDocumentItem $projection.BusinessTransactionDocument = _DeliveryDocumentItem.DeliveryDocument and $projection.BusinessTransactionDocItem = _DeliveryDocumentItem.DeliveryDocumentItem and $projection.BusinessTransactionDocType = 'J'
[1..1] I_JITHandlingUnitHeader _JITHandlingUnitHeader $projection.BusinessTransactionDocument = _JITHandlingUnitHeader.HandlingUnitExternalID and $projection.BusinessTransactionDocType = 'X'
[1..1] I_JITInboundCall _JITInboundCall $projection.JITHeaderUUID = _JITInboundCall.JITHeaderUUID

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
EndUserText.label JIT Inbound Call CG Document Reference view
Metadata.allowExtensions 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 (17)

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
_JITInbCallComponentGroup _JITInbCallComponentGroup
_DeliveryDocumentItem _DeliveryDocumentItem
_JITInboundCall _JITInboundCall
_JITHandlingUnitHeader _JITHandlingUnitHeader
@AccessControl.authorizationCheck     : #MANDATORY
@Analytics                            : { dataCategory            : #DIMENSION,
                                          internalName            : #LOCAL }
@EndUserText.label                    : 'JIT Inbound Call CG Document Reference'
@Metadata.allowExtensions             : 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
                                                                                       and $projection.BusinessTransactionDocType  = 'J'
  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
{
  key db_key             as JITDocRefUUID,
      root_key           as JITHeaderUUID,
      parent_key         as JITCallCompGrpUUID,
      int_call_num       as InternalJITCallNumber,
      comp_grp_num       as CompGrpNumber,
      call_item_num      as JITCallItemNumber,
      btd_type_code      as BusinessTransactionDocType,
      btd_id             as BusinessTransactionDocument,
      btd_item_id        as BusinessTransactionDocItem,
      btd_item_type_code as BusinessTransacDocItmTypeCode,
      btd_status         as BusinessTransactionDocStatus,
      logsys             as LogicalSystemID,
      lchg_date_time     as LastChangeDateTime,
      //associations

      _JITInbCallComponentGroup,
      _DeliveryDocumentItem,
      _JITInboundCall,
      _JITHandlingUnitHeader
}
where
  _JITInboundCall.JITScenario = '1'