What is C_SrvcSoldToPartyVH in SAP S/4HANA?

C_SrvcSoldToPartyVH is a consumption CDS view in SAP S/4HANA. Sold-To Party in Service It contains 45 fields.

Which tables does C_SrvcSoldToPartyVH read from?

C_SrvcSoldToPartyVH reads data from: C_SrvcOrderSoldToPartyVH.

What VDM layer is C_SrvcSoldToPartyVH?

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

C_SrvcSoldToPartyVH

DDL: C_SRVCSOLDTOPARTYVH Type: view CONSUMPTION

45 Fields 1 Data Sources 9 Associations

Sold-To Party in Service

C_SrvcSoldToPartyVH is a Consumption CDS View that provides data about "Sold-To Party in Service" in SAP S/4HANA. It reads from 1 data source (C_SrvcOrderSoldToPartyVH) and exposes 45 fields with key fields BusinessPartner, SalesOrganization, DistributionChannel, Division. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
C_SrvcOrderSoldToPartyVH	SrvcOrderSoldToPartyVH	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..1]	I_SalesOrgUnitIDSalesOrgAssgmt	_SalesOrgUnitIDSalesOrgAssgmt	`$projection.SalesOrganization = _SalesOrgUnitIDSalesOrgAssgmt.SalesOrganization`
[0..1]	I_SalesOfficeOrgUnitIDVH	_SalesOfficeOrgUnitIDVH	`$projection.SalesOffice = _SalesOfficeOrgUnitIDVH.SalesOffice`
[0..1]	I_SalesGroupOrgUnitIDVH	_SalesGroupOrgUnitIDVH	`$projection.SalesGroup = _SalesGroupOrgUnitIDVH.SalesGroup`
[0..1]	I_BusinessPartner	_SoldToParty	`_SoldToParty.BusinessPartner = $projection.BusinessPartner and _SoldToParty.BusinessPartnerIsBlocked != 'X'`
[0..1]	I_SalesOrganization	_SalesOrganization	`$projection.SalesOrganization = _SalesOrganization.SalesOrganization`
[0..1]	I_DistributionChannel	_DistributionChannel	`$projection.DistributionChannel = _DistributionChannel.DistributionChannel`
[0..1]	I_Division	_Division	`$projection.Division = _Division.Division`
[0..1]	I_SalesOffice	_SalesOffice	`$projection.SalesOffice = _SalesOffice.SalesOffice`
[0..1]	I_SalesGroup	_SalesGroup	`$projection.SalesGroup = _SalesGroup.SalesGroup`

Annotations (14)

Name	Value	Level
EndUserText.label	Sold-To Party in Service	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.representativeKey	BusinessPartner	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.dataCategory	#VALUE_HELP	view
Search.searchable	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	ISRVCSLDPRTVH	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view

Fields (45)

Key	Field	Source Table	Source Field	Description
KEY	BusinessPartner	C_SrvcOrderSoldToPartyVH	BusinessPartner	Issuing Authority
KEY	SalesOrganization	C_SrvcOrderSoldToPartyVH	SalesOrganization	Sales Organization
KEY	DistributionChannel	C_SrvcOrderSoldToPartyVH	DistributionChannel	RefDistCh-Cust/Mat.
KEY	Division	C_SrvcOrderSoldToPartyVH	Division	Internal Division ID
	BusinessPartnerName	C_SrvcOrderSoldToPartyVH	BusinessPartnerName	Extracted Customer Name
	PostalCode	C_SrvcOrderSoldToPartyVH	PostalCode	Postal Code
	CityName	C_SrvcOrderSoldToPartyVH	CityName	Name
	Country	C_SrvcOrderSoldToPartyVH	Country	Venue: Ctry/Reg
	CountryName	C_SrvcOrderSoldToPartyVH	CountryName	Country
	SalesOrganizationName	C_SrvcOrderSoldToPartyVH	SalesOrganizationName	Sales Organization Description
	DistributionChannelName	C_SrvcOrderSoldToPartyVH	DistributionChannelName
	DivisionName	C_SrvcOrderSoldToPartyVH	DivisionName	Division Description
	SalesOffice	C_SrvcOrderSoldToPartyVH	SalesOffice	Sales Office
	SalesGroup	C_SrvcOrderSoldToPartyVH	SalesGroup	Sales Group
	SalesOrganizationOrgUnitID	_SalesOrgUnitIDSalesOrgAssgmt	SalesOrganizationOrgUnitID
	SalesOrganizationOrgUnitName
	SalesOfficeOrgUnitID	_SalesOfficeOrgUnitIDVH	SalesOfficeOrgUnitID
	SalesGroupOrgUnitID	_SalesGroupOrgUnitIDVH	SalesGroupOrgUnitID
	FirstName	_SoldToParty	FirstName	First Name
	LastName	_SoldToParty	LastName	Last Name
	OrganizationBPName1	_SoldToParty	OrganizationBPName1	Name 1
	OrganizationBPName2	_SoldToParty	OrganizationBPName2	Name 2
	AuthorizationGroup	C_SrvcOrderSoldToPartyVH	AuthorizationGroup	AuthorizGroup
	IsBusinessPurposeCompleted	C_SrvcOrderSoldToPartyVH	IsBusinessPurposeCompleted	Purpose Completed
	CustomerAuthznGrp	C_SrvcOrderSoldToPartyVH	CustomerAuthznGrp	AuthorizGroup
	DataControllerSet	_SoldToParty	DataControllerSet	Data Ctrlr. Set
	DataController1	_SoldToParty	DataController1	Data Controller
	DataController2	_SoldToParty	DataController2	Data Controller
	DataController3	_SoldToParty	DataController3	Data Controller
	DataController4	_SoldToParty	DataController4	Data Controller
	DataController5	_SoldToParty	DataController5	Data Controller
	DataController6	_SoldToParty	DataController6	Data Controller
	DataController7	_SoldToParty	DataController7	Data Controller
	DataController8	_SoldToParty	DataController8	Data Controller
	DataController9	_SoldToParty	DataController9	Data Controller
	DataController10	_SoldToParty	DataController10	Data Controller
	_SoldToParty		_SoldToParty
	_SalesOrgUnitIDSalesOrgAssgmt		_SalesOrgUnitIDSalesOrgAssgmt
	_SalesOfficeOrgUnitIDVH		_SalesOfficeOrgUnitIDVH
	_SalesGroupOrgUnitIDVH		_SalesGroupOrgUnitIDVH
	_SalesOrganization		_SalesOrganization
	_DistributionChannel		_DistributionChannel
	_Division		_Division
	_SalesOffice		_SalesOffice
	_SalesGroup		_SalesGroup

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_SrvcSoldToPartyVH.
-- 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_SrvcSoldToPartyVH AS
SELECT
  SrvcOrderSoldToPartyVH.BusinessPartner AS BusinessPartner,
  SrvcOrderSoldToPartyVH.SalesOrganization AS SalesOrganization,
  SrvcOrderSoldToPartyVH.DistributionChannel AS DistributionChannel,
  SrvcOrderSoldToPartyVH.Division AS Division,
  SrvcOrderSoldToPartyVH.BusinessPartnerName AS BusinessPartnerName,
  SrvcOrderSoldToPartyVH.PostalCode AS PostalCode,
  SrvcOrderSoldToPartyVH.CityName AS CityName,
  SrvcOrderSoldToPartyVH.Country AS Country,
  SrvcOrderSoldToPartyVH.CountryName AS CountryName,
  SrvcOrderSoldToPartyVH.SalesOrganizationName AS SalesOrganizationName,
  SrvcOrderSoldToPartyVH.DistributionChannelName AS DistributionChannelName,
  SrvcOrderSoldToPartyVH.DivisionName AS DivisionName,
  SrvcOrderSoldToPartyVH.SalesOffice AS SalesOffice,
  SrvcOrderSoldToPartyVH.SalesGroup AS SalesGroup,
  _SalesOrgUnitIDSalesOrgAssgmt.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _SalesOrgUnitIDSalesOrgAssgmt._SalesOrganizationUnitText.OrganizationalUnitName AS SalesOrganizationOrgUnitName,
  _SalesOfficeOrgUnitIDVH.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  _SalesGroupOrgUnitIDVH.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  _SoldToParty.FirstName AS FirstName,
  _SoldToParty.LastName AS LastName,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  SrvcOrderSoldToPartyVH.AuthorizationGroup AS AuthorizationGroup,
  SrvcOrderSoldToPartyVH.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  SrvcOrderSoldToPartyVH.CustomerAuthznGrp AS CustomerAuthznGrp,
  _SoldToParty.DataControllerSet AS DataControllerSet,
  _SoldToParty.DataController1 AS DataController1,
  _SoldToParty.DataController2 AS DataController2,
  _SoldToParty.DataController3 AS DataController3,
  _SoldToParty.DataController4 AS DataController4,
  _SoldToParty.DataController5 AS DataController5,
  _SoldToParty.DataController6 AS DataController6,
  _SoldToParty.DataController7 AS DataController7,
  _SoldToParty.DataController8 AS DataController8,
  _SoldToParty.DataController9 AS DataController9,
  _SoldToParty.DataController10 AS DataController10
FROM C_SrvcOrderSoldToPartyVH AS SrvcOrderSoldToPartyVH
LEFT OUTER JOIN I_SalesOrgUnitIDSalesOrgAssgmt AS _SalesOrgUnitIDSalesOrgAssgmt ON SalesOrganization = _SalesOrgUnitIDSalesOrgAssgmt.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOfficeOrgUnitIDVH AS _SalesOfficeOrgUnitIDVH ON SalesOffice = _SalesOfficeOrgUnitIDVH.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesGroupOrgUnitIDVH AS _SalesGroupOrgUnitIDVH ON SalesGroup = _SalesGroupOrgUnitIDVH.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _SoldToParty ON _SoldToParty.BusinessPartner = BusinessPartner AND _SoldToParty.BusinessPartnerIsBlocked != 'X'  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
;

Depth:

C_SrvcSoldToPartyVH view

C_SrvcOrderSoldToPartyVH view