C_JITCallCompMatlDataTP

DDL: C_JITCALLCOMPMATLDATATP Type: view_entity CONSUMPTION Package: NJIT_APP_MANAGE_JIT_CALLS
49 Fields 1 Data Sources 4 Associations

JIT Call Comp Material Data Using Draft

C_JITCallCompMatlDataTP is a Consumption CDS View that provides data about "JIT Call Comp Material Data Using Draft" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompMatlDataTP) and exposes 49 fields with key fields InternalJITCallNumber, CompGrpNumber, JITCallItemNumber. It has 4 associations to related views. Part of development package NJIT_APP_MANAGE_JIT_CALLS.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompMatlDataTP _JITCallCompMatlDataTP from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_JITCallHeaderDataTP _JITCallHeaderDataTP $projection.InternalJITCallNumber = _JITCallHeaderDataTP.InternalJITCallNumber
[1..1] C_JITCallCompGrpDataTP _JITCallCompGrpDataTP $projection.InternalJITCallNumber = _JITCallCompGrpDataTP.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallCompGrpDataTP.CompGrpNumber
[0..*] C_JITCallRefTextMatTP _JITCallRefTextMatTP $projection.InternalJITCallNumber = _JITCallRefTextMatTP.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallRefTextMatTP.CompGrpNumber and $projection.JITCallItemNumber = _JITCallRefTextMatTP.JITCallItemNumber
[0..*] C_JITCallDelivConfRefDoc _JITCallDelivConfRefDoc $projection.InternalJITCallNumber = _JITCallDelivConfRefDoc.BusinessTransactionDocument and $projection.JITCallItemNumber = _JITCallDelivConfRefDoc.BusinessTransactionDocItem

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT Call Comp Material Data Using Draft view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.createEnabled true view
ObjectModel.transactionalProcessingDelegated true view
Search.searchable true view
UI.headerInfo.typeName Component view
UI.headerInfo.typeNamePlural Components view
VDM.viewType #CONSUMPTION view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber Internal JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group Number
KEY JITCallItemNumber JITCallItemNumber Ext. Item No.
JITCallItemNumberForEdit JITCallItemNumberForEdit Item No.
Material Material Component Material
ProductName ProductName Description
MaterialByCustomer MaterialByCustomer Customer Material
ExtJITCallItemNumber ExtJITCallItemNumber External Call Item Number
SalesSchedulingAgreement SalesOrder Sales Document
SalesOrderItem SalesOrderItem Sales Order Item
Division I_JITCallCompMatlDataTP Division Division
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
QuantityUnit QuantityUnit Unit of measure
IsErrorMsgNotToBeLogged IsErrorMsgNotToBeLogged Exculde Error
UnloadingPointName UnloadingPointName Unloading Point
ShippingPoint ShippingPoint Shipping Point
ShippingPointName ShippingPointName Description
Plant Plant Plant
StorageLocation StorageLocation Strorage Location
CustSupplyArea CustSupplyArea Customer Supply Area
SupplyAreaDesc Description
CustAssemblyLoc CustAssemblyLoc Assembly Location
ShipToParty ShipToParty Ship-To Party (obsolete)
TransmittedExtStatusByMfr TransmittedExtStatusByMfr Transmitted Status
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
JITExtStatusUpdtdOn JITExtStatusUpdtdOn Ext. Status Updtd
JITIntStatusUpdtdOn JITIntStatusUpdtdOn Int Status Updtd On
JITExtStatusAtSupplier JITExtStatusAtSupplier External Status
SupplyControlID SupplyControlID Supply Control ID
SupplyControlUUID SupplyControlUUID NodeID
JITActionCtrl JITActionCtrl Action Control
RequirementDateTime RequirementDateTime Requirement Date & Time
PlannedShippingDateTime PlannedShippingDateTime Pl. Shippg Date Time
DeliveryCreationDate DeliveryCreationDate Delivery Date
MaterialAvailabilityDate MaterialAvailabilityDate
JITExtSequenceNumber JITExtSequenceNumber Ext.Seq. Number
CustCompGrpMatl CustCompGrpMatl
CompGrpMatl CompGrpMatl Comp. Group Matl.
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
RequestedDeliveryTime RequestedDeliveryTime
ExtCompGrpNumber ExtCompGrpNumber Extl Comp. Group No.
JITUnderDeliveryToleranceInPct _JITCallCompGrpDataTP JITUnderDeliveryToleranceInPct Undrdelvry Tolerance
JITOverDeliveryToleranceInPct _JITCallCompGrpDataTP JITOverDeliveryToleranceInPct Ovrdelivry Tolerance
TransmittedExtStsUpdtdDteTme TransmittedExtStsUpdtdDteTme Ext. Status Updtd
_JITCallCompGrpDataTP _JITCallCompGrpDataTP
_JITCallHeaderDataTP _JITCallHeaderDataTP
_JITCallRefTextMatTP _JITCallRefTextMatTP
_JITCallDelivConfRefDoc _JITCallDelivConfRefDoc

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_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.

CREATE VIEW C_JITCallCompMatlDataTP AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITCallItemNumberForEdit,
  Material,
  ProductName,
  MaterialByCustomer,
  ExtJITCallItemNumber,
  SalesOrder AS SalesSchedulingAgreement,
  SalesOrderItem,
  _JITCallCompMatlDataTP.Division AS Division,
  RequestedQuantity,
  ActualDeliveredQuantity,
  QuantityUnit,
  IsErrorMsgNotToBeLogged,
  UnloadingPointName,
  ShippingPoint,
  ShippingPointName,
  Plant,
  StorageLocation,
  CustSupplyArea,
  _JITCustSupplyArea._JITCustomerSupplyAreaDesc[1: Language=$session.system_language].SupplyAreaDesc AS SupplyAreaDesc,
  CustAssemblyLoc,
  ShipToParty,
  TransmittedExtStatusByMfr,
  JITIntProcessingStatus,
  JITExtStatusUpdtdOn,
  JITIntStatusUpdtdOn,
  JITExtStatusAtSupplier,
  SupplyControlID,
  SupplyControlUUID,
  JITActionCtrl,
  RequirementDateTime,
  PlannedShippingDateTime,
  DeliveryCreationDate,
  MaterialAvailabilityDate,
  JITExtSequenceNumber,
  CustCompGrpMatl,
  CompGrpMatl,
  RequestedDeliveryDate,
  RequestedDeliveryTime,
  ExtCompGrpNumber,
  _JITCallCompGrpDataTP.JITUnderDeliveryToleranceInPct AS JITUnderDeliveryToleranceInPct,
  _JITCallCompGrpDataTP.JITOverDeliveryToleranceInPct AS JITOverDeliveryToleranceInPct,
  TransmittedExtStsUpdtdDteTme
FROM I_JITCallCompMatlDataTP AS _JITCallCompMatlDataTP
LEFT OUTER JOIN C_JITCallHeaderDataTP AS _JITCallHeaderDataTP ON InternalJITCallNumber = _JITCallHeaderDataTP.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN C_JITCallCompGrpDataTP AS _JITCallCompGrpDataTP ON InternalJITCallNumber = _JITCallCompGrpDataTP.InternalJITCallNumber AND CompGrpNumber = _JITCallCompGrpDataTP.CompGrpNumber  -- association [1..1]
LEFT OUTER JOIN C_JITCallRefTextMatTP AS _JITCallRefTextMatTP ON InternalJITCallNumber = _JITCallRefTextMatTP.InternalJITCallNumber AND CompGrpNumber = _JITCallRefTextMatTP.CompGrpNumber AND JITCallItemNumber = _JITCallRefTextMatTP.JITCallItemNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallDelivConfRefDoc AS _JITCallDelivConfRefDoc ON InternalJITCallNumber = _JITCallDelivConfRefDoc.BusinessTransactionDocument AND JITCallItemNumber = _JITCallDelivConfRefDoc.BusinessTransactionDocItem  -- association [0..*]
;

Learn More