What is C_SchedgAgrmtHdrObjPg in SAP S/4HANA?

C_SchedgAgrmtHdrObjPg is a consumption CDS view in SAP S/4HANA. Scheduling Agreement Header Object Page It contains 54 fields.

Which tables does C_SchedgAgrmtHdrObjPg read from?

C_SchedgAgrmtHdrObjPg reads data from: I_Schedgagrmthdr.

What VDM layer is C_SchedgAgrmtHdrObjPg?

C_SchedgAgrmtHdrObjPg is classified as a Consumption view optimized for specific business scenarios and reporting.

C_SchedgAgrmtHdrObjPg

DDL: C_SCHEDGAGRMTHDROBJPG SQL: CSCHHDRFS Type: view CONSUMPTION

54 Fields 1 Data Sources 7 Associations

Scheduling Agreement Header Object Page

C_SchedgAgrmtHdrObjPg is a Consumption CDS View that provides data about "Scheduling Agreement Header Object Page" in SAP S/4HANA. It reads from 1 data source (I_Schedgagrmthdr) and exposes 54 fields with key field SchedulingAgreement. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_Schedgagrmthdr	I_Schedgagrmthdr	from

Associations (7)

Cardinality	Target	Alias	Condition
[1..*]	C_SchedgAgrmtItmObjPg	_SchedgAgrmtItmObjPg	`_SchedgAgrmtItmObjPg.SchedulingAgreement = $projection.SchedulingAgreement`
[0..1]	C_MM_SupplierValueHelp	_SupplierValueHelp	`_SupplierValueHelp.Supplier = $projection.Supplier and _SupplierValueHelp.CompanyCode = $projection.CompanyCode`
[0..1]	C_PurchasingOrgValueHelp	_PurchasingOrganization	`_PurchasingOrganization.PurchasingOrganization = $projection.PurchasingOrganization`
[0..1]	C_MM_CompanyCodeValueHelp	_CompanyCode	`_CompanyCode.CompanyCode = $projection.CompanyCode`
[0..1]	C_PurchasingGroupValueHelp	_PurchasingGroup	`_PurchasingGroup.PurchasingGroup = $projection.PurchasingGroup`
[0..1]	I_PaymentTermsText	_PaymentTermsText	`_PaymentTermsText.PaymentTerms = $projection.PaymentTerms and _PaymentTermsText.Language = $projection.Language`
[0..*]	C_SchedgAgrmtFactSheetHdrText	_SchedgAgrmtFactSheetHdrText	`_SchedgAgrmtFactSheetHdrText.SchedulingAgreement = $projection.SchedulingAgreement`

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	CSCHHDRFS	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Scheduling Agreement Header Object Page	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.compositionRoot	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Search.searchable	true	view
UI.headerInfo.typeName	Purchase Scheduling Agreement	view
UI.headerInfo.typeNamePlural	Purchase Scheduling Agreements	view
UI.headerInfo.title.value	PurchasingDocumentTypeName	view
UI.headerInfo.description.value	SchedulingAgreement	view
UI.headerInfo.typeImageUrl	/sap/bc/ui5_ui5/sap/MM_SCHAGMT_MTS1/img/HeaderTitle.jpg	view

Fields (54)

Key	Field	Source Table	Source Field	Description
KEY	SchedulingAgreement	I_Schedgagrmthdr	SchedulingAgreement	Scheduling Agreement
	CompanyCode	I_Schedgagrmthdr	CompanyCode	Receiver Company Code
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	PurchasingDocumentCategory	I_Schedgagrmthdr	PurchasingDocumentCategory	Doc. Category
	PurchasingDocumentType	I_Schedgagrmthdr	PurchasingDocumentType	RFQ Type
	PurchasingDocumentTypeName	I_Schedgagrmthdr	PurchasingDocumentTypeName	Description
	CreatedByUser	I_Schedgagrmthdr	CreatedByUser	User Name
	CreatedByUserFullName	I_Schedgagrmthdr	CreatedByUserFullName	Created By(Full Name)
	CreationDate	I_Schedgagrmthdr	CreationDate	Time Stamp
	Language	I_Schedgagrmthdr	Language	Report Text Language
	PurchasingOrganization	I_Schedgagrmthdr	PurchasingOrganization	Purchasing Organization
	PurchasingOrganizationName	_PurchasingOrganization	PurchasingOrganizationName	Purch. Org. Name
	PurchasingGroup	I_Schedgagrmthdr	PurchasingGroup	Purchasing Group
	PurchasingGroupName	_PurchasingGroup	PurchasingGroupName	Purchasing Grp. Name
	IncotermsTransferLocation	I_Schedgagrmthdr	IncotermsTransferLocation	Incoterms 2
	PaymentTerms	I_Schedgagrmthdr	PaymentTerms	Pyt Terms
	PaymentTermsName	_PaymentTermsText	PaymentTermsName	Payment Terms Name
	CashDiscount2Days	I_Schedgagrmthdr	CashDiscount2Days	Days from Baseline Date for Payment
	CashDiscount1Percent	I_Schedgagrmthdr	CashDiscount1Percent	Disc. Percent 1
	CashDiscount1Days	I_Schedgagrmthdr	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Percent	I_Schedgagrmthdr	CashDiscount2Percent	Disc. Percent 2
	NetPaymentDays	I_Schedgagrmthdr	NetPaymentDays	Net Pmt Terms Period
	TargetAmount	I_Schedgagrmthdr	TargetAmount	Target Value
	DocumentCurrency	I_Schedgagrmthdr	DocumentCurrency	Document Currency
	ExchangeRateIsFixed	I_Schedgagrmthdr	ExchangeRateIsFixed	Fixed Exch.Rate
	IncotermsClassification	I_Schedgagrmthdr	IncotermsClassification	Incoterms
	IncotermsLocation1	I_Schedgagrmthdr	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	I_Schedgagrmthdr	IncotermsLocation2	Inco. Location2
	IncotermsVersion	I_Schedgagrmthdr	IncotermsVersion	Inco. Version
	PurchasingDocumentOrderDate	I_Schedgagrmthdr	PurchasingDocumentOrderDate	PO Date
	ScheduleAgreementHasReleaseDoc	I_Schedgagrmthdr	ScheduleAgreementHasReleaseDoc
	Supplier	I_Schedgagrmthdr	Supplier	Supplier
	SupplierAddressID	I_Schedgagrmthdr	SupplierAddressID	Address Number
	ValidityStartDate	I_Schedgagrmthdr	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_Schedgagrmthdr	ValidityEndDate	ValidTo
	PurchasingDocumentOrigin	I_Schedgagrmthdr	PurchasingDocumentOrigin	Status
	InvoicingParty	I_Schedgagrmthdr	InvoicingParty	Supplier
	SupplyingSupplier	I_Schedgagrmthdr	SupplyingSupplier	Goods Supplier
	VATRegistrationCountry	I_Schedgagrmthdr	VATRegistrationCountry	CtryRgnSlsTxNo.
	CompanyVATRegistration	I_Schedgagrmthdr	CompanyVATRegistration	VAT Registration No.
	SupplierName	_SupplierValueHelp	SupplierName	Supplier Name
	_SupplierValueHelp		_SupplierValueHelp
	_DocumentCurrency	I_Schedgagrmthdr	_DocumentCurrency
	_PurchasingOrganization		_PurchasingOrganization
	_CompanyCode		_CompanyCode
	_PurchasingGroup		_PurchasingGroup
	_Language		_Language
	_PurchasingDocumentCategory		_PurchasingDocumentCategory
	_PurchasingDocumentOrigin		_PurchasingDocumentOrigin
	_PaymentTermsText		_PaymentTermsText
	_SupplyingSupplier		_SupplyingSupplier
	_InvoicingParty		_InvoicingParty
	_SchedgAgrmtItmObjPg		_SchedgAgrmtItmObjPg
	_SchedgAgrmtFactSheetHdrText		_SchedgAgrmtFactSheetHdrText

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_SchedgAgrmtHdrObjPg.
-- 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: CSCHHDRFS

CREATE VIEW C_SchedgAgrmtHdrObjPg AS
SELECT
  I_Schedgagrmthdr.SchedulingAgreement AS SchedulingAgreement,
  I_Schedgagrmthdr.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_Schedgagrmthdr.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_Schedgagrmthdr.PurchasingDocumentType AS PurchasingDocumentType,
  I_Schedgagrmthdr.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  I_Schedgagrmthdr.CreatedByUser AS CreatedByUser,
  I_Schedgagrmthdr.CreatedByUserFullName AS CreatedByUserFullName,
  I_Schedgagrmthdr.CreationDate AS CreationDate,
  I_Schedgagrmthdr.Language AS Language,
  I_Schedgagrmthdr.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  I_Schedgagrmthdr.PurchasingGroup AS PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  I_Schedgagrmthdr.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_Schedgagrmthdr.PaymentTerms AS PaymentTerms,
  _PaymentTermsText.PaymentTermsName AS PaymentTermsName,
  I_Schedgagrmthdr.CashDiscount2Days AS CashDiscount2Days,
  I_Schedgagrmthdr.CashDiscount1Percent AS CashDiscount1Percent,
  I_Schedgagrmthdr.CashDiscount1Days AS CashDiscount1Days,
  I_Schedgagrmthdr.CashDiscount2Percent AS CashDiscount2Percent,
  I_Schedgagrmthdr.NetPaymentDays AS NetPaymentDays,
  I_Schedgagrmthdr.TargetAmount AS TargetAmount,
  I_Schedgagrmthdr.DocumentCurrency AS DocumentCurrency,
  I_Schedgagrmthdr.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  I_Schedgagrmthdr.IncotermsClassification AS IncotermsClassification,
  I_Schedgagrmthdr.IncotermsLocation1 AS IncotermsLocation1,
  I_Schedgagrmthdr.IncotermsLocation2 AS IncotermsLocation2,
  I_Schedgagrmthdr.IncotermsVersion AS IncotermsVersion,
  I_Schedgagrmthdr.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  I_Schedgagrmthdr.ScheduleAgreementHasReleaseDoc AS ScheduleAgreementHasReleaseDoc,
  I_Schedgagrmthdr.Supplier AS Supplier,
  I_Schedgagrmthdr.SupplierAddressID AS SupplierAddressID,
  I_Schedgagrmthdr.ValidityStartDate AS ValidityStartDate,
  I_Schedgagrmthdr.ValidityEndDate AS ValidityEndDate,
  I_Schedgagrmthdr.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  I_Schedgagrmthdr.InvoicingParty AS InvoicingParty,
  I_Schedgagrmthdr.SupplyingSupplier AS SupplyingSupplier,
  I_Schedgagrmthdr.VATRegistrationCountry AS VATRegistrationCountry,
  I_Schedgagrmthdr.CompanyVATRegistration AS CompanyVATRegistration,
  _SupplierValueHelp.SupplierName AS SupplierName,
  I_Schedgagrmthdr._DocumentCurrency AS _DocumentCurrency
FROM I_Schedgagrmthdr
LEFT OUTER JOIN C_SchedgAgrmtItmObjPg AS _SchedgAgrmtItmObjPg ON _SchedgAgrmtItmObjPg.SchedulingAgreement = SchedulingAgreement  -- association [1..*]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroup ON _PurchasingGroup.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON _PaymentTermsText.PaymentTerms = PaymentTerms AND _PaymentTermsText.Language = Language  -- association [0..1]
LEFT OUTER JOIN C_SchedgAgrmtFactSheetHdrText AS _SchedgAgrmtFactSheetHdrText ON _SchedgAgrmtFactSheetHdrText.SchedulingAgreement = SchedulingAgreement  -- association [0..*]
;

Depth:

C_SchedgAgrmtHdrObjPg view

I_Schedgagrmthdr view