I_JITOutboundDelivery_2

DDL: I_JITOUTBOUNDDELIVERY_2 Type: view_entity COMPOSITE
50 Fields 1 Data Sources 2 Associations

JIT OUTBOUND DELIVERY VERSION 2

I_JITOutboundDelivery_2 is a Composite CDS View that provides data about "JIT OUTBOUND DELIVERY VERSION 2" in SAP S/4HANA. It reads from 1 data source (I_JITOutboundDeliveryBasic) and exposes 50 fields with key fields InternalJITCallNumber, CompGrpNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITOutboundDeliveryBasic I_JITOutboundDeliveryBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..*] E_JITCall _JITCallExtension $projection.InternalJITCallNumber = _JITCallExtension.InternalJITCallNumber
[0..1] I_JITCustomerSupplyArea _JITCustomerSupplyArea $projection.ShipToParty = _JITCustomerSupplyArea.ShipToParty and $projection.CustSupplyArea = _JITCustomerSupplyArea.CustSupplyArea and $projection.UnloadingPointName = _JITCustomerSupplyArea.UnloadingPointName

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT OUTBOUND DELIVERY VERSION 2 view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view

Fields (50)

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
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
StorageLocation StorageLocation StorageLocation
JITInternalStatusText JITInternalStatusText
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
_JITAvailableUnrstrcdStock _JITAvailableUnrstrcdStock
_JITCustomerSupplyArea _JITCustomerSupplyArea

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_2.
-- 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_2 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,
  SupplyControlID,
  SupplyControlUUID,
  StorageLocation,
  JITInternalStatusText,
  BusinessPartnerName,
  OrganizationBPName1,
  ExtCompGrpNumber
FROM I_JITOutboundDeliveryBasic
LEFT OUTER JOIN E_JITCall AS _JITCallExtension ON InternalJITCallNumber = _JITCallExtension.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_JITCustomerSupplyArea AS _JITCustomerSupplyArea ON ShipToParty = _JITCustomerSupplyArea.ShipToParty AND CustSupplyArea = _JITCustomerSupplyArea.CustSupplyArea AND UnloadingPointName = _JITCustomerSupplyArea.UnloadingPointName  -- association [0..1]
;

Learn More