What is C_Suppliercontracts in SAP S/4HANA?

C_Suppliercontracts is a consumption CDS view in SAP S/4HANA. Purchase Contract It contains 48 fields.

Which tables does C_Suppliercontracts read from?

C_Suppliercontracts reads data from: I_PurchaseContract.

What VDM layer is C_Suppliercontracts?

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

C_Suppliercontracts

DDL: C_SUPPLIERCONTRACTS SQL: CSUPPCONTRACT Type: view CONSUMPTION

48 Fields 1 Data Sources 9 Associations

Purchase Contract

C_Suppliercontracts is a Consumption CDS View that provides data about "Purchase Contract" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContract) and exposes 48 fields with key field PurchaseContract. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_PurchaseContract	I_PurchaseContract	from

Associations (9)

Cardinality	Target	Alias	Condition
[1..*]	I_PurchaseContractHistory	_PurchaseContractHistory	`$projection.PurchaseContract = _PurchaseContractHistory.PurchaseContract`
[1..*]	C_ContractItemFs	_PurchaseContractItem	`$projection.PurchaseContract = _PurchaseContractItem.PurchaseContract`
[0..*]	I_PurchasingDocumentTypeText	_PurchasingDocumentTypeText	`$projection.PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory and $projection.PurchaseContractType = _PurchasingDocumentTypeText.PurchasingDocumentType`
[0..1]	I_PurchasingDocumentTypeText	_PurchasingDocumentTypeName	`$projection.PurchasingDocumentCategory = _PurchasingDocumentTypeName.PurchasingDocumentCategory and $projection.PurchaseContractType = _PurchasingDocumentTypeName.PurchasingDocumentType and _PurchasingDocumentTypeName.Language = $session.system_language`
[0..*]	I_PurgDocumentCategoryText	_PurgDocumentCategoryText	`$projection.PurchasingDocumentCategory = _PurgDocumentCategoryText.PurchasingDocumentCategory`
[0..*]	I_IncotermsClassificationText	_IncotermsClassificationText	`$projection.IncotermsClassification = _IncotermsClassificationText.IncotermsClassification`
[0..*]	I_PaymentTermsText	_PaymentTermsText	`$projection.PaymentTerms = _PaymentTermsText.PaymentTerms`
[0..1]	I_PurgProcessingStatusText	_PurgProcessingStatusText	`$projection.PurchasingProcessingStatus = _PurgProcessingStatusText.PurchasingProcessingStatus and _PurgProcessingStatusText.Language = $session.system_language`
[1..1]	I_SupplierOrAddressContactCard	_SupplierHeadOffice	`( _SupplierHeadOffice.ContactCardType = 'Address' and _SupplierHeadOffice.ContactCardID = $projection.SupplierAddressID and _SupplierHeadOffice.ContactCardRole = 'Supplier' ) or ( _SupplierHeadOffice.ContactCardType = 'Supplier' and _SupplierHeadOffice.ContactCardID = $projection.Supplier and _SupplierHeadOffice.ContactCardRole = 'Supplier' )`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	CSUPPCONTRACT	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Purchase Contract	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view
UI.headerInfo.typeName	Purchase Contract	view
UI.headerInfo.typeNamePlural	Purchase Contracts	view
UI.headerInfo.title.label	Purchase Contract	view
UI.headerInfo.title.value	PurchaseContract	view

Fields (48)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseContract	I_PurchaseContract	PurchaseContract	Purchasing Doc.
	PurchaseContractType	I_PurchaseContract	PurchaseContractType	Order Type
	PurchasingDocumentTypeName	_PurchasingDocumentTypeName	PurchasingDocumentTypeName	Description
	PurchasingDocumentCategory	I_PurchaseContract	PurchasingDocumentCategory	Doc. Category
	IncotermsClassification	I_PurchaseContract	IncotermsClassification	Incoterms
	CreationDate	I_PurchaseContract	CreationDate	Time Stamp
	DocumentCurrency	I_PurchaseContract	DocumentCurrency	Document Currency
	PurchaseContractTargetAmount	I_PurchaseContract	PurchaseContractTargetAmount	Target Value
	Supplier	I_PurchaseContract	Supplier	Supplier
	SupplierName	_SupplierHeadOffice	FullName	Name
	AddressID
	EmailAddress	_SupplierHeadOffice	EmailAddress	E-Mail Address
	InternationalPhoneNumber	_SupplierHeadOffice	PhoneNumber	Telephone no.
	InternationalMobilePhoneNumber	_SupplierHeadOffice	MobilePhoneNumber	Telephone
	CompanyCode	I_PurchaseContract	CompanyCode	Receiver Company Code
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	PurchasingOrganization	I_PurchaseContract	PurchasingOrganization	Purchasing Organization
	PurchasingOrganizationName	_PurchasingOrganization	PurchasingOrganizationName	Purch. Org. Name
	PurchasingGroup	I_PurchaseContract	PurchasingGroup	Purchasing Group
	PurchasingGroupName	_PurchasingGroup	PurchasingGroupName	Purchasing Grp. Name
	SupplyingSupplier		SupplyingSupplier	Goods Supplier
	InvoicingParty		InvoicingParty	Supplier
	SupplierAddressID		SupplierAddressID	Address Number
	CreatedByUser		CreatedByUser	User Name
	IncotermsTransferLocation	I_PurchaseContract	IncotermsTransferLocation	Incoterms 2
	PaymentTerms	I_PurchaseContract	PaymentTerms	Pyt Terms
	PaymentTermsDescription
	CashDiscount1Days	I_PurchaseContract	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	I_PurchaseContract	CashDiscount2Days	Days from Baseline Date for Payment
	NetPaymentDays	I_PurchaseContract	NetPaymentDays	Net Pmt Terms Period
	CashDiscount1Percent	I_PurchaseContract	CashDiscount1Percent	Disc. Percent 1
	CashDiscount2Percent	I_PurchaseContract	CashDiscount2Percent	Disc. Percent 2
	ValidityEndDate	I_PurchaseContract	ValidityEndDate	ValidTo
	ValidityStartDate	I_PurchaseContract	ValidityStartDate	Validity Start Date
	PurchasingProcessingStatus		PurchasingProcessingStatus	Proc. State
	PurchasingProcessingStatusName	_PurgProcessingStatusText	PurchasingProcessingStatusName	Short Description
	_PurchaseContractHistory		_PurchaseContractHistory
	_PurchaseContractItem		_PurchaseContractItem
	_IncotermsClassification	I_PurchaseContract	_IncotermsClassification
	_PurchasingDocumentType	I_PurchaseContract	_PurchasingDocumentType
	_PurchasingDocumentCategory	I_PurchaseContract	_PurchasingDocumentCategory
	_SupplierHeadOffice		_SupplierHeadOffice
	_IncotermsClassificationText		_IncotermsClassificationText
	_PurchasingDocumentTypeText		_PurchasingDocumentTypeText
	_PurgDocumentCategoryText		_PurgDocumentCategoryText
	_PaymentTermsText		_PaymentTermsText
	_PurchasingDocumentTypeName		_PurchasingDocumentTypeName
	_PurgProcessingStatusText		_PurgProcessingStatusText

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_Suppliercontracts.
-- 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: CSUPPCONTRACT

CREATE VIEW C_Suppliercontracts AS
SELECT
  I_PurchaseContract.PurchaseContract AS PurchaseContract,
  I_PurchaseContract.PurchaseContractType AS PurchaseContractType,
  _PurchasingDocumentTypeName.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  I_PurchaseContract.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_PurchaseContract.IncotermsClassification AS IncotermsClassification,
  I_PurchaseContract.CreationDate AS CreationDate,
  I_PurchaseContract.DocumentCurrency AS DocumentCurrency,
  I_PurchaseContract.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  I_PurchaseContract.Supplier AS Supplier,
  _SupplierHeadOffice.FullName AS SupplierName,
  cast(_SupplierHeadOffice.AddressID as contactcardaddress) AS AddressID,
  _SupplierHeadOffice.EmailAddress AS EmailAddress,
  _SupplierHeadOffice.PhoneNumber AS InternationalPhoneNumber,
  _SupplierHeadOffice.MobilePhoneNumber AS InternationalMobilePhoneNumber,
  I_PurchaseContract.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  I_PurchaseContract.PurchasingGroup AS PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  SupplyingSupplier,
  InvoicingParty,
  SupplierAddressID,
  CreatedByUser,
  I_PurchaseContract.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_PurchaseContract.PaymentTerms AS PaymentTerms,
  cast('' as mm_pur_paymenttermstext) AS PaymentTermsDescription,
  I_PurchaseContract.CashDiscount1Days AS CashDiscount1Days,
  I_PurchaseContract.CashDiscount2Days AS CashDiscount2Days,
  I_PurchaseContract.NetPaymentDays AS NetPaymentDays,
  I_PurchaseContract.CashDiscount1Percent AS CashDiscount1Percent,
  I_PurchaseContract.CashDiscount2Percent AS CashDiscount2Percent,
  I_PurchaseContract.ValidityEndDate AS ValidityEndDate,
  I_PurchaseContract.ValidityStartDate AS ValidityStartDate,
  PurchasingProcessingStatus,
  _PurgProcessingStatusText.PurchasingProcessingStatusName AS PurchasingProcessingStatusName,
  I_PurchaseContract._IncotermsClassification AS _IncotermsClassification,
  I_PurchaseContract._PurchasingDocumentType AS _PurchasingDocumentType,
  I_PurchaseContract._PurchasingDocumentCategory AS _PurchasingDocumentCategory
FROM I_PurchaseContract
LEFT OUTER JOIN I_PurchaseContractHistory AS _PurchaseContractHistory ON PurchaseContract = _PurchaseContractHistory.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_ContractItemFs AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory AND PurchaseContractType = _PurchasingDocumentTypeText.PurchasingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeName ON PurchasingDocumentCategory = _PurchasingDocumentTypeName.PurchasingDocumentCategory AND PurchaseContractType = _PurchasingDocumentTypeName.PurchasingDocumentType AND _PurchasingDocumentTypeName.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON PurchasingDocumentCategory = _PurgDocumentCategoryText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_PurgProcessingStatusText AS _PurgProcessingStatusText ON PurchasingProcessingStatus = _PurgProcessingStatusText.PurchasingProcessingStatus AND _PurgProcessingStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupplierOrAddressContactCard AS _SupplierHeadOffice ON ( _SupplierHeadOffice.ContactCardType = 'Address' AND _SupplierHeadOffice.ContactCardID = SupplierAddressID AND _SupplierHeadOffice.ContactCardRole = 'Supplier' ) OR ( _SupplierHeadOffice.ContactCardType = 'Supplier' AND _SupplierHeadOffice.ContactCardID = Supplier AND _SupplierHeadOffice.ContactCardRole = 'Supplier' )  -- association [1..1]
;

Depth:

C_Suppliercontracts view

I_PurchaseContract view