A_CnsldtnTaskLogItemDataEntry

DDL: A_CNSLDTNTASKLOGITEMDATAENTRY Type: view_entity COMPOSITE
61 Fields 1 Data Sources

Consolidation Task Log Item Data Entry

A_CnsldtnTaskLogItemDataEntry is a Composite CDS View that provides data about "Consolidation Task Log Item Data Entry" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnTaskLogItemDataEntry) and exposes 61 fields with key fields CnsldtnTaskLogUUID, CnsldtnTaskLogItemUUID.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnTaskLogItemDataEntry I_CnsldtnTaskLogItemDataEntry projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Consolidation Task Log Item Data Entry view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name CnsldtnTaskLogItemDataEntry_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnTaskLogUUID CnsldtnTaskLogUUID
KEY CnsldtnTaskLogItemUUID CnsldtnTaskLogItemUUID
CnsldtnTaskLogItemType CnsldtnTaskLogItemType
AssignmentReference AssignmentReference Assignment Reference
PostingFiscalYear PostingFiscalYear Fiscal Year
ConsolidationDocumentNumber ConsolidationDocumentNumber Document Number
ConsolidationVersion ConsolidationVersion Version
CnsldtnJrnlEntryAmtLoclCrcy CnsldtnJrnlEntryAmtLoclCrcy
CnsldtnJrnlEntryAmtInLoclCrcy CnsldtnJrnlEntryAmtInLoclCrcy
CnsldtnJrnlEntryAmtGrpCrcy CnsldtnJrnlEntryAmtGrpCrcy
CnsldtnJrnlEntryAmtInGrpCrcy CnsldtnJrnlEntryAmtInGrpCrcy
CnsldtnJrnlEntryAmtTransCrcy CnsldtnJrnlEntryAmtTransCrcy
CnsldtnJrnlEntryAmtInTransCrcy CnsldtnJrnlEntryAmtInTransCrcy
CnsldtnJrnlEntryQtyBaseUnit CnsldtnJrnlEntryQtyBaseUnit
CnsldtnJrnlEntryQtyInBsUnt CnsldtnJrnlEntryQtyInBsUnt
CnsldtnTriggeringAmtLoclCrcy CnsldtnTriggeringAmtLoclCrcy
CnsldtnTriggeringAmtInLoclCrcy CnsldtnTriggeringAmtInLoclCrcy
CnsldtnTriggeringAmtGrpCrcy CnsldtnTriggeringAmtGrpCrcy
CnsldtnTriggeringAmtInGrpCrcy CnsldtnTriggeringAmtInGrpCrcy
CnsldtnTriggeringAmtTransCrcy CnsldtnTriggeringAmtTransCrcy
CnsldtnTriggeringAmtInTC CnsldtnTriggeringAmtInTC
CnsldtnTriggeringQtyBaseUnit CnsldtnTriggeringQtyBaseUnit
CnsldtnTriggeringQtyInBsUnt CnsldtnTriggeringQtyInBsUnt
ConsolidationUnit ConsolidationUnit Consolidation Unit
ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem
PartnerConsolidationUnit PartnerConsolidationUnit Partner Unit
ConsolidationGroup ConsolidationGroup Cons. Group
CompanyCode CompanyCode Receiver Company Code
SubItemCategory SubItemCategory Subitem Category
SubItem SubItem Subitem Number
PostingLevel PostingLevel Posting Level
ConsolidationApportionment ConsolidationApportionment Apportionment
CurrencyConversionsDiffType CurrencyConversionsDiffType CT Indicator
ConsolidationDocumentType ConsolidationDocumentType Document Type
InvesteeConsolidationUnit InvesteeConsolidationUnit Investee Unit
InvestmentActivityType InvestmentActivityType C/I Activity
InvestmentActivity InvestmentActivity Activity Number
PostingDate PostingDate Posting Date for GR
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
FinancialTransactionType FinancialTransactionType Transact. Type
CustomerGroup CustomerGroup Customer Group
CnsldtnTskLgItmRowNmbr CnsldtnTskLgItmRowNmbr
FiscalPeriod FiscalPeriod Tax period
FinancialServicesBranch FinancialServicesBranch Branch (FS)
GHGScope2CalculationMethod GHGScope2CalculationMethod
CashLedgerAccount CashLedgerAccount Cash Origin Account
CnsldtnCashLedgerChartOfAccts CnsldtnCashLedgerChartOfAccts
GHGScope2ContractualInstrument GHGScope2ContractualInstrument
CustomerSupplierCountry CustomerSupplierCountry Customer or Supplier Country/Region
FinancialDataSource FinancialDataSource Data Source
CnsldtnLogHeaderDateTime CnsldtnLogHeaderDateTime
Fund Fund Sender Fund
GHGCategory GHGCategory
GHGScope GHGScope
GrantID GrantID Sender Grant
SustainabilityModeOfTransport SustainabilityModeOfTransport
FinancialServicesProductGroup FinancialServicesProductGroup Product Group (FS)
SoldProduct SoldProduct Product Sold
SoldProductGroup SoldProductGroup Product Sold Group
WBSElementExternalID WBSElementExternalID WBS Element External ID

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 A_CnsldtnTaskLogItemDataEntry.
-- 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 A_CnsldtnTaskLogItemDataEntry AS
SELECT
  CnsldtnTaskLogUUID,
  CnsldtnTaskLogItemUUID,
  CnsldtnTaskLogItemType,
  AssignmentReference,
  PostingFiscalYear,
  ConsolidationDocumentNumber,
  ConsolidationVersion,
  CnsldtnJrnlEntryAmtLoclCrcy,
  CnsldtnJrnlEntryAmtInLoclCrcy,
  CnsldtnJrnlEntryAmtGrpCrcy,
  CnsldtnJrnlEntryAmtInGrpCrcy,
  CnsldtnJrnlEntryAmtTransCrcy,
  CnsldtnJrnlEntryAmtInTransCrcy,
  CnsldtnJrnlEntryQtyBaseUnit,
  CnsldtnJrnlEntryQtyInBsUnt,
  CnsldtnTriggeringAmtLoclCrcy,
  CnsldtnTriggeringAmtInLoclCrcy,
  CnsldtnTriggeringAmtGrpCrcy,
  CnsldtnTriggeringAmtInGrpCrcy,
  CnsldtnTriggeringAmtTransCrcy,
  CnsldtnTriggeringAmtInTC,
  CnsldtnTriggeringQtyBaseUnit,
  CnsldtnTriggeringQtyInBsUnt,
  ConsolidationUnit,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  PartnerConsolidationUnit,
  ConsolidationGroup,
  CompanyCode,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationDocumentType,
  InvesteeConsolidationUnit,
  InvestmentActivityType,
  InvestmentActivity,
  PostingDate,
  PartnerCostCenter,
  FinancialTransactionType,
  CustomerGroup,
  CnsldtnTskLgItmRowNmbr,
  FiscalPeriod,
  FinancialServicesBranch,
  GHGScope2CalculationMethod,
  CashLedgerAccount,
  CnsldtnCashLedgerChartOfAccts,
  GHGScope2ContractualInstrument,
  CustomerSupplierCountry,
  FinancialDataSource,
  CnsldtnLogHeaderDateTime,
  Fund,
  GHGCategory,
  GHGScope,
  GrantID,
  SustainabilityModeOfTransport,
  FinancialServicesProductGroup,
  SoldProduct,
  SoldProductGroup,
  WBSElementExternalID
FROM I_CnsldtnTaskLogItemDataEntry
;

Learn More