I_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 I_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 I_CnsldtnJrnlEntryItemTP AS
SELECT
  ryear AS FiscalYear,
  docnr AS ConsolidationDocumentNumber,
  rldnr AS ConsolidationLedger,
  docln AS ConsolidationPostingItem,
  ryear AS FiscalYearForEdit,
  rldnr AS ConsolidationLedgerForEdit,
  rdimen AS ConsolidationDimension,
  rrcty AS GLRecordType,
  rvers AS ConsolidationVersion,
  rtcur AS TransactionCurrency,
  rhcur AS LocalCurrency,
  rkcur AS GroupCurrency,
  runit AS BaseUnit,
  poper AS FiscalPeriod,
  rcomp AS Company,
  cast ( rbunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  ritclg AS ConsolidationChartOfAccounts,
  ritem AS FinancialStatementItem,
  cast ( rbuptr as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
  rcongr AS ConsolidationGroup,
  robukrs AS CompanyCode,
  sityp AS SubItemCategory,
  subit AS SubItem,
  plevl AS PostingLevel,
  rpflg AS ConsolidationApportionment,
  rtflg AS CurrencyConversionsDiffType,
  docty AS ConsolidationDocumentType,
  yracq AS ConsolidationAcquisitionYear,
  pracq AS ConsolidationAcquisitionPeriod,
  cast ( coicu as fincs_investeeconsunit preserving type ) AS InvesteeConsolidationUnit,
  cast ( uppcu as fincs_investorconsunit preserving type ) AS InvestorConsolidationUnit,
  tsl AS AmountInTransactionCurrency,
  hsl AS AmountInLocalCurrency,
  ksl AS AmountInGroupCurrency,
  msl AS QuantityInBaseUnit,
  sgtxt AS DocumentItemText,
  autom AS ConsolidationPostgItemAutoFlag,
  activ AS BusinessTransactionType,
  budat AS PostingDate,
  wsdat AS CurrencyTranslationDate,
  refdocnr AS RefAccountingDocument,
  refdocnr AS RefConsolidationDocumentNumber,
  refryear AS ReferenceFiscalYear,
  refdocln AS RefConsolidationPostingItem,
  refdocln AS RefAccountingDocumentItem,
  refdocct AS RefConsolidationDocumentType,
  refactiv AS RefBusinessTransactionType,
  cpudt AS CreationDate,
  cputm AS CreationTime,
  usnam AS UserID,
  rvsdocnr AS ReverseDocument,
  orndocnr AS ReversedDocument,
  coiac AS InvestmentActivityType,
  coinr AS InvestmentActivity,
  revyear AS ConsolidationDocReversalYear,
  awtyp AS ReferenceDocumentType,
  aworg AS ReferenceDocumentContext,
  logsys AS LogicalSystem,
  ktopl AS ChartOfAccounts,
  racct AS GLAccount,
  zuonr AS AssignmentReference,
  rcntr AS CostCenter,
  prctr AS ProfitCenter,
  rfarea AS FunctionalArea,
  rbusa AS BusinessArea,
  kokrs AS ControllingArea,
  Segment,
  scntr AS PartnerCostCenter,
  pprctr AS PartnerProfitCenter,
  sfarea AS PartnerFunctionalArea,
  sbusa AS PartnerBusinessArea,
  rassc AS PartnerCompany,
  psegment AS PartnerSegment,
  aufnr AS OrderID,
  kunnr AS Customer,
  lifnr AS Supplier,
  matnr AS Material,
  werks AS Plant,
  rmvct AS FinancialTransactionType,
  ps_psp_pnr AS WBSElementInternalID,
  ps_posid AS WBSElementExternalID,
  ps_pspid AS Project,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matnr_copa AS SoldMaterial,
  matkl_mm AS MaterialGroup,
  matkl AS ProductGroup,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  brsch AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  kunre AS BillToParty,
  kunwe AS ShipToParty,
  konzs AS CustomerSupplierCorporateGroup,
  rbunit AS ConsolidationUnit3,
  rbuptr AS PartnerConsolidationUnit3,
  cast(fiscyearper as fis_jahrper_conv preserving type) AS FiscalYearPeriod,
  cast ( fs_product_group as fincs_finsrvcsproductgroup preserving type ) AS FinancialServicesProductGroup,
  cast ( branch_id as fincs_financialservicesbranch preserving type ) AS FinancialServicesBranch,
  cast ( datasource_id as fincs_financialdatasource preserving type ) AS FinancialDataSource,
  cast ( fikrs as fincs_financialmanagementarea preserving type ) AS FinancialManagementArea,
  cast ( rfund as fincs_fund preserving type ) AS Fund,
  cast ( rgrant_nbr as fincs_grant preserving type ) AS GrantID,
  cast ( re_ktopl as fincs_cashledgerchartofaccts preserving type ) AS CnsldtnCashLedgerChartOfAccts,
  cast ( re_account as fincs_cashledgeraccount preserving type ) AS CashLedgerAccount,
  cast ( sfund as fincs_partnerfund preserving type ) AS PartnerFund,
  cast ( ghgscope as fincs_ghgscope preserving type ) AS GHGScope,
  cast ( ghgcategory as fincs_ghgcategory preserving type ) AS GHGCategory,
  cast ( ghgscp2calcmeth as fincs_ghgscp2calculationmethod preserving type ) AS GHGScope2CalculationMethod,
  cast ( ghgscp2contrinstr as fincs_ghgscp2cntrctlinstrument preserving type ) AS GHGScope2ContractualInstrument,
  cast ( susmodeoftransport as fincs_sustmodeoftransport preserving type ) AS SustainabilityModeOfTransport,
  cast ( ghgdtaqltycharc as fincs_ghgdtaqltycharc preserving type ) AS GHGDataQualityCharacteristic,
  cast ( ghgenergyclass as fincs_ghgenergyclassification preserving type ) AS GHGEnergyClassification,
  cast ( ghgenergymix as fincs_ghgenergymix preserving type ) AS GHGEnergyMix,
  cast ( ghgengysrcgtype as fincs_ghgenergysourcingtype preserving type ) AS GHGEnergySourcingType
FROM acdocu AS u
INNER JOIN I_CnsldtnGlobalParameter AS _GlobalParameter ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_CnsldtnGroupJrnlEntryItem AS _Extension ON ConsolidationLedger = _Extension.ConsolidationLedger AND ConsolidationDimension = _Extension.ConsolidationDimension AND FiscalYear = _Extension.FiscalYear AND ConsolidationDocumentNumber = _Extension.CnsldtnGroupJrnlEntry AND ConsolidationPostingItem = _Extension.CnsldtnGroupJrnlEntryItem  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnJrnlEntryTP AS _Header ON _Header.FiscalYear = FiscalYear AND _Header.ConsolidationDocumentNumber = ConsolidationDocumentNumber AND _Header.ConsolidationLedger = ConsolidationLedger  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnLedger AS _Ledger ON ConsolidationLedger = _Ledger.ConsolidationLedger  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnVersion AS _Version ON ConsolidationVersion = _Version.ConsolidationVersion  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnGroup AS _CnsldtnGroup ON ConsolidationGroup = _CnsldtnGroup.ConsolidationGroup AND ConsolidationDimension = _CnsldtnGroup.ConsolidationDimension  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _ChartOfAccounts ON ConsolidationChartOfAccounts = _ChartOfAccounts.ConsolidationChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItem AS _FinStmntItm ON ConsolidationChartOfAccounts = _FinStmntItm.ConsolidationChartOfAccounts AND FinancialStatementItem = _FinStmntItm.FinancialStatementItem  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemCategory AS _SubItemCategory ON SubItemCategory = _SubItemCategory.SubItemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItem AS _SubItem ON SubItemCategory = _SubItem.SubItemCategory AND SubItem = _SubItem.SubItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDocumentType_2 AS _DocumentType ON ConsolidationDocumentType = _DocumentType.ConsolidationDocumentType  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnPostingLevel AS _PostingLevel ON PostingLevel = _PostingLevel.PostingLevel  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnApportionment AS _Apportionment ON ConsolidationApportionment = _Apportionment.ConsolidationApportionment  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _LocalCurrency ON LocalCurrency = _LocalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GroupCurrency ON GroupCurrency = _GroupCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;