C_JITCallDetail

DDL: C_JITCALLDETAIL Type: view CONSUMPTION

JIT Call Detail

C_JITCallDetail is a Consumption CDS View that provides data about "JIT Call Detail" in SAP S/4HANA. It reads from 1 data source (I_JITCallDetail) and exposes 38 fields with key fields InternalJITCallNumber, CompGrpNumber, JITCallItemNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITCallDetail I_JITCallDetail from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_JITIntJITCallNumberQuickView _JITIntJITCallNumberQuickView $projection.InternalJITCallNumber = _JITIntJITCallNumberQuickView.InternalJITCallNumber

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CJITCALLDETAIL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT Call Detail view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber Internal JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group
KEY JITCallItemNumber JITCallItemNumber Call Item Number
ExternalJITCallNumber ExternalJITCallNumber External JIT Call Number
Material Material Vehicle Model
Plant Plant Valuation Area
RequestedQuantity RequestedQuantity Requested Quantity
QuantityUnit QuantityUnit Unit of measure
AvailableQuantityInBaseUnit RequestedQuantity Requested Quantity
DifferenceQuantity RequestedQuantity Requested Quantity
ShipToParty ShipToParty Ship-To Party
OrganizationBPName1 Ship-To Party Description
RequirementDateTime RequirementDateTime Requirement Date and Time
PlannedShippingDateTime PlannedShippingDateTime Planned Shipping Date and Time
DeliveryCreationDate DeliveryCreationDate Planned Delivery Date
MaterialAvailabilityDate MaterialAvailabilityDate Material Availability Date
NumberOfCountedItems Number Of Counted Items
CompGrpMatl CompGrpMatl Component Group Material
ProductName ProductName Description
CustSupplyArea CustSupplyArea Cust. Supply Area
UnloadingPointName UnloadingPointName Unloading Point Name
ActualShippingDateTime ActualShippingDateTime
JITCallTypeText JITCallTypeText
JITLifecycleStatusText JITLifecycleStatusText
MatlUsageIndicator MatlUsageIndicator
MatlUsageIndicatorText MatlUsageIndicatorText
JITExternalStatusText JITExternalStatusText Status Description
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
DeliveryStatus DeliveryStatus Delivery Status
OrderIsCreated OrderIsCreated Delivery Created
StorageLocation StorageLocation StorageLocation
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
ShippingPoint ShippingPoint Shipping Point
Division Division Internal Division ID
_CustomerToBusinessPartner _CustomerToBusinessPartner
_Customer _Customer
_JITIntJITCallNumberQuickView _JITIntJITCallNumberQuickView

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 C_JITCallDetail.
-- 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 C_JITCallDetail AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  ExternalJITCallNumber,
  Material,
  Plant,
  RequestedQuantity,
  QuantityUnit,
  RequestedQuantity AS AvailableQuantityInBaseUnit,
  RequestedQuantity AS DifferenceQuantity,
  ShipToParty,
  _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  RequirementDateTime,
  PlannedShippingDateTime,
  DeliveryCreationDate,
  MaterialAvailabilityDate,
  cast(1 as abap.int4) AS NumberOfCountedItems,
  CompGrpMatl,
  ProductName,
  CustSupplyArea,
  UnloadingPointName,
  ActualShippingDateTime,
  JITCallTypeText,
  JITLifecycleStatusText,
  MatlUsageIndicator,
  MatlUsageIndicatorText,
  JITExternalStatusText,
  ActualDeliveredQuantity,
  DeliveryStatus,
  OrderIsCreated,
  StorageLocation,
  SalesOrganization,
  DistributionChannel,
  ShippingPoint,
  Division
FROM I_JITCallDetail
LEFT OUTER JOIN C_JITIntJITCallNumberQuickView AS _JITIntJITCallNumberQuickView ON InternalJITCallNumber = _JITIntJITCallNumberQuickView.InternalJITCallNumber  -- association [0..1]
;