I_JITCallRefTextMatTP

DDL: I_JITCALLREFTEXTMATTP Type: view_entity TRANSACTIONAL Package: NJIT_APP_MANAGE_JIT_CALLS
14 Fields 1 Data Sources 3 Associations

JIT Call Material Reference text

I_JITCallRefTextMatTP is a Transactional CDS View that provides data about "JIT Call Material Reference text" in SAP S/4HANA. It reads from 1 data source (I_JITCallRefTextBasic) and exposes 14 fields with key fields InternalJITCallNumber, CompGrpNumber, JITCallItemNumber, JITRefType. It has 3 associations to related views. Part of development package NJIT_APP_MANAGE_JIT_CALLS.

Data Sources (1)

SourceAliasJoin Type
I_JITCallRefTextBasic I_JITCallRefTextBasic from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_JITCallCompMatlDataTP _JITCallCompMatlDataTP $projection.InternalJITCallNumber = _JITCallCompMatlDataTP.InternalJITCallNumber and $projection.CompGrpNumber = _JITCallCompMatlDataTP.CompGrpNumber and $projection.JITCallItemNumber = _JITCallCompMatlDataTP.JITCallItemNumber
[1..1] I_JITCallHeaderDataTP _JITCallHeaderDataTP $projection.InternalJITCallNumber = _JITCallHeaderDataTP.InternalJITCallNumber
[0..1] I_Customer _Customer $projection.shiptoparty = _Customer.Customer

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT Call Material Reference text view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence NJIT_RTXT_MAT_D view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.createEnabled true view
VDM.viewType #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group No.
KEY JITCallItemNumber JITCallItemNumber Call Item Number
KEY JITRefType JITRefType Reference Type
JITRefTypeForEdit JITRefType Reference Type
JITRefText JITRefText Reference No.
ExtCompGrpNumber _JITCallCompMatlDataTP ExtCompGrpNumber Extl Comp. Group No.
MaterialByCustomer _JITCallCompMatlDataTP MaterialByCustomer Customer Mat.
ExternalJITCallNumber _JITCallHeaderDataTP ExternalJITCallNumber Ext. JIT Call Number
ShipToParty _JITCallHeaderDataTP ShipToParty Ship-To Party (obsolete)
JITReferenceTypeLevel
_JITCallCompMatlDataTP _JITCallCompMatlDataTP
_JITCallHeaderDataTP _JITCallHeaderDataTP
_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_JITCallRefTextMatTP.
-- 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 I_JITCallRefTextMatTP AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITRefType,
  JITRefType AS JITRefTypeForEdit,
  JITRefText,
  _JITCallCompMatlDataTP.ExtCompGrpNumber AS ExtCompGrpNumber,
  _JITCallCompMatlDataTP.MaterialByCustomer AS MaterialByCustomer,
  _JITCallHeaderDataTP.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITCallHeaderDataTP.ShipToParty AS ShipToParty,
  cast('3' as njit_ref_level_type) AS JITReferenceTypeLevel
FROM I_JITCallRefTextBasic
LEFT OUTER JOIN I_JITCallCompMatlDataTP AS _JITCallCompMatlDataTP ON InternalJITCallNumber = _JITCallCompMatlDataTP.InternalJITCallNumber AND CompGrpNumber = _JITCallCompMatlDataTP.CompGrpNumber AND JITCallItemNumber = _JITCallCompMatlDataTP.JITCallItemNumber  -- association [1..1]
LEFT OUTER JOIN I_JITCallHeaderDataTP AS _JITCallHeaderDataTP ON InternalJITCallNumber = _JITCallHeaderDataTP.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON shiptoparty = _Customer.Customer  -- association [0..1]
;

Learn More