P_GroupReportingLineItem

Consolidation - Line Item | view: PGRLINEITEM | Extraction: Not supported | Component: Embedded Analytics

Tables used: SCAL_TT_YEAR, ACDOCU, ACDOCA, ACDOCP, ACDOCU, RTC_PULL_REQ, ACDOCA, TF500, FINCS_FSITEM, TF110, TF160, TF162, FINCS_BUNIT_ATD, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, FINCS_FSITEM, T000, TF164, T881, TF165, TF200, TF110, T881, TF165, TF168, TF200, TF110, TF103A, TF001, TF040, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD, FINSC_LEDGER_REP, TFIN010, TFIN010, TFIN010, TFIN010, TF040

🔑 Keys
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (9)
Other (62)
🔗 Relations (26)

Column Name	Description

Column Name	Description
💲 Currency Key (rtcur):
tsl	Value in Transaction Currency
💲 Currency key of the local currency (rhcur):
hsl	Value in Local Currency
💲 Currency key of the ledger currency (rkcur):
ksl	Value in Group Currency

Column Name	Description
📏 Base Unit of Measure (runit):
msl	Quantity

Column Name	Description
budat	Posting Date in the Document
wsdat	Value Date for Currency Translation
cpudt	Day On Which Accounting Document Was Entered
cputm	Time of Entry

Column Name	Description
rrcty	Record Type	Show values
drcrk	Debit/Credit Indicator	Show values
docct	Document Category	Show values
plevl	Posting Level	Show values
rpflg	Apportionment	Show values
rtflg	Currency Translation	Show values
refdocct	Document Category	Show values
coiac	Consolidation of Investments Activity	Show values
CnsldtnJrnlEntryItemOrigin	Consolidation Journal Entry Item Origin	Show values

Column Name	Description	Domain name
gl_sirid	Record number of the line item record	OBJNR
rldnr	Ledger	RLDNR
rvers	Version	RVERS
ryear	Fiscal Year	GJAHR
poper	Posting period	POPER
docnr	Document Number of an Accounting Document	BELNR
docln	Six-Character Posting Item for Ledger	DOCLN6
rcomp	Company	RCOMP
rdimen	Dimension	FC_DIMEN
rbunit	Consolidation Unit	FC_BUNIT
ritclg	Consolidation Chart of Accounts	FC_ITCLG
ritem	Financial Statement Item	FC_ITEM
rbuptr	Partner Unit	FC_BUNIT
rcongr	Consolidation Group	FC_CONGR
robukrs	Original company code	BUKRS
sityp	Subitem Category	FC_SITYP
subit	Subitem	FC_SITEM
docty	Document Type	FC_DOCTY
yracq	Year of Acquisition	GJAHR
pracq	Period of Acquisition	NUM03
coicu	Investee Unit	FC_BUNIT
sgtxt	Item Text	TEXT50
autom	Indicator: Automatic posting lines	TEXT1
activ	Business Transaction	CHAR4
bvorg	Number of Cross-Company Code Posting Transaction	BVORG
refdocnr	Document Number of an Accounting Document	BELNR
refryear	Fiscal Year	GJAHR
refdocln	Six-figure number of line item	BUZEI6
refactiv	Business Transaction	CHAR4
usnam	User Name	XUBNAME
rvsdocnr	Reverse Document Number	BELNR
orndocnr	Number of Reversed Document	BELNR
coinr	Consolidation of Investments Activity Number	BELNR
revyear	Year of reversal document or reversed document	GJAHR
awtyp	Reference procedure	AWTYP
aworg	Reference Organizational Units	AWORG
logsys	Logical system	LOGSYS
timestamp	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
racct	Account Number	SAKNR
rcntr	Cost Center	KOSTL
prctr	Profit Center	PRCTR
rfarea	Functional Area	FKBER
rbusa	Business Area	GSBER
segment	Segment for Segmental Reporting	FB_SEGMENT
rmvct	Transaction type	RMVCT
ps_posid	Work Breakdown Structure Element (WBS Element)	PS_POSID
ps_pspid	Project definition	PS_PSPID
konzs	Group key	KONZS
zuonr	Assignment number	ZUONR
xblnr	Reference Document Number	XBLNR1
ps_psp_pnr	Work Breakdown Structure Element (WBS Element)	PS_POSNR
FinancialPlanningReqTransSqnc	Financial Planning Request Transaction Sequence Number	FIS_RSPM_TSN
FinancialPlanningDataPacket	Financial Planning Data Packet Number	NUM6
FinancialPlanningEntryItem	Financial Planning Entry Item	RSNUMRECORD
rldnr_fin	Ledger in General Ledger Accounting	FINS_LEDGER
adhocitem	Ad Hoc Item	FINCS_ADHOCITEM
adhocset	Ad Hoc Set	FINCS_ADHOCSET
adhocsetitem	Ad Hoc Set Item	FINCS_ADHOCSETITEM
rcode	Reason Code	ICA_RCODE
orig_ref	Origin Reference	FINCS_ORIG_REF
orig_type	Origin Type	FINCS_ORIG_TYPE
bunnr	Document Bundle Number	FINCS_BUNNR

Master Data Relations	Join Conditions
Order Number Client Order Number	`P_GROUPREPORTINGLINEITEM.MANDT == AUFK.MANDT` `P_GROUPREPORTINGLINEITEM.AUFNR == AUFK.AUFNR`
Industry key Industry key Client	`P_GROUPREPORTINGLINEITEM.BRSCH == T016.BRSCH` `P_GROUPREPORTINGLINEITEM.MANDT == T016.MANDT`
Sales District Sales District Client	`P_GROUPREPORTINGLINEITEM.BZIRK == T171.BZIRK` `P_GROUPREPORTINGLINEITEM.MANDT == T171.MANDT`
Billing Type Client Billing Type	`P_GROUPREPORTINGLINEITEM.MANDT == TVFK.MANDT` `P_GROUPREPORTINGLINEITEM.FKART == TVFK.FKART`
Customer Group Customer Group Client	`P_GROUPREPORTINGLINEITEM.KDGRP == T151.KDGRP` `P_GROUPREPORTINGLINEITEM.MANDT == T151.MANDT`
Controlling Area Client Controlling Area	`P_GROUPREPORTINGLINEITEM.MANDT == TKA01.MANDT` `P_GROUPREPORTINGLINEITEM.KOKRS == TKA01.KOKRS`
Chart of Accounts Client Chart of Accounts	`P_GROUPREPORTINGLINEITEM.MANDT == T004.MANDT` `P_GROUPREPORTINGLINEITEM.KTOPL == T004.KTOPL`
Customer Number Client Customer Number	`P_GROUPREPORTINGLINEITEM.MANDT == KNA1.MANDT` `P_GROUPREPORTINGLINEITEM.KUNNR == KNA1.KUNNR`
Bill-to Party Client Bill-to Party	`P_GROUPREPORTINGLINEITEM.MANDT == KNA1.MANDT` `P_GROUPREPORTINGLINEITEM.KUNRE == KNA1.KUNNR`
Ship-to Party Client Ship-to Party	`P_GROUPREPORTINGLINEITEM.MANDT == KNA1.MANDT` `P_GROUPREPORTINGLINEITEM.KUNWE == KNA1.KUNNR`
Country/Region Key Client Country/Region Key	`P_GROUPREPORTINGLINEITEM.MANDT == T005.MANDT` `P_GROUPREPORTINGLINEITEM.LAND1 == T005.LAND1`
Account Number of Supplier Client Account Number of Supplier	`P_GROUPREPORTINGLINEITEM.MANDT == LFA1.MANDT` `P_GROUPREPORTINGLINEITEM.LIFNR == LFA1.LIFNR`
Product Sold Group Product Sold Group Client	`P_GROUPREPORTINGLINEITEM.MATKL == T023.MATKL` `P_GROUPREPORTINGLINEITEM.MANDT == T023.MANDT`
Material Group Client Material Group	`P_GROUPREPORTINGLINEITEM.MANDT == T023.MANDT` `P_GROUPREPORTINGLINEITEM.MATKL_MM == T023.MATKL`
Material Number Client Material Number	`P_GROUPREPORTINGLINEITEM.MANDT == MARA.MANDT` `P_GROUPREPORTINGLINEITEM.MATNR == MARA.MATNR`
Product Sold Client Product Sold	`P_GROUPREPORTINGLINEITEM.MANDT == MARA.MANDT` `P_GROUPREPORTINGLINEITEM.MATNR_COPA == MARA.MATNR`
Partner Profit Center Client Partner Profit Center ? Controlling Area	`P_GROUPREPORTINGLINEITEM.MANDT == CEPC.MANDT` `P_GROUPREPORTINGLINEITEM.PPRCTR == CEPC.PRCTR` `P_GROUPREPORTINGLINEITEM.[column in domain "DATBI"] == CEPC.DATBI` `P_GROUPREPORTINGLINEITEM.KOKRS == CEPC.KOKRS`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`P_GROUPREPORTINGLINEITEM.PSEGMENT == FAGL_SEGM.SEGMENT` `P_GROUPREPORTINGLINEITEM.MANDT == FAGL_SEGM.MANDT`
Company ID of Trading Partner Client Company ID of Trading Partner	`P_GROUPREPORTINGLINEITEM.MANDT == T880.MANDT` `P_GROUPREPORTINGLINEITEM.RASSC == T880.RCOMP`
Trading partner's business area Client Trading partner's business area	`P_GROUPREPORTINGLINEITEM.MANDT == TGSB.MANDT` `P_GROUPREPORTINGLINEITEM.SBUSA == TGSB.GSBER`
Sender cost center Client ? Controlling Area Sender cost center	`P_GROUPREPORTINGLINEITEM.MANDT == CSKS.MANDT` `P_GROUPREPORTINGLINEITEM.[column in domain "DATBI"] == CSKS.DATBI` `P_GROUPREPORTINGLINEITEM.KOKRS == CSKS.KOKRS` `P_GROUPREPORTINGLINEITEM.SCNTR == CSKS.KOSTL`
Partner Functional Area Client Partner Functional Area	`P_GROUPREPORTINGLINEITEM.MANDT == TFKB.MANDT` `P_GROUPREPORTINGLINEITEM.SFAREA == TFKB.FKBER`
Division Client Division	`P_GROUPREPORTINGLINEITEM.MANDT == TSPA.MANDT` `P_GROUPREPORTINGLINEITEM.SPART == TSPA.SPART`
Sales Organization Client Sales Organization	`P_GROUPREPORTINGLINEITEM.MANDT == TVKO.MANDT` `P_GROUPREPORTINGLINEITEM.VKORG == TVKO.VKORG`
Distribution Channel Client Distribution Channel	`P_GROUPREPORTINGLINEITEM.MANDT == TVTW.MANDT` `P_GROUPREPORTINGLINEITEM.VTWEG == TVTW.VTWEG`
Plant Client Plant	`P_GROUPREPORTINGLINEITEM.MANDT == T001W.MANDT` `P_GROUPREPORTINGLINEITEM.WERKS == T001W.WERKS`