I_PlantStdVH

DDL: I_PLANTSTDVH Type: view_entity BASIC Package: PLANT
2 Fields 1 Data Sources 207 OData Services 1 Fiori Apps

Plant by Name

I_PlantStdVH (Basic)

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

Database & Data Management

I_PlantStdVH is a Basic CDS View (Dimension) that provides data about "Plant by Name" in SAP S/4HANA. It reads from 1 data source (t001w) and exposes 2 fields with key field Plant. It is exposed through 207 OData services (ASQL_F0246A, ASQL_F0251A, ASQL_F0263A, ...). It is used in 1 Fiori application: Manage Reservation Items. Part of development package PLANT.

SAP Help Documentation

CategoryCDS Views for Common Data
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business question: What is the ID and name of my plant? Note This CDS view is a reuse view to be used as an association in other views, for example. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Business Objects This view is built on the following business entity: Plant Parameters Main input parameters: The view does not have any input parameters. Measures and attributes Some important attributes are: Provides plant details: Client, plant, and plant name. Further important fields Important fields in this view include the following: Field Name Description Mandt Client Plant Plant PlantName Plant Name

SAP Business Warehouse (SAP BW) Extraction
Corresponding DataSource (Extractor) I_Plant Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessDatabase & Data Management
Application ComponentLO-MD-PL-2CL
CapabilitiesData Provider for Value Help
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageDatabase and Data Management for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li> <p>What is the ID and name of my plant?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
t001w t001w from

Annotations (17)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
EndUserText.label Plant by Name view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Plant view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #DIMENSION view
Analytics.technicalName IPLANTSTDVH view
Search.searchable true view
Consumption.ranked true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (207)

ServiceBindingVersionContractRelease
ASQL_F0246A ASQL_F0246A C2 NOT_RELEASED
ASQL_F0251A ASQL_F0251A C2 NOT_RELEASED
ASQL_F0263A ASQL_F0263A C2 NOT_RELEASED
ASQL_F0266B ASQL_F0266B C2 NOT_RELEASED
ASQL_F0311A ASQL_F0311A C2 NOT_RELEASED
ASQL_F0547B ASQL_F0547B C2 NOT_RELEASED
ASQL_F0773 ASQL_F0773 C2 NOT_RELEASED
ASQL_F0859 ASQL_F0859 C2 NOT_RELEASED
ASQL_F1345 ASQL_F1345 C2 NOT_RELEASED
ASQL_F1367 ASQL_F1367 C2 NOT_RELEASED
ASQL_F1425A ASQL_F1425A C2 NOT_RELEASED
ASQL_F1511 ASQL_F1511 C2 NOT_RELEASED
ASQL_F1579 ASQL_F1579 C2 NOT_RELEASED
ASQL_F1597 ASQL_F1597 C2 NOT_RELEASED
ASQL_F1612 ASQL_F1612 C2 NOT_RELEASED
ASQL_F1685A ASQL_F1685A C2 NOT_RELEASED
ASQL_F1688 ASQL_F1688 C2 NOT_RELEASED
ASQL_F1689 ASQL_F1689 C2 NOT_RELEASED
ASQL_F1813A ASQL_F1813A C2 NOT_RELEASED
ASQL_F1956 ASQL_F1956 C2 NOT_RELEASED
ASQL_F2009 ASQL_F2009 C2 NOT_RELEASED
ASQL_F2009A ASQL_F2009A C2 NOT_RELEASED
ASQL_F2035 ASQL_F2035 C2 NOT_RELEASED
ASQL_F2097A ASQL_F2097A C2 NOT_RELEASED
ASQL_F2101A ASQL_F2101A C2 NOT_RELEASED
ASQL_F2218 ASQL_F2218 C2 NOT_RELEASED
ASQL_F2219 ASQL_F2219 C2 NOT_RELEASED
ASQL_F2260 ASQL_F2260 C2 NOT_RELEASED
ASQL_F2265 ASQL_F2265 C2 NOT_RELEASED
ASQL_F2266 ASQL_F2266 C2 NOT_RELEASED
ASQL_F2358 ASQL_F2358 C2 NOT_RELEASED
ASQL_F2359 ASQL_F2359 C2 NOT_RELEASED
ASQL_F2361 ASQL_F2361 C2 NOT_RELEASED
ASQL_F2420 ASQL_F2420 C2 NOT_RELEASED
ASQL_F2421 ASQL_F2421 C2 NOT_RELEASED
ASQL_F2422 ASQL_F2422 C2 NOT_RELEASED
ASQL_F2428 ASQL_F2428 C2 NOT_RELEASED
ASQL_F2538 ASQL_F2538 C2 NOT_RELEASED
ASQL_F2545 ASQL_F2545 C2 NOT_RELEASED
ASQL_F2549 ASQL_F2549 C2 NOT_RELEASED
ASQL_F2593 ASQL_F2593 C2 NOT_RELEASED
ASQL_F2594 ASQL_F2594 C2 NOT_RELEASED
ASQL_F2649 ASQL_F2649 C2 NOT_RELEASED
ASQL_F2668 ASQL_F2668 C2 NOT_RELEASED
ASQL_F2669 ASQL_F2669 C2 NOT_RELEASED
ASQL_F2792 ASQL_F2792 C2 NOT_RELEASED
ASQL_F2810 ASQL_F2810 C2 NOT_RELEASED
ASQL_F2825 ASQL_F2825 C2 NOT_RELEASED
ASQL_F2826 ASQL_F2826 C2 NOT_RELEASED
ASQL_F2827 ASQL_F2827 C2 NOT_RELEASED
ASQL_F2828 ASQL_F2828 C2 NOT_RELEASED
ASQL_F2832 ASQL_F2832 C2 NOT_RELEASED
ASQL_F2914 ASQL_F2914 C2 NOT_RELEASED
ASQL_F2929 ASQL_F2929 C2 NOT_RELEASED
ASQL_F2948 ASQL_F2948 C2 NOT_RELEASED
ASQL_F2987 ASQL_F2987 C2 NOT_RELEASED
ASQL_F3034 ASQL_F3034 C2 NOT_RELEASED
ASQL_F3040 ASQL_F3040 C2 NOT_RELEASED
ASQL_F3065 ASQL_F3065 C2 NOT_RELEASED
ASQL_F3095 ASQL_F3095 C2 NOT_RELEASED
ASQL_F3215 ASQL_F3215 C2 NOT_RELEASED
ASQL_F3233 ASQL_F3233 C2 NOT_RELEASED
ASQL_F3239 ASQL_F3239 C2 NOT_RELEASED
ASQL_F3250 ASQL_F3250 C2 NOT_RELEASED
ASQL_F3289 ASQL_F3289 C2 NOT_RELEASED
ASQL_F3326 ASQL_F3326 C2 NOT_RELEASED
ASQL_F3331 ASQL_F3331 C2 NOT_RELEASED
ASQL_F3342 ASQL_F3342 C2 NOT_RELEASED
ASQL_F3366 ASQL_F3366 C2 NOT_RELEASED
ASQL_F3383 ASQL_F3383 C2 NOT_RELEASED
ASQL_F3423 ASQL_F3423 C2 NOT_RELEASED
ASQL_F3445 ASQL_F3445 C2 NOT_RELEASED
ASQL_F3493 ASQL_F3493 C2 NOT_RELEASED
ASQL_F3498 ASQL_F3498 C2 NOT_RELEASED
ASQL_F3567 ASQL_F3567 C2 NOT_RELEASED
ASQL_F3653 ASQL_F3653 C2 NOT_RELEASED
ASQL_F3669 ASQL_F3669 C2 NOT_RELEASED
ASQL_F3697 ASQL_F3697 C2 NOT_RELEASED
ASQL_F3697A ASQL_F3697A C2 NOT_RELEASED
ASQL_F3717 ASQL_F3717 C2 NOT_RELEASED
ASQL_F3789 ASQL_F3789 C2 NOT_RELEASED
ASQL_F3792 ASQL_F3792 C2 NOT_RELEASED
ASQL_F3799 ASQL_F3799 C2 NOT_RELEASED
ASQL_F3883 ASQL_F3883 C2 NOT_RELEASED
ASQL_F3883A ASQL_F3883A C2 NOT_RELEASED
ASQL_F3888 ASQL_F3888 C2 NOT_RELEASED
ASQL_F3925 ASQL_F3925 C2 NOT_RELEASED
ASQL_F4022 ASQL_F4022 C2 NOT_RELEASED
ASQL_F4051 ASQL_F4051 C2 NOT_RELEASED
ASQL_F4059 ASQL_F4059 C2 NOT_RELEASED
ASQL_F4072 ASQL_F4072 C2 NOT_RELEASED
ASQL_F4170 ASQL_F4170 C2 NOT_RELEASED
ASQL_F4197 ASQL_F4197 C2 NOT_RELEASED
ASQL_F4254 ASQL_F4254 C2 NOT_RELEASED
ASQL_F4272 ASQL_F4272 C2 NOT_RELEASED
ASQL_F4449 ASQL_F4449 C2 NOT_RELEASED
ASQL_F4513 ASQL_F4513 C2 NOT_RELEASED
ASQL_F4557 ASQL_F4557 C2 NOT_RELEASED
ASQL_F4562 ASQL_F4562 C2 NOT_RELEASED
ASQL_F4567 ASQL_F4567 C2 NOT_RELEASED
ASQL_F4569 ASQL_F4569 C2 NOT_RELEASED
ASQL_F4577 ASQL_F4577 C2 NOT_RELEASED
ASQL_F4584 ASQL_F4584 C2 NOT_RELEASED
ASQL_F4587 ASQL_F4587 C2 NOT_RELEASED
ASQL_F4603 ASQL_F4603 C2 NOT_RELEASED
ASQL_F4630 ASQL_F4630 C2 NOT_RELEASED
ASQL_F4682 ASQL_F4682 C2 NOT_RELEASED
ASQL_F4692 ASQL_F4692 C2 NOT_RELEASED
ASQL_F4713 ASQL_F4713 C2 NOT_RELEASED
ASQL_F4785 ASQL_F4785 C2 NOT_RELEASED
ASQL_F4786 ASQL_F4786 C2 NOT_RELEASED
ASQL_F4795 ASQL_F4795 C2 NOT_RELEASED
ASQL_F4796 ASQL_F4796 C2 NOT_RELEASED
ASQL_F4851 ASQL_F4851 C2 NOT_RELEASED
ASQL_F4959 ASQL_F4959 C2 NOT_RELEASED
ASQL_F4989 ASQL_F4989 C2 NOT_RELEASED
ASQL_F5026 ASQL_F5026 C2 NOT_RELEASED
ASQL_F5082 ASQL_F5082 C2 NOT_RELEASED
ASQL_F5133 ASQL_F5133 C2 NOT_RELEASED
ASQL_F5147 ASQL_F5147 C2 NOT_RELEASED
ASQL_F5241 ASQL_F5241 C2 NOT_RELEASED
ASQL_F5274 ASQL_F5274 C2 NOT_RELEASED
ASQL_F5314 ASQL_F5314 C2 NOT_RELEASED
ASQL_F5323 ASQL_F5323 C2 NOT_RELEASED
ASQL_F5381 ASQL_F5381 C2 NOT_RELEASED
ASQL_F5416 ASQL_F5416 C2 NOT_RELEASED
ASQL_F5430 ASQL_F5430 C2 NOT_RELEASED
ASQL_F5445 ASQL_F5445 C2 NOT_RELEASED
ASQL_F5509 ASQL_F5509 C2 NOT_RELEASED
ASQL_F5513 ASQL_F5513 C2 NOT_RELEASED
ASQL_F5514 ASQL_F5514 C2 NOT_RELEASED
ASQL_F5549 ASQL_F5549 C2 NOT_RELEASED
ASQL_F5563 ASQL_F5563 C2 NOT_RELEASED
ASQL_F5601 ASQL_F5601 C2 NOT_RELEASED
ASQL_F5690 ASQL_F5690 C2 NOT_RELEASED
ASQL_F5723 ASQL_F5723 C2 NOT_RELEASED
ASQL_F5726 ASQL_F5726 C2 NOT_RELEASED
ASQL_F5757 ASQL_F5757 C2 NOT_RELEASED
ASQL_F5763 ASQL_F5763 C2 NOT_RELEASED
ASQL_F5785 ASQL_F5785 C2 NOT_RELEASED
ASQL_F5786 ASQL_F5786 C2 NOT_RELEASED
ASQL_F5796 ASQL_F5796 C2 NOT_RELEASED
ASQL_F5938 ASQL_F5938 C2 NOT_RELEASED
ASQL_F5983 ASQL_F5983 C2 NOT_RELEASED
ASQL_F5987 ASQL_F5987 C2 NOT_RELEASED
ASQL_F6070 ASQL_F6070 C2 NOT_RELEASED
ASQL_F6109 ASQL_F6109 C2 NOT_RELEASED
ASQL_F6215 ASQL_F6215 C2 NOT_RELEASED
ASQL_F6248 ASQL_F6248 C2 NOT_RELEASED
ASQL_F6394 ASQL_F6394 C2 NOT_RELEASED
ASQL_F6400 ASQL_F6400 C2 NOT_RELEASED
ASQL_F6664 ASQL_F6664 C2 NOT_RELEASED
ASQL_F6716 ASQL_F6716 C2 NOT_RELEASED
ASQL_F6728 ASQL_F6728 C2 NOT_RELEASED
ASQL_F6764 ASQL_F6764 C2 NOT_RELEASED
ASQL_F6798 ASQL_F6798 C2 NOT_RELEASED
ASQL_F6842 ASQL_F6842 C2 NOT_RELEASED
ASQL_F6852 ASQL_F6852 C2 NOT_RELEASED
ASQL_F6879 ASQL_F6879 C2 NOT_RELEASED
ASQL_F6935 ASQL_F6935 C2 NOT_RELEASED
ASQL_F6965 ASQL_F6965 C2 NOT_RELEASED
ASQL_F7044 ASQL_F7044 C2 NOT_RELEASED
ASQL_F7047 ASQL_F7047 C2 NOT_RELEASED
ASQL_F7103 ASQL_F7103 C2 NOT_RELEASED
ASQL_F7147 ASQL_F7147 C2 NOT_RELEASED
ASQL_F7204A ASQL_F7204A C2 NOT_RELEASED
ASQL_F7205A ASQL_F7205A C2 NOT_RELEASED
ASQL_F7279 ASQL_F7279 C2 NOT_RELEASED
ASQL_F7311 ASQL_F7311 C2 NOT_RELEASED
ASQL_F7349 ASQL_F7349 C2 NOT_RELEASED
ASQL_F7551 ASQL_F7551 C2 NOT_RELEASED
ASQL_F7650 ASQL_F7650 C2 NOT_RELEASED
ASQL_F7681 ASQL_F7681 C2 NOT_RELEASED
ASQL_F7900 ASQL_F7900 C2 NOT_RELEASED
ASQL_F7933 ASQL_F7933 C2 NOT_RELEASED
ASQL_F7934 ASQL_F7934 C2 NOT_RELEASED
ASQL_F8392 ASQL_F8392 C2 NOT_RELEASED
ASQL_F8464 ASQL_F8464 C2 NOT_RELEASED
ASQL_F8537 ASQL_F8537 C2 NOT_RELEASED
ASQL_F8634 ASQL_F8634 C2 NOT_RELEASED
ASQL_F8685 ASQL_F8685 C2 NOT_RELEASED
ASQL_F8712 ASQL_F8712 C2 NOT_RELEASED
ASQL_F8725 ASQL_F8725 C2 NOT_RELEASED
ASQL_F8755 ASQL_F8755 C2 NOT_RELEASED
ASQL_F8756 ASQL_F8756 C2 NOT_RELEASED
ASQL_F8757 ASQL_F8757 C2 NOT_RELEASED
ASQL_F8764 ASQL_F8764 C2 NOT_RELEASED
ASQL_F8793 ASQL_F8793 C2 NOT_RELEASED
ASQL_F8794 ASQL_F8794 C2 NOT_RELEASED
ASQL_F8795 ASQL_F8795 C2 NOT_RELEASED
ASQL_F8796 ASQL_F8796 C2 NOT_RELEASED
ASQL_F8982 ASQL_F8982 C2 NOT_RELEASED
ASQL_F9014 ASQL_F9014 C2 NOT_RELEASED
ASQL_F9245 ASQL_F9245 C2 NOT_RELEASED
BOMEXPLOSION BOM_EXPLOSION_V2 V2 C1 NOT_TO_BE_RELEASED_STABLE
C_PPAREAOFRESPONSIBILITY_SD PP_MPE_AOR_SRV V4 C1 NOT_RELEASED
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
UI_CREDITMEMOREQUESTMANAGE UI_CREDITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_CUSTOMERRETURNMANAGE UI_CUSTOMERRETURNMANAGE V4 C1 NOT_RELEASED
UI_DEBITMEMOREQUESTMANAGE UI_DEBITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_INBOUNDDELIVERYMANAGE UI_INBOUNDDELIVERYMANAGE V4 C1 NOT_RELEASED
UI_QLTYCMPLAGNSTSUPLRMNG UI_QLTYCMPLAGNSTSUPLRMNG V4 C1 NOT_RELEASED
UI_RESERVATION_ITM_MNG_V2 UI_RESERVATION_ITM_MNG_V2 V2 C1 NOT_RELEASED
UI_SALESCONTRACTMANAGE UI_SALESCONTRACTMANAGE V4 C1 NOT_RELEASED
UI_SALESDOCUMENTMANAGE UI_SALESDOCUMENTMANAGE V4 C1 NOT_RELEASED
UI_SALESQUOTATIONMANAGE UI_SALESQUOTATIONMANAGE V4 C1 NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE UI_SLSORDERWITHOUTCHARGEMANAGE V4 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5601 Manage Reservation Items Transactional With this App you can display Reservation items, create and copy Reservations.

Manage Reservation Items

Business Role: Warehouse Clerk

This app enables you to view the items of a reservation. It is also possible to create, copy and maintain Manual Reservations as well as mark items as deleted for Manual Reservations.

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Plant werks Receiving Plant
PlantName Plant Name

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_PlantStdVH.
-- 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 I_PlantStdVH AS
SELECT
  werks AS Plant,
  cast(name1 as werks_name) AS PlantName
FROM t001w
;

Learn More