C_CnsldtnIntegRptdFinData

DDL: C_CNSLDTNINTEGRPTDFINDATA SQL: CINTFINDATA Type: view CONSUMPTION Package: FIN_CS_RELEASE_UNIVERSAL_JRNL
61 Fields 1 Data Sources

FINCS Realtime Reported Data TAI

C_CnsldtnIntegRptdFinData is a Consumption CDS View that provides data about "FINCS Realtime Reported Data TAI" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnIntegRptdFinData) and exposes 61 fields with key field ConsolidationRecordNumber. Part of development package FIN_CS_RELEASE_UNIVERSAL_JRNL.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnIntegRptdFinData I_CnsldtnIntegRptdFinData from

Parameters (2)

NameTypeDefault
P_CreationDateTimeRgFr timestamp
P_CreationDateTimeRgTo timestamp

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CINTFINDATA view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
Analytics.query true view
EndUserText.label FINCS Realtime Reported Data TAI view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationRecordNumber ConsolidationRecordNumber
ReferenceDocumentNumber ReferenceDocumentNumber
SubItemCategory SubItemCategory Subitem Category
SubItem SubItem Subitem Number
PartnerConsolidationUnit PartnerConsolidationUnit Partner Unit
BaseUnit BaseUnit Unit of Measure
QuantityInBaseUnit QuantityInBaseUnit Quantity
FinancialTransactionType FinancialTransactionType Transact. Type
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
CostCenter CostCenter Cost Center
GLAccount GLAccount General Ledger
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
AmountInLocalCurrency AmountInLocalCurrency Local Crcy Amt
AmountInGroupCurrency AmountInGroupCurrency Amnt in GrpCrcy
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
FinancialStatementItem FinancialStatementItem FS Item
ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
LocalCurrency LocalCurrency Local Currency
ConsolidationDimension ConsolidationDimension Dimension
ConsolidationUnit ConsolidationUnit Consolidation Unit
ConsolidationVersion ConsolidationVersion Version
ConsolidationLedger ConsolidationLedger Ledger
GroupCurrency GroupCurrency Ledger curr.
FiscalPeriod FiscalPeriod Tax period
FiscalYear FiscalYear G/L Fiscal Year
CompanyCode CompanyCode Receiver Company Code
ChartOfAccounts ChartOfAccounts Node Class
AssignmentReference AssignmentReference Assignment Reference
ControllingArea ControllingArea Controlling Area
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerProfitCenter PartnerProfitCenter Profit Center
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
PartnerCompany PartnerCompany Trading Partner
PartnerSegment PartnerSegment Partner Segment
OrderID OrderID Order ID
Customer Customer Sold-to Party
Supplier Supplier Supplier
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
WBSElementExternalID WBSElementExternalID WBS Element External ID
Project Project WBS Element
BillingDocumentType BillingDocumentType Billing Type
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SoldProduct SoldProduct Product Sold
SoldProductGroup SoldProductGroup Product Sold Group
CustomerGroup CustomerGroup Customer Group
CustomerSupplierCountry CustomerSupplierCountry Customer or Supplier Country/Region
CustomerSupplierIndustry CustomerSupplierIndustry Industry
SalesDistrict SalesDistrict Sales District
BillToParty BillToParty Inv. Recipient
ShipToParty ShipToParty Ship-To Party (obsolete)
CustomerSupplierCorporateGroup CustomerSupplierCorporateGroup Group
WBSElementInternalID WBSElementInternalID WBS Internal ID
CreationDateTime CreationDateTime Timestamp

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_CnsldtnIntegRptdFinData.
-- 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: CINTFINDATA
-- Parameters: P_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW C_CnsldtnIntegRptdFinData AS
SELECT
  ConsolidationRecordNumber,
  ReferenceDocumentNumber,
  SubItemCategory,
  SubItem,
  PartnerConsolidationUnit,
  BaseUnit,
  QuantityInBaseUnit,
  FinancialTransactionType,
  FunctionalArea,
  BusinessArea,
  CostCenter,
  GLAccount,
  ProfitCenter,
  Segment,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  AmountInTransactionCurrency,
  TransactionCurrency,
  FinancialStatementItem,
  ConsolidationChartOfAccounts,
  LocalCurrency,
  ConsolidationDimension,
  ConsolidationUnit,
  ConsolidationVersion,
  ConsolidationLedger,
  GroupCurrency,
  FiscalPeriod,
  FiscalYear,
  CompanyCode,
  ChartOfAccounts,
  AssignmentReference,
  ControllingArea,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  MaterialGroup,
  Plant,
  WBSElementExternalID,
  Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  WBSElementInternalID,
  CreationDateTime
FROM I_CnsldtnIntegRptdFinData
;

Learn More