C_MRPScheduleAgreement

DDL: C_MRPSCHEDULEAGREEMENT Type: view_entity CONSUMPTION
32 Fields 1 Data Sources 2 Associations

MRP Schedule Agreement

C_MRPScheduleAgreement is a Consumption CDS View that provides data about "MRP Schedule Agreement" in SAP S/4HANA. It reads from 1 data source (I_PurgDocScheduleLine) and exposes 32 fields with key fields SchedulingAgreement, SchedulingAgreementItem, ScheduleLine. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurgDocScheduleLine Scheduleagmtscheduleline from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PurchasingDocument _PurchasingDocument $projection.SchedulingAgreement = _PurchasingDocument.PurchasingDocument
[0..1] I_SchedgAgrmtItm _ScheduleAgreementItem $projection.SchedulingAgreement = _ScheduleAgreementItem.SchedulingAgreement and $projection.SchedulingAgreementItem = _ScheduleAgreementItem.SchedulingAgreementItem

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label MRP Schedule Agreement view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement PurchasingDocument Purchasing Document
KEY SchedulingAgreementItem PurchasingDocumentItem Purchasing Doc. Item
KEY ScheduleLine ScheduleLine Schedule Line
DelivDateCategory DelivDateCategory Delivery Date
ItemLastTransmissionDate _ScheduleAgreementItem ItemLastTransmissionDate
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
RoughGoodsReceiptQty RoughGoodsReceiptQty Delivered
SchedAgrmtAgreedCumQty _ScheduleAgreementItem SchedAgrmtAgreedCumQty
SchedAgrmtCumQtyReconcileDate _ScheduleAgreementItem SchedAgrmtCumQtyReconcileDate
SchedLineSemiFirmOrderInDays _ScheduleAgreementItem SchedLineSemiFirmOrderInDays
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
ScheduleAgreementHasReleaseDoc _PurchasingDocument ScheduleAgreementHasReleaseDoc
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
ScheduleLineDeliveryTime ScheduleLineDeliveryTime Time
ScheduleLineFirmOrderInDays _ScheduleAgreementItem ScheduleLineFirmOrderInDays
ScheduleLineOpenQuantity ScheduleLineOpenQuantity SchLineOpenQuan
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
Supplier _PurchasingDocument Supplier Supplier
SupplierName
SupplierFullName
SupplierPhoneNumber _PurchasingDocument SupplierPhoneNumber Telephone
EmailAddress
OrderQuantityUnit _ScheduleAgreementItem OrderQuantityUnit Sales Unit
DocumentDate
PurchasingOrganization
PurchasingOrganizationName
PurchasingGroup
PurchasingGroupName
PurchasingGroupPhoneNumber
PurchasingGroupEmailAddress
_Supplier _PurchasingDocument _Supplier

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_MRPScheduleAgreement.
-- 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.

CREATE VIEW C_MRPScheduleAgreement AS
SELECT
  PurchasingDocument AS SchedulingAgreement,
  PurchasingDocumentItem AS SchedulingAgreementItem,
  ScheduleLine,
  DelivDateCategory,
  _ScheduleAgreementItem.ItemLastTransmissionDate AS ItemLastTransmissionDate,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  RoughGoodsReceiptQty,
  _ScheduleAgreementItem.SchedAgrmtAgreedCumQty AS SchedAgrmtAgreedCumQty,
  _ScheduleAgreementItem.SchedAgrmtCumQtyReconcileDate AS SchedAgrmtCumQtyReconcileDate,
  _ScheduleAgreementItem.SchedLineSemiFirmOrderInDays AS SchedLineSemiFirmOrderInDays,
  SchedLineStscDeliveryDate,
  _PurchasingDocument.ScheduleAgreementHasReleaseDoc AS ScheduleAgreementHasReleaseDoc,
  ScheduleLineDeliveryDate,
  ScheduleLineDeliveryTime,
  _ScheduleAgreementItem.ScheduleLineFirmOrderInDays AS ScheduleLineFirmOrderInDays,
  ScheduleLineOpenQuantity,
  ScheduleLineOrderQuantity,
  _PurchasingDocument.Supplier AS Supplier,
  _PurchasingDocument._Supplier.BPSupplierName AS SupplierName,
  _PurchasingDocument._Supplier.BPSupplierFullName AS SupplierFullName,
  _PurchasingDocument.SupplierPhoneNumber AS SupplierPhoneNumber,
  _PurchasingDocument._Supplier._StandardAddress._DefaultEmailAddress.EmailAddress AS EmailAddress,
  _ScheduleAgreementItem.OrderQuantityUnit AS OrderQuantityUnit,
  _ScheduleAgreementItem._Schedgagrmthdr.PurchasingDocumentOrderDate AS DocumentDate,
  _ScheduleAgreementItem._Schedgagrmthdr.PurchasingOrganization AS PurchasingOrganization,
  _ScheduleAgreementItem._Schedgagrmthdr._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _ScheduleAgreementItem._Schedgagrmthdr.PurchasingGroup AS PurchasingGroup,
  _ScheduleAgreementItem._Schedgagrmthdr._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _ScheduleAgreementItem._Schedgagrmthdr._PurchasingGroup.PurchasingGroupPhoneNumber AS PurchasingGroupPhoneNumber,
  _ScheduleAgreementItem._Schedgagrmthdr._PurchasingGroup.EmailAddress AS PurchasingGroupEmailAddress,
  _PurchasingDocument._Supplier AS _Supplier
FROM I_PurgDocScheduleLine AS Scheduleagmtscheduleline
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON SchedulingAgreement = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_SchedgAgrmtItm AS _ScheduleAgreementItem ON SchedulingAgreement = _ScheduleAgreementItem.SchedulingAgreement AND SchedulingAgreementItem = _ScheduleAgreementItem.SchedulingAgreementItem  -- association [0..1]
;

Learn More