C_ProdnPlngPlndOrdQuickView

DDL: C_PRODNPLNGPLNDORDQUICKVIEW SQL: CPLNDORDQV Type: view CONSUMPTION
56 Fields 1 Data Sources

Planned Order Data

C_ProdnPlngPlndOrdQuickView is a Consumption CDS View that provides data about "Planned Order Data" in SAP S/4HANA. It reads from 1 data source (I_PlannedOrderQuickView) and exposes 56 fields with key field PlannedOrder.

Data Sources (1)

SourceAliasJoin Type
I_PlannedOrderQuickView I_PlannedOrderQuickView from

Parameters (1)

NameTypeDefault
P_MRPElementCategory delkz

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPLNDORDQV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Planned Order Data view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY PlannedOrder PlannedOrder
Material Material Vehicle Model
MRPPlant MRPPlant Plant
Supplier Supplier Supplier
MaterialProcurementCategory MaterialProcurementCategory Procurement
ProductionSupervisor ProductionSupervisor Prodn Supervisor
ProductionSupervisorName ProductionSupervisorName
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName PurchasingGroupName Purchasing Grp. Name
PurchasingGroupPhoneNumber PurchasingGroupPhoneNumber Tel.No.Purch.Gp
PurchasingGroupEmailAddress PurchasingGroupEmailAddress
MRPController MRPController MRP Controller
MRPControllerName MRPControllerName Controller name
InternalContactPersonName InternalContactPersonName
InternalContactPhoneNumber InternalContactPhoneNumber
InternalContactEmailAddress InternalContactEmailAddress
SupplierName SupplierName Supplier Name
SupplierFullName SupplierFullName
ContactPersonPhoneNumber ContactPersonPhoneNumber Telephone No.
ContactPersonEmailAddress ContactPersonEmailAddress Email
SupplyingPlant SupplyingPlant Supplying Plant
MaterialProcurementType MaterialProcurementType Spec. procuremt
MaterialProcurementTypeName MaterialProcurementTypeName
ProcurementType ProcurementType Procurement
MaterialProcurementCatName MaterialProcurementCatName
PlannedOrderOpeningDate PlannedOrderOpeningDate
PlndOrderPlannedStartDate PlndOrderPlannedStartDate
PlndOrderPlannedEndDate PlndOrderPlannedEndDate
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
PlndOrderPlannedTotalQty PlndOrderPlannedTotalQty
PlannedOrderType PlannedOrderType
PlannedOrderTypeName PlannedOrderTypeName
PlndOrderPlannedScrapQty PlndOrderPlannedScrapQty
GoodsReceiptQty GoodsReceiptQty Quantity
BaseUnit BaseUnit Unit of Measure
ProductionPlant ProductionPlant Prod plnt
ProductionPlantName ProductionPlantName
ProductionVersion ProductionVersion Version ID
ProductionVersionText ProductionVersionText
ProductionLine ProductionLine Production Line
ProductionLineText ProductionLineText Work Center Text
OpenQuantity OpenQuantity PBE Entry Open Qty
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn Pl. Deliv. Time
FixedLotSizeQuantity FixedLotSizeQuantity Fixed lot size
MinimumLotSizeQuantity MinimumLotSizeQuantity Min. Lot Size
MaximumLotSizeQuantity MaximumLotSizeQuantity Max. Lot Size
LotSizeRoundingQuantity LotSizeRoundingQuantity Rounding value
RoundingProfile RoundingProfile Rnding Profile
MaterialRoundingProfileName MaterialRoundingProfileName
MaterialPlannedProductionDurn MaterialPlannedProductionDurn InhseProdTime
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration Total RL time
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
Customer Customer Sold-to Party
BPCustomerName BPCustomerName Name of Customer
PartnerWBSElement 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 C_ProdnPlngPlndOrdQuickView.
-- 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: CPLNDORDQV
-- Parameters: P_MRPElementCategory : delkz

CREATE VIEW C_ProdnPlngPlndOrdQuickView AS
SELECT
  PlannedOrder,
  Material,
  MRPPlant,
  Supplier,
  MaterialProcurementCategory,
  ProductionSupervisor,
  ProductionSupervisorName,
  PurchasingGroup,
  PurchasingGroupName,
  PurchasingGroupPhoneNumber,
  PurchasingGroupEmailAddress,
  MRPController,
  MRPControllerName,
  InternalContactPersonName,
  InternalContactPhoneNumber,
  InternalContactEmailAddress,
  SupplierName,
  SupplierFullName,
  ContactPersonPhoneNumber,
  ContactPersonEmailAddress,
  SupplyingPlant,
  MaterialProcurementType,
  MaterialProcurementTypeName,
  ProcurementType,
  MaterialProcurementCatName,
  PlannedOrderOpeningDate,
  PlndOrderPlannedStartDate,
  PlndOrderPlannedEndDate,
  MaterialGoodsReceiptDuration,
  PlndOrderPlannedTotalQty,
  PlannedOrderType,
  PlannedOrderTypeName,
  PlndOrderPlannedScrapQty,
  GoodsReceiptQty,
  BaseUnit,
  ProductionPlant,
  ProductionPlantName,
  ProductionVersion,
  ProductionVersionText,
  ProductionLine,
  ProductionLineText,
  OpenQuantity,
  MaterialPlannedDeliveryDurn,
  FixedLotSizeQuantity,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  LotSizeRoundingQuantity,
  RoundingProfile,
  MaterialRoundingProfileName,
  MaterialPlannedProductionDurn,
  TotalReplenishmentLeadDuration,
  SalesOrder,
  SalesOrderItem,
  Customer,
  BPCustomerName,
  WBSElement AS PartnerWBSElement
FROM I_PlannedOrderQuickView
;

Learn More