P_CNSLDTNINTEGRPTDFINDATA_TN

(Reported FinData for Real-time Units (TN) (TAI) | view: PINTFINDATA_TN | Extraction: Not supported | Component: S/4HANA Financial Consolidation, Core Processing
Tables used: ACDOCA, TF500, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSITEM, TF103A, FINSC_LEDGER_REP
Column Name Description
gl_sirid Record number of the line item record
Column Name Description
💲 Currency Key (rtcur):
tsl Value in Transaction Currency
💲 Currency key of the local currency (rhcur):
hsl Value in Local Currency
ksl Value in Group Currency
Column Name Description
msl Quantity
Column Name Description
budat Posting Date in the Document
cpudt Day On Which Accounting Document Was Entered
cputm Time of Entry
wsdat Value Date for Currency Translation
_dataaging Data Filter Value for Data Aging
Column Name Description
rrcty Record Type Show values
rtflg Currency Translation Show values
drcrk Debit/Credit Indicator Show values
coiac Consolidation of Investments Activity Show values
plevl Posting Level Show values
refdocct Document Category Show values
docct Document Category Show values
rpflg Apportionment Show values
Column Name Description Domain name
rldnr Consolidation Ledger FC_RLDNR_CONS
rvers Version FC_RVERS
ryear Fiscal Year GJAHR
poper Fiscal Period POPER
rbuptr Partner Unit FC_BUNIT
zuonr Assignment Reference ZUONR
ps_posid WBS Element External ID FIS_WBSEXT_NO_CONV
ps_pspid Project FIS_PROJECT_NO_CONV
konzs Customer Supplier Corporate Group KONZS
ps_psp_pnr WBS Element Internal ID FIS_WBSINT_NO_CONV
timestamp Time Stamp of Creation TZNTSTMPS
docty Document Type FC_DOCTY
docnr Document Number of an Accounting Document BELNR
docln Six-Character Posting Item for Ledger DOCLN6
refryear Fiscal Year GJAHR
fiscyearper Fiscal Year Period FIS_JAHRPER_CONV
updhp Highest update period POPER
refdocnr Document Number of an Accounting Document BELNR
aworg Reference Organizational Units AWORG
refdocln Six-figure number of line item BUZEI6
coicu Investee Unit FC_BUNIT
rvsdocnr Reverse Document Number BELNR
revyear Year of reversal document or reversed document GJAHR
yracq Year of Acquisition GJAHR
sgtxt Item Text TEXT50
autom Indicator: Automatic posting lines TEXT1
rcongr Consolidation Group FC_CONGR
bvorg Number of Cross-Company Code Posting Transaction BVORG
orndocnr Number of Reversed Document BELNR
coinr Consolidation of Investments Activity Number BELNR
refactiv Business Transaction CHAR4
activ Business Transaction CHAR4
rcomp Company RCOMP
pracq Period of Acquisition NUM03
xblnr Reference Document Number XBLNR1
uppcu Investor Unit FC_BUNIT
Master Data Relations Join Conditions
Order ID
  • Order ID
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.AUFNR == AUFK.AUFNR
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == AUFK.MANDT
Reference procedure P_CNSLDTNINTEGRPTDFINDATA_TN.AWTYP == TTYP.AWTYP
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.BRSCH == T016.BRSCH
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T016.MANDT
Sales District
  • Sales District
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.BZIRK == T171.BZIRK
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T171.MANDT
Billing Type
  • Billing Type
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.FKART == TVFK.FKART
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TVFK.MANDT
Customer Group
  • Customer Group
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.KDGRP == T151.KDGRP
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T151.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.KOKRS == TKA01.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TKA01.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.KTOPL == T004.KTOPL
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.KUNNR == KNA1.KUNNR
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == KNA1.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.KUNRE == KNA1.KUNNR
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == KNA1.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.KUNWE == KNA1.KUNNR
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == KNA1.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.LAND1 == T005.LAND1
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T005.MANDT
Supplier
  • Supplier
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.LIFNR == LFA1.LIFNR
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == LFA1.MANDT
Logical system P_CNSLDTNINTEGRPTDFINDATA_TN.LOGSYS == TBDLS.LOGSYS
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MATKL == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MATKL_MM == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T023.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MATKL == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MATKL_MM == T023.MATKL
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T023.MANDT
Material Number
  • Material Number
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MATNR == MARA.MATNR
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == MARA.MANDT
Product Sold
  • Product Sold
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MATNR_COPA == MARA.MATNR
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == MARA.MANDT
Partner Profit Center
  • Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.PPRCTR == CEPC.PRCTR
  • P_CNSLDTNINTEGRPTDFINDATA_TN.[column in domain "DATBI"] == CEPC.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_TN.KOKRS == CEPC.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == CEPC.MANDT
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.[column in domain "DATBI"] == CEPC.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_TN.KOKRS == CEPC.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_TN.PRCTR == CEPC.PRCTR
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.PSEGMENT == FAGL_SEGM.SEGMENT
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == FAGL_SEGM.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RACCT == SKB1.SAKNR
  • P_CNSLDTNINTEGRPTDFINDATA_TN.ROBUKRS == SKB1.BUKRS
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == SKB1.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RASSC == T880.RCOMP
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T880.MANDT
Consolidation Unit
  • Consolidation Unit
  • ?
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RBUNIT == FINCS_BUNIT.BUNIT
  • P_CNSLDTNINTEGRPTDFINDATA_TN.[column in domain "FC_DIMEN"] == FINCS_BUNIT.DIMEN
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == FINCS_BUNIT.MANDT
Business Area
  • Business Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RBUSA == TGSB.GSBER
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TGSB.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • P_CNSLDTNINTEGRPTDFINDATA_TN.[column in domain "DATBI"] == CSKS.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_TN.KOKRS == CSKS.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == CSKS.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RCNTR == CSKS.KOSTL
Dimension
  • Dimension
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RDIMEN == TF150.DIMEN
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TF150.MANDT
Functional Area
  • Functional Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RFAREA == TFKB.FKBER
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TFKB.MANDT
Currency key of the local currency
  • Currency key of the local currency
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RHCUR == TCURC.WAERS
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TCURC.MANDT
Consolidation Chart of Accounts
  • Client
  • Consolidation Chart of Accounts
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TF120.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RITCLG == TF120.ITCLG
Consolidation Financial Statement Item
  • Client
  • Consolidation Chart of Accounts
  • Consolidation Financial Statement Item
Currency key of the ledger currency
  • Client
  • Currency key of the ledger currency
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TCURC.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RKCUR == TCURC.WAERS
Source Ledger
  • Source Ledger
  • Client
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RMVCT == T856.TRTYP
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T856.MANDT
Company Code
  • Company Code
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.ROBUKRS == T001.BUKRS
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.RTCUR == TCURC.WAERS
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TCURC.MANDT
Partner Business Area
  • Client
  • Partner Business Area
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TGSB.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_TN.SBUSA == TGSB.GSBER
Partner Cost Center
  • Partner Cost Center
  • ?
  • Controlling Area
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.SCNTR == CSKS.KOSTL
  • P_CNSLDTNINTEGRPTDFINDATA_TN.[column in domain "DATBI"] == CSKS.DATBI
  • P_CNSLDTNINTEGRPTDFINDATA_TN.KOKRS == CSKS.KOKRS
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == CSKS.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == FAGL_SEGM.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_TN.SEGMENT == FAGL_SEGM.SEGMENT
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TFKB.MANDT
  • P_CNSLDTNINTEGRPTDFINDATA_TN.SFAREA == TFKB.FKBER
Subitem Category
  • Subitem Category
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.SITYP == TF110.SITYP
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TF110.MANDT
Division
  • Division
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.SPART == TSPA.SPART
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TSPA.MANDT
Subitem
  • Subitem
  • Subitem Category
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.SUBIT == TF115.SITEM
  • P_CNSLDTNINTEGRPTDFINDATA_TN.SITYP == TF115.SITYP
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TF115.MANDT
Sales Organization
  • Sales Organization
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.VKORG == TVKO.VKORG
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TVKO.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.VTWEG == TVTW.VTWEG
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == TVTW.MANDT
Plant
  • Plant
  • Client
  • P_CNSLDTNINTEGRPTDFINDATA_TN.WERKS == T001W.WERKS
  • P_CNSLDTNINTEGRPTDFINDATA_TN.MANDT == T001W.MANDT