R_JITOutbCallComponentTP

DDL: R_JITOUTBCALLCOMPONENTTP Type: view_entity TRANSACTIONAL Package: RAP_LE_NJIT_OUTBCALL

JIT Outbound Call Component Material

R_JITOutbCallComponentTP is a Transactional CDS View that provides data about "JIT Outbound Call Component Material" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallComponent) and exposes 25 fields with key field JITCallComponentUUID. It has 7 associations to related views. Part of development package RAP_LE_NJIT_OUTBCALL.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallComponent I_JITOutbCallComponent from

Associations (7)

CardinalityTargetAliasCondition
[1..1] R_JITOutboundCallTP _JITOutboundCallTP $projection.JITHeaderUUID = _JITOutboundCallTP.JITHeaderUUID
[1..1] I_Product _ProductCompMatl $projection.Material = _ProductCompMatl.Product
[0..1] I_JITInternalStatus _JITInternalStatus $projection.JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus
[0..1] I_JITStockTransferSts _JITStockTransferSts $projection.JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts
[1..1] I_UnitOfMeasure _UnitOfMeasure $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure
[0..*] R_JITOutbCallCompRefDetTP _JITOutbCallCompRefTxtTP
[0..*] R_JITOutbCallCompDocRefTP _JITOutbCallCompDocRefTP

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label JIT Outbound Call Component Material view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.ignorePropagatedAnnotations true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY JITCallComponentUUID JITCallComponentUUID NodeID
JITCallCompGrpUUID JITCallCompGrpUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
CompGrpNumber CompGrpNumber Component Group No.
JITCallItemNumber JITCallItemNumber Call Item Number
Material Material Vehicle Model
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
JITIntStatusUpdtdOnDteTme JITIntStatusUpdtdOnDteTme Int Status Updtd On
JITOutbStockTransferSts JITOutbStockTransferSts Stock Trnsfr Status
JITOutbTransferredQuantity JITOutbTransferredQuantity Transferred Qty
JITOutbMinimumQuantity JITOutbMinimumQuantity Minimum Qty
JITOutbPickedQuantity JITOutbPickedQuantity Picked Quantity
JITOutbOpenQuantity JITOutbOpenQuantity Open Qty
QuantityUnit QuantityUnit Unit of measure
_JITOutbCallComponentGroupTP _JITOutbCallComponentGroupTP
_JITOutboundCallTP _JITOutboundCallTP
_JITInternalStatus _JITInternalStatus
_JITStockTransferSts _JITStockTransferSts
_ProductCompMatl _ProductCompMatl
_UnitOfMeasure _UnitOfMeasure
_JITOutbCallCompRefTxtTP _JITOutbCallCompRefTxtTP
_JITOutbCallCompDocRefTP _JITOutbCallCompDocRefTP

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 R_JITOutbCallComponentTP.
-- 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 R_JITOutbCallComponentTP AS
SELECT
  JITCallComponentUUID,
  JITCallCompGrpUUID,
  JITHeaderUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  Material,
  RequestedQuantity,
  ActualDeliveredQuantity,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOnDteTme,
  JITOutbStockTransferSts,
  JITOutbTransferredQuantity,
  JITOutbMinimumQuantity,
  JITOutbPickedQuantity,
  JITOutbOpenQuantity,
  QuantityUnit
FROM I_JITOutbCallComponent
LEFT OUTER JOIN R_JITOutboundCallTP AS _JITOutboundCallTP ON JITHeaderUUID = _JITOutboundCallTP.JITHeaderUUID  -- association [1..1]
LEFT OUTER JOIN I_Product AS _ProductCompMatl ON Material = _ProductCompMatl.Product  -- association [1..1]
LEFT OUTER JOIN I_JITInternalStatus AS _JITInternalStatus ON JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_JITStockTransferSts AS _JITStockTransferSts ON JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN R_JITOutbCallCompRefDetTP AS _JITOutbCallCompRefTxtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_JITOutbCallCompDocRefTP AS _JITOutbCallCompDocRefTP ON /* condition not available in parsed metadata */  -- association [0..*]
;