I_JITOutbBOM

DDL: I_JITOUTBBOM SQL: IJITOUTBOM Type: view BASIC
5 Fields 2 Data Sources

Bill of material details for JIT

I_JITOutbBOM is a Basic CDS View that provides data about "Bill of material details for JIT" in SAP S/4HANA. It reads from 2 data sources (stpo, mast) and exposes 5 fields with key fields Material, Plant, BOMItem, ItemCounter.

Data Sources (2)

SourceAliasJoin Type
stpo _bom_item inner
mast mast from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IJITOUTBOM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bill of material details for JIT view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Material matnr Vehicle Model
KEY Plant werks Receiving Plant
KEY BOMItem stlkn Single-Character Flag
KEY ItemCounter stpoz Counter
BillOfMaterialComponent stpo idnrk Component

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_JITOutbBOM.
-- 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: IJITOUTBOM

CREATE VIEW I_JITOutbBOM AS
SELECT
  matnr AS Material,
  werks AS Plant,
  stlkn AS BOMItem,
  stpoz AS ItemCounter,
  _bom_item.idnrk AS BillOfMaterialComponent
FROM mast
INNER JOIN stpo AS _bom_item ON /* join condition not captured in parsed metadata */
;

Learn More