P_Plant_Fs

DDL: P_PLANT_FS SQL: PPLANTFS Type: view BASIC Package: VDM_MD_PRODUCT_OBSOLETE
17 Fields 6 Data Sources

Priavte Factsheet - Plant

P_Plant_Fs is a Basic CDS View that provides data about "Priavte Factsheet - Plant" in SAP S/4HANA. It reads from 6 data sources and exposes 17 fields with key fields AddressID, OriginCountry, Language, SupplierRegion. Part of development package VDM_MD_PRODUCT_OBSOLETE.

Data Sources (6)

SourceAliasJoin Type
I_MRPController MRPController left_outer
I_Plant Plant left_outer
P_PlantAddrDetails_Fs PlantAddress left_outer
I_ProductPlant PlantName from
I_PurchasingGroup PurchasingGroup left_outer
I_RegionText RegionText left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPLANTFS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY AddressID P_PlantAddrDetails_Fs AddressID Ship-to address
KEY OriginCountry P_PlantAddrDetails_Fs OriginCountry Trip Ctry/Reg
KEY Language P_PlantAddrDetails_Fs Language Report Text Language
KEY SupplierRegion P_PlantAddrDetails_Fs SupplierRegion Resident Region
MRPControllerName I_MRPController MRPControllerName Controller name
PurchasingGroupName I_PurchasingGroup PurchasingGroupName Purchasing Grp. Name
RegionName
PlantName I_Plant PlantName Plant Name
Product I_ProductPlant Product Product Sold
Plant I_ProductPlant Plant Valuation Area
PurchasingGroup I_ProductPlant PurchasingGroup Purchasing Group
MRPResponsible I_ProductPlant MRPResponsible MRP Controller
RegionOfOrigin I_ProductPlant RegionOfOrigin Reg. of Origin
ABCIndicator I_ProductPlant ABCIndicator ABC Indicator
CountryOfOrigin I_ProductPlant CountryOfOrigin Country/Region of Origin
PurchasingGroupPhoneNumber I_PurchasingGroup PurchasingGroupPhoneNumber Tel.No.Purch.Gp
MRPControllerPhoneNumber I_MRPController MRPControllerPhoneNumber

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 P_Plant_Fs.
-- 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: PPLANTFS

CREATE VIEW P_Plant_Fs AS
SELECT
  PlantAddress.AddressID AS AddressID,
  PlantAddress.OriginCountry AS OriginCountry,
  PlantAddress.Language AS Language,
  PlantAddress.SupplierRegion AS SupplierRegion,
  MRPController.MRPControllerName AS MRPControllerName,
  PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  cast (RegionText.RegionName as xregio preserving type) AS RegionName,
  Plant.PlantName AS PlantName,
  PlantName.Product AS Product,
  PlantName.Plant AS Plant,
  PlantName.PurchasingGroup AS PurchasingGroup,
  PlantName.MRPResponsible AS MRPResponsible,
  PlantName.RegionOfOrigin AS RegionOfOrigin,
  PlantName.ABCIndicator AS ABCIndicator,
  PlantName.CountryOfOrigin AS CountryOfOrigin,
  PurchasingGroup.PurchasingGroupPhoneNumber AS PurchasingGroupPhoneNumber,
  MRPController.MRPControllerPhoneNumber AS MRPControllerPhoneNumber
FROM I_ProductPlant AS PlantName
LEFT OUTER JOIN P_PlantAddrDetails_Fs AS PlantAddress ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MRPController AS MRPController ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingGroup AS PurchasingGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RegionText AS RegionText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS Plant ON /* join condition not captured in parsed metadata */
;

Learn More