C_JITOutbCallQuery

DDL: C_JITOUTBCALLQUERY SQL: CJITCALLQ Type: view CONSUMPTION
41 Fields 1 Data Sources

Other Filters

C_JITOutbCallQuery is a Consumption CDS View that provides data about "Other Filters" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallCube) and exposes 41 fields with key fields InternalJITCallNumber, CompGrpNumber, JITCallItemNumber.

SAP Help Documentation

CategoryCDS Views for Just-In-Time Processing
StatusReleased
Corresponding DataSource2CCJITCALLQ
Purpose
This CDS view enables you to monitor JIT calls at a component material level. This CDS view provides the prerequisites for answering the following business questions: View the business attributes of JIT calls based on component material level in tabular format The graphical representation of various attributes of JIT calls based on component material level in patterns like the bar chart, column chart, and pie chart The viewing of logs or errors in the system

Prerequisites
The following authorization object is required: JIT_S2P_CC: JIT Supply to Production: Authorization for Control Cycles

Structure
Main CDS dimensions This CDS view does not have any input parameters. The main filters are: JITLifecycleStatus used to filter based on JIT call status RequirementDateTime used to filter based on requirement date and time Plant used to filter based on plant Responsible used to filter based on the person responsible for a plant StorageLocation used to filter based on storage location JITIntProcessingStatus used to filter based on internal processing status of a JIT call ProductionSupplyArea used to filter based on production supply area. JITControlCycle used to filter based on control cycle Material used to filter based on component material JITOutbStockTransferSts used to filter based on the stock transfer status Measures The measures are: TotalNumberOfJITCalls : Indicates the number of JIT calls. NumberOfDistinctProducts : Indicates the number of component materials.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallCube I_JITOutbCallCube from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CJITCALLQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Other Filters view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.query true view
VDM.viewType #CONSUMPTION view
OData.publish true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.allowExtensions true view
Search.searchable true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group No.
KEY JITCallItemNumber JITCallItemNumber Call Item Number
JITLifecycleStatus JITLifecycleStatus Life Cycle Status
JITLifecycleStatusText JITLifecycleStatusText
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
RequirementDateTime RequirementDateTime Time Stamp
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
JITInternalStatusText JITInternalStatusText
JITCallType JITCallType Call Type
ProductionSupplyArea ProductionSupplyArea Supply Area
JITControlCycle JITControlCycle Control Cycle
Responsible Responsible User Name
Material Material Vehicle Model
JITOutbDestinationStorLoc JITOutbDestinationStorLoc Dest. Storage Loc
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
JITOutbPickedQuantity JITOutbPickedQuantity Picked Quantity
QuantityUnit QuantityUnit Unit of measure
JITOutbTransferredQuantity JITOutbTransferredQuantity Transferred Qty
StorageBin StorageBin Storage Bin
DestinationStorageBin DestinationStorageBin
PlannedOrder PlannedOrder
ProductName ProductName Description
JITExternalReplenishment JITExternalReplenishment
Supplier Supplier Supplier
TotalNumberOfJITCalls TotalNumberOfJITCalls
NumberOfDistinctProducts NumberOfDistinctProducts
JITOutbDeviationInQty JITOutbDeviationInQty
UnitOfMeasureNumberOfDecimals UnitOfMeasureNumberOfDecimals
_JITOutbPlantVH _JITOutbPlantVH
_JITOutbInternalStatusVH _JITOutbInternalStatusVH
_JITOutbMaterialVH _JITOutbMaterialVH
_JITLifecycleStatus _JITLifecycleStatus
_JITLifecycleStatusValueHelp _JITLifecycleStatusValueHelp
_JITControlCycleVH _JITControlCycleVH
_JITCallTypeValueHelp _JITCallTypeValueHelp
_JITOutbStorageBinVH _JITOutbStorageBinVH
_JITInternalStatus _JITInternalStatus
_ProductCompMatl _ProductCompMatl

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_JITOutbCallQuery.
-- 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: CJITCALLQ

CREATE VIEW C_JITOutbCallQuery AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITLifecycleStatus,
  JITLifecycleStatusText,
  Plant,
  StorageLocation,
  RequirementDateTime,
  JITIntProcessingStatus,
  JITInternalStatusText,
  JITCallType,
  ProductionSupplyArea,
  JITControlCycle,
  Responsible,
  Material,
  JITOutbDestinationStorLoc,
  RequestedQuantity,
  ActualDeliveredQuantity,
  JITOutbPickedQuantity,
  QuantityUnit,
  JITOutbTransferredQuantity,
  StorageBin,
  DestinationStorageBin,
  PlannedOrder,
  ProductName,
  JITExternalReplenishment,
  Supplier,
  TotalNumberOfJITCalls,
  NumberOfDistinctProducts,
  JITOutbDeviationInQty,
  UnitOfMeasureNumberOfDecimals
FROM I_JITOutbCallCube
;

Learn More