C_JITOutbSqncCallCompMatlTP

DDL: C_JITOUTBSQNCCALLCOMPMATLTP SQL: CJITOUTBSEQCMTP Type: view CONSUMPTION
31 Fields 1 Data Sources 4 Associations

Consumption view for JIS Call Comp Matl

C_JITOutbSqncCallCompMatlTP is a Consumption CDS View that provides data about "Consumption view for JIS Call Comp Matl" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallsCompMatlDataTP) and exposes 31 fields with key fields RootDraftKey, InternalJITCallNumber, CompGrpNumber, JITCallItemNumber. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallsCompMatlDataTP _JITOutbCallsCompMatl from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_JITInternalStatus _JITInternalStatus $projection.JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus
[1..1] C_JITOutbSqncCallCompGrpTP _JITOutbCallsCompGrpDataTP $projection.InternalJITCallNumber = _JITOutbCallsCompGrpDataTP.InternalJITCallNumber
[0..1] I_JITStockTransferSts _JITStockTransferSts $projection.JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts
[0..1] I_JITOutbCallTolerance _JITOutbCallTolerance $projection.JITOutbToleranceFlag = _JITOutbCallTolerance.JITOutbToleranceFlag

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CJITOUTBSEQCMTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED 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.updateEnabled true view
ObjectModel.transactionalProcessingDelegated true view
Metadata.allowExtensions true view
Search.searchable true view
UI.headerInfo.typeName Component view
UI.headerInfo.typeNamePlural Components view
EndUserText.label Consumption view for JIS Call Comp Matl view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY RootDraftKey RootDraftKey NodeID
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group No.
KEY JITCallItemNumber JITCallItemNumber Call Item Number
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
JITInternalStatusText
JITIntProcessingStatusType _JITInternalStatus JITIntProcessingStatusType
JITOutbStockTransferSts JITOutbStockTransferSts Stock Trnsfr Status
JITStockTransferStsText
JITCallItemNumberForEdit JITCallItemNumberForEdit Call Item Number
Material Material Vehicle Model
ProductName ProductName Description
RequestedQuantity RequestedQuantity Requested Quantity
RequestedQuantityForEdit RequestedQuantityForEdit
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
QuantityUnit QuantityUnit Unit of measure
JITOutbMinimumQuantity JITOutbMinimumQuantity Minimum Qty
JITOutbTransferredQuantity JITOutbTransferredQuantity Transferred Qty
ShortfallQuantity ShortfallQuantity
JITOutbPickedQuantity JITOutbPickedQuantity Picked Quantity
JITOutbOpenQuantity JITOutbOpenQuantity Open Qty
JITIntStatusUpdtdOnDteTme JITIntStatusUpdtdOnDteTme Int Status Updtd On
IsErrorMsgNotToBeLogged IsErrorMsgNotToBeLogged Exculde Error
JITComponentIsReordered JITComponentIsReordered Usage Type
UnitOfMeasureNumberOfDecimals UnitOfMeasureNumberOfDecimals
_JITOutbCallsCompGrpDataTP _JITOutbCallsCompGrpDataTP
_JITInternalStatus _JITInternalStatus
_JITStockTransferSts _JITStockTransferSts
JITOutbToleranceFlagText
JITOutbToleranceFlag JITOutbToleranceFlag JIT Tolerance Threshold
_UnitOfMeasure _UnitOfMeasure

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_JITOutbSqncCallCompMatlTP.
-- 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: CJITOUTBSEQCMTP

CREATE VIEW C_JITOutbSqncCallCompMatlTP AS
SELECT
  RootDraftKey,
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITIntProcessingStatus,
  _JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  _JITInternalStatus.JITIntProcessingStatusType AS JITIntProcessingStatusType,
  JITOutbStockTransferSts,
  _JITStockTransferSts._Text[1: Language = $session.system_language].JITStockTransferStsText AS JITStockTransferStsText,
  JITCallItemNumberForEdit,
  Material,
  ProductName,
  RequestedQuantity,
  RequestedQuantityForEdit,
  ActualDeliveredQuantity,
  QuantityUnit,
  JITOutbMinimumQuantity,
  JITOutbTransferredQuantity,
  ShortfallQuantity,
  JITOutbPickedQuantity,
  JITOutbOpenQuantity,
  JITIntStatusUpdtdOnDteTme,
  IsErrorMsgNotToBeLogged,
  JITComponentIsReordered,
  UnitOfMeasureNumberOfDecimals,
  _JITOutbCallTolerance._Text[1: Language=$session.system_language].JITOutbToleranceFlagText AS JITOutbToleranceFlagText,
  JITOutbToleranceFlag
FROM I_JITOutbCallsCompMatlDataTP AS _JITOutbCallsCompMatl
LEFT OUTER JOIN I_JITInternalStatus AS _JITInternalStatus ON JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSqncCallCompGrpTP AS _JITOutbCallsCompGrpDataTP ON InternalJITCallNumber = _JITOutbCallsCompGrpDataTP.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_JITStockTransferSts AS _JITStockTransferSts ON JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts  -- association [0..1]
LEFT OUTER JOIN I_JITOutbCallTolerance AS _JITOutbCallTolerance ON JITOutbToleranceFlag = _JITOutbCallTolerance.JITOutbToleranceFlag  -- association [0..1]
;

Learn More