I_SchedgAgrmtRelDocScLiAPI01

DDL: I_SCHEDGAGRMTRELDOCSCLIAPI01 SQL: ISARELDOCSLAPI01 Type: view COMPOSITE
18 Fields 1 Data Sources 3 Associations

SchedLine in Rel Doc of Pur Schedg Agrmt

I_SchedgAgrmtRelDocScLiAPI01 (Composite)

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

Sourcing & Procurement

I_SchedgAgrmtRelDocScLiAPI01 is a Composite CDS View that provides data about "SchedLine in Rel Doc of Pur Schedg Agrmt" in SAP S/4HANA. It reads from 1 data source (I_SchedgAgrmtRelDocSchedLine) and exposes 18 fields with key fields SchedulingAgreement, SchedulingAgreementItem, SchedulingAgreementReleaseType, SchedulingAgreementRelease, ScheduleLine. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Purchase Scheduling Agreements
StatusReleased
Purpose
This CDS view provides general information about the schedule line in the release document of the purchase scheduling agreement. This CDS view provides the prerequisites for answering the following business questions: What is the associated purchase scheduling agreement? What is the item number of the associated purchase scheduling agreement? What is the schedule line number of the release document of the purchase scheduling agreement? What is the release type of the purchase scheduling agreement? What is the release code of the purchase scheduling agreement?

Prerequisites
You must have a role based on the SAP_BR_PURCHASER business role template.

Structure
Object types This view relates to the following SAP object types: I_SchedgAgrmtRelDocScLiAPI01

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-OA-CON
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides general information about the schedule line in the release document of the purchase scheduling agreement.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the associated purchase scheduling agreement?</p></li> <li><p>What is the item number of the associated purchase scheduling agreement?</p></li> <li><p>What is the schedule line number of the release document of the purchase scheduling agreement?</p></li> <li><p>What is the release type of the purchase scheduling agreement?</p></li> <li><p>What is the release code of the purchase scheduling agreement?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SchedgAgrmtRelDocSchedLine I_SchedgAgrmtRelDocSchedLine from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SchedgagrmthdrApi01 _SchedgAgrmtHdrAPI01 $projection.SchedulingAgreement = _SchedgAgrmtHdrAPI01.SchedulingAgreement
[1..1] I_SchedgAgrmtItmApi01 _SchedgAgrmtItmAPI01 $projection.SchedulingAgreement = _SchedgAgrmtItmAPI01.SchedulingAgreement and $projection.SchedulingAgreementItem = _SchedgAgrmtItmAPI01.SchedulingAgreementItem
[1..1] I_SchedgAgrmtReleaseDocAPI01 _SchedgAgrmtReleaseDocAPI01 $projection.SchedulingAgreement = _SchedgAgrmtReleaseDocAPI01.SchedulingAgreement and $projection.SchedulingAgreementItem = _SchedgAgrmtReleaseDocAPI01.SchedulingAgreementItem and $projection.SchedulingAgreementReleaseType = _SchedgAgrmtReleaseDocAPI01.SchedulingAgreementReleaseType and $projection.SchedulingAgreementRelease = _SchedgAgrmtReleaseDocAPI01.ReleaseCode

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISARELDOCSLAPI01 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label SchedLine in Rel Doc of Pur Schedg Agrmt view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement SchedulingAgreement Purchasing Document Number
KEY SchedulingAgreementItem SchedulingAgreementItem Item Number of Purchasing Document
KEY SchedulingAgreementReleaseType SchedulingAgreementReleaseType Scheduling agreement release type
KEY SchedulingAgreementRelease SchedulingAgreementRelease Release Number
KEY ScheduleLine ScheduleLine Delivery Schedule Line Counter
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Item Delivery Date
ScheduleLineDeliveryTime ScheduleLineDeliveryTime Delivery Date Time-Spot
ScheduledQuantity ScheduledQuantity Scheduled Quantity
SchedgLineType SchedgLineType Schedule line type (backlog, immed. requirement, forecast)
BOMExplosion BOMExplosion BOM explosion number
SourceOfCreation SourceOfCreation Creation indicator (purchase requisition/schedule lines)
PrevDelivQtyOfScheduleLine PrevDelivQtyOfScheduleLine Previous Quantity (Delivery Schedule Lines)
ReceivedQuantity ReceivedQuantity Quantity of Goods Received
DelivDateCategory DelivDateCategory Category of delivery date
OrderQuantityUnit _SchedgAgrmtReleaseDocAPI01 OrderQuantityUnit Purchase Order Unit of Measure
_SchedgAgrmtHdrAPI01 _SchedgAgrmtHdrAPI01
_SchedgAgrmtItmAPI01 _SchedgAgrmtItmAPI01
_SchedgAgrmtReleaseDocAPI01 _SchedgAgrmtReleaseDocAPI01

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_SchedgAgrmtRelDocScLiAPI01.
-- 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: ISARELDOCSLAPI01

CREATE VIEW I_SchedgAgrmtRelDocScLiAPI01 AS
SELECT
  SchedulingAgreement,
  SchedulingAgreementItem,
  SchedulingAgreementReleaseType,
  SchedulingAgreementRelease,
  ScheduleLine,
  ScheduleLineDeliveryDate,
  ScheduleLineDeliveryTime,
  ScheduledQuantity,
  SchedgLineType,
  BOMExplosion,
  SourceOfCreation,
  PrevDelivQtyOfScheduleLine,
  ReceivedQuantity,
  DelivDateCategory,
  _SchedgAgrmtReleaseDocAPI01.OrderQuantityUnit AS OrderQuantityUnit
FROM I_SchedgAgrmtRelDocSchedLine
LEFT OUTER JOIN I_SchedgagrmthdrApi01 AS _SchedgAgrmtHdrAPI01 ON SchedulingAgreement = _SchedgAgrmtHdrAPI01.SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtItmApi01 AS _SchedgAgrmtItmAPI01 ON SchedulingAgreement = _SchedgAgrmtItmAPI01.SchedulingAgreement AND SchedulingAgreementItem = _SchedgAgrmtItmAPI01.SchedulingAgreementItem  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtReleaseDocAPI01 AS _SchedgAgrmtReleaseDocAPI01 ON SchedulingAgreement = _SchedgAgrmtReleaseDocAPI01.SchedulingAgreement AND SchedulingAgreementItem = _SchedgAgrmtReleaseDocAPI01.SchedulingAgreementItem AND SchedulingAgreementReleaseType = _SchedgAgrmtReleaseDocAPI01.SchedulingAgreementReleaseType AND SchedulingAgreementRelease = _SchedgAgrmtReleaseDocAPI01.ReleaseCode  -- association [1..1]
;

Learn More