C_PlannedOrderTP

DDL: C_PLANNEDORDERTP Type: view_entity CONSUMPTION
42 Fields 2 Data Sources 1 Associations

Manage Planned Orders

C_PlannedOrderTP is a Consumption CDS View that provides data about "Manage Planned Orders" in SAP S/4HANA. It reads from 2 data sources (I_PlannedOrder, I_SDMAreaOfResponsibility) and exposes 42 fields with key field PlannedOrder. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_PlannedOrder _PlannedOrder from
I_SDMAreaOfResponsibility SDMAreaOfResponsibility inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProductionVersion _ProductionVersion _PlannedOrder.Material = _ProductionVersion.Material and _PlannedOrder.MRPPlant = _ProductionVersion.Plant and _PlannedOrder.ProductionVersion = _ProductionVersion.ProductionVersion

Annotations (9)

NameValueLevelField
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Manage Planned Orders view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY PlannedOrder I_PlannedOrder PlannedOrder Planned Order
Material I_PlannedOrder Material Vehicle Model
MaterialName
BaseUnit I_PlannedOrder BaseUnit Unit of Measure
PlannedTotalQtyInBaseUnit I_PlannedOrder PlannedTotalQtyInBaseUnit
PlannedOrderType I_PlannedOrder PlannedOrderType
PlannedOrderTypeName
PlannedOrderIsConvertible I_PlannedOrder PlannedOrderIsConvertible
PlannedOrderIsFirm I_PlannedOrder PlannedOrderIsFirm
BillOfMaterialStatus I_PlannedOrder BillOfMaterialStatus BOM Status
PlannedOrderCategory I_PlannedOrder PlannedOrderCategory
PlannedOrderCategoryName
MRPArea I_PlannedOrder MRPArea MRP Area
MRPAreaText
MRPPlant I_PlannedOrder MRPPlant Plant
MRPPlantName
ProductionPlant I_PlannedOrder ProductionPlant Prod plnt
ProductionPlantName
MRPController I_PlannedOrder MRPController MRP Controller
MRPControllerName
MaterialProcurementCategory I_PlannedOrder MaterialProcurementCategory Procurement
MaterialProcurementCatName
PlannedOrderOpeningDate I_PlannedOrder PlannedOrderOpeningDate
PlndOrderPlannedStartDate I_PlannedOrder PlndOrderPlannedStartDate
PlndOrderPlannedEndDate I_PlannedOrder PlndOrderPlannedEndDate
ProductionVersion I_PlannedOrder ProductionVersion Version ID
ProductionSupervisor I_PlannedOrder ProductionSupervisor Prodn Supervisor
ProductionSupervisorName
Supplier I_PlannedOrder FixedSupplier Fixed Vendor
ProductionVersionText _ProductionVersion ProductionVersionText
PlannedOrderLongText I_PlannedOrder PlannedOrderLongText Text for ItCat.
PlannedOrderLastChangeDateTime I_PlannedOrder LastChangeDateTime Timestamp
StockSegment I_PlannedOrder StockSegment Stock Segment
MasterPlannedOrder I_PlannedOrder MasterPlannedOrder Master Planned Order
CrossPlantConfigurableProduct Generic Product
ProductCharacteristic1 Product Characteristic 1
ProductCharacteristic2 Product Characteristic 2
ProductCharacteristic3 Product Characteristic 3
ProductSeasonYear I_PlannedOrder ProductSeasonYear Season Year
ProductSeason I_PlannedOrder ProductSeason Season
ProductCollection I_PlannedOrder ProductCollection Collection
ProductTheme I_PlannedOrder ProductTheme Theme

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_PlannedOrderTP.
-- 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_PlannedOrderTP AS
SELECT
  _PlannedOrder.PlannedOrder AS PlannedOrder,
  _PlannedOrder.Material AS Material,
  _PlannedOrder._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  _PlannedOrder.BaseUnit AS BaseUnit,
  _PlannedOrder.PlannedTotalQtyInBaseUnit AS PlannedTotalQtyInBaseUnit,
  _PlannedOrder.PlannedOrderType AS PlannedOrderType,
  _PlannedOrder._PlannedOrderType._Text[1: Language=$session.system_language].PlannedOrderTypeName AS PlannedOrderTypeName,
  _PlannedOrder.PlannedOrderIsConvertible AS PlannedOrderIsConvertible,
  _PlannedOrder.PlannedOrderIsFirm AS PlannedOrderIsFirm,
  _PlannedOrder.BillOfMaterialStatus AS BillOfMaterialStatus,
  _PlannedOrder.PlannedOrderCategory AS PlannedOrderCategory,
  _PlannedOrder._PlannedOrderCategory._Text[1: Language=$session.system_language].PlannedOrderCategoryName AS PlannedOrderCategoryName,
  _PlannedOrder.MRPArea AS MRPArea,
  _PlannedOrder._MRPArea.MRPAreaText AS MRPAreaText,
  _PlannedOrder.MRPPlant AS MRPPlant,
  _PlannedOrder._MRPPlant.PlantName AS MRPPlantName,
  _PlannedOrder.ProductionPlant AS ProductionPlant,
  _PlannedOrder._ProductionPlant.PlantName AS ProductionPlantName,
  _PlannedOrder.MRPController AS MRPController,
  _PlannedOrder._MRPController.MRPControllerName AS MRPControllerName,
  _PlannedOrder.MaterialProcurementCategory AS MaterialProcurementCategory,
  _PlannedOrder._MatlProcurementCategory._Text[1: Language=$session.system_language].MaterialProcurementCatName AS MaterialProcurementCatName,
  _PlannedOrder.PlannedOrderOpeningDate AS PlannedOrderOpeningDate,
  _PlannedOrder.PlndOrderPlannedStartDate AS PlndOrderPlannedStartDate,
  _PlannedOrder.PlndOrderPlannedEndDate AS PlndOrderPlannedEndDate,
  _PlannedOrder.ProductionVersion AS ProductionVersion,
  _PlannedOrder.ProductionSupervisor AS ProductionSupervisor,
  _PlannedOrder._ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  _PlannedOrder.FixedSupplier AS Supplier,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _PlannedOrder.PlannedOrderLongText AS PlannedOrderLongText,
  _PlannedOrder.LastChangeDateTime AS PlannedOrderLastChangeDateTime,
  _PlannedOrder.StockSegment AS StockSegment,
  _PlannedOrder.MasterPlannedOrder AS MasterPlannedOrder,
  _PlannedOrder._Product.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  _PlannedOrder._Product.ProductCharacteristic1 AS ProductCharacteristic1,
  _PlannedOrder._Product.ProductCharacteristic2 AS ProductCharacteristic2,
  _PlannedOrder._Product.ProductCharacteristic3 AS ProductCharacteristic3,
  _PlannedOrder.ProductSeasonYear AS ProductSeasonYear,
  _PlannedOrder.ProductSeason AS ProductSeason,
  _PlannedOrder.ProductCollection AS ProductCollection,
  _PlannedOrder.ProductTheme AS ProductTheme
FROM I_PlannedOrder AS _PlannedOrder
INNER JOIN I_SDMAreaOfResponsibility AS SDMAreaOfResponsibility ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersion ON _PlannedOrder.Material = _ProductionVersion.Material AND _PlannedOrder.MRPPlant = _ProductionVersion.Plant AND _PlannedOrder.ProductionVersion = _ProductionVersion.ProductionVersion  -- association [0..1]
;

Learn More