C_JITOutbSqncCallCompGrpTP

DDL: C_JITOUTBSQNCCALLCOMPGRPTP SQL: CJITOUTBSEQCGTP Type: view CONSUMPTION

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 95 fields with key field InternalJITCallNumber. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallsCompGrpDataTP _JITOutbCallCompGrp from

Associations (7)

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..*] C_JITOutbControlCycSchedgAgrmt _JITOutbControlCycSchedgAgrmt $projection.JITControlCycle = _JITOutbControlCycSchedgAgrmt.JITControlCycle
[0..1] C_JITInternalStatusVH _JITInternalStatusVH $projection.JITIntProcessingStatus = _JITInternalStatusVH.JITIntProcessingStatus
[0..*] C_JITOutbSqncCallCompGrpDocRef _JITOutbSqncCallCompGrpDocRef $projection.JITCallCompGrpUUID = _JITOutbSqncCallCompGrpDocRef.JITCallCompGrpUUID
[0..*] C_JITOutbSqncCompGrpEDIMsgRef _JITOutbSqncCompGrpEDIMsgRef $projection.InternalJITCallNumber = _JITOutbSqncCompGrpEDIMsgRef.InternalJITCallNumber

Annotations (23)

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.title.value InternalJITCallNumber view
UI.headerInfo.title.label Internal Call Number view
UI.headerInfo.description.label JIS Call Number view

Fields (95)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
ParentDraftKey ParentDraftKey NodeID
JITCallCompGrpUUID JITCallCompGrpUUID 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 _ProductionSupplyArea ProductionSupplyAreaRespPerson
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
UnloadingPointName UnloadingPointName Unloading Point Name
GoodsReceivingPoint GoodsReceivingPoint Goods Rcvg Point
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 _Plant PlantName Plant Name
JITOutbStockTransferSts JITOutbStockTransferSts Stock Transfer Status
JITStockTransferStsText
StorageLocationName _StorageLocation StorageLocationName Storage Loc. Name
ProductionSupplyAreaName
MRPControllerName
EWMWarehouse EWMWarehouse Warehouse No.
WarehouseName WarehouseName
ReplnmtPlanningProcedure ReplnmtPlanningProcedure
JITPlanningProcedureText
StorageType _JITOutbStorageBin StorageType Storage Type
StorageTypeName _JITOutbStorageBin StorageTypeName Destination 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.
JITInternalReplenishment JITInternalReplenishment
AutomotiveLoadingPoint _ProductionSupplyArea AutomotiveLoadingPoint
JITOutbToleranceFlag JITOutbToleranceFlag JIS Tolerance Threshold
Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
BusinessPartner BusinessPartner Issuing Authority
BusinessPartner1 BusinessPartner1 Partner
BusinessPartner2 BusinessPartner2 Partner
JITProductionOrderNumber JITProductionOrderNumber Vehicle Production Order Number
JITDeliveryDateTime JITDeliveryDateTime Delivery Date Time
JustInTimeInboundDelivery
_JITOutbCallsCompMatlDataTP _JITOutbCallsCompMatlDataTP
_JITOutbCallsRefTextTP _JITOutbCallsRefTextTP
_JITStockTransferSts _JITStockTransferSts
_JITInternalStatusVH _JITInternalStatusVH
_JITInternalStatus _JITInternalStatus
_Plant _Plant
_StorageLocation _StorageLocation
_JITOutbCallHeader _JITOutbCallHeader
_ProductionSupplyArea _ProductionSupplyArea
_JITOutbMissingPartFlag _JITOutbMissingPartFlag
_JITOutbControlCycSchedgAgrmt _JITOutbControlCycSchedgAgrmt
_JITOutbSqncCallCompGrpDocRef _JITOutbSqncCallCompGrpDocRef
_JITOutbSqncCompGrpEDIMsgRef _JITOutbSqncCompGrpEDIMsgRef

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,
  JITCallCompGrpUUID,
  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,
  _ProductionSupplyArea.ProductionSupplyAreaRespPerson AS Responsible,
  JITActionCtrl,
  CreatedByUser,
  _JITOutbCallHeader._CreatedByUser.FullName AS CreatedByUserDescription,
  StorageLocation,
  JITCallHasAlert,
  JITCallProcessingLogID,
  ProductionSupplyArea,
  JITOutbDestinationStorLoc,
  UnloadingPointName,
  GoodsReceivingPoint,
  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,
  _Plant.PlantName AS PlantName,
  JITOutbStockTransferSts,
  _JITStockTransferSts._Text[1: Language = $session.system_language].JITStockTransferStsText AS JITStockTransferStsText,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  _ProductionSupplyArea._Text[1: Language = $session.system_language].ProductionSupplyAreaName AS ProductionSupplyAreaName,
  _ProductionSupplyArea._ResponsiblePerson.MRPControllerName AS MRPControllerName,
  EWMWarehouse,
  WarehouseName,
  ReplnmtPlanningProcedure,
  _JITPlngProcedure._Text[1: Language = $session.system_language].JITPlanningProcedureText AS JITPlanningProcedureText,
  _JITOutbStorageBin.StorageType AS StorageType,
  _JITOutbStorageBin.StorageTypeName AS StorageTypeName,
  StorageBin,
  JITExternalReplenishment,
  DeliveryStatus,
  SourceStorageBin,
  SourceStorageType,
  JITSourceWarehouseNumber,
  JITInternalReplenishment,
  _ProductionSupplyArea.AutomotiveLoadingPoint AS AutomotiveLoadingPoint,
  JITOutbToleranceFlag,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  BusinessPartner,
  BusinessPartner1,
  BusinessPartner2,
  JITProductionOrderNumber,
  JITDeliveryDateTime,
  cast(_JITInboundDelivery.BusinessTransactionDocument as vbeln_vl) AS JustInTimeInboundDelivery
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 C_JITOutbControlCycSchedgAgrmt AS _JITOutbControlCycSchedgAgrmt ON JITControlCycle = _JITOutbControlCycSchedgAgrmt.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN C_JITInternalStatusVH AS _JITInternalStatusVH ON JITIntProcessingStatus = _JITInternalStatusVH.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSqncCallCompGrpDocRef AS _JITOutbSqncCallCompGrpDocRef ON JITCallCompGrpUUID = _JITOutbSqncCallCompGrpDocRef.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN C_JITOutbSqncCompGrpEDIMsgRef AS _JITOutbSqncCompGrpEDIMsgRef ON InternalJITCallNumber = _JITOutbSqncCompGrpEDIMsgRef.InternalJITCallNumber  -- association [0..*]
;