C_JITOutbSchedgAgrmtTP

DDL: C_JITOUTBSCHEDGAGRMTTP SQL: CJITCOMPSCHAGD Type: view CONSUMPTION Package: NJIT_MODEL_O
7 Fields 1 Data Sources 1 Associations

Consumption Schedule Agreement View

C_JITOutbSchedgAgrmtTP is a Consumption CDS View that provides data about "Consumption Schedule Agreement View" in SAP S/4HANA. It reads from 1 data source (I_JITOutbSchedgAgrmtTP) and exposes 7 fields with key fields JITControlCycle, Plant, Material, ProductionSupplyArea. It has 1 association to related views. Part of development package NJIT_MODEL_O.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbSchedgAgrmtTP I_JITOutbSchedgAgrmtTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_JITControlCycleTP _JITControlCycleTP $projection.JITControlCycle = _JITControlCycleTP.JITControlCycle

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CJITCOMPSCHAGD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption Schedule Agreement View view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey JITControlCycle view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
UI.headerInfo.typeName Scheduling Agreement view
UI.headerInfo.typeNamePlural Scheduling Agreements view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY JITControlCycle JITControlCycle Control Cycle
KEY Plant Plant Valuation Area
KEY Material Material Component Material
KEY ProductionSupplyArea ProductionSupplyArea Supply Area
SchedulingAgreement SchedulingAgreement Scheduling Agreement
SchedulingAgreementItem SchedulingAgreementItem Scheduling Agreement Item
_JITControlCycleTP _JITControlCycleTP

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_JITOutbSchedgAgrmtTP.
-- 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: CJITCOMPSCHAGD

CREATE VIEW C_JITOutbSchedgAgrmtTP AS
SELECT
  JITControlCycle,
  Plant,
  Material,
  ProductionSupplyArea,
  SchedulingAgreement,
  SchedulingAgreementItem
FROM I_JITOutbSchedgAgrmtTP
LEFT OUTER JOIN C_JITControlCycleTP AS _JITControlCycleTP ON JITControlCycle = _JITControlCycleTP.JITControlCycle  -- association [1..1]
;

Learn More