C_JITCallCompGrpConfmProdn

DDL: C_JITCALLCOMPGRPCONFMPRODN Type: view_entity CONSUMPTION Package: NJIT_APP_CONFIRM_PRODUCTION
49 Fields 1 Data Sources 6 Associations

Production Confirmation Consumption View

C_JITCallCompGrpConfmProdn is a Consumption CDS View that provides data about "Production Confirmation Consumption View" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompGrpConfmProdn) and exposes 49 fields with key field JITCallCompGrpUUID. It has 6 associations to related views. Part of development package NJIT_APP_CONFIRM_PRODUCTION.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompGrpConfmProdn I_JITCallCompGrpConfmProdn from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..*] I_JITPckgGrpItemRef _JITPckgGrpItemRef $projection.JITCallCompGrpUUID = _JITPckgGrpItemRef.ReferenceDocumentUUID
[0..1] I_Customer _Customer $projection.shiptoparty = _Customer.Customer
[0..1] E_JITCompGroup _JITCompGroupExtension $projection.InternalJITCallNumber = _JITCompGroupExtension.InternalJITCallNumber and $projection.CompGrpNumber = _JITCompGroupExtension.CompGrpNumber
[0..1] C_JITExtCallNumberVH _JITExternalCallNumberVH $projection.externaljitcallnumber = _JITExternalCallNumberVH.ExternalJITCallNumber and $projection.InternalJITCallNumber = _JITExternalCallNumberVH.InternalJITCallNumber
[1..1] I_Product _ProductCompGrp $projection.CompGrpMatl = _ProductCompGrp.Product

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Production Confirmation Consumption View view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
Search.searchable true view
UI.headerInfo.typeName Production Confirmation view
UI.headerInfo.typeNamePlural Component Group Material view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value Material view
VDM.viewType #CONSUMPTION view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY JITCallCompGrpUUID JITCallCompGrpUUID NodeID
InternalJITCallNumber InternalJITCallNumber Internal JIT Call Number
CompGrpNumber CompGrpNumber Component Group
JITHeaderUUID JITHeaderUUID NodeID
Material CompGrpMatl Comp. Group Matl.
CompGrpMatl CompGrpMatl Comp. Group Matl.
ProductName Component Group Material Description
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
MaterialAvailabilityDateTime
ProductionStartDate ProductionStartDate Start of Production
RequirementDateTime RequirementDateTime Time Stamp
ExternalJITCallNumber _JITCallHeaderBasic ExternalJITCallNumber Ext. JIT Call Number
JITCallType _JITCallHeaderBasic JITCallType Call Type
JITCallTypeText
JITExtSequenceNumber JITExtSequenceNumber Ext.Seq. Number
JITPckgGrpID
numc6endasJITPckgGrpCellNumber
ProductionVersion ProductionVersion Version ID
ProductionVersionText _ProductionVersion ProductionVersionText
JITAltvHndlgUnitID
JITAltvHndlgUnitIDShrt
Customer _JITCallHeaderBasic ShipToParty Ship-To Party (obsolete)
ShipToParty _JITCallHeaderBasic ShipToParty Ship-To Party (obsolete)
BusinessPartnerName
ProductionLine _ProductionVersion ProductionLine Production Line
UnloadingPointName UnloadingPointName Unloading Point Name
CustSupplyArea CustSupplyArea Cust. Supply Area
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
JITInternalStatusText
JITExtStatusAtSupplier JITExtStatusAtSupplier External Status
JITExternalStatusText
ProductionEndDate ProductionEndDate Production End Date
SupplyControlUUID SupplyControlUUID NodeID
ShippingPoint ShippingPoint Shipping Point
StorageLocation StorageLocation StorageLocation
JITLifecycleStatusText
MatlUsageIndicatorText
JITProdnConfirmationControl _JITSupplyControlHeader JITProdnConfirmationControl Prodn Conf Ctrl
_JITExternalCallNumberVH _JITExternalCallNumberVH
_JITCallCompMaterialBasic _JITCallCompMaterialBasic
_JITCallHeaderBasic _JITCallHeaderBasic
_JITInternalStatus _JITInternalStatus
_JITSupplyControlHeader _JITSupplyControlHeader
_Plant _Plant
_ProductCompGrp _ProductCompGrp
_ShippingPoint _ShippingPoint
_StorageLocation _StorageLocation
_SupplierExtStatus _SupplierExtStatus

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_JITCallCompGrpConfmProdn.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_JITCallCompGrpConfmProdn AS
SELECT
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITHeaderUUID,
  CompGrpMatl AS Material,
  CompGrpMatl,
  _ProductCompGrp._Text[1: Language=$session.system_language].ProductName AS ProductName,
  Plant,
  _Plant.PlantName AS PlantName,
  cast( dats_tims_to_tstmp(MaterialAvailabilityDate, MaterialAvailabilityTime, 'UTC', $session.client, 'NULL') as tzntstmps preserving type ) AS MaterialAvailabilityDateTime,
  ProductionStartDate,
  RequirementDateTime,
  _JITCallHeaderBasic.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITCallHeaderBasic.JITCallType AS JITCallType,
  _JITCallHeaderBasic._JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  JITExtSequenceNumber,
  _JITPckgGrpItemRef._JITPckgGrpHeader.JITPckgGrpID AS JITPckgGrpID,
  case _JITCallHeaderBasic.JITCallType when '1' then _JITPckgGrpItemRef._JITPckgGrpItem.JITPckgGrpCellNumber when '0' then cast('' as abap.numc( 6 )) else cast('' as abap.numc( 6 )) end as JITPckgGrpCellNumber AS numc6endasJITPckgGrpCellNumber,
  ProductionVersion,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _JITPckgGrpItemRef._JITPckgGrpHeader.JITAltvHndlgUnitID AS JITAltvHndlgUnitID,
  _JITPckgGrpItemRef._JITPckgGrpHeader.JITAltvHndlgUnitIDShrt AS JITAltvHndlgUnitIDShrt,
  _JITCallHeaderBasic.ShipToParty AS Customer,
  _JITCallHeaderBasic.ShipToParty AS ShipToParty,
  _JITCallHeaderBasic._Customer.CustomerName AS BusinessPartnerName,
  _ProductionVersion.ProductionLine AS ProductionLine,
  UnloadingPointName,
  CustSupplyArea,
  JITIntProcessingStatus,
  _JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  JITExtStatusAtSupplier,
  _SupplierExtStatus._JITExternalStatusText[1: Language=$session.system_language].JITExternalStatusText AS JITExternalStatusText,
  ProductionEndDate,
  SupplyControlUUID,
  ShippingPoint,
  StorageLocation,
  _JITCallHeaderBasic._JITLifecycleStatus._Text[1:Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  _JITCallHeaderBasic._MatlUsageIndicator._Text[1:Language = $session.system_language].MatlUsageIndicatorText AS MatlUsageIndicatorText,
  _JITSupplyControlHeader.JITProdnConfirmationControl AS JITProdnConfirmationControl
FROM I_JITCallCompGrpConfmProdn
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_JITPckgGrpItemRef AS _JITPckgGrpItemRef ON JITCallCompGrpUUID = _JITPckgGrpItemRef.ReferenceDocumentUUID  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON shiptoparty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN E_JITCompGroup AS _JITCompGroupExtension ON InternalJITCallNumber = _JITCompGroupExtension.InternalJITCallNumber AND CompGrpNumber = _JITCompGroupExtension.CompGrpNumber  -- association [0..1]
LEFT OUTER JOIN C_JITExtCallNumberVH AS _JITExternalCallNumberVH ON externaljitcallnumber = _JITExternalCallNumberVH.ExternalJITCallNumber AND InternalJITCallNumber = _JITExternalCallNumberVH.InternalJITCallNumber  -- association [0..1]
LEFT OUTER JOIN I_Product AS _ProductCompGrp ON CompGrpMatl = _ProductCompGrp.Product  -- association [1..1]
;

Learn More