C_InternalOrderPlanActQ2101

Internal Order Plan Actual | view: CFIIOPLANACT2101 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting

Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, MARA, T003, T003T, TGSB, TGSBT, FINSC_CUSTBTTYPE, FINSC_CUSTBTTYPT, T004, T001, TKA02, TKA01, CSKR, CSKR, CSKV, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, AUFK, T001W, MARA, T023T, T023, CRTX, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, T016T, PRPS, PRPS, CRHD, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys
💰 Amounts (6)
∑ Quantities
📅 Dates (1)
☰ Categorical (2)
Other (27)
🔗 Relations (22)

Column Name	Description

Column Name	Description
💲 Transaction Currency (TransactionCurrency):
ActualAmountInTransactionCrcy	Amount in Global Currency
PlanAmountInTransactionCrcy	Amount in Company Code Currency
💲 Company Code Currency (CompanyCodeCurrency):
ActualAmountInCompanyCodeCrcy	Amount in Company Code Currency
PlanAmountInCompanyCodeCrcy	Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
ActualAmountInGlobalCurrency	Amount in Global Currency
PlanAmountInGlobalCurrency	Amount in Global Currency

Column Name	Description

Column Name	Description
PostingDate	Posting Date

Column Name	Description
IsStatisticalOrder	Indicator: Internal Order is Statistical Account Assignment	Show values
ControllingDebitCreditCode	Controlling Debit Credit Code	Show values

Column Name	Description	Domain name
GLAccountName	G/L Account Short Text	TEXT20
CalendarMonth	Calendar Month	NUM2
CalendarQuarter	Calendar Quarter	NUM1
CalendarWeek	Calendar Week	NUM2
CalendarYear	Calendar Year	NUM4
FiscalPeriod	Fiscal Period	POPER
FiscalQuarter	Fiscal Quarter	FINS_FSCALQUARTER
FiscalWeek	Fiscal Week	FINS_FISCALWEEK
FiscalYearPeriod	Fiscal Year Period	FIS_JAHRPER_CONV
FiscalYearQuarter	Fiscal Year + Fiscal Quarter	FINS_FYEARQUARTER
FiscalYearWeek	Fiscal Year + Fiscal Week	FINS_FYEARWEEK
AccountingDocument	Journal Entry	BELNR
LedgerGLLineItem	Ledger Journal Entry Item	DOCLN6
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
PartnerProject	Partner Project	FIS_PROJECT
PartnerWBSElement	Partner WBS Element	FIS_WBS
PlanningCategory	Plan Category	FCOM_CATEGORY
CostAnalysisResourceName	Cost Analysis Resource Name	TEXT20
YearMonth	Year Month	NUM6
YearQuarter	Year Quarter	NUM5
YearWeek	Year Week	NUM6
DifferenceAmtInTransCrcy	null
TransCrcyDifferencePct	null
DifferenceAmtInCoCodeCrcy	null
CoCodeCrcyDifferencePct	null
DifferenceAmtInGlobalCrcy	null
GlobalCrcyDifferencePct	null

Master Data Relations	Join Conditions
Business Transaction Type Business Transaction Type Client	`C_INTERNALORDERPLANACTQ2101.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `C_INTERNALORDERPLANACTQ2101.MANDT == FINSC_CUSTBTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`C_INTERNALORDERPLANACTQ2101.CHARTOFACCOUNTS == T004.KTOPL` `C_INTERNALORDERPLANACTQ2101.MANDT == T004.MANDT`
Company Code Company Code Client	`C_INTERNALORDERPLANACTQ2101.COMPANYCODE == T001.BUKRS` `C_INTERNALORDERPLANACTQ2101.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`C_INTERNALORDERPLANACTQ2101.COMPANYCODECURRENCY == TCURC.WAERS` `C_INTERNALORDERPLANACTQ2101.MANDT == TCURC.MANDT`
Cost Analysis Resource Cost Analysis Resource ? ? Client	`C_INTERNALORDERPLANACTQ2101.COSTANALYSISRESOURCE == CSKR.RESRC` `C_INTERNALORDERPLANACTQ2101.[column in domain "KOKRS"] == CSKR.KOKRS` `C_INTERNALORDERPLANACTQ2101.[column in domain "DATBI"] == CSKR.DATBI` `C_INTERNALORDERPLANACTQ2101.MANDT == CSKR.MANDT`
Activity Type Activity Type ? ? Client	`C_INTERNALORDERPLANACTQ2101.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_INTERNALORDERPLANACTQ2101.[column in domain "KOKRS"] == CSLA.KOKRS` `C_INTERNALORDERPLANACTQ2101.[column in domain "DATBI"] == CSLA.DATBI` `C_INTERNALORDERPLANACTQ2101.MANDT == CSLA.MANDT`
Fiscal Year Variant Fiscal Year Variant Client	`C_INTERNALORDERPLANACTQ2101.FISCALYEARVARIANT == T009.PERIV` `C_INTERNALORDERPLANACTQ2101.MANDT == T009.MANDT`
Functional Area Client Functional Area	`C_INTERNALORDERPLANACTQ2101.MANDT == TFKB.MANDT` `C_INTERNALORDERPLANACTQ2101.FUNCTIONALAREA == TFKB.FKBER`
G/L Account G/L Account Company Code Client	`C_INTERNALORDERPLANACTQ2101.GLACCOUNT == SKB1.SAKNR` `C_INTERNALORDERPLANACTQ2101.COMPANYCODE == SKB1.BUKRS` `C_INTERNALORDERPLANACTQ2101.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`C_INTERNALORDERPLANACTQ2101.GLOBALCURRENCY == TCURC.WAERS` `C_INTERNALORDERPLANACTQ2101.MANDT == TCURC.MANDT`
Material Number Material Number Product Number Client	`C_INTERNALORDERPLANACTQ2101.MATERIAL == MARA.MATNR` `C_INTERNALORDERPLANACTQ2101.PRODUCT == MARA.MATNR` `C_INTERNALORDERPLANACTQ2101.MANDT == MARA.MANDT`
Order ID Order ID Client	`C_INTERNALORDERPLANACTQ2101.ORDERID == AUFK.AUFNR` `C_INTERNALORDERPLANACTQ2101.MANDT == AUFK.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`C_INTERNALORDERPLANACTQ2101.PARTNERCOMPANY == T880.RCOMP` `C_INTERNALORDERPLANACTQ2101.MANDT == T880.MANDT`
Partner Cost Center ? Partner Cost Center ? Client	`C_INTERNALORDERPLANACTQ2101.[column in domain "KOKRS"] == CSKS.KOKRS` `C_INTERNALORDERPLANACTQ2101.PARTNERCOSTCENTER == CSKS.KOSTL` `C_INTERNALORDERPLANACTQ2101.[column in domain "DATBI"] == CSKS.DATBI` `C_INTERNALORDERPLANACTQ2101.MANDT == CSKS.MANDT`
Partner Cost Center Activity Type Partner Cost Center Activity Type ? ? Client	`C_INTERNALORDERPLANACTQ2101.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_INTERNALORDERPLANACTQ2101.[column in domain "KOKRS"] == CSLA.KOKRS` `C_INTERNALORDERPLANACTQ2101.[column in domain "DATBI"] == CSLA.DATBI` `C_INTERNALORDERPLANACTQ2101.MANDT == CSLA.MANDT`
Partner Functional Area Client Partner Functional Area	`C_INTERNALORDERPLANACTQ2101.MANDT == TFKB.MANDT` `C_INTERNALORDERPLANACTQ2101.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Order Partner Order Client	`C_INTERNALORDERPLANACTQ2101.PARTNERORDER == AUFK.AUFNR` `C_INTERNALORDERPLANACTQ2101.MANDT == AUFK.MANDT`
Partner Profit Center ? Partner Profit Center ? Client	`C_INTERNALORDERPLANACTQ2101.[column in domain "KOKRS"] == CEPC.KOKRS` `C_INTERNALORDERPLANACTQ2101.PARTNERPROFITCENTER == CEPC.PRCTR` `C_INTERNALORDERPLANACTQ2101.[column in domain "DATBI"] == CEPC.DATBI` `C_INTERNALORDERPLANACTQ2101.MANDT == CEPC.MANDT`
Product Number Material Number Product Number Client	`C_INTERNALORDERPLANACTQ2101.MATERIAL == MARA.MATNR` `C_INTERNALORDERPLANACTQ2101.PRODUCT == MARA.MATNR` `C_INTERNALORDERPLANACTQ2101.MANDT == MARA.MANDT`
Profit Center ? ? Profit Center Client	`C_INTERNALORDERPLANACTQ2101.[column in domain "KOKRS"] == CEPC.KOKRS` `C_INTERNALORDERPLANACTQ2101.[column in domain "DATBI"] == CEPC.DATBI` `C_INTERNALORDERPLANACTQ2101.PROFITCENTER == CEPC.PRCTR` `C_INTERNALORDERPLANACTQ2101.MANDT == CEPC.MANDT`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`C_INTERNALORDERPLANACTQ2101.SEGMENT == FAGL_SEGM.SEGMENT` `C_INTERNALORDERPLANACTQ2101.MANDT == FAGL_SEGM.MANDT`
Transaction Currency Transaction Currency Client	`C_INTERNALORDERPLANACTQ2101.TRANSACTIONCURRENCY == TCURC.WAERS` `C_INTERNALORDERPLANACTQ2101.MANDT == TCURC.MANDT`