A_SrvcContrPartnerAddress

DDL: A_SRVCCONTRPARTNERADDRESS Type: view_entity CONSUMPTION Package: CRMS4_SERVICE_CONTR_ODATA_API
23 Fields 1 Data Sources 1 OData Services

Partner Address in Service Contract

A_SrvcContrPartnerAddress is a Consumption CDS View that provides data about "Partner Address in Service Contract" in SAP S/4HANA. It reads from 1 data source (R_SrvcContrPartnerAddressTP) and exposes 23 fields with key fields ServiceContract, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It is exposed through 1 OData service (API_SERVICECONTRACT). Part of development package CRMS4_SERVICE_CONTR_ODATA_API.

Data Sources (1)

SourceAliasJoin Type
R_SrvcContrPartnerAddressTP R_SrvcContrPartnerAddressTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Partner Address in Service Contract view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name SrvcContrPartnerAddress_Type view
Feature CRMS4_SC_API_PARTNER_ADDRESS view

OData Services (1)

ServiceBindingVersionContractRelease
API_SERVICECONTRACT API_SERVICECONTRACT V4 C2 C1

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceContract Transaction ID
KEY CustMgmtPartnerFunction CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner CustMgmtBusinessPartner
CityName CityName Name
Country Country Venue: Ctry/Reg
EmailAddress EmailAddress E-Mail Address
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber Fax
FaxExtensionNumber FaxExtensionNumber Extension
FaxNumberCountry FaxNumberCountry Country/Region
HouseNumber HouseNumber House Number
MobileNumber MobileNumber Telephone
MobilePhoneCountry MobilePhoneCountry Country/Region
OrganizationName1 OrganizationName1 Name
OrganizationName2 OrganizationName2 Name 2
OrganizationName3 OrganizationName3 Name 3
OrganizationName4 OrganizationName4 Name 4
PhoneExtensionNumber PhoneExtensionNumber Extension
PhoneNumber PhoneNumber Telephone no.
PhoneNumberCountry PhoneNumberCountry
PostalCode PostalCode Postal Code
Region Region Venue Region
StreetName StreetName Text
TaxJurisdiction TaxJurisdiction Tax Jurisdiction

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 A_SrvcContrPartnerAddress.
-- 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 A_SrvcContrPartnerAddress AS
SELECT
  ServiceContract,
  CustMgmtPartnerFunction,
  CustMgmtBusinessPartner,
  CityName,
  Country,
  EmailAddress,
  FaxAreaCodeSubscriberNumber,
  FaxExtensionNumber,
  FaxNumberCountry,
  HouseNumber,
  MobileNumber,
  MobilePhoneCountry,
  OrganizationName1,
  OrganizationName2,
  OrganizationName3,
  OrganizationName4,
  PhoneExtensionNumber,
  PhoneNumber,
  PhoneNumberCountry,
  PostalCode,
  Region,
  StreetName,
  TaxJurisdiction
FROM R_SrvcContrPartnerAddressTP
;

Learn More