What is C_CITItemClassificationQuery in SAP S/4HANA?

C_CITItemClassificationQuery is a consumption CDS view in SAP S/4HANA. CIT Item Classification - Query It contains 152 fields.

Which tables does C_CITItemClassificationQuery read from?

C_CITItemClassificationQuery reads data from: I_CITItemClassificationCube.

What VDM layer is C_CITItemClassificationQuery?

C_CITItemClassificationQuery is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CITItemClassificationQuery

DDL: C_CITITEMCLASSIFICATIONQUERY SQL: CCITITMCLFNQ Type: view CONSUMPTION

152 Fields 1 Data Sources

CIT Item Classification - Query

C_CITItemClassificationQuery is a Consumption CDS View that provides data about "CIT Item Classification - Query" in SAP S/4HANA. It reads from 1 data source (I_CITItemClassificationCube) and exposes 152 fields.

Data Sources (1)

Source	Alias	Join Type
I_CITItemClassificationCube	I_CITItemClassificationCube	from

Parameters (3)

Name	Type	Default
P_StatryRptgEntity	srf_reporting_entity
P_StatryRptCategory	srf_rep_cat_id
P_StatryRptRunID	srf_report_run_id

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	CCITITMCLFNQ	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
EndUserText.label	CIT Item Classification - Query	view

Fields (152)

Field	Source Field	Description
StatryRptgEntity	StatryRptgEntity	Reporting Entity
StatryRptCategory	StatryRptCategory	Report ID
StatryRptRunID	StatryRptRunID	Report Run ID
CITClassificationUUID	CITClassificationUUID	UUID
CITReportingLine	CITReportingLine	CIT Report Line
CITReportingLineDescription	CITReportingLineDescription
CITReportingItem	CITReportingItem	CIT Report Item
CITItemAmountInDisplayCurrency	CITItemAmountInDisplayCurrency	Amount
Currency	Currency	Valuation Crcy
ItemSignIsReversed	ItemSignIsReversed	Change Item Sign
CITReportingDate	CITReportingDate	CIT Reporting Date
CITReportVersion	CITReportVersion	CIT Report Version
BRFApplication	BRFApplication
CITSettlementCode	CITSettlementCode
CITSettlementCodeDescription	CITSettlementCodeDescription
LogicalSystem
IsReversal	IsReversal	Reversal doc.
IsReversed	IsReversed	Reversed?
ReversalReferenceDocument	ReversalReferenceDocument	Reversal Reference Document
ReversalReferenceDocumentCntxt	ReversalReferenceDocumentCntxt	Reversal Reference Document Context
IsSettlement	IsSettlement	Is Settling
IsSettled	IsSettled	Is Settled
AccountingDocCreatedByUser	AccountingDocCreatedByUser	User which created overhead document
JournalEntryCreationDate	JournalEntryCreationDate	Journal Entry Creation Date
AssetClass	AssetClass	Asset Class
MasterFixedAsset	MasterFixedAsset	Fixed Asset
FixedAsset	FixedAsset	Sub-number
AssetTransactionType	AssetTransactionType	Trans.Type
GroupMasterFixedAsset	GroupMasterFixedAsset
GroupFixedAsset	GroupFixedAsset
ControllingArea	ControllingArea	Controlling Area
ControllingAreaName	ControllingAreaName	Long Text
CostCenter	CostCenter	Cost Center
CostCenterName	CostCenterName	Name
CostCtrActivityType	CostCtrActivityType	Activity Type
ControllingObject	ControllingObject	Object number
ControllingObjectClass	ControllingObjectClass	Object Class
OriginObjectType	OriginObjectType	Origin
CostOriginGroup	CostOriginGroup	Origin Group
ControllingDebitCreditCode	ControllingDebitCreditCode	Dr/Cr ind. CO
PersonnelNumber	PersonnelNumber	Personnel No.
OriginProfitCenter	OriginProfitCenter
OriginCostCenter	OriginCostCenter
OriginCostCtrActivityType	OriginCostCtrActivityType
OrderID	OrderID	Order ID
InternalOrderDescription	InternalOrderDescription	Description
OrderCategory	OrderCategory	Order Category
WBSElementInternalID	WBSElementInternalID	WBS Internal ID
WBSDescription	WBSDescription	WBS Element Name
WBSElementExternalID	WBSElementExternalID	WBS Element External ID
ProjectInternalID	ProjectInternalID	Project Def.
ProjectExternalID	ProjectExternalID	Project def.
ProjectNetwork	ProjectNetwork	Order
BusinessProcess	BusinessProcess	Business Process
CostObject	CostObject	Cost Object
CostAnalysisResource	CostAnalysisResource
WorkItem	WorkItem	Work Item ID
AccrualObject	AccrualObject	External Reference of Accrual Object
AccrualObjectType	AccrualObjectType	Accrual Object Type
AccrualSubobject	AccrualSubobject	External Reference of Accrual Subobject
AccrualItemType	AccrualItemType	Accrual Item Type
ProfitCenter	ProfitCenter	Profit Center
ProfitCenterName	ProfitCenterName	Profit Center Name
AccountingDocumentCategory	AccountingDocumentCategory	Journal Entry Category
AccountingDocumentType	AccountingDocumentType	Journal Entry Type
AccountingDocumentTypeName	AccountingDocumentTypeName
TransactionTypeDetermination	TransactionTypeDetermination	Transaction Key
FinancialTransactionType	FinancialTransactionType	Transact. Type
BillingDocumentType	BillingDocumentType	Billing Type
ClearingAccountingDocument	ClearingAccountingDocument	Clearing Journal Entry
DebitCreditCode	DebitCreditCode	Single-Character Flag
PostingKey	PostingKey	Posting Key
TaxCode	TaxCode	Tax Code
HouseBank	HouseBank	House Bank
HouseBankAccount	HouseBankAccount	House Bank Account
JointVenture	JointVenture	Joint venture
PurchasingDocument	PurchasingDocument	Purchasing Document
PurchasingDocumentItem	PurchasingDocumentItem	Purchasing Doc. Item
SalesDocument	SalesDocument	SD Document
SalesDocumentItem	SalesDocumentItem	Sales Document Item
Product	Product	Product Sold
ProductName	ProductName	Description
ProductGroup	ProductGroup	Product Sold Group
SoldProduct	SoldProduct	Product Sold
Plant	Plant	Valuation Area
SalesOrganization	SalesOrganization	Sales Organization
SalesDistrict	SalesDistrict	Sales District
OrganizationDivision	OrganizationDivision	Org. Division
DistributionChannel	DistributionChannel	RefDistCh-Cust/Mat.
Supplier	Supplier	Supplier
SupplierName	SupplierName	Supplier Name
BPSupplierName	BPSupplierName	Supplier Name
Customer	Customer	Sold-to Party
CustomerName	CustomerName	Name of Customer
BPCustomerName	BPCustomerName	Name of Customer
CustomerGroup	CustomerGroup	Customer Group
CustomerSupplierCountry	CustomerSupplierCountry	Customer or Supplier Country/Region
CustomerSupplierCorporateGroup	CustomerSupplierCorporateGroup	Group
EliminationProfitCenter	EliminationProfitCenter
ServiceContract	ServiceContract	Transaction ID
ServiceContractItem	ServiceContractItem	Item Number in Doc.
ServiceContractType	ServiceContractType
ServiceDocument	ServiceDocument	Transaction ID
ServiceDocumentItem	ServiceDocumentItem	Service Document
BusinessSolutionOrder	BusinessSolutionOrder	Solution Order
BusinessSolutionOrderItem	BusinessSolutionOrderItem	Solution Order Item
SpecialGLCode	SpecialGLCode	Special G/L Ind
PartnerCompanyCode	PartnerCompanyCode	Partner Company Code
PartnerCostCenter	PartnerCostCenter	Sender Cost Ctr
PartnerProfitCenter	PartnerProfitCenter	Profit Center
PartnerFunctionalArea	PartnerFunctionalArea	Rec. Fntcl Area
PartnerBusinessArea	PartnerBusinessArea	Trdg Part.BA
PartnerSegment	PartnerSegment	Partner Segment
PartnerControllingObjectClass	PartnerControllingObjectClass
PartnerAccountAssignment	PartnerAccountAssignment	Partner Account Assignment
PartnerAccountAssignmentType	PartnerAccountAssignmentType	Partner Account Assignment Type
PartnerCostCtrActivityType	PartnerCostCtrActivityType	Partner Cost Center Activity Type
PartnerOrder	PartnerOrder	Partner Order
PartnerOrderCategory	PartnerOrderCategory
PartnerWBSElementInternalID	PartnerWBSElementInternalID	Partner WBS Element Internal ID
PartnerWBSElementExternalID	PartnerWBSElementExternalID	Partner WBSElmnt ext
PartnerProjectInternalID	PartnerProjectInternalID
PartnerProjectExternalID	PartnerProjectExternalID	Partner Project External ID
PartnerProjectNetwork	PartnerProjectNetwork	Part. Proj. Network
PartnerSalesDocument	PartnerSalesDocument	Partner Sales Doc.
PartnerSalesDocumentItem	PartnerSalesDocumentItem	Partner Sales Document Item
PartnerBusinessProcess	PartnerBusinessProcess	Part. Bus. Process
PartnerCostObject	PartnerCostObject	Partner Cost Object
PartnerFund	PartnerFund	Receiver Fund
PartnerGrant	PartnerGrant	Receiver Grant
PartnerBudgetPeriod	PartnerBudgetPeriod	Partner Budget Period
AssignmentReference	AssignmentReference	Assignment Reference
ReferenceDocument	ReferenceDocument	Reference Document
ReferenceDocumentItem	ReferenceDocumentItem	Reference item
ReferenceDocumentType	ReferenceDocumentType	Reference Document Type
ReferenceDocumentContext	ReferenceDocumentContext	Reference Document Context
PredecessorReferenceDocument	PredecessorReferenceDocument	Predecessor Reference Document
PredecessorReferenceDocItem	PredecessorReferenceDocItem	Prec. Ref. Doc. Item
PredecessorReferenceDocType	PredecessorReferenceDocType	Predecessor Reference Document Type
PredecessorReferenceDocCntxt	PredecessorReferenceDocCntxt	Predecessor Reference Document Context
InvoiceReference	InvoiceReference	Invoice Reference
InvoiceItemReference	InvoiceItemReference	Item
InvoiceReferenceFiscalYear	InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
BusinessTransactionCategory	BusinessTransactionCategory	Business Transaction Category
SubLedgerAcctLineItemType	SubLedgerAcctLineItemType	SLALineItemType
SenderCompanyCode	SenderCompanyCode	Sender Company Code
SenderGLAccount	SenderGLAccount
SenderAccountAssignment	SenderAccountAssignment
SenderAccountAssignmentType	SenderAccountAssignmentType
SenderFiscalYear	SenderFiscalYear	Sender FiscalYr
SenderAccountingDocument	SenderAccountingDocument	Sender Journal Entry
SenderLogicalSystem	SenderLogicalSystem	Sender Logical System

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CITItemClassificationQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCITITMCLFNQ
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_CITItemClassificationQuery AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CITClassificationUUID,
  CITReportingLine,
  CITReportingLineDescription,
  CITReportingItem,
  CITItemAmountInDisplayCurrency,
  Currency,
  ItemSignIsReversed,
  CITReportingDate,
  CITReportVersion,
  BRFApplication,
  CITSettlementCode,
  CITSettlementCodeDescription,
  / LogicalSystem AS LogicalSystem,
  IsReversal,
  IsReversed,
  ReversalReferenceDocument,
  ReversalReferenceDocumentCntxt,
  IsSettlement,
  IsSettled,
  AccountingDocCreatedByUser,
  JournalEntryCreationDate,
  AssetClass,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  ControllingArea,
  ControllingAreaName,
  CostCenter,
  CostCenterName,
  CostCtrActivityType,
  ControllingObject,
  ControllingObjectClass,
  OriginObjectType,
  CostOriginGroup,
  ControllingDebitCreditCode,
  PersonnelNumber,
  OriginProfitCenter,
  OriginCostCenter,
  OriginCostCtrActivityType,
  OrderID,
  InternalOrderDescription,
  OrderCategory,
  WBSElementInternalID,
  WBSDescription,
  WBSElementExternalID,
  ProjectInternalID,
  ProjectExternalID,
  ProjectNetwork,
  BusinessProcess,
  CostObject,
  CostAnalysisResource,
  WorkItem,
  AccrualObject,
  AccrualObjectType,
  AccrualSubobject,
  AccrualItemType,
  ProfitCenter,
  ProfitCenterName,
  AccountingDocumentCategory,
  AccountingDocumentType,
  AccountingDocumentTypeName,
  TransactionTypeDetermination,
  FinancialTransactionType,
  BillingDocumentType,
  ClearingAccountingDocument,
  DebitCreditCode,
  PostingKey,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  JointVenture,
  PurchasingDocument,
  PurchasingDocumentItem,
  SalesDocument,
  SalesDocumentItem,
  Product,
  ProductName,
  ProductGroup,
  SoldProduct,
  Plant,
  SalesOrganization,
  SalesDistrict,
  OrganizationDivision,
  DistributionChannel,
  Supplier,
  SupplierName,
  BPSupplierName,
  Customer,
  CustomerName,
  BPCustomerName,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierCorporateGroup,
  EliminationProfitCenter,
  ServiceContract,
  ServiceContractItem,
  ServiceContractType,
  ServiceDocument,
  ServiceDocumentItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  SpecialGLCode,
  PartnerCompanyCode,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerSegment,
  PartnerControllingObjectClass,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerWBSElementInternalID,
  PartnerWBSElementExternalID,
  PartnerProjectInternalID,
  PartnerProjectExternalID,
  PartnerProjectNetwork,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerBusinessProcess,
  PartnerCostObject,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  AssignmentReference,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  InvoiceReference,
  InvoiceItemReference,
  InvoiceReferenceFiscalYear,
  BusinessTransactionCategory,
  SubLedgerAcctLineItemType,
  SenderCompanyCode,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  SenderFiscalYear,
  SenderAccountingDocument,
  SenderLogicalSystem
FROM I_CITItemClassificationCube
;

Depth:

C_CITItemClassificationQuery view

I_CITItemClassificationCube view