C_SchedAgrmtSchedLineDEX

DDL: C_SCHEDAGRMTSCHEDLINEDEX SQL: CMMSCHEDGLINEDEX Type: view CONSUMPTION
25 Fields 1 Data Sources

Data Extraction for Scheduling Agreement Releases

C_SchedAgrmtSchedLineDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

PurSchedgAgrmtItmScheduleLine · Sourcing & Procurement

C_SchedAgrmtSchedLineDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Scheduling Agreement Releases" in SAP S/4HANA. It reads from 1 data source (I_SchedglineApi01) and exposes 25 fields with key fields SchedulingAgreement, SchedulingAgreementItem, ScheduleLine.

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-ANA
CapabilitiesData Source for Data Extraction
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>These CDS views are app independent, and are available for all external consumers who want to extract the data to SAP Business Warehouse (SAP BW) or other external systems.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SchedglineApi01 I_SchedglineApi01 from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CMMSCHEDGLINEDEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Data Extraction for Scheduling Agreement Releases view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.supportedCapabilities #EXTRACTION_DATA_SOURCE view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement SchedulingAgreement Purchasing Document Number
KEY SchedulingAgreementItem SchedulingAgreementItem Item Number of Purchasing Document
KEY ScheduleLine ScheduleLine Delivery Schedule Line Counter
DelivDateCategory DelivDateCategory Category of delivery date
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Item Delivery Date
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Statistics-Relevant Delivery Date
ScheduleLineDeliveryTime ScheduleLineDeliveryTime Delivery Date Time-Spot
OrderQuantityUnit OrderQuantityUnit Purchase Order Unit of Measure
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Quantity
PurchaseRequisition PurchaseRequisition Purchase Requisition Number
PurchaseRequisitionItem PurchaseRequisitionItem Item number of purchase requisition
RoughGoodsReceiptQty RoughGoodsReceiptQty Quantity of Goods Received
ScheduleLineIsFixed ScheduleLineIsFixed Schedule Line is "Fixed"
PurchasingSchdLnNrOfReminders NoOfRemindersOfScheduleLine No. of Reminders/Expediters for Schedule Line
PrevDelivQtyOfScheduleLine PrevDelivQtyOfScheduleLine Previous Quantity (Delivery Schedule Lines)
SourceOfCreation SourceOfCreation Creation indicator (purchase requisition/schedule lines)
PurchasingDocumentOrderDate _SchedgagrmthdrApi01 PurchasingDocumentOrderDate Purchasing Document Date
PurchasingGroup _SchedgagrmthdrApi01 PurchasingGroup Purchasing Group
PurchasingOrganization _SchedgagrmthdrApi01 PurchasingOrganization Purchasing Organization
StorageLocation _SchedgAgrmtItmApi01 StorageLocation Storage Location
Supplier _SchedgagrmthdrApi01 Supplier Supplier
Material _SchedgAgrmtItmApi01 Material Material Number
PurchasingDocumentOrigin _SchedgagrmthdrApi01 PurchasingDocumentOrigin Status of Purchasing Document
Plant _SchedgAgrmtItmApi01 Plant Valuation Area
PurchasingDocumentType _SchedgagrmthdrApi01 PurchasingDocumentType Purchasing Document Type

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_SchedAgrmtSchedLineDEX.
-- 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: CMMSCHEDGLINEDEX

CREATE VIEW C_SchedAgrmtSchedLineDEX AS
SELECT
  SchedulingAgreement,
  SchedulingAgreementItem,
  ScheduleLine,
  DelivDateCategory,
  ScheduleLineDeliveryDate,
  SchedLineStscDeliveryDate,
  ScheduleLineDeliveryTime,
  OrderQuantityUnit,
  ScheduleLineOrderQuantity,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  RoughGoodsReceiptQty,
  ScheduleLineIsFixed,
  NoOfRemindersOfScheduleLine AS PurchasingSchdLnNrOfReminders,
  PrevDelivQtyOfScheduleLine,
  SourceOfCreation,
  _SchedgagrmthdrApi01.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  _SchedgagrmthdrApi01.PurchasingGroup AS PurchasingGroup,
  _SchedgagrmthdrApi01.PurchasingOrganization AS PurchasingOrganization,
  _SchedgAgrmtItmApi01.StorageLocation AS StorageLocation,
  _SchedgagrmthdrApi01.Supplier AS Supplier,
  _SchedgAgrmtItmApi01.Material AS Material,
  _SchedgagrmthdrApi01.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  _SchedgAgrmtItmApi01.Plant AS Plant,
  _SchedgagrmthdrApi01.PurchasingDocumentType AS PurchasingDocumentType
FROM I_SchedglineApi01
;

Learn More