P_CITItemClassification2

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

CREATE VIEW P_CITItemClassification2 AS
SELECT
  item.StatryRptgEntity AS StatryRptgEntity,
  item.StatryRptCategory AS StatryRptCategory,
  item.StatryRptRunID AS StatryRptRunID,
  item.CITClassificationUUID AS CITClassificationUUID,
  item.CITSettlementUUID AS CITSettlementUUID,
  item.CITReportingLine AS CITReportingLine,
  _ReportingLineText[1:Language = $session.system_language].CITReportingLineDescription AS CITReportingLineDescription,
  item.CITReportingItem AS CITReportingItem,
  item.CITReportingDate AS CITReportingDate,
  item.CITReportVersion AS CITReportVersion,
  item.BRFApplication AS BRFApplication,
  item.CITSettlementCode AS CITSettlementCode,
  item.CITSettlementCodeDescription AS CITSettlementCodeDescription,
  item.CITItemAmountInDisplayCurrency AS CITItemAmountInDisplayCurrency,
  item.Currency AS Currency,
  item.ItemSignIsReversed AS ItemSignIsReversed,
  item.CITItemType AS CITItemType,
  _JournalEntry.TaxReportingDate AS TaxReportingDate,
  item.Ledger AS Ledger,
  _LedgerText[1:Language = $session.system_language].LedgerName AS LedgerName,
  item.SourceLedger AS SourceLedger,
  item.CompanyCode AS CompanyCode,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  item.CorporateIncomeTaxHierarchy AS CorporateIncomeTaxHierarchy,
  item.CITClassificationCode AS CITClassificationCode,
  _HierarchyNode.CITClassificationCodeDesc AS CITClassificationCodeDesc,
  journalItem.ChartOfAccounts AS ChartOfAccounts,
  journalItem.GLAccount AS GLAccount,
  cast( _GLAccountText[1:Language = $session.system_language].GLAccountLongName as fis_txt50_skat preserving type ) AS GLAccountLongName,
  journalItem.AlternativeGLAccount AS AlternativeGLAccount,
  item.FiscalYear AS FiscalYear,
  journalItem.FiscalYearVariant AS FiscalYearVariant,
  journalItem.LedgerFiscalYear AS LedgerFiscalYear,
  journalItem.FiscalYearPeriod AS FiscalYearPeriod,
  journalItem.PostingDate AS PostingDate,
  journalItem.DocumentDate AS DocumentDate,
  journalItem.Segment AS Segment,
  cast( item.AccountingDocument as fis_belnr preserving type ) AS AccountingDocument,
  cast( item.LedgerGLLineItem as fis_docln preserving type ) AS LedgerGLLineItem,
  _JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  journalItem.DocumentItemText AS DocumentItemText,
  journalItem.LogicalSystem AS LogicalSystem,
  journalItem.IsReversal AS IsReversal,
  journalItem.IsReversed AS IsReversed,
  journalItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  journalItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  journalItem.IsSettlement AS IsSettlement,
  journalItem.IsSettled AS IsSettled,
  journalItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  cast( journalItem.CreationDate as wlf_journal_entry_crtn_dte_utc preserving type ) AS JournalEntryCreationDate,
  journalItem.AssetClass AS AssetClass,
  journalItem.MasterFixedAsset AS MasterFixedAsset,
  journalItem.FixedAsset AS FixedAsset,
  journalItem.AssetTransactionType AS AssetTransactionType,
  journalItem.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  journalItem.GroupFixedAsset AS GroupFixedAsset,
  journalItem.ControllingArea AS ControllingArea,
  journalItem._ControllingArea.ControllingAreaName AS ControllingAreaName,
  journalItem.CostCenter AS CostCenter,
  _CostCenterTxt[1:Language = $session.system_language and ValidityStartDate <= CITReportingDate and ValidityEndDate >= CITReportingDate].CostCenterName AS CostCenterName,
  journalItem.CostCtrActivityType AS CostCtrActivityType,
  journalItem.ControllingObject AS ControllingObject,
  journalItem.ControllingObjectClass AS ControllingObjectClass,
  journalItem.OriginObjectType AS OriginObjectType,
  journalItem.CostOriginGroup AS CostOriginGroup,
  cast( journalItem.ControllingDebitCreditCode as ficite_co_belkz preserving type ) AS ControllingDebitCreditCode,
  journalItem.PersonnelNumber AS PersonnelNumber,
  journalItem.OriginProfitCenter AS OriginProfitCenter,
  journalItem.OriginCostCenter AS OriginCostCenter,
  journalItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  journalItem.OrderID AS OrderID,
  _InternalOrder.InternalOrderDescription AS InternalOrderDescription,
  journalItem.OrderCategory AS OrderCategory,
  journalItem.WBSElementInternalID AS WBSElementInternalID,
  _WBSElementBasicDataText.WBSDescription AS WBSDescription,
  cast( journalItem._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
  journalItem._WBSElementBasicData.FunctionalArea AS FunctionalArea,
  journalItem.Project AS Project,
  journalItem.ProjectInternalID AS ProjectInternalID,
  cast ( journalItem._ProjectBasicData.ProjectExternalID as fis_projectext_no_conv preserving type ) AS ProjectExternalID,
  journalItem.ProjectNetwork AS ProjectNetwork,
  journalItem.BusinessProcess AS BusinessProcess,
  journalItem.CostObject AS CostObject,
  journalItem.CostAnalysisResource AS CostAnalysisResource,
  journalItem.WorkItem AS WorkItem,
  journalItem.AccrualObject AS AccrualObject,
  journalItem.AccrualObjectType AS AccrualObjectType,
  journalItem.AccrualSubobject AS AccrualSubobject,
  journalItem.AccrualItemType AS AccrualItemType,
  journalItem.ProfitCenter AS ProfitCenter,
  _ProfitCenterTxt[1:Language = $session.system_language and ValidityStartDate <= citreportingdate and ValidityEndDate >= citreportingdate].ProfitCenterName AS ProfitCenterName,
  journalItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  journalItem.AccountingDocumentType AS AccountingDocumentType,
  _AccountingDocumentTypeText[1:Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  journalItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  journalItem.FinancialTransactionType AS FinancialTransactionType,
  journalItem.BillingDocumentType AS BillingDocumentType,
  journalItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  journalItem.DebitCreditCode AS DebitCreditCode,
  journalItem.PostingKey AS PostingKey,
  journalItem.TaxCode AS TaxCode,
  journalItem.HouseBank AS HouseBank,
  journalItem.HouseBankAccount AS HouseBankAccount,
  journalItem.JointVenture AS JointVenture,
  journalItem.PurchasingDocument AS PurchasingDocument,
  journalItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  journalItem.SalesDocument AS SalesDocument,
  journalItem.SalesDocumentItem AS SalesDocumentItem,
  journalItem.Product AS Product,
  _ProductText[1:Language = $session.system_language].ProductName AS ProductName,
  journalItem.ProductGroup AS ProductGroup,
  journalItem.SoldProduct AS SoldProduct,
  journalItem.Plant AS Plant,
  journalItem.SalesOrganization AS SalesOrganization,
  journalItem.SalesDistrict AS SalesDistrict,
  journalItem.OrganizationDivision AS OrganizationDivision,
  journalItem.DistributionChannel AS DistributionChannel,
  journalItem.Supplier AS Supplier,
  journalItem._Supplier.SupplierName AS SupplierName,
  journalItem._Supplier.BPSupplierName AS BPSupplierName,
  journalItem.Customer AS Customer,
  journalItem._Customer.CustomerName AS CustomerName,
  journalItem._Customer.BPCustomerName AS BPCustomerName,
  journalItem.CustomerGroup AS CustomerGroup,
  journalItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  journalItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  journalItem.EliminationProfitCenter AS EliminationProfitCenter,
  journalItem.ServiceContract AS ServiceContract,
  journalItem.ServiceContractItem AS ServiceContractItem,
  journalItem.ServiceContractType AS ServiceContractType,
  journalItem.ServiceDocument AS ServiceDocument,
  journalItem.ServiceDocumentItem AS ServiceDocumentItem,
  journalItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  journalItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  journalItem.SpecialGLCode AS SpecialGLCode,
  journalItem.PartnerCompanyCode AS PartnerCompanyCode,
  journalItem.PartnerCostCenter AS PartnerCostCenter,
  journalItem.PartnerProfitCenter AS PartnerProfitCenter,
  journalItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  journalItem.PartnerBusinessArea AS PartnerBusinessArea,
  journalItem.PartnerSegment AS PartnerSegment,
  journalItem.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  journalItem.PartnerAccountAssignment AS PartnerAccountAssignment,
  journalItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  journalItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  journalItem.PartnerOrder AS PartnerOrder,
  journalItem.PartnerOrderCategory AS PartnerOrderCategory,
  journalItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  cast( journalItem._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv preserving type ) AS PartnerWBSElementExternalID,
  journalItem.PartnerProjectInternalID AS PartnerProjectInternalID,
  cast ( journalItem._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv preserving type ) AS PartnerProjectExternalID,
  journalItem.PartnerProjectNetwork AS PartnerProjectNetwork,
  journalItem.PartnerSalesDocument AS PartnerSalesDocument,
  journalItem.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  journalItem.PartnerBusinessProcess AS PartnerBusinessProcess,
  journalItem.PartnerCostObject AS PartnerCostObject,
  journalItem.PartnerFund AS PartnerFund,
  journalItem.PartnerGrant AS PartnerGrant,
  journalItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  journalItem.AssignmentReference AS AssignmentReference,
  journalItem.ReferenceDocument AS ReferenceDocument,
  journalItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  journalItem.ReferenceDocumentType AS ReferenceDocumentType,
  journalItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  journalItem.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  journalItem.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  journalItem.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  journalItem.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  journalItem.InvoiceReference AS InvoiceReference,
  journalItem.InvoiceItemReference AS InvoiceItemReference,
  journalItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  journalItem.BusinessTransactionCategory AS BusinessTransactionCategory,
  journalItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  journalItem.SenderCompanyCode AS SenderCompanyCode,
  journalItem.SenderGLAccount AS SenderGLAccount,
  journalItem.SenderAccountAssignment AS SenderAccountAssignment,
  journalItem.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  _JournalEntry.SenderFiscalYear AS SenderFiscalYear,
  _JournalEntry.SenderAccountingDocument AS SenderAccountingDocument,
  _JournalEntry.SenderLogicalSystem AS SenderLogicalSystem
FROM P_CITItemClassification1
LEFT OUTER JOIN I_CITReportingLineText AS _ReportingLineText ON CITReportVersion = _ReportingLineText.CITReportVersion AND CITReportingLine = _ReportingLineText.CITReportingLine  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicDataText ON WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterTxt ON ControllingArea = _CostCenterTxt.ControllingArea AND CostCenter = _CostCenterTxt.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterTxt ON ControllingArea = _ProfitCenterTxt.ControllingArea AND ProfitCenter = _ProfitCenterTxt.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON journalItem.AccountingDocument = _JournalEntry.AccountingDocument AND journalItem.CompanyCode = _JournalEntry.CompanyCode AND journalItem.FiscalYear = _JournalEntry.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON item.Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN P_CITClassificationCode AS _HierarchyNode ON item.CorporateIncomeTaxHierarchy = _HierarchyNode.CorporateIncomeTaxHierarchy AND item.CITClassificationCode = _HierarchyNode.CITClassificationCode  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON journalItem.GLAccount = _GLAccountText.GLAccount AND journalItem.ChartOfAccounts = _GLAccountText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON journalItem.Product = _ProductText.Product  -- association [0..*]
;