C_SchedgAgrmtPartner

DDL: C_SCHEDGAGRMTPARTNER SQL: CSCHAGRMTPARTNER Type: view CONSUMPTION Package: ODATA_MM_SCHD_MAINTAIN
30 Fields 1 Data Sources 1 Associations

Scheduling Agreement Partner

C_SchedgAgrmtPartner is a Consumption CDS View that provides data about "Scheduling Agreement Partner" in SAP S/4HANA. It reads from 1 data source (I_SchedgAgrmtPartnWD) and exposes 30 fields with key fields PartnerCounter, PartnerFunction, Plant, SupplierSubrange, PurchasingOrganization. It has 1 association to related views. Part of development package ODATA_MM_SCHD_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_SchedgAgrmtPartnWD Partner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_Schedgagrmthdr _SchedgagrmthdrWithDraft _SchedgagrmthdrWithDraft.SchedulingAgreement = $projection.SchedulingAgreement

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CSCHAGRMTPARTNER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Scheduling Agreement Partner view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
UI.headerInfo.typeName Partner view
UI.headerInfo.typeNamePlural Partners view
UI.headerInfo.title.value PartnerFunction view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY PartnerCounter I_SchedgAgrmtPartnWD PartnerCounter Partner counter
KEY PartnerFunction I_SchedgAgrmtPartnWD PartnerFunction Partner Functn
KEY Plant I_SchedgAgrmtPartnWD Plant Valuation Area
KEY SupplierSubrange I_SchedgAgrmtPartnWD SupplierSubrange Suppl. Subrange
KEY PurchasingOrganization I_SchedgAgrmtPartnWD PurchasingOrganization Purchasing Organization
KEY SchedulingAgreementItem I_SchedgAgrmtPartnWD SchedulingAgreementItem Schedule Item Number
KEY SchedulingAgreement I_SchedgAgrmtPartnWD SchedulingAgreement Scheduling Agreement
PartnerCounterForEdit I_SchedgAgrmtPartnWD PartnerCounterForEdit Partner counter
PurchasingOrgForEdit I_SchedgAgrmtPartnWD PurchasingOrgForEdit Purchasing Organization
PartnerFunctionForEdit I_SchedgAgrmtPartnWD PartnerFunctionForEdit Partner Funct.
SchedgAgrmtPartner I_SchedgAgrmtPartnWD SchedgAgrmtPartner
SchedgAgrmtPartnerName I_SchedgAgrmtPartnWD SchedgAgrmtPartnerName
SchedgAgrmtCategory I_SchedgAgrmtPartnWD SchedgAgrmtCategory
SchedgAgrmtType I_SchedgAgrmtPartnWD SchedgAgrmtType
CreatedByUser I_SchedgAgrmtPartnWD CreatedByUser User Name
CreationDate I_SchedgAgrmtPartnWD CreationDate Time Stamp
Supplier I_SchedgAgrmtPartnWD Supplier Supplier
SupplierContact I_SchedgAgrmtPartnWD SupplierContact Contact Person
PersonWorkAgreement I_SchedgAgrmtPartnWD PersonWorkAgreement Personnel No.
DefaultPartner I_SchedgAgrmtPartnWD DefaultPartner Default Partner
PurchasingGroup _SchedgagrmthdrWithDraft PurchasingGroup Purchasing Group
PurchasingDocumentType _SchedgagrmthdrWithDraft PurchasingDocumentType RFQ Type
_PersonWorkAgreement _PersonWorkAgreement
_PartnerFunction _PartnerFunction
_PartnerFunctionText _PartnerFunctionText
_Plant _Plant
_PurchasingOrganization _PurchasingOrganization
_Supplier _Supplier
_SupplierContact _SupplierContact
_SchedgagrmthdrWithDraft _SchedgagrmthdrWithDraft

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_SchedgAgrmtPartner.
-- 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: CSCHAGRMTPARTNER

CREATE VIEW C_SchedgAgrmtPartner AS
SELECT
  Partner.PartnerCounter AS PartnerCounter,
  Partner.PartnerFunction AS PartnerFunction,
  Partner.Plant AS Plant,
  Partner.SupplierSubrange AS SupplierSubrange,
  Partner.PurchasingOrganization AS PurchasingOrganization,
  Partner.SchedulingAgreementItem AS SchedulingAgreementItem,
  Partner.SchedulingAgreement AS SchedulingAgreement,
  Partner.PartnerCounterForEdit AS PartnerCounterForEdit,
  Partner.PurchasingOrgForEdit AS PurchasingOrgForEdit,
  Partner.PartnerFunctionForEdit AS PartnerFunctionForEdit,
  Partner.SchedgAgrmtPartner AS SchedgAgrmtPartner,
  Partner.SchedgAgrmtPartnerName AS SchedgAgrmtPartnerName,
  Partner.SchedgAgrmtCategory AS SchedgAgrmtCategory,
  Partner.SchedgAgrmtType AS SchedgAgrmtType,
  Partner.CreatedByUser AS CreatedByUser,
  Partner.CreationDate AS CreationDate,
  Partner.Supplier AS Supplier,
  Partner.SupplierContact AS SupplierContact,
  Partner.PersonWorkAgreement AS PersonWorkAgreement,
  Partner.DefaultPartner AS DefaultPartner,
  _SchedgagrmthdrWithDraft.PurchasingGroup AS PurchasingGroup,
  _SchedgagrmthdrWithDraft.PurchasingDocumentType AS PurchasingDocumentType
FROM I_SchedgAgrmtPartnWD AS Partner
LEFT OUTER JOIN C_Schedgagrmthdr AS _SchedgagrmthdrWithDraft ON _SchedgagrmthdrWithDraft.SchedulingAgreement = SchedulingAgreement  -- association [1..1]
;

Learn More