I_JITCallCompMaterialBasic

DDL: I_JITCALLCOMPMATERIALBASIC Type: view_entity BASIC

JIT Call Components

I_JITCallCompMaterialBasic is a Basic CDS View that provides data about "JIT Call Components" in SAP S/4HANA. It reads from 1 data source (njit_call_d_cmat) and exposes 29 fields with key fields JITCallComponentUUID, JITHeaderUUID, JITCallCompGrpUUID, InternalJITCallNumber, CompGrpNumber. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
njit_call_d_cmat njit_call_d_cmat from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_JITCallHeaderBasic _JITCallHeaderBasic $projection.JITHeaderUUID = _JITCallHeaderBasic.JITHeaderUUID
[1..1] I_Product _ProductCompMatl $projection.Material = _ProductCompMatl.Product
[0..1] I_JITCallCompGroupBasic _JITCallCompGroupBasic $projection.JITCallCompGrpUUID = _JITCallCompGroupBasic.JITCallCompGrpUUID and $projection.InternalJITCallNumber = _JITCallCompGroupBasic.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallCompGroupBasic.CompGrpNumber
[0..*] I_JITCallDocRefBasic _JITCallDocRefBasic $projection.JITCallComponentUUID = _JITCallDocRefBasic.JITCallComponentUUID
[0..1] I_ProductPlant _ProductPlant $projection.Material = _ProductPlant.Product and $projection.Plant = _ProductPlant.Plant

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label JIT Call Components view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY JITCallComponentUUID db_key
KEY JITHeaderUUID root_key
KEY JITCallCompGrpUUID parent_key
KEY InternalJITCallNumber int_call_num
KEY CompGrpNumber comp_grp_num
KEY JITCallItemNumber call_item_num
Material matnr
MaterialByCustomer kdmat
ExtJITCallItemNumber ext_call_item_num
SalesOrder vbeln
SalesOrderItem posnr
Division spart
RequestedQuantity requested_quantity
ActualDeliveredQuantity delivered_quantity
QuantityUnit meins
JITIntProcessingStatus int_stat
JITCallCompMatlBackflushStatus jitcallcompmatlbackflushstatus
JITCallCompMatlBackflushType jitcallcompmatlbackflushtype
JITCallCompBackflushStsUpdtdOn jitcallcompbackflushstsupdtdon
JITProdnConfirmationControl
SupplyControlUUID _JITCallCompGroupBasic SupplyControlUUID
MaterialGroup
MaterialGroupName
Plant _JITCallCompGroupBasic Plant
_ProductCompMatl _ProductCompMatl
_JITCallDocRefBasic _JITCallDocRefBasic
_JITCallCompGroupBasic _JITCallCompGroupBasic
_ProductPlant _ProductPlant
_JITCallHeaderBasic _JITCallHeaderBasic
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #NOT_REQUIRED
}
@EndUserText.label: 'JIT Call Components'
@ObjectModel: {
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #B,
    sizeCategory: #XXL
  }
}
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
define view entity I_JITCallCompMaterialBasic
  as select from njit_call_d_cmat
  association [1..1] to I_JITCallHeaderBasic    as _JITCallHeaderBasic    on  $projection.JITHeaderUUID = _JITCallHeaderBasic.JITHeaderUUID
  association [1..1] to I_Product               as _ProductCompMatl       on  $projection.Material = _ProductCompMatl.Product
  association [0..1] to I_JITCallCompGroupBasic as _JITCallCompGroupBasic on  $projection.JITCallCompGrpUUID    = _JITCallCompGroupBasic.JITCallCompGrpUUID
                                                                          and $projection.InternalJITCallNumber = _JITCallCompGroupBasic.InternalJITCallNumber
                                                                          and $projection.CompGrpNumber         = _JITCallCompGroupBasic.CompGrpNumber
  association [0..*] to I_JITCallDocRefBasic    as _JITCallDocRefBasic    on  $projection.JITCallComponentUUID = _JITCallDocRefBasic.JITCallComponentUUID
  association [0..1] to I_ProductPlant          as _ProductPlant          on  $projection.Material = _ProductPlant.Product
                                                                          and $projection.Plant    = _ProductPlant.Plant
{
  key db_key                                                                                      as JITCallComponentUUID,
  key root_key                                                                                    as JITHeaderUUID,      //CE2008

  key parent_key                                                                                  as JITCallCompGrpUUID, //CE2008

  key int_call_num                                                                                as InternalJITCallNumber,
  key comp_grp_num                                                                                as CompGrpNumber,
  key call_item_num                                                                               as JITCallItemNumber,
      matnr                                                                                       as Material,
      kdmat                                                                                       as MaterialByCustomer,
      ext_call_item_num                                                                           as ExtJITCallItemNumber,
      vbeln                                                                                       as SalesOrder,
      posnr                                                                                       as SalesOrderItem,
      spart                                                                                       as Division,
      @Semantics.quantity.unitOfMeasure: 'QUANTITYUNIT'
      requested_quantity                                                                          as RequestedQuantity,
      @Semantics.quantity.unitOfMeasure: 'QUANTITYUNIT'
      delivered_quantity                                                                          as ActualDeliveredQuantity,
      meins                                                                                       as QuantityUnit,
      int_stat                                                                                    as JITIntProcessingStatus, //CE2008

      jitcallcompmatlbackflushstatus                                                              as JITCallCompMatlBackflushStatus, //CE2011

      jitcallcompmatlbackflushtype                                                                as JITCallCompMatlBackflushType,   //CE2011

      jitcallcompbackflushstsupdtdon                                                              as JITCallCompBackflushStsUpdtdOn, //CE2011

      _JITCallCompGroupBasic._JITSupplyControlHeader.JITProdnConfirmationControl, //CE2011

      _JITCallCompGroupBasic.SupplyControlUUID,
      _ProductCompMatl._ProductGroup.MaterialGroup                                                as MaterialGroup,
      _ProductCompMatl._ProductGroup._Text[1:Language=$session.system_language].MaterialGroupName as MaterialGroupName,
      _JITCallCompGroupBasic.Plant                                                                as Plant,
      //Associations

      _ProductCompMatl,
      _JITCallDocRefBasic,
      _JITCallCompGroupBasic,
      _ProductPlant,
      _JITCallHeaderBasic
}
where
  _JITCallHeaderBasic.JITScenario = '1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JITCALLCOMPGROUPBASIC",
"I_JITCALLHEADERBASIC",
"I_JITSUPPLYCONTROLHEADER",
"I_PRODUCT",
"I_PRODUCTGROUP",
"I_PRODUCTGROUPTEXT",
"NJIT_CALL_D_CMAT"
],
"ASSOCIATED":
[
"I_JITCALLCOMPGROUPBASIC",
"I_JITCALLDOCREFBASIC",
"I_JITCALLHEADERBASIC",
"I_PRODUCT",
"I_PRODUCTPLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/