C_InternalOrderQ0001

Internal Order | view: CFIINTORDERQ0001 | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: JESTT001TKA02CSKSCSKSCSKTTFKBTFKBTAUFKAUFKTJ02TT003OT003PCEPCCEPCCEPCTUSR21
Column Name Description
InternalOrder Internal Order
Column Name Description
Column Name Description
Column Name Description
CreationDate Created On
LastChangeTime Changed At
Column Name Description
OrderCategory Order category Show values
IsStatisticalOrder Indicates If the Int. Order Has a Stats. Account Assignment Show values
IsDeleted Deletion Flag Show values
ControllingObjectClass Object Class Show values
Column Name Description Domain name
InternalOrderDescription Internal Order Description TEXT40
CreatedByUser Created By USNAM
LastChangedByUser Last Changed By USNAM
CompanyCodeName Name of Company Code or Company TEXT25
ProfitCenterName Description of Profit Center TEXT20
FunctionalAreaName Name of the Functional Area TEXT25
ControllingObjectClassName Short Text for Fixed Values DDTEXT
OrderTypeName Short Text TEXT40
CostCenterDescription Description of Cost Center TEXT40
PersonFullName User Description SUIDTECHDESC
StatusName Object status TEXT30
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • C_INTERNALORDERQ0001.BUSINESSAREA == TGSB.GSBER
  • C_INTERNALORDERQ0001.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • C_INTERNALORDERQ0001.COMPANYCODE == T001.BUKRS
  • C_INTERNALORDERQ0001.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_INTERNALORDERQ0001.CONTROLLINGAREA == TKA01.KOKRS
  • C_INTERNALORDERQ0001.MANDT == TKA01.MANDT
Order Currency
  • Client
  • Order Currency
  • C_INTERNALORDERQ0001.MANDT == TCURC.MANDT
  • C_INTERNALORDERQ0001.CURRENCY == TCURC.WAERS
Functional Area
  • Functional Area
  • Client
  • C_INTERNALORDERQ0001.FUNCTIONALAREA == TFKB.FKBER
  • C_INTERNALORDERQ0001.MANDT == TFKB.MANDT
Responsible user for Internal Order
  • Responsible user for Internal Order
  • Client
  • C_INTERNALORDERQ0001.INTERNALORDERRESPONSIBLEUSER == USR02.BNAME
  • C_INTERNALORDERQ0001.MANDT == USR02.MANDT
Order Type
  • Order Type
  • Client
  • C_INTERNALORDERQ0001.ORDERTYPE == T003O.AUART
  • C_INTERNALORDERQ0001.MANDT == T003O.CLIENT
Plant
  • Client
  • Plant
  • C_INTERNALORDERQ0001.MANDT == T001W.MANDT
  • C_INTERNALORDERQ0001.PLANT == T001W.WERKS
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • C_INTERNALORDERQ0001.PROFITCENTER == CEPC.PRCTR
  • C_INTERNALORDERQ0001.[column in domain "DATBI"] == CEPC.DATBI
  • C_INTERNALORDERQ0001.CONTROLLINGAREA == CEPC.KOKRS
  • C_INTERNALORDERQ0001.MANDT == CEPC.MANDT
Reference Order Number
  • Reference Order Number
  • Client
  • C_INTERNALORDERQ0001.REFERENCEORDER == AUFK.AUFNR
  • C_INTERNALORDERQ0001.MANDT == AUFK.MANDT
Responsible cost center in internal order
  • Responsible cost center in internal order
  • ?
  • Controlling Area
  • Client
  • C_INTERNALORDERQ0001.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_INTERNALORDERQ0001.[column in domain "DATBI"] == CSKS.DATBI
  • C_INTERNALORDERQ0001.CONTROLLINGAREA == CSKS.KOKRS
  • C_INTERNALORDERQ0001.MANDT == CSKS.MANDT