C_MarketSegmentQ2501

Market Segments Actuals | view: CFIMARKSEGMQ2501 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, ACDOCA, BKPF, /CPD/D_PFP_PS, /CPD/D_WORK_ITEM, MARA, T003, T003T, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKR, CSKV, CSKS, CSLA, CSLT, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, T023, T023T, MAKT, T001W, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, T016T, PRPS, /CPD/FC_WORKITEM, SKAT, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity 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
PersonnelNumber Personnel Number PERNR
EmployeeFullName Full Name TEXT80
Project Project FIS_PROJECT
CostAnalysisResourceName Cost Analysis Resource Name TEXT20
SalesDocumentItem Sales Document Item POSNR
SalesOrderItem Sales Order Item POSNR
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
BusinessSolutionOrderItem Solution Order Item CRMS4_NUMBER_INT
WBSElement WBS Element FIS_WBS
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
WorkItemName Work Item Name /CPD/PFP_WORKITEM_NAME
CalendarYearMonth Year Month NUM6
CalendarYearQuarter Year Quarter NUM5
CalendarYearWeek Year Week NUM6
Master Data Relations Join Conditions
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_MARKETSEGMENTQ2501.MANDT == T004.MANDT
  • C_MARKETSEGMENTQ2501.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_MARKETSEGMENTQ2501.MANDT == T001.MANDT
  • C_MARKETSEGMENTQ2501.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_MARKETSEGMENTQ2501.MANDT == TCURC.MANDT
  • C_MARKETSEGMENTQ2501.COMPANYCODECURRENCY == TCURC.WAERS
Cost Analysis Resource
  • ?
  • ?
  • Client
  • Cost Analysis Resource
  • C_MARKETSEGMENTQ2501.[column in domain "DATBI"] == CSKR.DATBI
  • C_MARKETSEGMENTQ2501.[column in domain "KOKRS"] == CSKR.KOKRS
  • C_MARKETSEGMENTQ2501.MANDT == CSKR.MANDT
  • C_MARKETSEGMENTQ2501.COSTANALYSISRESOURCE == CSKR.RESRC
Cost Center
  • ?
  • ?
  • Client
  • Cost Center
  • C_MARKETSEGMENTQ2501.[column in domain "DATBI"] == CSKS.DATBI
  • C_MARKETSEGMENTQ2501.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_MARKETSEGMENTQ2501.MANDT == CSKS.MANDT
  • C_MARKETSEGMENTQ2501.COSTCENTER == CSKS.KOSTL
Activity Type
  • ?
  • ?
  • Client
  • Activity Type
  • C_MARKETSEGMENTQ2501.[column in domain "DATBI"] == CSLA.DATBI
  • C_MARKETSEGMENTQ2501.[column in domain "KOKRS"] == CSLA.KOKRS
  • C_MARKETSEGMENTQ2501.MANDT == CSLA.MANDT
  • C_MARKETSEGMENTQ2501.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Cost Source Unit
  • Client
  • Cost Source Unit
  • C_MARKETSEGMENTQ2501.MANDT == T006.MANDT
  • C_MARKETSEGMENTQ2501.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Customer Number
  • Client
  • C_MARKETSEGMENTQ2501.CUSTOMER == KNA1.KUNNR
  • C_MARKETSEGMENTQ2501.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • C_MARKETSEGMENTQ2501.MANDT == T151.MANDT
  • C_MARKETSEGMENTQ2501.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • C_MARKETSEGMENTQ2501.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • C_MARKETSEGMENTQ2501.MANDT == T005.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_MARKETSEGMENTQ2501.MANDT == TVTW.MANDT
  • C_MARKETSEGMENTQ2501.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_MARKETSEGMENTQ2501.MANDT == T009.MANDT
  • C_MARKETSEGMENTQ2501.FISCALYEARVARIANT == T009.PERIV
Functional Area
  • Client
  • Functional Area
  • C_MARKETSEGMENTQ2501.MANDT == TFKB.MANDT
  • C_MARKETSEGMENTQ2501.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_MARKETSEGMENTQ2501.MANDT == SKB1.MANDT
  • C_MARKETSEGMENTQ2501.GLACCOUNT == SKB1.SAKNR
  • C_MARKETSEGMENTQ2501.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_MARKETSEGMENTQ2501.MANDT == TCURC.MANDT
  • C_MARKETSEGMENTQ2501.GLOBALCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • Product Number
  • C_MARKETSEGMENTQ2501.MANDT == MARA.MANDT
  • C_MARKETSEGMENTQ2501.MATERIAL == MARA.MATNR
  • C_MARKETSEGMENTQ2501.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Material Group
  • Product Sold Group
  • C_MARKETSEGMENTQ2501.MANDT == T023.MANDT
  • C_MARKETSEGMENTQ2501.MATERIALGROUP == T023.MATKL
  • C_MARKETSEGMENTQ2501.SOLDPRODUCTGROUP == T023.MATKL
Order ID
  • Client
  • Order ID
  • C_MARKETSEGMENTQ2501.MANDT == AUFK.MANDT
  • C_MARKETSEGMENTQ2501.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • C_MARKETSEGMENTQ2501.MANDT == TSPA.MANDT
  • C_MARKETSEGMENTQ2501.ORGANIZATIONDIVISION == TSPA.SPART
Origin Profit Center
  • ?
  • ?
  • Client
  • Origin Profit Center
  • C_MARKETSEGMENTQ2501.[column in domain "DATBI"] == CEPC.DATBI
  • C_MARKETSEGMENTQ2501.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_MARKETSEGMENTQ2501.MANDT == CEPC.MANDT
  • C_MARKETSEGMENTQ2501.ORIGINPROFITCENTER == CEPC.PRCTR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_MARKETSEGMENTQ2501.MANDT == T880.MANDT
  • C_MARKETSEGMENTQ2501.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • ?
  • ?
  • Client
  • Partner Cost Center
  • C_MARKETSEGMENTQ2501.[column in domain "DATBI"] == CSKS.DATBI
  • C_MARKETSEGMENTQ2501.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_MARKETSEGMENTQ2501.MANDT == CSKS.MANDT
  • C_MARKETSEGMENTQ2501.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • C_MARKETSEGMENTQ2501.MANDT == TFKB.MANDT
  • C_MARKETSEGMENTQ2501.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Order
  • Client
  • Partner Order
  • C_MARKETSEGMENTQ2501.MANDT == AUFK.MANDT
  • C_MARKETSEGMENTQ2501.PARTNERORDER == AUFK.AUFNR
Partner Profit Center
  • ?
  • ?
  • Client
  • Partner Profit Center
  • C_MARKETSEGMENTQ2501.[column in domain "DATBI"] == CEPC.DATBI
  • C_MARKETSEGMENTQ2501.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_MARKETSEGMENTQ2501.MANDT == CEPC.MANDT
  • C_MARKETSEGMENTQ2501.PARTNERPROFITCENTER == CEPC.PRCTR
Plant
  • Client
  • Plant
  • C_MARKETSEGMENTQ2501.MANDT == T001W.MANDT
  • C_MARKETSEGMENTQ2501.PLANT == T001W.WERKS
Product Number
  • Client
  • Material Number
  • Product Number
  • C_MARKETSEGMENTQ2501.MANDT == MARA.MANDT
  • C_MARKETSEGMENTQ2501.MATERIAL == MARA.MATNR
  • C_MARKETSEGMENTQ2501.PRODUCT == MARA.MATNR
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • C_MARKETSEGMENTQ2501.[column in domain "DATBI"] == CEPC.DATBI
  • C_MARKETSEGMENTQ2501.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_MARKETSEGMENTQ2501.MANDT == CEPC.MANDT
  • C_MARKETSEGMENTQ2501.PROFITCENTER == CEPC.PRCTR
Sales District
  • Sales District
  • Client
  • C_MARKETSEGMENTQ2501.SALESDISTRICT == T171.BZIRK
  • C_MARKETSEGMENTQ2501.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_MARKETSEGMENTQ2501.MANDT == TVKO.MANDT
  • C_MARKETSEGMENTQ2501.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_MARKETSEGMENTQ2501.MANDT == FAGL_SEGM.MANDT
  • C_MARKETSEGMENTQ2501.SEGMENT == FAGL_SEGM.SEGMENT
Service Document ID
  • Client
  • Service Document ID
  • Service Document Item ID
  • Service Document Type
  • C_MARKETSEGMENTQ2501.MANDT == FCO_SRVDOC.MANDT
  • C_MARKETSEGMENTQ2501.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • C_MARKETSEGMENTQ2501.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • C_MARKETSEGMENTQ2501.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Item ID
  • Client
  • Service Document ID
  • Service Document Item ID
  • Service Document Type
  • C_MARKETSEGMENTQ2501.MANDT == FCO_SRVDOC.MANDT
  • C_MARKETSEGMENTQ2501.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • C_MARKETSEGMENTQ2501.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • C_MARKETSEGMENTQ2501.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
Sold Material
  • Sold Material
  • Product Sold
  • Client
  • C_MARKETSEGMENTQ2501.SOLDMATERIAL == MARA.MATNR
  • C_MARKETSEGMENTQ2501.SOLDPRODUCT == MARA.MATNR
  • C_MARKETSEGMENTQ2501.MANDT == MARA.MANDT
Product Sold
  • Sold Material
  • Product Sold
  • Client
  • C_MARKETSEGMENTQ2501.SOLDMATERIAL == MARA.MATNR
  • C_MARKETSEGMENTQ2501.SOLDPRODUCT == MARA.MATNR
  • C_MARKETSEGMENTQ2501.MANDT == MARA.MANDT
Product Sold Group
  • Client
  • Material Group
  • Product Sold Group
  • C_MARKETSEGMENTQ2501.MANDT == T023.MANDT
  • C_MARKETSEGMENTQ2501.MATERIALGROUP == T023.MATKL
  • C_MARKETSEGMENTQ2501.SOLDPRODUCTGROUP == T023.MATKL
Transaction Currency
  • Client
  • Transaction Currency
  • C_MARKETSEGMENTQ2501.MANDT == TCURC.MANDT
  • C_MARKETSEGMENTQ2501.TRANSACTIONCURRENCY == TCURC.WAERS