C_ProdnPlngPlndOrdQuickView

Planned Order Data | view: CPLNDORDQV | Extraction: Not supported | Component: Replenishment Planning & Execution
Tables used: EKKOPRTEMARAADCPADRCADR6KNA1PLAFT001WMARACRTXT024FMKALT001T001KT001WPROJT024RDTXLFA1PRPSCRHDADR2ADR6ADRPT024DUSR02USR21MKAL_AENDMKAL_AENDMARC
Column Name Description
PlannedOrder Planned Order
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
PlndOrderPlannedTotalQty Planned Total Order Quantity
PlndOrderPlannedScrapQty Planned Scrap Quantity
GoodsReceiptQty Quantity of Goods Received
OpenQuantity null
FixedLotSizeQuantity Fixed lot size
MinimumLotSizeQuantity Minimum Lot Size
MaximumLotSizeQuantity Maximum Lot Size
LotSizeRoundingQuantity Rounding value for purchase order quantity
Column Name Description
PlannedOrderOpeningDate Planned Opening Date in Planned Order
PlndOrderPlannedStartDate Planned Order Start Date
PlndOrderPlannedEndDate Planned Order End Date
Column Name Description
MaterialProcurementCategory Material Procurement Category Show values
MaterialProcurementType Material Procurement Type Show values
ProcurementType Material Procurement Category Show values
PlannedOrderType Planned Order Type Show values
Column Name Description Domain name
ProductionSupervisorName Production Supervisor Name TEXT30
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingGroupPhoneNumber null
PurchasingGroupEmailAddress E-Mail Address AD_SMTPADR
MRPControllerName Name of MRP controller TEXT18
InternalContactPersonName Full Name of Person TEXT80
InternalContactPhoneNumber null
InternalContactEmailAddress E-Mail Address AD_SMTPADR
SupplierName Name of Supplier TEXT80
SupplierFullName Supplier Full Name TEXT220
ContactPersonPhoneNumber First telephone number TEXT16
ContactPersonEmailAddress E-Mail Address AD_SMTPADR
SupplyingPlant Planning Plant WERKS
MaterialProcurementTypeName Material Procurement Type Description DDTEXT
MaterialProcurementCatName Material Procurement Category Name DDTEXT
MaterialGoodsReceiptDuration Material Goods Receipt Duration in Days DEC3
PlannedOrderTypeName Planned Order Type Name TEXT60
ProductionPlantName Plant Name TEXT30
ProductionVersionText Short Text for Production Version TEXT40
ProductionLine Production Line for Repetitive Manufacturing ARBPL
ProductionLineText Work Center Text TEXT40
MaterialPlannedDeliveryDurn Material Planned Delivery Duration in Days DEC3
MaterialRoundingProfileName Text, 40 Characters Long TEXT40
MaterialPlannedProductionDurn In-house production time DEC3
TotalReplenishmentLeadDuration Total replenishment lead time (in workdays) DEC3
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
PartnerWBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_PRODNPLNGPLNDORDQUICKVIEW.MANDT == T006.MANDT
  • C_PRODNPLNGPLNDORDQUICKVIEW.BASEUNIT == T006.MSEHI
Material
  • Client
  • Planning material
  • C_PRODNPLNGPLNDORDQUICKVIEW.MANDT == MARA.MANDT
  • C_PRODNPLNGPLNDORDQUICKVIEW.MATERIAL == MARA.MATNR
MRP Controller
  • Client
  • Planning Plant
  • MRP Controller
  • C_PRODNPLNGPLNDORDQUICKVIEW.MANDT == T024D.MANDT
  • C_PRODNPLNGPLNDORDQUICKVIEW.MRPPLANT == T024D.WERKS
  • C_PRODNPLNGPLNDORDQUICKVIEW.MRPCONTROLLER == T024D.DISPO
Plant
  • Client
  • Planning Plant
  • C_PRODNPLNGPLNDORDQUICKVIEW.MANDT == T001W.MANDT
  • C_PRODNPLNGPLNDORDQUICKVIEW.MRPPLANT == T001W.WERKS
Plant
  • Client
  • Production Plant
  • C_PRODNPLNGPLNDORDQUICKVIEW.MANDT == T001W.MANDT
  • C_PRODNPLNGPLNDORDQUICKVIEW.PRODUCTIONPLANT == T001W.WERKS
Planner Group (Routing)
  • Client
  • Production Plant
  • Production Supervisor
  • C_PRODNPLNGPLNDORDQUICKVIEW.MANDT == T024F.MANDT
  • C_PRODNPLNGPLNDORDQUICKVIEW.PRODUCTIONPLANT == T024F.WERKS
  • C_PRODNPLNGPLNDORDQUICKVIEW.PRODUCTIONSUPERVISOR == T024F.FEVOR
Production Version
  • Client
  • Planning material
  • Production Plant
  • Production Version
  • C_PRODNPLNGPLNDORDQUICKVIEW.MANDT == MKAL.MANDT
  • C_PRODNPLNGPLNDORDQUICKVIEW.MATERIAL == MKAL.MATNR
  • C_PRODNPLNGPLNDORDQUICKVIEW.PRODUCTIONPLANT == MKAL.WERKS
  • C_PRODNPLNGPLNDORDQUICKVIEW.PRODUCTIONVERSION == MKAL.VERID
Purchasing Group
  • Client
  • Purchasing Group
  • C_PRODNPLNGPLNDORDQUICKVIEW.MANDT == T024.MANDT
  • C_PRODNPLNGPLNDORDQUICKVIEW.PURCHASINGGROUP == T024.EKGRP
Rounding Profile
  • Client
  • Rounding Profile
  • ?
  • ?
  • C_PRODNPLNGPLNDORDQUICKVIEW.MANDT == RDPR.MANDT
  • C_PRODNPLNGPLNDORDQUICKVIEW.ROUNDINGPROFILE == RDPR.RDPRF
  • C_PRODNPLNGPLNDORDQUICKVIEW.[column in domain "RDZAE"] == RDPR.RDZAE
  • C_PRODNPLNGPLNDORDQUICKVIEW.[column in domain "WERKS_D"] == RDPR.WERKS
Fixed Vendor
  • Client
  • Fixed Vendor
  • C_PRODNPLNGPLNDORDQUICKVIEW.MANDT == LFA1.MANDT
  • C_PRODNPLNGPLNDORDQUICKVIEW.SUPPLIER == LFA1.LIFNR