C_MRPPlanningSegmentExtVH

DDL: C_MRPPLANNINGSEGMENTEXTVH Type: view_entity CONSUMPTION Package: ODATA_PP_MRP
7 Fields 1 Data Sources 5 OData Services

MRP Planning Segment External Code

C_MRPPlanningSegmentExtVH is a Consumption CDS View that provides data about "MRP Planning Segment External Code" in SAP S/4HANA. It reads from 1 data source (I_MRPPlanningSegment) and exposes 7 fields with key fields MRPPlant, Material, MRPArea, MRPPlanningSegmentType, MRPPlanningSegment. It is exposed through 5 OData services (ASQL_F0246A, ASQL_F0251A, ASQL_F0263A, ...). Part of development package ODATA_PP_MRP.

Data Sources (1)

SourceAliasJoin Type
I_MRPPlanningSegment Planningsegment from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MRP Planning Segment External Code view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view

OData Services (5)

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_F2101A ASQL_F2101A C2 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MRPPlant I_MRPPlanningSegment MRPPlant Plant
KEY Material I_MRPPlanningSegment Material Vehicle Model
KEY MRPArea I_MRPPlanningSegment MRPArea MRP Area
KEY MRPPlanningSegmentType
KEY MRPPlanningSegment I_MRPPlanningSegment MRPPlanningSegment Plng Segmnt No.
KEY MaterialShortageProfile I_MRPPlanningSegment MaterialShortageProfile Shortage Prf.
MRPPlanningSegmentExternalCode MRPPlanningSegmentExternalCode Individual Segment

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_MRPPlanningSegmentExtVH.
-- 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_MRPPlanningSegmentExtVH AS
SELECT
  Planningsegment.MRPPlant AS MRPPlant,
  Planningsegment.Material AS Material,
  Planningsegment.MRPArea AS MRPArea,
  cast(Planningsegment.MRPPlanningSegmentType as plaab) AS MRPPlanningSegmentType,
  Planningsegment.MRPPlanningSegment AS MRPPlanningSegment,
  Planningsegment.MaterialShortageProfile AS MaterialShortageProfile,
  MRPPlanningSegmentExternalCode
FROM I_MRPPlanningSegment AS Planningsegment
;

Learn More