C_SlsQuotationPartnerManageTP

DDL: C_SLSQUOTATIONPARTNERMANAGETP Type: view_entity CONSUMPTION Package: ODATA_SD_QUOTATION
58 Fields 1 Data Sources 1 Associations 1 OData Services

Sales Quotation Header Partner

C_SlsQuotationPartnerManageTP is a Consumption CDS View that provides data about "Sales Quotation Header Partner" in SAP S/4HANA. It reads from 1 data source (R_SalesQuotationPartnerTP) and exposes 58 fields with key fields SalesQuotation, PartnerFunction. It has 1 association to related views. It is exposed through 1 OData service (UI_SALESQUOTATIONMANAGE). Part of development package ODATA_SD_QUOTATION.

Data Sources (1)

SourceAliasJoin Type
R_SalesQuotationPartnerTP R_SalesQuotationPartnerTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_PartnerFunctionUnconverted _PartnerFunction $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction

Annotations (10)

NameValueLevelField
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 Quotation Header Partner view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SALESQUOTATIONMANAGE UI_SALESQUOTATIONMANAGE V4 C1 NOT_RELEASED

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation SalesQuotation
KEY PartnerFunction Partner Functn
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
SDDocPartnerAddrIsDocSpecific HeaderPartner SDDocPartnerAddrIsDocSpecific
virtualBusinessPartnerName1ad_name1
virtualBusinessPartnerName2ad_name2
virtualBusinessPartnerName3ad_name3
virtualBusinessPartnerName4ad_name4
virtualSDCustomerAddressIDadrnr
virtualSDContactPersonAddressIDadrnr
virtualUICT_VATRegistrationboole_d
virtualUICT_UnloadingPointNameboole_d
virtualUICT_BusinessPartnerName3boole_d
virtualUICT_BusinessPartnerName4boole_d
SalesQuotationType HeaderPartner SalesQuotationType
SalesOrganization HeaderPartner SalesOrganization Sales Organization
DistributionChannel HeaderPartner DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision HeaderPartner OrganizationDivision Org. Division
_PartnerFunction _PartnerFunction
_FormOfAddress HeaderPartner _FormOfAddress
_Country HeaderPartner _Country
_Region HeaderPartner _Region
_CorrespondenceLanguage HeaderPartner _CorrespondenceLanguage
_TransportationZone HeaderPartner _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_SlsQuotationPartnerManageTP.
-- 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_SlsQuotationPartnerManageTP AS
SELECT
  SalesQuotation,
  cast(PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  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,
  HeaderPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  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,
  virtual UICT_BusinessPartnerName3 : boole_d AS virtualUICT_BusinessPartnerName3boole_d,
  virtual UICT_BusinessPartnerName4 : boole_d AS virtualUICT_BusinessPartnerName4boole_d,
  HeaderPartner.SalesQuotationType AS SalesQuotationType,
  HeaderPartner.SalesOrganization AS SalesOrganization,
  HeaderPartner.DistributionChannel AS DistributionChannel,
  HeaderPartner.OrganizationDivision AS OrganizationDivision,
  HeaderPartner._FormOfAddress AS _FormOfAddress,
  HeaderPartner._Country AS _Country,
  HeaderPartner._Region AS _Region,
  HeaderPartner._CorrespondenceLanguage AS _CorrespondenceLanguage,
  HeaderPartner._TransportationZone AS _TransportationZone
FROM R_SalesQuotationPartnerTP
LEFT OUTER JOIN C_PartnerFunctionUnconverted AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
;

Learn More