I_LogisticsOrderBasic

Logistics Order Basic | view: ILOGSORDBASIC | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFKO
Column Name Description
OrderID FK Order Number
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OrderPlannedTotalQty Total Order Quantity
OrderPlannedScrapQty Total Scrap Quantity in the Order
OrderConfirmedYieldQty Confirmed Yield Quantity From Order Confirmation
OrderConfirmedScrapQty Confirmed Scrap Quantity From Order Confirmation
MfgOrderConfirmedReworkQty Total Confirmed Rework Quantity
TotalConfirmedQuantity null
MaterialFromLotSizeQuantity From Lot Size
MaterialToLotSizeQuantity To Lot Size
Column Name Description
BOOExplosionDate Date for Routing Explosion
BOOValidityStartDate Valid-From Date
BOMExplosionDate Date of BOM Explosion/Routing Transfer
BOMValidityStartDate Valid-From Date
PlannedStartDate Basic Start Date
PlannedStartTime Basic Start (Time)
PlannedEndDate Basic finish date
PlannedEndTime Basic Finish (Time)
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
ScheduledReleaseDate Scheduled release date
ActualStartDate Actual start date
ActualStartTime Actual start time
ActualEndDate Actual finish date
ActualReleasedDate Actual release date
ConfirmedEndDate Confirmed Order Finish Date
ConfirmedEndTime Confirmed Order Finish (Time)
ScheduledForecastedStartDate Scheduled forecast start
ScheduledForecastedStartTime Scheduled start time (Forecast)
ScheduledForecastedEndDate Scheduled forecast finish
ScheduledForecastedEndTime Scheduled forecast finish time
ScheduledFcstdReleaseDate Scheduled release date (forecast)
ForecastedStartDate Forecast start date
ForecastedStartTime Forecast start (time)
ForecastedEndDate Finish date (forecast)
ForecastedEndTime Forecast finish (time)
TotalCommitmentDate Total Commitment Date
LastScheduledDate Date of the Last Scheduling
Column Name Description
MfgOrderIsPartOfCollvOrder Order is Part of Collective Order Show values
OrderIsNotCostedAutomatically Indicator: Do not cost automatically Show values
OrdIsNotSchedldAutomatically Indicator: Do not schedule automatically Show values
ProdnProcgIsFlexible Flexible Processing Show values
ProdAvailyCheckPlanningType Basis for scheduling Show values
NtwkAccountAssignmentCode Indicator for the account assignment of a network(hdr/act.) Show values
CapacityRqmtHasNotToBeCreated Indicator: Do not Create Capacity Requirements Show values
BillOfMaterialCategory Bill of Material Category Code Show values
Column Name Description Domain name
OrderInternalID Order Internal ID AUFPL
PriorityCode Order priority CHAR1
MfgOrderHierarchyLevel Level (in multi-level BOM explosions) DEC2
MfgOrderSuperiorMfgOrder Number of Superior Order AUFNR
SuperiorProjectNetwork Number of superior network AUFNR
Reservation Number of reservation/dependent requirements RSNUM
SettlementReservation Number of reservation/dependent requirements RSNUM
MfgOrderConfirmation Completion confirmation number for the operation CO_RUECK
MfgOrderConfirmationCount Internal counter CIM_COUNT
CapacityRequirement ID of the Capacity Requirements Record BEDID
InspectionLot Inspection Lot Number QPLOS
ForecastSchedulingType Scheduling type (forecast) TERART
ProductConfiguration Configuration (internal object number) CUOBJ
MaterialRevisionLevel Revision Level VDM_QM_REVLV
CapacityActiveVersion Version of Available Capacity KAPVERSION
OrderSequenceNumber Sequence Number Order CY_SEQNR
ActualCostsCostingVariant Costing Variant For Actual Costs KLVAR
PlannedCostsCostingVariant Costing Variant for Planned Costs KLVAR
BillOfOperationsType Bill of Operations Type PLNTY
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Variant ALTNR
BOOInternalVersionCounter Internal counter CIM_COUNT
BillOfOperationsVersion Routing Version PLNVERSN
BillOfOperations Key for Task List Group PLNNR
BillOfMaterial Bill of Material STNUM
BillOfMaterialVariant Alternative BOM ALTNR
BillOfMaterialVersion BOM Version CS_VERSN
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_LOGISTICSORDERBASIC.BASEUNIT == T006.MSEHI
  • I_LOGISTICSORDERBASIC.MANDT == T006.MANDT
Scheduling type
  • Scheduling type
  • Client
  • I_LOGISTICSORDERBASIC.BASICSCHEDULINGTYPE == T482.TERMKZ
  • I_LOGISTICSORDERBASIC.MANDT == T482.MANDT
BOM Usage
  • Client
  • BOM Usage
  • I_LOGISTICSORDERBASIC.MANDT == T416.MANDT
  • I_LOGISTICSORDERBASIC.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
Task List Usage
  • Client
  • Bill of Operations Usage
  • I_LOGISTICSORDERBASIC.MANDT == T411.MANDT
  • I_LOGISTICSORDERBASIC.BILLOFOPERATIONSUSAGE == T411.VERWE
Change Number
  • Change Number
  • Client
  • I_LOGISTICSORDERBASIC.CHANGENUMBER == AENR.AENNR
  • I_LOGISTICSORDERBASIC.MANDT == AENR.MANDT
Leading Order in Current Processing
  • Leading Order in Current Processing
  • Client
  • I_LOGISTICSORDERBASIC.LEADINGORDER == AUFK.AUFNR
  • I_LOGISTICSORDERBASIC.MANDT == AUFK.MANDT
Bill of Operations Material
  • Client
  • Bill of Operations Material
  • I_LOGISTICSORDERBASIC.MANDT == MARA.MANDT
  • I_LOGISTICSORDERBASIC.MATERIAL == MARA.MATNR
MRP Controller Group
  • Client
  • MRP Controller
  • ?
  • I_LOGISTICSORDERBASIC.MANDT == T024D.MANDT
  • I_LOGISTICSORDERBASIC.MRPCONTROLLER == T024D.DISPO
  • I_LOGISTICSORDERBASIC.[column in domain "WERKS_D"] == T024D.WERKS
Network Profile
  • Client
  • ?
  • Network Profile
  • I_LOGISTICSORDERBASIC.MANDT == TCN41.MANDT
  • I_LOGISTICSORDERBASIC.[column in domain "PLNAW"] == TCN41.PLNAW
  • I_LOGISTICSORDERBASIC.NETWORKPROFILE == TCN41.PROFIDNETZ
Order Number
  • Client
  • Order Number
  • I_LOGISTICSORDERBASIC.MANDT == AUFK.MANDT
  • I_LOGISTICSORDERBASIC.ORDERID == AUFK.AUFNR
Production Scheduling Profile
  • Client
  • Production Scheduling Profile
  • ?
  • I_LOGISTICSORDERBASIC.MANDT == TCO43.MANDT
  • I_LOGISTICSORDERBASIC.PRODUCTIONSCHEDULINGPROFILE == TCO43.CO_PRODPRF
  • I_LOGISTICSORDERBASIC.[column in domain "WERKS_D"] == TCO43.WERKS
Production Supervisor
  • Production Supervisor
  • Client
  • ?
  • I_LOGISTICSORDERBASIC.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • I_LOGISTICSORDERBASIC.MANDT == T024F.MANDT
  • I_LOGISTICSORDERBASIC.[column in domain "WERKS_D"] == T024F.WERKS
Project (internal)
  • Client
  • Project (internal)
  • I_LOGISTICSORDERBASIC.MANDT == PROJ.MANDT
  • I_LOGISTICSORDERBASIC.PROJECTINTERNALID == PROJ.PSPNR
Other Relations | to Master Data Relations ↑ Join Conditions
Responsible Planner Group or Department
  • Responsible Planner Group or Department
  • Client
  • ?
  • I_LOGISTICSORDERBASIC.RESPONSIBLEPLANNERGROUP == T024A.FEVOR
  • I_LOGISTICSORDERBASIC.MANDT == T024A.MANDT
  • I_LOGISTICSORDERBASIC.[column in domain "WERKS_D"] == T024A.WERKS