I_JITOutboundDeliveryBasic

DDL: I_JITOUTBOUNDDELIVERYBASIC Type: view_entity COMPOSITE Package: NJIT_APP_CREATE_DELIVERY_SUMJC

JIT Call Outbound Delivery Processing

I_JITOutboundDeliveryBasic is a Composite CDS View that provides data about "JIT Call Outbound Delivery Processing" in SAP S/4HANA. It reads from 1 data source (P_JITOutboundDeliveryBasic) and exposes 60 fields with key fields InternalJITCallNumber, CompGrpNumber. It has 3 associations to related views. Part of development package NJIT_APP_CREATE_DELIVERY_SUMJC.

Data Sources (1)

SourceAliasJoin Type
P_JITOutboundDeliveryBasic P_JITOutboundDeliveryBasic from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SalesOrganization _SalesOrganization $projection.SalesOrganization = _SalesOrganization.SalesOrganization
[0..1] I_DistributionChannel _DistributionChannel $projection.DistributionChannel = _DistributionChannel.DistributionChannel
[0..1] I_Division _Division $projection.Division = _Division.Division

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT Call Outbound Delivery Processing view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group No.
ShipToParty ShipToParty Ship-To Party (obsolete)
CustomerUUID CustomerUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
JITCallCompGrpUUID JITCallCompGrpUUID NodeID
ShippingPoint ShippingPoint Shipping Point
JITCompGrpDocConfToProdnSts JITCompGrpDocConfToProdnSts
ShippingPointName ShippingPointName
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
DeliveryCreationDate DeliveryCreationDate Delivery Date
DeliveryCreationTime DeliveryCreationTime Field of type TIMS
PlannedShippingDateTime PlannedShippingDateTime Pl. Shippg Date Time
ExternalJITCallNumber ExternalJITCallNumber Ext. JIT Call Number
CompGrpMatl CompGrpMatl Comp. Group Matl.
Material Material Vehicle Model
ProductName ProductName Description
MaterialGrossWeight MaterialGrossWeight
MaterialWeightUnit MaterialWeightUnit Weight unit
RequirementDateTime RequirementDateTime Time Stamp
MaterialVolume MaterialVolume Volume
MaterialVolumeUoM MaterialVolumeUoM Volume UoM
SoldToParty SoldToParty Sold-to Party
UnloadingPointName UnloadingPointName Unloading Point Name
SalesArea SalesArea
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
CustSupplyArea CustSupplyArea Cust. Supply Area
Plant Plant Valuation Area
SalesOrder SalesOrder SD Document
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
ScheduleLinePndgQtyInStkUnit ScheduleLinePndgQtyInStkUnit
QuantityUnit QuantityUnit Unit of measure
SupplyControlUUID SupplyControlUUID NodeID
SupplyControlID SupplyControlID Supply Control ID
StorageLocation StorageLocation StorageLocation
JITInternalStatusText JITInternalStatusText
BusinessPartnerName BusinessPartnerName Extracted Customer Name
OrganizationBPName1 OrganizationBPName1 Name 1
JITLifecycleStatus JITLifecycleStatus Life Cycle Status
CustAssemblyLoc CustAssemblyLoc Assembly Location
ExtCompGrpNumber ExtCompGrpNumber Extl Comp. Group No.
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_SalesDocumentBasic _SalesDocumentBasic
_CustomerToBusinessPartner _CustomerToBusinessPartner
_Customer _Customer
_JITSupplyControlHeader _JITSupplyControlHeader
_JITCustomer _JITCustomer
_JITAvailableUnrstrcdStock _JITAvailableUnrstrcdStock
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division

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_JITOutboundDeliveryBasic.
-- 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 I_JITOutboundDeliveryBasic AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  ShipToParty,
  CustomerUUID,
  JITHeaderUUID,
  JITCallCompGrpUUID,
  ShippingPoint,
  JITCompGrpDocConfToProdnSts,
  ShippingPointName,
  RequestedDeliveryDate,
  DeliveryCreationDate,
  DeliveryCreationTime,
  PlannedShippingDateTime,
  ExternalJITCallNumber,
  CompGrpMatl,
  Material,
  ProductName,
  MaterialGrossWeight,
  MaterialWeightUnit,
  RequirementDateTime,
  MaterialVolume,
  MaterialVolumeUoM,
  SoldToParty,
  UnloadingPointName,
  SalesArea,
  SalesOrganization,
  DistributionChannel,
  Division,
  CustSupplyArea,
  Plant,
  SalesOrder,
  JITIntProcessingStatus,
  RequestedQuantity,
  ActualDeliveredQuantity,
  ScheduleLinePndgQtyInStkUnit,
  QuantityUnit,
  SupplyControlUUID,
  SupplyControlID,
  StorageLocation,
  JITInternalStatusText,
  BusinessPartnerName,
  OrganizationBPName1,
  JITLifecycleStatus,
  CustAssemblyLoc,
  ExtCompGrpNumber,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM P_JITOutboundDeliveryBasic
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
;