C_JITCallCompGroupObjPg

DDL: C_JITCALLCOMPGROUPOBJPG Type: view_entity CONSUMPTION

Monitor Customer JIT Calls Component Grp

C_JITCallCompGroupObjPg is a Consumption CDS View that provides data about "Monitor Customer JIT Calls Component Grp" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompGroupCube) and exposes 85 fields with key field JITCallCompGrpUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompGroupCube I_JITCallCompGroupCube from

Associations (4)

CardinalityTargetAliasCondition
[0..*] C_JITInbCallCompGrpRefText _JITCallReferenceText $projection.JITCallCompGrpUUID = _JITCallReferenceText.ParentDraftKey
[0..*] C_JITCallDocRefObjPg _JITCallDocRefObjPg $projection.InternalJITCallNumber = _JITCallDocRefObjPg.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallDocRefObjPg.CompGrpNumber
[0..*] C_JITCallCompMatlBasicObjPg _JITCallCompMatlBasicObjPg $projection.JITCallCompGrpUUID = _JITCallCompMatlBasicObjPg.JITCallCompGrpUUID
[0..*] C_JITCallHndlgUnitForObjPg _JITCallHndlgUnitForObjPg $projection.JITCallCompGrpUUID = _JITCallHndlgUnitForObjPg.JITCallCompGrpUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Monitor Customer JIT Calls Component Grp view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
Search.searchable true view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (85)

KeyFieldSource TableSource FieldDescription
KEY JITCallCompGrpUUID JITCallCompGrpUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
CompGrpNumber CompGrpNumber Component Group No.
JITDelivSqncGrpUUID JITDelivSqncGrpUUID NodeID
SupplyControlUUID SupplyControlUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
ExtCompGrpNumber ExtCompGrpNumber Extl Comp. Group No.
Material CompGrpMatl Comp. Group Matl.
CompGrpMatl CompGrpMatl Comp. Group Matl.
ProductName
CustCompGrpMatl CustCompGrpMatl
JITExtSequenceNumber JITExtSequenceNumber Ext.Seq. Number
JITExtStatusAtSupplier JITExtStatusAtSupplier External Status
JITExternalStatusText
JITIntProcessingStatusPartial JITIntProcessingStatus Transmitted Status
JITInternalStatusText
Plant Plant Valuation Area
CustSupplyArea CustSupplyArea Cust. Supply Area
SupplyAreaDesc
UnloadingPointName UnloadingPointName Unloading Point Name
SupplyControlID SupplyControlID Supply Control ID
SupplyControlDesc
JITActionCtrl JITActionCtrl Action Control
CustAssemblyLoc CustAssemblyLoc Assembly Location
ShippingPoint ShippingPoint Shipping Point
StorageLocation StorageLocation StorageLocation
StorageLocationName _StorageLocation StorageLocationName Storage Loc. Name
WarehouseNumber WarehouseNumber
DeliveryStatus DeliveryStatus Delivery Status
JITCompGrpDocDelivStsTxt
PickingStatus PickingStatus Status Value
GoodsMovementStatus GoodsMovementStatus Gds Movemt Status
JITCompGrpDocGdsMvtStsTxt
JITCompGrpDocPckgGrpSts JITCompGrpDocPckgGrpSts
JITCompGrpDocPckgGrpStsTxt
JITCompGrpDocConfToProdnSts JITCompGrpDocConfToProdnSts
JITCompGrpDocConfToProdnStsTxt
JITCompGrpDocRelToProdnSts JITCompGrpDocRelToProdnSts
JITCompGrpDocRelToProdnStsTxt
DeliveryCreationDate DeliveryCreationDate Delivery Date
ProductionStartDate ProductionStartDate Start of Production
PlannedShippingDateTime PlannedShippingDateTime Pl. Shippg Date Time
RequirementDateTime RequirementDateTime Time Stamp
MaterialAvailabilityDate MaterialAvailabilityDate
NumberOfItems NumberOfItems
ExternalJITCallNumber _JITInboundCall ExternalJITCallNumber Ext. JIT Call Number
ShipToParty _JITInboundCall ShipToParty Ship-To Party (obsolete)
SalesOrganization _JITInboundCall SalesOrganization Sales Organization
SoldToParty _JITInboundCall SoldToParty Sold-to Party
ActiveSupplier _JITInboundCall ActiveSupplier Vendor no.
CustomerPartnerDescription _JITInboundCall CustomerPartnerDescription Partner desc.
DistributionChannel _JITInboundCall DistributionChannel RefDistCh-Cust/Mat.
Division _JITInboundCall Division Internal Division ID
JITLifecycleStatus _JITInboundCall JITLifecycleStatus Life Cycle Status
JITCallType _JITInboundCall JITCallType Call Type
ActualShippingDateTime ActualShippingDateTime
ProductionVersion ProductionVersion Version ID
ProductionVersionText _ProductionVersion ProductionVersionText
MaterialGroup
MaterialGroupName
TransmittedExtStatusByMfr TransmittedExtStatusByMfr Transmitted Status
JITIntStatusUpdtdOn JITIntStatusUpdtdOn Int Status Updtd On
ProductionLine _ProductionVersion ProductionLine Production Line
JITProdnConfirmationControl _JITSupplyControlHeader JITProdnConfirmationControl Prodn Conf Ctrl
ReceivingStorageLocation _ProductionVersion ReceivingStorageLocation RecStorLoc
IssuingStorageLocation _ProductionVersion IssuingStorageLocation Iss. Stor. Loc.
JITUnderDeliveryToleranceInPct _JITSupplyControlHeader JITUnderDeliveryToleranceInPct Undrdelvry Tolerance
JITOverDeliveryToleranceInPct _JITSupplyControlHeader JITOverDeliveryToleranceInPct Ovrdelivry Tolerance
PartialDeliveryIsAllowed _JITSupplyControlHeader PartialDeliveryIsAllowed Partial Deliv.
JITUnlimitedOverDelivIsAllowed _JITSupplyControlHeader JITUnlimitedOverDelivIsAllowed Unlmt Ov Del
JITDeliverySplitCriteriaDesc
JITPckgGrpDefID
JITPckgGrpDesc
_JITInbCallComponent _JITInbCallComponent
_JITSupplyControlHeader _JITSupplyControlHeader
_Plant _Plant
_JITCallReferenceText _JITCallReferenceText
_JITCallDocRefObjPg _JITCallDocRefObjPg
_JITCallCompMatlBasicObjPg _JITCallCompMatlBasicObjPg
_JITCallHndlgUnitForObjPg _JITCallHndlgUnitForObjPg
_ShippingPoint _ShippingPoint
_ProductionVersion _ProductionVersion
_StorageLocation _StorageLocation
_JITInboundCall _JITInboundCall
_JITDelivSqncGrpHeaderBasic _JITDelivSqncGrpHeaderBasic

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_JITCallCompGroupObjPg.
-- 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_JITCallCompGroupObjPg AS
SELECT
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITDelivSqncGrpUUID,
  SupplyControlUUID,
  JITHeaderUUID,
  ExtCompGrpNumber,
  CompGrpMatl AS Material,
  CompGrpMatl,
  _ProductCompGrp._Text[1: Language=$session.system_language].ProductName AS ProductName,
  CustCompGrpMatl,
  JITExtSequenceNumber,
  JITExtStatusAtSupplier,
  _SupplierExtStatus._JITExternalStatusText[1: Language=$session.system_language].JITExternalStatusText AS JITExternalStatusText,
  JITIntProcessingStatus AS JITIntProcessingStatusPartial,
  _JITInternalStatus._Text[1:Language = $session.system_language].JITInternalStatusText AS JITInternalStatusText,
  Plant,
  CustSupplyArea,
  _JITSupplyControlHeader._JITCustomerSupplyArea._JITCustomerSupplyAreaDesc[1: Language=$session.system_language].SupplyAreaDesc AS SupplyAreaDesc,
  UnloadingPointName,
  SupplyControlID,
  _JITSupplyControlHeader._Description[1:Language=$session.system_language].SupplyControlDesc AS SupplyControlDesc,
  JITActionCtrl,
  CustAssemblyLoc,
  ShippingPoint,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  WarehouseNumber,
  DeliveryStatus,
  _JITDeliveryStatus._Text[1:Language = $session.system_language].DeliveryStatusText AS JITCompGrpDocDelivStsTxt,
  PickingStatus,
  GoodsMovementStatus,
  _JITGoodsMovementStatus._Text[1:Language = $session.system_language].GoodsMovementStatusDesc AS JITCompGrpDocGdsMvtStsTxt,
  JITCompGrpDocPckgGrpSts,
  _JITPackingGrpCreationStatus._Text[1:Language = $session.system_language].JITPackingGroupCreationStsText AS JITCompGrpDocPckgGrpStsTxt,
  JITCompGrpDocConfToProdnSts,
  _JITProdnConfirmationStatus._Text[1:Language = $session.system_language].JITProdnConfirmationStatusText AS JITCompGrpDocConfToProdnStsTxt,
  JITCompGrpDocRelToProdnSts,
  _JITReleaseToProductionStatus._Text[1:Language = $session.system_language].JITReleaseToProductionStsText AS JITCompGrpDocRelToProdnStsTxt,
  DeliveryCreationDate,
  ProductionStartDate,
  PlannedShippingDateTime,
  RequirementDateTime,
  MaterialAvailabilityDate,
  NumberOfItems,
  _JITInboundCall.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITInboundCall.ShipToParty AS ShipToParty,
  _JITInboundCall.SalesOrganization AS SalesOrganization,
  _JITInboundCall.SoldToParty AS SoldToParty,
  _JITInboundCall.ActiveSupplier AS ActiveSupplier,
  _JITInboundCall.CustomerPartnerDescription AS CustomerPartnerDescription,
  _JITInboundCall.DistributionChannel AS DistributionChannel,
  _JITInboundCall.Division AS Division,
  _JITInboundCall.JITLifecycleStatus AS JITLifecycleStatus,
  _JITInboundCall.JITCallType AS JITCallType,
  ActualShippingDateTime,
  ProductionVersion,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _ProductionVersion._Product._ProductGroup.MaterialGroup AS MaterialGroup,
  _ProductionVersion._Product._ProductGroup._Text[1:Language=$session.system_language].MaterialGroupName AS MaterialGroupName,
  TransmittedExtStatusByMfr,
  JITIntStatusUpdtdOn,
  _ProductionVersion.ProductionLine AS ProductionLine,
  _JITSupplyControlHeader.JITProdnConfirmationControl AS JITProdnConfirmationControl,
  _ProductionVersion.ReceivingStorageLocation AS ReceivingStorageLocation,
  _ProductionVersion.IssuingStorageLocation AS IssuingStorageLocation,
  _JITSupplyControlHeader.JITUnderDeliveryToleranceInPct AS JITUnderDeliveryToleranceInPct,
  _JITSupplyControlHeader.JITOverDeliveryToleranceInPct AS JITOverDeliveryToleranceInPct,
  _JITSupplyControlHeader.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  _JITSupplyControlHeader.JITUnlimitedOverDelivIsAllowed AS JITUnlimitedOverDelivIsAllowed,
  _JITInboundCall._JITCustomer._JITDeliverySplitCriteria._JITDeliverySplitCriteriaDesc[1:Language = $session.system_language].JITDeliverySplitCriteriaDesc AS JITDeliverySplitCriteriaDesc,
  _JITPckgGrpItemRef._JITPckgGrpHeader._JITPckgGrpDef.JITPckgGrpDefID AS JITPckgGrpDefID,
  _JITPckgGrpItemRef._JITPckgGrpHeader._JITPckgGrpDef._PackageGroupDefinitionText[1:Language = $session.system_language].JITPckgGrpDesc AS JITPckgGrpDesc
FROM I_JITCallCompGroupCube
LEFT OUTER JOIN C_JITInbCallCompGrpRefText AS _JITCallReferenceText ON JITCallCompGrpUUID = _JITCallReferenceText.ParentDraftKey  -- association [0..*]
LEFT OUTER JOIN C_JITCallDocRefObjPg AS _JITCallDocRefObjPg ON InternalJITCallNumber = _JITCallDocRefObjPg.InternalJITCallNumber AND CompGrpNumber = _JITCallDocRefObjPg.CompGrpNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallCompMatlBasicObjPg AS _JITCallCompMatlBasicObjPg ON JITCallCompGrpUUID = _JITCallCompMatlBasicObjPg.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN C_JITCallHndlgUnitForObjPg AS _JITCallHndlgUnitForObjPg ON JITCallCompGrpUUID = _JITCallHndlgUnitForObjPg.JITCallCompGrpUUID  -- association [0..*]
;