What is C_SrvcConfRelBillgListRpt in SAP S/4HANA?

C_SrvcConfRelBillgListRpt is a consumption CDS view in SAP S/4HANA. View for Items Released for Billing It contains 65 fields.

What VDM layer is C_SrvcConfRelBillgListRpt?

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

C_SrvcConfRelBillgListRpt

DDL: C_SRVCCONFRELBILLGLISTRPT SQL: CSRVCCONFBILLG Type: view CONSUMPTION

65 Fields 8 Associations

View for Items Released for Billing

C_SrvcConfRelBillgListRpt is a Consumption CDS View that provides data about "View for Items Released for Billing" in SAP S/4HANA. It has 8 associations to related views.

Associations (8)

Cardinality	Target	Alias	Condition
[0..1]	I_ServiceDocumentStatus	_ServiceOrderItemStatus	`$projection.ServiceOrderStatus = _ServiceOrderItemStatus.ServiceDocumentStatus`
[0..1]	I_ServiceDocumentStatus	_ServiceConfItemStatus	`$projection.ServiceConfirmationStatus = _ServiceConfItemStatus.ServiceDocumentStatus`
[0..1]	C_ServiceDocumentSoldToPartyVH	_SoldToParty	`$projection.SoldToParty = _SoldToParty.BusinessPartner`
[0..1]	C_SrvcDocBusinessPartnerVH	_ServiceTeam	`$projection.ServiceTeam = _ServiceTeam.BusinessPartner`
[0..1]	E_ServiceDocumentItem	_ServiceDocItemExt	`$projection.ServiceObjectType = _ServiceDocItemExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocItemExt.ServiceOrderItem and $projection.ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID`
[0..1]	I_CustMgmtLifecycleUserStsText	_SrvcOrdLifecycleUserStsText	`$projection.ServiceOrderStatus = _SrvcOrdLifecycleUserStsText.CustMgmtLifecycleUserStatus and _SrvcOrdLifecycleUserStsText.Language = $session.system_language`
[0..1]	I_CustMgmtLifecycleUserStsText	_SrvConfLifecycleUserStsText	`$projection.ServiceConfirmationStatus = _SrvConfLifecycleUserStsText.CustMgmtLifecycleUserStatus and _SrvConfLifecycleUserStsText.Language = $session.system_language`
[0..1]	C_SrvcOrdSrvcConfDocTypeVH	_SrvcOrdSrvcConfDocTypeVH	`$projection.ServiceDocumentType = _SrvcOrdSrvcConfDocTypeVH.ServiceDocumentType`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CSRVCCONFBILLG	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	View for Items Released for Billing	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Search.searchable	true	view
UI.headerInfo.typeName	Item Pending Release	view
UI.headerInfo.typeNamePlural	Items Pending Release	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.representativeKey	ServiceDocument	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view

Fields (65)

Key	Field	Source Table	Source Field	Description
KEY	ServiceDocument	ServiceDocumentItem	ServiceDocument	Transaction ID
KEY	ServiceDocumentItem	ServiceDocumentItem	ServiceDocumentItem	Item Number
KEY	ServiceDocumentItemCharUUID	ServiceDocumentItem	ServiceDocumentItemCharUUID
KEY	ServiceConfirmation		ServiceConfirmation	Service Confirmation ID
KEY	ServiceOrder		ServiceOrder	Service Order ID
	ServiceDocumentUUID		ServiceDocumentUUID	Object GUID
	ServiceDocumentItemObjectType	ServiceDocumentItem	ServiceDocumentItemObjectType
	ServiceDocumentType	ServiceDocumentItem	ServiceDocumentType	Billed Transaction Type
	ServiceObjectType		ServiceObjectType	Object Type
	PostingDate	ServiceDocumentItem	PostingDate	Posting Date for GR
	SoldToParty	ServiceDocumentItem	SoldToParty	Sold-To Party
	FirstName	_SoldToParty	FirstName	First Name
	LastName	_SoldToParty	LastName	Last Name
	GroupBusinessPartnerName1	_SoldToParty	GroupBusinessPartnerName1	Name 1
	GroupBusinessPartnerName2	_SoldToParty	GroupBusinessPartnerName2	Name 2
	OrganizationBPName1	_SoldToParty	OrganizationBPName1	Name 1
	OrganizationBPName2	_SoldToParty	OrganizationBPName2	Name 2
	ServiceTeam	ServiceDocumentItem	ServiceTeam
	ServiceConfItemCreationDate		ServiceConfItemCreationDate	Created On
	OriginallyRequestedProduct	ServiceDocumentItem	OriginallyRequestedProduct	Product ID
	ServiceConfItemDescription		ServiceConfItemDescription	Product Description
	ServiceOrderStatus		ServiceOrderStatus	Service Order Status
	StatusProfile	_ServiceDocumentType	StatusProfile	Status Profile
	ServiceOrdErrorStsCriticality		ServiceOrdErrorStsCriticality
	ResponsibleServiceOrganization	ServiceDocumentItem	ResponsibleServiceOrganization	Service Organization
	ServiceDocumentItemStatus	ServiceDocumentItem	ServiceDocumentItemStatus	Billed Item Status
	ServiceDocumentItemStatusName
	ServiceDocItemStatusCritlty		ServiceDocItemStatusCritlty
	PurchaseOrderByCustomer	ServiceDocumentItem	PurchaseOrderByCustomer	External Number
	ServiceConfirmationStatus		ServiceConfirmationStatus	Service Confirmation Status
	TransactionCurrency		TransactionCurrency	Transaction Currency
	ServiceDocItemGrossAmount		ServiceDocItemGrossAmount	Gross Amount
	ResponsibleEmployee		ResponsibleEmployee	Employee Resp.
	SalesOrganization		SalesOrganization	Sales Organization
	DistributionChannel		DistributionChannel	Distribution Channel
	Division		Division	Division
	SalesOffice		SalesOffice	Sales Office
	SalesGroup		SalesGroup	Sales Group
	SalesOrganizationOrgUnitID		SalesOrganizationOrgUnitID
	SalesOfficeOrgUnitID		SalesOfficeOrgUnitID
	SalesGroupOrgUnitID		SalesGroupOrgUnitID
	ServiceOrganization		ServiceOrganization
	ServiceConfErrorStsCriticality		ServiceConfErrorStsCriticality
	ServiceDocItemBillingStatus	ServiceDocumentItem	ServiceDocItemBillingStatus
	SrvcDocItmIsReleasedForBilling	ServiceDocumentItem	SrvcDocItmIsReleasedForBilling
	ParentServiceDocumentItemUUID		ParentServiceDocumentItemUUID
	ServiceDocumentCharUUID		ServiceDocumentCharUUID
	SrvcOrderConfirmationRelevance		SrvcOrderConfirmationRelevance
	ParentSrvcOrdItmConfRelevance		ParentSrvcOrdItmConfRelevance
	ParentServiceDocumentItem		ParentServiceDocumentItem	Higher-Level Item
	ServiceOrderType		ServiceOrderType
	SrvcDocItemIsBundle		SrvcDocItemIsBundle
	_SoldToParty		_SoldToParty
	_ServiceTeam		_ServiceTeam
	_ServiceDocItemStatus		_ServiceDocItemStatus
	_SrvcDocItmLifecycleStatus		_SrvcDocItmLifecycleStatus
	_SalesOrganization		_SalesOrganization
	_DistributionChannel		_DistributionChannel
	_Division		_Division
	_ServiceDocumentType		_ServiceDocumentType
	_ServiceConfItemStatus		_ServiceConfItemStatus
	_ServiceOrderItemStatus		_ServiceOrderItemStatus
	_SrvcOrdLifecycleUserStsText		_SrvcOrdLifecycleUserStsText
	_SrvConfLifecycleUserStsText		_SrvConfLifecycleUserStsText
	_SrvcOrdSrvcConfDocTypeVH		_SrvcOrdSrvcConfDocTypeVH

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_SrvcConfRelBillgListRpt.
-- 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: CSRVCCONFBILLG

CREATE VIEW C_SrvcConfRelBillgListRpt AS
SELECT
  ServiceDocumentItem.ServiceDocument AS ServiceDocument,
  ServiceDocumentItem.ServiceDocumentItem AS ServiceDocumentItem,
  ServiceDocumentItem.ServiceDocumentItemCharUUID AS ServiceDocumentItemCharUUID,
  ServiceConfirmation,
  ServiceOrder,
  ServiceDocumentUUID,
  ServiceDocumentItem.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
  ServiceDocumentItem.ServiceDocumentType AS ServiceDocumentType,
  ServiceObjectType,
  ServiceDocumentItem.PostingDate AS PostingDate,
  ServiceDocumentItem.SoldToParty AS SoldToParty,
  _SoldToParty.FirstName AS FirstName,
  _SoldToParty.LastName AS LastName,
  _SoldToParty.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _SoldToParty.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  ServiceDocumentItem.ServiceTeam AS ServiceTeam,
  ServiceConfItemCreationDate,
  ServiceDocumentItem.OriginallyRequestedProduct AS OriginallyRequestedProduct,
  ServiceConfItemDescription,
  ServiceOrderStatus,
  _ServiceDocumentType.StatusProfile AS StatusProfile,
  ServiceOrdErrorStsCriticality,
  ServiceDocumentItem.ResponsibleServiceOrganization AS ResponsibleServiceOrganization,
  ServiceDocumentItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  _SrvcDocItmLifecycleStatus._ServiceDocumentStatusText[1:Language =$session.system_language].ServiceDocumentStatusName AS ServiceDocumentItemStatusName,
  ServiceDocItemStatusCritlty,
  ServiceDocumentItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  ServiceConfirmationStatus,
  TransactionCurrency,
  ServiceDocItemGrossAmount,
  ResponsibleEmployee,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  ServiceConfErrorStsCriticality,
  ServiceDocumentItem.ServiceDocItemBillingStatus AS ServiceDocItemBillingStatus,
  ServiceDocumentItem.SrvcDocItmIsReleasedForBilling AS SrvcDocItmIsReleasedForBilling,
  ParentServiceDocumentItemUUID,
  ServiceDocumentCharUUID,
  SrvcOrderConfirmationRelevance,
  ParentSrvcOrdItmConfRelevance,
  ParentServiceDocumentItem,
  ServiceOrderType,
  SrvcDocItemIsBundle
LEFT OUTER JOIN I_ServiceDocumentStatus AS _ServiceOrderItemStatus ON ServiceOrderStatus = _ServiceOrderItemStatus.ServiceDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentStatus AS _ServiceConfItemStatus ON ServiceConfirmationStatus = _ServiceConfItemStatus.ServiceDocumentStatus  -- association [0..1]
LEFT OUTER JOIN C_ServiceDocumentSoldToPartyVH AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocBusinessPartnerVH AS _ServiceTeam ON ServiceTeam = _ServiceTeam.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceDocument = _ServiceDocItemExt.ServiceOrderItem AND ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtLifecycleUserStsText AS _SrvcOrdLifecycleUserStsText ON ServiceOrderStatus = _SrvcOrdLifecycleUserStsText.CustMgmtLifecycleUserStatus AND _SrvcOrdLifecycleUserStsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtLifecycleUserStsText AS _SrvConfLifecycleUserStsText ON ServiceConfirmationStatus = _SrvConfLifecycleUserStsText.CustMgmtLifecycleUserStatus AND _SrvConfLifecycleUserStsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_SrvcOrdSrvcConfDocTypeVH AS _SrvcOrdSrvcConfDocTypeVH ON ServiceDocumentType = _SrvcOrdSrvcConfDocTypeVH.ServiceDocumentType  -- association [0..1]
;

Depth:

C_SrvcConfRelBillgListRpt view