I_LogisticsOrder

Logistics Order | view: ILOGISTCSORDER | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFKO, AUFK
Column Name Description
OrderID Order Number
Column Name Description
💲 Order Currency (Currency):
EstimatedTotalOrderCost Estimated total costs of order
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
MaterialFromLotSizeQuantity From Lot Size
MaterialToLotSizeQuantity To Lot Size
📏 Base Unit of Measure (MaterialBaseUnit):
PlannedTotalQtyInBaseUnit Base quantity
Column Name Description
CreationDate Created On
CreationTime Time created
LastChangeDate Change Date for Order Master
LastChangeTime Changed At
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
PlannedReleaseDate Planned release date
PlannedCompletionDate Planned completion date
TechnicalCompletionDate Technical Completion Date
Column Name Description
OrderCategory Order Category Show values
OrderHasLongText Order Has Long Text Show values
IsMarkedForDeletion Deletion Flag Show values
MfgOrderHasMultipleItems Order Has Multiple Items Show values
MfgOrderIsPartOfCollvOrder Order is Part of Collective Order Show values
OrderIsRefurbishmentOrder Refurbishment order indicator (PM) Show values
IsStatisticalOrder Identifier for Statistical Order Show values
ProdnProcgIsFlexible Flexible Processing Show values
OrderIsEventBasedPosting Event-Based Posting Show values
ProdAvailyCheckPlanningType Basis for scheduling Show values
NtwkAccountAssignmentCode Indicator for the account assignment of a network(hdr/act.) Show values
OrderIsNotCostedAutomatically Indicator: Do not cost automatically Show values
OrdIsNotSchedldAutomatically Indicator: Do not schedule automatically Show values
CapacityRqmtHasNotToBeCreated Indicator: Do not Create Capacity Requirements Show values
MfgOrderSplitStatus Status of an Order in a Split Hierarchy Show values
ControllingObjectClass Controlling Object Class Show values
JointVentureOriginalCostObject JV original cost object Show values
BillOfMaterialCategory Bill of Material Category Code Show values
Column Name Description Domain name
OrderDescription Order Description TEXT40
MfgOrderSuperiorMfgOrder Number of Superior Order AUFNR
PriorityCode Order priority CHAR1
MfgOrderHierarchyLevel Level (in multi-level BOM explosions) DEC2
CreatedByUser Entered By USNAM
LastChangedByUser Last Changed By USNAM
OrderInternalBillOfOperations Routing number of operations in the order AUFPL
MainWorkCenter Main work center for maintenance tasks ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
SalesOrder Sales Order Number VBELN
SalesOrderItem Item number in Sales Order NUM06
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
ExternalOrder External order number AUFEX
OverheadCode Overhead key CHAR6
CapacityActiveVersion Version of Available Capacity KAPVERSION
OrderSequenceNumber Sequence Number Order CY_SEQNR
MaterialRevisionLevel Revision Level REVLV
MaterialRevisionLevel_2 Revision Level VDM_QM_REVLV
ProductCostCollector Cost Collector for Production Process AUFNR
JointVentureObjectType Joint Venture Object Type JV_OTYPE
ActualCostsCostingVariant Costing Variant For Actual Costs KLVAR
PlannedCostsCostingVariant Costing Variant for Planned Costs KLVAR
BillOfOperationsType Bill of Operations Type PLNTY
BillOfOperations Bill of Operations ID PLNNR
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Variant ALTNR
BOOInternalVersionCounter Internal counter CIM_COUNT
BillOfOperationsVersion Routing Version PLNVERSN
BillOfMaterial Bill of Material STNUM
BillOfMaterialInternalID Bill Of Material PPH_STNUM
BillOfMaterialVariant Alternative BOM ALTNR
BillOfMaterialVersion BOM Version CS_VERSN
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_LOGISTICSORDER.MANDT == T006.MANDT
  • I_LOGISTICSORDER.BASEUNIT == T006.MSEHI
Scheduling type
  • Scheduling type
  • Client
  • I_LOGISTICSORDER.BASICSCHEDULINGTYPE == T482.TERMKZ
  • I_LOGISTICSORDER.MANDT == T482.MANDT
BOM Usage
  • Client
  • BOM Usage
  • I_LOGISTICSORDER.MANDT == T416.MANDT
  • I_LOGISTICSORDER.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
Task List Usage
  • Client
  • Bill of Operations Usage
  • I_LOGISTICSORDER.MANDT == T411.MANDT
  • I_LOGISTICSORDER.BILLOFOPERATIONSUSAGE == T411.VERWE
Business Area
  • Client
  • Business Area
  • I_LOGISTICSORDER.MANDT == TGSB.MANDT
  • I_LOGISTICSORDER.BUSINESSAREA == TGSB.GSBER
Change Number
  • Change Number
  • Change Number
  • Client
  • I_LOGISTICSORDER.CHANGENUMBER == AENR.AENNR
  • I_LOGISTICSORDER.ENGINEERINGCHANGEORDER == AENR.AENNR
  • I_LOGISTICSORDER.MANDT == AENR.MANDT
Company Code
  • Client
  • Company Code
  • I_LOGISTICSORDER.MANDT == T001.MANDT
  • I_LOGISTICSORDER.COMPANYCODE == T001.BUKRS
Application I_LOGISTICSORDER.CONDITIONAPPLICATION == T681A.KAPPL
Controlling Area
  • Client
  • Controlling Area
  • I_LOGISTICSORDER.MANDT == TKA01.MANDT
  • I_LOGISTICSORDER.CONTROLLINGAREA == TKA01.KOKRS
Cost Center for Basic Settlement
  • ?
  • Cost Center for Basic Settlement
  • Client
  • Controlling Area
  • I_LOGISTICSORDER.[column in domain "DATBI"] == CSKS.DATBI
  • I_LOGISTICSORDER.COSTCENTER == CSKS.KOSTL
  • I_LOGISTICSORDER.MANDT == CSKS.MANDT
  • I_LOGISTICSORDER.CONTROLLINGAREA == CSKS.KOKRS
Settlement Cost Element
  • Settlement Cost Element
  • ?
  • Client
  • Controlling Area
  • I_LOGISTICSORDER.COSTELEMENT == CSKB.KSTAR
  • I_LOGISTICSORDER.[column in domain "DATBI"] == CSKB.DATBI
  • I_LOGISTICSORDER.MANDT == CSKB.MANDT
  • I_LOGISTICSORDER.CONTROLLINGAREA == CSKB.KOKRS
Costing Sheet
  • Application
  • Costing Sheet
  • Client
  • ?
  • I_LOGISTICSORDER.CONDITIONAPPLICATION == T683.KAPPL
  • I_LOGISTICSORDER.COSTINGSHEET == T683.KALSM
  • I_LOGISTICSORDER.MANDT == T683.MANDT
  • I_LOGISTICSORDER.[column in domain "KVEWE"] == T683.KVEWE
Order Currency
  • Client
  • Order Currency
  • I_LOGISTICSORDER.MANDT == TCURC.MANDT
  • I_LOGISTICSORDER.CURRENCY == TCURC.WAERS
Change Number
  • Change Number
  • Change Number
  • Client
  • I_LOGISTICSORDER.CHANGENUMBER == AENR.AENNR
  • I_LOGISTICSORDER.ENGINEERINGCHANGEORDER == AENR.AENNR
  • I_LOGISTICSORDER.MANDT == AENR.MANDT
Reason for Environmental Investment
  • Client
  • Reason for Environmental Investment
  • I_LOGISTICSORDER.MANDT == T087K.MANDT
  • I_LOGISTICSORDER.ENVIRONMENTALINVESTMENTREASON == T087K.UMWKZ
Functional Area
  • Functional Area
  • Client
  • I_LOGISTICSORDER.FUNCTIONALAREA == TFKB.FKBER
  • I_LOGISTICSORDER.MANDT == TFKB.MANDT
G/L Account for Basic Settlement
  • G/L Account for Basic Settlement
  • Client
  • Company Code
  • I_LOGISTICSORDER.GLACCOUNT == SKB1.SAKNR
  • I_LOGISTICSORDER.MANDT == SKB1.MANDT
  • I_LOGISTICSORDER.COMPANYCODE == SKB1.BUKRS
Reason for Investment
  • Client
  • Reason for Investment
  • I_LOGISTICSORDER.MANDT == T087I.MANDT
  • I_LOGISTICSORDER.INVESTMENTREASON == T087I.IZWEK
Joint venture
  • Client
  • Joint venture
  • Company Code
  • I_LOGISTICSORDER.MANDT == T8JV.MANDT
  • I_LOGISTICSORDER.JOINTVENTURE == T8JV.VNAME
  • I_LOGISTICSORDER.COMPANYCODE == T8JV.BUKRS
JIB/JIBE Class
  • JIB/JIBE Class
  • Client
  • Company Code
  • I_LOGISTICSORDER.JOINTVENTURECLASS == T8J6A.CLASS
  • I_LOGISTICSORDER.MANDT == T8J6A.MANDT
  • I_LOGISTICSORDER.COMPANYCODE == T8J6A.BUKRS
JIB/JIBE Subclass A
  • JIB/JIBE Class
  • Client
  • Company Code
  • JIB/JIBE Subclass A
  • I_LOGISTICSORDER.JOINTVENTURECLASS == T8J6C.CLASS
  • I_LOGISTICSORDER.MANDT == T8J6C.MANDT
  • I_LOGISTICSORDER.COMPANYCODE == T8J6C.BUKRS
  • I_LOGISTICSORDER.JOINTVENTURESUBCLASS == T8J6C.SUBCLASS
Leading Order in Current Processing
  • Leading Order in Current Processing
  • Client
  • I_LOGISTICSORDER.LEADINGORDER == AUFK.AUFNR
  • I_LOGISTICSORDER.MANDT == AUFK.MANDT
Location Plant
  • Client
  • Location Plant
  • I_LOGISTICSORDER.MANDT == T001W.MANDT
  • I_LOGISTICSORDER.LOCATIONPLANT == T001W.WERKS
Location
  • Client
  • Location Plant
  • Location
  • I_LOGISTICSORDER.MANDT == T499S.MANDT
  • I_LOGISTICSORDER.LOCATIONPLANT == T499S.WERKS
  • I_LOGISTICSORDER.MAINTENANCEOBJECTLOCATION == T499S.STAND
Bill of Operations Material
  • Client
  • Bill of Operations Material
  • I_LOGISTICSORDER.MANDT == MARA.MANDT
  • I_LOGISTICSORDER.MATERIAL == MARA.MATNR
MRP Controller Group
  • MRP controller for the order
  • Client
  • Plant
  • I_LOGISTICSORDER.MRPCONTROLLER == T024D.DISPO
  • I_LOGISTICSORDER.MANDT == T024D.MANDT
  • I_LOGISTICSORDER.PLANT == T024D.WERKS
Network Profile
  • Client
  • Network Profile
  • ?
  • I_LOGISTICSORDER.MANDT == TCN41.MANDT
  • I_LOGISTICSORDER.NETWORKPROFILE == TCN41.PROFIDNETZ
  • I_LOGISTICSORDER.[column in domain "PLNAW"] == TCN41.PLNAW
Processing group
  • Client
  • Processing group
  • Controlling Area
  • I_LOGISTICSORDER.MANDT == TKO08.CLIENT
  • I_LOGISTICSORDER.ORDERPROCESSINGGROUP == TKO08.ABKRS
  • I_LOGISTICSORDER.CONTROLLINGAREA == TKO08.KOKRS
Order Type
  • Client
  • Order Type
  • I_LOGISTICSORDER.MANDT == T003O.CLIENT
  • I_LOGISTICSORDER.ORDERTYPE == T003O.AUART
Plant
  • Client
  • Plant
  • I_LOGISTICSORDER.MANDT == T001W.MANDT
  • I_LOGISTICSORDER.PLANT == T001W.WERKS
Production Scheduling Profile
  • Production Scheduling Profile
  • Client
  • Plant
  • I_LOGISTICSORDER.PRODUCTIONSCHEDULINGPROFILE == TCO43.CO_PRODPRF
  • I_LOGISTICSORDER.MANDT == TCO43.MANDT
  • I_LOGISTICSORDER.PLANT == TCO43.WERKS
Production Supervisor
  • Client
  • Production Supervisor
  • Plant
  • I_LOGISTICSORDER.MANDT == T024F.MANDT
  • I_LOGISTICSORDER.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • I_LOGISTICSORDER.PLANT == T024F.WERKS
Profit Center
  • ?
  • Client
  • Controlling Area
  • Profit Center
  • I_LOGISTICSORDER.[column in domain "DATBI"] == CEPC.DATBI
  • I_LOGISTICSORDER.MANDT == CEPC.MANDT
  • I_LOGISTICSORDER.CONTROLLINGAREA == CEPC.KOKRS
  • I_LOGISTICSORDER.PROFITCENTER == CEPC.PRCTR
Project definition
  • Client
  • Project definition
  • Project (internal)
  • I_LOGISTICSORDER.MANDT == PROJ.MANDT
  • I_LOGISTICSORDER.PROJECTINTERNALID == PROJ.PSPNR
  • I_LOGISTICSORDER.PROJECTINTERNALID_2 == PROJ.PSPNR
Project (internal)
  • Client
  • Project definition
  • Project (internal)
  • I_LOGISTICSORDER.MANDT == PROJ.MANDT
  • I_LOGISTICSORDER.PROJECTINTERNALID == PROJ.PSPNR
  • I_LOGISTICSORDER.PROJECTINTERNALID_2 == PROJ.PSPNR
Interest calculation profile
  • Client
  • Interest Profile for Project/Order Interest Calculation
  • I_LOGISTICSORDER.MANDT == TPI01.MANDT
  • I_LOGISTICSORDER.PROJINTERESTCALCPROFILE == TPI01.ZSCHM
Reference Order Number
  • Reference Order Number
  • Client
  • I_LOGISTICSORDER.REFERENCEORDER == AUFK.AUFNR
  • I_LOGISTICSORDER.MANDT == AUFK.MANDT
Requesting company code
  • Requesting company code
  • Client
  • I_LOGISTICSORDER.REQUESTINGCOMPANYCODE == T001.BUKRS
  • I_LOGISTICSORDER.MANDT == T001.MANDT
Requesting cost center
  • Requesting cost center
  • ?
  • Client
  • Controlling Area
  • I_LOGISTICSORDER.REQUESTINGCOSTCENTER == CSKS.KOSTL
  • I_LOGISTICSORDER.[column in domain "DATBI"] == CSKS.DATBI
  • I_LOGISTICSORDER.MANDT == CSKS.MANDT
  • I_LOGISTICSORDER.CONTROLLINGAREA == CSKS.KOKRS
Responsible Cost Center
  • ?
  • Client
  • Controlling Area
  • Responsible Cost Center
  • I_LOGISTICSORDER.[column in domain "DATBI"] == CSKS.DATBI
  • I_LOGISTICSORDER.MANDT == CSKS.MANDT
  • I_LOGISTICSORDER.CONTROLLINGAREA == CSKS.KOKRS
  • I_LOGISTICSORDER.RESPONSIBLECOSTCENTER == CSKS.KOSTL
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • I_LOGISTICSORDER.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_LOGISTICSORDER.MANDT == TTXJ.MANDT
  • I_LOGISTICSORDER.TAXJURISDICTION == TTXJ.TXJCD
Other Relations | to Master Data Relations ↑ Join Conditions
Responsible Planner Group or Department
  • Client
  • Responsible Planner Group or Department
  • Plant
  • I_LOGISTICSORDER.MANDT == T024A.MANDT
  • I_LOGISTICSORDER.RESPONSIBLEPLANNERGROUP == T024A.FEVOR
  • I_LOGISTICSORDER.PLANT == T024A.WERKS