C_JITOutbSqncCallCompGrpTP
Consumption view for JIS Call Comp Group
C_JITOutbSqncCallCompGrpTP is a Consumption CDS View that provides data about "Consumption view for JIS Call Comp Group" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallsCompGrpDataTP) and exposes 87 fields with key field InternalJITCallNumber. It has 9 associations to related views. Part of development package NJIT_MODEL_O.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_JITOutbCallsCompGrpDataTP | _JITOutbCallCompGrp | from |
Associations (9)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | C_JITOutbSqncCallCompMatlTP | _JITOutbCallsCompMatlDataTP | $projection.InternalJITCallNumber = _JITOutbCallsCompMatlDataTP.InternalJITCallNumber |
| [0..*] | C_JITOutbSqncCallsRefTextTP | _JITOutbCallsRefTextTP | $projection.InternalJITCallNumber = _JITOutbCallsRefTextTP.InternalJITCallNumber |
| [0..1] | C_JITLifecycleStatusValueHelp | _JITLifecycleStatusValueHelp | $projection.JITLifecycleStatus = _JITLifecycleStatusValueHelp.JITLifecycleStatus |
| [0..1] | I_JITInternalStatus | _JITInternalStatus | $projection.JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus |
| [0..1] | I_JITStockTransferSts | _JITStockTransferSts | $projection.JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts |
| [0..1] | I_ProductionSupplyArea | _ProductionSupplyArea | $projection.Plant = _ProductionSupplyArea.Plant and $projection.ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea |
| [0..1] | I_JITOutbStorageBin | _JITOutbStorageBin | $projection.StorageBin = _JITOutbStorageBin.StorageBin and $projection.WarehouseNumber = _JITOutbStorageBin.WarehouseNumber |
| [0..*] | C_JITOutbControlCycSchedgAgrmt | _JITOutbControlCycSchedgAgrmt | $projection.JITControlCycle = _JITOutbControlCycSchedgAgrmt.JITControlCycle |
| [0..1] | C_JITInternalStatusVH | _JITInternalStatusVH | $projection.JITIntProcessingStatus = _JITInternalStatusVH.JITIntProcessingStatus |
Annotations (24)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CJITOUTBSEQCGTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.updateEnabled | EXTERNAL_CALCULATION | view | |
| ObjectModel.draftEnabled | true | view | |
| ObjectModel.deleteEnabled | EXTERNAL_CALCULATION | view | |
| ObjectModel.compositionRoot | true | view | |
| ObjectModel.transactionalProcessingDelegated | true | view | |
| Metadata.allowExtensions | true | view | |
| Search.searchable | true | view | |
| EndUserText.label | Consumption view for JIS Call Comp Group | view | |
| UI.headerInfo.typeName | Just-In-Time Call | view | |
| UI.headerInfo.typeNamePlural | Just-In-Time Calls | view | |
| UI.headerInfo.title.value | InternalJITCallNumber | view | |
| UI.headerInfo.title.label | Internal Call Number | view | |
| UI.headerInfo.description.label | JIS Call Number | view |
Fields (87)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InternalJITCallNumber | InternalJITCallNumber | JIT Call Number | |
| ParentDraftKey | ParentDraftKey | NodeID | ||
| JITLifecycleStatus | JITLifecycleStatus | Life Cycle Status | ||
| JITLifecycleStatusText | _JITLifecycleStatusValueHelp | JITLifecycleStatusText | ||
| JITLifeCycleStatusCriticality | JITLifeCycleStatusCriticality | |||
| JITCallType | JITCallType | Call Type | ||
| JITCallTypeText | Call Type | |||
| VehicleIdentificationNumber | VehicleIdentificationNumber | Vehicle Identification Number | ||
| JITPlannedOrderNumber | JITPlannedOrderNumber | Vehicle Planned Order Number | ||
| JITVehicleSeqDateTime | JITVehicleSeqDateTime | Vehicle Sequence Date | ||
| JITIntSequenceNumber | JITIntSequenceNumber | Vehicle Sequence Number | ||
| VehicleModel | VehicleModel | Vehicle Model | ||
| JITCallImmediateRequest | JITCallImmediateRequest | Immediate Request | ||
| JITCallPriorityID | JITCallPriorityID | Delivery Prior. | ||
| JITCallPriorityType | JITCallPriorityType | Priority Type | ||
| JITCallPriorityTypeText | Priority Type | |||
| JITMissingPartFlag | JITMissingPartFlag | Missing Part | ||
| JITMaterialStockMissingText | ||||
| CreationDateTime | CreationDateTime | Timestamp | ||
| LastChangeDateTime | LastChangeDateTime | Timestamp | ||
| LastChangedByUser | LastChangedByUser | User Name | ||
| LastChangedByUserDescription | ||||
| JITExtSequenceNumber | JITExtSequenceNumber | External Sequence Number | ||
| JITCallCreationMode | _JITOutbCallHeader | JITCallCreationMode | JIT- Creation Mode | |
| JITCallCreationModeText | ||||
| Plant | Plant | Valuation Area | ||
| JITIntProcessingStatus | JITIntProcessingStatus | Internal Processing Status | ||
| JITIntStatusUpdtdOn | JITIntStatusUpdtdOn | Int Status Updtd On | ||
| Material | Material | Component Material | ||
| RequirementDateTime | RequirementDateTime | Demand Date/Time | ||
| JITSupplyDateTime | JITSupplyDateTime | Supply Date & Time | ||
| WarehouseNumber | WarehouseNumber | |||
| JITControlCycle | JITControlCycle | Control Cycle | ||
| Responsible | Responsible | User Name | ||
| JITActionCtrl | JITActionCtrl | Action Control | ||
| CreatedByUser | CreatedByUser | User Name | ||
| CreatedByUserDescription | ||||
| StorageLocation | StorageLocation | Storage Location | ||
| JITCallHasAlert | JITCallHasAlert | Has Alerts | ||
| JITCallProcessingLogID | JITCallProcessingLogID | |||
| ProductionSupplyArea | ProductionSupplyArea | Supply Area | ||
| JITOutbDestinationStorLoc | JITOutbDestinationStorLoc | Dest. Storage Loc | ||
| RequestedDeliveryDateTime | RequestedDeliveryDateTime | |||
| DeliveryCreationDate | DeliveryCreationDate | Delivery Date | ||
| JITMissingPrtCriticality | JITMissingPrtCriticality | |||
| CompGrpNumber | CompGrpNumber | Component Group No. | ||
| CompGrpNumberForEdit | CompGrpNumberForEdit | Component Group No. | ||
| CompGrpMatl | CompGrpMatl | Component Group Material | ||
| ProductName | ||||
| JITInternalStatusText | ||||
| PlantName | PlantName | Plant Name | ||
| JITOutbStockTransferSts | JITOutbStockTransferSts | Stock Transfer Status | ||
| JITStockTransferStsText | ||||
| StorageLocationName | _StorageLocation | StorageLocationName | Storage Loc. Name | |
| ProductionSupplyAreaName | ProductionSupplyAreaName | Production Supply Area Name | ||
| MRPControllerName | ||||
| EWMWarehouse | EWMWarehouse | Warehouse No. | ||
| WarehouseName | WarehouseName | |||
| ReplnmtPlanningProcedure | ReplnmtPlanningProcedure | |||
| JITPlanningProcedureText | JITPlanningProcedureText | |||
| StorageType | _JITOutbStorageBin | StorageType | Storage Type | |
| StorageTypeName | _JITOutbStorageBin | StorageTypeName | Source Storage Type Name | |
| StorageBin | StorageBin | Storage Bin | ||
| JITExternalReplenishment | JITExternalReplenishment | |||
| DeliveryStatus | DeliveryStatus | Delivery Status | ||
| SourceStorageBin | SourceStorageBin | |||
| SourceStorageType | SourceStorageType | Source Storage Type | ||
| JITSourceWarehouseNumber | JITSourceWarehouseNumber | Source Warehouse No. | ||
| _JITOutbCallsCompMatlDataTP | _JITOutbCallsCompMatlDataTP | |||
| _JITOutbCallsRefTextTP | _JITOutbCallsRefTextTP | |||
| _JITStockTransferSts | _JITStockTransferSts | |||
| _JITInternalStatusVH | _JITInternalStatusVH | |||
| _JITInternalStatus | _JITInternalStatus | |||
| _Plant | _Plant | |||
| _StorageLocation | _StorageLocation | |||
| _JITOutbCallHeader | _JITOutbCallHeader | |||
| _ProductionSupplyArea | _ProductionSupplyArea | |||
| JITInternalReplenishment | JITInternalReplenishment | |||
| AutomotiveLoadingPoint | AutomotiveLoadingPoint | |||
| JITOutbToleranceFlag | JITOutbToleranceFlag | JIS Tolerance Threshold | ||
| Supplier | Supplier | Supplier | ||
| SupplierName | SupplierName | Supplier Name | ||
| BusinessPartner | BusinessPartner | Issuing Authority | ||
| BusinessPartner1 | BusinessPartner1 | Partner | ||
| BusinessPartner2 | BusinessPartner2 | Partner | ||
| _JITOutbMissingPartFlag | _JITOutbMissingPartFlag | |||
| _JITOutbControlCycSchedgAgrmt | _JITOutbControlCycSchedgAgrmt |
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_JITOutbSqncCallCompGrpTP.
-- 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.
-- SQL view name: CJITOUTBSEQCGTP
CREATE VIEW C_JITOutbSqncCallCompGrpTP AS
SELECT
InternalJITCallNumber,
ParentDraftKey,
JITLifecycleStatus,
_JITLifecycleStatusValueHelp.JITLifecycleStatusText AS JITLifecycleStatusText,
JITLifeCycleStatusCriticality,
JITCallType,
_JITOutbCallHeader._JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
VehicleIdentificationNumber,
JITPlannedOrderNumber,
JITVehicleSeqDateTime,
JITIntSequenceNumber,
VehicleModel,
JITCallImmediateRequest,
JITCallPriorityID,
JITCallPriorityType,
_JITOutbCallHeader._DeliveryPriority._Text[1:Language = $session.system_language].DeliveryPriorityDesc AS JITCallPriorityTypeText,
JITMissingPartFlag,
_JITOutbMissingPartFlag._Text[1: Language = $session.system_language].JITMaterialStockMissingText AS JITMaterialStockMissingText,
CreationDateTime,
LastChangeDateTime,
LastChangedByUser,
_JITOutbCallHeader._LastChangedByUser.FullName AS LastChangedByUserDescription,
JITExtSequenceNumber,
_JITOutbCallHeader.JITCallCreationMode AS JITCallCreationMode,
_JITOutbCallHeader._JITCallCreationMode._Text[1:Language = $session.system_language].JITCallCreationModeText AS JITCallCreationModeText,
Plant,
JITIntProcessingStatus,
JITIntStatusUpdtdOn,
Material,
RequirementDateTime,
JITSupplyDateTime,
WarehouseNumber,
JITControlCycle,
Responsible,
JITActionCtrl,
CreatedByUser,
_JITOutbCallHeader._CreatedByUser.FullName AS CreatedByUserDescription,
StorageLocation,
JITCallHasAlert,
JITCallProcessingLogID,
ProductionSupplyArea,
JITOutbDestinationStorLoc,
RequestedDeliveryDateTime,
DeliveryCreationDate,
JITMissingPrtCriticality,
CompGrpNumber,
CompGrpNumberForEdit,
CompGrpMatl,
_ProductCompGrp._Text[1: Language=$session.system_language].ProductName AS ProductName,
_JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
PlantName,
JITOutbStockTransferSts,
_JITStockTransferSts._Text[1: Language = $session.system_language].JITStockTransferStsText AS JITStockTransferStsText,
_StorageLocation.StorageLocationName AS StorageLocationName,
ProductionSupplyAreaName,
_ProductionSupplyArea._ResponsiblePerson.MRPControllerName AS MRPControllerName,
EWMWarehouse,
WarehouseName,
ReplnmtPlanningProcedure,
JITPlanningProcedureText,
_JITOutbStorageBin.StorageType AS StorageType,
_JITOutbStorageBin.StorageTypeName AS StorageTypeName,
StorageBin,
JITExternalReplenishment,
DeliveryStatus,
SourceStorageBin,
SourceStorageType,
JITSourceWarehouseNumber,
JITInternalReplenishment,
AutomotiveLoadingPoint,
JITOutbToleranceFlag,
Supplier,
SupplierName,
BusinessPartner,
BusinessPartner1,
BusinessPartner2
FROM I_JITOutbCallsCompGrpDataTP AS _JITOutbCallCompGrp
LEFT OUTER JOIN C_JITOutbSqncCallCompMatlTP AS _JITOutbCallsCompMatlDataTP ON InternalJITCallNumber = _JITOutbCallsCompMatlDataTP.InternalJITCallNumber -- association [0..*]
LEFT OUTER JOIN C_JITOutbSqncCallsRefTextTP AS _JITOutbCallsRefTextTP ON InternalJITCallNumber = _JITOutbCallsRefTextTP.InternalJITCallNumber -- association [0..*]
LEFT OUTER JOIN C_JITLifecycleStatusValueHelp AS _JITLifecycleStatusValueHelp ON JITLifecycleStatus = _JITLifecycleStatusValueHelp.JITLifecycleStatus -- association [0..1]
LEFT OUTER JOIN I_JITInternalStatus AS _JITInternalStatus ON JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus -- association [0..1]
LEFT OUTER JOIN I_JITStockTransferSts AS _JITStockTransferSts ON JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _ProductionSupplyArea ON Plant = _ProductionSupplyArea.Plant AND ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea -- association [0..1]
LEFT OUTER JOIN I_JITOutbStorageBin AS _JITOutbStorageBin ON StorageBin = _JITOutbStorageBin.StorageBin AND WarehouseNumber = _JITOutbStorageBin.WarehouseNumber -- association [0..1]
LEFT OUTER JOIN C_JITOutbControlCycSchedgAgrmt AS _JITOutbControlCycSchedgAgrmt ON JITControlCycle = _JITOutbControlCycSchedgAgrmt.JITControlCycle -- association [0..*]
LEFT OUTER JOIN C_JITInternalStatusVH AS _JITInternalStatusVH ON JITIntProcessingStatus = _JITInternalStatusVH.JITIntProcessingStatus -- 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