C_SustPlantAddressDEX

DDL: C_SUSTPLANTADDRESSDEX Type: view CONSUMPTION
8 Fields 1 Data Sources

Plant Address data extractor

C_SustPlantAddressDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Plant · Cross Applications

C_SustPlantAddressDEX is a Consumption CDS View (Fact) that provides data about "Plant Address data extractor" in SAP S/4HANA. It reads from 1 data source (I_Plant) and exposes 8 fields with key field Plant.

SAP Help Documentation

CategoryCDS Views for Product Footprint Management
Purpose
This CDS view is used by Product Footprint Management for the data extraction of the relevant plant address. This view provides the necessary address detail data based on the plant. Note The view does not support delta extraction.

Prerequisites
Since the CDS entity uses a privileged access control, access is only possible through the data extraction runtime. Therefore, no additional authorizations are needed.

Structure
Fields used for filtering The main filters are as follows: Field Description Country Country Region Region CityName City name PostalCode Postal code StreetName Street name HouseNumber House number Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentSUS-INT
CapabilitiesData Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is used by Product Footprint Management for the data extraction of the relevant plant address. This view provides the necessary address detail data based on the plant.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_Plant _Plant from

Annotations (17)

NameValueLevelField
EndUserText.label Plant Address data extractor view
AbapCatalog.sqlViewName CSUSTPLNTADRSDEX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.sapObjectNodeType.name Plant view
ObjectModel.modelingPattern #NONE view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #FACT view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Plant I_Plant Plant Valuation Area
AddressID I_Plant AddressID Ship-to address
Country _Address Country Country/Region Key
Region _Address Region Region (State, Province, County)
CityName _Address CityName Name
PostalCode _Address PostalCode City postal code
StreetName _Address StreetName Street
HouseNumber _Address HouseNumber House Number

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_SustPlantAddressDEX.
-- 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_SustPlantAddressDEX AS
SELECT
  _Plant.Plant AS Plant,
  _Plant.AddressID AS AddressID,
  _Address.Country AS Country,
  _Address.Region AS Region,
  _Address.CityName AS CityName,
  _Address.PostalCode AS PostalCode,
  _Address.StreetName AS StreetName,
  _Address.HouseNumber AS HouseNumber
FROM I_Plant AS _Plant
;

Learn More