C_JITOutbCallsCompGrpDataTP

DDL: C_JITOUTBCALLSCOMPGRPDATATP SQL: CJITOUTBCGHTP Type: view CONSUMPTION Package: NJIT_MODEL_O
76 Fields 1 Data Sources 7 Associations

Consumption view for Component group

C_JITOutbCallsCompGrpDataTP is a Consumption CDS View that provides data about "Consumption view for Component group" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallsCompGrpDataTP) and exposes 76 fields with key field InternalJITCallNumber. It has 7 associations to related views. Part of development package NJIT_MODEL_O.

SAP Help Documentation

CategoryCDS Views for Just-In-Time Processing
Data CategoryConsumption
StatusReleased
Purpose
This CDS view retrives the Just In Time (JIT) calls based on the filters that you specify. This CDS view provides the prerequisites for answering the following business questions: The source storage location and destination storage location in the system The planned details in the system How many type of JIT calls are there in the system? How many JIT calls with missing parts are there in the system? The creation mode of JIT calls in the system

Prerequisites
The following authorization objects are required: JIT_S2P: JIT Supply To Production : Authorizations for the JIT Calls JIT_S2P_CC: JIT Supply to Production: Authorization for Control Cycles

Structure
Object types This view relates to the following object type: I_JITOutbCallsCompGrpDataTP Main CDS parameters and filters This CDS view does not have any input parameters. The main filters are: RequirementDateTime used to filter by requirement details Plant used to filter by plant JITIntProcessingStatus used to filter by internal processing status VehicleModel used to filter by vehicle model ActiveSupplier used to filter by supplier InternalJITCallNumber used to filter by JIT call number JITCallType used to filter by JIT call type JITLifecycleStatus used to filter by lifecycle status JITControlCycle used to filter by control cycle Responsible used to filter by person responsible Material used to filter by material

Reference Text
C_JITOutbCallsRefTextTP - Component Group Material level

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallsCompGrpDataTP _JITOutbCallsCompGrpDataTP from

Associations (7)

CardinalityTargetAliasCondition
[1..*] C_JITOutbCallsCompMatlDataTP _JITOutbCallsCompMatlDataTP $projection.InternalJITCallNumber = _JITOutbCallsCompMatlDataTP.InternalJITCallNumber
[0..*] C_JITOutbCallsRefTextTP _JITOutbCallsRefTextTP $projection.InternalJITCallNumber = _JITOutbCallsRefTextTP.InternalJITCallNumber
[0..1] I_JITStockTransferSts _JITStockTransferSts $projection.JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts
[0..1] C_JITLifecycleStatusValueHelp _JITLifecycleStatusValueHelp $projection.JITLifecycleStatus = _JITLifecycleStatusValueHelp.JITLifecycleStatus
[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 (25)

NameValueLevelField
AbapCatalog.sqlViewName CJITOUTBCGHTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.dataMaintenance #RESTRICTED 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 Component 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 JIT Call Number view

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
CompGrpNumber CompGrpNumber Component Group No.
CompGrpNumberForEdit CompGrpNumberForEdit Component Group No.
CompGrpMatl CompGrpMatl Component Group Material
Material Material Component Material
JITLifecycleStatus JITLifecycleStatus Life Cycle Status
JITLifecycleStatusText _JITLifecycleStatusValueHelp JITLifecycleStatusText
JITLifeCycleStatusCriticality JITLifeCycleStatusCriticality
JITCallType JITCallType Call Type
JITCallTypeText JIT Call Type
JITCallImmediateRequest JITCallImmediateRequest Immediate Request
JITCallPriorityID JITCallPriorityID Delivery Prior.
JITCallPriorityType JITCallPriorityType Priority Type
JITCallPriorityTypeText Priority Type
JITMissingPartFlag JITMissingPartFlag Missing Part
JITMaterialStockMissingText
JITMissingPrtCriticality JITMissingPrtCriticality
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription
JITCallCreationMode _JITOutbCallHeader JITCallCreationMode JIT- Creation Mode
JITCallCreationModeText
Plant Plant Valuation Area
WarehouseNumber WarehouseNumber
JITSourceWarehouseNumber JITSourceWarehouseNumber Source Warehouse No.
JITIntProcessingStatus JITIntProcessingStatus Internal Processing Status
JITIntStatusUpdtdOn JITIntStatusUpdtdOn Int Status Updtd On
ReplenishmentStrategy ReplenishmentStrategy
JITReplenishmentLeadTimeValue JITReplenishmentLeadTimeValue
JITActionCtrl JITActionCtrl Action Control
RequirementDateTime RequirementDateTime Demand Date and Time
JITSupplyDateTime JITSupplyDateTime Supply Date & Time
JITControlCycle JITControlCycle Control Cycle
Responsible Responsible User Name
CreatedByUser CreatedByUser User Name
CreatedByUserDescription
StorageLocation StorageLocation StorageLocation
JITCallHasAlert JITCallHasAlert Has Alerts
JITCallProcessingLogID JITCallProcessingLogID
ProductionSupplyArea ProductionSupplyArea Supply Area
JITOutbDestinationStorLoc JITOutbDestinationStorLoc Dest. Storage Loc
ProductName
JITInternalStatusText
PlantName PlantName Plant Name
SupplierName SupplierName Supplier Name
JITOutbStockTransferSts JITOutbStockTransferSts Stock Trnsfr Status
JITStockTransferStsText
StorageLocationName _StorageLocation StorageLocationName Storage Loc. Name
ProductionSupplyAreaName ProductionSupplyAreaName Production Supply Area Name
EWMWarehouse EWMWarehouse Warehouse No.
WarehouseName WarehouseName
StorageType _JITOutbStorageBin StorageType Storage Type
StorageTypeName _JITOutbStorageBin StorageTypeName
StorageBin StorageBin Storage Bin
ReplnmtPlanningProcedure ReplnmtPlanningProcedure
JITPlanningProcedureText JITPlanningProcedureText
JITExternalReplenishment JITExternalReplenishment
RequestedDeliveryDateTime RequestedDeliveryDateTime
DeliveryCreationDate DeliveryCreationDate Delivery Date
JITInternalReplenishment JITInternalReplenishment
AutomotiveLoadingPoint AutomotiveLoadingPoint
Supplier Supplier Supplier
JITOutbToleranceFlag JITOutbToleranceFlag JIT Tolerance Threshold
BusinessPartner BusinessPartner Issuing Authority
BusinessPartner1 BusinessPartner1 Partner
BusinessPartner2 BusinessPartner2 Partner
_StorageLocation _StorageLocation
_ProductionSupplyArea _ProductionSupplyArea
_JITOutbCallsCompMatlDataTP _JITOutbCallsCompMatlDataTP
_JITOutbCallsRefTextTP _JITOutbCallsRefTextTP
_JITLifecycleStatusValueHelp _JITLifecycleStatusValueHelp
_JITOutbControlCycSchedgAgrmt _JITOutbControlCycSchedgAgrmt
_JITOutbMissingPartFlag _JITOutbMissingPartFlag
_JITInternalStatusVH _JITInternalStatusVH
_Plant _Plant

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_JITOutbCallsCompGrpDataTP.
-- 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: CJITOUTBCGHTP

CREATE VIEW C_JITOutbCallsCompGrpDataTP AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  CompGrpNumberForEdit,
  CompGrpMatl,
  Material,
  JITLifecycleStatus,
  _JITLifecycleStatusValueHelp.JITLifecycleStatusText AS JITLifecycleStatusText,
  JITLifeCycleStatusCriticality,
  JITCallType,
  _JITOutbCallHeader._JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  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,
  JITMissingPrtCriticality,
  CreationDateTime,
  LastChangeDateTime,
  LastChangedByUser,
  _JITOutbCallHeader._LastChangedByUser.FullName AS LastChangedByUserDescription,
  _JITOutbCallHeader.JITCallCreationMode AS JITCallCreationMode,
  _JITOutbCallHeader._JITCallCreationMode._Text[1:Language = $session.system_language].JITCallCreationModeText AS JITCallCreationModeText,
  Plant,
  WarehouseNumber,
  JITSourceWarehouseNumber,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOn,
  ReplenishmentStrategy,
  JITReplenishmentLeadTimeValue,
  JITActionCtrl,
  RequirementDateTime,
  JITSupplyDateTime,
  JITControlCycle,
  Responsible,
  CreatedByUser,
  _JITOutbCallHeader._CreatedByUser.FullName AS CreatedByUserDescription,
  StorageLocation,
  JITCallHasAlert,
  JITCallProcessingLogID,
  ProductionSupplyArea,
  JITOutbDestinationStorLoc,
  _ProductCompGrp._Text[1: Language=$session.system_language].ProductName AS ProductName,
  _JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  PlantName,
  SupplierName,
  JITOutbStockTransferSts,
  _JITStockTransferSts._Text[1: Language = $session.system_language].JITStockTransferStsText AS JITStockTransferStsText,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  ProductionSupplyAreaName,
  EWMWarehouse,
  WarehouseName,
  _JITOutbStorageBin.StorageType AS StorageType,
  _JITOutbStorageBin.StorageTypeName AS StorageTypeName,
  StorageBin,
  ReplnmtPlanningProcedure,
  JITPlanningProcedureText,
  JITExternalReplenishment,
  RequestedDeliveryDateTime,
  DeliveryCreationDate,
  JITInternalReplenishment,
  AutomotiveLoadingPoint,
  Supplier,
  JITOutbToleranceFlag,
  BusinessPartner,
  BusinessPartner1,
  BusinessPartner2
FROM I_JITOutbCallsCompGrpDataTP AS _JITOutbCallsCompGrpDataTP
LEFT OUTER JOIN C_JITOutbCallsCompMatlDataTP AS _JITOutbCallsCompMatlDataTP ON InternalJITCallNumber = _JITOutbCallsCompMatlDataTP.InternalJITCallNumber  -- association [1..*]
LEFT OUTER JOIN C_JITOutbCallsRefTextTP AS _JITOutbCallsRefTextTP ON InternalJITCallNumber = _JITOutbCallsRefTextTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_JITStockTransferSts AS _JITStockTransferSts ON JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts  -- association [0..1]
LEFT OUTER JOIN C_JITLifecycleStatusValueHelp AS _JITLifecycleStatusValueHelp ON JITLifecycleStatus = _JITLifecycleStatusValueHelp.JITLifecycleStatus  -- 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