What is C_PurchaseOrderCommitment in SAP S/4HANA?

C_PurchaseOrderCommitment is a consumption CDS view in SAP S/4HANA. Commitments of Purchase Order It contains 56 fields.

Which tables does C_PurchaseOrderCommitment read from?

C_PurchaseOrderCommitment reads data from: P_PurchaseOrderCommitment.

What VDM layer is C_PurchaseOrderCommitment?

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

C_PurchaseOrderCommitment

DDL: C_PURCHASEORDERCOMMITMENT SQL: CPURORDCOMMIT Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN_V2

56 Fields 1 Data Sources 4 Associations

Commitments of Purchase Order

C_PurchaseOrderCommitment is a Consumption CDS View that provides data about "Commitments of Purchase Order" in SAP S/4HANA. It reads from 1 data source (P_PurchaseOrderCommitment) and exposes 56 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber, SourceReferenceDocSubitem, Segment. It has 4 associations to related views. Part of development package ODATA_MM_PUR_PO_MAINTAIN_V2.

Data Sources (1)

Source	Alias	Join Type
P_PurchaseOrderCommitment	PurchaseOrderCommitment	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	I_MM_GLAccountVH	_GLAccount	`$projection.GLAccount = _GLAccount.GLAccount and $projection.CompanyCode = _GLAccount.CompanyCode`
[0..1]	I_MM_ControllingAreaVH	_ControllingAreaValueHelp	`$projection.ControllingArea = _ControllingAreaValueHelp.ControllingArea`
[0..1]	I_PubSecBudgetAccountStdVH	_PubSecBudgetAccountStd	`_PubSecBudgetAccountStd.PubSecBudgetAccount = $projection.PubSecBudgetAccount and _PubSecBudgetAccountStd.PubSecBudgetAccountCoCode = $projection.PubSecBudgetAccountCoCode`
[0..1]	I_PubSecBdgtCnsmpnType	_PubSecBdgtCnsmpnType	`_PubSecBdgtCnsmpnType.PubSecBudgetCnsmpnType = $projection.PubSecBudgetCnsmpnType`

Annotations (20)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
AbapCatalog.sqlViewName	CPURORDCOMMIT	view
EndUserText.label	Commitments of Purchase Order	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ObjectModel.transactionalProcessingDelegated	false	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
ObjectModel.deleteEnabled	false	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.text.control	#ASSOCIATED_TEXT_UI_HIDDEN	view
Search.searchable	false	view
UI.headerInfo.typeName	Commitment	view
UI.headerInfo.typeNamePlural	Commitments	view
UI.headerInfo.title.value	Purchase Order Commitments	view

Fields (56)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseOrder			Purchasing Document
KEY	PurchaseOrderItem		PurchasingDocumentItem	Purchasing Doc. Item
KEY	AccountAssignmentNumber			Account Assgmt No.
KEY	SourceReferenceDocSubitem		SourceReferenceDocSubitem
KEY	Segment		Segment	Segment number
KEY	GLAccount	P_PurchaseOrderCommitment	GLAccount	General Ledger
KEY	ControllingArea		ControllingArea	Controlling Area
KEY	FunctionalArea	P_PurchaseOrderCommitment	FunctionalArea	Sendr Fctl Area
KEY	CompanyCode	P_PurchaseOrderCommitment	CompanyCode	Receiver Company Code
KEY	CashLedgerAccount	P_PurchaseOrderCommitment	CashLedgerAccount	Cash Origin Account
KEY	Fund	P_PurchaseOrderCommitment	Fund	Sender Fund
KEY	GrantID	P_PurchaseOrderCommitment	GrantID	Sender Grant
KEY	BudgetPeriod	P_PurchaseOrderCommitment	BudgetPeriod	Budget Period
KEY	FiscalYearPeriod	P_PurchaseOrderCommitment	FiscalYearPeriod	Period/Year
KEY	PubSecBudgetAccount	P_PurchaseOrderCommitment	PubSecBudgetAccount	Budget Account
KEY	PubSecBudgetAccountCoCode	P_PurchaseOrderCommitment	PubSecBudgetAccountCoCode	Company Code for Budget Account
KEY	PubSecBudgetIsRelevant	P_PurchaseOrderCommitment	PubSecBudgetIsRelevant
KEY	PubSecBudgetCnsmpnType	P_PurchaseOrderCommitment	PubSecBudgetCnsmpnType	Budget Consumption Type
KEY	CostCenter	P_PurchaseOrderCommitment	CostCenter	Cost Center
KEY	ProfitCenter	P_PurchaseOrderCommitment	ProfitCenter	Profit Center
KEY	WBSElementInternalID	P_PurchaseOrderCommitment	WBSElementInternalID	WBS Internal ID
KEY	WBSElement	P_PurchaseOrderCommitment	WBSElement	WBS Internal ID
KEY	AccountAssignmentType	P_PurchaseOrderCommitment	AccountAssignmentType	Sndr AcctAssgmt Type
KEY	AccountAssignment	P_PurchaseOrderCommitment	AccountAssignment	Sender Acct Assgmt
KEY	SponsoredProgram	P_PurchaseOrderCommitment	SponsoredProgram	Sponsored Program
KEY	SponsoredClass	P_PurchaseOrderCommitment	SponsoredClass	Sponsored Class
KEY	TransactionCurrency		TransactionCurrency	Transaction Currency
	CompanyCodeName
	FundName
	GrantName
	SponsoredClassName
	SponsoredProgramName
	BudgetAccountName
	BudgetPeriodName
	PubSecBudgetCnsmpnTypeText
	CostCenterName
	ProfitCenterName
	SegmentName
	WBSDescription
	AccountAssignmentTypeName
	GLAccountName
	PurchasingOrganization		PurchasingOrganization	Purchasing Organization
	PurchasingGroup		PurchasingGroup	Purchasing Group
	PurchaseOrderType		PurchaseOrderType	PO Type
	DocumentItemText	P_PurchaseOrderCommitment	PurchaseOrderItemText	Short Text
	AmountInTransactionCurrency			Pt Crcy Amt
	AmountInCompanyCodeCurrency			Local Crcy Amt
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	AmountInGlobalCurrency			Amount in Global Currency
	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
	IsCommitment		IsCommitment
	_ControllingAreaValueHelp		_ControllingAreaValueHelp
	_FunctionalArea	P_PurchaseOrderCommitment	_FunctionalArea
	_PubSecBudgetAccountStd		_PubSecBudgetAccountStd
	_PubSecBdgtCnsmpnType		_PubSecBdgtCnsmpnType
	_GLAccount		_GLAccount

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_PurchaseOrderCommitment.
-- 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: CPURORDCOMMIT

CREATE VIEW C_PurchaseOrderCommitment AS
SELECT
  cast (PurchasingDocument as vdm_purchaseorder preserving type) AS PurchaseOrder,
  PurchasingDocumentItem AS PurchaseOrderItem,
  cast(AccountAssignmentNumber as dzekkn_ll preserving type ) AS AccountAssignmentNumber,
  SourceReferenceDocSubitem,
  Segment,
  PurchaseOrderCommitment.GLAccount AS GLAccount,
  ControllingArea,
  PurchaseOrderCommitment.FunctionalArea AS FunctionalArea,
  PurchaseOrderCommitment.CompanyCode AS CompanyCode,
  PurchaseOrderCommitment.CashLedgerAccount AS CashLedgerAccount,
  PurchaseOrderCommitment.Fund AS Fund,
  PurchaseOrderCommitment.GrantID AS GrantID,
  PurchaseOrderCommitment.BudgetPeriod AS BudgetPeriod,
  PurchaseOrderCommitment.FiscalYearPeriod AS FiscalYearPeriod,
  PurchaseOrderCommitment.PubSecBudgetAccount AS PubSecBudgetAccount,
  PurchaseOrderCommitment.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  PurchaseOrderCommitment.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  PurchaseOrderCommitment.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  PurchaseOrderCommitment.CostCenter AS CostCenter,
  PurchaseOrderCommitment.ProfitCenter AS ProfitCenter,
  PurchaseOrderCommitment.WBSElementInternalID AS WBSElementInternalID,
  PurchaseOrderCommitment.WBSElement AS WBSElement,
  PurchaseOrderCommitment.AccountAssignmentType AS AccountAssignmentType,
  PurchaseOrderCommitment.AccountAssignment AS AccountAssignment,
  PurchaseOrderCommitment.SponsoredProgram AS SponsoredProgram,
  PurchaseOrderCommitment.SponsoredClass AS SponsoredClass,
  TransactionCurrency,
  _CompanyCodeText .CompanyCodeName AS CompanyCodeName,
  _FundText [1: Language = $session.system_language].FundName AS FundName,
  _Grant._Text [1: Language = $session.system_language].GrantName AS GrantName,
  _SponsoredClass._Text [1: Language = $session.system_language].SponsoredClassName AS SponsoredClassName,
  _SponsoredProgram._Text [1: Language = $session.system_language].SponsoredProgramName AS SponsoredProgramName,
  _PubSecBudgetAccount._BudgetAccountText[1: Language = $session.system_language].BudgetAccountName AS BudgetAccountName,
  _BudgetPeriodText [1: Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  _PubSecBudgetCnsmpnType._Text [1: Language = $session.system_language].PubSecBudgetCnsmpnTypeText AS PubSecBudgetCnsmpnTypeText,
  _CostCenterText [1: Language = $session.system_language and ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].CostCenterName AS CostCenterName,
  _ProfitCenterText [1: Language = $session.system_language and ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].ProfitCenterName AS ProfitCenterName,
  _SegmentText [1: Language = $session.system_language].SegmentName AS SegmentName,
  _WBSElementBasicDataText .WBSDescription AS WBSDescription,
  _AccountAssignmentType._Text [1: Language = $session.system_language].AccountAssignmentTypeName AS AccountAssignmentTypeName,
  _CashLedgerAccount._Text [1: Language = $session.system_language].GLAccountName AS GLAccountName,
  PurchasingOrganization,
  PurchasingGroup,
  PurchaseOrderType,
  PurchaseOrderCommitment.PurchaseOrderItemText AS DocumentItemText,
  cast (AmountInTransactionCurrency as fis_wsl_ll preserving type ) AS AmountInTransactionCurrency,
  cast(AmountInCompanyCodeCurrency as fis_hsl_ll preserving type ) AS AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  cast(AmountInGlobalCurrency as fis_ksl_ll preserving type ) AS AmountInGlobalCurrency,
  GlobalCurrency,
  IsCommitment,
  PurchaseOrderCommitment._FunctionalArea AS _FunctionalArea
FROM P_PurchaseOrderCommitment AS PurchaseOrderCommitment
LEFT OUTER JOIN I_MM_GLAccountVH AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MM_ControllingAreaVH AS _ControllingAreaValueHelp ON ControllingArea = _ControllingAreaValueHelp.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccountStdVH AS _PubSecBudgetAccountStd ON _PubSecBudgetAccountStd.PubSecBudgetAccount = PubSecBudgetAccount AND _PubSecBudgetAccountStd.PubSecBudgetAccountCoCode = PubSecBudgetAccountCoCode  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnType AS _PubSecBdgtCnsmpnType ON _PubSecBdgtCnsmpnType.PubSecBudgetCnsmpnType = PubSecBudgetCnsmpnType  -- association [0..1]
;

Depth:

C_PurchaseOrderCommitment view

P_PurchaseOrderCommitment view