C_SchedgAgrmtSubcontrgComp

DDL: C_SCHEDGAGRMTSUBCONTRGCOMP SQL: CSAGSUBCOMP Type: view CONSUMPTION Package: ODATA_MM_SCHD_MAINTAIN
18 Fields 1 Data Sources 5 Associations

Consumption View for SA Subcontracting Components

C_SchedgAgrmtSubcontrgComp is a Consumption CDS View that provides data about "Consumption View for SA Subcontracting Components" in SAP S/4HANA. It reads from 1 data source (I_SchedgAgrmtSubcontrgCompTP) and exposes 18 fields with key fields SchedulingAgreement, SchedulingAgreementItem, ScheduleLine, ReservationItem, RecordType. It has 5 associations to related views. Part of development package ODATA_MM_SCHD_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_SchedgAgrmtSubcontrgCompTP I_SchedgAgrmtSubcontrgCompTP from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_Schedgagrmthdr _SchedgAgrmtHdrWithDraft $projection.SchedulingAgreement = _SchedgAgrmtHdrWithDraft.SchedulingAgreement
[1..1] C_Schedgagrmtitm _SchedgAgrmtItmWithDraft $projection.SchedulingAgreement = _SchedgAgrmtItmWithDraft.SchedulingAgreement and $projection.SchedulingAgreementItem = _SchedgAgrmtItmWithDraft.SchedulingAgreementItem
[1..1] C_Schedgline _SchedgLineWithDraft $projection.SchedulingAgreement = _SchedgLineWithDraft.SchedulingAgreement and $projection.SchedulingAgreementItem = _SchedgLineWithDraft.SchedulingAgreementItem and $projection.ScheduleLine = _SchedgLineWithDraft.ScheduleLine
[0..1] C_MM_MaterialValueHelp _MaterialValueHelp $projection.Plant = _MaterialValueHelp.Plant and $projection.Material = _MaterialValueHelp.Material
[0..1] C_MM_PlantBasicValueHelp _PlantBasicValueHelp $projection.Plant = _PlantBasicValueHelp.Plant

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CSAGSUBCOMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
UI.headerInfo.typeName Scheduling Agreement Subcontracting view
UI.headerInfo.typeNamePlural Scheduling Agreement Subcontracting view
UI.headerInfo.title.value ReservationItem view
UI.headerInfo.description.value ReservationItem view
Search.searchable true view
VDM.viewType #CONSUMPTION view
EndUserText.label Consumption View for SA Subcontracting Components view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement SchedulingAgreement Scheduling Agreement
KEY SchedulingAgreementItem SchedulingAgreementItem Schedule Item Number
KEY ScheduleLine ScheduleLine Schedule Line
KEY ReservationItem ReservationItem Reservation Item
KEY RecordType RecordType Reservation Record Type
Material Material Vehicle Model
BOMItemDescription _MaterialValueHelp MaterialName Material Description
RequirementDate RequirementDate Requirement Date
EntryUnit EntryUnit Unit of Entry
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
Plant Plant Valuation Area
MaterialName _MaterialValueHelp MaterialName Material Description
_SchedgAgrmtHdrWithDraft _SchedgAgrmtHdrWithDraft
_SchedgAgrmtItmWithDraft _SchedgAgrmtItmWithDraft
_SchedgLineWithDraft _SchedgLineWithDraft
_PlantBasicValueHelp _PlantBasicValueHelp
_MaterialValueHelp _MaterialValueHelp
_EntryUnit _EntryUnit

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_SchedgAgrmtSubcontrgComp.
-- 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: CSAGSUBCOMP

CREATE VIEW C_SchedgAgrmtSubcontrgComp AS
SELECT
  SchedulingAgreement,
  SchedulingAgreementItem,
  ScheduleLine,
  ReservationItem,
  RecordType,
  Material,
  _MaterialValueHelp.MaterialName AS BOMItemDescription,
  RequirementDate,
  EntryUnit,
  QuantityInEntryUnit,
  Plant,
  _MaterialValueHelp.MaterialName AS MaterialName
FROM I_SchedgAgrmtSubcontrgCompTP
LEFT OUTER JOIN C_Schedgagrmthdr AS _SchedgAgrmtHdrWithDraft ON SchedulingAgreement = _SchedgAgrmtHdrWithDraft.SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN C_Schedgagrmtitm AS _SchedgAgrmtItmWithDraft ON SchedulingAgreement = _SchedgAgrmtItmWithDraft.SchedulingAgreement AND SchedulingAgreementItem = _SchedgAgrmtItmWithDraft.SchedulingAgreementItem  -- association [1..1]
LEFT OUTER JOIN C_Schedgline AS _SchedgLineWithDraft ON SchedulingAgreement = _SchedgLineWithDraft.SchedulingAgreement AND SchedulingAgreementItem = _SchedgLineWithDraft.SchedulingAgreementItem AND ScheduleLine = _SchedgLineWithDraft.ScheduleLine  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON Plant = _MaterialValueHelp.Plant AND Material = _MaterialValueHelp.Material  -- association [0..1]
LEFT OUTER JOIN C_MM_PlantBasicValueHelp AS _PlantBasicValueHelp ON Plant = _PlantBasicValueHelp.Plant  -- association [0..1]
;

Learn More