P_JITCallCompGroup

DDL: P_JITCALLCOMPGROUP SQL: PJITCALLCOMPGRP Type: view COMPOSITE
44 Fields 1 Data Sources 1 Associations

P_JITCallCompGroup is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_JITCallCompGroup) and exposes 44 fields with key fields JITCallCompGrpUUID, InternalJITCallNumber, CompGrpNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompGroup I_JITCallCompGroup from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_JITPckgGrpHeader _JITPckgGrpHeader $projection.JITPckgGrpUUID = _JITPckgGrpHeader.JITPckgGrpUUID

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PJITCALLCOMPGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY JITCallCompGrpUUID JITCallCompGrpUUID NodeID
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group No.
JITPckgGrpUUID JITPckgGrpUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
ExtCompGrpNumber ExtCompGrpNumber Extl Comp. Group No.
CompGrpMatl CompGrpMatl Comp. Group Matl.
CustCompGrpMatl CustCompGrpMatl
JITExtSequenceNumber JITExtSequenceNumber Ext.Seq. Number
TransmittedExtStatusByMfr TransmittedExtStatusByMfr Transmitted Status
JITExtStatusAtSupplier JITExtStatusAtSupplier External Status
JITExtStatusUpdtdOn JITExtStatusUpdtdOn Ext. Status Updtd
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
JITIntStatusUpdtdOn JITIntStatusUpdtdOn Int Status Updtd On
RequirementDateTime RequirementDateTime Time Stamp
Plant Plant Valuation Area
CustSupplyArea CustSupplyArea Cust. Supply Area
UnloadingPointName UnloadingPointName Unloading Point Name
SupplyControlUUID SupplyControlUUID NodeID
SupplyControlID SupplyControlID Supply Control ID
JITActionCtrl JITActionCtrl Action Control
CustAssemblyLoc CustAssemblyLoc Assembly Location
ShippingPoint ShippingPoint Shipping Point
StorageLocation StorageLocation StorageLocation
PlannedShippingDateTime PlannedShippingDateTime Pl. Shippg Date Time
ActualShippingDateTime ActualShippingDateTime
MaterialAvailabilityDate MaterialAvailabilityDate
MaterialAvailabilityTime MaterialAvailabilityTime
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
RequestedDeliveryTime RequestedDeliveryTime
WarehouseNumber WarehouseNumber
DeliveryCreationDate DeliveryCreationDate Delivery Date
DeliveryStatus DeliveryStatus Delivery Status
PickingStatus PickingStatus Status Value
GoodsMovementStatus GoodsMovementStatus Gds Movemt Status
JITCallType JITCallType Call Type
ShipToParty ShipToParty Ship-To Party (obsolete)
SalesOrganization SalesOrganization Sales Organization
ExternalJITCallNumber ExternalJITCallNumber Ext. JIT Call Number
ProductName ProductName Description
ProductionStartDate ProductionStartDate Start of Production
ProductionEndDate ProductionEndDate Production End Date
ProductionVersion ProductionVersion Version ID
char70asExternalDocumentID

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_JITCallCompGroup.
-- 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.
-- SQL view name: PJITCALLCOMPGRP

CREATE VIEW P_JITCallCompGroup AS
SELECT
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITPckgGrpUUID,
  JITHeaderUUID,
  ExtCompGrpNumber,
  CompGrpMatl,
  CustCompGrpMatl,
  JITExtSequenceNumber,
  TransmittedExtStatusByMfr,
  JITExtStatusAtSupplier,
  JITExtStatusUpdtdOn,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOn,
  RequirementDateTime,
  Plant,
  CustSupplyArea,
  UnloadingPointName,
  SupplyControlUUID,
  SupplyControlID,
  JITActionCtrl,
  CustAssemblyLoc,
  ShippingPoint,
  StorageLocation,
  PlannedShippingDateTime,
  ActualShippingDateTime,
  MaterialAvailabilityDate,
  MaterialAvailabilityTime,
  RequestedDeliveryDate,
  RequestedDeliveryTime,
  WarehouseNumber,
  DeliveryCreationDate,
  DeliveryStatus,
  PickingStatus,
  GoodsMovementStatus,
  JITCallType,
  ShipToParty,
  SalesOrganization,
  ExternalJITCallNumber,
  ProductName,
  ProductionStartDate,
  ProductionEndDate,
  ProductionVersion,
  cast(case when JITCallType = '0' then concat( InternalJITCallNumber, CompGrpNumber) else _JITPckgGrpHeader.JITPckgGrpID end as abap.char(70) ) as ExternalDocumentID AS char70asExternalDocumentID
FROM I_JITCallCompGroup
LEFT OUTER JOIN I_JITPckgGrpHeader AS _JITPckgGrpHeader ON JITPckgGrpUUID = _JITPckgGrpHeader.JITPckgGrpUUID  -- association [1..1]
;

Learn More