FGL_BCF_HIST_PREP

Previous year's PL accounts | view: BCFV_HIST_PREP | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting

Tables used: ACDOCA, T856, SKA1, SKB1, T001, SKB1, T001, T030

🔑 Keys
💰 Amounts (15)
∑ Quantities
📅 Dates (1)
☰ Categorical (2)
Other (26)
🔗 Relations (58)

Column Name	Description

Column Name	Description
tsl	Amount in Company Code Currency
💲 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 (rhcur):
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
💲 Freely Defined Currency 2 (rvcur):
vsl	Amount in Freely Defined Currency 2

Column Name	Description

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
belnr	Document Number of an Accounting Document	BELNR
docln	Six-Character Posting Item for Ledger	DOCLN6
ryear	null
xbilk	null
drcrk	null
poper	null
racct	G/L Account Number	SAKNR
glu1_account	G/L Account Number	SAKNR
vtkon	G/L Account Number	SAKNR
rmvct	Carryforward Transaction Type	RMVCT
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
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

Master Data Relations	Join Conditions
Type of the Accrual Object Type of the Accrual Object Client	`FGL_BCF_HIST_PREP.ACROBJTYPE == TACR_OBJ_TYPE.ACROBJ_TYPE` `FGL_BCF_HIST_PREP.RCLNT == TACR_OBJ_TYPE.MANDT`
Order Number Order Number Client	`FGL_BCF_HIST_PREP.AUFNR == AUFK.AUFNR` `FGL_BCF_HIST_PREP.RCLNT == AUFK.MANDT`
Logical system of source document	`FGL_BCF_HIST_PREP.AWSYS == TBDLS.LOGSYS`
Reference procedure	`FGL_BCF_HIST_PREP.AWTYP == TTYP.AWTYP`
Budget Account Budget Account Chart of Accounts Client	`FGL_BCF_HIST_PREP.BDGT_ACCOUNT == SKA1.SAKNR` `FGL_BCF_HIST_PREP.KTOPL == SKA1.KTOPL` `FGL_BCF_HIST_PREP.RCLNT == SKA1.MANDT`
Budget Account Company Code Budget Account Company Code Client	`FGL_BCF_HIST_PREP.BDGT_ACCOUNT_COCODE == T001.BUKRS` `FGL_BCF_HIST_PREP.RCLNT == T001.MANDT`
Document Type Document Type Client	`FGL_BCF_HIST_PREP.BLART == T003.BLART` `FGL_BCF_HIST_PREP.RCLNT == T003.MANDT`
Billing Indicator Billing Indicator Client	`FGL_BCF_HIST_PREP.BTYPE == T8JA.BILIND` `FGL_BCF_HIST_PREP.RCLNT == T8JA.MANDT`
Equity group Equity group Joint venture ? Client	`FGL_BCF_HIST_PREP.EGRUP == T8JF.EGRUP` `FGL_BCF_HIST_PREP.VNAME == T8JF.VNAME` `FGL_BCF_HIST_PREP.[column in domain "BUKRS"] == T8JF.BUKRS` `FGL_BCF_HIST_PREP.RCLNT == T8JF.MANDT`
Partner profit center for elimination of internal business Partner profit center for elimination of internal business Controlling Area ? Client	`FGL_BCF_HIST_PREP.EPRCTR == CEPC.PRCTR` `FGL_BCF_HIST_PREP.KOKRS == CEPC.KOKRS` `FGL_BCF_HIST_PREP.[column in domain "DATBI"] == CEPC.DATBI` `FGL_BCF_HIST_PREP.RCLNT == CEPC.MANDT`
Financial Management Area Financial Management Area Client	`FGL_BCF_HIST_PREP.FIKRS == FM01.FIKRS` `FGL_BCF_HIST_PREP.RCLNT == FM01.MANDT`
Funds Center Funds Center Financial Management Area ? Client	`FGL_BCF_HIST_PREP.FISTL == FMFCTR.FICTR` `FGL_BCF_HIST_PREP.FIKRS == FMFCTR.FIKRS` `FGL_BCF_HIST_PREP.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS` `FGL_BCF_HIST_PREP.RCLNT == FMFCTR.MANDT`
Short Key for a House Bank Short Key for a House Bank ? Client	`FGL_BCF_HIST_PREP.HBKID == T012.HBKID` `FGL_BCF_HIST_PREP.[column in domain "BUKRS"] == T012.BUKRS` `FGL_BCF_HIST_PREP.RCLNT == T012.MANDT`
ID for Account Details Short Key for a House Bank ID for Account Details ? Client	`FGL_BCF_HIST_PREP.HBKID == T012K.HBKID` `FGL_BCF_HIST_PREP.HKTID == T012K.HKTID` `FGL_BCF_HIST_PREP.[column in domain "BUKRS"] == T012K.BUKRS` `FGL_BCF_HIST_PREP.RCLNT == T012K.MANDT`
Controlling Area Controlling Area Client	`FGL_BCF_HIST_PREP.KOKRS == TKA01.KOKRS` `FGL_BCF_HIST_PREP.RCLNT == TKA01.MANDT`
Alternative Chart of Accounts Alternative Chart of Accounts Client	`FGL_BCF_HIST_PREP.KTOP2 == T004.KTOPL` `FGL_BCF_HIST_PREP.RCLNT == T004.MANDT`
Chart of Accounts Chart of Accounts Client	`FGL_BCF_HIST_PREP.KTOPL == T004.KTOPL` `FGL_BCF_HIST_PREP.RCLNT == T004.MANDT`
Funded Program Funded Program Financial Management Area Client	`FGL_BCF_HIST_PREP.MEASURE == FMMEASURE.MEASURE` `FGL_BCF_HIST_PREP.FIKRS == FMMEASURE.FMAREA` `FGL_BCF_HIST_PREP.RCLNT == FMMEASURE.CLIENT`
Account Number Account Number Company Code Client	`FGL_BCF_HIST_PREP.ORG_ACCOUNT == SKB1.SAKNR` `FGL_BCF_HIST_PREP.RBUKRS == SKB1.BUKRS` `FGL_BCF_HIST_PREP.RCLNT == SKB1.MANDT`
Fiscal Year Variant Fiscal Year Variant Client	`FGL_BCF_HIST_PREP.PERIV == T009.PERIV` `FGL_BCF_HIST_PREP.RCLNT == T009.MANDT`
Partner Profit Center Partner Profit Center Controlling Area ? Client	`FGL_BCF_HIST_PREP.PPRCTR == CEPC.PRCTR` `FGL_BCF_HIST_PREP.KOKRS == CEPC.KOKRS` `FGL_BCF_HIST_PREP.[column in domain "DATBI"] == CEPC.DATBI` `FGL_BCF_HIST_PREP.RCLNT == CEPC.MANDT`
Profit Center Controlling Area Profit Center ? Client	`FGL_BCF_HIST_PREP.KOKRS == CEPC.KOKRS` `FGL_BCF_HIST_PREP.PRCTR == CEPC.PRCTR` `FGL_BCF_HIST_PREP.[column in domain "DATBI"] == CEPC.DATBI` `FGL_BCF_HIST_PREP.RCLNT == CEPC.MANDT`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`FGL_BCF_HIST_PREP.PSEGMENT == FAGL_SEGM.SEGMENT` `FGL_BCF_HIST_PREP.RCLNT == FAGL_SEGM.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`FGL_BCF_HIST_PREP.RASSC == T880.RCOMP` `FGL_BCF_HIST_PREP.RCLNT == T880.MANDT`
Freely Defined Currency 3 Freely Defined Currency 3 Client	`FGL_BCF_HIST_PREP.RBCUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT`
Budget Period Financial Management Area Budget Period Client Fund	`FGL_BCF_HIST_PREP.FIKRS == FMFUNDBPD.FIKRS` `FGL_BCF_HIST_PREP.RBUDGET_PD == FMFUNDBPD.BUDGET_PD` `FGL_BCF_HIST_PREP.RCLNT == FMFUNDBPD.MANDT` `FGL_BCF_HIST_PREP.RFUND == FMFUNDBPD.FINCODE`
Company Code Company Code Client	`FGL_BCF_HIST_PREP.RBUKRS == T001.BUKRS` `FGL_BCF_HIST_PREP.RCLNT == T001.MANDT`
Business Area Business Area Client	`FGL_BCF_HIST_PREP.RBUSA == TGSB.GSBER` `FGL_BCF_HIST_PREP.RCLNT == TGSB.MANDT`
Freely Defined Currency 4 Freely Defined Currency 4 Client	`FGL_BCF_HIST_PREP.RCCUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT`
Client	`FGL_BCF_HIST_PREP.RCLNT == T000.MANDT`
Cost Center Cost Center Controlling Area ? Client	`FGL_BCF_HIST_PREP.RCNTR == CSKS.KOSTL` `FGL_BCF_HIST_PREP.KOKRS == CSKS.KOKRS` `FGL_BCF_HIST_PREP.[column in domain "DATBI"] == CSKS.DATBI` `FGL_BCF_HIST_PREP.RCLNT == CSKS.MANDT`
CO Object Currency CO Object Currency Client	`FGL_BCF_HIST_PREP.RCO_OCUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT`
Freely Defined Currency 5 Freely Defined Currency 5 Client	`FGL_BCF_HIST_PREP.RDCUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT`
Recovery Indicator Recovery Indicator ? Client	`FGL_BCF_HIST_PREP.RECID == T8JJ.RECID` `FGL_BCF_HIST_PREP.[column in domain "BUKRS"] == T8JJ.BUKRS` `FGL_BCF_HIST_PREP.RCLNT == T8JJ.MANDT`
Freely Defined Currency 6 Freely Defined Currency 6 Client	`FGL_BCF_HIST_PREP.RECUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT`
Cash Origin Account Cash Origin Account Chart of Accounts Client	`FGL_BCF_HIST_PREP.RE_ACCOUNT == SKA1.SAKNR` `FGL_BCF_HIST_PREP.KTOPL == SKA1.KTOPL` `FGL_BCF_HIST_PREP.RCLNT == SKA1.MANDT`
Cash Origin Company Code Cash Origin Company Code Client	`FGL_BCF_HIST_PREP.RE_BUKRS == T001.BUKRS` `FGL_BCF_HIST_PREP.RCLNT == T001.MANDT`
Functional Area Functional Area Client	`FGL_BCF_HIST_PREP.RFAREA == TFKB.FKBER` `FGL_BCF_HIST_PREP.RCLNT == TFKB.MANDT`
Freely Defined Currency 7 Freely Defined Currency 7 Client	`FGL_BCF_HIST_PREP.RFCUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT`
Fund Financial Management Area Client Fund	`FGL_BCF_HIST_PREP.FIKRS == FMFINCODE.FIKRS` `FGL_BCF_HIST_PREP.RCLNT == FMFINCODE.MANDT` `FGL_BCF_HIST_PREP.RFUND == FMFINCODE.FINCODE`
Freely Defined Currency 8	`FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT` `FGL_BCF_HIST_PREP.RGCUR == TCURC.WAERS`
Company Code Currency Company Code Currency Company Code Currency Company Code Currency	`FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT` `FGL_BCF_HIST_PREP.T001_WAERS == TCURC.WAERS` `FGL_BCF_HIST_PREP.RHCUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RWCUR == TCURC.WAERS`
Global Currency	`FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT` `FGL_BCF_HIST_PREP.RKCUR == TCURC.WAERS`
Ledger in General Ledger Accounting Ledger in General Ledger Accounting Client	`FGL_BCF_HIST_PREP.RLDNR == FINSC_LEDGER.RLDNR` `FGL_BCF_HIST_PREP.RCLNT == FINSC_LEDGER.MANDT`
Freely Defined Currency 1 Freely Defined Currency 1 Client	`FGL_BCF_HIST_PREP.ROCUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT`
Freely Defined Currency 2 Freely Defined Currency 2 Client	`FGL_BCF_HIST_PREP.RVCUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT`
Company Code Currency Company Code Currency Company Code Currency Company Code Currency	`FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT` `FGL_BCF_HIST_PREP.T001_WAERS == TCURC.WAERS` `FGL_BCF_HIST_PREP.RHCUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RWCUR == TCURC.WAERS`
FM: Partner Budget Period Partner Fund Financial Management Area FM: Partner Budget Period Client	`FGL_BCF_HIST_PREP.SFUND == FMFUNDBPD.FINCODE` `FGL_BCF_HIST_PREP.FIKRS == FMFUNDBPD.FIKRS` `FGL_BCF_HIST_PREP.SBUDGET_PD == FMFUNDBPD.BUDGET_PD` `FGL_BCF_HIST_PREP.RCLNT == FMFUNDBPD.MANDT`
Trading partner's business area	`FGL_BCF_HIST_PREP.RCLNT == TGSB.MANDT` `FGL_BCF_HIST_PREP.SBUSA == TGSB.GSBER`
Sender cost center Controlling Area ? Client Sender cost center	`FGL_BCF_HIST_PREP.KOKRS == CSKS.KOKRS` `FGL_BCF_HIST_PREP.[column in domain "DATBI"] == CSKS.DATBI` `FGL_BCF_HIST_PREP.RCLNT == CSKS.MANDT` `FGL_BCF_HIST_PREP.SCNTR == CSKS.KOSTL`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`FGL_BCF_HIST_PREP.SEGMENT == FAGL_SEGM.SEGMENT` `FGL_BCF_HIST_PREP.RCLNT == FAGL_SEGM.MANDT`
Partner Functional Area Partner Functional Area Client	`FGL_BCF_HIST_PREP.SFAREA == TFKB.FKBER` `FGL_BCF_HIST_PREP.RCLNT == TFKB.MANDT`
Partner Fund Partner Fund Financial Management Area Client	`FGL_BCF_HIST_PREP.SFUND == FMFINCODE.FINCODE` `FGL_BCF_HIST_PREP.FIKRS == FMFINCODE.FIKRS` `FGL_BCF_HIST_PREP.RCLNT == FMFINCODE.MANDT`
Company Code Currency Company Code Currency Company Code Currency Company Code Currency	`FGL_BCF_HIST_PREP.RCLNT == TCURC.MANDT` `FGL_BCF_HIST_PREP.T001_WAERS == TCURC.WAERS` `FGL_BCF_HIST_PREP.RHCUR == TCURC.WAERS` `FGL_BCF_HIST_PREP.RWCUR == TCURC.WAERS`
Type of the Financial Valuation Object Type of the Financial Valuation Object Client	`FGL_BCF_HIST_PREP.VALOBJTYPE == FINSC_VAL_TYPE.VALOBJ_TYPE` `FGL_BCF_HIST_PREP.RCLNT == FINSC_VAL_TYPE.MANDT`
Joint venture Joint venture ? Client	`FGL_BCF_HIST_PREP.VNAME == T8JV.VNAME` `FGL_BCF_HIST_PREP.[column in domain "BUKRS"] == T8JV.BUKRS` `FGL_BCF_HIST_PREP.RCLNT == T8JV.MANDT`
Partner account number Partner account number Client	`FGL_BCF_HIST_PREP.VPTNR == KNA1.KUNNR` `FGL_BCF_HIST_PREP.RCLNT == KNA1.MANDT`
Plant Plant Client	`FGL_BCF_HIST_PREP.WERKS == T001W.WERKS` `FGL_BCF_HIST_PREP.RCLNT == T001W.MANDT`