I_SchedgAgrmtReleaseDocAPI01

DDL: I_SCHEDGAGRMTRELEASEDOCAPI01 SQL: ISARELDOCAPI01 Type: view COMPOSITE
24 Fields 1 Data Sources 3 Associations

Release Document of Pur Schedg Agrmt

I_SchedgAgrmtReleaseDocAPI01 (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_SchedgAgrmtReleaseDocAPI01 is a Composite CDS View that provides data about "Release Document of Pur Schedg Agrmt" in SAP S/4HANA. It reads from 1 data source (I_SchedgAgrmtReleaseDoc) and exposes 24 fields with key fields SchedulingAgreement, SchedulingAgreementItem, SchedulingAgreementReleaseType, ReleaseCode. 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 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 purchase scheduling agreement? What is the document type 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_SchedgAgrmtReleaseDocAPI01

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 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 purchase scheduling agreement?</p></li> <li><p>What is the document type 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_SchedgAgrmtReleaseDoc I_SchedgAgrmtReleaseDoc 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
[0..*] I_SchedgAgrmtRelDocScLiAPI01 _SchedgAgrmtRelDocScLiAPI01 $projection.SchedulingAgreement = _SchedgAgrmtRelDocScLiAPI01.SchedulingAgreement and $projection.SchedulingAgreementItem = _SchedgAgrmtRelDocScLiAPI01.SchedulingAgreementItem and $projection.SchedulingAgreementReleaseType = _SchedgAgrmtRelDocScLiAPI01.SchedulingAgreementReleaseType and $projection.ReleaseCode = _SchedgAgrmtRelDocScLiAPI01.SchedulingAgreementRelease

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISARELDOCAPI01 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Release Document 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 (24)

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 ReleaseCode ReleaseCode Release Number
SchedulingAgreementRelease SchedulingAgreementRelease Release Number
SchedgAgreementItemRelText SchedgAgreementItemRelText Scheduling Agreement Release Type Name
SchedgAgreementItemRelStatus SchedgAgreementItemRelStatus Scheduling Agreement Release Status Text
SchedgAgreementItemRelStsText SchedgAgreementItemRelStsText Scheduling Agreement Release Status Text
SchedgAgrmtReleaseCreationDate SchedgAgrmtReleaseCreationDate Date of Scheduling Agreement Release (Transmission Date)
SchedgAgrmtReleaseCreationTime SchedgAgrmtReleaseCreationTime Time
SchedgAgreementItemNextRelDate SchedgAgreementItemNextRelDate Next JIT Delivery Schedule Transmission
ProductionGoAheadPeriodEndDate ProductionGoAheadPeriodEndDate End of Production Go-Ahead Period
MaterialGoAheadPeriodEndDate MaterialGoAheadPeriodEndDate End of Material Go-Ahead Period
LastGoodsReceiptQuantity LastGoodsReceiptQuantity Quantity of Last Goods Receipt
LastGoodsReceiptDate LastGoodsReceiptDate Date of Last Goods Receipt
SchedgAgrmtRelTransmissionDate SchedgAgrmtRelTransmissionDate Date Release was Created
SchedgAgrmtRelTransmissionTime SchedgAgrmtRelTransmissionTime Time of Creation
OrderQuantityUnit OrderQuantityUnit Purchase Order Unit of Measure
IsSchedgAgreementItemReld IsSchedgAgreementItemReld Scheduling Agreement release status Criticality
InboundDeliveryNote InboundDeliveryNote Number of Delivery Note
SchedgAgrmtCumltvRcvdQty SchedgAgrmtCumltvRcvdQty Cumulative Received Quantity for Scheduling Agreement
_SchedgAgrmtHdrAPI01 _SchedgAgrmtHdrAPI01
_SchedgAgrmtItmAPI01 _SchedgAgrmtItmAPI01
_SchedgAgrmtRelDocScLiAPI01 _SchedgAgrmtRelDocScLiAPI01

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_SchedgAgrmtReleaseDocAPI01.
-- 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: ISARELDOCAPI01

CREATE VIEW I_SchedgAgrmtReleaseDocAPI01 AS
SELECT
  SchedulingAgreement,
  SchedulingAgreementItem,
  SchedulingAgreementReleaseType,
  ReleaseCode,
  SchedulingAgreementRelease,
  SchedgAgreementItemRelText,
  SchedgAgreementItemRelStatus,
  SchedgAgreementItemRelStsText,
  SchedgAgrmtReleaseCreationDate,
  SchedgAgrmtReleaseCreationTime,
  SchedgAgreementItemNextRelDate,
  ProductionGoAheadPeriodEndDate,
  MaterialGoAheadPeriodEndDate,
  LastGoodsReceiptQuantity,
  LastGoodsReceiptDate,
  SchedgAgrmtRelTransmissionDate,
  SchedgAgrmtRelTransmissionTime,
  OrderQuantityUnit,
  IsSchedgAgreementItemReld,
  InboundDeliveryNote,
  SchedgAgrmtCumltvRcvdQty
FROM I_SchedgAgrmtReleaseDoc
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_SchedgAgrmtRelDocScLiAPI01 AS _SchedgAgrmtRelDocScLiAPI01 ON SchedulingAgreement = _SchedgAgrmtRelDocScLiAPI01.SchedulingAgreement AND SchedulingAgreementItem = _SchedgAgrmtRelDocScLiAPI01.SchedulingAgreementItem AND SchedulingAgreementReleaseType = _SchedgAgrmtRelDocScLiAPI01.SchedulingAgreementReleaseType AND ReleaseCode = _SchedgAgrmtRelDocScLiAPI01.SchedulingAgreementRelease  -- association [0..*]
;

Learn More