C_JITOutbSqncCallCompGrpTP

DDL: C_JITOUTBSQNCCALLCOMPGRPTP SQL: CJITOUTBSEQCGTP Type: view CONSUMPTION Package: NJIT_MODEL_O

Consumption view for JIS Call Comp Group

C_JITOutbSqncCallCompGrpTP is a Consumption CDS View that provides data about "Consumption view for JIS Call Comp Group" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallsCompGrpDataTP) and exposes 87 fields with key field InternalJITCallNumber. It has 9 associations to related views. Part of development package NJIT_MODEL_O.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallsCompGrpDataTP _JITOutbCallCompGrp from

Associations (9)

CardinalityTargetAliasCondition
[0..*] C_JITOutbSqncCallCompMatlTP _JITOutbCallsCompMatlDataTP $projection.InternalJITCallNumber = _JITOutbCallsCompMatlDataTP.InternalJITCallNumber
[0..*] C_JITOutbSqncCallsRefTextTP _JITOutbCallsRefTextTP $projection.InternalJITCallNumber = _JITOutbCallsRefTextTP.InternalJITCallNumber
[0..1] C_JITLifecycleStatusValueHelp _JITLifecycleStatusValueHelp $projection.JITLifecycleStatus = _JITLifecycleStatusValueHelp.JITLifecycleStatus
[0..1] I_JITInternalStatus _JITInternalStatus $projection.JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus
[0..1] I_JITStockTransferSts _JITStockTransferSts $projection.JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts
[0..1] I_ProductionSupplyArea _ProductionSupplyArea $projection.Plant = _ProductionSupplyArea.Plant and $projection.ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea
[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 (24)

NameValueLevelField
AbapCatalog.sqlViewName CJITOUTBSEQCGTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true 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 JIS Call Comp 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 JIS Call Number view

Fields (87)

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

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_JITOutbSqncCallCompGrpTP.
-- 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: CJITOUTBSEQCGTP

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