I_CnsldtnTaskLogItem01

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_CnsldtnTaskLogItem01.
-- 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: ICNSLDTNTLITEM01

CREATE VIEW I_CnsldtnTaskLogItem01 AS
SELECT
  cnsldtnlognumber AS CnsldtnTaskLogUUID,
  cnsldtnlogitemnumber AS CnsldtnTaskLogItemUUID,
  raw_rowid AS CnsldtnTskLgItmRowNmbr,
  cnsldtnlineitemtype AS CnsldtnTaskLogItemType,
  _DocIndi[1: Language = $session.system_language].cnsldtnlineitemtypet AS CnsldtnTaskLogItemTypeTxt,
  entryid AS CnsldtnGroupJrnlEntry,
  node AS CnsldtnTskLgNode,
  parentnode AS CnsldtnTskLgParNode,
  cnsldtnledger AS ConsolidationLedger,
  fiscalyear AS PostingFiscalYear,
  cnsldtndocumentnumber AS ConsolidationDocumentNumber,
  cnsldtnpostingitem AS ConsolidationPostingItem,
  cnsldtndimension AS ConsolidationDimension,
  GLRecordType,
  cnsldtnversion AS ConsolidationVersion,
  fiscalperiod AS PostingFiscalPeriod,
  company AS OriginalCompanyCode,
  Company,
  cnsldtnunit AS ConsolidationUnit,
  cnsldtnunitmdmtext AS ConsolidationUnitMdmText,
  cnsldtnchartofaccounts AS ConsolidationChartOfAccounts,
  cnsldtnfinstmntitm AS FinancialStatementItem,
  cnsldtnfinstmntitm AS CnsldtnFinancialStatementItem,
  cnsldtnpartnerunit AS PartnerConsolidationUnit,
  cnsldtngroup AS ConsolidationGroup,
  CompanyCode,
  cnsldtnfinstmntsubitmcat AS SubItemCategory,
  cnsldtnfinstmntsubitm AS SubItem,
  cnsldtnpostinglevel AS PostingLevel,
  cnsldtnapportionment AS ConsolidationApportionment,
  cnsldtncrcycnvrsndifftype AS CurrencyConversionsDiffType,
  cnsldtndocumenttype AS ConsolidationDocumentType,
  cnsldtnacquisitionyear AS ConsolidationAcquisitionYear,
  cnsldtnacquisitionperiod AS ConsolidationAcquisitionPeriod,
  cnsldtninvesteeunit AS InvesteeConsolidationUnit,
  chartofaccounts AS ChartOfAccountsText,
  cnsldtnlocalcurrency AS CnsldtnTriggeringAmtLoclCrcy,
  amountincnsldtnlocalcrcy AS CnsldtnTriggeringAmtInLoclCrcy,
  cnsldtngroupcurrency AS CnsldtnTriggeringAmtGrpCrcy,
  amountincnsldtngroupcrcy AS CnsldtnTriggeringAmtInGrpCrcy,
  transactioncurrency AS CnsldtnTriggeringAmtTransCrcy,
  amountintransactioncurrency AS CnsldtnTriggeringAmtInTC,
  baseunit AS CnsldtnTriggeringQtyBaseUnit,
  quantityinbaseunit AS CnsldtnTriggeringQtyInBsUnt,
  cnsldtnlocalcurrency AS CnsldtnJrnlEntryAmtLoclCrcy,
  amountincnsldtnlocalcrcy AS CnsldtnJrnlEntryAmtInLoclCrcy,
  cnsldtngroupcurrency AS CnsldtnJrnlEntryAmtGrpCrcy,
  amountincnsldtngroupcrcy AS CnsldtnJrnlEntryAmtInGrpCrcy,
  transactioncurrency AS CnsldtnJrnlEntryAmtTransCrcy,
  amountintransactioncurrency AS CnsldtnJrnlEntryAmtInTransCrcy,
  baseunit AS CnsldtnJrnlEntryQtyBaseUnit,
  quantityinbaseunit AS CnsldtnJrnlEntryQtyInBsUnt,
  cnsldtnitemtext AS ConsolidationReportingItemText,
  cnsldtnisautoposting AS ConsolidationPostgItemAutoFlag,
  cnsldtnbusinesstransactiontype AS BusinessTransactionType,
  PostingDate,
  cnsldtncrcytranslationdate AS CurrencyTranslationDate,
  cnsldtnrefacctgdocument AS RefAccountingDocument,
  cnsldtnreffiscalyear AS ReferenceFiscalYear,
  cnsldtnrefacctgdocitem AS RefAccountingDocumentItem,
  cnsldtnrefacctgdocitem AS RefConsolidationPostingItem,
  cnsldtnrefdocumenttype AS ReferenceAcctgDocumentType,
  cnsldtnrefbustranstype AS RefBusinessTransactionType,
  cnsldtnreversedocument AS RvsdReferenceDocumentType,
  cnsldtnreverseddocument AS ReversedDocument,
  cnsldtninvmtactivitytype AS InvestmentActivityType,
  cnsldtninvmtactivity AS InvestmentActivity,
  cnsldtndocreversalyear AS ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  glaccount AS GLAccountText,
  AssignmentReference,
  costcenter AS CostCenterText,
  profitcenter AS ProfitCenterText,
  functionalarea AS FunctionalAreaText,
  businessarea AS BusinessAreaText,
  controllingarea AS ControllingAreaText,
  segment AS CnsldtnSegmentText,
  PartnerCostCenter,
  partnerprofitcenter AS PartnerProfitCenterText,
  partnerfunctionalarea AS PartnerFunctionalAreaText,
  partnerbusinessarea AS PartnerBusinessAreaText,
  partnercompany AS PartnerCompanyText,
  partnersegment AS PartnerSegmentText,
  OrderID,
  material AS CnsldtnMaterialText,
  materialgroup AS MaterialGroupName,
  plant AS CnsldtnPlantText,
  FinancialTransactionType,
  WBSElementInternalID,
  cast(wbselement as abap.char(24) ) AS WBSElement,
  partnerwbselement AS PartnerWBSElementDescription,
  project AS CnsldtnProjectText,
  billingdocumenttype AS BillingDocumentTypeText,
  salesorganization AS SalesOrganizationText,
  distributionchannel AS DistributionChannelText,
  organizationdivision AS OrganizationDivisionText,
  SoldMaterial,
  productgroup AS ProductGroupText,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  salesdistrict AS SalesDistrictText,
  CustomerSupplierCorporateGroup,
  latest_indi AS CnsldtnTaskLogItemIsLatest,
  logdate AS CnsldtnLogHeaderDateTime,
  customer AS CnsldtnCustomerText,
  supplier AS SupplierName,
  SoldProduct,
  SoldProductGroup,
  BillToParty,
  ShipToParty,
  CnsldtnGroupJrnlEntryBundle
FROM fincs_log_item01
LEFT OUTER JOIN P_CNSLDTN_DOCINDI AS _DocIndi ON CnsldtnTaskLogItemType = _DocIndi.cnsldtnlineitemtype  -- association [0..1]
;