C_JITCallCompMaterial

DDL: C_JITCALLCOMPMATERIAL Type: view_entity CONSUMPTION
79 Fields 1 Data Sources

Monitor JIT Call Components

C_JITCallCompMaterial is a Consumption CDS View that provides data about "Monitor JIT Call Components" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompMatlCube) and exposes 79 fields with key field JITCallComponentUUID.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompMatlCube I_JITCallCompMatlCube from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Monitor JIT Call Components view
Metadata.allowExtensions true view
OData.publish true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (79)

KeyFieldSource TableSource FieldDescription
KEY JITCallComponentUUID JITCallComponentUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
CompGrpNumber CompGrpNumber Component Group No.
JITCallItemNumber JITCallItemNumber Call Item Number
JITCallCompGrpUUID JITCallCompGrpUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
ExtJITCallItemNumber ExtJITCallItemNumber
Material Material Vehicle Model
ProductName
MaterialByCustomer MaterialByCustomer Customer Mat.
RequestedQuantity RequestedQuantity Requested Quantity
QuantityUnit QuantityUnit Unit of measure
SalesSchedulingAgreement SalesSchedulingAgreement Sales Document
SalesSchedulingAgreementItem SalesSchedulingAgreementItem Item
JITIntProcessingStatus _JITCallCompGrpEnhanced JITIntProcessingStatus Transmitted Status
JITCallCompMatlBackflushStatus JITCallCompMatlBackflushStatus BackFlush Status
JITInbCallCompDelivConfStatus JITInbCallCompDelivConfStatus
JITDelivConfQuantity JITDelivConfQuantity
JITInternalStatusText
ExternalJITCallNumber _JITInboundCall ExternalJITCallNumber Ext. JIT Call Number
ShipToParty _JITInboundCall ShipToParty Ship-To Party (obsolete)
JITCallType _JITInboundCall JITCallType Call Type
JITCallTypeText
SalesOrganization _JITInboundCall SalesOrganization Sales Organization
JITComponentIsReordered _JITInboundCall JITComponentIsReordered Usage Type
SoldToParty _JITInboundCall SoldToParty Sold-to Party
Division _JITInboundCall Division Internal Division ID
JITVehicleModel _JITInboundCall VehicleModel Vehicle Model
VehicleIdentificationNumber _JITInboundCall VehicleIdentificationNumber VIN
ExtCompGrpNumber _JITCallCompGrpEnhanced ExtCompGrpNumber Extl Comp. Group No.
JITExtSequenceNumber _JITCallCompGrpEnhanced JITExtSequenceNumber Ext.Seq. Number
CompGrpMatl _JITCallCompGrpEnhanced CompGrpMatl Comp. Group Matl.
RequirementDateTime _JITCallCompGrpEnhanced RequirementDateTime Time Stamp
Plant _JITCallCompGrpEnhanced Plant Valuation Area
PlantName
NumberOfComponents NumberOfComponents
JITActionCtrl _JITCallCompGrpEnhanced JITActionCtrl Action Control
SupplyControlID _JITCallCompGrpEnhanced SupplyControlID Supply Control ID
SupplyControlDesc
SupplyControlUUID _JITCallCompGrpEnhanced SupplyControlUUID NodeID
JITDelivSqncGrpUUID _JITCallCompGrpEnhanced JITDelivSqncGrpUUID NodeID
CustSupplyArea _JITCallCompGrpEnhanced CustSupplyArea Cust. Supply Area
CustAssemblyLoc _JITCallCompGrpEnhanced CustAssemblyLoc Assembly Location
UnloadingPointName _JITCallCompGrpEnhanced UnloadingPointName Unloading Point Name
ShippingPoint _JITCallCompGrpEnhanced ShippingPoint Shipping Point
JITExtStatusAtSupplier _JITCallCompGrpEnhanced JITExtStatusAtSupplier External Status
PlannedShippingDateTime _JITCallCompGrpEnhanced PlannedShippingDateTime Pl. Shippg Date Time
DeliveryCreationDate _JITCallCompGrpEnhanced DeliveryCreationDate Delivery Date
ProductionLine
JITPckgGrpID
JITPackageLevel
JITAltvHndlgUnitID
JITPckgGrpCellNumber
JITSuperPckgGrpUUID _JITCallCompGrpEnhanced JITSuperPckgGrpUUID NodeID
JITSuperPckgGrpID
JITAltvHndlgUnitIDShrt
JITPckgGrpUUID _JITCallCompGrpEnhanced JITSuperPckgGrpUUID NodeID
JITDelivSqncGrpID _JITCallCompGrpEnhanced JITDelivSqncGrpID Del. Seq. Grp. ID
ExtJITDelivSqncGrpID
HandlingUnitExternalID _JITCallCompGrpEnhanced HandlingUnitExternalID Handling Unit
OutboundDelivery _JITCallCompGrpEnhanced OutboundDelivery LE Delivery
SerialNumber _JITCallCompGrpEnhanced SerialNumber Serial Number
JITCallForwardingStatus _JITCallCompGrpEnhanced JITCallForwardingStatus
JITCallForwardingStatusText
JITExtStatusUpdtdOn
JITIntStatusUpdtdOn
CreationDateTime
LastChangeDateTime
LastChangedByUser _JITInboundCall LastChangedByUser User Name
_JITInboundCall _JITInboundCall
_JITInbCallComponentGroup _JITInbCallComponentGroup
_JITCallCompGrpEnhanced _JITCallCompGrpEnhanced
_JITCallCompMatlRefTextEnhcd _JITCallCompMatlRefTextEnhcd
_JITCallCompGrpRefTextEnhcd _JITCallCompGrpRefTextEnhcd
_JITCallHdrRefTextEnhcd _JITCallHdrRefTextEnhcd
_ProductCompMatl _ProductCompMatl
_SalesSchedgAgrmt _SalesSchedgAgrmt
_SalesSchedgAgrmtItem _SalesSchedgAgrmtItem
_JITBackflushStatus _JITBackflushStatus

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_JITCallCompMaterial.
-- 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_JITCallCompMaterial AS
SELECT
  JITCallComponentUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITCallCompGrpUUID,
  JITHeaderUUID,
  ExtJITCallItemNumber,
  Material,
  _ProductCompMatl._Text[1: Language=$session.system_language].ProductName AS ProductName,
  MaterialByCustomer,
  RequestedQuantity,
  QuantityUnit,
  SalesSchedulingAgreement,
  SalesSchedulingAgreementItem,
  _JITCallCompGrpEnhanced.JITIntProcessingStatus AS JITIntProcessingStatus,
  JITCallCompMatlBackflushStatus,
  JITInbCallCompDelivConfStatus,
  JITDelivConfQuantity,
  _JITCallCompGrpEnhanced._JITInternalStatus._Text[1:Language = $session.system_language].JITInternalStatusText AS JITInternalStatusText,
  _JITInboundCall.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITInboundCall.ShipToParty AS ShipToParty,
  _JITInboundCall.JITCallType AS JITCallType,
  _JITInboundCall._JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  _JITInboundCall.SalesOrganization AS SalesOrganization,
  _JITInboundCall.JITComponentIsReordered AS JITComponentIsReordered,
  _JITInboundCall.SoldToParty AS SoldToParty,
  _JITInboundCall.Division AS Division,
  _JITInboundCall.VehicleModel AS JITVehicleModel,
  _JITInboundCall.VehicleIdentificationNumber AS VehicleIdentificationNumber,
  _JITCallCompGrpEnhanced.ExtCompGrpNumber AS ExtCompGrpNumber,
  _JITCallCompGrpEnhanced.JITExtSequenceNumber AS JITExtSequenceNumber,
  _JITCallCompGrpEnhanced.CompGrpMatl AS CompGrpMatl,
  _JITCallCompGrpEnhanced.RequirementDateTime AS RequirementDateTime,
  _JITCallCompGrpEnhanced.Plant AS Plant,
  _JITCallCompGrpEnhanced._Plant.PlantName AS PlantName,
  NumberOfComponents,
  _JITCallCompGrpEnhanced.JITActionCtrl AS JITActionCtrl,
  _JITCallCompGrpEnhanced.SupplyControlID AS SupplyControlID,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader._Description[1:Language=$session.system_language].SupplyControlDesc AS SupplyControlDesc,
  _JITCallCompGrpEnhanced.SupplyControlUUID AS SupplyControlUUID,
  _JITCallCompGrpEnhanced.JITDelivSqncGrpUUID AS JITDelivSqncGrpUUID,
  _JITCallCompGrpEnhanced.CustSupplyArea AS CustSupplyArea,
  _JITCallCompGrpEnhanced.CustAssemblyLoc AS CustAssemblyLoc,
  _JITCallCompGrpEnhanced.UnloadingPointName AS UnloadingPointName,
  _JITCallCompGrpEnhanced.ShippingPoint AS ShippingPoint,
  _JITCallCompGrpEnhanced.JITExtStatusAtSupplier AS JITExtStatusAtSupplier,
  _JITCallCompGrpEnhanced.PlannedShippingDateTime AS PlannedShippingDateTime,
  _JITCallCompGrpEnhanced.DeliveryCreationDate AS DeliveryCreationDate,
  _JITCallCompGrpEnhanced._ProductionVersion.ProductionLine AS ProductionLine,
  _JITCallCompGrpEnhanced._JITPckgGrpItemRef._JITPckgGrpItem._JITPckgGrpHeader.JITPckgGrpID AS JITPckgGrpID,
  _JITCallCompGrpEnhanced._JITPckgGrpItemRef._JITPckgGrpItem._JITPckgGrpHeader.JITPackageLevel AS JITPackageLevel,
  _JITCallCompGrpEnhanced._JITPckgGrpItemRef._JITPckgGrpItem._JITPckgGrpHeader.JITAltvHndlgUnitID AS JITAltvHndlgUnitID,
  _JITCallCompGrpEnhanced._JITPckgGrpItemRef._JITPckgGrpItem.JITPckgGrpCellNumber AS JITPckgGrpCellNumber,
  _JITCallCompGrpEnhanced.JITSuperPckgGrpUUID AS JITSuperPckgGrpUUID,
  _JITCallCompGrpEnhanced._JITPckgGrpHeader.JITPckgGrpID AS JITSuperPckgGrpID,
  _JITCallCompGrpEnhanced._JITPckgGrpHeader.JITAltvHndlgUnitID AS JITAltvHndlgUnitIDShrt,
  _JITCallCompGrpEnhanced.JITSuperPckgGrpUUID AS JITPckgGrpUUID,
  _JITCallCompGrpEnhanced.JITDelivSqncGrpID AS JITDelivSqncGrpID,
  _JITCallCompGrpEnhanced._JITDelivSqncGrpHeaderBasic.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID,
  _JITCallCompGrpEnhanced.HandlingUnitExternalID AS HandlingUnitExternalID,
  _JITCallCompGrpEnhanced.OutboundDelivery AS OutboundDelivery,
  _JITCallCompGrpEnhanced.SerialNumber AS SerialNumber,
  _JITCallCompGrpEnhanced.JITCallForwardingStatus AS JITCallForwardingStatus,
  _JITCallCompGrpEnhanced._JITCallForwardingStatus._Text[1:Language=$session.system_language].JITCallForwardingStatusText AS JITCallForwardingStatusText,
  cast(_JITCallCompGrpEnhanced.JITExtStatusUpdtdOn as tzntstmps) AS JITExtStatusUpdtdOn,
  cast(_JITCallCompGrpEnhanced.JITIntStatusUpdtdOn as tzntstmps) AS JITIntStatusUpdtdOn,
  cast(_JITInboundCall.CreationDateTime as tzntstmps) AS CreationDateTime,
  cast(_JITInboundCall.LastChangeDateTime as tzntstmps) AS LastChangeDateTime,
  _JITInboundCall.LastChangedByUser AS LastChangedByUser
FROM I_JITCallCompMatlCube
;

Learn More