C_JITCallCompGrpDataTP

DDL: C_JITCALLCOMPGRPDATATP Type: view_entity CONSUMPTION Package: NJIT_APP_MANAGE_JIT_CALLS

JIT Call Comp Group Data Using Draft

C_JITCallCompGrpDataTP is a Consumption CDS View that provides data about "JIT Call Comp Group Data Using Draft" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompGrpDataTP) and exposes 99 fields with key fields InternalJITCallNumber, CompGrpNumber. It has 13 associations to related views. Part of development package NJIT_APP_MANAGE_JIT_CALLS.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompGrpDataTP _JITCallCompGrpDataTP from

Associations (13)

CardinalityTargetAliasCondition
[1..1] C_JITCallHeaderDataTP _JITCallHeaderDataTP $projection.InternalJITCallNumber = _JITCallHeaderDataTP.InternalJITCallNumber
[0..*] C_JITCallCompMatlDataTP _JITCallCompMatlDataTP $projection.InternalJITCallNumber = _JITCallCompMatlDataTP.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallCompMatlDataTP.CompGrpNumber
[0..*] C_JITCallRefTextCompGrpTP _JITCallRefTextCompGrpTP $projection.InternalJITCallNumber = _JITCallRefTextCompGrpTP.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallRefTextCompGrpTP.CompGrpNumber
[0..*] C_JITCallActionLog _JITCallActionLog $projection.JITCallCompGrpUUID = _JITCallActionLog.JITCallCompGrpUUID
[0..1] I_JITCustomerSupplyArea _JITCustSupplyArea $projection.ShipToParty = _JITCustSupplyArea.ShipToParty and $projection.CustSupplyArea = _JITCustSupplyArea.CustSupplyArea and $projection.UnloadingPointName = _JITCustSupplyArea.UnloadingPointName
[0..1] I_JITCallHeaderBasic _JITCallHeaderBasic $projection.InternalJITCallNumber = _JITCallHeaderBasic.InternalJITCallNumber
[0..*] I_JITCallDocRef _JITCallDocRef $projection.InternalJITCallNumber = _JITCallDocRef.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallDocRef.CompGrpNumber and _JITCallDocRef.BusinessTransactionDocStatus = '1'
[0..*] C_JITCallHndlgUnitDocRef _JITCallHndlgUnitDocRef $projection.JITCallCompGrpUUID = _JITCallHndlgUnitDocRef.JITCallCompGrpUUID
[0..*] C_JITCallDocRefObjPg _JITCallDocRefObj $projection.InternalJITCallNumber = _JITCallDocRefObj.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallDocRefObj.CompGrpNumber
[0..1] C_JITDelivSqncGrpDescTP _JITDelivSqncGrpDescTP $projection.JITDelivSqncGrpUUID = _JITDelivSqncGrpDescTP.JITDelivSqncGrpUUID and _JITDelivSqncGrpDescTP.Language = $session.system_language
[0..*] I_JITCompGrpPackgInstrn _JITCompGrpPackgInstrn $projection.JITCallCompGrpUUID = _JITCompGrpPackgInstrn.ReferenceDocumentUUID
[0..*] C_JITCallHndlgUnitForObjPg _JITCallHndlgUnitForObjPg $projection.JITCallCompGrpUUID = _JITCallHndlgUnitForObjPg.JITCallCompGrpUUID
[0..1] I_JITDeliverySplitCriteria _JITDeliverySplitCriteria $projection.JITDeliveryHdrSplitCriterion = _JITDeliverySplitCriteria.JITDeliverySplitCriteria

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT Call Comp Group Data Using Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.createEnabled true view
ObjectModel.transactionalProcessingDelegated true view
UI.headerInfo.typeName Component Group view
UI.headerInfo.typeNamePlural Component Groups view
UI.headerInfo.title.value ShipToParty view
UI.headerInfo.title.label ShipToParty view
UI.headerInfo.description.value CompGrpNumberForEdit view
UI.headerInfo.imageUrl ProductImageURL view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (99)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber Call Number
KEY CompGrpNumber CompGrpNumber Component Group No.
JITCallCompGrpUUID JITCallCompGrpUUID NodeID
CompGrpNumberForEdit CompGrpNumberForEdit Component Group
ShipToParty ShipToParty Ship-To Party
ExternalJITCallNumber ExternalJITCallNumber Ext. JIT Call Number
ProductImageURL
JITCallTypeText
JITExtSequenceNumber JITExtSequenceNumber Ext.Seq. Number
JITExtStatusAtSupplier JITExtStatusAtSupplier External Status
RequirementDateTime RequirementDateTime Requirement Date/Time
JITIntProcessingStatus JITIntProcessingStatus Internal Processing Status
JITInternalStatusText Internal Processing Status
PlannedShippingDateTime PlannedShippingDateTime Planned Goods issue Date/Time
ExtCompGrpNumber ExtCompGrpNumber External Component Group Number
CustSupplyArea CustSupplyArea Customer Supply Area
SupplyAreaDesc
Plant Plant Plant
PlantName PlantName Plant Name
JITExternalStatusText External Status
Material CompGrpMatl Component Group Material
CompGrpMatl CompGrpMatl Comp. Group Matl.
CustAssemblyLoc CustAssemblyLoc Assembly Location
ShippingPoint ShippingPoint Shipping Point
JITExtStatusUpdtdOn JITExtStatusUpdtdOn Ext. Status Updtd
JITIntStatusUpdtdOn JITIntStatusUpdtdOn Int Status Updtd On
MaterialGroup Material Group
MaterialGroupName
UnloadingPointName UnloadingPointName Unloading Point
StorageLocation StorageLocation Storage Location
StorageLocationName
TransmittedExtStatusByMfr TransmittedExtStatusByMfr Transmitted Status
WarehouseNumber WarehouseNumber EWM warehouse number
ProductName
CustCompGrpMatl CustCompGrpMatl Customer Component Group Material
SupplyControlID SupplyControlID Supply Control
SupplyControlUUID SupplyControlUUID NodeID
SupplyControlDesc
JITActionCtrl JITActionCtrl Action Control
JITDelivSqncGrpID JITDelivSqncGrpID Delivery Sequence Group
JITDelivSqncGrpDesc _JITDelivSqncGrpDescTP JITDelivSqncGrpDesc DSG Description
ShippingPointName ShippingPointName
ActualShippingDateTime ActualShippingDateTime Actual Goods issue Date/Time
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
RequestedDeliveryTime RequestedDeliveryTime
RequestedDeliveryDateTime RequestedDeliveryDateTime
DeliveryCreationDate DeliveryCreationDate Delivery Date
MaterialAvailabilityDateTime MaterialAvailabilityDateTime Material Availability Date/Time
ProductionStartDate ProductionStartDate Production Start Date/Time
ProductionEndDate ProductionEndDate Production End Date
DeliveryStatus DeliveryStatus Delivery Status
JITCompGrpDocDelivStsTxt
JITCompGrpDocRelToProdnSts JITCompGrpDocRelToProdnSts Transfer To Production Status
JITCompGrpDocRelToProdnStsTxt
JITCompGrpDocPckgGrpSts JITCompGrpDocPckgGrpSts Packing Status
JITCompGrpDocPckgGrpStsTxt
JITCompGrpDocConfToProdnSts JITCompGrpDocConfToProdnSts Production Confirmation Status
JITCompGrpDocConfToProdnStsTxt
GoodsMovementStatus GoodsMovementStatus Goods Issue Status
JITCompGrpDocGdsMvtStsTxt
RepetitiveManufacturingIsAllwd Repetitive Manufacturing
JITRepetitiveMfgAllwdText
ProductionVersion ProductionVersion Production Version
ProductionVersionText Production Version Description
JITProdnConfControlText Production Confirmation Control
ProductionLine Production line
WorkCenterText
ReceivingStorageLocation Receiving Storage Location
ReceivingStorageLocationName
IssuingStorageLocation Issuing Storage Location
IssuingStorageLocationName
JITPckgGrpDefID Packing Specification
JITPckgGrpDesc
JITUnderDeliveryToleranceInPct Underdelivery Tolerance (%)
PartialDeliveryIsAllowed Partial Delivery allowed
PartialDeliveryIsAllowedText
JITOverDeliveryToleranceInPct Overdelivery Tolerance (%)
JITDeliveryHdrSplitCriterion JITDeliveryHdrSplitCriterion Delivery Split by
JITDeliverySplitCriteriaDesc
JITUnlimitedOverDelivIsAllowed Unlimited Under-Over Delivery
JITDelivSqncGrpUUID JITDelivSqncGrpUUID NodeID
_JITCallCompMatlDataTP _JITCallCompMatlDataTP
_JITCallRefTextCompGrpTP _JITCallRefTextCompGrpTP
_JITCallDocRefObj _JITCallDocRefObj
_JITCallHeaderDataTP _JITCallHeaderDataTP
_ProductCompGrp _ProductCompGrp
_Plant _Plant
_ShippingPoint _ShippingPoint
_StorageLocation _StorageLocation
_JITCustSupplyArea _JITCustSupplyArea
_SupplierExtStatus _SupplierExtStatus
_JITSupplyControlHeader _JITSupplyControlHeader
_JITCallHeaderBasic _JITCallHeaderBasic
_JITCallDocRef _JITCallDocRef
_JITCallHndlgUnitDocRef _JITCallHndlgUnitDocRef
_JITCallActionLog _JITCallActionLog
_JITCompGrpPackgInstrn _JITCompGrpPackgInstrn
_JITCallHndlgUnitForObjPg _JITCallHndlgUnitForObjPg
_ProductionVersion _ProductionVersion

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_JITCallCompGrpDataTP.
-- 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_JITCallCompGrpDataTP AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallCompGrpUUID,
  CompGrpNumberForEdit,
  ShipToParty,
  ExternalJITCallNumber,
  cast( '' as productimageurl ) AS ProductImageURL,
  _JITCallHeaderBasic._JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  JITExtSequenceNumber,
  JITExtStatusAtSupplier,
  RequirementDateTime,
  JITIntProcessingStatus,
  _JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  PlannedShippingDateTime,
  ExtCompGrpNumber,
  CustSupplyArea,
  _JITCustSupplyArea._JITCustomerSupplyAreaDesc[1: Language=$session.system_language].SupplyAreaDesc AS SupplyAreaDesc,
  Plant,
  PlantName,
  _SupplierExtStatus._JITExternalStatusText[1: Language=$session.system_language].JITExternalStatusText AS JITExternalStatusText,
  CompGrpMatl AS Material,
  CompGrpMatl,
  CustAssemblyLoc,
  ShippingPoint,
  JITExtStatusUpdtdOn,
  JITIntStatusUpdtdOn,
  _JITCallCompGrpDataTP._ProductionVersion._Product._ProductGroup.MaterialGroup AS MaterialGroup,
  _ProductionVersion._Product._ProductGroup._Text[1:Language=$session.system_language].MaterialGroupName AS MaterialGroupName,
  UnloadingPointName,
  StorageLocation,
  _JITCallCompGrpDataTP._StorageLocation.StorageLocationName AS StorageLocationName,
  TransmittedExtStatusByMfr,
  WarehouseNumber,
  _ProductCompGrp._Text[1: Language=$session.system_language].ProductName AS ProductName,
  CustCompGrpMatl,
  SupplyControlID,
  SupplyControlUUID,
  _JITSupplyControlHeader._Description[1:Language=$session.system_language].SupplyControlDesc AS SupplyControlDesc,
  JITActionCtrl,
  JITDelivSqncGrpID,
  _JITDelivSqncGrpDescTP.JITDelivSqncGrpDesc AS JITDelivSqncGrpDesc,
  ShippingPointName,
  ActualShippingDateTime,
  RequestedDeliveryDate,
  RequestedDeliveryTime,
  RequestedDeliveryDateTime,
  DeliveryCreationDate,
  MaterialAvailabilityDateTime,
  ProductionStartDate,
  ProductionEndDate,
  DeliveryStatus,
  _JITCompGrpDocStatus._Text[1:Language = $session.system_language].JITCompGrpDocDelivStsTxt AS JITCompGrpDocDelivStsTxt,
  JITCompGrpDocRelToProdnSts,
  _JITCompGrpDocRelToProdnStatus._RelToProdnText[1:Language = $session.system_language].JITCompGrpDocRelToProdnStsTxt AS JITCompGrpDocRelToProdnStsTxt,
  JITCompGrpDocPckgGrpSts,
  _JITCompGrpDocPckgGrpSts._PkgGrpText[1:Language = $session.system_language].JITCompGrpDocPckgGrpStsTxt AS JITCompGrpDocPckgGrpStsTxt,
  JITCompGrpDocConfToProdnSts,
  _JITCompGrpDocConfToProdnSts._ConfToProdnText[1:Language = $session.system_language].JITCompGrpDocConfToProdnStsTxt AS JITCompGrpDocConfToProdnStsTxt,
  GoodsMovementStatus,
  _JITCompGrpDocGdsMvtSts._GdsMvtText[1:Language = $session.system_language].JITCompGrpDocGdsMvtStsTxt AS JITCompGrpDocGdsMvtStsTxt,
  _JITCallCompGrpDataTP._JITSupplyControlHeader.RepetitiveManufacturingIsAllwd AS RepetitiveManufacturingIsAllwd,
  _JITSupplyControlHeader._JITRepetitiveMfg._Text[1:Language = $session.system_language].RepetitiveMfgIsAllwdText AS JITRepetitiveMfgAllwdText,
  ProductionVersion,
  _JITCallCompGrpDataTP._JITSupplyControlHeader._ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _JITSupplyControlHeader._JITProdnConfirmationControl._Text[1: Language=$session.system_language].JITProdnConfControlText AS JITProdnConfControlText,
  _JITCallCompGrpDataTP._JITSupplyControlHeader._ProductionVersion.ProductionLine AS ProductionLine,
  _JITSupplyControlHeader._ProductionVersion._ProductionLine._WorkCenterTextBySemanticKey[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  _JITCallCompGrpDataTP._JITSupplyControlHeader._ProductionVersion.ReceivingStorageLocation AS ReceivingStorageLocation,
  _JITCallCompGrpDataTP._ProductionVersion._ReceivingStorageLocation.StorageLocationName AS ReceivingStorageLocationName,
  _JITCallCompGrpDataTP._JITSupplyControlHeader._ProductionVersion.IssuingStorageLocation AS IssuingStorageLocation,
  _JITCallCompGrpDataTP._ProductionVersion._IssuingStorageLocation.StorageLocationName AS IssuingStorageLocationName,
  _JITCompGrpPackgInstrn._JITPckgGrpHeader._JITPckgGrpDef.JITPckgGrpDefID AS JITPckgGrpDefID,
  _JITCompGrpPackgInstrn._JITPckgGrpDefTxt[1:Language = $session.system_language].JITPckgGrpDesc AS JITPckgGrpDesc,
  _JITCallCompGrpDataTP._JITSupplyControlHeader.JITUnderDeliveryToleranceInPct AS JITUnderDeliveryToleranceInPct,
  _JITCallCompGrpDataTP._JITSupplyControlHeader.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  _JITSupplyControlHeader._JITPartialDelivery._Text [1: Language = $session.system_language ].PartialDeliveryIsAllowedText AS PartialDeliveryIsAllowedText,
  _JITCallCompGrpDataTP._JITSupplyControlHeader.JITOverDeliveryToleranceInPct AS JITOverDeliveryToleranceInPct,
  JITDeliveryHdrSplitCriterion,
  _JITDeliverySplitCriteria._JITDeliverySplitCriteriaDesc[1: Language=$session.system_language].JITDeliverySplitCriteriaDesc AS JITDeliverySplitCriteriaDesc,
  _JITCallCompGrpDataTP._JITSupplyControlHeader.JITUnlimitedOverDelivIsAllowed AS JITUnlimitedOverDelivIsAllowed,
  JITDelivSqncGrpUUID
FROM I_JITCallCompGrpDataTP AS _JITCallCompGrpDataTP
LEFT OUTER JOIN C_JITCallHeaderDataTP AS _JITCallHeaderDataTP ON InternalJITCallNumber = _JITCallHeaderDataTP.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN C_JITCallCompMatlDataTP AS _JITCallCompMatlDataTP ON InternalJITCallNumber = _JITCallCompMatlDataTP.InternalJITCallNumber AND CompGrpNumber = _JITCallCompMatlDataTP.CompGrpNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallRefTextCompGrpTP AS _JITCallRefTextCompGrpTP ON InternalJITCallNumber = _JITCallRefTextCompGrpTP.InternalJITCallNumber AND CompGrpNumber = _JITCallRefTextCompGrpTP.CompGrpNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallActionLog AS _JITCallActionLog ON JITCallCompGrpUUID = _JITCallActionLog.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN I_JITCustomerSupplyArea AS _JITCustSupplyArea ON ShipToParty = _JITCustSupplyArea.ShipToParty AND CustSupplyArea = _JITCustSupplyArea.CustSupplyArea AND UnloadingPointName = _JITCustSupplyArea.UnloadingPointName  -- association [0..1]
LEFT OUTER JOIN I_JITCallHeaderBasic AS _JITCallHeaderBasic ON InternalJITCallNumber = _JITCallHeaderBasic.InternalJITCallNumber  -- association [0..1]
LEFT OUTER JOIN I_JITCallDocRef AS _JITCallDocRef ON InternalJITCallNumber = _JITCallDocRef.InternalJITCallNumber AND CompGrpNumber = _JITCallDocRef.CompGrpNumber AND _JITCallDocRef.BusinessTransactionDocStatus = '1'  -- association [0..*]
LEFT OUTER JOIN C_JITCallHndlgUnitDocRef AS _JITCallHndlgUnitDocRef ON JITCallCompGrpUUID = _JITCallHndlgUnitDocRef.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN C_JITCallDocRefObjPg AS _JITCallDocRefObj ON InternalJITCallNumber = _JITCallDocRefObj.InternalJITCallNumber AND CompGrpNumber = _JITCallDocRefObj.CompGrpNumber  -- association [0..*]
LEFT OUTER JOIN C_JITDelivSqncGrpDescTP AS _JITDelivSqncGrpDescTP ON JITDelivSqncGrpUUID = _JITDelivSqncGrpDescTP.JITDelivSqncGrpUUID AND _JITDelivSqncGrpDescTP.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JITCompGrpPackgInstrn AS _JITCompGrpPackgInstrn ON JITCallCompGrpUUID = _JITCompGrpPackgInstrn.ReferenceDocumentUUID  -- association [0..*]
LEFT OUTER JOIN C_JITCallHndlgUnitForObjPg AS _JITCallHndlgUnitForObjPg ON JITCallCompGrpUUID = _JITCallHndlgUnitForObjPg.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN I_JITDeliverySplitCriteria AS _JITDeliverySplitCriteria ON JITDeliveryHdrSplitCriterion = _JITDeliverySplitCriteria.JITDeliverySplitCriteria  -- association [0..1]
;