C_ProductionSupplyAreaAddress

DDL: C_PRODUCTIONSUPPLYAREAADDRESS Type: view_entity CONSUMPTION
20 Fields 1 Data Sources

Production Supply Area Address

C_ProductionSupplyAreaAddress is a Consumption CDS View that provides data about "Production Supply Area Address" in SAP S/4HANA. It reads from 1 data source (R_ProductionSupplyAreaAddrTP) and exposes 20 fields with key fields ProductionSupplyArea, Plant, AddressRepresentationCode.

Data Sources (1)

SourceAliasJoin Type
R_ProductionSupplyAreaAddrTP R_ProductionSupplyAreaAddrTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Production Supply Area Address view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ProductionSupplyArea ProductionSupplyArea Supply Area
KEY Plant Plant Valuation Area
KEY AddressRepresentationCode AddressRepresentationCode Address Version
ProductionSupplyAreaAddressID ProductionSupplyAreaAddressID Ship-to address
AddresseeName1 AddresseeName1 Addressee 1
AddresseeName2 AddresseeName2 Addressee 2
Building Building Building
StreetName StreetName Street
HouseNumber HouseNumber House Number
StreetPrefixName1 StreetPrefixName1 Street Prefix 1
StreetPrefixName2 StreetPrefixName2 Street Prefix 2
StreetSuffixName1 StreetSuffixName1 Street Suffix 1
StreetSuffixName2 StreetSuffixName2 Street Suffix 2
CityName CityName Name
PostalCode PostalCode Postal Code
Region Region Venue Region
Country Country Country/Region
AddressRepresentationDesclocalized
RegionNamelocalized
CountryNamelocalized

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_ProductionSupplyAreaAddress.
-- 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_ProductionSupplyAreaAddress AS
SELECT
  ProductionSupplyArea,
  Plant,
  AddressRepresentationCode,
  ProductionSupplyAreaAddressID,
  AddresseeName1,
  AddresseeName2,
  Building,
  StreetName,
  HouseNumber,
  StreetPrefixName1,
  StreetPrefixName2,
  StreetSuffixName1,
  StreetSuffixName2,
  CityName,
  PostalCode,
  Region,
  Country,
  _AddressRepresentationCode._Text.AddressRepresentationDesc : localized AS AddressRepresentationDesclocalized,
  _Region._RegionText.RegionName : localized AS RegionNamelocalized,
  _Country._Text.CountryName : localized AS CountryNamelocalized
FROM R_ProductionSupplyAreaAddrTP
;

Learn More