C_COGSSplitRelevantGLItems

Relevant Items from COGS Split and original Document | view: CCOGSSPLRELGLI | Extraction: Not supported | Component: Profitability Analysis
Tables used: SCAL_TT_DATE, ACDOCA, MARA, FINSC_CUSTBTTYPE, FINSC_CUSTBTTYPT, T001, TKA02, SKAT, FINSC_LEDGER, T001W, MAKT, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FCOC_COGS_SA
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
JournalEntry Journal Entry
JournalEntryItem Journal Entry Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
PostingDate Posting Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
GLAccountName G/L Account Short Text TEXT20
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
GLBusinessTransactionType Transaction Type for General Ledger VORGN
SalesOrderItem Sales Order Item POSNR
COGSSplitGLItemRoleName Short Text for Fixed Values DDTEXT
COGSSplitGLItemRole Values for Domains: Single Value/Lower Limit DOMVAL
SalesDocumentItem Sales Document Item POSNR
CompanyCodeName Name of Company Code or Company TEXT25
PlantName Plant Name TEXT30
BusinessTransactionTypeName Business Transaction Type Description TEXT30
ProductName Product Description TEXT40
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == T003.MANDT
Asset Class
  • Asset Class
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.ASSETCLASS == ANKA.ANLKL
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == ANKA.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.BASEUNIT == T006.MSEHI
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.BUSINESSAREA == TGSB.GSBER
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == TGSB.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.CHARTOFACCOUNTS == T004.KTOPL
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.COMPANYCODE == T001.BUKRS
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == TCURC.MANDT
  • C_COGSSPLITRELEVANTGLITEMS.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.CONTROLLINGAREA == TKA01.KOKRS
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.[column in domain "DATBI"] == CSKS.DATBI
  • C_COGSSPLITRELEVANTGLITEMS.COSTCENTER == CSKS.KOSTL
  • C_COGSSPLITRELEVANTGLITEMS.CONTROLLINGAREA == CSKS.KOKRS
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.CUSTOMER == KNA1.KUNNR
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == TVTW.MANDT
  • C_COGSSPLITRELEVANTGLITEMS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.GLACCOUNT == SKB1.SAKNR
  • C_COGSSPLITRELEVANTGLITEMS.COMPANYCODE == SKB1.BUKRS
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.GLOBALCURRENCY == TCURC.WAERS
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Order ID
  • Order ID
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.ORDERID == AUFK.AUFNR
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.ORGANIZATIONDIVISION == TSPA.SPART
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == TSPA.MANDT
Plant
  • Plant
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.PLANT == T001W.WERKS
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == T001W.MANDT
Product Number
  • Product Number
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.PRODUCT == MARA.MATNR
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == MARA.MANDT
Profit Center
  • ?
  • Profit Center
  • Controlling Area
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.[column in domain "DATBI"] == CEPC.DATBI
  • C_COGSSPLITRELEVANTGLITEMS.PROFITCENTER == CEPC.PRCTR
  • C_COGSSPLITRELEVANTGLITEMS.CONTROLLINGAREA == CEPC.KOKRS
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == CEPC.MANDT
Reference Document Type C_COGSSPLITRELEVANTGLITEMS.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales Organization
  • Sales Organization
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.SALESORGANIZATION == TVKO.VKORG
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.SEGMENT == FAGL_SEGM.SEGMENT
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == FAGL_SEGM.MANDT
Service Document ID
  • Service Document ID
  • ?
  • Client
  • Service Document Type
  • C_COGSSPLITRELEVANTGLITEMS.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • C_COGSSPLITRELEVANTGLITEMS.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == FCO_SRVDOC.MANDT
  • C_COGSSPLITRELEVANTGLITEMS.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
Source Reference Document Type C_COGSSPLITRELEVANTGLITEMS.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Subledger-Specific Line Item Type C_COGSSPLITRELEVANTGLITEMS.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Supplier
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.SUPPLIER == LFA1.LIFNR
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == LFA1.MANDT
Valuation area
  • Valuation area
  • Client
  • C_COGSSPLITRELEVANTGLITEMS.VALUATIONAREA == T001K.BWKEY
  • C_COGSSPLITRELEVANTGLITEMS.MANDT == T001K.MANDT