I_SiteBPMaintainedVH

DDL: I_SITEBPMAINTAINEDVH SQL: ISITEBPM Type: view COMPOSITE Package: VDM_RFM_SITE
10 Fields 1 Data Sources 3 Associations 2 OData Services 1 Fiori Apps

Site with BP assigned

I_SiteBPMaintainedVH is a Composite CDS View that provides data about "Site with BP assigned" in SAP S/4HANA. It reads from 1 data source (I_Site) and exposes 10 fields with key field Site. It has 3 associations to related views. It is exposed through 2 OData services (ASQL_F5375, UI_RFM_SITE_MAINTAIN). It is used in 1 Fiori application: Maintain Retail Site. Part of development package VDM_RFM_SITE.

Data Sources (1)

SourceAliasJoin Type
I_Site I_Site from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_PlantCategoryT _SiteCategoryText $projection.SiteCategory = _SiteCategoryText.PlantCategory
[0..*] I_Address_2 _Address $projection.AddressID = _Address.AddressID
[1..1] I_SiteBPMaintenanceStatus _SiteBPMaintenanceStatus $projection.Site = _SiteBPMaintenanceStatus.Site

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ISITEBPM view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Site with BP assigned view
Consumption.ranked true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Site view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F5375 ASQL_F5375 C2 NOT_RELEASED
UI_RFM_SITE_MAINTAIN UI_RFM_SITE_MAINTAIN V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5375 Maintain Retail Site Transactional An application to maintain relevant information for a retail distribution center or a retail store and facilitate making it functional for business use.

Maintain Retail Site

Business Role: Master Data Specialist - Location Data (Retail)

With this app, as a Master Data Specialist - Location Data Retail you can maintain retail site master data and enable it for functional use such as assigning business partner to the site, profit center assignment to the site, so on. If the site is already functional, then you can review the attributes of the site including the assigned business partner and profit center.

Key Features: Make a site functional by creating a site business partner and establishing the link between site and business partner Assign an already created business partner for the site Create a business partner by navigating to Manage Business Partner app Use copy master data functionality. It is possible as well to copy master data. the business partner ID is created with the same ID as the site ID so on. Assign profit center for site and the assortment is created automatically when business partner assignment to site is saved Add merchandise categories Add supplying sites Define block reason for blocked sites Maintain opening and closing date and time Use copy master data functionality to make multiple sites functional

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Site Site Plant
SiteName SiteName
SiteCategory SiteCategory
AddressID AddressID Ship-to address
CityName _Address CityName Name
PostalCode _Address PostalCode Postal Code
StreetName _Address StreetName Text
_SiteCategoryText _SiteCategoryText
_Address _Address
_SiteBPMaintenanceStatus _SiteBPMaintenanceStatus

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 I_SiteBPMaintainedVH.
-- 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: ISITEBPM

CREATE VIEW I_SiteBPMaintainedVH AS
SELECT
  Site,
  SiteName,
  SiteCategory,
  AddressID,
  _Address.CityName AS CityName,
  _Address.PostalCode AS PostalCode,
  _Address.StreetName AS StreetName
FROM I_Site
LEFT OUTER JOIN I_PlantCategoryT AS _SiteCategoryText ON SiteCategory = _SiteCategoryText.PlantCategory  -- association [0..*]
LEFT OUTER JOIN I_Address_2 AS _Address ON AddressID = _Address.AddressID  -- association [0..*]
LEFT OUTER JOIN I_SiteBPMaintenanceStatus AS _SiteBPMaintenanceStatus ON Site = _SiteBPMaintenanceStatus.Site  -- association [1..1]
;

Learn More