C_CnsldtnJrnlEntryItemTP

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_CnsldtnJrnlEntryItemTP.
-- 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.

CREATE VIEW C_CnsldtnJrnlEntryItemTP AS
SELECT
  FiscalYear,
  ConsolidationLedger,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  FiscalYearForEdit,
  ConsolidationUnit1IsUsed,
  ConsolidationDimension,
  GLRecordType,
  ConsolidationVersion,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  Company,
  ConsolidationUnit,
  _ConsolidationUnitText.ConsolidationUnitText AS ConsolidationUnitMdmText,
  ConsolidationChartOfAccounts,
  _CnsldtnCoAText.ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  FinancialStatementItem,
  _FSItemText.FinancialStatementItemMdmText AS FinancialStatementItemMdmText,
  PartnerConsolidationUnit,
  _PartnerConsolidationUnitText.ConsolidationUnitText AS PartnerCnsldtnUnitMediumText,
  ConsolidationGroup,
  CompanyCode,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationDocumentType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  _InvesteeConsolidationUnitText.ConsolidationUnitText AS InvesteeConsolidationUnitText,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  CurrencyTranslationDate,
  ReferenceFiscalYear,
  RefConsolidationDocumentNumber,
  RefConsolidationPostingItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  _InvestmentActivityTypeText.InvestmentActivityType AS InvestmentActivityTypeText,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  PostingDate,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  Plant,
  FinancialTransactionType,
  WBSElementInternalID,
  WBSElementExternalID,
  Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  MaterialGroup,
  ProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  ConsolidationUnit3,
  _ConsolidationUnit3Text.ConsolidationUnitText AS CnsldtnUnit3Text,
  PartnerConsolidationUnit3,
  _PartnerConsolidationUnit3Text.ConsolidationUnitText AS PartnerCnsldtnUnit3Text,
  FiscalYearPeriod,
  _FSItemAttribute.CnsldtnFSItemRole AS CnsldtnFSItemRole,
  _FSItemAttribute.CnsldtnFSItemDataCollection AS CnsldtnFSItemDataCollection,
  _FSItemAttribute.CnsldtnFSItemCrcyTranslation AS CnsldtnFSItemCrcyTranslation,
  _FSItemAttribute.CnsldtnFSItemElimination AS CnsldtnFSItemElimination,
  _FSItemAttribute.CnsldtnFSItemCashFlow AS CnsldtnFSItemCashFlow,
  _FSItemAttribute.CnsldtnFSItemScope AS CnsldtnFSItemScope,
  _FSItemAttribute.CnsldtnFSItemCustomerSpecific AS CnsldtnFSItemCustomerSpecific,
  _FSItemAttribute.CnsldtnEliminationTargetFSItem AS CnsldtnEliminationTargetFSItem,
  _FSItemAttribute.CnsldtnNCITargetFSItem AS CnsldtnNCITargetFSItem,
  _FSItemAttribute.CnsldtnPlanningTargetFSItem AS CnsldtnPlanningTargetFSItem
FROM I_CnsldtnJrnlEntryItemTP AS CnsldtnJrnlEntryItemTP
LEFT OUTER JOIN C_CnsldtnJrnlEntryTP AS _Header ON _Header.FiscalYear = FiscalYear AND _Header.ConsolidationLedger = ConsolidationLedger AND _Header.ConsolidationDocumentNumber = ConsolidationDocumentNumber  -- association [1..1]
LEFT OUTER JOIN C_CnsldtnProjectVH AS _CnsldtnProjectVH ON _CnsldtnProjectVH.Project = Project  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnMaterialGroupVH AS _CnsldtnMaterialGroupVH ON _CnsldtnMaterialGroupVH.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnMaterialGroupVH AS _CnsldtnProductGroupVH ON _CnsldtnProductGroupVH.MaterialGroup = ProductGroup  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnMaterialVH AS _CnsldtnSoldMaterialVH ON _CnsldtnSoldMaterialVH.Material = SoldMaterial  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnWBSElementVH AS _CnsldtnWBSElementVH ON _CnsldtnWBSElementVH.WBSElementExternalID = WBSElementExternalID AND _CnsldtnWBSElementVH.Project = Project  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnPlantVH AS _CnsldtnPlantVH ON _CnsldtnPlantVH.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnFinTransTypeVH AS _CnsldtnFinTransTypeVH ON _CnsldtnFinTransTypeVH.FinancialTransactionType = FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnBillgTypeVH AS _CnsldtnBillgTypeVH ON _CnsldtnBillgTypeVH.BillingDocumentType = BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnSlsOrgVH AS _CnsldtnSlsOrgVH ON _CnsldtnSlsOrgVH.SalesOrganization = SalesOrganization  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnDistrChnlVH AS _CnsldtnDistrChnlVH ON _CnsldtnDistrChnlVH.DistributionChannel = DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnDivnVH AS _CnsldtnDivnVH ON _CnsldtnDivnVH.Division = OrganizationDivision  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnCustGrpVH AS _CnsldtnCustGrpVH ON _CnsldtnCustGrpVH.CustomerGroup = CustomerGroup  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnIndustryVH AS _CnsldtnIndustryVH ON _CnsldtnIndustryVH.Industry = CustomerSupplierIndustry  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnSlsDstrctVH AS _CnsldtnSlsDstrctVH ON _CnsldtnSlsDstrctVH.SalesDistrict = SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCountry AS _CnsldtnCountry ON _CnsldtnCountry.Country = CustomerSupplierCountry  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _ConsolidationUnitText ON ConsolidationUnit = _ConsolidationUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnPartnerUnitVH AS _PartnerConsolidationUnitText ON PartnerConsolidationUnit = _PartnerConsolidationUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnInvesteeUnitVH AS _InvesteeConsolidationUnitText ON InvesteeConsolidationUnit = _InvesteeConsolidationUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnInvmtEquityActyVH AS _InvestmentActivityTypeText ON InvestmentActivityType = _InvestmentActivityTypeText.InvestmentActivityType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItemText AS _FSItemText ON _FSItemText.FinancialStatementItem = FinancialStatementItem AND _FSItemText.ConsolidationChartOfAccounts = ConsolidationChartOfAccounts AND _FSItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccountsT AS _CnsldtnCoAText ON _CnsldtnCoAText.ConsolidationChartOfAccounts = ConsolidationChartOfAccounts AND _CnsldtnCoAText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _ConsolidationUnit3Text ON ConsolidationUnit = _ConsolidationUnit3Text.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnPartnerUnitVH AS _PartnerConsolidationUnit3Text ON PartnerConsolidationUnit3 = _PartnerConsolidationUnit3Text.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItemByTimeVersion AS _FSItemAttribute ON FinancialStatementItem = _FSItemAttribute.CnsldtnFinancialStatementItem AND ConsolidationChartOfAccounts = _FSItemAttribute.ConsolidationChartOfAccounts AND ConsolidationVersion = _FSItemAttribute.ConsolidationVersion AND FiscalYearPeriod >= _FSItemAttribute.FromFiscalYearPeriod AND FiscalYearPeriod <= _FSItemAttribute.ToFiscalYearPeriod  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnPartnerCompanyVH AS _CnsldtnPartnerCompanyVH ON _CnsldtnPartnerCompanyVH.Company = PartnerCompany  -- association [0..1]
;