I_JITOutbCtrlCycBOMSchedgAgrmt

DDL: I_JITOUTBCTRLCYCBOMSCHEDGAGRMT SQL: IBOMSCHDAG Type: view COMPOSITE Package: NJIT_MODEL_O
17 Fields 3 Data Sources

Control Cycle BOM Scheduling agreement

I_JITOutbCtrlCycBOMSchedgAgrmt is a Composite CDS View that provides data about "Control Cycle BOM Scheduling agreement" in SAP S/4HANA. It reads from 3 data sources (I_BillOfMaterialHeader, I_BillOfMaterialItem, I_JITControlCycle) and exposes 17 fields with key fields BillOfMaterial, Material, Plant, JITControlCycle, ProdOrderIssueLocation. Part of development package NJIT_MODEL_O.

Data Sources (3)

SourceAliasJoin Type
I_BillOfMaterialHeader _BillOfMaterialHeader from
I_BillOfMaterialItem _BillOfMaterialItem inner
I_JITControlCycle _JITControlCycle inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IBOMSCHDAG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Control Cycle BOM Scheduling agreement view

Fields (17)

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
KEY SchedulingAgreement _JITOutbSchedAgrmt SchedulingAgreement Scheduling Agreement
KEY SchedulingAgreementItem _JITOutbSchedAgrmt SchedulingAgreementItem Schedule Item Number
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_JITOutbCtrlCycBOMSchedgAgrmt.
-- 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: IBOMSCHDAG

CREATE VIEW I_JITOutbCtrlCycBOMSchedgAgrmt 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,
  _JITOutbSchedAgrmt.SchedulingAgreement AS SchedulingAgreement,
  _JITOutbSchedAgrmt.SchedulingAgreementItem AS SchedulingAgreementItem,
  _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 */
;

Learn More