P_PlannedOrderQuickView

DDL: P_PLANNEDORDERQUICKVIEW SQL: PPPPLNDORDER Type: view BASIC
53 Fields 1 Data Sources 4 Associations

P_PlannedOrderQuickView is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_PlannedOrder) and exposes 53 fields with key field PlannedOrder. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PlannedOrder _PlannedOrder from

Parameters (1)

NameTypeDefault
P_MRPElementCategory delkz

Associations (4)

CardinalityTargetAliasCondition
[0..1] P_DDMRPController _MRPCtrlr $projection.MRPPlant = _MRPCtrlr.Plant and $projection.MRPController = _MRPCtrlr.MRPController
[0..1] I_RoundingPrfText _RoundingProfile $projection.RoundingProfile = _RoundingProfile.MaterialRoundingProfile and $projection.MRPPlant = _RoundingProfile.Plant
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_ProductionVersion _ProdVersion $projection.Material = _ProdVersion.Material and $projection.MRPPlant = _ProdVersion.Plant and $projection.ProductionVersion = _ProdVersion.ProductionVersion

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPPPLNDORDER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.preserveKey true view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY PlannedOrder PlannedOrder Planned Order
Material Material Vehicle Model
MRPPlant MRPPlant Plant
Supplier FixedSupplier Fixed Vendor
MaterialProcurementCategory MaterialProcurementCategory Procurement
ProductionSupervisor ProductionSupervisor Prodn Supervisor
ProductionSupervisorName _ProductionSupervisor ProductionSupervisorName
PurchasingGroup _PurchasingDocument PurchasingGroup Purchasing Group
PurchasingGroupName
PurchasingGroupPhoneNumber
PurchasingGroupEmailAddress
MRPController MRPController MRP Controller
MRPControllerName _MRPCtrlr MRPControllerName Controller name
InternalContactPersonName _MRPCtrlr InternalContactName
InternalContactPhoneNumber _MRPCtrlr PhoneNumber Telephone no.
InternalContactEmailAddress _MRPCtrlr EmailAddress E-Mail Address
SupplierName _Supplier SupplierName Supplier Name
SupplierFullName _Supplier SupplierFullName
ContactPersonPhoneNumber _Supplier PhoneNumber1 Telephone 1
ContactPersonEmailAddress
MaterialProcurementType MaterialProcurementType Spec. procuremt
MaterialProcurementTypeName
MaterialProcurementCatName
PlannedOrderOpeningDate PlannedOrderOpeningDate Opening Date
PlndOrderPlannedStartDate PlndOrderPlannedStartDate Order Start
PlndOrderPlannedEndDate PlndOrderPlannedEndDate Order End Date
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
PlndOrderPlannedTotalQty PlannedTotalQtyInBaseUnit Total Quantity
PlannedOrderType PlannedOrderType
PlannedOrderTypeName
PlndOrderPlannedScrapQty PlannedScrapQtyInBaseUnit Scrap Quantity
GoodsReceiptQty GoodsReceiptQtyInBaseUnit Received
BaseUnit I_PlannedOrder BaseUnit Unit of Measure
ProductionPlant ProductionPlant Prod plnt
ProductionPlantName _ProductionPlant PlantName Plant Name
ProductionVersion ProductionVersion Version ID
ProductionVersionText _ProductionVersion ProductionVersionText
ProductionLine _ProdVersion ProductionLine Production Line
OpenQuantity
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn Pl. Deliv. Time
FixedLotSizeQuantity _ProductSupplyPlanning FixedLotSizeQuantity Fixed lot size
MinimumLotSizeQuantity _ProductSupplyPlanning MinimumLotSizeQuantity Min. Lot Size
MaximumLotSizeQuantity _ProductSupplyPlanning MaximumLotSizeQuantity Max. Lot Size
LotSizeRoundingQuantity _ProductSupplyPlanning LotSizeRoundingQuantity Rounding value
RoundingProfile _ProductSupplyPlanning RoundingProfile Rnding Profile
MaterialRoundingProfileName
MaterialPlannedProductionDurn _ProductSupplyPlanning InHouseProductionTime InhseProdTime
TotalReplenishmentLeadDuration _ProductSupplyPlanning TotalReplenishmentLeadTime Total RL time
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
Customer Customer Sold-to Party
_Customer _Customer
WBSElement _WBSElement WBSElement WBS Internal ID

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_PlannedOrderQuickView.
-- 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: PPPPLNDORDER
-- Parameters: P_MRPElementCategory : delkz

CREATE VIEW P_PlannedOrderQuickView AS
SELECT
  PlannedOrder,
  Material,
  MRPPlant,
  FixedSupplier AS Supplier,
  MaterialProcurementCategory,
  ProductionSupervisor,
  _ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  _PurchasingDocument._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  concat_with_space(_PurchasingDocument._PurchasingGroup.PhoneNumberExtension, _PurchasingDocument._PurchasingGroup.PhoneNumber, 1) AS PurchasingGroupPhoneNumber,
  _PurchasingDocument._PurchasingGroup.EmailAddress AS PurchasingGroupEmailAddress,
  MRPController,
  _MRPCtrlr.MRPControllerName AS MRPControllerName,
  _MRPCtrlr.InternalContactName AS InternalContactPersonName,
  _MRPCtrlr.PhoneNumber AS InternalContactPhoneNumber,
  _MRPCtrlr.EmailAddress AS InternalContactEmailAddress,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.SupplierFullName AS SupplierFullName,
  _Supplier.PhoneNumber1 AS ContactPersonPhoneNumber,
  _Supplier._CurrentDfltEmailAddress.EmailAddress AS ContactPersonEmailAddress,
  MaterialProcurementType,
  _MatlProcurementType._Text[1: Language = $session.system_language ].MaterialProcurementTypeName AS MaterialProcurementTypeName,
  _MatlProcurementCategory._Text[1: Language = $session.system_language ].MaterialProcurementCatName AS MaterialProcurementCatName,
  PlannedOrderOpeningDate,
  PlndOrderPlannedStartDate,
  PlndOrderPlannedEndDate,
  MaterialGoodsReceiptDuration,
  PlannedTotalQtyInBaseUnit AS PlndOrderPlannedTotalQty,
  PlannedOrderType,
  _PlannedOrderType._Text[1: Language = $session.system_language ].PlannedOrderTypeName AS PlannedOrderTypeName,
  PlannedScrapQtyInBaseUnit AS PlndOrderPlannedScrapQty,
  GoodsReceiptQtyInBaseUnit AS GoodsReceiptQty,
  _PlannedOrder.BaseUnit AS BaseUnit,
  ProductionPlant,
  _ProductionPlant.PlantName AS ProductionPlantName,
  ProductionVersion,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _ProdVersion.ProductionLine AS ProductionLine,
  (PlannedTotalQtyInBaseUnit - PlannedScrapQtyInBaseUnit - GoodsReceiptQtyInBaseUnit) AS OpenQuantity,
  MaterialPlannedDeliveryDurn,
  _ProductSupplyPlanning.FixedLotSizeQuantity AS FixedLotSizeQuantity,
  _ProductSupplyPlanning.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  _ProductSupplyPlanning.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  _ProductSupplyPlanning.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  _ProductSupplyPlanning.RoundingProfile AS RoundingProfile,
  _RoundingProfile[1: Language = $session.system_language ].MaterialRoundingProfileName AS MaterialRoundingProfileName,
  _ProductSupplyPlanning.InHouseProductionTime AS MaterialPlannedProductionDurn,
  _ProductSupplyPlanning.TotalReplenishmentLeadTime AS TotalReplenishmentLeadDuration,
  SalesOrder,
  SalesOrderItem,
  Customer,
  _WBSElement.WBSElement AS WBSElement
FROM I_PlannedOrder AS _PlannedOrder
LEFT OUTER JOIN P_DDMRPController AS _MRPCtrlr ON MRPPlant = _MRPCtrlr.Plant AND MRPController = _MRPCtrlr.MRPController  -- association [0..1]
LEFT OUTER JOIN I_RoundingPrfText AS _RoundingProfile ON RoundingProfile = _RoundingProfile.MaterialRoundingProfile AND MRPPlant = _RoundingProfile.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProdVersion ON Material = _ProdVersion.Material AND MRPPlant = _ProdVersion.Plant AND ProductionVersion = _ProdVersion.ProductionVersion  -- association [0..1]
;

Learn More