A_CnsldtnTskLgItmLineValdtn

DDL: A_CNSLDTNTSKLGITMLINEVALDTN Type: view_entity COMPOSITE Package: FIN_CS_TASK_LOG_API
51 Fields 1 Data Sources 3 OData Services

Cnsldtn Task Log Item Line Validation

A_CnsldtnTskLgItmLineValdtn is a Composite CDS View that provides data about "Cnsldtn Task Log Item Line Validation" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnTskLgItmLineValdtn) and exposes 51 fields with key fields CnsldtnTaskLogUUID, CnsldtnTaskLogItemUUID. It is exposed through 3 OData services (API_CONSOLIDATIONTASKLOG, ASQL_F7093, ASQL_F7454). Part of development package FIN_CS_TASK_LOG_API.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnTskLgItmLineValdtn I_CnsldtnTskLgItmLineValdtn projection

Annotations (10)

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

OData Services (3)

ServiceBindingVersionContractRelease
API_CONSOLIDATIONTASKLOG API_CONSOLIDATIONTASKLOG V4 C2 C1
ASQL_F7093 ASQL_F7093 C2 NOT_RELEASED
ASQL_F7454 ASQL_F7454 C2 NOT_RELEASED

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnTaskLogUUID CnsldtnTaskLogUUID
KEY CnsldtnTaskLogItemUUID CnsldtnTaskLogItemUUID
CnsldtnTaskLogItemType CnsldtnTaskLogItemType
AssignmentReference AssignmentReference Assignment Reference
ConsolidationLedger ConsolidationLedger Ledger
PostingFiscalYear PostingFiscalYear Fiscal Year
ConsolidationVersion ConsolidationVersion Version
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
InvesteeConsolidationUnit InvesteeConsolidationUnit Investee Unit
InvestmentActivityType InvestmentActivityType C/I Activity
InvestmentActivity InvestmentActivity Activity Number
PostingDate PostingDate Posting Date for GR
CnsldtnJrnlEntryAmtLoclCrcy CnsldtnJrnlEntryAmtLoclCrcy
CnsldtnJrnlEntryAmtInLoclCrcy CnsldtnJrnlEntryAmtInLoclCrcy
CnsldtnJrnlEntryAmtGrpCrcy CnsldtnJrnlEntryAmtGrpCrcy
CnsldtnJrnlEntryAmtInGrpCrcy CnsldtnJrnlEntryAmtInGrpCrcy
CnsldtnJrnlEntryAmtTransCrcy CnsldtnJrnlEntryAmtTransCrcy
CnsldtnJrnlEntryAmtInTransCrcy CnsldtnJrnlEntryAmtInTransCrcy
CnsldtnJrnlEntryQtyBaseUnit CnsldtnJrnlEntryQtyBaseUnit
CnsldtnJrnlEntryQtyInBsUnt CnsldtnJrnlEntryQtyInBsUnt
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
FinancialTransactionType FinancialTransactionType Transact. Type
CustomerGroup CustomerGroup Customer Group
CustomerSupplierCountry CustomerSupplierCountry Customer or Supplier Country/Region
CnsldtnTskLgItmRowNmbr CnsldtnTskLgItmRowNmbr
FiscalPeriod FiscalPeriod Tax period
FinancialServicesBranch FinancialServicesBranch Branch (FS)
GHGScope2CalculationMethod GHGScope2CalculationMethod
CashLedgerAccount CashLedgerAccount Cash Origin Account
CnsldtnCashLedgerChartOfAccts CnsldtnCashLedgerChartOfAccts
GHGScope2ContractualInstrument GHGScope2ContractualInstrument
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

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

Learn More