C_JITOutbSchedgAgrmtVH

DDL: C_JITOUTBSCHEDGAGRMTVH SQL: CJITOBSCAGVH Type: view CONSUMPTION Package: NJIT_MODEL_O
8 Fields 2 Data Sources

Scheduling agreement F4 help

C_JITOutbSchedgAgrmtVH is a Consumption CDS View that provides data about "Scheduling agreement F4 help" in SAP S/4HANA. It reads from 2 data sources (I_JITOutbSchedAgrmt, I_ProductionSupplyArea) and exposes 8 fields with key fields Plant, StorageLocation, ProductionSupplyArea, Material, SchedulingAgreement. Part of development package NJIT_MODEL_O.

Data Sources (2)

SourceAliasJoin Type
I_JITOutbSchedAgrmt _JITOutbSchedAgrmt inner
I_ProductionSupplyArea _ProductionSupplyArea from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CJITOBSCAGVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Scheduling agreement F4 help view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Plant I_ProductionSupplyArea Plant Plant
KEY StorageLocation I_ProductionSupplyArea StorageLocation Storage Location
KEY ProductionSupplyArea I_ProductionSupplyArea ProductionSupplyArea Production Supply Area
KEY Material I_JITOutbSchedAgrmt ManufacturerMaterial Material
KEY SchedulingAgreement I_JITOutbSchedAgrmt SchedulingAgreement Scheduling Agreement
KEY SchedulingAgreementItem I_JITOutbSchedAgrmt SchedulingAgreementItem Scheduling Agreement Item
JITOutbSchedgAgrmtSupplier I_JITOutbSchedAgrmt JITOutbSchedgAgrmtSupplier Scheduling Agreement Supplier
_Supplier I_JITOutbSchedAgrmt _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 C_JITOutbSchedgAgrmtVH.
-- 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: CJITOBSCAGVH

CREATE VIEW C_JITOutbSchedgAgrmtVH AS
SELECT
  _ProductionSupplyArea.Plant AS Plant,
  _ProductionSupplyArea.StorageLocation AS StorageLocation,
  _ProductionSupplyArea.ProductionSupplyArea AS ProductionSupplyArea,
  _JITOutbSchedAgrmt.ManufacturerMaterial AS Material,
  _JITOutbSchedAgrmt.SchedulingAgreement AS SchedulingAgreement,
  _JITOutbSchedAgrmt.SchedulingAgreementItem AS SchedulingAgreementItem,
  _JITOutbSchedAgrmt.JITOutbSchedgAgrmtSupplier AS JITOutbSchedgAgrmtSupplier,
  _JITOutbSchedAgrmt._Supplier AS _Supplier
FROM I_ProductionSupplyArea AS _ProductionSupplyArea
INNER JOIN I_JITOutbSchedAgrmt AS _JITOutbSchedAgrmt ON /* join condition not captured in parsed metadata */
;

Learn More