I_JITOutbCallsBOMTP

DDL: I_JITOUTBCALLSBOMTP SQL: IJITCALLBOMTP Type: view TRANSACTIONAL
15 Fields 4 Data Sources

Transactional View for BOM Explosion

I_JITOutbCallsBOMTP is a Transactional CDS View that provides data about "Transactional View for BOM Explosion" in SAP S/4HANA. It reads from 4 data sources (I_BillOfMaterialHeader, I_BillOfMaterialItem, I_JITControlCycle, njit_bom_link) and exposes 15 fields with key fields BillOfMaterial, Material, Plant, JITControlCycle, ProdOrderIssueLocation.

Data Sources (4)

SourceAliasJoin Type
I_BillOfMaterialHeader _BillOfMaterialHeader from
I_BillOfMaterialItem _BillOfMaterialItem inner
I_JITControlCycle _JITControlCycle inner
njit_bom_link _njit_bom_link inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IJITCALLBOMTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transactional View for BOM Explosion view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial I_BillOfMaterialHeader BillOfMaterial BOM
KEY Material I_BillOfMaterialHeader Material Vehicle Model
KEY Plant I_BillOfMaterialHeader Plant Valuation Area
KEY JITControlCycle I_JITControlCycle JITControlCycle Control Cycle
KEY ProdOrderIssueLocation I_BillOfMaterialItem ProdOrderIssueLocation StorageLocation
KEY BillOfMaterialComponent I_BillOfMaterialItem BillOfMaterialComponent Component
KEY BillOfMaterialItemNumber I_BillOfMaterialItem BillOfMaterialItemNumber Item
JITControlCycleCategory I_JITControlCycle JITControlCycleCategory Ctrl Cycle Cat.
JITCtrlCycLifeCycSts I_JITControlCycle JITCtrlCycLifeCycSts Lifecycle Status
BillOfMaterialVariant I_BillOfMaterialHeader BillOfMaterialVariant AlternativeBOM
SalesOrder I_BillOfMaterialHeader SalesOrder SD Document
SalesOrderItem I_BillOfMaterialHeader SalesOrderItem Sales Order Item
BillOfMaterialItemQuantity I_BillOfMaterialItem BillOfMaterialItemQuantity Quantity
BillOfMaterialItemUnit I_BillOfMaterialItem BillOfMaterialItemUnit Component UoM
ProductionSupplyArea I_BillOfMaterialItem ProductionSupplyArea Supply Area

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_JITOutbCallsBOMTP.
-- 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: IJITCALLBOMTP

CREATE VIEW I_JITOutbCallsBOMTP AS
SELECT
  _BillOfMaterialHeader.BillOfMaterial AS BillOfMaterial,
  _BillOfMaterialHeader.Material AS Material,
  _BillOfMaterialHeader.Plant AS Plant,
  _JITControlCycle.JITControlCycle AS JITControlCycle,
  _BillOfMaterialItem.ProdOrderIssueLocation AS ProdOrderIssueLocation,
  _BillOfMaterialItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  _BillOfMaterialItem.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  _JITControlCycle.JITControlCycleCategory AS JITControlCycleCategory,
  _JITControlCycle.JITCtrlCycLifeCycSts AS JITCtrlCycLifeCycSts,
  _BillOfMaterialHeader.BillOfMaterialVariant AS BillOfMaterialVariant,
  _BillOfMaterialHeader.SalesOrder AS SalesOrder,
  _BillOfMaterialHeader.SalesOrderItem AS SalesOrderItem,
  _BillOfMaterialItem.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  _BillOfMaterialItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  _BillOfMaterialItem.ProductionSupplyArea AS ProductionSupplyArea
FROM I_BillOfMaterialHeader AS _BillOfMaterialHeader
INNER JOIN I_JITControlCycle AS _JITControlCycle ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillOfMaterialItem AS _BillOfMaterialItem ON /* join condition not captured in parsed metadata */
INNER JOIN njit_bom_link AS _njit_bom_link ON /* join condition not captured in parsed metadata */
;

Learn More