A_PlannedOrder

Planned Order | view: APLNDORD | Extraction: Not supported | Component: Material Requirements Planning
Tables used: AFKOKBKOEKKOPRTEMARAMAKTPLAFT460CPROJLFA1PRPS
Column Name Description
PlannedOrder Planned Order
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
TotalQuantity Planned Total Order Quantity
PlndOrderPlannedScrapQty Planned Scrap Quantity
GoodsReceiptQty Quantity of Goods Received
IssuedQuantity Issued Quantity
Column Name Description
PlndOrderPlannedStartDate Planned Order Start Date
PlndOrderPlannedStartTime Planned Order Start Time
PlndOrderPlannedEndDate Planned Order End Date
PlndOrderPlannedEndTime Planned Order End Time
PlannedOrderOpeningDate Planned Opening Date in Planned Order
ProductionStartDate Start Date for Production
ProductionEndDate End Date for Production
LastScheduledDate Date of the Last Scheduling
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Earliest finish of operation (time)
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Earliest scheduled start: Execution (time)
Column Name Description
PlannedOrderType Planned Order Type Show values
MaterialProcurementCategory Material Procurement Category Show values
MaterialProcurementType Material Procurement Type Show values
PlannedOrderIsFirm Firming Indicator for Planned Order Data Show values
PlannedOrderIsConvertible Planned Order Conversion Indicator Show values
PlannedOrderBOMIsFixed Fixing Indicator for BOM Explosion Show values
PlannedOrderCapacityIsDsptchd Indicator: Capacity for Planned Order is Dispatched Show values
CapacityRequirementOrigin Capacity Requirement Origin Show values
Column Name Description Domain name
PlannedOrderProfile Planned order profile PASCH
MaterialName Material Description TEXT40
LastChangeDateTime Last Change to Planned Order: Time Stamp TZNTSTMPS
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
Customer Customer Number KUNNR
WBSElementInternalID Work Breakdown Structure Element Internal ID PS_POSNR
WBSElement WBS Element PS_POSID
WBSDescription WBS Element Name TEXT40
Reservation Number of reservation/dependent requirements RSNUM
QuotaArrangement Quota Arrangement QUNUM
QuotaArrangementItem Quota Arrangement Item NUM03
SupplierName Name of Supplier TEXT80
CapacityRequirement ID of the Capacity Requirements Record BEDID
BillOfOperationsGroup Key for Task List Group PLNNR
BillOfOperations Group Counter ALTNR
Master Data Relations Join Conditions
Account Assignment
  • Account Assignment Category
  • Client
  • A_PLANNEDORDER.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • A_PLANNEDORDER.MANDT == T163K.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • A_PLANNEDORDER.BASEUNIT == T006.MSEHI
  • A_PLANNEDORDER.MANDT == T006.MANDT
Task List Type
  • Task List Type
  • Client
  • A_PLANNEDORDER.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • A_PLANNEDORDER.MANDT == TCA01.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • A_PLANNEDORDER.FIXEDSUPPLIER == LFA1.LIFNR
  • A_PLANNEDORDER.MANDT == LFA1.MANDT
Material
  • Planning material
  • Client
  • A_PLANNEDORDER.MATERIAL == MARA.MATNR
  • A_PLANNEDORDER.MANDT == MARA.MANDT
MRP Area
  • MRP Area
  • Client
  • A_PLANNEDORDER.MRPAREA == MDLV.BERID
  • A_PLANNEDORDER.MANDT == MDLV.MANDT
MRP Controller
  • Planning Plant
  • MRP Controller
  • Client
  • A_PLANNEDORDER.MRPPLANT == T024D.WERKS
  • A_PLANNEDORDER.MRPCONTROLLER == T024D.DISPO
  • A_PLANNEDORDER.MANDT == T024D.MANDT
Plant
  • Planning Plant
  • Client
  • A_PLANNEDORDER.MRPPLANT == T001W.WERKS
  • A_PLANNEDORDER.MANDT == T001W.MANDT
Plant
  • Production Plant
  • Client
  • A_PLANNEDORDER.PRODUCTIONPLANT == T001W.WERKS
  • A_PLANNEDORDER.MANDT == T001W.MANDT
Planner Group (Routing)
  • Production Plant
  • Production Supervisor
  • Client
  • A_PLANNEDORDER.PRODUCTIONPLANT == T024F.WERKS
  • A_PLANNEDORDER.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • A_PLANNEDORDER.MANDT == T024F.MANDT
Production Version
  • Production Plant
  • Planning material
  • Production Version
  • Client
  • A_PLANNEDORDER.PRODUCTIONPLANT == MKAL.WERKS
  • A_PLANNEDORDER.MATERIAL == MKAL.MATNR
  • A_PLANNEDORDER.PRODUCTIONVERSION == MKAL.VERID
  • A_PLANNEDORDER.MANDT == MKAL.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • A_PLANNEDORDER.PURCHASINGGROUP == T024.EKGRP
  • A_PLANNEDORDER.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • A_PLANNEDORDER.PURCHASINGORGANIZATION == T024E.EKORG
  • A_PLANNEDORDER.MANDT == T024E.MANDT
Scheduling Type
  • Scheduling Type
  • Client
  • A_PLANNEDORDER.SCHEDULINGTYPE == T482.TERMKZ
  • A_PLANNEDORDER.MANDT == T482.MANDT
Storage Location
  • Planning Plant
  • Storage Location
  • Client
  • A_PLANNEDORDER.MRPPLANT == T001L.WERKS
  • A_PLANNEDORDER.STORAGELOCATION == T001L.LGORT
  • A_PLANNEDORDER.MANDT == T001L.MANDT