C_ProfitCenterToSrvcOrderItem

DDL: C_PROFITCENTERTOSRVCORDERITEM Type: view_entity CONSUMPTION
42 Fields 1 Data Sources 4 Associations

Assgmt of PrftCtr to Service Order Item

C_ProfitCenterToSrvcOrderItem is a Consumption CDS View that provides data about "Assgmt of PrftCtr to Service Order Item" in SAP S/4HANA. It reads from 1 data source (I_PrftCtrToServiceDocumentItem) and exposes 42 fields with key fields OrganizationalChangeObjectType, ServiceDocumentType, ServiceDocument, ServiceDocumentItem, ValidityStartDate. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrftCtrToServiceDocumentItem _ProfitCenterToSrvcOrderItem from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_ProfitCenterText _ProfitCenterBfrOrglChangeText _ProfitCenterToSrvcOrderItem.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea and _ProfitCenterToSrvcOrderItem.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter and _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'
[0..*] I_ProfitCenterText _ProfitCenterByOrglChangeText _ProfitCenterToSrvcOrderItem.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea and _ProfitCenterToSrvcOrderItem.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter and _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'
[0..1] I_AcctgServiceDocumentItem _AcctgServiceDocumentItem _ProfitCenterToSrvcOrderItem.ServiceDocumentType = _AcctgServiceDocumentItem.ServiceDocumentType and _ProfitCenterToSrvcOrderItem.ServiceDocument = _AcctgServiceDocumentItem.ServiceDocument and _ProfitCenterToSrvcOrderItem.ServiceDocumentItem = _AcctgServiceDocumentItem.ServiceDocumentItem
[0..1] I_AcctgServiceDocumentItem _AcctgServiceDocumentItem1 _ProfitCenterToSrvcOrderItem.SourceServiceDocumentType = _AcctgServiceDocumentItem1.ServiceDocumentType and _ProfitCenterToSrvcOrderItem.SourceServiceDocument = _AcctgServiceDocumentItem1.ServiceDocument and _ProfitCenterToSrvcOrderItem.SourceServiceDocumentItem = _AcctgServiceDocumentItem1.ServiceDocumentItem

Annotations (8)

NameValueLevelField
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 Service Order Item view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChangeObjectType
KEY ServiceDocumentType ServiceDocumentType Transaction Type
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
KEY ValidityStartDate ValidityStartDate Validity Start Date
ServiceDocumentItemDescription _AcctgServiceDocumentItem ServiceDocumentItemDescription
ServiceDocumentDescription
ValidityEndDate ValidityEndDate ValidTo
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ProfitCenterBeforeOrglChange ProfitCenterBeforeOrglChange Old Profit Center
ProfitCenterByOrglChange ProfitCenter Profit Center
SegmentByOrglChange _ProfitCtr Segment Segment number
SegmentBeforeOrglChange _ProfitCenterBeforeOrglChange Segment Segment number
SegmentNameendasSegmentByOrglChangeName
OrganizationalChange OrganizationalChange Organizational Change
OrglChangeReassignmentStatus OrglChangeReassignmentStatus Status
ProfitCenterDerivationSrceType ProfitCenterDerivationSrceType Profit Center Source
ServiceObjectType ServiceObjectType Object Type
SourceServiceDocumentType SourceServiceDocumentType
SourceServiceDocument SourceServiceDocument
SourceServiceDocumentItem SourceServiceDocumentItem
SourceServiceDocumentItemDesc _AcctgServiceDocumentItem1 ServiceDocumentItemDescription
SourceServiceDocumentDesc
_OrglChgReassignmentStatus _OrglChgReassignmentStatus
_ProfitCtrDerivationSrceType _ProfitCtrDerivationSrceType
_ServiceDocumentType _ServiceDocumentType
_ServiceDocument _ServiceDocument
_ServiceDocumentItem _ServiceDocumentItem
_ServiceObjType _ServiceObjType
_OrglChange _OrglChange
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_ProfitCtr _ProfitCtr
OrglChangeEffectiveDate I_PrftCtrToServiceDocumentItem OrglChangeEffectiveDate Effective Date
OrglChgLastDateBeforeEffDate I_PrftCtrToServiceDocumentItem OrglChgLastDateBeforeEffDate
_ProfitCenterBeforeOrglChange _ProfitCenterBeforeOrglChange
_SourceServiceDocumentType _SourceServiceDocumentType
_AcctgServiceDocumentItem _AcctgServiceDocumentItem
_AcctgServiceDocumentItem1 _AcctgServiceDocumentItem1

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_ProfitCenterToSrvcOrderItem.
-- 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_ProfitCenterToSrvcOrderItem AS
SELECT
  'SV' AS OrganizationalChangeObjectType,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  ValidityStartDate,
  _AcctgServiceDocumentItem.ServiceDocumentItemDescription AS ServiceDocumentItemDescription,
  _AcctgServiceDocumentItem._ServiceDocument.ServiceDocumentDescription AS ServiceDocumentDescription,
  ValidityEndDate,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ProfitCenterBeforeOrglChange,
  ProfitCenter AS ProfitCenterByOrglChange,
  _ProfitCtr.Segment AS SegmentByOrglChange,
  _ProfitCenterBeforeOrglChange.Segment AS SegmentBeforeOrglChange,
  case when _ProfitCtr._Segment._Text[1:Language=$session.system_language].SegmentName is null then _ProfitCtr._Segment._Text[1:Language='E'].SegmentName else _ProfitCtr._Segment._Text[1:Language=$session.system_language].SegmentName end as SegmentByOrglChangeName AS SegmentNameendasSegmentByOrglChangeName,
  OrganizationalChange,
  OrglChangeReassignmentStatus,
  ProfitCenterDerivationSrceType,
  ServiceObjectType,
  SourceServiceDocumentType,
  SourceServiceDocument,
  SourceServiceDocumentItem,
  _AcctgServiceDocumentItem1.ServiceDocumentItemDescription AS SourceServiceDocumentItemDesc,
  _AcctgServiceDocumentItem1._ServiceDocument.ServiceDocumentDescription AS SourceServiceDocumentDesc,
  _ProfitCenterToSrvcOrderItem.OrglChangeEffectiveDate AS OrglChangeEffectiveDate,
  _ProfitCenterToSrvcOrderItem.OrglChgLastDateBeforeEffDate AS OrglChgLastDateBeforeEffDate
FROM I_PrftCtrToServiceDocumentItem AS _ProfitCenterToSrvcOrderItem
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterBfrOrglChangeText ON _ProfitCenterToSrvcOrderItem.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea AND _ProfitCenterToSrvcOrderItem.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter AND _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterByOrglChangeText ON _ProfitCenterToSrvcOrderItem.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea AND _ProfitCenterToSrvcOrderItem.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter AND _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_AcctgServiceDocumentItem AS _AcctgServiceDocumentItem ON _ProfitCenterToSrvcOrderItem.ServiceDocumentType = _AcctgServiceDocumentItem.ServiceDocumentType AND _ProfitCenterToSrvcOrderItem.ServiceDocument = _AcctgServiceDocumentItem.ServiceDocument AND _ProfitCenterToSrvcOrderItem.ServiceDocumentItem = _AcctgServiceDocumentItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentItem AS _AcctgServiceDocumentItem1 ON _ProfitCenterToSrvcOrderItem.SourceServiceDocumentType = _AcctgServiceDocumentItem1.ServiceDocumentType AND _ProfitCenterToSrvcOrderItem.SourceServiceDocument = _AcctgServiceDocumentItem1.ServiceDocument AND _ProfitCenterToSrvcOrderItem.SourceServiceDocumentItem = _AcctgServiceDocumentItem1.ServiceDocumentItem  -- association [0..1]
;

Learn More