C_JITOutbSqncCallOvwByLfcycSts

DDL: C_JITOUTBSQNCCALLOVWBYLFCYCSTS Type: view_entity CONSUMPTION

JIS Call Overview by Lifecycle Status

C_JITOutbSqncCallOvwByLfcycSts is a Consumption CDS View that provides data about "JIS Call Overview by Lifecycle Status" in SAP S/4HANA. It reads from 1 data source (I_JITOutbSqncCallOvwReorder) and exposes 33 fields with key field JITCallCompGrpUUID. It is exposed through 1 OData service (UI_JITOUTBSEQUENCECALLFWD_OVW).

Data Sources (1)

SourceAliasJoin Type
I_JITOutbSqncCallOvwReorder I_JITOutbSqncCallOvwReorder from

Parameters (3)

NameTypeDefault
P_CheckStatus check_status
P_StartDate vdm_v_key_date
P_EndDate vdm_v_key_date

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label JIS Call Overview by Lifecycle Status view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
UI_JITOUTBSEQUENCECALLFWD_OVW UI_JITOUTBSQNCCALLFWD_OVW V2 C1 NOT_RELEASED

Fields (33)

KeyFieldSource TableSource FieldDescription
lookupEntityF_JITOutbSeqCallCalendarDate
resultElementStartDate
resultElementFirstDayOfWeekDate
KEY JITCallCompGrpUUID JITCallCompGrpUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
ExternalJITCallNumber ExternalJITCallNumber Ext. JIT Call Number
JITLifecycleStatus JITLifecycleStatus Life Cycle Status
JITLifecycleStatusText
JITCallType JITCallType Call Type
VehicleIdentificationNumber VehicleIdentificationNumber VIN
JITVehicleModel JITVehicleModel Vehicle Model
ActiveSupplier ActiveSupplier Vendor no.
JITCallImmediateRequest JITCallImmediateRequest Immediate Request
JITMissingPartFlag JITMissingPartFlag Missing Part
JITCallPriorityType JITCallPriorityType Priority Type
JITCallPriorityID JITCallPriorityID Delivery Prior.
JITIntSequenceNumber JITIntSequenceNumber Internal Sequence No
JITExtSequenceNumber JITExtSequenceNumber Ext.Seq. Number
JITCallCreationMode JITCallCreationMode JIT- Creation Mode
JITPlannedOrderNumber JITPlannedOrderNumber JIT Planned Order
CreationDateTime CreationDateTime Timestamp
RequirementDateTime RequirementDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
JITScenario JITScenario JIT Scenario
NumberOfItems Number of JIS Calls
JITCallIsForwarded JITCallIsForwarded Forwarded JIS Call
Plant Plant Valuation Area
ProductionSupplyArea ProductionSupplyArea Supply Area
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
CompGrpMatl CompGrpMatl Comp. Group Matl.
_JITLifecycleStatus _JITLifecycleStatus

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_JITOutbSqncCallOvwByLfcycSts.
-- 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.
-- Parameters: P_CheckStatus : check_status, P_StartDate : vdm_v_key_date, P_EndDate : vdm_v_key_date

CREATE VIEW C_JITOutbSqncCallOvwByLfcycSts AS
SELECT
  lookupEntity : 'F_JITOutbSeqCallCalendarDate' AS lookupEntityF_JITOutbSeqCallCalendarDate,
  resultElement : 'StartDate' AS resultElementStartDate,
  resultElement : 'FirstDayOfWeekDate' AS resultElementFirstDayOfWeekDate,
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  ExternalJITCallNumber,
  JITLifecycleStatus,
  _JITLifecycleStatus._Text[1:Language=$session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  JITCallType,
  VehicleIdentificationNumber,
  JITVehicleModel,
  ActiveSupplier,
  JITCallImmediateRequest,
  JITMissingPartFlag,
  JITCallPriorityType,
  JITCallPriorityID,
  JITIntSequenceNumber,
  JITExtSequenceNumber,
  JITCallCreationMode,
  JITPlannedOrderNumber,
  CreationDateTime,
  RequirementDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  JITScenario,
  cast(1 as abap.int4) AS NumberOfItems,
  JITCallIsForwarded,
  Plant,
  ProductionSupplyArea,
  JITIntProcessingStatus,
  CompGrpMatl
FROM I_JITOutbSqncCallOvwReorder
;