P_CITItemClassification2

DDL: P_CITITEMCLASSIFICATION2 SQL: PCITITMCLFN2 Type: view COMPOSITE
1 Data Sources 12 Associations

P_CITItemClassification2 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_CITItemClassification1). It has 12 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_CITItemClassification1 P_CITItemClassification1 from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Associations (12)

CardinalityTargetAliasCondition
[0..*] I_CITReportingLineText _ReportingLineText $projection.CITReportVersion = _ReportingLineText.CITReportVersion and $projection.CITReportingLine = _ReportingLineText.CITReportingLine
[0..1] I_CompanyCode _CompanyCodeText $projection.CompanyCode = _CompanyCodeText.CompanyCode
[0..1] I_InternalOrder _InternalOrder $projection.OrderID = _InternalOrder.InternalOrder
[0..*] I_AccountingDocumentTypeText _AccountingDocumentTypeText $projection.AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType
[0..1] I_WBSElementBasicData _WBSElementBasicDataText $projection.WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID
[0..*] I_CostCenterText _CostCenterTxt $projection.ControllingArea = _CostCenterTxt.ControllingArea and $projection.CostCenter = _CostCenterTxt.CostCenter
[0..*] I_ProfitCenterText _ProfitCenterTxt $projection.ControllingArea = _ProfitCenterTxt.ControllingArea and $projection.ProfitCenter = _ProfitCenterTxt.ProfitCenter
[1..1] I_JournalEntry _JournalEntry journalItem.AccountingDocument = _JournalEntry.AccountingDocument and journalItem.CompanyCode = _JournalEntry.CompanyCode and journalItem.FiscalYear = _JournalEntry.FiscalYear
[0..*] I_LedgerText _LedgerText item.Ledger = _LedgerText.Ledger
[0..*] P_CITClassificationCode _HierarchyNode item.CorporateIncomeTaxHierarchy = _HierarchyNode.CorporateIncomeTaxHierarchy and item.CITClassificationCode = _HierarchyNode.CITClassificationCode
[0..*] I_GLAccountText _GLAccountText journalItem.GLAccount = _GLAccountText.GLAccount and journalItem.ChartOfAccounts = _GLAccountText.ChartOfAccounts
[0..*] I_ProductText _ProductText journalItem.Product = _ProductText.Product

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCITITMCLFN2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view

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 *  -- field list not available in parsed metadata
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..*]
;

Learn More