P_JITOutboundDeliveryBasic

DDL: P_JITOUTBOUNDDELIVERYBASIC Type: view_entity COMPOSITE Package: NJIT_APP_CREATE_DELIVERY_SUMJC
61 Fields 1 Data Sources 3 Associations

Private Basic View for JIT Outbound Delivery

P_JITOutboundDeliveryBasic is a Composite CDS View that provides data about "Private Basic View for JIT Outbound Delivery" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompMaterialBasic) and exposes 61 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
I_JITCallCompMaterialBasic I_JITCallCompMaterialBasic from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SalesDocumentBasic _SalesDocumentBasic $projection.SalesOrder = _SalesDocumentBasic.SalesDocument
[1..1] I_JITSupplyControlHeader _JITSupplyControlHeader $projection.supplycontroluuid = _JITSupplyControlHeader.SupplyControlUUID
[0..1] I_JITAvailableUnrstrcdStock _JITAvailableUnrstrcdStock $projection.Material = _JITAvailableUnrstrcdStock.Material and $projection.plant = _JITAvailableUnrstrcdStock.Plant and $projection.QuantityUnit = _JITAvailableUnrstrcdStock.MaterialBaseUnit

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group No.
JITHeaderUUID JITHeaderUUID NodeID
JITCallCompGrpUUID JITCallCompGrpUUID NodeID
Material Material Vehicle Model
SalesOrder SalesOrder SD Document
QuantityUnit QuantityUnit Unit of measure
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
ScheduleLinePndgQtyInStkUnit
MaterialWeightUnit _ProductCompMatl WeightUnit Weight unit
MaterialVolumeUoM _ProductCompMatl VolumeUnit Volume Unit
MaterialGrossWeight
MaterialVolume
SupplyControlUUID _JITCallCompGroupBasic SupplyControlUUID NodeID
Plant _JITCallCompGroupBasic Plant Valuation Area
RequirementDateTime _JITCallCompGroupBasic RequirementDateTime Time Stamp
JITCompGrpDocConfToProdnSts _JITCallCompGroupBasic JITCompGrpDocConfToProdnSts
ShippingPoint _JITCallCompGroupBasic ShippingPoint Shipping Point
RequestedDeliveryDate _JITCallCompGroupBasic RequestedDeliveryDate Requested Delivery Date
DeliveryCreationDate _JITCallCompGroupBasic DeliveryCreationDate Delivery Date
DeliveryCreationTime _JITCallCompGroupBasic DeliveryCreationTime Field of type TIMS
PlannedShippingDateTime _JITCallCompGroupBasic PlannedShippingDateTime Pl. Shippg Date Time
CustSupplyArea _JITCallCompGroupBasic CustSupplyArea Cust. Supply Area
JITIntProcessingStatus _JITCallCompGroupBasic JITIntProcessingStatus Transmitted Status
SupplyControlID _JITCallCompGroupBasic SupplyControlID Supply Control ID
StorageLocation _JITCallCompGroupBasic StorageLocation StorageLocation
CompGrpMatl _JITCallCompGroupBasic CompGrpMatl Comp. Group Matl.
CustAssemblyLoc _JITCallCompGroupBasic CustAssemblyLoc Assembly Location
ExtCompGrpNumber _JITCallCompGroupBasic ExtCompGrpNumber Extl Comp. Group No.
DeliveryStatus _JITCallCompGroupBasic DeliveryStatus Delivery Status
ExternalJITCallNumber
ShipToParty
CustomerUUID
SoldToParty
SalesOrganization
DistributionChannel
Division
JITLifecycleStatus
JITCallType
BusinessPartnerName
OrganizationBPName1
SalesArea
JITInternalStatusText
ProductName
ShippingPointName
CreationDateTime
CreatedByUser
LastChangeDateTime
LastChangedByUser
_SalesDocumentBasic _SalesDocumentBasic
_JITAvailableUnrstrcdStock _JITAvailableUnrstrcdStock
_JITSupplyControlHeader _JITSupplyControlHeader
_CustomerToBusinessPartner
_JITCustomer
_Customer
_CreatedByUser
_LastChangedByUser
PartialDeliveryIsAllowed
JITCallCompGrpCancellationSts _JITCallCompGroupBasic JITCallCompGrpCancellationSts
_JITCallCompGroupBasic _JITCallCompGroupBasic

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 P_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 P_JITOutboundDeliveryBasic AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITHeaderUUID,
  JITCallCompGrpUUID,
  Material,
  SalesOrder,
  QuantityUnit,
  RequestedQuantity,
  ActualDeliveredQuantity,
  RequestedQuantity - ActualDeliveredQuantity AS ScheduleLinePndgQtyInStkUnit,
  _ProductCompMatl.WeightUnit AS MaterialWeightUnit,
  _ProductCompMatl.VolumeUnit AS MaterialVolumeUoM,
  cast(_ProductCompMatl.GrossWeight*(RequestedQuantity - ActualDeliveredQuantity) as abap.quan( 13, 3 )) AS MaterialGrossWeight,
  cast(_ProductCompMatl.MaterialVolume*(RequestedQuantity - ActualDeliveredQuantity) as abap.quan( 13, 3)) AS MaterialVolume,
  _JITCallCompGroupBasic.SupplyControlUUID AS SupplyControlUUID,
  _JITCallCompGroupBasic.Plant AS Plant,
  _JITCallCompGroupBasic.RequirementDateTime AS RequirementDateTime,
  _JITCallCompGroupBasic.JITCompGrpDocConfToProdnSts AS JITCompGrpDocConfToProdnSts,
  _JITCallCompGroupBasic.ShippingPoint AS ShippingPoint,
  _JITCallCompGroupBasic.RequestedDeliveryDate AS RequestedDeliveryDate,
  _JITCallCompGroupBasic.DeliveryCreationDate AS DeliveryCreationDate,
  _JITCallCompGroupBasic.DeliveryCreationTime AS DeliveryCreationTime,
  _JITCallCompGroupBasic.PlannedShippingDateTime AS PlannedShippingDateTime,
  _JITCallCompGroupBasic.CustSupplyArea AS CustSupplyArea,
  _JITCallCompGroupBasic.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITCallCompGroupBasic.SupplyControlID AS SupplyControlID,
  _JITCallCompGroupBasic.StorageLocation AS StorageLocation,
  _JITCallCompGroupBasic.CompGrpMatl AS CompGrpMatl,
  _JITCallCompGroupBasic.CustAssemblyLoc AS CustAssemblyLoc,
  _JITCallCompGroupBasic.ExtCompGrpNumber AS ExtCompGrpNumber,
  _JITCallCompGroupBasic.DeliveryStatus AS DeliveryStatus,
  _JITCallCompGroupBasic._JITCallHeaderBasic.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITCallCompGroupBasic._JITCallHeaderBasic.ShipToParty AS ShipToParty,
  _JITCallCompGroupBasic._JITCallHeaderBasic.CustomerUUID AS CustomerUUID,
  _JITCallCompGroupBasic._JITCallHeaderBasic.SoldToParty AS SoldToParty,
  _JITCallCompGroupBasic._JITCallHeaderBasic.SalesOrganization AS SalesOrganization,
  _JITCallCompGroupBasic._JITCallHeaderBasic.DistributionChannel AS DistributionChannel,
  _JITCallCompGroupBasic._JITCallHeaderBasic.Division AS Division,
  _JITCallCompGroupBasic._JITCallHeaderBasic.JITLifecycleStatus AS JITLifecycleStatus,
  _JITCallCompGroupBasic._JITCallHeaderBasic.JITCallType AS JITCallType,
  _JITCallCompGroupBasic._JITCallHeaderBasic._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _JITCallCompGroupBasic._JITCallHeaderBasic._CustomerToBusinessPartner._BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  concat( _JITCallCompGroupBasic._JITCallHeaderBasic.SalesOrganization,concat('/', concat( _JITCallCompGroupBasic._JITCallHeaderBasic.DistributionChannel, concat('/', _JITCallCompGroupBasic._JITCallHeaderBasic.Division)))) AS SalesArea,
  _JITCallCompGroupBasic._JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  _JITCallCompGroupBasic._ProductCompGrp._Text[1:Language = $session.system_language ].ProductName AS ProductName,
  _JITCallCompGroupBasic._ShippingPoint._Text[1: Language=$session.system_language].ShippingPointName AS ShippingPointName,
  _JITCallCompGroupBasic._JITCallHeaderBasic.CreationDateTime AS CreationDateTime,
  _JITCallCompGroupBasic._JITCallHeaderBasic.CreatedByUser AS CreatedByUser,
  _JITCallCompGroupBasic._JITCallHeaderBasic.LastChangeDateTime AS LastChangeDateTime,
  _JITCallCompGroupBasic._JITCallHeaderBasic.LastChangedByUser AS LastChangedByUser,
  _JITCallCompGroupBasic._JITCallHeaderBasic._CustomerToBusinessPartner AS _CustomerToBusinessPartner,
  _JITCallCompGroupBasic._JITCallHeaderBasic._JITCustomer AS _JITCustomer,
  _JITCallCompGroupBasic._JITCallHeaderBasic._Customer AS _Customer,
  _JITCallCompGroupBasic._JITCallHeaderBasic._CreatedByUser AS _CreatedByUser,
  _JITCallCompGroupBasic._JITCallHeaderBasic._LastChangedByUser AS _LastChangedByUser,
  _JITCallCompGroupBasic._JITSupplyControlHeader.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  _JITCallCompGroupBasic.JITCallCompGrpCancellationSts AS JITCallCompGrpCancellationSts
FROM I_JITCallCompMaterialBasic
LEFT OUTER JOIN I_SalesDocumentBasic AS _SalesDocumentBasic ON SalesOrder = _SalesDocumentBasic.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_JITSupplyControlHeader AS _JITSupplyControlHeader ON supplycontroluuid = _JITSupplyControlHeader.SupplyControlUUID  -- association [1..1]
LEFT OUTER JOIN I_JITAvailableUnrstrcdStock AS _JITAvailableUnrstrcdStock ON Material = _JITAvailableUnrstrcdStock.Material AND plant = _JITAvailableUnrstrcdStock.Plant AND QuantityUnit = _JITAvailableUnrstrcdStock.MaterialBaseUnit  -- association [0..1]
;

Learn More