P_JITOutBOMData

DDL: P_JITOUTBOMDATA SQL: PJITBOMDATA Type: view TRANSACTIONAL
15 Fields 3 Data Sources

Bill of material data

P_JITOutBOMData is a Transactional CDS View that provides data about "Bill of material data" in SAP S/4HANA. It reads from 3 data sources (I_JITControlCycle, I_MaterialBOMLink, stpo) and exposes 15 fields with key fields BillOfMaterial, Material, Plant, JITControlCycle, BillOfMaterialComponent.

Data Sources (3)

SourceAliasJoin Type
I_JITControlCycle _JITControlCycle inner
I_MaterialBOMLink _mast from
stpo _stpo inner

Annotations (13)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PJITBOMDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Bill of material data view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial I_MaterialBOMLink BillOfMaterial BOM
KEY Material I_MaterialBOMLink Material Vehicle Model
KEY Plant I_MaterialBOMLink Plant Valuation Area
KEY JITControlCycle I_JITControlCycle JITControlCycle Control Cycle
KEY BillOfMaterialComponent stpo idnrk Component
KEY ProdOrderIssueLocation stpo lgort Sublocation
KEY BillOfMaterialVariant I_MaterialBOMLink BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVariantUsage I_MaterialBOMLink BillOfMaterialVariantUsage Usage
KEY BillOfMaterialItemNumber stpo posnr WBS Element
ProductionSupplyArea I_JITControlCycle ProductionSupplyArea Supply Area
QuantityUnit I_JITControlCycle QuantityUnit Unit of measure
JITControlCycleCategory I_JITControlCycle JITControlCycleCategory Ctrl Cycle Cat.
JITCtrlCycLifeCycSts I_JITControlCycle JITCtrlCycLifeCycSts Lifecycle Status
BillOfMaterialItemUnit stpo meins Valuation Unit
BillOfMaterialItemQuantity stpo menge WarrCountValue

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 P_JITOutBOMData.
-- 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: PJITBOMDATA

CREATE VIEW P_JITOutBOMData AS
SELECT
  _mast.BillOfMaterial AS BillOfMaterial,
  _mast.Material AS Material,
  _mast.Plant AS Plant,
  _JITControlCycle.JITControlCycle AS JITControlCycle,
  _stpo.idnrk AS BillOfMaterialComponent,
  _stpo.lgort AS ProdOrderIssueLocation,
  _mast.BillOfMaterialVariant AS BillOfMaterialVariant,
  _mast.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _stpo.posnr AS BillOfMaterialItemNumber,
  _JITControlCycle.ProductionSupplyArea AS ProductionSupplyArea,
  _JITControlCycle.QuantityUnit AS QuantityUnit,
  _JITControlCycle.JITControlCycleCategory AS JITControlCycleCategory,
  _JITControlCycle.JITCtrlCycLifeCycSts AS JITCtrlCycLifeCycSts,
  _stpo.meins AS BillOfMaterialItemUnit,
  _stpo.menge AS BillOfMaterialItemQuantity
FROM I_MaterialBOMLink AS _mast
INNER JOIN stpo AS _stpo ON /* join condition not captured in parsed metadata */
INNER JOIN I_JITControlCycle AS _JITControlCycle ON /* join condition not captured in parsed metadata */
;

Learn More