FGL_BCF_HIST_PRFYR

Previous year's RE accounts | view: BCFV_HIST_PRFYR | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: ACDOCA, SKA1, SKB1, T001, SKB1, T001, T030
Column Name Description
Column Name Description
💲 CO Object Currency (rco_ocur):
co_osl Amount in CO Object Currency
💲 Freely Defined Currency 3 (rbcur):
bsl Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (rccur):
csl Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (rdcur):
dsl Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (recur):
esl Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (rfcur):
fsl Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (rgcur):
gsl Amount in Freely Defined Currency 8
💲 Company Code Currency (rwcur):
hsl Amount in Company Code Currency
wsl Amount in Company Code Currency
💲 Global Currency (rkcur):
ksl Amount in Global Currency
pfsl Fixed Price Variance in Global Currency
psl Total Price Variance in Global Currency
💲 Freely Defined Currency 1 (rocur):
osl Amount in Freely Defined Currency 1
💲 Balance Transaction Currency (rtcur):
tsl Amount in Balance Transaction Currency
💲 Freely Defined Currency 2 (rvcur):
vsl Amount in Freely Defined Currency 2
Column Name Description
msl null
quant1 null
quant2 null
quant3 null
vmsl null
Column Name Description
prodper Production Month (Date to find period and year)
Column Name Description
rhoart Type of origin object (EC-PCA) Show values
rrcty Record Type Show values
Column Name Description Domain name
docln Six-Character Posting Item for Ledger DOCLN6
belnr Document Number of an Accounting Document BELNR
ryear General Ledger Fiscal Year GJAHR
drcrk null
poper Posting period POPER
rgrant_nbr Grant GM_GRANT_NBR
sgrant_nbr Partner Grant GM_GRANT_NBR
cbrunid Cutback Run ID (Joint Venture Accounting) TZNTSTMPL
jvactivity JVA Activity (Joint Venture Accounting)
pvname Partner Venture (Joint Venture Accounting) JV_NAME
pegrup Partner Equity Group (Joint Venture Accounting) JV_EGROUP
bukrs_sender Company Code in Sender System CHAR4
racct_sender General Ledger Account in Sender System CHAR10
pps_psp_pnr Partner Work Breakdown Structure Element (internal ID) PS_POSNR
swenr Business Entity Number REBDBENO
sgenr Number of Building REBDBUNO
sgrnr Number of Land REBDPRNO
acritmtype Type of the Item of the Accrual Subobject ACR_ITEM_TYPE
acrobj_id Identifier of the Accrual Object ACR_OBJ_ID
acrsobj_id Identifier of the Accrual Subobject ACR_SUBOBJ_ID
valobj_id Identifier of the Financial Valuation Object VAL_OBJ_ID
valsobj_id Identifier of the Financial Valuation Subobject VAL_SUBOBJ_ID
xbilk null
vtkon null
rmvct_mod null
movcat null
anbwa null
slalittype_mod null
glu1_account null
slalittype null
afabe null
anlgr null
anlgr2 null
anln1 null
anln2 null
bttype null
bwkey null
bwtar null
glaccount_type null
kalnr null
koart null
ktosl null
kunnr null
kzbws null
lifnr null
lokkt null
matnr null
mat_kdauf null
mat_kdpos null
mat_lifnr null
mat_pspnr null
qunit1 null
qunit2 null
qunit3 null
runit null
rvunit null
sobkz null
vorgn null
vrgng null
xobew null
ps_posid null
pps_posid null
ps_pspid null
kdauf null
kdpos null
pkdauf null
pkdpos null
Master Data Relations Join Conditions
Type of the Accrual Object
Order Number
  • Order Number
  • Client
  • FGL_BCF_HIST_PRFYR.AUFNR == AUFK.AUFNR
  • FGL_BCF_HIST_PRFYR.RCLNT == AUFK.MANDT
Logical system of source document FGL_BCF_HIST_PRFYR.AWSYS == TBDLS.LOGSYS
Reference procedure FGL_BCF_HIST_PRFYR.AWTYP == TTYP.AWTYP
Budget Account
  • Budget Account
  • Chart of Accounts
  • Client
  • FGL_BCF_HIST_PRFYR.BDGT_ACCOUNT == SKA1.SAKNR
  • FGL_BCF_HIST_PRFYR.KTOPL == SKA1.KTOPL
  • FGL_BCF_HIST_PRFYR.RCLNT == SKA1.MANDT
Budget Account Company Code
  • FGL_BCF_HIST_PRFYR.RCLNT == T001.MANDT
  • FGL_BCF_HIST_PRFYR.BDGT_ACCOUNT_COCODE == T001.BUKRS
Document Type
  • FGL_BCF_HIST_PRFYR.RCLNT == T003.MANDT
  • FGL_BCF_HIST_PRFYR.BLART == T003.BLART
Billing Indicator
  • FGL_BCF_HIST_PRFYR.RCLNT == T8JA.MANDT
  • FGL_BCF_HIST_PRFYR.BTYPE == T8JA.BILIND
Equity group
  • ?
  • Equity group
  • Client
  • Joint venture
  • FGL_BCF_HIST_PRFYR.[column in domain "BUKRS"] == T8JF.BUKRS
  • FGL_BCF_HIST_PRFYR.EGRUP == T8JF.EGRUP
  • FGL_BCF_HIST_PRFYR.RCLNT == T8JF.MANDT
  • FGL_BCF_HIST_PRFYR.VNAME == T8JF.VNAME
Partner profit center for elimination of internal business
  • ?
  • Partner profit center for elimination of internal business
  • Client
  • Controlling Area
  • FGL_BCF_HIST_PRFYR.[column in domain "DATBI"] == CEPC.DATBI
  • FGL_BCF_HIST_PRFYR.EPRCTR == CEPC.PRCTR
  • FGL_BCF_HIST_PRFYR.RCLNT == CEPC.MANDT
  • FGL_BCF_HIST_PRFYR.KOKRS == CEPC.KOKRS
Financial Management Area
  • Financial Management Area
  • Client
  • FGL_BCF_HIST_PRFYR.FIKRS == FM01.FIKRS
  • FGL_BCF_HIST_PRFYR.RCLNT == FM01.MANDT
Funds Center
  • ?
  • Financial Management Area
  • Client
  • Funds Center
  • FGL_BCF_HIST_PRFYR.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • FGL_BCF_HIST_PRFYR.FIKRS == FMFCTR.FIKRS
  • FGL_BCF_HIST_PRFYR.RCLNT == FMFCTR.MANDT
  • FGL_BCF_HIST_PRFYR.FISTL == FMFCTR.FICTR
Short Key for a House Bank
  • ?
  • Client
  • Short Key for a House Bank
  • FGL_BCF_HIST_PRFYR.[column in domain "BUKRS"] == T012.BUKRS
  • FGL_BCF_HIST_PRFYR.RCLNT == T012.MANDT
  • FGL_BCF_HIST_PRFYR.HBKID == T012.HBKID
ID for Account Details
  • ID for Account Details
  • ?
  • Client
  • Short Key for a House Bank
  • FGL_BCF_HIST_PRFYR.HKTID == T012K.HKTID
  • FGL_BCF_HIST_PRFYR.[column in domain "BUKRS"] == T012K.BUKRS
  • FGL_BCF_HIST_PRFYR.RCLNT == T012K.MANDT
  • FGL_BCF_HIST_PRFYR.HBKID == T012K.HBKID
Controlling Area
  • FGL_BCF_HIST_PRFYR.RCLNT == TKA01.MANDT
  • FGL_BCF_HIST_PRFYR.KOKRS == TKA01.KOKRS
Alternative Chart of Accounts
  • Alternative Chart of Accounts
  • Client
  • FGL_BCF_HIST_PRFYR.KTOP2 == T004.KTOPL
  • FGL_BCF_HIST_PRFYR.RCLNT == T004.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • FGL_BCF_HIST_PRFYR.KTOPL == T004.KTOPL
  • FGL_BCF_HIST_PRFYR.RCLNT == T004.MANDT
Funded Program
  • Financial Management Area
  • Client
  • Funded Program
  • FGL_BCF_HIST_PRFYR.FIKRS == FMMEASURE.FMAREA
  • FGL_BCF_HIST_PRFYR.RCLNT == FMMEASURE.CLIENT
  • FGL_BCF_HIST_PRFYR.MEASURE == FMMEASURE.MEASURE
Account Number
  • Account Number
  • Account Number
  • Company Code
  • Client
  • FGL_BCF_HIST_PRFYR.ORG_ACCOUNT == SKB1.SAKNR
  • FGL_BCF_HIST_PRFYR.RACCT == SKB1.SAKNR
  • FGL_BCF_HIST_PRFYR.RBUKRS == SKB1.BUKRS
  • FGL_BCF_HIST_PRFYR.RCLNT == SKB1.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FGL_BCF_HIST_PRFYR.PERIV == T009.PERIV
  • FGL_BCF_HIST_PRFYR.RCLNT == T009.MANDT
Partner Profit Center
  • ?
  • Client
  • Partner Profit Center
  • Controlling Area
  • FGL_BCF_HIST_PRFYR.[column in domain "DATBI"] == CEPC.DATBI
  • FGL_BCF_HIST_PRFYR.RCLNT == CEPC.MANDT
  • FGL_BCF_HIST_PRFYR.PPRCTR == CEPC.PRCTR
  • FGL_BCF_HIST_PRFYR.KOKRS == CEPC.KOKRS
Partner Project (internal ID)
  • Partner Project (internal ID)
  • Client
  • FGL_BCF_HIST_PRFYR.PPS_PRJ_PNR == PROJ.PSPNR
  • FGL_BCF_HIST_PRFYR.RCLNT == PROJ.MANDT
Profit Center
  • ?
  • Profit Center
  • Client
  • Controlling Area
  • FGL_BCF_HIST_PRFYR.[column in domain "DATBI"] == CEPC.DATBI
  • FGL_BCF_HIST_PRFYR.PRCTR == CEPC.PRCTR
  • FGL_BCF_HIST_PRFYR.RCLNT == CEPC.MANDT
  • FGL_BCF_HIST_PRFYR.KOKRS == CEPC.KOKRS
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • FGL_BCF_HIST_PRFYR.PSEGMENT == FAGL_SEGM.SEGMENT
  • FGL_BCF_HIST_PRFYR.RCLNT == FAGL_SEGM.MANDT
Account Number
  • Account Number
  • Account Number
  • Company Code
  • Client
  • FGL_BCF_HIST_PRFYR.ORG_ACCOUNT == SKB1.SAKNR
  • FGL_BCF_HIST_PRFYR.RACCT == SKB1.SAKNR
  • FGL_BCF_HIST_PRFYR.RBUKRS == SKB1.BUKRS
  • FGL_BCF_HIST_PRFYR.RCLNT == SKB1.MANDT
Company ID of Trading Partner
  • FGL_BCF_HIST_PRFYR.RCLNT == T880.MANDT
  • FGL_BCF_HIST_PRFYR.RASSC == T880.RCOMP
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • FGL_BCF_HIST_PRFYR.RBCUR == TCURC.WAERS
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
Budget Period
  • Financial Management Area
  • Fund
  • Client
  • Budget Period
  • FGL_BCF_HIST_PRFYR.FIKRS == FMFUNDBPD.FIKRS
  • FGL_BCF_HIST_PRFYR.RFUND == FMFUNDBPD.FINCODE
  • FGL_BCF_HIST_PRFYR.RCLNT == FMFUNDBPD.MANDT
  • FGL_BCF_HIST_PRFYR.RBUDGET_PD == FMFUNDBPD.BUDGET_PD
Company Code
  • Company Code
  • Client
  • FGL_BCF_HIST_PRFYR.RBUKRS == T001.BUKRS
  • FGL_BCF_HIST_PRFYR.RCLNT == T001.MANDT
Business Area
  • FGL_BCF_HIST_PRFYR.RCLNT == TGSB.MANDT
  • FGL_BCF_HIST_PRFYR.RBUSA == TGSB.GSBER
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • FGL_BCF_HIST_PRFYR.RCCUR == TCURC.WAERS
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
Client FGL_BCF_HIST_PRFYR.RCLNT == T000.MANDT
Cost Center
  • ?
  • Client
  • Cost Center
  • Controlling Area
  • FGL_BCF_HIST_PRFYR.[column in domain "DATBI"] == CSKS.DATBI
  • FGL_BCF_HIST_PRFYR.RCLNT == CSKS.MANDT
  • FGL_BCF_HIST_PRFYR.RCNTR == CSKS.KOSTL
  • FGL_BCF_HIST_PRFYR.KOKRS == CSKS.KOKRS
CO Object Currency
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.RCO_OCUR == TCURC.WAERS
Freely Defined Currency 5
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.RDCUR == TCURC.WAERS
Recovery Indicator
  • ?
  • Client
  • Recovery Indicator
  • FGL_BCF_HIST_PRFYR.[column in domain "BUKRS"] == T8JJ.BUKRS
  • FGL_BCF_HIST_PRFYR.RCLNT == T8JJ.MANDT
  • FGL_BCF_HIST_PRFYR.RECID == T8JJ.RECID
Freely Defined Currency 6
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.RECUR == TCURC.WAERS
Cash Origin Account
  • Chart of Accounts
  • Client
  • Cash Origin Account
  • FGL_BCF_HIST_PRFYR.KTOPL == SKA1.KTOPL
  • FGL_BCF_HIST_PRFYR.RCLNT == SKA1.MANDT
  • FGL_BCF_HIST_PRFYR.RE_ACCOUNT == SKA1.SAKNR
Cash Origin Company Code
  • FGL_BCF_HIST_PRFYR.RCLNT == T001.MANDT
  • FGL_BCF_HIST_PRFYR.RE_BUKRS == T001.BUKRS
Functional Area
  • FGL_BCF_HIST_PRFYR.RCLNT == TFKB.MANDT
  • FGL_BCF_HIST_PRFYR.RFAREA == TFKB.FKBER
Freely Defined Currency 7
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.RFCUR == TCURC.WAERS
Fund
  • Financial Management Area
  • Fund
  • Client
Freely Defined Currency 8
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.RGCUR == TCURC.WAERS
Company Code Currency
  • Company Code Currency
  • Company Code Currency
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.RHCUR == TCURC.WAERS
  • FGL_BCF_HIST_PRFYR.RWCUR == TCURC.WAERS
Global Currency
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.RKCUR == TCURC.WAERS
Ledger in General Ledger Accounting
Transaction type
  • Transaction type
  • Client
  • FGL_BCF_HIST_PRFYR.RMVCT == T856.TRTYP
  • FGL_BCF_HIST_PRFYR.RCLNT == T856.MANDT
Freely Defined Currency 1
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.ROCUR == TCURC.WAERS
Balance Transaction Currency
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.RTCUR == TCURC.WAERS
Freely Defined Currency 2
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.RVCUR == TCURC.WAERS
Company Code Currency
  • Company Code Currency
  • Company Code Currency
  • FGL_BCF_HIST_PRFYR.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_PRFYR.RHCUR == TCURC.WAERS
  • FGL_BCF_HIST_PRFYR.RWCUR == TCURC.WAERS
FM: Partner Budget Period
  • Financial Management Area
  • Client
  • FM: Partner Budget Period
  • Partner Fund
  • FGL_BCF_HIST_PRFYR.FIKRS == FMFUNDBPD.FIKRS
  • FGL_BCF_HIST_PRFYR.RCLNT == FMFUNDBPD.MANDT
  • FGL_BCF_HIST_PRFYR.SBUDGET_PD == FMFUNDBPD.BUDGET_PD
  • FGL_BCF_HIST_PRFYR.SFUND == FMFUNDBPD.FINCODE
Trading partner's business area
  • FGL_BCF_HIST_PRFYR.RCLNT == TGSB.MANDT
  • FGL_BCF_HIST_PRFYR.SBUSA == TGSB.GSBER
Sender cost center
  • ?
  • Client
  • Sender cost center
  • Controlling Area
  • FGL_BCF_HIST_PRFYR.[column in domain "DATBI"] == CSKS.DATBI
  • FGL_BCF_HIST_PRFYR.RCLNT == CSKS.MANDT
  • FGL_BCF_HIST_PRFYR.SCNTR == CSKS.KOSTL
  • FGL_BCF_HIST_PRFYR.KOKRS == CSKS.KOKRS
Segment for Segmental Reporting
  • FGL_BCF_HIST_PRFYR.RCLNT == FAGL_SEGM.MANDT
  • FGL_BCF_HIST_PRFYR.SEGMENT == FAGL_SEGM.SEGMENT
Partner Functional Area
  • FGL_BCF_HIST_PRFYR.RCLNT == TFKB.MANDT
  • FGL_BCF_HIST_PRFYR.SFAREA == TFKB.FKBER
Partner Fund
  • Financial Management Area
  • Client
  • Partner Fund
Type of the Financial Valuation Object
  • Type of the Financial Valuation Object
  • Client
Joint venture
  • ?
  • Client
  • Joint venture
  • FGL_BCF_HIST_PRFYR.[column in domain "BUKRS"] == T8JV.BUKRS
  • FGL_BCF_HIST_PRFYR.RCLNT == T8JV.MANDT
  • FGL_BCF_HIST_PRFYR.VNAME == T8JV.VNAME
Partner account number
  • FGL_BCF_HIST_PRFYR.RCLNT == KNA1.MANDT
  • FGL_BCF_HIST_PRFYR.VPTNR == KNA1.KUNNR
Plant
  • FGL_BCF_HIST_PRFYR.RCLNT == T001W.MANDT
  • FGL_BCF_HIST_PRFYR.WERKS == T001W.WERKS