I_CnsldtnTaskLogDetail

DDL: I_CNSLDTNTASKLOGDETAIL SQL: ICNSLDTNTLDTL Type: view BASIC Package: ODATA_CS_GENERICLOG
38 Fields 1 Data Sources 1 Associations

Interface for Task Log Detail

I_CnsldtnTaskLogDetail is a Basic CDS View that provides data about "Interface for Task Log Detail" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnTaskLogItem) and exposes 38 fields with key fields CnsldtnTaskLogUUID, CnsldtnTaskLogItemUUID. It has 1 association to related views. Part of development package ODATA_CS_GENERICLOG.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnTaskLogItem I_CnsldtnTaskLogItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CnsldtnMethodText _cnsldtnmethodT $projection.ConsolidationMethod = _cnsldtnmethodT.ConsolidationMethod and _cnsldtnmethodT.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICNSLDTNTLDTL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface for Task Log Detail view
VDM.viewType #BASIC view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnTaskLogUUID CnsldtnTaskLogUUID Consolidation Log GUID
KEY CnsldtnTaskLogItemUUID CnsldtnTaskLogItemUUID Consolidation Log Item Number GUID
CnsldtnTaskLogItemType CnsldtnTaskLogItemType Log Line Item Type
CnsldtnTaskLogItemTypeTxt CnsldtnTaskLogItemTypeTxt
CnsldtnTskLgNode CnsldtnTskLgNode Node ID
CnsldtnTskLgParNode CnsldtnTskLgParNode Parent Node
ConsolidationGroup ConsolidationGroup Cons. Group
ConsolidationUnit ConsolidationUnit Consolidation Unit
PartnerConsolidationUnit PartnerConsolidationUnit Partner Unit
ConsolidationCurrencySetIdn ConsolidationCurrencySetIdn Selection
ConsolidationDocumentNumber ConsolidationDocumentNumber Document Number
ConsolidationPostingItem ConsolidationPostingItem G/L Line Item
FinancialStatementItem FinancialStatementItem FS Item
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem FS Item
SubItemCategory SubItemCategory Subitem Category
SubItem SubItem Subitem Number
ConsolidationAcquisitionYear ConsolidationAcquisitionYear Acquis. Year
ConsolidationAcquisitionPeriod ConsolidationAcquisitionPeriod Period of Acq.
CurrencyConversionsDiffType CurrencyConversionsDiffType CT Indicator
ConsolidationApportionment ConsolidationApportionment Apportionment
ConsolidationPostgItemAutoFlag ConsolidationPostgItemAutoFlag Auto. ID
ConsolidationMethod ConsolidationMethod Method
CnsldtnPercent CnsldtnPercent Well Contribution Percentage
CnsldtnTriggeringAmtLoclCrcy CnsldtnTriggeringAmtLoclCrcy Local Currency
CnsldtnTriggeringAmtGrpCrcy CnsldtnTriggeringAmtGrpCrcy Ledger curr.
CnsldtnTriggeringAmtTransCrcy CnsldtnTriggeringAmtTransCrcy Transaction Currency
CnsldtnTriggeringQtyBaseUnit CnsldtnTriggeringQtyBaseUnit Unit of Measure
CnsldtnTriggeringQtyInBsUnt CnsldtnTriggeringQtyInBsUnt Quantity
CnsldtnJrnlEntryAmtLoclCrcy CnsldtnJrnlEntryAmtLoclCrcy Local Currency
CnsldtnJrnlEntryAmtGrpCrcy CnsldtnJrnlEntryAmtGrpCrcy Ledger curr.
CnsldtnJrnlEntryAmtTransCrcy CnsldtnJrnlEntryAmtTransCrcy Transaction Currency
CnsldtnJrnlEntryQtyBaseUnit CnsldtnJrnlEntryQtyBaseUnit Unit of Measure
CnsldtnJrnlEntryQtyInBsUnt CnsldtnJrnlEntryQtyInBsUnt Quantity
ConsolidationSelection ConsolidationSelection Selection ID
ConsolidationMethodText _cnsldtnmethodT ConsolidationMethodText
SequenceNumber SequenceNumber Sort sequence
CnsldtnRclassfctnRecdType CnsldtnRclassfctnRecdType Source/Target Indic.
CnsldtnGroupJrnlEntry CnsldtnGroupJrnlEntry Sort Order

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_CnsldtnTaskLogDetail.
-- 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: ICNSLDTNTLDTL

CREATE VIEW I_CnsldtnTaskLogDetail AS
SELECT
  CnsldtnTaskLogUUID,
  CnsldtnTaskLogItemUUID,
  CnsldtnTaskLogItemType,
  CnsldtnTaskLogItemTypeTxt,
  CnsldtnTskLgNode,
  CnsldtnTskLgParNode,
  ConsolidationGroup,
  ConsolidationUnit,
  PartnerConsolidationUnit,
  ConsolidationCurrencySetIdn,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  FinancialStatementItem,
  CnsldtnFinancialStatementItem,
  SubItemCategory,
  SubItem,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  CurrencyConversionsDiffType,
  ConsolidationApportionment,
  ConsolidationPostgItemAutoFlag,
  ConsolidationMethod,
  CnsldtnPercent,
  CnsldtnTriggeringAmtLoclCrcy,
  CnsldtnTriggeringAmtGrpCrcy,
  CnsldtnTriggeringAmtTransCrcy,
  CnsldtnTriggeringQtyBaseUnit,
  CnsldtnTriggeringQtyInBsUnt,
  CnsldtnJrnlEntryAmtLoclCrcy,
  CnsldtnJrnlEntryAmtGrpCrcy,
  CnsldtnJrnlEntryAmtTransCrcy,
  CnsldtnJrnlEntryQtyBaseUnit,
  CnsldtnJrnlEntryQtyInBsUnt,
  ConsolidationSelection,
  _cnsldtnmethodT.ConsolidationMethodText AS ConsolidationMethodText,
  SequenceNumber,
  CnsldtnRclassfctnRecdType,
  CnsldtnGroupJrnlEntry
FROM I_CnsldtnTaskLogItem
LEFT OUTER JOIN I_CnsldtnMethodText AS _cnsldtnmethodT ON ConsolidationMethod = _cnsldtnmethodT.ConsolidationMethod AND _cnsldtnmethodT.Language = $session.system_language  -- association [0..1]
;

Learn More