C_JITCallCompGrpDataTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_JITCallCompGrpDataTP | _JITCallCompGrpDataTP | from |
Associations (13)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA