What is I_Schedgagrmthdr in SAP S/4HANA?

I_Schedgagrmthdr is a basic CDS view in SAP S/4HANA. Scheduling Agreement Header It contains 80 fields.

Which tables does I_Schedgagrmthdr read from?

I_Schedgagrmthdr reads data from: R_PurchasingDocument.

What VDM layer is I_Schedgagrmthdr?

I_Schedgagrmthdr is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_Schedgagrmthdr

DDL: I_SCHEDGAGRMTHDR SQL: ISCHEDGAGRMTHDR Type: view BASIC

80 Fields 1 Data Sources 9 Associations

Scheduling Agreement Header

I_Schedgagrmthdr is a Basic CDS View that provides data about "Scheduling Agreement Header" in SAP S/4HANA. It reads from 1 data source (R_PurchasingDocument) and exposes 80 fields with key field SchedulingAgreement. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
R_PurchasingDocument	R_PurchasingDocument	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..*]	I_SchedgAgrmtItm	_SchedgAgrmtItm	`$projection.SchedulingAgreement = _SchedgAgrmtItm.SchedulingAgreement`
[1..*]	I_SchedgAgrmtPartner	_Schedgagrmtpartner	`_Schedgagrmtpartner.SchedulingAgreement = $projection.SchedulingAgreement`
[0..*]	I_Schedgagrmthdrcnd	_Schedgagrmthdrcnd	`_Schedgagrmthdrcnd.SchedulingAgreement = $projection.SchedulingAgreement`
[1..1]	I_Schedgagrmthdrtranfields	_SchedgAgrmtTransientField	`$projection.SchedulingAgreement = _SchedgAgrmtTransientField.SchedulingAgreement`
[0..*]	I_SchedgAgrmtHeaderNotes	_SchedgAgrmtHeaderNotes	`$projection.SchedulingAgreement = _SchedgAgrmtHeaderNotes.SchedulingAgreement`
[0..1]	I_PurchasingDocumentTypeText	_SchedulingAgreementTypeText	`_SchedulingAgreementTypeText.PurchasingDocumentType = $projection.PurchasingDocumentType and _SchedulingAgreementTypeText.PurchasingDocumentCategory = 'L' and _SchedulingAgreementTypeText.Language = $session.system_language`
[1..1]	I_CountrySalesTax	_CountrySalesTax	`$projection.VATRegistrationCountry = _CountrySalesTax.VATRegistrationCountry and $projection.CompanyCode = _CountrySalesTax.CompanyCode and $projection.CompanyVATRegistration = _CountrySalesTax.CompanyVATRegistration`
[0..1]	I_User	_User	`_User.UserID = $projection.CreatedByUser ---Extension`
[1..1]	E_PurchasingDocument	_SchedulingAgreementExten	`$projection.SchedulingAgreement = _SchedulingAgreementExten.PurchasingDocument`

Annotations (19)

Name	Value	Level
AbapCatalog.sqlViewName	ISCHEDGAGRMTHDR	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.compositionRoot	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Scheduling Agreement Header	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Search.searchable	true	view
UI.headerInfo.typeName	Scheduling Agreement	view
UI.headerInfo.typeNamePlural	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
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
AbapCatalog.preserveKey	true	view

Fields (80)

Key	Field	Source Table	Source Field	Description
KEY	SchedulingAgreement	R_PurchasingDocument	PurchasingDocument	Purchasing Document
	CompanyCode	R_PurchasingDocument	CompanyCode	Receiver Company Code
	PurchasingDocumentCategory	R_PurchasingDocument	PurchasingDocumentCategory	Doc. Category
	PurchasingDocumentType	R_PurchasingDocument	PurchasingDocumentType	RFQ Type
	PurchasingDocumentSubtype	R_PurchasingDocument	PurchasingDocumentSubtype	Control
	PurchasingDocumentTypeName	_SchedulingAgreementTypeText	PurchasingDocumentTypeName	Description
	CreatedByUser	R_PurchasingDocument	CreatedByUser	User Name
	CreatedByUserFullName	_User	UserDescription	Full Name
	CreationDate	R_PurchasingDocument	CreationDate	Time Stamp
	Language	R_PurchasingDocument	Language	Report Text Language
	PurchasingOrganization	R_PurchasingDocument	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	R_PurchasingDocument	PurchasingGroup	Purchasing Group
	DocumentCurrency	R_PurchasingDocument	DocumentCurrency	Document Currency
	PaymentTerms	R_PurchasingDocument	PaymentTerms	Pyt Terms
	CashDiscount1Days	R_PurchasingDocument	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount1Percent	R_PurchasingDocument	CashDiscount1Percent	Disc. Percent 1
	CashDiscount2Days	R_PurchasingDocument	CashDiscount2Days	Days from Baseline Date for Payment
	CashDiscount2Percent	R_PurchasingDocument	CashDiscount2Percent	Disc. Percent 2
	NetPaymentDays	R_PurchasingDocument	NetPaymentDays	Net Pmt Terms Period
	TargetAmount	R_PurchasingDocument	TargetAmount	Target Value
	ExchangeRate	R_PurchasingDocument	ExchangeRate	Exchange rate
	ExchangeRateIsFixed	R_PurchasingDocument	ExchangeRateIsFixed	Fixed Exch.Rate
	IncotermsSupChnLoc1AddlUUID	R_PurchasingDocument	IncotermsSupChnLoc1AddlUUID	Location UUID
	IncotermsSupChnLoc2AddlUUID	R_PurchasingDocument	IncotermsSupChnLoc2AddlUUID	Location UUID
	IncotermsSupChnDvtgLocAddlUUID	R_PurchasingDocument	IncotermsSupChnDvtgLocAddlUUID	Location UUID
	IncotermsLocation1Identifier
	IncotermsLocation2Identifier
	IncotermsDvtgLocIdentifier
	IncotermsDvtgLocDescription
	IncotermsVersion	R_PurchasingDocument	IncotermsVersion	Inco. Version
	IncotermsClassification	R_PurchasingDocument	IncotermsClassification	Incoterms
	IncotermsTransferLocation	R_PurchasingDocument	IncotermsTransferLocation	Incoterms 2
	IncotermsLocation1	R_PurchasingDocument	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	R_PurchasingDocument	IncotermsLocation2	Inco. Location2
	PurchasingDocumentOrderDate	R_PurchasingDocument	PurchasingDocumentOrderDate	PO Date
	ScheduleAgreementHasReleaseDoc	R_PurchasingDocument	ScheduleAgreementHasReleaseDoc	Release Docu.
	Supplier	R_PurchasingDocument	Supplier	Supplier
	SupplierAddressID	R_PurchasingDocument	SupplierAddressID	Address Number
	ValidityStartDate	R_PurchasingDocument	ValidityStartDate	Validity Start Date
	ValidityEndDate	R_PurchasingDocument	ValidityEndDate	ValidTo
	PurchasingDocumentOrigin	R_PurchasingDocument	PurchasingDocumentOrigin	Status
	QuotationSubmissionDate	R_PurchasingDocument	QuotationSubmissionDate	Quotation Date
	SupplierQuotationExternalID	R_PurchasingDocument	SupplierQuotationExternalID	Quotation
	VATRegistrationCountry	R_PurchasingDocument	VATRegistrationCountry	CtryRgnSlsTxNo.
	InvoicingParty	R_PurchasingDocument	InvoicingParty	Supplier
	SupplyingSupplier	R_PurchasingDocument	SupplyingSupplier	Goods Supplier
	SupplierRespSalesPersonName	R_PurchasingDocument	SupplierRespSalesPersonName	Salesperson
	SupplierPhoneNumber	R_PurchasingDocument	SupplierPhoneNumber	Telephone
	CorrespncExternalReference	R_PurchasingDocument	CorrespncExternalReference	Your Reference
	CorrespncInternalReference	R_PurchasingDocument	CorrespncInternalReference	Our Reference
	CompanyVATRegistration	R_PurchasingDocument	VATRegistration	VAT Registration No.
	LastChangeDateTime	R_PurchasingDocument	LastChangeDateTime	Timestamp
	IsEndOfPurposeBlocked	R_PurchasingDocument	IsEndOfPurposeBlocked	Busin. Purp. Cmpltd.
	PurgAggrgdProdCmplncSuplrSts	R_PurchasingDocument	PurgAggrgdProdCmplncSuplrSts	Supplier Check Sts
	_Supplier	R_PurchasingDocument	_Supplier
	PurchasingDocumentDeletionCode		PurchasingDocumentDeletionCode	Del. Indicator
	ReleaseIsNotCompleted		ReleaseIsNotCompleted	Subj.to Release
	PurchasingCompletenessStatus		PurchasingCompletenessStatus	Incomplete
	PurchasingProcessingStatus		PurchasingProcessingStatus	Proc. State
	_SchedgAgrmtTransientField		_SchedgAgrmtTransientField
	_CompanyCode		_CompanyCode
	_PurchasingDocumentType		_PurchasingDocumentType
	_PurchasingDocumentCategory		_PurchasingDocumentCategory
	_Language		_Language
	_DocumentCurrency		_DocumentCurrency
	_PaymentTerms		_PaymentTerms
	_IncotermsVersion		_IncotermsVersion
	_PurchasingDocumentOrigin		_PurchasingDocumentOrigin
	_SchedulingAgreementTypeText		_SchedulingAgreementTypeText
	_PurchasingOrganization	R_PurchasingDocument	_PurchasingOrganization
	_PurchasingGroup		_PurchasingGroup
	_IncotermsClassification	R_PurchasingDocument	_IncotermsClassification
	_SupplyingSupplier	R_PurchasingDocument	_SupplyingSupplier
	_InvoicingParty	R_PurchasingDocument	_InvoicingParty
	_CountrySalesTax		_CountrySalesTax
	_User		_User
	_SchedgAgrmtItm		_SchedgAgrmtItm
	_Schedgagrmtpartner		_Schedgagrmtpartner
	_Schedgagrmthdrcnd		_Schedgagrmthdrcnd
	_SchedgAgrmtHeaderNotes		_SchedgAgrmtHeaderNotes

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_Schedgagrmthdr.
-- 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: ISCHEDGAGRMTHDR

CREATE VIEW I_Schedgagrmthdr AS
SELECT
  R_PurchasingDocument.PurchasingDocument AS SchedulingAgreement,
  R_PurchasingDocument.CompanyCode AS CompanyCode,
  R_PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  R_PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  R_PurchasingDocument.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _SchedulingAgreementTypeText.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  R_PurchasingDocument.CreatedByUser AS CreatedByUser,
  _User.UserDescription AS CreatedByUserFullName,
  R_PurchasingDocument.CreationDate AS CreationDate,
  R_PurchasingDocument.Language AS Language,
  R_PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  R_PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  R_PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  R_PurchasingDocument.PaymentTerms AS PaymentTerms,
  R_PurchasingDocument.CashDiscount1Days AS CashDiscount1Days,
  R_PurchasingDocument.CashDiscount1Percent AS CashDiscount1Percent,
  R_PurchasingDocument.CashDiscount2Days AS CashDiscount2Days,
  R_PurchasingDocument.CashDiscount2Percent AS CashDiscount2Percent,
  R_PurchasingDocument.NetPaymentDays AS NetPaymentDays,
  R_PurchasingDocument.TargetAmount AS TargetAmount,
  R_PurchasingDocument.ExchangeRate AS ExchangeRate,
  R_PurchasingDocument.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  R_PurchasingDocument.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  R_PurchasingDocument.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  R_PurchasingDocument.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  cast( '' as tminco_loc_1_id ) AS IncotermsLocation1Identifier,
  cast( '' as tminco_loc_2_id ) AS IncotermsLocation2Identifier,
  cast( '' as tminco_loc_d_id ) AS IncotermsDvtgLocIdentifier,
  cast( '' as tminco_loc_d_descr ) AS IncotermsDvtgLocDescription,
  R_PurchasingDocument.IncotermsVersion AS IncotermsVersion,
  R_PurchasingDocument.IncotermsClassification AS IncotermsClassification,
  R_PurchasingDocument.IncotermsTransferLocation AS IncotermsTransferLocation,
  R_PurchasingDocument.IncotermsLocation1 AS IncotermsLocation1,
  R_PurchasingDocument.IncotermsLocation2 AS IncotermsLocation2,
  R_PurchasingDocument.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  R_PurchasingDocument.ScheduleAgreementHasReleaseDoc AS ScheduleAgreementHasReleaseDoc,
  R_PurchasingDocument.Supplier AS Supplier,
  R_PurchasingDocument.SupplierAddressID AS SupplierAddressID,
  R_PurchasingDocument.ValidityStartDate AS ValidityStartDate,
  R_PurchasingDocument.ValidityEndDate AS ValidityEndDate,
  R_PurchasingDocument.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  R_PurchasingDocument.QuotationSubmissionDate AS QuotationSubmissionDate,
  R_PurchasingDocument.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  R_PurchasingDocument.VATRegistrationCountry AS VATRegistrationCountry,
  R_PurchasingDocument.InvoicingParty AS InvoicingParty,
  R_PurchasingDocument.SupplyingSupplier AS SupplyingSupplier,
  R_PurchasingDocument.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  R_PurchasingDocument.SupplierPhoneNumber AS SupplierPhoneNumber,
  R_PurchasingDocument.CorrespncExternalReference AS CorrespncExternalReference,
  R_PurchasingDocument.CorrespncInternalReference AS CorrespncInternalReference,
  R_PurchasingDocument.VATRegistration AS CompanyVATRegistration,
  R_PurchasingDocument.LastChangeDateTime AS LastChangeDateTime,
  R_PurchasingDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  R_PurchasingDocument.PurgAggrgdProdCmplncSuplrSts AS PurgAggrgdProdCmplncSuplrSts,
  R_PurchasingDocument._Supplier AS _Supplier,
  PurchasingDocumentDeletionCode,
  ReleaseIsNotCompleted,
  PurchasingCompletenessStatus,
  PurchasingProcessingStatus,
  R_PurchasingDocument._PurchasingOrganization AS _PurchasingOrganization,
  R_PurchasingDocument._IncotermsClassification AS _IncotermsClassification,
  R_PurchasingDocument._SupplyingSupplier AS _SupplyingSupplier,
  R_PurchasingDocument._InvoicingParty AS _InvoicingParty
FROM R_PurchasingDocument
LEFT OUTER JOIN I_SchedgAgrmtItm AS _SchedgAgrmtItm ON SchedulingAgreement = _SchedgAgrmtItm.SchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN I_SchedgAgrmtPartner AS _Schedgagrmtpartner ON _Schedgagrmtpartner.SchedulingAgreement = SchedulingAgreement  -- association [1..*]
LEFT OUTER JOIN I_Schedgagrmthdrcnd AS _Schedgagrmthdrcnd ON _Schedgagrmthdrcnd.SchedulingAgreement = SchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN I_Schedgagrmthdrtranfields AS _SchedgAgrmtTransientField ON SchedulingAgreement = _SchedgAgrmtTransientField.SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtHeaderNotes AS _SchedgAgrmtHeaderNotes ON SchedulingAgreement = _SchedgAgrmtHeaderNotes.SchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _SchedulingAgreementTypeText ON _SchedulingAgreementTypeText.PurchasingDocumentType = PurchasingDocumentType AND _SchedulingAgreementTypeText.PurchasingDocumentCategory = 'L' AND _SchedulingAgreementTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountrySalesTax AS _CountrySalesTax ON VATRegistrationCountry = _CountrySalesTax.VATRegistrationCountry AND CompanyCode = _CountrySalesTax.CompanyCode AND CompanyVATRegistration = _CountrySalesTax.CompanyVATRegistration  -- association [1..1]
LEFT OUTER JOIN I_User AS _User ON _User.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _SchedulingAgreementExten ON SchedulingAgreement = _SchedulingAgreementExten.PurchasingDocument  -- association [1..1]
;

Depth:

I_Schedgagrmthdr view

R_PurchasingDocument view