I_JITCompGrpDueForDelivery

DDL: I_JITCOMPGRPDUEFORDELIVERY Type: view_entity TRANSACTIONAL
26 Fields 1 Data Sources 2 Associations

Component Group Due for Delivery

I_JITCompGrpDueForDelivery is a Transactional CDS View that provides data about "Component Group Due for Delivery" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompGroupBasic) and exposes 26 fields with key field JITCallCompGrpUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompGroupBasic I_JITCallCompGroupBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_JITSupplyControlTolLvl _JITSupplyControlTolLvl $projection.SupplyControlUUID = _JITSupplyControlTolLvl.SupplyControlUUID and _JITSupplyControlTolLvl.JITToleranceDateType = '1'
[0..1] I_Customer _Customer $projection.shiptoparty = _Customer.Customer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Component Group Due for Delivery view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY JITCallCompGrpUUID JITCallCompGrpUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
ExternalJITCallNumber _JITCallHeaderBasic ExternalJITCallNumber Ext. JIT Call Number
JITCallType _JITCallHeaderBasic JITCallType Call Type
ShipToParty _JITCallHeaderBasic ShipToParty Ship-To Party (obsolete)
SalesOrganization _JITCallHeaderBasic SalesOrganization Sales Organization
DistributionChannel _JITCallHeaderBasic DistributionChannel RefDistCh-Cust/Mat.
Division _JITCallHeaderBasic Division Internal Division ID
SoldToParty _JITCallHeaderBasic SoldToParty Sold-to Party
CompGrpNumber CompGrpNumber Component Group No.
ExtCompGrpNumber ExtCompGrpNumber Extl Comp. Group No.
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
CompGrpMatl CompGrpMatl Comp. Group Matl.
CustCompGrpMatl CustCompGrpMatl Cust Comp. Grp. Matl
CustSupplyArea CustSupplyArea Cust. Supply Area
UnloadingPointName UnloadingPointName Unloading Point Name
Plant Plant Valuation Area
CustAssemblyLoc CustAssemblyLoc Assembly Location
ShippingPoint ShippingPoint Shipping Point
StorageLocation StorageLocation StorageLocation
SupplyControlUUID SupplyControlUUID NodeID
DeliveryCreationDate DeliveryCreationDate Delivery Date
DeliveryCreationTime DeliveryCreationTime Field of type TIMS
_JITCallHeaderBasic _JITCallHeaderBasic
_Customer _Customer

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_JITCompGrpDueForDelivery.
-- 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_JITCompGrpDueForDelivery AS
SELECT
  JITCallCompGrpUUID,
  JITHeaderUUID,
  InternalJITCallNumber,
  _JITCallHeaderBasic.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITCallHeaderBasic.JITCallType AS JITCallType,
  _JITCallHeaderBasic.ShipToParty AS ShipToParty,
  _JITCallHeaderBasic.SalesOrganization AS SalesOrganization,
  _JITCallHeaderBasic.DistributionChannel AS DistributionChannel,
  _JITCallHeaderBasic.Division AS Division,
  _JITCallHeaderBasic.SoldToParty AS SoldToParty,
  CompGrpNumber,
  ExtCompGrpNumber,
  JITIntProcessingStatus,
  CompGrpMatl,
  CustCompGrpMatl,
  CustSupplyArea,
  UnloadingPointName,
  Plant,
  CustAssemblyLoc,
  ShippingPoint,
  StorageLocation,
  SupplyControlUUID,
  DeliveryCreationDate,
  DeliveryCreationTime
FROM I_JITCallCompGroupBasic
LEFT OUTER JOIN I_JITSupplyControlTolLvl AS _JITSupplyControlTolLvl ON SupplyControlUUID = _JITSupplyControlTolLvl.SupplyControlUUID AND _JITSupplyControlTolLvl.JITToleranceDateType = '1'  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON shiptoparty = _Customer.Customer  -- association [0..1]
;

Learn More