I_JITOutboundDelivery

DDL: I_JITOUTBOUNDDELIVERY Type: view_entity COMPOSITE Package: NJIT_APP_CREATE_DELIVERY_SUMJC
48 Fields 1 Data Sources 2 Associations

Composite View for JIT Outbound Delivery

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

Data Sources (1)

SourceAliasJoin Type
I_JITOutboundDeliveryBasic I_JITOutboundDeliveryBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..1] E_JITCall _JITCallExtension $projection.InternalJITCallNumber = _JITCallExtension.InternalJITCallNumber
[1..*] I_JITStkAnlysAtStorLoc _JITStkAnlysAtStorLoc $projection.Material = _JITStkAnlysAtStorLoc.Material and $projection.Plant = _JITStkAnlysAtStorLoc.Plant

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Composite View for JIT Outbound Delivery view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view

Fields (48)

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
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
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
SupplyControlID SupplyControlID Supply Control ID
SupplyControlUUID SupplyControlUUID NodeID
JITInternalStatusText JITInternalStatusText
ActualAvailableQuantity
BusinessPartnerName BusinessPartnerName Extracted Customer Name
OrganizationBPName1 OrganizationBPName1 Name 1
ExtCompGrpNumber ExtCompGrpNumber Extl Comp. Group No.
_SalesDocumentBasic _SalesDocumentBasic
_CustomerToBusinessPartner _CustomerToBusinessPartner
_Customer _Customer
_JITSupplyControlHeader _JITSupplyControlHeader
_JITCustomer _JITCustomer
_JITStkAnlysAtStorLoc _JITStkAnlysAtStorLoc

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_JITOutboundDelivery.
-- 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_JITOutboundDelivery AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  ShipToParty,
  CustomerUUID,
  JITHeaderUUID,
  JITCallCompGrpUUID,
  ShippingPoint,
  JITCompGrpDocConfToProdnSts,
  ShippingPointName,
  RequestedDeliveryDate,
  DeliveryCreationDate,
  PlannedShippingDateTime,
  ExternalJITCallNumber,
  CompGrpMatl,
  Material,
  ProductName,
  MaterialGrossWeight,
  MaterialWeightUnit,
  RequirementDateTime,
  MaterialVolume,
  MaterialVolumeUoM,
  SoldToParty,
  UnloadingPointName,
  SalesArea,
  SalesOrganization,
  DistributionChannel,
  Division,
  CustSupplyArea,
  Plant,
  SalesOrder,
  JITIntProcessingStatus,
  RequestedQuantity,
  ActualDeliveredQuantity,
  ScheduleLinePndgQtyInStkUnit,
  QuantityUnit,
  SupplyControlID,
  SupplyControlUUID,
  JITInternalStatusText,
  sum(_JITStkAnlysAtStorLoc.UnrestrictedStkInStkUnit) AS ActualAvailableQuantity,
  BusinessPartnerName,
  OrganizationBPName1,
  ExtCompGrpNumber
FROM I_JITOutboundDeliveryBasic
LEFT OUTER JOIN E_JITCall AS _JITCallExtension ON InternalJITCallNumber = _JITCallExtension.InternalJITCallNumber  -- association [0..1]
LEFT OUTER JOIN I_JITStkAnlysAtStorLoc AS _JITStkAnlysAtStorLoc ON Material = _JITStkAnlysAtStorLoc.Material AND Plant = _JITStkAnlysAtStorLoc.Plant  -- association [1..*]
;

Learn More