I_JITCallCompMatlDataTP

DDL: I_JITCALLCOMPMATLDATATP SQL: IJITCCMDTP Type: view TRANSACTIONAL
53 Fields 1 Data Sources 6 Associations

JIT Call Comp Material Data Using Draft

I_JITCallCompMatlDataTP is a Transactional CDS View that provides data about "JIT Call Comp Material Data Using Draft" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompMaterialBasic) and exposes 53 fields with key fields InternalJITCallNumber, CompGrpNumber, JITCallItemNumber. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompMaterialBasic I_JITCallCompMaterialBasic from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_JITCallHeaderDataTP _JITCallHeaderDataTP $projection.InternalJITCallNumber = _JITCallHeaderDataTP.InternalJITCallNumber
[1..1] I_JITCallCompGrpDataTP _JITCallCompGrpDataTP $projection.InternalJITCallNumber = _JITCallCompGrpDataTP.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallCompGrpDataTP.CompGrpNumber
[0..1] I_JITCustomerSupplyArea _JITCustSupplyArea $projection.ShipToParty = _JITCustSupplyArea.ShipToParty and $projection.custsupplyarea = _JITCustSupplyArea.CustSupplyArea
[0..1] E_JITCompMatl _JITCompMatlExtension $projection.InternalJITCallNumber = _JITCompMatlExtension.InternalJITCallNumber and $projection.CompGrpNumber = _JITCompMatlExtension.CompGrpNumber and $projection.JITCallItemNumber = _JITCompMatlExtension.JITCallItemNumber
[0..*] I_JITCallRefTextMatTP _JITCallRefTextMatTP $projection.InternalJITCallNumber = _JITCallRefTextMatTP.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallRefTextMatTP.CompGrpNumber and $projection.JITCallItemNumber = _JITCallRefTextMatTP.JITCallItemNumber
[0..1] I_Customer _Customer $projection.ShipToParty = _Customer.Customer

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IJITCCMDTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT Call Comp Material Data Using Draft view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence NJIT_CM_D view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.createEnabled true view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group No.
KEY JITCallItemNumber JITCallItemNumber Call Item Number
JITCallItemNumberForEdit JITCallItemNumber Call Item Number
ShipToParty _JITCallHeaderDataTP ShipToParty Ship-To Party (obsolete)
ExternalJITCallNumber _JITCallHeaderDataTP ExternalJITCallNumber Ext. JIT Call Number
Material Material Vehicle Model
ProductName
MaterialByCustomer MaterialByCustomer Customer Mat.
ExtJITCallItemNumber ExtJITCallItemNumber Extl Call Item No.
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
Division Division Internal Division ID
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
QuantityUnit QuantityUnit Unit of measure
IsErrorMsgNotToBeLogged
UnloadingPointName _JITCallCompGrpDataTP UnloadingPointName Unloading Point Name
ShippingPoint _JITCallCompGrpDataTP ShippingPoint Shipping Point
ShippingPointName _JITCallCompGrpDataTP ShippingPointName
Plant _JITCallCompGrpDataTP Plant Valuation Area
StorageLocation _JITCallCompGrpDataTP StorageLocation StorageLocation
CustSupplyArea _JITCallCompGrpDataTP CustSupplyArea Cust. Supply Area
SupplyAreaDesc _JITCallCompGrpDataTP SupplyAreaDesc Sup. Area Desc.
CustAssemblyLoc _JITCallCompGrpDataTP CustAssemblyLoc Assembly Location
JITExtStatusAtSupplier _JITCallCompGrpDataTP JITExtStatusAtSupplier External Status
JITExtStatusUpdtdOn _JITCallCompGrpDataTP JITExtStatusUpdtdOn Ext. Status Updtd
JITIntProcessingStatus _JITCallCompGrpDataTP JITIntProcessingStatus Transmitted Status
JITIntStatusUpdtdOn _JITCallCompGrpDataTP JITIntStatusUpdtdOn Int Status Updtd On
TransmittedExtStatusByMfr _JITCallCompGrpDataTP TransmittedExtStatusByMfr Transmitted Status
SupplyControlID _JITCallCompGrpDataTP SupplyControlID Supply Control ID
SupplyControlUUID _JITCallCompGrpDataTP SupplyControlUUID NodeID
JITActionCtrl _JITCallCompGrpDataTP JITActionCtrl Action Control
RequirementDateTime _JITCallCompGrpDataTP RequirementDateTime Time Stamp
PlannedShippingDateTime _JITCallCompGrpDataTP PlannedShippingDateTime Pl. Shippg Date Time
DeliveryCreationDate _JITCallCompGrpDataTP DeliveryCreationDate Delivery Date
DeliveryCreationTime _JITCallCompGrpDataTP DeliveryCreationTime Field of type TIMS
MaterialAvailabilityDate _JITCallCompGrpDataTP MaterialAvailabilityDate
MaterialAvailabilityTime _JITCallCompGrpDataTP MaterialAvailabilityTime
CustCompGrpMatl _JITCallCompGrpDataTP CustCompGrpMatl
JITExtSequenceNumber _JITCallCompGrpDataTP JITExtSequenceNumber Ext.Seq. Number
CompGrpMatl _JITCallCompGrpDataTP CompGrpMatl Comp. Group Matl.
RequestedDeliveryDate _JITCallCompGrpDataTP RequestedDeliveryDate Requested Delivery Date
RequestedDeliveryTime _JITCallCompGrpDataTP RequestedDeliveryTime
ExtCompGrpNumber _JITCallCompGrpDataTP ExtCompGrpNumber Extl Comp. Group No.
TransmittedExtStsUpdtdDteTme _JITCallCompGrpDataTP TransmittedExtStsUpdtdDteTme Ext. Status Updtd
JITDelivConfControl _JITCallCompGrpDataTP JITDelivConfControl Deliv Conf Control
_JITCallCompGrpDataTP _JITCallCompGrpDataTP
_JITCallHeaderDataTP _JITCallHeaderDataTP
_JITCallRefTextMatTP _JITCallRefTextMatTP
_ProductCompMatl _ProductCompMatl
_JITCustSupplyArea _JITCustSupplyArea
_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_JITCallCompMatlDataTP.
-- 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: IJITCCMDTP

CREATE VIEW I_JITCallCompMatlDataTP AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITCallItemNumber AS JITCallItemNumberForEdit,
  _JITCallHeaderDataTP.ShipToParty AS ShipToParty,
  _JITCallHeaderDataTP.ExternalJITCallNumber AS ExternalJITCallNumber,
  Material,
  _ProductCompMatl._Text[1: Language=$session.system_language].ProductName AS ProductName,
  MaterialByCustomer,
  ExtJITCallItemNumber,
  SalesOrder,
  SalesOrderItem,
  Division,
  RequestedQuantity,
  ActualDeliveredQuantity,
  QuantityUnit,
  cast('' as njit_comp_matl_ind_error ) AS IsErrorMsgNotToBeLogged,
  _JITCallCompGrpDataTP.UnloadingPointName AS UnloadingPointName,
  _JITCallCompGrpDataTP.ShippingPoint AS ShippingPoint,
  _JITCallCompGrpDataTP.ShippingPointName AS ShippingPointName,
  _JITCallCompGrpDataTP.Plant AS Plant,
  _JITCallCompGrpDataTP.StorageLocation AS StorageLocation,
  _JITCallCompGrpDataTP.CustSupplyArea AS CustSupplyArea,
  _JITCallCompGrpDataTP.SupplyAreaDesc AS SupplyAreaDesc,
  _JITCallCompGrpDataTP.CustAssemblyLoc AS CustAssemblyLoc,
  _JITCallCompGrpDataTP.JITExtStatusAtSupplier AS JITExtStatusAtSupplier,
  _JITCallCompGrpDataTP.JITExtStatusUpdtdOn AS JITExtStatusUpdtdOn,
  _JITCallCompGrpDataTP.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITCallCompGrpDataTP.JITIntStatusUpdtdOn AS JITIntStatusUpdtdOn,
  _JITCallCompGrpDataTP.TransmittedExtStatusByMfr AS TransmittedExtStatusByMfr,
  _JITCallCompGrpDataTP.SupplyControlID AS SupplyControlID,
  _JITCallCompGrpDataTP.SupplyControlUUID AS SupplyControlUUID,
  _JITCallCompGrpDataTP.JITActionCtrl AS JITActionCtrl,
  _JITCallCompGrpDataTP.RequirementDateTime AS RequirementDateTime,
  _JITCallCompGrpDataTP.PlannedShippingDateTime AS PlannedShippingDateTime,
  _JITCallCompGrpDataTP.DeliveryCreationDate AS DeliveryCreationDate,
  _JITCallCompGrpDataTP.DeliveryCreationTime AS DeliveryCreationTime,
  _JITCallCompGrpDataTP.MaterialAvailabilityDate AS MaterialAvailabilityDate,
  _JITCallCompGrpDataTP.MaterialAvailabilityTime AS MaterialAvailabilityTime,
  _JITCallCompGrpDataTP.CustCompGrpMatl AS CustCompGrpMatl,
  _JITCallCompGrpDataTP.JITExtSequenceNumber AS JITExtSequenceNumber,
  _JITCallCompGrpDataTP.CompGrpMatl AS CompGrpMatl,
  _JITCallCompGrpDataTP.RequestedDeliveryDate AS RequestedDeliveryDate,
  _JITCallCompGrpDataTP.RequestedDeliveryTime AS RequestedDeliveryTime,
  _JITCallCompGrpDataTP.ExtCompGrpNumber AS ExtCompGrpNumber,
  _JITCallCompGrpDataTP.TransmittedExtStsUpdtdDteTme AS TransmittedExtStsUpdtdDteTme,
  _JITCallCompGrpDataTP.JITDelivConfControl AS JITDelivConfControl
FROM I_JITCallCompMaterialBasic
LEFT OUTER JOIN I_JITCallHeaderDataTP AS _JITCallHeaderDataTP ON InternalJITCallNumber = _JITCallHeaderDataTP.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_JITCallCompGrpDataTP AS _JITCallCompGrpDataTP ON InternalJITCallNumber = _JITCallCompGrpDataTP.InternalJITCallNumber AND CompGrpNumber = _JITCallCompGrpDataTP.CompGrpNumber  -- association [1..1]
LEFT OUTER JOIN I_JITCustomerSupplyArea AS _JITCustSupplyArea ON ShipToParty = _JITCustSupplyArea.ShipToParty AND custsupplyarea = _JITCustSupplyArea.CustSupplyArea  -- association [0..1]
LEFT OUTER JOIN E_JITCompMatl AS _JITCompMatlExtension ON InternalJITCallNumber = _JITCompMatlExtension.InternalJITCallNumber AND CompGrpNumber = _JITCompMatlExtension.CompGrpNumber AND JITCallItemNumber = _JITCompMatlExtension.JITCallItemNumber  -- association [0..1]
LEFT OUTER JOIN I_JITCallRefTextMatTP AS _JITCallRefTextMatTP ON InternalJITCallNumber = _JITCallRefTextMatTP.InternalJITCallNumber AND CompGrpNumber = _JITCallRefTextMatTP.CompGrpNumber AND JITCallItemNumber = _JITCallRefTextMatTP.JITCallItemNumber  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON ShipToParty = _Customer.Customer  -- association [0..1]
;

Learn More