What is C_SalesOrderItemPartnerManage in SAP S/4HANA?

C_SalesOrderItemPartnerManage is a consumption CDS view in SAP S/4HANA. Sales Order Item Partner It contains 61 fields.

Which tables does C_SalesOrderItemPartnerManage read from?

C_SalesOrderItemPartnerManage reads data from: R_SalesOrderItemPartnerTP.

What VDM layer is C_SalesOrderItemPartnerManage?

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

C_SalesOrderItemPartnerManage

DDL: C_SALESORDERITEMPARTNERMANAGE Type: view_entity CONSUMPTION Package: ODATA_SD_SALESORDER_UI

61 Fields 1 Data Sources 1 Associations 1 OData Services

Sales Order Item Partner

C_SalesOrderItemPartnerManage is a Consumption CDS View that provides data about "Sales Order Item Partner" in SAP S/4HANA. It reads from 1 data source (R_SalesOrderItemPartnerTP) and exposes 61 fields with key fields SalesOrder, SalesOrderItem, PartnerFunction. It has 1 association to related views. It is exposed through 1 OData service (C_SALESORDERMANAGE_SD). Part of development package ODATA_SD_SALESORDER_UI.

Data Sources (1)

Source	Alias	Join Type
R_SalesOrderItemPartnerTP	R_SalesOrderItemPartnerTP	projection

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	C_PartnerFunctionUnconverted	_PartnerFunction	`$projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction`

Annotations (10)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.modelingPattern	#TRANSACTIONAL_QUERY	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.query.implementedBy	ABAP:CL_S4RAP_STICKY_QRY	view
EndUserText.label	Sales Order Item Partner	view

OData Services (1)

Service	Binding	Version	Contract	Release
C_SALESORDERMANAGE_SD	C_SALESORDERMANAGE_SRV	V4	C1	NOT_RELEASED

Fields (61)

Key	Field	Source Table	Source Field	Description
KEY	SalesOrder	ItemPartner	SalesOrder	SD Document
KEY	SalesOrderItem	ItemPartner	SalesOrderItem	Sales Order Item
KEY	PartnerFunction	ItemPartner	PartnerFunction	Partner Functn
	PartnerFunctionForEdit	ItemPartner	PartnerFunctionForEdit	Partner Funct.
	Customer	ItemPartner	Customer	Sold-to Party
	Supplier	ItemPartner	Supplier	Supplier
	Personnel	ItemPartner	Personnel	Personnel No.
	ContactPerson	ItemPartner	ContactPerson	Contact Person Key
	Partner	ItemPartner	Partner	With Partner
	ReferenceBusinessPartner	ItemPartner	ReferenceBusinessPartner	Busn. Partner
	FullName	ItemPartner	FullName	Name
	SDDocumentPartnerType	ItemPartner	SDDocumentPartnerType	Partner Type
	PartnerIsSpecificForSDDocItem	ItemPartner	PartnerIsSpecificForSDDocItem
	UnloadingPointName	ItemPartner	UnloadingPointName	Unloading Point Name
	VATRegistration	ItemPartner	VATRegistration	VAT Registration No.
	virtualSDCustomerAddressIDadrnr
	virtualSDContactPersonAddressIDadrnr
	SDDocPartnerAddrIsDocSpecific	ItemPartner	SDDocPartnerAddrIsDocSpecific
	PartnerIsOneTimeAccount	ItemPartner	PartnerIsOneTimeAccount	One-Time Customer
	AddressID	ItemPartner	AddressID	Ship-to address
	AddressPersonID	ItemPartner	AddressPersonID	Person Number
	AddressObjectType	ItemPartner	AddressObjectType	Address Type
	virtualBusinessPartnerName1ad_name1
	virtualBusinessPartnerName2ad_name2
	virtualBusinessPartnerName3ad_name3
	virtualBusinessPartnerName4ad_name4
	FormOfAddress	ItemPartner	FormOfAddress	Title Key
	PostalCode	ItemPartner	PostalCode	Postal Code
	CityName	ItemPartner	CityName	Name
	Country	ItemPartner	Country	Venue: Ctry/Reg
	Region	ItemPartner	Region	Venue Region
	DistrictName	ItemPartner	DistrictName	District
	StreetName	ItemPartner	StreetName	Text
	StreetPrefixName1	ItemPartner	StreetPrefixName1	Street 2
	StreetPrefixName2	ItemPartner	StreetPrefixName2	Street 3
	StreetSuffixName1	ItemPartner	StreetSuffixName1	Street 4
	StreetSuffixName2	ItemPartner	StreetSuffixName2	Street 5
	HouseNumber	ItemPartner	HouseNumber	House Number
	POBox	ItemPartner	POBox	PO Box
	POBoxPostalCode	ItemPartner	POBoxPostalCode	PO Box Postal Code
	CorrespondenceLanguage	ItemPartner	CorrespondenceLanguage	Correspondence Language
	TaxJurisdiction	ItemPartner	TaxJurisdiction	Tax Jurisdiction
	TransportZone	ItemPartner	TransportZone	Transport Zone
	InternationalPhoneNumber	ItemPartner	InternationalPhoneNumber	Telephone no.
	InternationalMobilePhoneNumber	ItemPartner	InternationalMobilePhoneNumber
	InternationalFaxNumber	ItemPartner	InternationalFaxNumber	Fax Number
	EmailAddress	ItemPartner	EmailAddress	E-Mail Address
	virtualUICT_VATRegistrationboole_d
	virtualUICT_UnloadingPointNameboole_d
	virtualUICT_BusinessPartnerName3boole_d
	virtualUICT_BusinessPartnerName4boole_d
	SalesOrderType	ItemPartner	SalesOrderType	Sales Order Type
	SalesOrganization	ItemPartner	SalesOrganization	Sales Organization
	DistributionChannel	ItemPartner	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	ItemPartner	OrganizationDivision	Org. Division
	_PartnerFunction		_PartnerFunction
	_FormOfAddress	ItemPartner	_FormOfAddress
	_Country	ItemPartner	_Country
	_Region	ItemPartner	_Region
	_CorrespondenceLanguage	ItemPartner	_CorrespondenceLanguage
	_TransportationZone	ItemPartner	_TransportationZone

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_SalesOrderItemPartnerManage.
-- 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_SalesOrderItemPartnerManage AS
SELECT
  ItemPartner.SalesOrder AS SalesOrder,
  ItemPartner.SalesOrderItem AS SalesOrderItem,
  ItemPartner.PartnerFunction AS PartnerFunction,
  ItemPartner.PartnerFunctionForEdit AS PartnerFunctionForEdit,
  ItemPartner.Customer AS Customer,
  ItemPartner.Supplier AS Supplier,
  ItemPartner.Personnel AS Personnel,
  ItemPartner.ContactPerson AS ContactPerson,
  ItemPartner.Partner AS Partner,
  ItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  ItemPartner.FullName AS FullName,
  ItemPartner.SDDocumentPartnerType AS SDDocumentPartnerType,
  ItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  ItemPartner.UnloadingPointName AS UnloadingPointName,
  ItemPartner.VATRegistration AS VATRegistration,
  virtual SDCustomerAddressID : adrnr AS virtualSDCustomerAddressIDadrnr,
  virtual SDContactPersonAddressID : adrnr AS virtualSDContactPersonAddressIDadrnr,
  ItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  ItemPartner.PartnerIsOneTimeAccount AS PartnerIsOneTimeAccount,
  ItemPartner.AddressID AS AddressID,
  ItemPartner.AddressPersonID AS AddressPersonID,
  ItemPartner.AddressObjectType AS AddressObjectType,
  virtual BusinessPartnerName1 : ad_name1 AS virtualBusinessPartnerName1ad_name1,
  virtual BusinessPartnerName2 : ad_name2 AS virtualBusinessPartnerName2ad_name2,
  virtual BusinessPartnerName3 : ad_name3 AS virtualBusinessPartnerName3ad_name3,
  virtual BusinessPartnerName4 : ad_name4 AS virtualBusinessPartnerName4ad_name4,
  ItemPartner.FormOfAddress AS FormOfAddress,
  ItemPartner.PostalCode AS PostalCode,
  ItemPartner.CityName AS CityName,
  ItemPartner.Country AS Country,
  ItemPartner.Region AS Region,
  ItemPartner.DistrictName AS DistrictName,
  ItemPartner.StreetName AS StreetName,
  ItemPartner.StreetPrefixName1 AS StreetPrefixName1,
  ItemPartner.StreetPrefixName2 AS StreetPrefixName2,
  ItemPartner.StreetSuffixName1 AS StreetSuffixName1,
  ItemPartner.StreetSuffixName2 AS StreetSuffixName2,
  ItemPartner.HouseNumber AS HouseNumber,
  ItemPartner.POBox AS POBox,
  ItemPartner.POBoxPostalCode AS POBoxPostalCode,
  ItemPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  ItemPartner.TaxJurisdiction AS TaxJurisdiction,
  ItemPartner.TransportZone AS TransportZone,
  ItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  ItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  ItemPartner.InternationalFaxNumber AS InternationalFaxNumber,
  ItemPartner.EmailAddress AS EmailAddress,
  virtual UICT_VATRegistration : boole_d AS virtualUICT_VATRegistrationboole_d,
  virtual UICT_UnloadingPointName : boole_d AS virtualUICT_UnloadingPointNameboole_d,
  virtual UICT_BusinessPartnerName3 : boole_d AS virtualUICT_BusinessPartnerName3boole_d,
  virtual UICT_BusinessPartnerName4 : boole_d AS virtualUICT_BusinessPartnerName4boole_d,
  ItemPartner.SalesOrderType AS SalesOrderType,
  ItemPartner.SalesOrganization AS SalesOrganization,
  ItemPartner.DistributionChannel AS DistributionChannel,
  ItemPartner.OrganizationDivision AS OrganizationDivision,
  ItemPartner._FormOfAddress AS _FormOfAddress,
  ItemPartner._Country AS _Country,
  ItemPartner._Region AS _Region,
  ItemPartner._CorrespondenceLanguage AS _CorrespondenceLanguage,
  ItemPartner._TransportationZone AS _TransportationZone
FROM R_SalesOrderItemPartnerTP
LEFT OUTER JOIN C_PartnerFunctionUnconverted AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
;

Depth:

C_SalesOrderItemPartnerManage view_entity

R_SalesOrderItemPartnerTP view_entity