A_CnsldtnTransactionData

Consolidation - Transactional Data for Group Reporting | view: ACSTRANSDATA | Extraction: Not supported | Component: Embedded Analytics
Tables used: ACDOCU, FINCS_REF_VERS_R, PRTE, ACDOCU, FINCS_ADHITM, FINCS_ADHITMT, FINCS_ADHSET, FINCS_ADHSETITM, FINCS_ADHSETT, FINCS_GRPSTR, TF200, PROJ, PRPS, HRRP_NODE, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Local Currency (LocalCurrency):
AmountInLocalCurrency Amount in Local Currency
💲 Group Currency (GroupCurrency):
AmountInGroupCurrency Amount in Group Currency
Column Name Description
📏 Base Unit (BaseUnit):
QuantityInBaseUnit Quantity
CnsldtnQuantityInBaseUnit Quantity
Column Name Description
PostingDate Posting Date in the Document
CurrencyTranslationDate Currency Translation Date
CreationDate Created On
CreationTime Created At
Column Name Description
GLRecordType G/L Record Type Show values
PeriodMode Period Mode Show values
DebitCreditCode Debit/Credit Code Show values
PostingLevel Posting Level Show values
ConsolidationApportionment Consolidation Apportionment Show values
CurrencyConversionsDiffType Currency Translation Indicator Show values
RefConsolidationDocumentType Reference Document Category Show values
InvestmentActivityType Consolidation of Investments Activity Show values
Column Name Description Domain name
ConsolidationLedger Consolidation Ledger RLDNR
ConsolidationDimension Dimension FC_DIMEN
FiscalYear Fiscal Year GJAHR
ConsolidationDocumentNumber Consolidation Document Number BELNR
ConsolidationPostingItem Consolidation Document Line Item DOCLN6
ConsolidationVersion Consolidation Version FC_RVERS
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_C
FiscalYearVariant Fiscal Year Variant PERIV
ConsolidationDocumentType Document Type FC_DOCTY
Company Company RCOMP
ConsolidationUnit Consolidation Unit FC_BUNIT
ConsolidationUnitForElim Consolidation Unit for Elimination FINCS_ELIMINATION_MEMBER
ConsolidationChartOfAccounts Consolidation Chart of Accounts FC_ITCLG
FinancialStatementItem Financial Statement Item FC_ITEM
PartnerConsolidationUnit Partner Unit FC_BUNIT
ConsolidationGroup Consolidation Group FC_CONGR
CompanyCode Company Code BUKRS
SubItemCategory Subitem Category FC_SITYP
SubItem Subitem FC_SITEM
ConsolidationAcquisitionYear Year of Acquisition GJAHR
ConsolidationAcquisitionPeriod Period of Acquisition NUM03
InvesteeConsolidationUnit Investee Unit FC_BUNIT
DocumentItemText Document Text TEXT50
ConsolidationPostgItemAutoFlag Automatic Posting Indicator TEXT1
BusinessTransactionType Business Transaction Type CHAR4
RefConsolidationDocumentNumber Reference Consolidation Document Number BELNR
ReferenceFiscalYear Reference Fiscal Year GJAHR
RefConsolidationPostingItem Reference Consolidation Posting Item BUZEI6
RefBusinessTransactionType Reference Business Transaction Type CHAR4
UserID User ID XUBNAME
ReverseDocument Reversal Document BELNR
ReversedDocument Reversed Document BELNR
InvestmentActivity Consolidation of Investments Activity Number BELNR
ConsolidationDocReversalYear Year of Reversal Document GJAHR
ReferenceDocumentType Reference Transaction AWTYP
ReferenceDocumentContext Reference Organizational Unit AWORG
LogicalSystem Logical system LOGSYS
ChartOfAccounts G/L Chart of Accounts KTOPL
GLAccount G/L Account SAKNR
AssignmentReference Assignment Reference Number ZUONR
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
ConsolidationPrftCtrForElim Profit Center for Elimination FINCS_ELIMINATION_MEMBER
FunctionalArea Functional Area FKBER
BusinessArea Business Area GSBER
ControllingArea Controlling Area CACCD
Segment Segment FB_SEGMENT
ConsolidationSegmentForElim Segment for Elimination FINCS_ELIMINATION_MEMBER
PartnerCostCenter Partner Cost Center KOSTL
PartnerProfitCenter Partner Profit Center PRCTR
PartnerFunctionalArea Partner Functional Area FKBER
PartnerBusinessArea Partner Business Area GSBER
PartnerCompany Partner Company RCOMP
PartnerSegment Partner Segment FB_SEGMENT
OrderID Order ID AUFNR
Customer Customer Number KUNNR
Supplier Supplier LIFNR
Material Material MATNR
Plant Plant WERKS
FinancialTransactionType Financial Transaction Type RMVCT
WBSElementInternalID WBS Element PS_S4_PSPNR
WBSDescription WBS Element Internal ID Description TEXT40
WBSElementExternalID WBS Element External ID PS_POSID
Project Project Definition PS_PSPID
BillingDocumentType Billing Document Type
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
MaterialGroup Material Group MATKL
SoldProduct Product Sold MATNR
SoldProductGroup Product Sold Group MATKL
CustomerGroup Customer Group KDGRP
CustomerSupplierCountry Customer/Supplier Country/Region LAND1
CustomerSupplierIndustry Customer/Supplier Industry BRSCH
SalesDistrict Sales District BZIRK
BillToParty Bill-To Party KUNNR
ShipToParty Ship-To Party KUNNR
CustomerSupplierCorporateGroup Customer/Supplier Corporate Group KONZS
CnsldtnAdhocItem Ad Hoc Item FINCS_ADHOCITEM
CnsldtnAdhocItemText Ad Hoc Item Description FINCS_ADHOCITEMTEXT
CnsldtnAdhocSet Ad Hoc Set FINCS_ADHOCSET
CnsldtnAdhocSetText Ad Hoc Set Description FINCS_ADHOCSETTEXT
CnsldtnAdhocSetItem Ad Hoc Set Item FINCS_ADHOCSETITEM
CnsldtnAdhocSetItemText Ad Hoc Set Item Description FINCS_ADHOCSETITEMTEXT