I_CnsldtnTaskLogItem

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_CnsldtnTaskLogItem.
-- 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: ICNSLDTNTLITEM

CREATE VIEW I_CnsldtnTaskLogItem AS
SELECT
  cnsldtnlognumber AS CnsldtnTaskLogUUID,
  cnsldtnlogitemnumber AS CnsldtnTaskLogItemUUID,
  cnsldtnlineitemtype AS CnsldtnTaskLogItemType,
  _DocIndi[1: Language = $session.system_language].cnsldtnlineitemtypet AS CnsldtnTaskLogItemTypeTxt,
  node AS CnsldtnTskLgNode,
  parentnode AS CnsldtnTskLgParNode,
  cnsldtngroup AS ConsolidationGroup,
  cnsldtnunit AS ConsolidationUnit,
  cnsldtnpartnerunit AS PartnerConsolidationUnit,
  cnsldtnsetidentification AS ConsolidationCurrencySetIdn,
  cnsldtndocumentnumber AS ConsolidationDocumentNumber,
  cnsldtnpostingitem AS ConsolidationPostingItem,
  cnsldtnfinstmntitm AS FinancialStatementItem,
  cnsldtnfinstmntitm AS CnsldtnFinancialStatementItem,
  cnsldtnfinstmntsubitmcat AS SubItemCategory,
  cnsldtnfinstmntsubitm AS SubItem,
  cnsldtnacquisitionyear AS ConsolidationAcquisitionYear,
  cnsldtnacquisitionperiod AS ConsolidationAcquisitionPeriod,
  cnsldtncrcycnvrsndifftype AS CurrencyConversionsDiffType,
  cnsldtnapportionment AS ConsolidationApportionment,
  cnsldtnisautoposting AS ConsolidationPostgItemAutoFlag,
  percentage AS CnsldtnPercent,
  cnsldtnlocalcurrency AS CnsldtnTriggeringAmtLoclCrcy,
  amountinlocalcrcy AS CnsldtnTriggeringAmtInLoclCrcy,
  cnsldtngroupcurrency AS CnsldtnTriggeringAmtGrpCrcy,
  amountingroupcrcy AS CnsldtnTriggeringAmtInGrpCrcy,
  transactioncurrency AS CnsldtnTriggeringAmtTransCrcy,
  amountintransactioncrcy AS CnsldtnTriggeringAmtInTC,
  baseunit AS CnsldtnTriggeringQtyBaseUnit,
  quantityinbaseunit AS CnsldtnTriggeringQtyInBsUnt,
  cnsldtnlocalcurrency AS CnsldtnJrnlEntryAmtLoclCrcy,
  amountinlocalcrcy AS CnsldtnJrnlEntryAmtInLoclCrcy,
  cnsldtngroupcurrency AS CnsldtnJrnlEntryAmtGrpCrcy,
  amountingroupcrcy AS CnsldtnJrnlEntryAmtInGrpCrcy,
  transactioncurrency AS CnsldtnJrnlEntryAmtTransCrcy,
  amountintransactioncrcy AS CnsldtnJrnlEntryAmtInTransCrcy,
  baseunit AS CnsldtnJrnlEntryQtyBaseUnit,
  quantityinbaseunit AS CnsldtnJrnlEntryQtyInBsUnt,
  seqno AS SequenceNumber,
  recordindicator AS CnsldtnRclassfctnRecdType,
  cnsldtnmethod AS ConsolidationMethod,
  sortorder AS CnsldtnGroupJrnlEntry,
  selection_id AS ConsolidationSelection,
  chartofaccounts AS ConsolidationChartOfAccounts,
  reexchangerateindicator AS CnsldtnRefExchangeRateType,
  reexchagerate AS CnsldtnRefExchangeRate,
  exchangerateindicator AS CnsldtnExchangeRateType,
  exchangerate AS CnsldtnExchangeRate,
  currencytranskey AS CnsldtnCrcyTranslationKey,
  cnsldtnfinstmntitmr AS CnsldtnCrcyTrnsltnDiffFSItem,
  cnsldtnfinstmntsubitmr AS CnsldtnCrcyTrnsltnDiffSubitem,
  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,
  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,
  customer AS CnsldtnCustomerText,
  supplier AS SupplierName,
  SoldProduct,
  SoldProductGroup,
  BillToParty,
  ShipToParty,
  diffamount AS CalculatedDiffAmount,
  reffamount AS CalculatedRefAmount
FROM fincs_log_item
LEFT OUTER JOIN P_CNSLDTN_DOCINDI AS _DocIndi ON CnsldtnTaskLogItemType = _DocIndi.cnsldtnlineitemtype  -- association [0..1]
;