P_REALTIMERPTDFINDATANRL_01

Select from ACDOCA; Cons Unit; Period and Year (NRL) | view: PREALTFDNRL_01 | Extraction: Not supported | Component: S/4HANA Financial Consolidation, Core Processing
Tables used: ACDOCA, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInTransactionCurrency Amount in Balance Transaction Currency
AmountInLocalCurrency Amount in Company Code Currency
AmountInGroupCurrency Amount in Global Currency
osl Amount in Freely Defined Currency 1
vsl Amount in Freely Defined Currency 2
bsl Amount in Freely Defined Currency 3
csl Amount in Freely Defined Currency 4
dsl Amount in Freely Defined Currency 5
esl Amount in Freely Defined Currency 6
fsl Amount in Freely Defined Currency 7
gsl Amount in Freely Defined Currency 8
Column Name Description
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
Column Name Description
DocumentEntryIsInGroupCurrency Group Currency is Leading Currency Show values
CnsldtnUnitGroupCrcySource Source for Group Currency Key Figure Show values
CnsldtnUnitLocalCrcySource Source for Local Currency Key Figure Show values
Column Name Description Domain name
ConsolidationUnit Consolidation Unit FINCS_MD_BUNIT
ConsolidationVersion Version FC_RVERS
ConsolidationLedger Consolidation Ledger FC_RLDNR_CONS
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
AccountingDocument Journal Entry BELNR
ReferenceFiscalYear Fiscal Year GJAHR
AssignmentReference Assignment Reference ZUONR
WBSElementExternalID WBS Element FIS_WBS
Project Project FIS_PROJECT
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
CreationDateTime Time Stamp of Creation TZNTSTMPS
Master Data Relations Join Conditions
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TCURC.MANDT
  • P_REALTIMERPTDFINDATANRL_01.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T006.MANDT
  • P_REALTIMERPTDFINDATANRL_01.BASEUNIT == T006.MSEHI
Billing Type
  • Billing Type
  • Client
  • P_REALTIMERPTDFINDATANRL_01.BILLINGDOCUMENTTYPE == TVFK.FKART
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TVFK.MANDT
Bill-to Party
  • Client
  • Bill-to Party
  • P_REALTIMERPTDFINDATANRL_01.MANDT == KNA1.MANDT
  • P_REALTIMERPTDFINDATANRL_01.BILLTOPARTY == KNA1.KUNNR
Business Area
  • Client
  • Business Area
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TGSB.MANDT
  • P_REALTIMERPTDFINDATANRL_01.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • Chart of Accounts
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T004.MANDT
  • P_REALTIMERPTDFINDATANRL_01.CHARTOFACCOUNTS == T004.KTOPL
  • P_REALTIMERPTDFINDATANRL_01.REFERENCECHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_REALTIMERPTDFINDATANRL_01.COMPANYCODE == T001.BUKRS
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T001.MANDT
Dimension
  • Dimension
  • Client
  • P_REALTIMERPTDFINDATANRL_01.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TF150.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TKA01.MANDT
  • P_REALTIMERPTDFINDATANRL_01.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • P_REALTIMERPTDFINDATANRL_01.MANDT == CSKS.MANDT
  • P_REALTIMERPTDFINDATANRL_01.[column in domain "DATBI"] == CSKS.DATBI
  • P_REALTIMERPTDFINDATANRL_01.CONTROLLINGAREA == CSKS.KOKRS
  • P_REALTIMERPTDFINDATANRL_01.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • P_REALTIMERPTDFINDATANRL_01.CUSTOMER == KNA1.KUNNR
  • P_REALTIMERPTDFINDATANRL_01.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T151.MANDT
  • P_REALTIMERPTDFINDATANRL_01.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Client
  • Customer or Supplier Country/Region
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T005.MANDT
  • P_REALTIMERPTDFINDATANRL_01.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T016.MANDT
  • P_REALTIMERPTDFINDATANRL_01.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TVTW.MANDT
  • P_REALTIMERPTDFINDATANRL_01.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T856.MANDT
  • P_REALTIMERPTDFINDATANRL_01.FINANCIALTRANSACTIONTYPE == T856.TRTYP
FS Item Mapping Version
  • FS Item Mapping Version
  • Client
  • P_REALTIMERPTDFINDATANRL_01.FSITEMMAPPINGVERSION == TF23A.IMPVS
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TF23A.MANDT
Functional Area
  • Client
  • Functional Area
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TFKB.MANDT
  • P_REALTIMERPTDFINDATANRL_01.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_REALTIMERPTDFINDATANRL_01.COMPANYCODE == SKB1.BUKRS
  • P_REALTIMERPTDFINDATANRL_01.MANDT == SKB1.MANDT
  • P_REALTIMERPTDFINDATANRL_01.GLACCOUNT == SKB1.SAKNR
Group Currency of Consolidation Version
  • Group Currency of Consolidation Version
  • Client
  • P_REALTIMERPTDFINDATANRL_01.GROUPCURRENCY == TCURC.WAERS
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Material Number
  • Client
  • Material Number
  • P_REALTIMERPTDFINDATANRL_01.MANDT == MARA.MANDT
  • P_REALTIMERPTDFINDATANRL_01.MATERIAL == MARA.MATNR
Product Sold Group
  • Client
  • Product Sold Group
  • Product Sold Group
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T023.MANDT
  • P_REALTIMERPTDFINDATANRL_01.SOLDPRODUCTGROUP == T023.MATKL
  • P_REALTIMERPTDFINDATANRL_01.MATERIALGROUP == T023.MATKL
Order ID
  • Order ID
  • Client
  • P_REALTIMERPTDFINDATANRL_01.ORDERID == AUFK.AUFNR
  • P_REALTIMERPTDFINDATANRL_01.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TSPA.MANDT
  • P_REALTIMERPTDFINDATANRL_01.ORGANIZATIONDIVISION == TSPA.SPART
Partner Business Area
  • Client
  • Partner Business Area
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TGSB.MANDT
  • P_REALTIMERPTDFINDATANRL_01.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T880.MANDT
  • P_REALTIMERPTDFINDATANRL_01.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • Client
  • Partner Cost Center
  • ?
  • Controlling Area
  • P_REALTIMERPTDFINDATANRL_01.MANDT == CSKS.MANDT
  • P_REALTIMERPTDFINDATANRL_01.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_REALTIMERPTDFINDATANRL_01.[column in domain "DATBI"] == CSKS.DATBI
  • P_REALTIMERPTDFINDATANRL_01.CONTROLLINGAREA == CSKS.KOKRS
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TFKB.MANDT
  • P_REALTIMERPTDFINDATANRL_01.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Partner Profit Center
  • Client
  • ?
  • Controlling Area
  • P_REALTIMERPTDFINDATANRL_01.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_REALTIMERPTDFINDATANRL_01.MANDT == CEPC.MANDT
  • P_REALTIMERPTDFINDATANRL_01.[column in domain "DATBI"] == CEPC.DATBI
  • P_REALTIMERPTDFINDATANRL_01.CONTROLLINGAREA == CEPC.KOKRS
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_REALTIMERPTDFINDATANRL_01.MANDT == FAGL_SEGM.MANDT
  • P_REALTIMERPTDFINDATANRL_01.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T001W.MANDT
  • P_REALTIMERPTDFINDATANRL_01.PLANT == T001W.WERKS
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • P_REALTIMERPTDFINDATANRL_01.MANDT == CEPC.MANDT
  • P_REALTIMERPTDFINDATANRL_01.[column in domain "DATBI"] == CEPC.DATBI
  • P_REALTIMERPTDFINDATANRL_01.CONTROLLINGAREA == CEPC.KOKRS
  • P_REALTIMERPTDFINDATANRL_01.PROFITCENTER == CEPC.PRCTR
Chart of Accounts
  • Chart of Accounts
  • Chart of Accounts
  • Client
  • P_REALTIMERPTDFINDATANRL_01.CHARTOFACCOUNTS == T004.KTOPL
  • P_REALTIMERPTDFINDATANRL_01.REFERENCECHARTOFACCOUNTS == T004.KTOPL
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T004.MANDT
Sales District
  • Client
  • Sales District
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T171.MANDT
  • P_REALTIMERPTDFINDATANRL_01.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • P_REALTIMERPTDFINDATANRL_01.MANDT == TVKO.MANDT
  • P_REALTIMERPTDFINDATANRL_01.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_REALTIMERPTDFINDATANRL_01.MANDT == FAGL_SEGM.MANDT
  • P_REALTIMERPTDFINDATANRL_01.SEGMENT == FAGL_SEGM.SEGMENT
Ship-to Party
  • Client
  • Ship-to Party
  • P_REALTIMERPTDFINDATANRL_01.MANDT == KNA1.MANDT
  • P_REALTIMERPTDFINDATANRL_01.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Client
  • Product Sold
  • P_REALTIMERPTDFINDATANRL_01.MANDT == MARA.MANDT
  • P_REALTIMERPTDFINDATANRL_01.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Client
  • Product Sold Group
  • Product Sold Group
  • P_REALTIMERPTDFINDATANRL_01.MANDT == T023.MANDT
  • P_REALTIMERPTDFINDATANRL_01.SOLDPRODUCTGROUP == T023.MATKL
  • P_REALTIMERPTDFINDATANRL_01.MATERIALGROUP == T023.MATKL
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Supplier
  • Client
  • Supplier
  • P_REALTIMERPTDFINDATANRL_01.MANDT == LFA1.MANDT
  • P_REALTIMERPTDFINDATANRL_01.SUPPLIER == LFA1.LIFNR