P_SchedgAgrmt

DDL: P_SCHEDGAGRMT SQL: PMMSCHEDAGRMT Type: view CONSUMPTION
24 Fields 3 Data Sources

Scheduling Agreement Details

P_SchedgAgrmt is a Consumption CDS View that provides data about "Scheduling Agreement Details" in SAP S/4HANA. It reads from 3 data sources (I_Schedgline, I_Schedgagrmthdr, I_SchedgAgrmtItm) and exposes 24 fields with key fields SchedulingAgreement, SchedulingAgreementItem, ScheduleLine, PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (3)

SourceAliasJoin Type
I_Schedgline ScheduleLine inner
I_Schedgagrmthdr SchedulingAgrmtHeader inner
I_SchedgAgrmtItm SchedulingAgrmtItem from

Parameters (3)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat
P_DisplayCurrency displaycurrency

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMMSCHEDAGRMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Scheduling Agreement Details view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement I_SchedgAgrmtItm SchedulingAgreement Scheduling Agreement
KEY SchedulingAgreementItem I_SchedgAgrmtItm SchedulingAgreementItem Schedule Item Number
KEY ScheduleLine I_Schedgline ScheduleLine Schedule Line
KEY PurchaseRequisition I_SchedgAgrmtItm PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_SchedgAgrmtItm PurchaseRequisitionItem Requisn. item
PurchasingDocumentCategory I_SchedgAgrmtItm PurchasingDocumentCategory Doc. Category
PurchasingDocumentItemCategory I_SchedgAgrmtItm PurchasingDocumentItemCategory Item Category
StorageLocation I_SchedgAgrmtItm StorageLocation StorageLocation
PurchaseOrderDate I_SchedgAgrmtItm PurchaseRequisition Requisition
Supplier I_Schedgagrmthdr Supplier Supplier
PurchasingGroup I_Schedgagrmthdr PurchasingGroup Purchasing Group
PurchasingOrganization I_Schedgagrmthdr PurchasingOrganization Purchasing Organization
PurchasingDocumentType I_Schedgagrmthdr PurchasingDocumentType RFQ Type
Material I_SchedgAgrmtItm Material Vehicle Model
MaterialGroup I_SchedgAgrmtItm MaterialGroup Product Group
Plant I_SchedgAgrmtItm Plant Valuation Area
PurgDocHdrCompanyCode I_Schedgagrmthdr CompanyCode Receiver Company Code
CompanyCode I_SchedgAgrmtItm CompanyCode Receiver Company Code
PurchaseOrderType
ProductType I_SchedgAgrmtItm ProductType Product Type Group
DisplayCurrency
Currency I_Schedgagrmthdr DocumentCurrency Document Currency
ScheduleLineDeliveryDate I_Schedgline ScheduleLineDeliveryDate Delivery Date
_Schedgagrmthdr _Schedgagrmthdr

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 P_SchedgAgrmt.
-- 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: PMMSCHEDAGRMT
-- Parameters: P_StartDate : bedat, P_EndDate : bedat, P_DisplayCurrency : displaycurrency

CREATE VIEW P_SchedgAgrmt AS
SELECT
  SchedulingAgrmtItem.SchedulingAgreement AS SchedulingAgreement,
  SchedulingAgrmtItem.SchedulingAgreementItem AS SchedulingAgreementItem,
  ScheduleLine.ScheduleLine AS ScheduleLine,
  SchedulingAgrmtItem.PurchaseRequisition AS PurchaseRequisition,
  SchedulingAgrmtItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  SchedulingAgrmtItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  SchedulingAgrmtItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  SchedulingAgrmtItem.StorageLocation AS StorageLocation,
  SchedulingAgrmtItem.PurchaseRequisition AS PurchaseOrderDate,
  SchedulingAgrmtHeader.Supplier AS Supplier,
  SchedulingAgrmtHeader.PurchasingGroup AS PurchasingGroup,
  SchedulingAgrmtHeader.PurchasingOrganization AS PurchasingOrganization,
  SchedulingAgrmtHeader.PurchasingDocumentType AS PurchasingDocumentType,
  SchedulingAgrmtItem.Material AS Material,
  SchedulingAgrmtItem.MaterialGroup AS MaterialGroup,
  SchedulingAgrmtItem.Plant AS Plant,
  SchedulingAgrmtHeader.CompanyCode AS PurgDocHdrCompanyCode,
  SchedulingAgrmtItem.CompanyCode AS CompanyCode,
  cast( '' as esart ) AS PurchaseOrderType,
  SchedulingAgrmtItem.ProductType AS ProductType,
  cast( :P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  SchedulingAgrmtHeader.DocumentCurrency AS Currency,
  ScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate
FROM I_SchedgAgrmtItm AS SchedulingAgrmtItem
INNER JOIN I_Schedgagrmthdr AS SchedulingAgrmtHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_Schedgline AS ScheduleLine ON /* join condition not captured in parsed metadata */
;

Learn More