What is C_PurOrdMaintainHeader in SAP S/4HANA?

C_PurOrdMaintainHeader is a consumption CDS view in SAP S/4HANA. PO Maintenance: Purchase Order Headers (Active + Draft) It contains 66 fields.

Which tables does C_PurOrdMaintainHeader read from?

C_PurOrdMaintainHeader reads data from: P_PurOrdMaintainHeaderAll.

What VDM layer is C_PurOrdMaintainHeader?

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

C_PurOrdMaintainHeader

DDL: C_PURORDMAINTAINHEADER SQL: CPOMAINTHDR Type: view CONSUMPTION

66 Fields 1 Data Sources 12 Associations

PO Maintenance: Purchase Order Headers (Active + Draft)

C_PurOrdMaintainHeader is a Consumption CDS View that provides data about "PO Maintenance: Purchase Order Headers (Active + Draft)" in SAP S/4HANA. It reads from 1 data source (P_PurOrdMaintainHeaderAll) and exposes 66 fields with key fields ID, PurchaseOrder, PurchaseOrderHeaderDraftUUID. It has 12 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_PurOrdMaintainHeaderAll	PurchaseOrderHeaders	from

Associations (12)

Cardinality	Target	Alias	Condition
[1..*]	C_PurOrdMaintainItem	_PurOrdMaintainItem	`$projection.PurchaseOrder = _PurOrdMaintainItem.PurchaseOrder and $projection.PurchaseOrderHeaderDraftUUID = _PurOrdMaintainItem.PurchaseOrderHeaderDraftUUID`
[0..*]	I_PurchasingDocumentTypeText	_PurchasingDocumentTypeText	`$projection.PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType and $projection.PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory`
[0..*]	I_PurchasingDocumentStatusText	_StatusText	`$projection.PurchasingDocumentStatus = _StatusText.PurchasingDocumentStatus`
[0..*]	I_IncotermsClassificationText	_IncotermsClassificationText	`$projection.IncotermsClassification = _IncotermsClassificationText.IncotermsClassification`
[0..*]	I_IncotermsVersionText	_IncotermsVersionText	`$projection.IncotermsVersion = _IncotermsVersionText.IncotermsVersion`
[0..*]	I_CountryText	_CountryText	`$projection.AddressCountry = _CountryText.Country`
[0..*]	I_RegionText	_RegionText	`$projection.AddressRegion = _RegionText.Region and $projection.AddressCountry = _RegionText.Country`
[0..1]	C_PurOrdMaintainHeader	_PurOrdMaintainHeader	`$projection.PurchaseOrder = _PurOrdMaintainHeader.PurchaseOrder and $projection.PurchaseOrderHeaderDraftUUID = _PurOrdMaintainHeader.PurchaseOrderHeaderDraftUUID and $projection.PurchaseOrder = _PurOrdMaintainHeader.PurchaseOrder`
[0..1]	E_PurchasingDocument	_PurDocHeaderExtension	`$projection.PurchaseOrder = _PurDocHeaderExtension.PurchasingDocument`
[0..1]	E_PurchasingDocumentDraft	_PurDocHeaderDraftExtension	`$projection.PurchaseOrderHeaderDraftUUID = _PurDocHeaderDraftExtension.PurchaseOrderHeaderDraftUUID`
[0..1]	P_PurOrdMaintDraftAdminData	_PurOrdMaintDraftAdminData	`_PurOrdMaintDraftAdminData.EntityName = 'MM_PO_DRAFT' and ( PurchaseOrderHeaders.PurchaseOrderHeaderDraftUUID = _PurOrdMaintDraftAdminData.ID and PurchaseOrderHeaders.EditState = '3' ) or( PurchaseOrderHeaders.TwinPurchaseOrderHdrDraftUUID = _PurOrdMaintDraftAdminData.ID and PurchaseOrderHeaders.EditState = '2' )`
[0..1]	I_DraftAdministrativeData	_DraftAdministrativeData	`_DraftAdministrativeData.DraftEntityType = 'MM_PO_DRAFT' and PurchaseOrderHeaders.IsDraft = 'X' and ( PurchaseOrderHeaders.DraftUUID = _DraftAdministrativeData.DraftUUID ) or( PurchaseOrderHeaders.TwinUUID = _DraftAdministrativeData.DraftUUID and PurchaseOrderHeaders.HasTwin = 'X' )`

Annotations (9)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.sqlViewName	CPOMAINTHDR	view
EndUserText.label	PO Maintenance: Purchase Order Headers (Active + Draft)	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (66)

Key	Field	Source Field	Description
KEY	ID	ID	WorklistID
KEY	PurchaseOrder	PurchaseOrder	Purchasing Document
KEY	PurchaseOrderHeaderDraftUUID	PurchaseOrderHeaderDraftUUID
	DraftUUID	DraftUUID	UUID
	PurchasingDocumentCategory	PurchasingDocumentCategory	Doc. Category
	PurchasingDocumentType	PurchasingDocumentType	RFQ Type
	CompanyCode	CompanyCode	Receiver Company Code
	CompanyCodeName	CompanyCodeName	Company Name
	PurchasingOrganization	PurchasingOrganization	Purchasing Organization
	PurchasingOrganizationName	PurchasingOrganizationName	Purch. Org. Name
	PurchasingGroup	PurchasingGroup	Purchasing Group
	PurchasingGroupName	PurchasingGroupName	Purchasing Grp. Name
	Supplier	Supplier	Supplier
	SupplierName	SupplierName	Supplier Name
	Currency	Currency	Valuation Crcy
	PaymentTerms	PaymentTerms	Pyt Terms
	CashDiscount1Days	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	CashDiscount2Days	Days from Baseline Date for Payment
	NetPaymentDays	NetPaymentDays	Net Pmt Terms Period
	CashDiscount1Percent	CashDiscount1Percent	Disc. Percent 1
	CashDiscount2Percent	CashDiscount2Percent	Disc. Percent 2
	ExchangeRate	ExchangeRate	Exchange rate
	IncotermsClassification	IncotermsClassification	Incoterms
	IncotermsTransferLocation	IncotermsTransferLocation	Incoterms 2
	IncotermsVersion	IncotermsVersion	Inco. Version
	IncotermsLocation1	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	IncotermsLocation2	Inco. Location2
	CreatedByUser	CreatedByUser	User Name
	PurchaseOrderDate	PurchaseOrderDate	PO Date
	LastChangeDateTime	LastChangeDateTime	Timestamp
	LastChangeUser	LastChangeUser	User Name
	InvoicingParty	InvoicingParty	Supplier
	InvoicingPartyName	InvoicingPartyName	Supplier Name
	ReleaseIsNotCompleted	ReleaseIsNotCompleted	Subj.to Release
	IsHeld	IsHeld
	NumberOfItems	NumberOfItems
	PurchaseOrderNetAmount	PurchaseOrderNetAmount	Net Value
	PurchasingDocumentStatus	PurchasingDocumentStatus	Short Description
	EditState	EditState
	IsDraft	IsDraft
	HasTwin	HasTwin
	TwinPurchaseOrderHdrDraftUUID	TwinPurchaseOrderHdrDraftUUID
	TwinUUID	TwinUUID
	PurchasingDocumentCondition	PurchasingDocumentCondition	Doc. Condition
	PricingProcedure	PricingProcedure	Procedure
	AddressID	AddressID	Ship-to address
	AddressName	AddressName	Name
	AddressStreetName	AddressStreetName	Street
	AddressHouseNumber	AddressHouseNumber	House Number
	AddressPostalCode	AddressPostalCode	Postal Code
	AddressCityName	AddressCityName	City
	AddressPhoneNumber	AddressPhoneNumber
	AddressFaxNumber	AddressFaxNumber	Fax
	AddressRegion	AddressRegion	Region
	AddressCountry	AddressCountry	Country/Reg.
	AddressCorrespondenceLanguage	AddressCorrespondenceLanguage	Language
	IsActiveEntity	IsActiveEntity	Is active
	_PurOrdMaintainItem	_PurOrdMaintainItem
	_PurchasingDocumentTypeText	_PurchasingDocumentTypeText
	_StatusText	_StatusText
	_IncotermsClassificationText	_IncotermsClassificationText
	_IncotermsVersionText	_IncotermsVersionText
	_CountryText	_CountryText
	_RegionText	_RegionText
	_PurOrdMaintainHeader	_PurOrdMaintainHeader
	_DraftAdministrativeData	_DraftAdministrativeData

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_PurOrdMaintainHeader.
-- 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: CPOMAINTHDR

CREATE VIEW C_PurOrdMaintainHeader AS
SELECT
  ID,
  PurchaseOrder,
  PurchaseOrderHeaderDraftUUID,
  DraftUUID,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  CompanyCode,
  CompanyCodeName,
  PurchasingOrganization,
  PurchasingOrganizationName,
  PurchasingGroup,
  PurchasingGroupName,
  Supplier,
  SupplierName,
  Currency,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  ExchangeRate,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  CreatedByUser,
  PurchaseOrderDate,
  LastChangeDateTime,
  LastChangeUser,
  InvoicingParty,
  InvoicingPartyName,
  ReleaseIsNotCompleted,
  IsHeld,
  NumberOfItems,
  PurchaseOrderNetAmount,
  PurchasingDocumentStatus,
  EditState,
  IsDraft,
  HasTwin,
  TwinPurchaseOrderHdrDraftUUID,
  TwinUUID,
  PurchasingDocumentCondition,
  PricingProcedure,
  AddressID,
  AddressName,
  AddressStreetName,
  AddressHouseNumber,
  AddressPostalCode,
  AddressCityName,
  AddressPhoneNumber,
  AddressFaxNumber,
  AddressRegion,
  AddressCountry,
  AddressCorrespondenceLanguage,
  IsActiveEntity
FROM P_PurOrdMaintainHeaderAll AS PurchaseOrderHeaders
LEFT OUTER JOIN C_PurOrdMaintainItem AS _PurOrdMaintainItem ON PurchaseOrder = _PurOrdMaintainItem.PurchaseOrder AND PurchaseOrderHeaderDraftUUID = _PurOrdMaintainItem.PurchaseOrderHeaderDraftUUID  -- association [1..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType AND PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentStatusText AS _StatusText ON PurchasingDocumentStatus = _StatusText.PurchasingDocumentStatus  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN I_IncotermsVersionText AS _IncotermsVersionText ON IncotermsVersion = _IncotermsVersionText.IncotermsVersion  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CountryText ON AddressCountry = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_RegionText AS _RegionText ON AddressRegion = _RegionText.Region AND AddressCountry = _RegionText.Country  -- association [0..*]
LEFT OUTER JOIN C_PurOrdMaintainHeader AS _PurOrdMaintainHeader ON PurchaseOrder = _PurOrdMaintainHeader.PurchaseOrder AND PurchaseOrderHeaderDraftUUID = _PurOrdMaintainHeader.PurchaseOrderHeaderDraftUUID AND PurchaseOrder = _PurOrdMaintainHeader.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _PurDocHeaderExtension ON PurchaseOrder = _PurDocHeaderExtension.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentDraft AS _PurDocHeaderDraftExtension ON PurchaseOrderHeaderDraftUUID = _PurDocHeaderDraftExtension.PurchaseOrderHeaderDraftUUID  -- association [0..1]
LEFT OUTER JOIN P_PurOrdMaintDraftAdminData AS _PurOrdMaintDraftAdminData ON _PurOrdMaintDraftAdminData.EntityName = 'MM_PO_DRAFT' AND ( PurchaseOrderHeaders.PurchaseOrderHeaderDraftUUID = _PurOrdMaintDraftAdminData.ID AND PurchaseOrderHeaders.EditState = '3' ) OR( PurchaseOrderHeaders.TwinPurchaseOrderHdrDraftUUID = _PurOrdMaintDraftAdminData.ID AND PurchaseOrderHeaders.EditState = '2' )  -- association [0..1]
LEFT OUTER JOIN I_DraftAdministrativeData AS _DraftAdministrativeData ON _DraftAdministrativeData.DraftEntityType = 'MM_PO_DRAFT' AND PurchaseOrderHeaders.IsDraft = 'X' AND ( PurchaseOrderHeaders.DraftUUID = _DraftAdministrativeData.DraftUUID ) OR( PurchaseOrderHeaders.TwinUUID = _DraftAdministrativeData.DraftUUID AND PurchaseOrderHeaders.HasTwin = 'X' )  -- association [0..1]
;

Depth:

C_PurOrdMaintainHeader view

P_PurOrdMaintainHeaderAll view