What is C_ServiceMgmtOvPgGlobalFltr in SAP S/4HANA?

C_ServiceMgmtOvPgGlobalFltr is a consumption CDS view in SAP S/4HANA. Query view for Service management filter It contains 41 fields.

Which tables does C_ServiceMgmtOvPgGlobalFltr read from?

C_ServiceMgmtOvPgGlobalFltr reads data from: I_ServiceDocumentEnhcd.

What VDM layer is C_ServiceMgmtOvPgGlobalFltr?

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

C_ServiceMgmtOvPgGlobalFltr

DDL: C_SERVICEMGMTOVPGGLOBALFLTR Type: view CONSUMPTION

41 Fields 1 Data Sources 9 Associations

Query view for Service management filter

C_ServiceMgmtOvPgGlobalFltr is a Consumption CDS View that provides data about "Query view for Service management filter" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentEnhcd) and exposes 41 fields with key fields ServiceObjectType, ServiceDocument. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ServiceDocumentEnhcd	I_ServiceDocumentEnhcd	from

Parameters (1)

Name	Type	Default
P_DisplayCurrency	displaycurrency

Associations (9)

Cardinality	Target	Alias	Condition
[0..1]	C_Dischannelvaluehelp	_DistributionChannel	`$projection.SalesOrganization = _DistributionChannel.SalesOrganization and $projection.DistributionChannel = _DistributionChannel.DistributionChannel`
[0..1]	C_OrgDivisionValueHelp	_OrganizationDivision	`$projection.SalesOrganization = _OrganizationDivision.SalesOrganization and $projection.DistributionChannel = _OrganizationDivision.DistributionChannel and $projection.Division = _OrganizationDivision.Division`
[0..1]	C_SalesOfficeValueHelp	_SalesOffice	`$projection.SalesOrganization = _SalesOffice.SalesOrganization and $projection.DistributionChannel = _SalesOffice.DistributionChannel and $projection.Division = _SalesOffice.OrganizationDivision and $projection.SalesOffice = _SalesOffice.SalesOffice`
[0..1]	C_SalesGroupValueHelp	_SalesGroup	`$projection.SalesOffice = _SalesGroup.SalesOffice and $projection.SalesGroup = _SalesGroup.SalesGroup`
[0..1]	E_ServiceDocument	_ServiceDocumentExt	`$projection.ServiceObjectType = _ServiceDocumentExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocumentExt.ServiceOrder`
[0..1]	C_DischannelOrgUnitVH	_OrgUnitDistributionChannel	`$projection.SalesOrganizationOrgUnitID = _OrgUnitDistributionChannel.OrganizationalUnit and $projection.OrgUnitDistributionChannel = _OrgUnitDistributionChannel.OrgUnitDistributionChannel`
[0..1]	C_SalesOrgDivisionVH	_SalesOrganizationDivision	`$projection.SalesOrganizationOrgUnitID = _SalesOrganizationDivision.OrganizationalUnit and $projection.OrgUnitDistributionChannel = _SalesOrganizationDivision.DistributionChannel and $projection.OrgUnitDivision = _SalesOrganizationDivision.OrgUnitDivision`
[0..1]	C_SalesOfficeOrgUnitVH	_SalesOfficeOrgUnit	`$projection.SalesOrganizationOrgUnitID = _SalesOfficeOrgUnit.OrganizationalUnit and $projection.OrgUnitDistributionChannel = _SalesOfficeOrgUnit.DistributionChannel and $projection.OrgUnitDivision = _SalesOfficeOrgUnit.Division and $projection.SalesOfficeOrgUnitID = _SalesOfficeOrgUnit.SalesOfficeOrgUnitID`
[0..1]	C_SalesGroupOrgUnitVH	_SalesGroupOrgUnit	`$projection.SalesOfficeOrgUnitID = _SalesGroupOrgUnit.SalesOfficeOrgUnitID and $projection.SalesGroupOrgUnitID = _SalesGroupOrgUnit.SalesGroupOrgUnitID`

Annotations (11)

Name	Value	Level
EndUserText.label	Query view for Service management filter	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	CSERVMGTGLBFLTR	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view

Fields (41)

Key	Field	Source Table	Source Field	Description
KEY	ServiceObjectType		ServiceObjectType	Object Type
KEY	ServiceDocument		ServiceDocument	Transaction ID
	ServiceOrderType		ServiceDocumentType	Service Order Type
	_ServiceDocumentType		_ServiceDocumentType
	SalesOrganization		SalesOrganization	Sales Organization
	_SalesOrganization		_SalesOrganization
	SalesOrganizationOrgUnitID		SalesOrganizationOrgUnitID
	_SalesOrganizationOrgUnit		_SalesOrganizationOrgUnit
	DistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
	_DistributionChannel		_DistributionChannel
	Division		Division	Internal Division ID
	_Division		_Division
	_OrganizationDivision		_OrganizationDivision
	SalesOffice		SalesOffice	Sales Office
	_SalesOffice		_SalesOffice
	SalesGroup		SalesGroup	Sales Group
	_SalesGroup		_SalesGroup
	SalesOfficeOrgUnitID		SalesOfficeOrgUnitID
	SalesGroupOrgUnitID		SalesGroupOrgUnitID
	OrgUnitDistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
	OrgUnitDivision		Division	Internal Division ID
	ServiceOrganization		ServiceOrganization
	ResponsibleEmployee		ResponsibleEmployee	Employee Resp.
	TeamName	_ServiceTeamHeader	TeamName	Service Team
	RespyMgmtServiceTeam		RespyMgmtServiceTeam
	RespEmployeeBusinessPartnerId		ResponsibleEmployee	Responsible Employee
	ContactPersonBusinessPartnerId		ContactPerson	Contact Person
	RefBusinessSolutionOrder		RefBusinessSolutionOrder	Solution Order
	SoldToParty		SoldToParty	Sold-To Party
	_SalesOfficeOrgUnit		_SalesOfficeOrgUnit
	_SalesGroupOrgUnit		_SalesGroupOrgUnit
	_SalesOrganizationOrgUnit_2		_SalesOrganizationOrgUnit_2
	_SalesOfficeOrgUnit_2		_SalesOfficeOrgUnit_2
	_SalesGroupOrgUnit_2		_SalesGroupOrgUnit_2
	_SalesOrganizationDivision		_SalesOrganizationDivision
	_OrgUnitDistributionChannel		_OrgUnitDistributionChannel
	_ServiceObjType		_ServiceObjType
	_RespEmployee		_RespEmployee
	_ContactPerson		_ContactPerson
	_SoldToParty		_SoldToParty
	_ServiceTeamHeader		_ServiceTeamHeader

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_ServiceMgmtOvPgGlobalFltr.
-- 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.
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW C_ServiceMgmtOvPgGlobalFltr AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentType AS ServiceOrderType,
  SalesOrganization,
  SalesOrganizationOrgUnitID,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  DistributionChannel AS OrgUnitDistributionChannel,
  Division AS OrgUnitDivision,
  ServiceOrganization,
  ResponsibleEmployee,
  _ServiceTeamHeader.TeamName AS TeamName,
  RespyMgmtServiceTeam,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  ContactPerson AS ContactPersonBusinessPartnerId,
  RefBusinessSolutionOrder,
  SoldToParty
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN C_Dischannelvaluehelp AS _DistributionChannel ON SalesOrganization = _DistributionChannel.SalesOrganization AND DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_OrgDivisionValueHelp AS _OrganizationDivision ON SalesOrganization = _OrganizationDivision.SalesOrganization AND DistributionChannel = _OrganizationDivision.DistributionChannel AND Division = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOfficeValueHelp AS _SalesOffice ON SalesOrganization = _SalesOffice.SalesOrganization AND DistributionChannel = _SalesOffice.DistributionChannel AND Division = _SalesOffice.OrganizationDivision AND SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupValueHelp AS _SalesGroup ON SalesOffice = _SalesGroup.SalesOffice AND SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceDocument = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN C_DischannelOrgUnitVH AS _OrgUnitDistributionChannel ON SalesOrganizationOrgUnitID = _OrgUnitDistributionChannel.OrganizationalUnit AND OrgUnitDistributionChannel = _OrgUnitDistributionChannel.OrgUnitDistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_SalesOrgDivisionVH AS _SalesOrganizationDivision ON SalesOrganizationOrgUnitID = _SalesOrganizationDivision.OrganizationalUnit AND OrgUnitDistributionChannel = _SalesOrganizationDivision.DistributionChannel AND OrgUnitDivision = _SalesOrganizationDivision.OrgUnitDivision  -- association [0..1]
LEFT OUTER JOIN C_SalesOfficeOrgUnitVH AS _SalesOfficeOrgUnit ON SalesOrganizationOrgUnitID = _SalesOfficeOrgUnit.OrganizationalUnit AND OrgUnitDistributionChannel = _SalesOfficeOrgUnit.DistributionChannel AND OrgUnitDivision = _SalesOfficeOrgUnit.Division AND SalesOfficeOrgUnitID = _SalesOfficeOrgUnit.SalesOfficeOrgUnitID  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupOrgUnitVH AS _SalesGroupOrgUnit ON SalesOfficeOrgUnitID = _SalesGroupOrgUnit.SalesOfficeOrgUnitID AND SalesGroupOrgUnitID = _SalesGroupOrgUnit.SalesGroupOrgUnitID  -- association [0..1]
;

Depth:

C_ServiceMgmtOvPgGlobalFltr view

I_ServiceDocumentEnhcd view