What is C_ProfitCenterToSalesOrderItem in SAP S/4HANA?

C_ProfitCenterToSalesOrderItem is a consumption CDS view in SAP S/4HANA. Assgmt of PrftCtr to Sales Order Item It contains 48 fields.

Which tables does C_ProfitCenterToSalesOrderItem read from?

C_ProfitCenterToSalesOrderItem reads data from: I_ProfitCenterToSalesOrderItem.

What VDM layer is C_ProfitCenterToSalesOrderItem?

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

C_ProfitCenterToSalesOrderItem

DDL: C_PROFITCENTERTOSALESORDERITEM Type: view_entity CONSUMPTION

48 Fields 1 Data Sources 9 Associations

Assgmt of PrftCtr to Sales Order Item

C_ProfitCenterToSalesOrderItem is a Consumption CDS View that provides data about "Assgmt of PrftCtr to Sales Order Item" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenterToSalesOrderItem) and exposes 48 fields with key fields OrganizationalChangeObjectType, SalesDocument, SalesDocumentItem, ValidityStartDate. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ProfitCenterToSalesOrderItem	_ProfitCenterToSalesOrderItem	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..*]	I_ProfitCenterText	_ProfitCenterBfrOrglChangeText	`_ProfitCenterToSalesOrderItem.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea and _ProfitCenterToSalesOrderItem.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter and _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'`
[0..*]	I_ProfitCenterText	_ProfitCenterByOrglChangeText	`_ProfitCenterToSalesOrderItem.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea and _ProfitCenterToSalesOrderItem.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter and _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'`
[0..1]	I_WBSElementBasicData	_SourceWBSElement	`_ProfitCenterToSalesOrderItem.SourceWBSElementInternalID = _SourceWBSElement.WBSElementInternalID`
[0..1]	I_ProjectBasicData	_SourceProjectBasicData	`_ProfitCenterToSalesOrderItem.SourceProjectInternalID = _SourceProjectBasicData.ProjectInternalID`
[0..1]	I_CostCenter	_SourceCostCenter	`_ProfitCenterToSalesOrderItem.SourceCostCenter = _SourceCostCenter.CostCenter and _ProfitCenterToSalesOrderItem.ControllingArea = _SourceCostCenter.ControllingArea and _SourceCostCenter.ValidityEndDate = '99991231'`
[0..1]	I_Plant	_SourcePlant	`_ProfitCenterToSalesOrderItem.SourcePlant = _SourcePlant.Plant`
[0..1]	I_Product	_SourceProduct	`_ProfitCenterToSalesOrderItem.SourceProduct = _SourceProduct.Product`
[0..1]	I_OrderBasic	_SourceOrder	`_ProfitCenterToSalesOrderItem.SourceOrder = _SourceOrder.OrderID`
[0..1]	I_AcctgServiceDocumentItem	_AcctgServiceDocumentItem	`_ProfitCenterToSalesOrderItem.SourceServiceDocumentType = _AcctgServiceDocumentItem.ServiceDocumentType and _ProfitCenterToSalesOrderItem.SourceServiceDocument = _AcctgServiceDocumentItem.ServiceDocument and _ProfitCenterToSalesOrderItem.SourceServiceDocumentItem = _AcctgServiceDocumentItem.ServiceDocumentItem`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
Metadata.allowExtensions	true	view
VDM.viewType	#CONSUMPTION	view
EndUserText.label	Assgmt of PrftCtr to Sales Order Item	view

Fields (48)

Key	Field	Source Table	Source Field	Description
KEY	OrganizationalChangeObjectType
KEY	SalesDocument		SalesDocument	SD Document
KEY	SalesDocumentItem		SalesDocumentItem	Sales Document Item
KEY	ValidityStartDate		ValidityStartDate	Validity Start Date
	ValidityEndDate		ValidityEndDate	ValidTo
	ControllingArea		ControllingArea	Controlling Area
	ControllingAreaName	_ControllingArea	ControllingAreaName	Long Text
	SalesDocumentItemText	_SalesDocumentItem	SalesDocumentItemText	Item Descr.
	CompanyCode		CompanyCode	Receiver Company Code
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	ProfitCenterBeforeOrglChange		ProfitCenterBeforeOrglChange	Old Profit Center
	ProfitCenterByOrglChange		ProfitCenter	Profit Center
	OrganizationalChange		OrganizationalChange	Organizational Change
	OrglChangeReassignmentStatus		OrglChangeReassignmentStatus	Status
	ProfitCenterDerivationSrceType		ProfitCenterDerivationSrceType	Profit Center Source
	SourceProduct		SourceProduct	Source Product
	ProductNameendasSourceProductName
	SourcePlant		SourcePlant	Source Plant
	SourcePlantName	_SourcePlant	PlantName	Plant Name
	SourceOrder		SourceOrder
	SourceOrderName	_SourceOrder	OrderDescription
	SourceCostCenter		SourceCostCenter
	CostCenterNameendasSourceCostCenterName
	SourceWBSElementExternalID	_SourceWBSElement	WBSElementExternalID	WBS Element External ID
	SourceWBSElementDescription	_SourceWBSElement	WBSDescription	WBS Element Name
	SourceProjectExternalID	_SourceProjectBasicData	ProjectExternalID	Project def.
	SourceProjectDescription	_SourceProjectBasicData	ProjectDescription	Project Name
	SegmentByOrglChange		SegmentByOrglChange	Segment number
	SegmentBeforeOrglChange		SegmentBeforeOrglChange
	SegmentNameendasSegmentByOrglChangeName
	SourceServiceDocumentType		SourceServiceDocumentType
	SourceServiceDocument		SourceServiceDocument
	SourceServiceDocumentItem		SourceServiceDocumentItem
	SourceServiceDocumentItemDesc	_AcctgServiceDocumentItem	ServiceDocumentItemDescription
	SourceServiceDocumentDesc
	OrglChangeEffectiveDate	I_ProfitCenterToSalesOrderItem	OrglChangeEffectiveDate	Effective Date
	OrglChgLastDateBeforeEffDate	I_ProfitCenterToSalesOrderItem	OrglChgLastDateBeforeEffDate
	_OrglChgReassignmentStatus		_OrglChgReassignmentStatus
	_ProfitCtrDerivationSrceType		_ProfitCtrDerivationSrceType
	_SalesDocument		_SalesDocument
	_SalesDocumentItem		_SalesDocumentItem
	_SourceServiceDocumentType		_SourceServiceDocumentType
	_OrglChange		_OrglChange
	_CompanyCode		_CompanyCode
	_ControllingArea		_ControllingArea
	_ProfitCtr		_ProfitCtr
	_ProfitCenterBeforeOrglChange		_ProfitCenterBeforeOrglChange
	_AcctgServiceDocumentItem		_AcctgServiceDocumentItem

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_ProfitCenterToSalesOrderItem.
-- 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.

CREATE VIEW C_ProfitCenterToSalesOrderItem AS
SELECT
  'VB' AS OrganizationalChangeObjectType,
  SalesDocument,
  SalesDocumentItem,
  ValidityStartDate,
  ValidityEndDate,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ProfitCenterBeforeOrglChange,
  ProfitCenter AS ProfitCenterByOrglChange,
  OrganizationalChange,
  OrglChangeReassignmentStatus,
  ProfitCenterDerivationSrceType,
  SourceProduct,
  case when _SourceProduct._Text[1:Language=$session.system_language].ProductName is null then _SourceProduct._Text[1:Language='E'].ProductName else _SourceProduct._Text[1:Language=$session.system_language].ProductName end as SourceProductName AS ProductNameendasSourceProductName,
  SourcePlant,
  _SourcePlant.PlantName AS SourcePlantName,
  SourceOrder,
  _SourceOrder.OrderDescription AS SourceOrderName,
  SourceCostCenter,
  case when _SourceCostCenter._Text[1:Language=$session.system_language].CostCenterName is null then _SourceCostCenter._Text[1:Language='E'].CostCenterName else _SourceCostCenter._Text[1:Language=$session.system_language].CostCenterName end as SourceCostCenterName AS CostCenterNameendasSourceCostCenterName,
  _SourceWBSElement.WBSElementExternalID AS SourceWBSElementExternalID,
  _SourceWBSElement.WBSDescription AS SourceWBSElementDescription,
  _SourceProjectBasicData.ProjectExternalID AS SourceProjectExternalID,
  _SourceProjectBasicData.ProjectDescription AS SourceProjectDescription,
  SegmentByOrglChange,
  SegmentBeforeOrglChange,
  case when _SegmentByOrglChange._Text[1:Language=$session.system_language].SegmentName is null then _SegmentByOrglChange._Text[1:Language='E'].SegmentName else _SegmentByOrglChange._Text[1:Language=$session.system_language].SegmentName end as SegmentByOrglChangeName AS SegmentNameendasSegmentByOrglChangeName,
  SourceServiceDocumentType,
  SourceServiceDocument,
  SourceServiceDocumentItem,
  _AcctgServiceDocumentItem.ServiceDocumentItemDescription AS SourceServiceDocumentItemDesc,
  _AcctgServiceDocumentItem._ServiceDocument.ServiceDocumentDescription AS SourceServiceDocumentDesc,
  _ProfitCenterToSalesOrderItem.OrglChangeEffectiveDate AS OrglChangeEffectiveDate,
  _ProfitCenterToSalesOrderItem.OrglChgLastDateBeforeEffDate AS OrglChgLastDateBeforeEffDate
FROM I_ProfitCenterToSalesOrderItem AS _ProfitCenterToSalesOrderItem
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterBfrOrglChangeText ON _ProfitCenterToSalesOrderItem.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea AND _ProfitCenterToSalesOrderItem.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter AND _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterByOrglChangeText ON _ProfitCenterToSalesOrderItem.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea AND _ProfitCenterToSalesOrderItem.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter AND _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _SourceWBSElement ON _ProfitCenterToSalesOrderItem.SourceWBSElementInternalID = _SourceWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _SourceProjectBasicData ON _ProfitCenterToSalesOrderItem.SourceProjectInternalID = _SourceProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _SourceCostCenter ON _ProfitCenterToSalesOrderItem.SourceCostCenter = _SourceCostCenter.CostCenter AND _ProfitCenterToSalesOrderItem.ControllingArea = _SourceCostCenter.ControllingArea AND _SourceCostCenter.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SourcePlant ON _ProfitCenterToSalesOrderItem.SourcePlant = _SourcePlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _SourceProduct ON _ProfitCenterToSalesOrderItem.SourceProduct = _SourceProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_OrderBasic AS _SourceOrder ON _ProfitCenterToSalesOrderItem.SourceOrder = _SourceOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentItem AS _AcctgServiceDocumentItem ON _ProfitCenterToSalesOrderItem.SourceServiceDocumentType = _AcctgServiceDocumentItem.ServiceDocumentType AND _ProfitCenterToSalesOrderItem.SourceServiceDocument = _AcctgServiceDocumentItem.ServiceDocument AND _ProfitCenterToSalesOrderItem.SourceServiceDocumentItem = _AcctgServiceDocumentItem.ServiceDocumentItem  -- association [0..1]
;

Depth:

C_ProfitCenterToSalesOrderItem view_entity

I_ProfitCenterToSalesOrderItem view