I_CITItemClassificationCube

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 I_CITItemClassificationCube.
-- 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: ICITITMCLFNC
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW I_CITItemClassificationCube AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CITClassificationUUID,
  CITSettlementUUID,
  CITReportingLine,
  CITReportingLineDescription,
  CITReportingItem,
  CITReportingDate,
  CITReportVersion,
  BRFApplication,
  CITSettlementCode,
  CITSettlementCodeDescription,
  CITItemAmountInDisplayCurrency,
  Currency,
  ItemSignIsReversed,
  / 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,
  Customer,
  CustomerName,
  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 P_CITItemClassification2
LEFT OUTER JOIN E_CITItemClassificationLog AS _Classification ON StatryRptgEntity = _Classification.StatryRptgEntity AND StatryRptCategory = _Classification.StatryRptCategory AND StatryRptRunID = _Classification.StatryRptRunID AND CITClassificationUUID = _Classification.CITClassificationUUID AND CITReportingLine = _Classification.CITReportingLine  -- association [0..1]
LEFT OUTER JOIN E_CITSettlementLog AS _Settlement ON StatryRptgEntity = _Settlement.StatryRptgEntity AND StatryRptCategory = _Settlement.StatryRptCategory AND StatryRptRunID = _Settlement.StatryRptRunID AND CITSettlementUUID = _Settlement.CITSettlementUUID  -- association [0..1]
;