I_JITOutbCallHdrTP

DDL: I_JITOUTBCALLHDRTP SQL: IJITOUTBHEADTP Type: view TRANSACTIONAL Package: NJIT_MODEL_O

Transactional view for JIT Call Header

I_JITOutbCallHdrTP is a Transactional CDS View that provides data about "Transactional view for JIT Call Header" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallHdrBasic) and exposes 61 fields with key fields JITHeaderUUID, InternalJITCallNumber. It has 8 associations to related views. Part of development package NJIT_MODEL_O.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallHdrBasic I_JITOutbCallHdrBasic from

Associations (8)

CardinalityTargetAliasCondition
[0..*] I_JITOutbCallCompGrpDataTP _JITOutbCallCompGrpDataTP $projection.JITHeaderUUID = _JITOutbCallCompGrpDataTP.ParentDraftKey and $projection.InternalJITCallNumber = _JITOutbCallCompGrpDataTP.InternalJITCallNumber
[0..*] I_JITOutbCallCompMatlDataTP _JITOutbCallCompMatlDataTP $projection.JITHeaderUUID = _JITOutbCallCompMatlDataTP.RootDraftKey and $projection.InternalJITCallNumber = _JITOutbCallCompMatlDataTP.InternalJITCallNumber
[0..*] I_JITOutbCallRefTextHdrTP _JITOutbCallRefTextHdrTP $projection.JITHeaderUUID = _JITOutbCallRefTextHdrTP.ParentDraftKey and $projection.InternalJITCallNumber = _JITOutbCallRefTextHdrTP.InternalJITCallNumber
[0..1] I_MRPController _ResponsiblePerson $projection.Plant = _ResponsiblePerson.Plant and $projection.Responsible = _ResponsiblePerson.MRPController
[0..1] I_JITOutbCallPriorityType _JITOutbCallPriorityID $projection.JITCallPriorityID = _JITOutbCallPriorityID.JITCallPriorityID
[0..1] I_JITCallCreationMode _JITCallCreationMode $projection.JITCallCreationMode = _JITCallCreationMode.JITCallCreationMode
[0..1] I_DeliveryPriority _DeliveryPriority $projection.JITCallPriorityID = _DeliveryPriority.DeliveryPriority
[0..1] E_JITCall _JITHeaderExtension $projection.InternalJITCallNumber = _JITHeaderExtension.InternalJITCallNumber

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IJITOUTBHEADTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence NJIT_OUTB_HDR_D view
ObjectModel.compositionRoot true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.modelCategory #BUSINESS_OBJECT view
EndUserText.label Transactional view for JIT Call Header view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY JITHeaderUUID JITHeaderUUID NodeID
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
ExternalJITCallNumber ExternalJITCallNumber Ext. JIT Call Number
ExternalJITCallNumberForFilter ExternalJITCallNumber Ext. JIT Call Number
ShipToParty ShipToParty Ship-To Party (obsolete)
SoldToParty SoldToParty Sold-to Party
JITLifecycleStatus JITLifecycleStatus Life Cycle Status
JITCallType JITCallType Call Type
VehicleIdentificationNumber VehicleIdentificationNumber VIN
VehicleModel VehicleModel Vehicle Model
JITPlannedOrderNumber JITPlannedOrderNumber JIT Planned Order
JITVehicleSeqDateTime JITVehicleSeqDateTime
JITIntSequenceNumber JITIntSequenceNumber Internal Sequence No
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
UnloadingPointName UnloadingPointName Unloading Point Name
CustomerPartnerDescription CustomerPartnerDescription Partner desc.
MatlUsageIndicator MatlUsageIndicator
ActiveSupplier ActiveSupplier Vendor no.
JITCallImmediateRequest JITCallImmediateRequest Immediate Request
JITMissingPartFlag JITMissingPartFlag Missing Part
JITCallPriorityType JITCallPriorityType Priority Type
JITCallPriorityID JITCallPriorityID Delivery Prior.
JITCallCreationMode JITCallCreationMode JIT- Creation Mode
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _LastChangedByUser FullName Name
CreatedByUserDescription _CreatedByUser FullName Name
LastChangeDateTime LastChangeDateTime Timestamp
ReplenishmentStrategy ReplenishmentStrategy
Responsible _ProductionSupplyArea ProductionSupplyAreaRespPerson
JITCallProcessingLogID JITCallProcessingLogID
JITExtSequenceNumber JITExtSequenceNumber Ext.Seq. Number
RequirementDateTime RequirementDateTime Time Stamp
JITSupplyDateTime JITSupplyDateTime Supply Date & Time
WarehouseNumber WarehouseNumber
Plant Plant Valuation Area
CompGrpMatl CompGrpMatl Comp. Group Matl.
StorageLocation StorageLocation StorageLocation
JITControlCycle JITControlCycle Control Cycle
ProductionSupplyArea ProductionSupplyArea Supply Area
JITOutbDestinationStorLoc JITOutbDestinationStorLoc Dest. Storage Loc
JITActionCtrl JITActionCtrl Action Control
JITIntStatusUpdtdOn JITIntStatusUpdtdOn Int Status Updtd On
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
Material Material Vehicle Model
_JITOutbCallCompGrpDataTP _JITOutbCallCompGrpDataTP
_JITOutbCallRefTextHdrTP _JITOutbCallRefTextHdrTP
_JITOutbCallCompMatlDataTP _JITOutbCallCompMatlDataTP
_JITCallDate _JITCallDate
_ProductionSupplyArea _ProductionSupplyArea
_JITCallType _JITCallType
_JITLifecycleStatus _JITLifecycleStatus
_ResponsiblePerson _ResponsiblePerson
_JITOutbCallPriorityID _JITOutbCallPriorityID
_DeliveryPriority _DeliveryPriority
_JITCallCreationMode _JITCallCreationMode
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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 I_JITOutbCallHdrTP.
-- 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: IJITOUTBHEADTP

CREATE VIEW I_JITOutbCallHdrTP AS
SELECT
  JITHeaderUUID,
  InternalJITCallNumber,
  ExternalJITCallNumber,
  ExternalJITCallNumber AS ExternalJITCallNumberForFilter,
  ShipToParty,
  SoldToParty,
  JITLifecycleStatus,
  JITCallType,
  VehicleIdentificationNumber,
  VehicleModel,
  JITPlannedOrderNumber,
  JITVehicleSeqDateTime,
  JITIntSequenceNumber,
  SalesOrganization,
  DistributionChannel,
  Division,
  UnloadingPointName,
  CustomerPartnerDescription,
  MatlUsageIndicator,
  ActiveSupplier,
  JITCallImmediateRequest,
  JITMissingPartFlag,
  JITCallPriorityType,
  JITCallPriorityID,
  JITCallCreationMode,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  _LastChangedByUser.FullName AS LastChangedByUserDescription,
  _CreatedByUser.FullName AS CreatedByUserDescription,
  LastChangeDateTime,
  ReplenishmentStrategy,
  _ProductionSupplyArea.ProductionSupplyAreaRespPerson AS Responsible,
  JITCallProcessingLogID,
  JITExtSequenceNumber,
  RequirementDateTime,
  JITSupplyDateTime,
  WarehouseNumber,
  Plant,
  CompGrpMatl,
  StorageLocation,
  JITControlCycle,
  ProductionSupplyArea,
  JITOutbDestinationStorLoc,
  JITActionCtrl,
  JITIntStatusUpdtdOn,
  JITIntProcessingStatus,
  Material
FROM I_JITOutbCallHdrBasic
LEFT OUTER JOIN I_JITOutbCallCompGrpDataTP AS _JITOutbCallCompGrpDataTP ON JITHeaderUUID = _JITOutbCallCompGrpDataTP.ParentDraftKey AND InternalJITCallNumber = _JITOutbCallCompGrpDataTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_JITOutbCallCompMatlDataTP AS _JITOutbCallCompMatlDataTP ON JITHeaderUUID = _JITOutbCallCompMatlDataTP.RootDraftKey AND InternalJITCallNumber = _JITOutbCallCompMatlDataTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_JITOutbCallRefTextHdrTP AS _JITOutbCallRefTextHdrTP ON JITHeaderUUID = _JITOutbCallRefTextHdrTP.ParentDraftKey AND InternalJITCallNumber = _JITOutbCallRefTextHdrTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_MRPController AS _ResponsiblePerson ON Plant = _ResponsiblePerson.Plant AND Responsible = _ResponsiblePerson.MRPController  -- association [0..1]
LEFT OUTER JOIN I_JITOutbCallPriorityType AS _JITOutbCallPriorityID ON JITCallPriorityID = _JITOutbCallPriorityID.JITCallPriorityID  -- association [0..1]
LEFT OUTER JOIN I_JITCallCreationMode AS _JITCallCreationMode ON JITCallCreationMode = _JITCallCreationMode.JITCallCreationMode  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON JITCallPriorityID = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN E_JITCall AS _JITHeaderExtension ON InternalJITCallNumber = _JITHeaderExtension.InternalJITCallNumber  -- association [0..1]
;