C_CITItemClassificationQuery

CIT Item Classification - Query | view: CCITITMCLFNQ | Extraction: Not supported | Component: Corporate Income Tax Framework

Tables used: FICITD_ITMCLFNLG, FICITD_SETTLMTLG, ACDOCA, BKPF, T003T, FICITC_RPTGLINET, FICITC_SETTLMTT, T001, TKA02, TKA01, CSKS, CSKT, KNA1, AUFK, FINSC_LEDGER_T, MAKT, CEPC, CEPCT, PROJ, T000, LFA1, PRPS, SKAT, T004, HRRP_NODE, HRRP_NODET

🔑 Keys
💰 Amounts (1)
∑ Quantities
📅 Dates (4)
☰ Categorical (13)
Other (74)
🔗 Relations (75)

Column Name	Description

Column Name	Description
💲 CIT Currency (Currency):
CITItemAmountInDisplayCurrency	CIT Amount

Column Name	Description

Column Name	Description
CITReportingDate	Reporting Date
PostingDate	Posting Date
DocumentDate	Journal Entry Date
JournalEntryCreationDate	Journal Entry Creation Date in UTC

Column Name	Description
ItemSignIsReversed	Change Item Sign in Reporting	Show values
IsReversal	Indicator: Item is Reversing Another Item	Show values
IsReversed	Indicator: Item is Reversed	Show values
IsSettlement	Indicator: Item is Settling or Transferring Another Item	Show values
IsSettled	Indicator: Line Item is Settled or Transferred	Show values
ControllingObjectClass	Object Class	Show values
OriginObjectType	Type of Origin Object	Show values
ControllingDebitCreditCode	Controlling Debit/Credit Code	Show values
OrderCategory	Order category	Show values
AccountingDocumentCategory	Journal Entry Category	Show values
DebitCreditCode	Debit/Credit Code	Show values
PartnerControllingObjectClass	Partner object class	Show values
PartnerOrderCategory	Partner Order Category	Show values

Column Name	Description	Domain name
StatryRptgEntity	Reporting Entity	SRF_REPORTING_ENTITY
StatryRptCategory	Report Category ID	SRF_REP_CAT_ID
StatryRptRunID	Report Run ID	SRF_REPORT_RUN_ID
CITClassificationUUID	Global Unique ID for table	UUID
CITReportingLine	CIT Report Line
CITReportingLineDescription	CIT Report Line Description	TEXT100
CITReportingItem	CIT Report Item
CITReportVersion	CIT Report Version
BRFApplication	BRFplus Application name	FDT_NAME
CITSettlementCode	CIT Settlement Code	FDT_NAME
CITSettlementCodeDescription	CIT Settlement Code Description	TEXT50
Ledger	Ledger in General Ledger Accounting	FINS_LEDGER
LedgerName	Ledger Name	TEXT30
SourceLedger	Source Ledger	FINS_LEDGER
CompanyCode	Company Code	BUKRS
CompanyCodeName	Name of Company Code or Company	TEXT25
CorporateIncomeTaxHierarchy	Corporate Income Tax Hierarchy	DHRYID
CITClassificationCode	CIT Classification Code
CITClassificationCodeDesc	Hierarchy node description	TEXT50
GLAccountLongName	G/L Account Long Name	CHAR50
FiscalYear	Fiscal Year	GJAHR
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
FiscalYearPeriod	Fiscal Year Period	FIS_JAHRPER_CONV
AccountingDocument	Journal Entry	BELNR
LedgerGLLineItem	Ledger Journal Entry Item	DOCLN6
AccountingDocumentHeaderText	Document Header Text	TEXT25
DocumentReferenceID	Document Reference ID	XBLNR1
DocumentItemText	Item Text	TEXT50
ReversalReferenceDocument	Reversal Reference Document	AWREF
ReversalReferenceDocumentCntxt	Reversal Reference Document Context	AWORG
ControllingAreaName	Controlling Area Name	TEXT25
CostCenterName	Cost Center Name	TEXT20
PersonnelNumber	Personnel Number	PERNR
InternalOrderDescription	Internal Order Description	TEXT40
WBSElementInternalID	WBS Element Internal ID	FIS_WBSINT_NO_CONV
WBSDescription	WBS Element Name	TEXT40
WBSElementExternalID	WBS Element External ID	FIS_WBSEXT_NO_CONV
ProjectExternalID	Project External ID	FIS_PROJECTEXT_NO_CONV
WorkItem	Work Item ID	/CPD/PFP_WORKITEM_ID
AccrualObject	Identifier of the Accrual Object	ACR_OBJ_ID
AccrualSubobject	Identifier of the Accrual Subobject	ACR_SUBOBJ_ID
AccrualItemType	Type of the Item of the Accrual Subobject	ACR_ITEM_TYPE
ProfitCenterName	Description of Profit Center	TEXT20
AccountingDocumentTypeName	Document Type Name	TEXT20
TransactionTypeDetermination	Transaction Key	CHAR3
ClearingAccountingDocument	Clearing Journal Entry	BELNR
SalesDocumentItem	Sales Document Item	POSNR
ProductName	Product Description	TEXT40
SupplierName	Name of Supplier	TEXT80
CustomerName	Name of Customer	TEXT80
CustomerSupplierCorporateGroup	Customer Supplier Corporate Group	KONZS
BusinessSolutionOrder	Solution Order	CRM_OBJECT_ID
BusinessSolutionOrderItem	Solution Order Item	CRMS4_NUMBER_INT
PartnerAccountAssignment	Partner Account Assignment	ACCAS
PartnerWBSElementInternalID	Partner WBS Element Internal ID	FIS_WBSINT_NO_CONV
PartnerWBSElementExternalID	Partner WBS Element External ID	FIS_WBSEXT_NO_CONV
PartnerProjectExternalID	Partner Project External ID	FIS_PROJECTEXT_NO_CONV
PartnerGrant	Partner Grant	GM_GRANT_NBR
AssignmentReference	Assignment Reference	ZUONR
ReferenceDocument	Reference document number	AWREF
ReferenceDocumentItem	Reference Document Item	NUMC6
ReferenceDocumentContext	Reference Document Context	AWORG
PredecessorReferenceDocument	Predecessor Reference Document	AWREF
PredecessorReferenceDocItem	Predecessor Reference Document Item	NUMC6
PredecessorReferenceDocCntxt	Predecessor Reference Document Context	AWORG
InvoiceReference	Invoice Reference	BELNR
InvoiceItemReference	Invoice Item Reference	BUZEI
InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year	GJAHR
SenderCompanyCode	Company Code in Sender System	CHAR4
SenderGLAccount	Sender G/L Account	CHAR10
SenderAccountAssignment	Sender Account Assignment	ACCAS
SenderFiscalYear	Fiscal Year of an Accounting Document in the Sender System	GJAHR
SenderAccountingDocument	Sender Journal Entry	BELNR
SenderLogicalSystem	Sender Logical System	LOGSYS

Master Data Relations	Join Conditions
Journal Entry Type Journal Entry Type Client	`C_CITITEMCLASSIFICATIONQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T003.MANDT`
Type of the Accrual Object Type of the Accrual Object Client	`C_CITITEMCLASSIFICATIONQUERY.ACCRUALOBJECTTYPE == TACR_OBJ_TYPE.ACROBJ_TYPE` `C_CITITEMCLASSIFICATIONQUERY.MANDT == TACR_OBJ_TYPE.MANDT`
Alternative G/L Account Number In Company Code ? Client Alternative G/L Account Number In Company Code	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "KTOPL"] == SKA1.KTOPL` `C_CITITEMCLASSIFICATIONQUERY.MANDT == SKA1.MANDT` `C_CITITEMCLASSIFICATIONQUERY.ALTERNATIVEGLACCOUNT == SKA1.SAKNR`
Asset Class Client Asset Class	`C_CITITEMCLASSIFICATIONQUERY.MANDT == ANKA.MANDT` `C_CITITEMCLASSIFICATIONQUERY.ASSETCLASS == ANKA.ANLKL`
Asset Transaction Type Asset Transaction Type Client	`C_CITITEMCLASSIFICATIONQUERY.ASSETTRANSACTIONTYPE == TABW.BWASL` `C_CITITEMCLASSIFICATIONQUERY.MANDT == TABW.MANDT`
Billing Type Client Billing Type	`C_CITITEMCLASSIFICATIONQUERY.MANDT == TVFK.MANDT` `C_CITITEMCLASSIFICATIONQUERY.BILLINGDOCUMENTTYPE == TVFK.FKART`
Business Process ? Business Process Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CBPR.DATBI` `C_CITITEMCLASSIFICATIONQUERY.BUSINESSPROCESS == CBPR.PRZNR` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CBPR.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CBPR.MANDT`
Business Transaction Category Business Transaction Category Client	`C_CITITEMCLASSIFICATIONQUERY.BUSINESSTRANSACTIONCATEGORY == FINSC_BTTYPE.BTTYPE` `C_CITITEMCLASSIFICATIONQUERY.MANDT == FINSC_BTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`C_CITITEMCLASSIFICATIONQUERY.CHARTOFACCOUNTS == T004.KTOPL` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T004.MANDT`
Controlling Area Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == TKA01.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == TKA01.MANDT`
Cost Analysis Resource Cost Analysis Resource ? Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.COSTANALYSISRESOURCE == CSKR.RESRC` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CSKR.DATBI` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CSKR.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CSKR.MANDT`
Cost Center ? Controlling Area Client Cost Center	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CSKS.DATBI` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CSKS.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CSKS.MANDT` `C_CITITEMCLASSIFICATIONQUERY.COSTCENTER == CSKS.KOSTL`
Activity Type ? Controlling Area Client Activity Type	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CSLA.DATBI` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CSLA.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CSLA.MANDT` `C_CITITEMCLASSIFICATIONQUERY.COSTCTRACTIVITYTYPE == CSLA.LSTAR`
Cost Object ? Cost Object Client	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CKPH.DATBI` `C_CITITEMCLASSIFICATIONQUERY.COSTOBJECT == CKPH.KSTRG` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CKPH.MANDT`
Origin Group as Subdivision of Cost Element ? Origin Group as Subdivision of Cost Element Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "HRKTYP"] == TKKH1.KOATY` `C_CITITEMCLASSIFICATIONQUERY.COSTORIGINGROUP == TKKH1.HRKFT` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == TKKH1.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == TKKH1.MANDT`
Customer Number Customer Number Client	`C_CITITEMCLASSIFICATIONQUERY.CUSTOMER == KNA1.KUNNR` `C_CITITEMCLASSIFICATIONQUERY.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`C_CITITEMCLASSIFICATIONQUERY.CUSTOMERGROUP == T151.KDGRP` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T151.MANDT`
Customer or Supplier Country/Region Customer or Supplier Country/Region Client	`C_CITITEMCLASSIFICATIONQUERY.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T005.MANDT`
Distribution Channel Distribution Channel Client	`C_CITITEMCLASSIFICATIONQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `C_CITITEMCLASSIFICATIONQUERY.MANDT == TVTW.MANDT`
Elimination Profit Center ? Elimination Profit Center Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CEPC.DATBI` `C_CITITEMCLASSIFICATIONQUERY.ELIMINATIONPROFITCENTER == CEPC.PRCTR` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CEPC.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CEPC.MANDT`
Financial Transaction Type Financial Transaction Type Client	`C_CITITEMCLASSIFICATIONQUERY.FINANCIALTRANSACTIONTYPE == T856.TRTYP` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T856.MANDT`
Fiscal Year Variant Fiscal Year Variant Client	`C_CITITEMCLASSIFICATIONQUERY.FISCALYEARVARIANT == T009.PERIV` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T009.MANDT`
Asset Subnumber Asset Subnumber Client Fixed Asset ?	`C_CITITEMCLASSIFICATIONQUERY.FIXEDASSET == ANLA.ANLN2` `C_CITITEMCLASSIFICATIONQUERY.MANDT == ANLA.MANDT` `C_CITITEMCLASSIFICATIONQUERY.MASTERFIXEDASSET == ANLA.ANLN1` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "BUKRS"] == ANLA.BUKRS`
G/L Account G/L Account ? Client	`C_CITITEMCLASSIFICATIONQUERY.GLACCOUNT == SKB1.SAKNR` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "BUKRS"] == SKB1.BUKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == SKB1.MANDT`
Group Asset Subnumber Group Asset Subnumber Client Group Asset ?	`C_CITITEMCLASSIFICATIONQUERY.GROUPFIXEDASSET == ANLA.ANLN2` `C_CITITEMCLASSIFICATIONQUERY.MANDT == ANLA.MANDT` `C_CITITEMCLASSIFICATIONQUERY.GROUPMASTERFIXEDASSET == ANLA.ANLN1` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "BUKRS"] == ANLA.BUKRS`
House Bank Key House Bank Key Client ?	`C_CITITEMCLASSIFICATIONQUERY.HOUSEBANK == T012.HBKID` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T012.MANDT` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "BUKRS"] == T012.BUKRS`
House Bank Account House Bank Account House Bank Key Client ?	`C_CITITEMCLASSIFICATIONQUERY.HOUSEBANKACCOUNT == T012K.HKTID` `C_CITITEMCLASSIFICATIONQUERY.HOUSEBANK == T012K.HBKID` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T012K.MANDT` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "BUKRS"] == T012K.BUKRS`
Joint venture Client Joint venture ?	`C_CITITEMCLASSIFICATIONQUERY.MANDT == T8JV.MANDT` `C_CITITEMCLASSIFICATIONQUERY.JOINTVENTURE == T8JV.VNAME` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "BUKRS"] == T8JV.BUKRS`
Logical System	`C_CITITEMCLASSIFICATIONQUERY.LOGICALSYSTEM == TBDLS.LOGSYS`
Order ID Client Order ID	`C_CITITEMCLASSIFICATIONQUERY.MANDT == AUFK.MANDT` `C_CITITEMCLASSIFICATIONQUERY.ORDERID == AUFK.AUFNR`
Division Division Client	`C_CITITEMCLASSIFICATIONQUERY.ORGANIZATIONDIVISION == TSPA.SPART` `C_CITITEMCLASSIFICATIONQUERY.MANDT == TSPA.MANDT`
Origin Cost Center ? Controlling Area Client Origin Cost Center	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CSKS.DATBI` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CSKS.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CSKS.MANDT` `C_CITITEMCLASSIFICATIONQUERY.ORIGINCOSTCENTER == CSKS.KOSTL`
Origin Cost Center Activity Type ? Origin Cost Center Activity Type Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CSLA.DATBI` `C_CITITEMCLASSIFICATIONQUERY.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CSLA.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CSLA.MANDT`
Origin Profit Center ? Origin Profit Center Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CEPC.DATBI` `C_CITITEMCLASSIFICATIONQUERY.ORIGINPROFITCENTER == CEPC.PRCTR` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CEPC.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CEPC.MANDT`
FM: Partner Budget Period Partner Fund ? FM: Partner Budget Period Client	`C_CITITEMCLASSIFICATIONQUERY.PARTNERFUND == FMFUNDBPD.FINCODE` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS` `C_CITITEMCLASSIFICATIONQUERY.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD` `C_CITITEMCLASSIFICATIONQUERY.MANDT == FMFUNDBPD.MANDT`
Partner Business Area Client Partner Business Area	`C_CITITEMCLASSIFICATIONQUERY.MANDT == TGSB.MANDT` `C_CITITEMCLASSIFICATIONQUERY.PARTNERBUSINESSAREA == TGSB.GSBER`
Partner Business Process Partner Business Process ? Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.PARTNERBUSINESSPROCESS == CBPR.PRZNR` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CBPR.DATBI` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CBPR.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CBPR.MANDT`
Partner Company Code Client Partner Company Code	`C_CITITEMCLASSIFICATIONQUERY.MANDT == T001.MANDT` `C_CITITEMCLASSIFICATIONQUERY.PARTNERCOMPANYCODE == T001.BUKRS`
Partner Cost Center ? Partner Cost Center Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CSKS.DATBI` `C_CITITEMCLASSIFICATIONQUERY.PARTNERCOSTCENTER == CSKS.KOSTL` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CSKS.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CSKS.MANDT`
Partner Cost Center Activity Type ? Partner Cost Center Activity Type Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CSLA.DATBI` `C_CITITEMCLASSIFICATIONQUERY.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CSLA.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CSLA.MANDT`
Partner Cost Object ? Client Partner Cost Object	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CKPH.DATBI` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CKPH.MANDT` `C_CITITEMCLASSIFICATIONQUERY.PARTNERCOSTOBJECT == CKPH.KSTRG`
Partner Functional Area Partner Functional Area Client	`C_CITITEMCLASSIFICATIONQUERY.PARTNERFUNCTIONALAREA == TFKB.FKBER` `C_CITITEMCLASSIFICATIONQUERY.MANDT == TFKB.MANDT`
Partner Fund Partner Fund ? Client	`C_CITITEMCLASSIFICATIONQUERY.PARTNERFUND == FMFINCODE.FINCODE` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "FIKRS"] == FMFINCODE.FIKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == FMFINCODE.MANDT`
Partner Order Partner Order Client	`C_CITITEMCLASSIFICATIONQUERY.PARTNERORDER == AUFK.AUFNR` `C_CITITEMCLASSIFICATIONQUERY.MANDT == AUFK.MANDT`
Partner Profit Center ? Controlling Area Client Partner Profit Center	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CEPC.DATBI` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CEPC.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CEPC.MANDT` `C_CITITEMCLASSIFICATIONQUERY.PARTNERPROFITCENTER == CEPC.PRCTR`
Partner Project Internal ID Partner Project Internal ID Client	`C_CITITEMCLASSIFICATIONQUERY.PARTNERPROJECTINTERNALID == PROJ.PSPNR` `C_CITITEMCLASSIFICATIONQUERY.MANDT == PROJ.MANDT`
Partner Project Network Client Partner Project Network	`C_CITITEMCLASSIFICATIONQUERY.MANDT == AUFK.MANDT` `C_CITITEMCLASSIFICATIONQUERY.PARTNERPROJECTNETWORK == AUFK.AUFNR`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`C_CITITEMCLASSIFICATIONQUERY.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `C_CITITEMCLASSIFICATIONQUERY.MANDT == FAGL_SEGM.MANDT`
Plant Client Plant	`C_CITITEMCLASSIFICATIONQUERY.MANDT == T001W.MANDT` `C_CITITEMCLASSIFICATIONQUERY.PLANT == T001W.WERKS`
Posting Key Client Posting Key	`C_CITITEMCLASSIFICATIONQUERY.MANDT == TBSL.MANDT` `C_CITITEMCLASSIFICATIONQUERY.POSTINGKEY == TBSL.BSCHL`
Predecessor Reference Document Type	`C_CITITEMCLASSIFICATIONQUERY.PREDECESSORREFERENCEDOCTYPE == TTYP.AWTYP`
Product Number Client Product Number	`C_CITITEMCLASSIFICATIONQUERY.MANDT == MARA.MANDT` `C_CITITEMCLASSIFICATIONQUERY.PRODUCT == MARA.MATNR`
Product Group Product Group Client	`C_CITITEMCLASSIFICATIONQUERY.PRODUCTGROUP == T023.MATKL` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T023.MANDT`
Profit Center ? Profit Center Controlling Area Client	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "DATBI"] == CEPC.DATBI` `C_CITITEMCLASSIFICATIONQUERY.PROFITCENTER == CEPC.PRCTR` `C_CITITEMCLASSIFICATIONQUERY.CONTROLLINGAREA == CEPC.KOKRS` `C_CITITEMCLASSIFICATIONQUERY.MANDT == CEPC.MANDT`
Project Internal ID Project Internal ID Client	`C_CITITEMCLASSIFICATIONQUERY.PROJECTINTERNALID == PROJ.PSPNR` `C_CITITEMCLASSIFICATIONQUERY.MANDT == PROJ.MANDT`
Network Number for Account Assignment Network Number for Account Assignment Client	`C_CITITEMCLASSIFICATIONQUERY.PROJECTNETWORK == AUFK.AUFNR` `C_CITITEMCLASSIFICATIONQUERY.MANDT == AUFK.MANDT`
Reference Document Type	`C_CITITEMCLASSIFICATIONQUERY.REFERENCEDOCUMENTTYPE == TTYP.AWTYP`
Sales District Sales District Client	`C_CITITEMCLASSIFICATIONQUERY.SALESDISTRICT == T171.BZIRK` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T171.MANDT`
Sales Organization Client Sales Organization	`C_CITITEMCLASSIFICATIONQUERY.MANDT == TVKO.MANDT` `C_CITITEMCLASSIFICATIONQUERY.SALESORGANIZATION == TVKO.VKORG`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`C_CITITEMCLASSIFICATIONQUERY.MANDT == FAGL_SEGM.MANDT` `C_CITITEMCLASSIFICATIONQUERY.SEGMENT == FAGL_SEGM.SEGMENT`
Service Contract ID Service Contract Item ID Service Contract ID Client Service Contract Type	`C_CITITEMCLASSIFICATIONQUERY.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `C_CITITEMCLASSIFICATIONQUERY.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID` `C_CITITEMCLASSIFICATIONQUERY.MANDT == FCO_SRVDOC.MANDT` `C_CITITEMCLASSIFICATIONQUERY.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Contract Item ID Service Contract Item ID Service Contract ID Client Service Contract Type	`C_CITITEMCLASSIFICATIONQUERY.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `C_CITITEMCLASSIFICATIONQUERY.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID` `C_CITITEMCLASSIFICATIONQUERY.MANDT == FCO_SRVDOC.MANDT` `C_CITITEMCLASSIFICATIONQUERY.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Contract Type Client Service Contract Type	`C_CITITEMCLASSIFICATIONQUERY.MANDT == CRMC_PROC_TYPE.CLIENT` `C_CITITEMCLASSIFICATIONQUERY.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Service Document ID Client Service Document ID Service Document Item ID ?	`C_CITITEMCLASSIFICATIONQUERY.MANDT == FCO_SRVDOC.MANDT` `C_CITITEMCLASSIFICATIONQUERY.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID` `C_CITITEMCLASSIFICATIONQUERY.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "FCO_SRVDOC_TYPE"] == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Document Item ID Client Service Document ID Service Document Item ID ?	`C_CITITEMCLASSIFICATIONQUERY.MANDT == FCO_SRVDOC.MANDT` `C_CITITEMCLASSIFICATIONQUERY.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID` `C_CITITEMCLASSIFICATIONQUERY.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "FCO_SRVDOC_TYPE"] == FCO_SRVDOC.SERVICE_DOC_TYPE`
Product Sold Product Sold Client	`C_CITITEMCLASSIFICATIONQUERY.SOLDPRODUCT == MARA.MATNR` `C_CITITEMCLASSIFICATIONQUERY.MANDT == MARA.MANDT`
Special G/L Indicator Special G/L Indicator Client ?	`C_CITITEMCLASSIFICATIONQUERY.SPECIALGLCODE == T074U.UMSKZ` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T074U.MANDT` `C_CITITEMCLASSIFICATIONQUERY.[column in domain "KOART"] == T074U.KOART`
Subledger-Specific Line Item Type	`C_CITITEMCLASSIFICATIONQUERY.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE`
Supplier Client Supplier	`C_CITITEMCLASSIFICATIONQUERY.MANDT == LFA1.MANDT` `C_CITITEMCLASSIFICATIONQUERY.SUPPLIER == LFA1.LIFNR`
Tax on Sales/Purchases Code ? Client Tax on Sales/Purchases Code	`C_CITITEMCLASSIFICATIONQUERY.[column in domain "KALSM_D"] == T007A.KALSM` `C_CITITEMCLASSIFICATIONQUERY.MANDT == T007A.MANDT` `C_CITITEMCLASSIFICATIONQUERY.TAXCODE == T007A.MWSKZ`