C_JITOutbCallQuery

DDL: C_JITOUTBCALLQUERY SQL: CJITCALLQ Type: view CONSUMPTION Package: NJIT_MODEL_O
40 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 40 fields with key fields InternalJITCallNumber, CompGrpNumber, JITCallItemNumber. Part of development package NJIT_MODEL_O.

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
AbapCatalog.preserveKey true view
Metadata.allowExtensions true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group Number
KEY JITCallItemNumber JITCallItemNumber JIT Call Item Number
JITLifecycleStatus JITLifecycleStatus JIT Call Status
JITLifecycleStatusText JITLifecycleStatusText JIT Call Status Description
Plant Plant Plant
StorageLocation StorageLocation Source Storage Location
RequirementDateTime RequirementDateTime Requirement Date/Time
JITInternalStatusText JITInternalStatusText Internal Processing Status Description
JITIntProcessingStatus JITIntProcessingStatus Internal Processing Status
JITCallType JITCallType JIT Call Type
ProductionSupplyArea ProductionSupplyArea Production Supply Area
JITControlCycle JITControlCycle Control Cycle
Responsible Responsible Person Responsible
Material Material Component Material
JITStockTransferStsText JITStockTransferStsText Stock Transfer Status Description
JITOutbStockTransferSts JITOutbStockTransferSts Stock Transfer Status
JITOutbDestinationStorLoc JITOutbDestinationStorLoc Destination Storage Location
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity ASN Quantity
JITOutbPickedQuantity JITOutbPickedQuantity Picked Quantity
QuantityUnit QuantityUnit Unit of measure
JITOutbTransferredQuantity JITOutbTransferredQuantity Transferred Quantity
JITOutbMinimumQuantity JITOutbMinimumQuantity Minimum Quantity
StorageBin StorageBin Destination Storage Bin
PlannedOrder PlannedOrder Vehicle Planned Order
ProductName ProductName Component Material Name
JITExternalReplenishment JITExternalReplenishment External Replenishment
Supplier Supplier Supplier
TotalNumberOfJITCalls TotalNumberOfJITCalls Number of JIT Calls
NumberOfDistinctProducts NumberOfDistinctProducts Number of Component Materials
JITOutbDeviationInQty JITOutbDeviationInQty Deviation Quantity
UnitOfMeasureNumberOfDecimals UnitOfMeasureNumberOfDecimals
_JITLifecycleStatus _JITLifecycleStatus
_JITInternalStatusVH _JITInternalStatusVH
_JITControlCycleVH _JITControlCycleVH
_JITOutbPlantVH _JITOutbPlantVH
_JITOutbSupplyAreaVH _JITOutbSupplyAreaVH
_JITOutbStorageBinVH _JITOutbStorageBinVH
_JITOutbMaterialVH _JITOutbMaterialVH

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,
  JITInternalStatusText,
  JITIntProcessingStatus,
  JITCallType,
  ProductionSupplyArea,
  JITControlCycle,
  Responsible,
  Material,
  JITStockTransferStsText,
  JITOutbStockTransferSts,
  JITOutbDestinationStorLoc,
  RequestedQuantity,
  ActualDeliveredQuantity,
  JITOutbPickedQuantity,
  QuantityUnit,
  JITOutbTransferredQuantity,
  JITOutbMinimumQuantity,
  StorageBin,
  PlannedOrder,
  ProductName,
  JITExternalReplenishment,
  Supplier,
  TotalNumberOfJITCalls,
  NumberOfDistinctProducts,
  JITOutbDeviationInQty,
  UnitOfMeasureNumberOfDecimals
FROM I_JITOutbCallCube
;

Learn More