R_PurchaseOrderSupplierAddress

DDL: R_PURCHASEORDERSUPPLIERADDRESS SQL: RMMPOSUPPLADDR Type: view COMPOSITE
56 Fields 1 Data Sources 1 Associations

Purchase Order Supplier Address

R_PurchaseOrderSupplierAddress is a Composite CDS View that provides data about "Purchase Order Supplier Address" in SAP S/4HANA. It reads from 1 data source (P_PurchaseOrderSupplierAddress) and exposes 56 fields with key fields SupplierAddressID, PurchaseOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_PurchaseOrderSupplierAddress P_PurchaseOrderSupplierAddress from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName RMMPOSUPPLADDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Purchase Order Supplier Address view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey SupplierAddressID view
ObjectModel.uniqueIdField SupplierAddressUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY SupplierAddressID P_PurchaseOrderSupplierAddress SupplierAddressID Address Number
KEY PurchaseOrder P_PurchaseOrderSupplierAddress PurchaseOrder Purchasing Document
AddressID _SupplierAddress AddressID Ship-to address
AddressPersonID _SupplierAddress AddressPersonID Person Number
AddressRepresentationCode _SupplierAddress AddressRepresentationCode Address Version
CorrespondenceLanguage _SupplierAddress CorrespondenceLanguage Language
PrfrdCommMediumType _SupplierAddress PrfrdCommMediumType Comm. Method
AddresseeFullName _SupplierAddress AddresseeFullName Full Name
OrganizationName1 _SupplierAddress OrganizationName1 Name
OrganizationName2 _SupplierAddress OrganizationName2 Name 2
OrganizationName3 _SupplierAddress OrganizationName3 Name 3
OrganizationName4 _SupplierAddress OrganizationName4 Name 4
AddressSearchTerm1 _SupplierAddress AddressSearchTerm1 Search Term 1
AddressSearchTerm2 _SupplierAddress AddressSearchTerm2 Search Term 2
CityName _SupplierAddress CityName Name
DistrictName _SupplierAddress DistrictName District
VillageName _SupplierAddress VillageName Different City
PostalCode _SupplierAddress PostalCode Postal Code
CompanyPostalCode _SupplierAddress CompanyPostalCode Company Post Cd
StreetName _SupplierAddress StreetName Text
StreetPrefixName1 _SupplierAddress StreetPrefixName1 Street 2
StreetPrefixName2 _SupplierAddress StreetPrefixName2 Street 3
StreetSuffixName1 _SupplierAddress StreetSuffixName1 Street 4
StreetSuffixName2 _SupplierAddress StreetSuffixName2 Street 5
HouseNumber _SupplierAddress HouseNumber House Number
HouseNumberSupplementText _SupplierAddress HouseNumberSupplementText Supplement
Building _SupplierAddress Building Building code
Floor _SupplierAddress Floor Floor
RoomNumber _SupplierAddress RoomNumber Room Number
Country _SupplierAddress Country Venue: Ctry/Reg
Region _SupplierAddress Region Venue Region
FormOfAddress _SupplierAddress FormOfAddress Title Key
TaxJurisdiction _SupplierAddress TaxJurisdiction Tax Jurisdiction
TransportZone _SupplierAddress TransportZone Transport Zone
POBox _SupplierAddress POBox PO Box
POBoxIsWithoutNumber _SupplierAddress POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode _SupplierAddress POBoxPostalCode PO Box Postal Code
POBoxLobbyName _SupplierAddress POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName _SupplierAddress POBoxDeviatingCityName PO Box City
POBoxDeviatingRegion _SupplierAddress POBoxDeviatingRegion PO Region
POBoxDeviatingCountry _SupplierAddress POBoxDeviatingCountry PO Box C/R
CareOfName _SupplierAddress CareOfName c/o
DeliveryServiceTypeCode _SupplierAddress DeliveryServiceTypeCode Delvry Serv Type
DeliveryServiceNumber _SupplierAddress DeliveryServiceNumber Delivery Service No.
AddressTimeZone _SupplierAddress AddressTimeZone Time Zone
_Country _SupplierAddress _Country
_CurrentDfltEmailAddress _SupplierAddress _CurrentDfltEmailAddress
_CurrentDfltFaxNumber _SupplierAddress _CurrentDfltFaxNumber
_CurrentDfltLandlinePhoneNmbr _SupplierAddress _CurrentDfltLandlinePhoneNmbr
_CurrentDfltMobilePhoneNumber _SupplierAddress _CurrentDfltMobilePhoneNumber
_EmailAddress _SupplierAddress _EmailAddress
_FaxNumber _SupplierAddress _FaxNumber
_PhoneNumber _SupplierAddress _PhoneNumber
_Region _SupplierAddress _Region
RegionalStructureCheckStatus _SupplierAddress RegionalStructureCheckStatus Check Status
_PurchaseOrder _PurchaseOrder

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_PurchaseOrderSupplierAddress.
-- 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.
-- SQL view name: RMMPOSUPPLADDR

CREATE VIEW R_PurchaseOrderSupplierAddress AS
SELECT
  P_PurchaseOrderSupplierAddress.SupplierAddressID AS SupplierAddressID,
  P_PurchaseOrderSupplierAddress.PurchaseOrder AS PurchaseOrder,
  _SupplierAddress.AddressID AS AddressID,
  _SupplierAddress.AddressPersonID AS AddressPersonID,
  _SupplierAddress.AddressRepresentationCode AS AddressRepresentationCode,
  _SupplierAddress.CorrespondenceLanguage AS CorrespondenceLanguage,
  _SupplierAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  _SupplierAddress.AddresseeFullName AS AddresseeFullName,
  _SupplierAddress.OrganizationName1 AS OrganizationName1,
  _SupplierAddress.OrganizationName2 AS OrganizationName2,
  _SupplierAddress.OrganizationName3 AS OrganizationName3,
  _SupplierAddress.OrganizationName4 AS OrganizationName4,
  _SupplierAddress.AddressSearchTerm1 AS AddressSearchTerm1,
  _SupplierAddress.AddressSearchTerm2 AS AddressSearchTerm2,
  _SupplierAddress.CityName AS CityName,
  _SupplierAddress.DistrictName AS DistrictName,
  _SupplierAddress.VillageName AS VillageName,
  _SupplierAddress.PostalCode AS PostalCode,
  _SupplierAddress.CompanyPostalCode AS CompanyPostalCode,
  _SupplierAddress.StreetName AS StreetName,
  _SupplierAddress.StreetPrefixName1 AS StreetPrefixName1,
  _SupplierAddress.StreetPrefixName2 AS StreetPrefixName2,
  _SupplierAddress.StreetSuffixName1 AS StreetSuffixName1,
  _SupplierAddress.StreetSuffixName2 AS StreetSuffixName2,
  _SupplierAddress.HouseNumber AS HouseNumber,
  _SupplierAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  _SupplierAddress.Building AS Building,
  _SupplierAddress.Floor AS Floor,
  _SupplierAddress.RoomNumber AS RoomNumber,
  _SupplierAddress.Country AS Country,
  _SupplierAddress.Region AS Region,
  _SupplierAddress.FormOfAddress AS FormOfAddress,
  _SupplierAddress.TaxJurisdiction AS TaxJurisdiction,
  _SupplierAddress.TransportZone AS TransportZone,
  _SupplierAddress.POBox AS POBox,
  _SupplierAddress.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _SupplierAddress.POBoxPostalCode AS POBoxPostalCode,
  _SupplierAddress.POBoxLobbyName AS POBoxLobbyName,
  _SupplierAddress.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _SupplierAddress.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _SupplierAddress.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _SupplierAddress.CareOfName AS CareOfName,
  _SupplierAddress.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _SupplierAddress.DeliveryServiceNumber AS DeliveryServiceNumber,
  _SupplierAddress.AddressTimeZone AS AddressTimeZone,
  _SupplierAddress._Country AS _Country,
  _SupplierAddress._CurrentDfltEmailAddress AS _CurrentDfltEmailAddress,
  _SupplierAddress._CurrentDfltFaxNumber AS _CurrentDfltFaxNumber,
  _SupplierAddress._CurrentDfltLandlinePhoneNmbr AS _CurrentDfltLandlinePhoneNmbr,
  _SupplierAddress._CurrentDfltMobilePhoneNumber AS _CurrentDfltMobilePhoneNumber,
  _SupplierAddress._EmailAddress AS _EmailAddress,
  _SupplierAddress._FaxNumber AS _FaxNumber,
  _SupplierAddress._PhoneNumber AS _PhoneNumber,
  _SupplierAddress._Region AS _Region,
  _SupplierAddress.RegionalStructureCheckStatus AS RegionalStructureCheckStatus
FROM P_PurchaseOrderSupplierAddress
LEFT OUTER JOIN R_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
;

Learn More