C_JITOutbControlCycSchedgAgrmt

DDL: C_JITOUTBCONTROLCYCSCHEDGAGRMT SQL: CCSCHAGRM Type: view CONSUMPTION
9 Fields

Get Scheduling agreement for Control cycle

C_JITOutbControlCycSchedgAgrmt is a Consumption CDS View that provides data about "Get Scheduling agreement for Control cycle" in SAP S/4HANA.

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCSCHAGRM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Get Scheduling agreement for Control cycle view
UI.headerInfo.typeName Scheduling Agreement view
UI.headerInfo.typeNamePlural Scheduling Agreements view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY JITControlCycle _JITOutbSchAgmnt JITControlCycle Control Cycle
KEY Plant _JITOutbSchAgmnt Plant Plant
KEY JITCtrlCycHdrMatlSchedgAgrmt _JITOutbSchAgmnt SchedulingAgreement Scheduling Agreement
KEY ActiveSchedgAgrmtItm _JITOutbSchAgmnt SchedulingAgreementItem Schedule Item Number
KEY JITCtrlCycBOMSchedgAgrmt _JITOutbSchAgmnt SchedulingAgreement Scheduling Agreement
KEY ActiveSchedulingAgreementItem _JITOutbSchAgmnt SchedulingAgreementItem Schedule Item Number
Material _JITOutbSchAgmnt Material Material
SchedulingAgreement _JITOutbSchAgmnt SchedulingAgreement Scheduling Agreement
SchedulingAgreementItem _JITOutbSchAgmnt SchedulingAgreementItem Scheduling Agreement Item Number

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_JITOutbControlCycSchedgAgrmt.
-- 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: CCSCHAGRM

CREATE VIEW C_JITOutbControlCycSchedgAgrmt AS
SELECT
  _JITOutbSchAgmnt.JITControlCycle AS JITControlCycle,
  _JITOutbSchAgmnt.Plant AS Plant,
  _JITOutbSchAgmnt.SchedulingAgreement AS JITCtrlCycHdrMatlSchedgAgrmt,
  _JITOutbSchAgmnt.SchedulingAgreementItem AS ActiveSchedgAgrmtItm,
  _JITOutbSchAgmnt.SchedulingAgreement AS JITCtrlCycBOMSchedgAgrmt,
  _JITOutbSchAgmnt.SchedulingAgreementItem AS ActiveSchedulingAgreementItem,
  _JITOutbSchAgmnt.Material AS Material,
  _JITOutbSchAgmnt.SchedulingAgreement AS SchedulingAgreement,
  _JITOutbSchAgmnt.SchedulingAgreementItem AS SchedulingAgreementItem
;

Learn More