R_SrvcQtanPartnerAddressTP

DDL: R_SRVCQTANPARTNERADDRESSTP Type: view_entity TRANSACTIONAL
50 Fields 2 Data Sources

Partner Address of Srvc Quotation - TP

R_SrvcQtanPartnerAddressTP is a Transactional CDS View that provides data about "Partner Address of Srvc Quotation - TP" in SAP S/4HANA. It reads from 2 data sources (I_SrvcDocPartnerAddress, I_ServiceDocumentEnhcd) and exposes 50 fields with key fields ServiceQuotation, CustMgmtPartnerFunction, CustMgmtBusinessPartner.

Data Sources (2)

SourceAliasJoin Type
I_SrvcDocPartnerAddress addr inner
I_ServiceDocumentEnhcd srvcdoc from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Partner Address of Srvc Quotation - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY ServiceQuotation I_ServiceDocumentEnhcd ServiceDocument Transaction ID
KEY CustMgmtPartnerFunction I_SrvcDocPartnerAddress CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner I_SrvcDocPartnerAddress CustMgmtBusinessPartner
AddresseeFullName I_SrvcDocPartnerAddress AddresseeFullName Full Name
CityName I_SrvcDocPartnerAddress CityName Name
CorrespondenceLanguage I_SrvcDocPartnerAddress CorrespondenceLanguage Language
Country I_SrvcDocPartnerAddress Country Venue: Ctry/Reg
DistrictName I_SrvcDocPartnerAddress DistrictName District
EmailAddress I_SrvcDocPartnerAddress EmailAddress E-Mail Address
FaxAreaCodeSubscriberNumber I_SrvcDocPartnerAddress FaxAreaCodeSubscriberNumber Fax
FaxExtensionNumber I_SrvcDocPartnerAddress FaxExtensionNumber Extension
FaxNumberCountry I_SrvcDocPartnerAddress FaxNumberCountry Country/Region
FormOfAddress I_SrvcDocPartnerAddress FormOfAddress Title Key
HouseNumber I_SrvcDocPartnerAddress HouseNumber House Number
MobileNumber I_SrvcDocPartnerAddress MobileNumber Telephone
MobilePhoneCountry I_SrvcDocPartnerAddress MobilePhoneCountry Country/Region
OrganizationName1 I_SrvcDocPartnerAddress OrganizationName1 Name
OrganizationName2 I_SrvcDocPartnerAddress OrganizationName2 Name 2
OrganizationName3 I_SrvcDocPartnerAddress OrganizationName3 Name 3
OrganizationName4 I_SrvcDocPartnerAddress OrganizationName4 Name 4
PersonFamilyName I_SrvcDocPartnerAddress PersonFamilyName
PersonGivenName I_SrvcDocPartnerAddress PersonGivenName
PhoneExtensionNumber I_SrvcDocPartnerAddress PhoneExtensionNumber Extension
PhoneNumber I_SrvcDocPartnerAddress PhoneNumber Telephone no.
PhoneNumberCountry I_SrvcDocPartnerAddress PhoneNumberCountry
POBox I_SrvcDocPartnerAddress POBox PO Box
POBoxPostalCode I_SrvcDocPartnerAddress POBoxPostalCode PO Box Postal Code
PostalCode I_SrvcDocPartnerAddress PostalCode Postal Code
Region I_SrvcDocPartnerAddress Region Venue Region
StreetName I_SrvcDocPartnerAddress StreetName Text
StreetPrefixName1 I_SrvcDocPartnerAddress StreetPrefixName1 Street 2
StreetPrefixName2 I_SrvcDocPartnerAddress StreetPrefixName2 Street 3
StreetSuffixName1 I_SrvcDocPartnerAddress StreetSuffixName1 Street 4
StreetSuffixName2 I_SrvcDocPartnerAddress StreetSuffixName2 Street 5
TaxJurisdiction I_SrvcDocPartnerAddress TaxJurisdiction Tax Jurisdiction
TransportZone I_SrvcDocPartnerAddress TransportZone Transport Zone
DistributionChannel I_ServiceDocumentEnhcd DistributionChannel RefDistCh-Cust/Mat.
Division I_ServiceDocumentEnhcd Division Internal Division ID
RespEmployeeBusinessPartnerId I_ServiceDocumentEnhcd ResponsibleEmployee Employee Resp.
SalesGroup I_ServiceDocumentEnhcd SalesGroup Sales Group
SalesGroupOrgUnitID I_ServiceDocumentEnhcd SalesGroupOrgUnitID
SalesOffice I_ServiceDocumentEnhcd SalesOffice Sales Office
SalesOfficeOrgUnitID I_ServiceDocumentEnhcd SalesOfficeOrgUnitID
SalesOrganization I_ServiceDocumentEnhcd SalesOrganization Sales Organization
SalesOrganizationOrgUnitID I_ServiceDocumentEnhcd SalesOrganizationOrgUnitID
ServiceDocumentType I_ServiceDocumentEnhcd ServiceDocumentType Transaction Type
ServiceObjectType I_ServiceDocumentEnhcd ServiceObjectType Object Type
ServiceOrganization I_ServiceDocumentEnhcd ServiceOrganization
_SrvcQtanPartnerTP _SrvcQtanPartnerTP
_ServiceQuotationTP _ServiceQuotationTP

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 R_SrvcQtanPartnerAddressTP.
-- 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 R_SrvcQtanPartnerAddressTP AS
SELECT
  srvcdoc.ServiceDocument AS ServiceQuotation,
  addr.CustMgmtPartnerFunction AS CustMgmtPartnerFunction,
  addr.CustMgmtBusinessPartner AS CustMgmtBusinessPartner,
  addr.AddresseeFullName AS AddresseeFullName,
  addr.CityName AS CityName,
  addr.CorrespondenceLanguage AS CorrespondenceLanguage,
  addr.Country AS Country,
  addr.DistrictName AS DistrictName,
  addr.EmailAddress AS EmailAddress,
  addr.FaxAreaCodeSubscriberNumber AS FaxAreaCodeSubscriberNumber,
  addr.FaxExtensionNumber AS FaxExtensionNumber,
  addr.FaxNumberCountry AS FaxNumberCountry,
  addr.FormOfAddress AS FormOfAddress,
  addr.HouseNumber AS HouseNumber,
  addr.MobileNumber AS MobileNumber,
  addr.MobilePhoneCountry AS MobilePhoneCountry,
  addr.OrganizationName1 AS OrganizationName1,
  addr.OrganizationName2 AS OrganizationName2,
  addr.OrganizationName3 AS OrganizationName3,
  addr.OrganizationName4 AS OrganizationName4,
  addr.PersonFamilyName AS PersonFamilyName,
  addr.PersonGivenName AS PersonGivenName,
  addr.PhoneExtensionNumber AS PhoneExtensionNumber,
  addr.PhoneNumber AS PhoneNumber,
  addr.PhoneNumberCountry AS PhoneNumberCountry,
  addr.POBox AS POBox,
  addr.POBoxPostalCode AS POBoxPostalCode,
  addr.PostalCode AS PostalCode,
  addr.Region AS Region,
  addr.StreetName AS StreetName,
  addr.StreetPrefixName1 AS StreetPrefixName1,
  addr.StreetPrefixName2 AS StreetPrefixName2,
  addr.StreetSuffixName1 AS StreetSuffixName1,
  addr.StreetSuffixName2 AS StreetSuffixName2,
  addr.TaxJurisdiction AS TaxJurisdiction,
  addr.TransportZone AS TransportZone,
  srvcdoc.DistributionChannel AS DistributionChannel,
  srvcdoc.Division AS Division,
  srvcdoc.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  srvcdoc.SalesGroup AS SalesGroup,
  srvcdoc.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  srvcdoc.SalesOffice AS SalesOffice,
  srvcdoc.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  srvcdoc.SalesOrganization AS SalesOrganization,
  srvcdoc.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  srvcdoc.ServiceDocumentType AS ServiceDocumentType,
  srvcdoc.ServiceObjectType AS ServiceObjectType,
  srvcdoc.ServiceOrganization AS ServiceOrganization
FROM I_ServiceDocumentEnhcd AS srvcdoc
INNER JOIN I_SrvcDocPartnerAddress AS addr ON /* join condition not captured in parsed metadata */
;

Learn More