I_JITOutbSchedAgrmt

DDL: I_JITOUTBSCHEDAGRMT SQL: IJITSCHDAGRMT Type: view COMPOSITE Package: NJIT_MODEL_O
8 Fields 1 Data Sources 1 Associations

Composite View for JIT Schedule Agrmt

I_JITOutbSchedAgrmt is a Composite CDS View that provides data about "Composite View for JIT Schedule Agrmt" in SAP S/4HANA. It reads from 1 data source (I_SchedgAgrmtItm) and exposes 8 fields with key fields SchedulingAgreement, SchedulingAgreementItem. It has 1 association to related views. Part of development package NJIT_MODEL_O.

Data Sources (1)

SourceAliasJoin Type
I_SchedgAgrmtItm I_SchedgAgrmtItm from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Schedgagrmthdr _SchedgagrmtHdr $projection.SchedulingAgreement = _SchedgagrmtHdr.SchedulingAgreement

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IJITSCHDAGRMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.type #INHERITED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey SchedulingAgreement view
EndUserText.label Composite View for JIT Schedule Agrmt view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement SchedulingAgreement Scheduling Agreement
KEY SchedulingAgreementItem SchedulingAgreementItem Schedule Item Number
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
ManufacturerMaterial ManufacturerMaterial MPN: Material
SupplierConfirmationControlKey ConfirmationControl Conf. Control
JITOutbSchedgAgrmtSupplier _SchedgagrmtHdr Supplier Supplier
_Supplier _SchedgagrmtHdr _Supplier

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_JITOutbSchedAgrmt.
-- 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: IJITSCHDAGRMT

CREATE VIEW I_JITOutbSchedAgrmt AS
SELECT
  SchedulingAgreement,
  SchedulingAgreementItem,
  Plant,
  StorageLocation,
  ManufacturerMaterial,
  ConfirmationControl AS SupplierConfirmationControlKey,
  _SchedgagrmtHdr.Supplier AS JITOutbSchedgAgrmtSupplier,
  _SchedgagrmtHdr._Supplier AS _Supplier
FROM I_SchedgAgrmtItm
LEFT OUTER JOIN I_Schedgagrmthdr AS _SchedgagrmtHdr ON SchedulingAgreement = _SchedgagrmtHdr.SchedulingAgreement  -- association [0..1]
;

Learn More