I_InternalOrder

Internal Order | view: IFIINTERNALORDER | ATTR | Extraction: Full only | Component: Information System

Tables used: AUFK

🔑 Keys (1)
💰 Amounts (1)
∑ Quantities
📅 Dates (13)
☰ Categorical (8)
Other (14)
🔗 Relations (40)

Column Name	Description
InternalOrder	Internal Order

Column Name	Description
💲 Order Currency (Currency):
IntOrderIndividualField5Amount	Estimated total costs of order

Column Name	Description

Column Name	Description
IntOrderIndividualField6Date	Application date
IntOrderIndividualField8Date	Work Start
IntOrderIndividualField9Date	End of Work
CreationDate	Created On
CreationTime	Time created
LastChangeDate	Change Date for Order Master
LastChangeTime	Changed At
IntOrderPlannedReleaseDate	Planned release date
IntOrderPlannedCompletionDate	Planned completion date
IntOrderPlannedClosingDate	Planned closing date
InternalOrderReleaseDate	Release Date
InternalOrderCompletionDate	Technical Completion Date
InternalOrderClosingDate	Close Date

Column Name	Description
OrderCategory	Order category	Show values
IsStatisticalOrder	Indicates If the Int. Order Has a Stats. Account Assignment	Show values
PlanningWithLineItemsIsActive	Identifier for Planning with Line Items	Show values
OrdIsUsedInIntegratedPlanning	Indicates If the Internal Order Is Plan Integrated	Show values
IntOrderIndividualField10Value	Identifier for work permit issued	Show values
JointVentureOriginalCostObject	JV original cost object	Show values
IsDeleted	Deletion Flag	Show values
ControllingObjectClass	Object Class	Show values

Column Name	Description	Domain name
InternalOrderDescription	Internal Order Description	TEXT40
SalesOrder	Sales Order Number	VBELN
SalesOrderItem	Item number in Sales Order	NUM06
ExternalOrder	External order number	AUFEX
OverheadCode	Overhead Key	CHAR6
IntOrderIndividualField1Value	Applicant	AUFUSER0
IntOrderIndividualField2Value	Applicant's telephone number	AUFUSER1
IntOrderIndividualField3Value	Person Responsible	AUFUSER2
IntOrderIndividualField4Value	Telephone number of person in charge	AUFUSER3
IntOrderIndividualField7Value	Department	AUFUSER6
JointVentureObjectType	Joint Venture Object Type	JV_OTYPE
CreatedByUser	Created By	USNAM
LastChangedByUser	Last Changed By	USNAM
CostCollector	Cost Collector Key	CCKEY

Master Data Relations	Join Conditions
statische mitbebuchte Kostenstelle ? Client Cost Center for Actual Costs Posting Controlling Area	`I_INTERNALORDER.[column in domain "DATBI"] == CSKS.DATBI` `I_INTERNALORDER.MANDT == CSKS.MANDT` `I_INTERNALORDER.ACTUALPOSTEDCOSTCENTER == CSKS.KOSTL` `I_INTERNALORDER.CONTROLLINGAREA == CSKS.KOKRS`
G/L Account for Basic Settlement Company Code Client G/L Account for Basic Settlement	`I_INTERNALORDER.COMPANYCODE == SKB1.BUKRS` `I_INTERNALORDER.MANDT == SKB1.MANDT` `I_INTERNALORDER.BASICSETTLEMENTGLACCOUNT == SKB1.SAKNR`
Business Area Client Business Area	`I_INTERNALORDER.MANDT == TGSB.MANDT` `I_INTERNALORDER.BUSINESSAREA == TGSB.GSBER`
Company Code Company Code Client	`I_INTERNALORDER.COMPANYCODE == T001.BUKRS` `I_INTERNALORDER.MANDT == T001.MANDT`
Application	`I_INTERNALORDER.CONDITIONAPPLICATION == T681A.KAPPL`
Usage of the condition table	`I_INTERNALORDER.CONDITIONUSAGE == T681V.KVEWE`
Controlling Area Client Controlling Area	`I_INTERNALORDER.MANDT == TKA01.MANDT` `I_INTERNALORDER.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center ? Client Controlling Area Cost Center	`I_INTERNALORDER.[column in domain "DATBI"] == CSKS.DATBI` `I_INTERNALORDER.MANDT == CSKS.MANDT` `I_INTERNALORDER.CONTROLLINGAREA == CSKS.KOKRS` `I_INTERNALORDER.COSTCENTER == CSKS.KOSTL`
Costing Sheet Costing Sheet Client Application Usage of the condition table	`I_INTERNALORDER.COSTINGSHEET == T683.KALSM` `I_INTERNALORDER.MANDT == T683.MANDT` `I_INTERNALORDER.CONDITIONAPPLICATION == T683.KAPPL` `I_INTERNALORDER.CONDITIONUSAGE == T683.KVEWE`
Order Currency Client Order Currency	`I_INTERNALORDER.MANDT == TCURC.MANDT` `I_INTERNALORDER.CURRENCY == TCURC.WAERS`
Reason for Environmental Investment Client Reason for Environmental Investment	`I_INTERNALORDER.MANDT == T087K.MANDT` `I_INTERNALORDER.ENVIRONMENTALINVESTMENTREASON == T087K.UMWKZ`
Functional Area Functional Area Client	`I_INTERNALORDER.FUNCTIONALAREA == TFKB.FKBER` `I_INTERNALORDER.MANDT == TFKB.MANDT`
Plant location for internal order Client Plant location for internal order Location Plant	`I_INTERNALORDER.MANDT == T499S.MANDT` `I_INTERNALORDER.INTERNALORDERLOCATION == T499S.STAND` `I_INTERNALORDER.LOCATIONPLANT == T499S.WERKS`
Responsible user for Internal Order Client Responsible user for Internal Order	`I_INTERNALORDER.MANDT == USR02.MANDT` `I_INTERNALORDER.INTERNALORDERRESPONSIBLEUSER == USR02.BNAME`
Settlement Cost Element ? Client Controlling Area Settlement Cost Element	`I_INTERNALORDER.[column in domain "DATBI"] == CSKB.DATBI` `I_INTERNALORDER.MANDT == CSKB.MANDT` `I_INTERNALORDER.CONTROLLINGAREA == CSKB.KOKRS` `I_INTERNALORDER.INTORDERSETTLEMENTCOSTELEMENT == CSKB.KSTAR`
Investment Measure Profile Investment Measure Profile Client	`I_INTERNALORDER.INVESTMENTPROFILE == TAPRF.IVPRO` `I_INTERNALORDER.MANDT == TAPRF.MANDT`
Reason for Investment Reason for Investment Client	`I_INTERNALORDER.INVESTMENTREASON == T087I.IZWEK` `I_INTERNALORDER.MANDT == T087I.MANDT`
Scale of investment objects Client Scale of investment objects	`I_INTERNALORDER.MANDT == TAIF5.MANDT` `I_INTERNALORDER.INVESTMENTSCALE == TAIF5.SIZECL`
Joint venture Company Code Client Joint venture	`I_INTERNALORDER.COMPANYCODE == T8JV.BUKRS` `I_INTERNALORDER.MANDT == T8JV.MANDT` `I_INTERNALORDER.JOINTVENTURE == T8JV.VNAME`
JIB/JIBE Class Company Code JIB/JIBE Class Client	`I_INTERNALORDER.COMPANYCODE == T8J6A.BUKRS` `I_INTERNALORDER.JOINTVENTURECLASS == T8J6A.CLASS` `I_INTERNALORDER.MANDT == T8J6A.MANDT`
Equity type ? Company Code Client Equity type Joint venture	`I_INTERNALORDER.[column in domain "FDATE"] == T8JG.FDATE` `I_INTERNALORDER.COMPANYCODE == T8JG.BUKRS` `I_INTERNALORDER.MANDT == T8JG.MANDT` `I_INTERNALORDER.JOINTVENTUREEQUITYTYPE == T8JG.ETYPE` `I_INTERNALORDER.JOINTVENTURE == T8JG.VNAME`
Recovery Indicator Company Code Client Recovery Indicator	`I_INTERNALORDER.COMPANYCODE == T8JJ.BUKRS` `I_INTERNALORDER.MANDT == T8JJ.MANDT` `I_INTERNALORDER.JOINTVENTURERECOVERYCODE == T8JJ.RECID`
JIB/JIBE Subclass A Company Code JIB/JIBE Class JIB/JIBE Subclass A Client	`I_INTERNALORDER.COMPANYCODE == T8J6C.BUKRS` `I_INTERNALORDER.JOINTVENTURECLASS == T8J6C.CLASS` `I_INTERNALORDER.JOINTVENTURESUBCLASS == T8J6C.SUBCLASS` `I_INTERNALORDER.MANDT == T8J6C.MANDT`
Location Plant Client Location Plant	`I_INTERNALORDER.MANDT == T001W.MANDT` `I_INTERNALORDER.LOCATIONPLANT == T001W.WERKS`
Logical System	`I_INTERNALORDER.LOGICALSYSTEM == TBDLS.LOGSYS`
Interest calculation profile Client Interest Profile for Order Interest Calculation	`I_INTERNALORDER.MANDT == TPI01.MANDT` `I_INTERNALORDER.ORDERINTERESTCALCPROFILE == TPI01.ZSCHM`
Processing Group Client Processing Group Controlling Area	`I_INTERNALORDER.MANDT == TKO08.CLIENT` `I_INTERNALORDER.ORDERPROCESSINGGROUP == TKO08.ABKRS` `I_INTERNALORDER.CONTROLLINGAREA == TKO08.KOKRS`
Order Type Order Type Client	`I_INTERNALORDER.ORDERTYPE == T003O.AUART` `I_INTERNALORDER.MANDT == T003O.CLIENT`
Plant Client Plant	`I_INTERNALORDER.MANDT == T001W.MANDT` `I_INTERNALORDER.PLANT == T001W.WERKS`
Profit Center ? Client Profit Center Controlling Area	`I_INTERNALORDER.[column in domain "DATBI"] == CEPC.DATBI` `I_INTERNALORDER.MANDT == CEPC.MANDT` `I_INTERNALORDER.PROFITCENTER == CEPC.PRCTR` `I_INTERNALORDER.CONTROLLINGAREA == CEPC.KOKRS`
Reference Order Number Client Reference Order Number	`I_INTERNALORDER.MANDT == AUFK.MANDT` `I_INTERNALORDER.REFERENCEORDER == AUFK.AUFNR`
Requesting company code Requesting company code Client	`I_INTERNALORDER.REQUESTINGCOMPANYCODE == T001.BUKRS` `I_INTERNALORDER.MANDT == T001.MANDT`
Requesting cost center ? Client Requesting cost center Controlling Area	`I_INTERNALORDER.[column in domain "DATBI"] == CSKS.DATBI` `I_INTERNALORDER.MANDT == CSKS.MANDT` `I_INTERNALORDER.REQUESTINGCOSTCENTER == CSKS.KOSTL` `I_INTERNALORDER.CONTROLLINGAREA == CSKS.KOKRS`
Requesting order Client Requesting order	`I_INTERNALORDER.MANDT == AUFK.MANDT` `I_INTERNALORDER.REQUESTINGORDER == AUFK.AUFNR`
Responsible cost center in internal order ? Client Controlling Area Responsible cost center in internal order	`I_INTERNALORDER.[column in domain "DATBI"] == CSKS.DATBI` `I_INTERNALORDER.MANDT == CSKS.MANDT` `I_INTERNALORDER.CONTROLLINGAREA == CSKS.KOKRS` `I_INTERNALORDER.RESPONSIBLECOSTCENTER == CSKS.KOSTL`
Results Analysis Key Results Analysis Key Client	`I_INTERNALORDER.RESULTANALYSISINTERNALID == TKKAA.ABGSL` `I_INTERNALORDER.MANDT == TKKAA.MANDT`
Tax Jurisdiction ? Client Tax Jurisdiction	`I_INTERNALORDER.[column in domain "TAX_KALSM"] == TTXJ.KALSM` `I_INTERNALORDER.MANDT == TTXJ.MANDT` `I_INTERNALORDER.TAXJURISDICTION == TTXJ.TXJCD`