I_JITCallDocRefBasic

DDL: I_JITCALLDOCREFBASIC SQL: IJITCALLDOCREF Type: view BASIC

JIT Call Document Reference

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

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
njit_call_d_dref njit_call_d_dref from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_DeliveryDocumentItem _DeliveryDocumentItem $projection.BusinessTransactionDocument = _DeliveryDocumentItem.DeliveryDocument and $projection.BusinessTransactionDocItem = _DeliveryDocumentItem.DeliveryDocumentItem and $projection.BusinessTransactionDocType = _DeliveryDocumentItem.SDDocumentCategory
[0..*] I_JITCallCompMaterialBasic _JITCallCompMaterialBasic $projection.JITCallComponentUUID = _JITCallCompMaterialBasic.JITCallComponentUUID
[0..1] I_JITCallHeaderBasic _JITCallHeaderBasic $projection.JITHeaderUUID = _JITCallHeaderBasic.JITHeaderUUID and $projection.InternalJITCallNumber = _JITCallHeaderBasic.InternalJITCallNumber

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IJITCALLDOCREF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label JIT Call Document Reference view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY JITDocRefUUID db_key
JITHeaderUUID root_key
JITCallComponentUUID parent_key
InternalJITCallNumber int_call_num
JITCallItemNumber call_item_num
BusinessTransactionDocType btd_type_code
BusinessTransactionDocument btd_id
BusinessTransactionDocItem btd_item_id
BusinessTransactionDocStatus btd_status
LogicalSystemID logsys
LastChangeDateTime lchg_date_time
DataAgingObject _dataaging
CompGrpNumber comp_grp_num
_DeliveryDocumentItem _DeliveryDocumentItem
_JITCallHeaderBasic _JITCallHeaderBasic
_JITCallCompMaterialBasic _JITCallCompMaterialBasic 
@AbapCatalog.sqlViewName: 'IJITCALLDOCREF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'JIT Call Document Reference'
@ClientHandling: {
  type: #INHERITED,
  algorithm: #SESSION_VARIABLE
}
@AccessControl: {
  authorizationCheck: #CHECK
}

@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@ObjectModel: {
  usageType.dataClass: #TRANSACTIONAL,
  usageType.serviceQuality: #A,
  usageType.sizeCategory: #XL
}
define view I_JITCallDocRefBasic
  as select from njit_call_d_dref
  association [0..1] to I_DeliveryDocumentItem     as _DeliveryDocumentItem     on  $projection.BusinessTransactionDocument = _DeliveryDocumentItem.DeliveryDocument
                                                                                and $projection.BusinessTransactionDocItem  = _DeliveryDocumentItem.DeliveryDocumentItem
                                                                                and $projection.BusinessTransactionDocType  = _DeliveryDocumentItem.SDDocumentCategory
  association [0..*] to I_JITCallCompMaterialBasic as _JITCallCompMaterialBasic on  $projection.JITCallComponentUUID = _JITCallCompMaterialBasic.JITCallComponentUUID
  
  association [0..1] to I_JITCallHeaderBasic       as _JITCallHeaderBasic       on  $projection.JITHeaderUUID        = _JITCallHeaderBasic.JITHeaderUUID 
                                                                                and $projection.InternalJITCallNumber = _JITCallHeaderBasic.InternalJITCallNumber
 
//  association [0..*] to I_HandlingUnitHeaderCombined as _HandlingUnitHeaderCombined on  $projection.BusinessTransactionDocument = _HandlingUnitHeaderCombined.HandlingUnitExternalID

//                                                                                    and $projection.BusinessTransactionDocType  = 'X'

//  association [0..1] to I_HandlingUnitProcessStatusTxt  as _HandlingUnitProcessStatusTxt on  $projection.HandlingUnitProcessStatus = _HandlingUnitProcessStatusTxt.HandlingUnitProcessStatus

//                                                                                         and _HandlingUnitProcessStatusTxt.language = $session.system_language

{
      //njit_call_d_dref

  key db_key         as JITDocRefUUID,
      root_key       as JITHeaderUUID,
      parent_key     as JITCallComponentUUID,
      int_call_num   as InternalJITCallNumber,
      call_item_num  as JITCallItemNumber,
      btd_type_code  as BusinessTransactionDocType,
      btd_id         as BusinessTransactionDocument,
      //ltrim(btd_id,'0'  ) as BusinessTransactionDocument,

      btd_item_id    as BusinessTransactionDocItem,
      btd_status     as BusinessTransactionDocStatus,
      logsys         as LogicalSystemID,
      lchg_date_time as LastChangeDateTime,
      _dataaging     as DataAgingObject,
      comp_grp_num   as CompGrpNumber,
//      _HandlingUnitHeaderCombined.HandlingUnitProcessStatus as HandlingUnitProcessStatus,

      
      _DeliveryDocumentItem,
      _JITCallHeaderBasic,
      _JITCallCompMaterialBasic
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"NJIT_CALL_D_DREF"
],
"ASSOCIATED":
[
"I_DELIVERYDOCUMENTITEM",
"I_JITCALLCOMPMATERIALBASIC",
"I_JITCALLHEADERBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More