C_JITOutbSqncCallOvwPg

DDL: C_JITOUTBSQNCCALLOVWPG Type: view_entity CONSUMPTION
37 Fields 1 Data Sources 6 Associations 1 OData Services

Overview for Forwarded JIS Calls

C_JITOutbSqncCallOvwPg is a Consumption CDS View that provides data about "Overview for Forwarded JIS Calls" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallComponentGroupDet) and exposes 37 fields with key field JITCallCompGrpUUID. It has 6 associations to related views. It is exposed through 1 OData service (UI_JITOUTBSEQUENCECALLFWD_OVW).

SAP Help Documentation

CategoryCDS Views for Just-In-Time Processing
Data CategoryConsumption
Purpose
This CDS view retrieves the forwarded Just-In-Sequence (JIS) calls based on the filters that you specify. The CDS view provide prerequisites for answering the following questions: Information based on the JIS call by supplier, reordered JIS call, forwarded JIS call, and component materials

Prerequisites
Authorizations The following authorization object is required: JIT_S2P: JIT Supply To Production: Authorizations for JIS calls

Structure
Main CDS Parameters and Filters This CDS view has the below input parameter: Creation Date/Time The main filters are: Plant used to filter by plant, which is a location where materials are produced and consumed JIS Call Status used to filter by lifecycle status of the JIS call Supplier used to filter by supplier, which is an individual or organization that provide products or services Production Supply Area used to filter by production supply area, which is an area on the shop floor where component materials are stored so that they can be directly used for production

Additional Information
There are five analytical cards with one static card. Views for the cards are: C_JITOutbSqncCallOvwBySuplr C_JITOutbSqncCallOvwByLfcycSts C_JITOutbSqncCallOvwReorder C_JITOutbSqncCallOvwByIntSts C_JITOutbSqncCallOvwFwdInfo Technical Details: UI_JITOUTBSEQUENCECALLFWD_OVW: Service definition UI_JITOUTBSQNCCALLFWD_OVW: Service binding

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallComponentGroupDet I_JITOutbCallComponentGroupDet from

Associations (6)

CardinalityTargetAliasCondition
[1..*] C_JITOutbSqncCallOvwBySuplr _JITOutbSqncCallOvwBySuplr $projection.JITHeaderUUID = _JITOutbSqncCallOvwBySuplr.JITHeaderUUID
[1..*] C_JITOutbSqncCallOvwByLfcycSts _JITOutbSqncCallOvwByLfcycSts $projection.JITHeaderUUID = _JITOutbSqncCallOvwByLfcycSts.JITHeaderUUID
[1..*] C_JITOutbSqncCallOvwByIntSts _JITOutbSqncCallOvwByIntSts $projection.JITCallCompGrpUUID = _JITOutbSqncCallOvwByIntSts.JITCallCompGrpUUID
[1..*] C_JITOutbSqncCallOvwReorder _JITOutbSqncCallOvwReorder $projection.JITHeaderUUID = _JITOutbSqncCallOvwReorder.JITHeaderUUID
[1..*] C_JITOutbSqncCallOvwFwdInfo _JITOutbSqncCallOvwFwdInfo $projection.JITHeaderUUID = _JITOutbSqncCallOvwFwdInfo.JITHeaderUUID
[1..1] C_JITOutbSqncCallOvwByCompGrp _JITOutbSqncCallOvwByCompGrp $projection.JITCallCompGrpUUID = _JITOutbSqncCallOvwByCompGrp.JITCallCompGrpUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Overview for Forwarded JIS Calls view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_JITOUTBSEQUENCECALLFWD_OVW UI_JITOUTBSQNCCALLFWD_OVW V2 C1 NOT_RELEASED

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY JITCallCompGrpUUID JITCallCompGrpUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
CompGrpNumber CompGrpNumber Component Group No.
CompGrpMatl CompGrpMatl Comp. Group Matl.
RequirementDateTime RequirementDateTime Time Stamp
JITSupplyDateTime JITSupplyDateTime Supply Date & Time
Plant Plant Valuation Area
JITActionCtrl JITActionCtrl Action Control
StorageLocation StorageLocation StorageLocation
EWMWarehouse EWMWarehouse Warehouse No.
JITSourceWarehouseNumber JITSourceWarehouseNumber Source Warehouse No.
JITControlCycle JITControlCycle Control Cycle
ProductionSupplyArea ProductionSupplyArea Supply Area
JITOutbDestinationStorLoc JITOutbDestinationStorLoc Dest. Storage Loc
ReferenceJITComponentGroupUUID ReferenceJITComponentGroupUUID Ref Comp Grp UUID
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
JITIntStatusUpdtdOnDteTme JITIntStatusUpdtdOnDteTme Int Status Updtd On
ExternalJITCallNumber _JITOutboundCall ExternalJITCallNumber Ext. JIT Call Number
ActiveSupplier _JITOutboundCall ActiveSupplier Vendor no.
CreationDateTime _JITOutboundCall CreationDateTime Timestamp
JITLifecycleStatus _JITOutboundCall JITLifecycleStatus Life Cycle Status
JITScenario _JITOutboundCall JITScenario JIT Scenario
JITLifecycleStatusText
_JITControlCycle _JITControlCycle
_JITInternalStatus _JITInternalStatus
_JITPlant _JITPlant
_ProductCompGrp _ProductCompGrp
_ProductionSupplyArea _ProductionSupplyArea
_StorageLocation _StorageLocation
_JITOutbSqncCallOvwBySuplr _JITOutbSqncCallOvwBySuplr
_JITOutbSqncCallOvwByLfcycSts _JITOutbSqncCallOvwByLfcycSts
_JITOutbSqncCallOvwByIntSts _JITOutbSqncCallOvwByIntSts
_JITOutbSqncCallOvwReorder _JITOutbSqncCallOvwReorder
_JITOutbSqncCallOvwFwdInfo _JITOutbSqncCallOvwFwdInfo
_JITOutbSqncCallOvwByCompGrp _JITOutbSqncCallOvwByCompGrp
_JITOutboundCall _JITOutboundCall

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_JITOutbSqncCallOvwPg.
-- 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_JITOutbSqncCallOvwPg AS
SELECT
  JITCallCompGrpUUID,
  JITHeaderUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  CompGrpMatl,
  RequirementDateTime,
  JITSupplyDateTime,
  Plant,
  JITActionCtrl,
  StorageLocation,
  EWMWarehouse,
  JITSourceWarehouseNumber,
  JITControlCycle,
  ProductionSupplyArea,
  JITOutbDestinationStorLoc,
  ReferenceJITComponentGroupUUID,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOnDteTme,
  _JITOutboundCall.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITOutboundCall.ActiveSupplier AS ActiveSupplier,
  _JITOutboundCall.CreationDateTime AS CreationDateTime,
  _JITOutboundCall.JITLifecycleStatus AS JITLifecycleStatus,
  _JITOutboundCall.JITScenario AS JITScenario,
  _JITOutboundCall._JITLifecycleStatus._Text[1: Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText
FROM I_JITOutbCallComponentGroupDet
LEFT OUTER JOIN C_JITOutbSqncCallOvwBySuplr AS _JITOutbSqncCallOvwBySuplr ON JITHeaderUUID = _JITOutbSqncCallOvwBySuplr.JITHeaderUUID  -- association [1..*]
LEFT OUTER JOIN C_JITOutbSqncCallOvwByLfcycSts AS _JITOutbSqncCallOvwByLfcycSts ON JITHeaderUUID = _JITOutbSqncCallOvwByLfcycSts.JITHeaderUUID  -- association [1..*]
LEFT OUTER JOIN C_JITOutbSqncCallOvwByIntSts AS _JITOutbSqncCallOvwByIntSts ON JITCallCompGrpUUID = _JITOutbSqncCallOvwByIntSts.JITCallCompGrpUUID  -- association [1..*]
LEFT OUTER JOIN C_JITOutbSqncCallOvwReorder AS _JITOutbSqncCallOvwReorder ON JITHeaderUUID = _JITOutbSqncCallOvwReorder.JITHeaderUUID  -- association [1..*]
LEFT OUTER JOIN C_JITOutbSqncCallOvwFwdInfo AS _JITOutbSqncCallOvwFwdInfo ON JITHeaderUUID = _JITOutbSqncCallOvwFwdInfo.JITHeaderUUID  -- association [1..*]
LEFT OUTER JOIN C_JITOutbSqncCallOvwByCompGrp AS _JITOutbSqncCallOvwByCompGrp ON JITCallCompGrpUUID = _JITOutbSqncCallOvwByCompGrp.JITCallCompGrpUUID  -- association [1..1]
;

Learn More