C_MarketSegmentPlanActQ2501

Market Segment Plan Actual | view: CFIMSPLANACT2501 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, /CPD/D_PFP_PS, /CPD/D_WORK_ITEM, 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, /CPD/FC_WORKITEM, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
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
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation quantity
ActualValuationQuantity Actual Valuation Quantity
PlanValuationQuantity Plan Valuation Quantity
Column Name Description
Column Name Description
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
PersonnelNumber Personnel Number PERNR
Project Project FIS_PROJECT
CostAnalysisResourceName Cost Analysis Resource Name TEXT20
SalesDocumentItem Sales Document Item POSNR
SalesOrderItem Sales Order Item POSNR
WBSElement WBS Element FIS_WBS
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
WorkItemName Work Item Name /CPD/PFP_WORKITEM_NAME
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
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == T004.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.COMPANYCODE == T001.BUKRS
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.COMPANYCODECURRENCY == TCURC.WAERS
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == TCURC.MANDT
Cost Analysis Resource
  • Cost Analysis Resource
  • ?
  • ?
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.COSTANALYSISRESOURCE == CSKR.RESRC
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "DATBI"] == CSKR.DATBI
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "KOKRS"] == CSKR.KOKRS
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == CSKR.MANDT
Cost Center
  • Cost Center
  • ?
  • ?
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.COSTCENTER == CSKS.KOSTL
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "DATBI"] == CSKS.DATBI
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == CSKS.MANDT
Activity Type
  • ?
  • ?
  • Client
  • Activity Type
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "DATBI"] == CSLA.DATBI
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "KOKRS"] == CSLA.KOKRS
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == CSLA.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Cost Source Unit
  • Client
  • Cost Source Unit
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == T006.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Client
  • Customer Number
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == KNA1.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.CUSTOMER == KNA1.KUNNR
Customer Group
  • Customer Group
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.CUSTOMERGROUP == T151.KDGRP
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == T005.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == TVTW.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == TSPA.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.DIVISION == TSPA.SPART
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.FISCALYEARVARIANT == T009.PERIV
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == T009.MANDT
Functional Area
  • Functional Area
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.FUNCTIONALAREA == TFKB.FKBER
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == TFKB.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • C_MARKETSEGMENTPLANACTQ2501.COMPANYCODE == SKB1.BUKRS
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == SKB1.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Global Currency
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.GLOBALCURRENCY == TCURC.WAERS
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == TCURC.MANDT
Material Number
  • Product Number
  • Material Number
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.PRODUCT == MARA.MATNR
  • C_MARKETSEGMENTPLANACTQ2501.MATERIAL == MARA.MATNR
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.MATERIALGROUP == T023.MATKL
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == T023.MANDT
Order ID
  • Client
  • Order ID
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == AUFK.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.ORDERID == AUFK.AUFNR
Origin Profit Center
  • ?
  • ?
  • Client
  • Origin Profit Center
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "DATBI"] == CEPC.DATBI
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == CEPC.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.ORIGINPROFITCENTER == CEPC.PRCTR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == T880.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • ?
  • ?
  • Client
  • Partner Cost Center
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "DATBI"] == CSKS.DATBI
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == CSKS.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Partner Functional Area
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == TFKB.MANDT
Partner Order
  • Partner Order
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.PARTNERORDER == AUFK.AUFNR
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == AUFK.MANDT
Partner Profit Center
  • Partner Profit Center
  • ?
  • ?
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.PARTNERPROFITCENTER == CEPC.PRCTR
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "DATBI"] == CEPC.DATBI
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == CEPC.MANDT
Plant
  • Client
  • Plant
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == T001W.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.PLANT == T001W.WERKS
Product Number
  • Product Number
  • Material Number
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.PRODUCT == MARA.MATNR
  • C_MARKETSEGMENTPLANACTQ2501.MATERIAL == MARA.MATNR
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == MARA.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "DATBI"] == CEPC.DATBI
  • C_MARKETSEGMENTPLANACTQ2501.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_MARKETSEGMENTPLANACTQ2501.PROFITCENTER == CEPC.PRCTR
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == CEPC.MANDT
Sales District
  • Client
  • Sales District
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == T171.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == TVKO.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == FAGL_SEGM.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.SEGMENT == FAGL_SEGM.SEGMENT
Sold Material
  • Client
  • Sold Material
  • Product Sold
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == MARA.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.SOLDMATERIAL == MARA.MATNR
  • C_MARKETSEGMENTPLANACTQ2501.SOLDPRODUCT == MARA.MATNR
Product Sold
  • Client
  • Sold Material
  • Product Sold
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == MARA.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.SOLDMATERIAL == MARA.MATNR
  • C_MARKETSEGMENTPLANACTQ2501.SOLDPRODUCT == MARA.MATNR
Transaction Currency
  • Client
  • Transaction Currency
  • C_MARKETSEGMENTPLANACTQ2501.MANDT == TCURC.MANDT
  • C_MARKETSEGMENTPLANACTQ2501.TRANSACTIONCURRENCY == TCURC.WAERS