P_JITCallComponentMatlDocRef

DDL: P_JITCALLCOMPONENTMATLDOCREF Type: view_entity TRANSACTIONAL

JIT Component Material Doc Ref

P_JITCallComponentMatlDocRef is a Transactional CDS View that provides data about "JIT Component Material Doc Ref" in SAP S/4HANA. It reads from 1 data source (njit_call_d_dref) and exposes 8 fields with key field JITDocRefUUID. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
njit_call_d_dref njit_call_d_dref from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialDocumentHeader_2 _MaterialDocumentHeader $projection.MaterialDocument = _MaterialDocumentHeader.MaterialDocument and $projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label JIT Component Material Doc Ref view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY JITDocRefUUID db_key
JITHeaderUUID root_key
JITCallComponentUUID parent_key
MaterialDocument
MaterialDocumentYear
InternalJITCallNumber int_call_num
CompGrpNumber comp_grp_num
_MaterialDocumentHeader _MaterialDocumentHeader 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'JIT Component Material Doc Ref'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #C,
  sizeCategory: #L
}
@VDM.viewType: #TRANSACTIONAL
@VDM.private: true
define view entity P_JITCallComponentMatlDocRef
  as select from njit_call_d_dref
  association [0..1] to I_MaterialDocumentHeader_2 as _MaterialDocumentHeader on  $projection.MaterialDocument     = _MaterialDocumentHeader.MaterialDocument
                                                                              and $projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear
{
  key  db_key                                                                   as JITDocRefUUID,
       root_key                                                                 as JITHeaderUUID,
       parent_key                                                               as JITCallComponentUUID,
       cast(btd_id as abap.char(10))                                            as MaterialDocument,
       cast(left(cast(lchg_date_time as abap.char( 28 )), 4) as abap.numc( 4 )) as MaterialDocumentYear,
       int_call_num                                                             as InternalJITCallNumber,
       comp_grp_num                                                             as CompGrpNumber,

       //Associations

       _MaterialDocumentHeader
}
where
  btd_type_code = 'M'

Learn More