What is I_SchdAgrSchdLnEnhcdAPI01 in SAP S/4HANA?

I_SchdAgrSchdLnEnhcdAPI01 is a composite CDS view in SAP S/4HANA. Sched Agreement with Schedule Line Details It contains 98 fields.

Which tables does I_SchdAgrSchdLnEnhcdAPI01 read from?

I_SchdAgrSchdLnEnhcdAPI01 reads data from: I_SchedgAgrmtSchedLineEnhcd.

What VDM layer is I_SchdAgrSchdLnEnhcdAPI01?

I_SchdAgrSchdLnEnhcdAPI01 is classified as a Composite view that combines data from multiple basic views.

I_SchdAgrSchdLnEnhcdAPI01

DDL: I_SCHDAGRSCHDLNENHCDAPI01 SQL: ISAENHDAPI01 Type: view COMPOSITE Package: ODATA_MM_ANALYTICS

98 Fields 1 Data Sources

Sched Agreement with Schedule Line Details

I_SchdAgrSchdLnEnhcdAPI01 (Composite)

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

Sourcing & Procurement

I_SchdAgrSchdLnEnhcdAPI01 is a Composite CDS View that provides data about "Sched Agreement with Schedule Line Details" in SAP S/4HANA. It reads from 1 data source (I_SchedgAgrmtSchedLineEnhcd) and exposes 98 fields with key fields SchedulingAgreement, SchedulingAgreementItem, ScheduleLine, ProcurementHubSourceSystem. Part of development package ODATA_MM_ANALYTICS.

SAP API Hub

Category	Composite
State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-ANA-2CL
Capabilities	Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Sourcing and Procurement for SAP S/4HANA Cloud Public Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_SchedgAgrmtSchedLineEnhcd	I_SchedgAgrmtSchedLineEnhcd	from

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	ISAENHDAPI01	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
EndUserText.label	Sched Agreement with Schedule Line Details	view

Fields (98)

Key	Field	Source Field	Description
KEY	SchedulingAgreement	SchedulingAgreement	Purchasing Document Number
KEY	SchedulingAgreementItem	SchedulingAgreementItem	Item Number of Purchasing Document
KEY	ScheduleLine	ScheduleLine	Schedule Line Number
KEY	ProcurementHubSourceSystem	ProcurementHubSourceSystem	Connected System ID
	ScheduleLineUniqueID	ScheduleLineUniqueID	Schedule line id(Concatenation of EBELN, EBELP, EETEN)
	PurchasingOrganization	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	PurchasingGroup	Purchasing Group
	CompanyCode	CompanyCode	Receiver Company Code
	Supplier	Supplier	Account Number of Supplier
	Plant	Plant	Valuation Area
	Material	Material	Material Number
	MaterialGroup	MaterialGroup	Material Group
	ServicePerformer	ServicePerformer	Service Performer
	DocumentCurrency	DocumentCurrency	Document Currency
	AnalyticalReportingCurrency	AnalyticalReportingCurrency	Reporting Currency 1
	AnalyticalReportingCurrency2	AnalyticalReportingCurrency2	Reporting Currency 2
	CompanyCodeCurrency	CompanyCodeCurrency	Company Currency
	AnlytlCrcyExchangeRateStatus	AnlytlCrcyExchangeRateStatus	Reporting Currency
	NetPriceInReportingCurrency	NetPriceInReportingCurrency	Net Price: Reporting Currency 1
	NetPriceInReportingCurrency2	NetPriceInReportingCurrency2	Net Price: Reporting Currency 2
	NetPriceAmount	NetPriceAmount	Net Price in Purchasing Document (in Document Currency)
	NetPriceInCompanyCodeCrcy	NetPriceInCompanyCodeCrcy	Net Price: Company Currency
	NetAmountInReportingCurrency	NetAmountInReportingCurrency	Net Amount (in Reporting Currency 1)
	NetAmountInReportingCurrency2	NetAmountInReportingCurrency2	Net Amount (in Reporting Currency 2)
	NetAmount	NetAmount	Net Order Value in PO Currency
	NetAmountInCoCodeCurrency	NetAmountInCoCodeCurrency	Net Amount in Company Currency
	OpenAmountInReportingCurrency	OpenAmountInReportingCurrency	Open Amount (in Reporting Currency 1)
	OpenAmountInReportingCurrency2	OpenAmountInReportingCurrency2	Open Amount (in Reporting Currency 2)
	OpenAmountInDocumentCurrency	OpenAmountInDocumentCurrency	Open Amount (in Document Currency)
	OpenAmountInCompanyCodeCrcy	OpenAmountInCompanyCodeCrcy	Open Amount (in Company Currency)
	ScheduleLineOpenQuantity	ScheduleLineOpenQuantity	SchLineOpenQuan
	OrderQuantityUnit	OrderQuantityUnit	Purchase Order Unit of Measure
	IsCompletelyDelivered	IsCompletelyDelivered	"Delivery Completed" Indicator
	GoodsReceiptIsExpected	GoodsReceiptIsExpected	Goods Receipt Indicator
	PurchasingDocumentDeletionCode	PurchasingDocumentDeletionCode	Asset class marked for deletion
	PurchasingCompletenessStatus	PurchasingCompletenessStatus	Purchase order not yet complete
	PurchasingDocumentCategory	PurchasingDocumentCategory	Purchasing Document Category
	PurchasingDocumentType	PurchasingDocumentType	Order Type (Purchasing)
	PurchasingDocumentItemCategory	PurchasingDocumentItemCategory	Item category in purchasing document
	AccountAssignmentCategory	AccountAssignmentCategory	Account Assignment Category
	CreationDate	CreationDate	Last Changed On
	PurchasingDocumentOrigin	PurchasingDocumentOrigin	Status of Purchasing Document
	CreatedByUser	CreatedByUser	Name of Person Responsible for Creating the Object
	LastChangeDateTime	LastChangeDateTime	Change Time Stamp
	PurchasingProcessingStatus	PurchasingProcessingStatus	Purchasing Document Processing State
	PurchasingDocumentOrderDate	PurchasingDocumentOrderDate	Purchasing Document Date
	PurchasingDocumentIsAged	PurchasingDocumentIsAged	Document is aged
	OrderQuantity	OrderQuantity	Purchase Order Quantity
	PurgDocOrderQuantityUnit	PurgDocOrderQuantityUnit	Purchasing Document Order Qty Unit
	ProductTypeCode	ProductTypeCode	Product Type Group
	ReleaseIsNotCompleted	ReleaseIsNotCompleted	Release Not Yet Completely Effected
	IsReturnsItem	IsReturnsItem	Returns Item
	PurgDocSchdLnHasNextDelivery	PurgDocSchdLnHasNextDelivery	Indicator for Next Delivery Line
	StorageLocation	StorageLocation	Storage Location
	ScheduleLineDeliveryDate	ScheduleLineDeliveryDate	Item Delivery Date
	SchedLineStscDeliveryDate	SchedLineStscDeliveryDate	Statistics-Relevant Delivery Date
	ScheduleLineOrderDate	ScheduleLineOrderDate	Order date of schedule line
	OriglPurgDocSchedLineDelivDte	OriglPurgDocSchedLineDelivDte	Original Delivery Date
	OriglPurgDocItemStstclDelivDte	OriglPurgDocItemStstclDelivDte	Original Statistical Delivery Date
	DelivDateCategory	DelivDateCategory	Category of delivery date
	ScheduleLineOrderQuantity	ScheduleLineOrderQuantity	Scheduled Quantity
	PrevDelivQtyOfScheduleLine	PrevDelivQtyOfScheduleLine	Previous Quantity (Delivery Schedule Lines)
	GoodsReceiptQuantity	GoodsReceiptQuantity	Quantity of Goods Received
	ScheduleLineIssuedQuantity	ScheduleLineIssuedQuantity	Issued Quantity
	ScheduleLineDeliveryTime	ScheduleLineDeliveryTime	Delivery Date Time-Spot
	PurchaseRequisition	PurchaseRequisition	Purchase Requisition Number
	PurchaseRequisitionItem	PurchaseRequisitionItem	Item Number of Purchase Requisition
	SourceOfCreation	SourceOfCreation	Creation indicator (purchase requisition/schedule lines)
	PurchasingSchdLnNrOfReminders	PurchasingSchdLnNrOfReminders	No. of Reminders/Expediters for Schedule Line
	SchedulingAgreementReleaseType	SchedulingAgreementReleaseType	Scheduling agreement release type
	ScheduleLineCommittedQuantity	ScheduleLineCommittedQuantity	Committed Quantity
	ProductAvailabilityDate	ProductAvailabilityDate	Material Staging/Availability Date
	ProductAvailabilityTime	ProductAvailabilityTime	Material Staging Time (Local, Relating to a Plant)
	LoadingDate	LoadingDate	Loading Date
	LoadingTime	LoadingTime	Loading Time (Local Time Relating to a Shipping Point)
	TransportationPlanningDate	TransportationPlanningDate	Transportation Planning Date
	TransportationPlanningTime	TransportationPlanningTime	Transp. Planning Time (Local, Relating to a Shipping Point)
	GoodsIssueDate	GoodsIssueDate	Goods Issue Date CCD
	GoodsIssueTime	GoodsIssueTime	Time of Goods Issue (Local, Relating to a Plant)
	STOLatestPossibleGRDate	STOLatestPossibleGRDate	Goods Receipt End Date
	STOLatestPossibleGRTime	STOLatestPossibleGRTime	Goods Receipt End Time (Local, Relating to a Plant)
	RoughGoodsReceiptQty	RoughGoodsReceiptQty	Quantity of Goods Received
	PurchaseContractItem	PurchaseContractItem	Item Number of Principal Purchase Agreement
	PurchaseContract	PurchaseContract	Number of principal purchase agreement
	MultipleAcctAssgmtDistribution	MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment
	PurchaseOrderDate	PurchaseOrderDate	Purchasing Document Date
	OrderPriceUnitToOrderUnitNmrtr	OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit
	OrdPriceUnitToOrderUnitDnmntr	OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit
	NetPriceQuantity	NetPriceQuantity	Price Unit
	OrderPriceUnit	OrderPriceUnit	Order Price Unit (Purchasing)
	PerformancePeriodStartDate	PerformancePeriodStartDate	Start Date for Period of Performance
	PerformancePeriodEndDate	PerformancePeriodEndDate	End Date for Period of Performance
	SupplyingPlant	SupplyingPlant	Supplying (issuing) plant in case of stock transport order
	PurgDocItmAnlytsIndIsActv	PurgDocItmAnlytsIndIsActv	Dimension Indicator
	PurDocItmFirstGRPostingDate	PurDocItmFirstGRPostingDate	First Goods Receipt Date
	PurDocItmFinalGRPostingDate	PurDocItmFinalGRPostingDate	Final Goods Receipt Date
	OriglPurgDocItm1stGRPostgDte	OriglPurgDocItm1stGRPostgDte	Original First Good Receipt Posting Date
	OriglPurgDocItmFnlGRPostgDte	OriglPurgDocItmFnlGRPostgDte	Original Final Goods Receipt Posting Date

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 I_SchdAgrSchdLnEnhcdAPI01.
-- 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: ISAENHDAPI01

CREATE VIEW I_SchdAgrSchdLnEnhcdAPI01 AS
SELECT
  SchedulingAgreement,
  SchedulingAgreementItem,
  ScheduleLine,
  ProcurementHubSourceSystem,
  ScheduleLineUniqueID,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  Supplier,
  Plant,
  Material,
  MaterialGroup,
  ServicePerformer,
  DocumentCurrency,
  AnalyticalReportingCurrency,
  AnalyticalReportingCurrency2,
  CompanyCodeCurrency,
  AnlytlCrcyExchangeRateStatus,
  NetPriceInReportingCurrency,
  NetPriceInReportingCurrency2,
  NetPriceAmount,
  NetPriceInCompanyCodeCrcy,
  NetAmountInReportingCurrency,
  NetAmountInReportingCurrency2,
  NetAmount,
  NetAmountInCoCodeCurrency,
  OpenAmountInReportingCurrency,
  OpenAmountInReportingCurrency2,
  OpenAmountInDocumentCurrency,
  OpenAmountInCompanyCodeCrcy,
  ScheduleLineOpenQuantity,
  OrderQuantityUnit,
  IsCompletelyDelivered,
  GoodsReceiptIsExpected,
  PurchasingDocumentDeletionCode,
  PurchasingCompletenessStatus,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingDocumentItemCategory,
  AccountAssignmentCategory,
  CreationDate,
  PurchasingDocumentOrigin,
  CreatedByUser,
  LastChangeDateTime,
  PurchasingProcessingStatus,
  PurchasingDocumentOrderDate,
  PurchasingDocumentIsAged,
  OrderQuantity,
  PurgDocOrderQuantityUnit,
  ProductTypeCode,
  ReleaseIsNotCompleted,
  IsReturnsItem,
  PurgDocSchdLnHasNextDelivery,
  StorageLocation,
  ScheduleLineDeliveryDate,
  SchedLineStscDeliveryDate,
  ScheduleLineOrderDate,
  OriglPurgDocSchedLineDelivDte,
  OriglPurgDocItemStstclDelivDte,
  DelivDateCategory,
  ScheduleLineOrderQuantity,
  PrevDelivQtyOfScheduleLine,
  GoodsReceiptQuantity,
  ScheduleLineIssuedQuantity,
  ScheduleLineDeliveryTime,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SourceOfCreation,
  PurchasingSchdLnNrOfReminders,
  SchedulingAgreementReleaseType,
  ScheduleLineCommittedQuantity,
  ProductAvailabilityDate,
  ProductAvailabilityTime,
  LoadingDate,
  LoadingTime,
  TransportationPlanningDate,
  TransportationPlanningTime,
  GoodsIssueDate,
  GoodsIssueTime,
  STOLatestPossibleGRDate,
  STOLatestPossibleGRTime,
  RoughGoodsReceiptQty,
  PurchaseContractItem,
  PurchaseContract,
  MultipleAcctAssgmtDistribution,
  PurchaseOrderDate,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  NetPriceQuantity,
  OrderPriceUnit,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  SupplyingPlant,
  PurgDocItmAnlytsIndIsActv,
  PurDocItmFirstGRPostingDate,
  PurDocItmFinalGRPostingDate,
  OriglPurgDocItm1stGRPostgDte,
  OriglPurgDocItmFnlGRPostgDte
FROM I_SchedgAgrmtSchedLineEnhcd
;

Depth:

I_SchdAgrSchdLnEnhcdAPI01 view

I_SchedgAgrmtSchedLineEnhcd view

C_SchdAgrSchdLnEnhcdDEX view