C_CnsldtnRelJrnlTskLg

DDL: C_CNSLDTNRELJRNLTSKLG SQL: CCNSLDRUJTSKLG Type: view CONSUMPTION
38 Fields 1 Data Sources

Release Universal Journal task log

C_CnsldtnRelJrnlTskLg is a Consumption CDS View that provides data about "Release Universal Journal task log" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnRelJrnlTskLg) and exposes 38 fields with key fields CnsldtnTaskLogUUID, CnsldtnTaskLogItemUUID, CnsldtnTskLgItmRowNmbr.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnRelJrnlTskLg item from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCNSLDRUJTSKLG 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 Release Universal Journal task log view
VDM.viewType #CONSUMPTION view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnTaskLogUUID CnsldtnTaskLogUUID
KEY CnsldtnTaskLogItemUUID CnsldtnTaskLogItemUUID
KEY CnsldtnTskLgItmRowNmbr CnsldtnTskLgItmRowNmbr
CnsldtnTskLgMsgNmbr CnsldtnTskLgMsgNmbr
CnsldtnTaskLogItemType CnsldtnTaskLogItemType
CnsldtnTaskLogItemTypeTxt CnsldtnTaskLogItemTypeTxt
ConsolidationLedger ConsolidationLedger Ledger
ConsolidationUnit ConsolidationUnit Consolidation Unit
ConsolidationUnitText ConsolidationUnitText
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem
FinancialStatementItemText FinancialStatementItemText
CnsldtnMsgTypeTxt CnsldtnMsgTypeTxt
SystemMessageText SystemMessageText Message Text
SystemMessageIdentification SystemMessageIdentification Message ID
SystemMessageType SystemMessageType Message type
SystemMessageNumber SystemMessageNumber Message Number
SystemMessageVariable1 SystemMessageVariable1 Variable 1
SystemMessageVariable2 SystemMessageVariable2 Variable 2
SystemMessageVariable3 SystemMessageVariable3 Variable 3
SystemMessageVariable4 SystemMessageVariable4 Variable 4
SystemMessageTypeSortOrder SystemMessageTypeSortOrder
CnsldtnTskLgMsgID CnsldtnTskLgMsgID
GLAccountText GLAccountText
PostingFiscalYear PostingFiscalYear Fiscal Year
ConsolidationVersion ConsolidationVersion Version
FiscalPeriod FiscalPeriod Tax period
PostingDate PostingDate Posting Date for GR
CnsldtnLogHeaderDateTime CnsldtnLogHeaderDateTime
ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
ConsolidationGroup ConsolidationGroup Cons. Group
CnsldtnJrnlEntryAmtLoclCrcy CnsldtnJrnlEntryAmtLoclCrcy
CnsldtnJrnlEntryAmtInLoclCrcy
CnsldtnJrnlEntryAmtGrpCrcy CnsldtnJrnlEntryAmtGrpCrcy
CnsldtnJrnlEntryAmtInGrpCrcy
CnsldtnJrnlEntryAmtTransCrcy CnsldtnJrnlEntryAmtTransCrcy
CnsldtnJrnlEntryAmtInTransCrcy
CnsldtnJrnlEntryQtyBaseUnit CnsldtnJrnlEntryQtyBaseUnit
CnsldtnJrnlEntryQtyInBsUnt

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 C_CnsldtnRelJrnlTskLg.
-- 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: CCNSLDRUJTSKLG

CREATE VIEW C_CnsldtnRelJrnlTskLg AS
SELECT
  CnsldtnTaskLogUUID,
  CnsldtnTaskLogItemUUID,
  CnsldtnTskLgItmRowNmbr,
  CnsldtnTskLgMsgNmbr,
  CnsldtnTaskLogItemType,
  CnsldtnTaskLogItemTypeTxt,
  ConsolidationLedger,
  ConsolidationUnit,
  ConsolidationUnitText,
  CnsldtnFinancialStatementItem,
  FinancialStatementItemText,
  CnsldtnMsgTypeTxt,
  SystemMessageText,
  SystemMessageIdentification,
  SystemMessageType,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  SystemMessageTypeSortOrder,
  CnsldtnTskLgMsgID,
  GLAccountText,
  PostingFiscalYear,
  ConsolidationVersion,
  FiscalPeriod,
  PostingDate,
  CnsldtnLogHeaderDateTime,
  ConsolidationChartOfAccounts,
  ConsolidationGroup,
  CnsldtnJrnlEntryAmtLoclCrcy,
  sum(CnsldtnJrnlEntryAmtInLoclCrcy) AS CnsldtnJrnlEntryAmtInLoclCrcy,
  CnsldtnJrnlEntryAmtGrpCrcy,
  sum(CnsldtnJrnlEntryAmtInGrpCrcy) AS CnsldtnJrnlEntryAmtInGrpCrcy,
  CnsldtnJrnlEntryAmtTransCrcy,
  sum(CnsldtnJrnlEntryAmtInTransCrcy) AS CnsldtnJrnlEntryAmtInTransCrcy,
  CnsldtnJrnlEntryQtyBaseUnit,
  sum(CnsldtnJrnlEntryQtyInBsUnt) AS CnsldtnJrnlEntryQtyInBsUnt
FROM I_CnsldtnRelJrnlTskLg AS item
;

Learn More