What is C_SalesContractPartnerManageTP in SAP S/4HANA?

C_SalesContractPartnerManageTP is a consumption CDS view in SAP S/4HANA. Sales Contract Header Partner It contains 59 fields.

Which tables does C_SalesContractPartnerManageTP read from?

C_SalesContractPartnerManageTP reads data from: R_SalesContractPartnerTP.

What VDM layer is C_SalesContractPartnerManageTP?

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

C_SalesContractPartnerManageTP

DDL: C_SALESCONTRACTPARTNERMANAGETP Type: view_entity CONSUMPTION Package: ODATA_SD_CONTRACT

59 Fields 1 Data Sources 1 Associations 1 OData Services

Sales Contract Header Partner

C_SalesContractPartnerManageTP is a Consumption CDS View that provides data about "Sales Contract Header Partner" in SAP S/4HANA. It reads from 1 data source (R_SalesContractPartnerTP) and exposes 59 fields with key fields SalesContract, PartnerFunction, SDDocPartnerSequenceNumber. It has 1 association to related views. It is exposed through 1 OData service (UI_SALESCONTRACTMANAGE). Part of development package ODATA_SD_CONTRACT.

Data Sources (1)

Source	Alias	Join Type
R_SalesContractPartnerTP	R_SalesContractPartnerTP	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 Contract Header Partner	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_SALESCONTRACTMANAGE	UI_SALESCONTRACTMANAGE	V4	C1	NOT_RELEASED

Fields (59)

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

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_SalesContractPartnerManageTP.
-- 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_SalesContractPartnerManageTP AS
SELECT
  HeaderPartner.SalesContract AS SalesContract,
  HeaderPartner.PartnerFunction AS PartnerFunction,
  HeaderPartner.SDDocPartnerSequenceNumber AS SDDocPartnerSequenceNumber,
  HeaderPartner.PartnerFunctionForEdit AS PartnerFunctionForEdit,
  HeaderPartner.Customer AS Customer,
  HeaderPartner.Supplier AS Supplier,
  HeaderPartner.Personnel AS Personnel,
  HeaderPartner.ContactPerson AS ContactPerson,
  HeaderPartner.FullName AS FullName,
  HeaderPartner.SDDocumentPartnerType AS SDDocumentPartnerType,
  HeaderPartner.Partner AS Partner,
  HeaderPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  cast( HeaderPartner.FormOfAddress as ad_title preserving type ) AS FormOfAddress,
  HeaderPartner.PostalCode AS PostalCode,
  HeaderPartner.CityName AS CityName,
  HeaderPartner.DistrictName AS DistrictName,
  HeaderPartner.Country AS Country,
  HeaderPartner.Region AS Region,
  HeaderPartner.StreetName AS StreetName,
  HeaderPartner.StreetPrefixName1 AS StreetPrefixName1,
  HeaderPartner.StreetPrefixName2 AS StreetPrefixName2,
  HeaderPartner.StreetSuffixName1 AS StreetSuffixName1,
  HeaderPartner.StreetSuffixName2 AS StreetSuffixName2,
  HeaderPartner.HouseNumber AS HouseNumber,
  cast( HeaderPartner.InternationalPhoneNumber as ad_telnrlg preserving type ) AS InternationalPhoneNumber,
  cast( HeaderPartner.InternationalMobilePhoneNumber as ad_telnrlg preserving type ) AS InternationalMobilePhoneNumber,
  HeaderPartner.InternationalFaxNumber AS InternationalFaxNumber,
  cast( HeaderPartner.EmailAddress as ad_smtpadr preserving type ) AS EmailAddress,
  HeaderPartner.POBox AS POBox,
  HeaderPartner.POBoxPostalCode AS POBoxPostalCode,
  HeaderPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  HeaderPartner.TaxJurisdiction AS TaxJurisdiction,
  HeaderPartner.TransportZone AS TransportZone,
  HeaderPartner.UnloadingPointName AS UnloadingPointName,
  HeaderPartner.VATRegistration AS VATRegistration,
  HeaderPartner.AddressID AS AddressID,
  HeaderPartner.AddressPersonID AS AddressPersonID,
  HeaderPartner.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,
  virtual SDCustomerAddressID : adrnr AS virtualSDCustomerAddressIDadrnr,
  virtual SDContactPersonAddressID : adrnr AS virtualSDContactPersonAddressIDadrnr,
  virtual UICT_VATRegistration : boole_d AS virtualUICT_VATRegistrationboole_d,
  virtual UICT_UnloadingPointName : boole_d AS virtualUICT_UnloadingPointNameboole_d,
  HeaderPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  virtual UICT_BusinessPartnerName3 : boole_d AS virtualUICT_BusinessPartnerName3boole_d,
  virtual UICT_BusinessPartnerName4 : boole_d AS virtualUICT_BusinessPartnerName4boole_d,
  HeaderPartner.SalesContractType AS SalesContractType,
  HeaderPartner.SalesOrganization AS SalesOrganization,
  HeaderPartner.DistributionChannel AS DistributionChannel,
  HeaderPartner.OrganizationDivision AS OrganizationDivision,
  HeaderPartner._TransportationZone AS _TransportationZone,
  HeaderPartner._FormOfAddress AS _FormOfAddress,
  HeaderPartner._Country AS _Country,
  HeaderPartner._Region AS _Region,
  HeaderPartner._CorrespondenceLanguage AS _CorrespondenceLanguage
FROM R_SalesContractPartnerTP
LEFT OUTER JOIN C_PartnerFunctionUnconverted AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
;

Depth:

C_SalesContractPartnerManageTP view_entity

R_SalesContractPartnerTP view_entity