R_ProductionSupplyAreaAddrTP

DDL: R_PRODUCTIONSUPPLYAREAADDRTP Type: view_entity TRANSACTIONAL Package: MD05_PSA_BO_RAP
21 Fields 2 Data Sources

Production Supply Area Address - TP

R_ProductionSupplyAreaAddrTP is a Transactional CDS View that provides data about "Production Supply Area Address - TP" in SAP S/4HANA. It reads from 2 data sources (I_OrganizationAddress, pvbe) and exposes 21 fields with key fields ProductionSupplyArea, Plant, AddressRepresentationCode. Part of development package MD05_PSA_BO_RAP.

Data Sources (2)

SourceAliasJoin Type
I_OrganizationAddress address inner
pvbe pvbe from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Production Supply Area Address - TP view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ProductionSupplyArea pvbe prvbe Supply Area
KEY Plant pvbe werks Receiving Plant
KEY AddressRepresentationCode I_OrganizationAddress AddressRepresentationCode Address Version
ProductionSupplyAreaAddressID I_OrganizationAddress AddressID Ship-to address
AddresseeName1 I_OrganizationAddress AddresseeName1
AddresseeName2 I_OrganizationAddress AddresseeName2
Building I_OrganizationAddress Building Building code
StreetName I_OrganizationAddress StreetName Text
HouseNumber I_OrganizationAddress HouseNumber House Number
StreetPrefixName1 I_OrganizationAddress StreetPrefixName1 Street 2
StreetPrefixName2 I_OrganizationAddress StreetPrefixName2 Street 3
StreetSuffixName1 I_OrganizationAddress StreetSuffixName1 Street 4
StreetSuffixName2 I_OrganizationAddress StreetSuffixName2 Street 5
CityName I_OrganizationAddress CityName Name
PostalCode I_OrganizationAddress PostalCode Postal Code
Region I_OrganizationAddress Region Venue Region
Country I_OrganizationAddress Country Venue: Ctry/Reg
_ProductionSupplyArea _ProductionSupplyArea
_AddressRepresentationCode I_OrganizationAddress _AddressRepresentationCode
_Region I_OrganizationAddress _Region
_Country I_OrganizationAddress _Country

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_ProductionSupplyAreaAddrTP.
-- 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_ProductionSupplyAreaAddrTP AS
SELECT
  pvbe.prvbe AS ProductionSupplyArea,
  pvbe.werks AS Plant,
  address.AddressRepresentationCode AS AddressRepresentationCode,
  address.AddressID AS ProductionSupplyAreaAddressID,
  address.AddresseeName1 AS AddresseeName1,
  address.AddresseeName2 AS AddresseeName2,
  address.Building AS Building,
  address.StreetName AS StreetName,
  address.HouseNumber AS HouseNumber,
  address.StreetPrefixName1 AS StreetPrefixName1,
  address.StreetPrefixName2 AS StreetPrefixName2,
  address.StreetSuffixName1 AS StreetSuffixName1,
  address.StreetSuffixName2 AS StreetSuffixName2,
  address.CityName AS CityName,
  address.PostalCode AS PostalCode,
  address.Region AS Region,
  address.Country AS Country,
  address._AddressRepresentationCode AS _AddressRepresentationCode,
  address._Region AS _Region,
  address._Country AS _Country
FROM pvbe
INNER JOIN I_OrganizationAddress AS address ON /* join condition not captured in parsed metadata */
;

Learn More