FGL_BCF_HIST_ALLB

All BS accounts and RE accounts | view: BCFV_HIST_ALLB | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: ACDOCA, ACDOCA, SKA1, SKB1, T001, FINSTS_FAA_BCF, T856, SKB1, T001, T030
Column Name Description
docln Six-Character Posting Item for Ledger
belnr Document Number of an Accounting Document
ryear null
rbukrs FK Company Code
rldnr FK Ledger in General Ledger Accounting
Column Name Description
hsl_ending null
hsl_changeover null
tsl_ending null
tsl_changeover null
ksl null
msl null
osl null
💲 Company Code Currency (rwcur):
hsl_opening Amount in Company Code Currency
wsl Amount in Company Code Currency
💲 Balance Transaction Currency (rtcur):
tsl_opening Amount in Balance Transaction 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
💲 Global Currency (rkcur):
pfsl Fixed Price Variance in Global Currency
psl Total Price Variance in Global Currency
💲 Freely Defined Currency 2 (rvcur):
vsl Amount in Freely Defined Currency 2
Column Name Description
📏 Additional Unit of Measure 1 (qunit1):
quant1 Additional Quantity 1
📏 Additional Unit of Measure 2 (qunit2):
quant2 Additional Quantity 2
📏 Additional Unit of Measure 3 (qunit3):
quant3 Additional Quantity 3
📏 Unit of Measure for Valuation Quantity (rvunit):
vmsl Valuation quantity
Column Name Description
prodper Production Month (Date to find period and year)
Column Name Description
glaccount_type Type of a General Ledger Account Show values
koart Account type Show values
kzbws Valuation of Special Stock Show values
rhoart Type of origin object (EC-PCA) Show values
rrcty Record Type Show values
xobew Vendor Stock Valuation Indicator Show values
Column Name Description Domain name
timestamp null
drcrk null
poper null
anbwa Asset Transaction Type BWASL
kalnr Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR
ktosl Transaction Key CHAR3
mat_kdauf Sales Document Number of Valuated Special Inventory VBELN
mat_kdpos Sales Document Item Number of Valuated Special Inventory POSNR
mat_lifnr Supplier of Valuated Special Inventory LIFNR
mat_pspnr WBS Element (internal) of Valuated Special Inventory PS_POSNR
movcat Transaction Type Category FAA_MOVCAT
rmvct Carryforward Transaction Type RMVCT
slalittype Subledger-Specific Line Item Type SLALITTYPE
sobkz Special Stock Indicator SOBKZ
vorgn Transaction Type for General Ledger VORGN
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
ps_posid Work Breakdown Structure Element (WBS Element) PS_POSID
pps_posid Partner Work Breakdown Structure Element PS_POSID
ps_pspid Project definition PS_PSPID
kdpos Item number in Sales Order NUM06
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
Master Data Relations Join Conditions
Type of the Accrual Object
  • Type of the Accrual Object
  • Client
Subnumber of Group Asset
  • Group Asset
  • Subnumber of Group Asset
  • ?
  • Client
  • FGL_BCF_HIST_ALLB.ANLGR == ANLA.ANLN1
  • FGL_BCF_HIST_ALLB.ANLGR2 == ANLA.ANLN2
  • FGL_BCF_HIST_ALLB.[column in domain "BUKRS"] == ANLA.BUKRS
  • FGL_BCF_HIST_ALLB.RCLNT == ANLA.MANDT
Asset Subnumber
  • Asset Subnumber
  • Main Asset Number
  • ?
  • Client
  • FGL_BCF_HIST_ALLB.ANLN2 == ANLA.ANLN2
  • FGL_BCF_HIST_ALLB.ANLN1 == ANLA.ANLN1
  • FGL_BCF_HIST_ALLB.[column in domain "BUKRS"] == ANLA.BUKRS
  • FGL_BCF_HIST_ALLB.RCLNT == ANLA.MANDT
Order Number
  • Order Number
  • Client
  • FGL_BCF_HIST_ALLB.AUFNR == AUFK.AUFNR
  • FGL_BCF_HIST_ALLB.RCLNT == AUFK.MANDT
Logical system of source document FGL_BCF_HIST_ALLB.AWSYS == TBDLS.LOGSYS
Reference procedure FGL_BCF_HIST_ALLB.AWTYP == TTYP.AWTYP
Budget Account
  • Budget Account
  • Chart of Accounts
  • Client
  • FGL_BCF_HIST_ALLB.BDGT_ACCOUNT == SKA1.SAKNR
  • FGL_BCF_HIST_ALLB.KTOPL == SKA1.KTOPL
  • FGL_BCF_HIST_ALLB.RCLNT == SKA1.MANDT
Budget Account Company Code
  • Budget Account Company Code
  • Client
  • FGL_BCF_HIST_ALLB.BDGT_ACCOUNT_COCODE == T001.BUKRS
  • FGL_BCF_HIST_ALLB.RCLNT == T001.MANDT
Document Type
  • Document Type
  • Client
  • FGL_BCF_HIST_ALLB.BLART == T003.BLART
  • FGL_BCF_HIST_ALLB.RCLNT == T003.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
Billing Indicator
  • Billing Indicator
  • Client
  • FGL_BCF_HIST_ALLB.BTYPE == T8JA.BILIND
  • FGL_BCF_HIST_ALLB.RCLNT == T8JA.MANDT
Valuation area
  • Valuation area
  • Client
  • FGL_BCF_HIST_ALLB.BWKEY == T001K.BWKEY
  • FGL_BCF_HIST_ALLB.RCLNT == T001K.MANDT
Valuation Type
  • Valuation Type
  • Client
  • FGL_BCF_HIST_ALLB.BWTAR == T149D.BWTAR
  • FGL_BCF_HIST_ALLB.RCLNT == T149D.MANDT
Equity group
  • Equity group
  • ?
  • Joint venture
  • Client
  • FGL_BCF_HIST_ALLB.EGRUP == T8JF.EGRUP
  • FGL_BCF_HIST_ALLB.[column in domain "BUKRS"] == T8JF.BUKRS
  • FGL_BCF_HIST_ALLB.VNAME == T8JF.VNAME
  • FGL_BCF_HIST_ALLB.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_ALLB.[column in domain "DATBI"] == CEPC.DATBI
  • FGL_BCF_HIST_ALLB.EPRCTR == CEPC.PRCTR
  • FGL_BCF_HIST_ALLB.KOKRS == CEPC.KOKRS
  • FGL_BCF_HIST_ALLB.RCLNT == CEPC.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • FGL_BCF_HIST_ALLB.FIKRS == FM01.FIKRS
  • FGL_BCF_HIST_ALLB.RCLNT == FM01.MANDT
Funds Center
  • ?
  • Financial Management Area
  • Funds Center
  • Client
  • FGL_BCF_HIST_ALLB.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • FGL_BCF_HIST_ALLB.FIKRS == FMFCTR.FIKRS
  • FGL_BCF_HIST_ALLB.FISTL == FMFCTR.FICTR
  • FGL_BCF_HIST_ALLB.RCLNT == FMFCTR.MANDT
Short Key for a House Bank
  • Short Key for a House Bank
  • ?
  • Client
  • FGL_BCF_HIST_ALLB.HBKID == T012.HBKID
  • FGL_BCF_HIST_ALLB.[column in domain "BUKRS"] == T012.BUKRS
  • FGL_BCF_HIST_ALLB.RCLNT == T012.MANDT
ID for Account Details
  • Short Key for a House Bank
  • ?
  • ID for Account Details
  • Client
  • FGL_BCF_HIST_ALLB.HBKID == T012K.HBKID
  • FGL_BCF_HIST_ALLB.[column in domain "BUKRS"] == T012K.BUKRS
  • FGL_BCF_HIST_ALLB.HKTID == T012K.HKTID
  • FGL_BCF_HIST_ALLB.RCLNT == T012K.MANDT
Controlling Area
  • Controlling Area
  • Client
  • FGL_BCF_HIST_ALLB.KOKRS == TKA01.KOKRS
  • FGL_BCF_HIST_ALLB.RCLNT == TKA01.MANDT
Alternative Chart of Accounts
  • Alternative Chart of Accounts
  • Client
  • FGL_BCF_HIST_ALLB.KTOP2 == T004.KTOPL
  • FGL_BCF_HIST_ALLB.RCLNT == T004.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • FGL_BCF_HIST_ALLB.KTOPL == T004.KTOPL
  • FGL_BCF_HIST_ALLB.RCLNT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • FGL_BCF_HIST_ALLB.KUNNR == KNA1.KUNNR
  • FGL_BCF_HIST_ALLB.RCLNT == KNA1.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • FGL_BCF_HIST_ALLB.LIFNR == LFA1.LIFNR
  • FGL_BCF_HIST_ALLB.RCLNT == LFA1.MANDT
Alternative Account Number in Company Code
  • Alternative Chart of Accounts
  • Alternative Account Number in Company Code
  • Client
  • FGL_BCF_HIST_ALLB.KTOP2 == SKA1.KTOPL
  • FGL_BCF_HIST_ALLB.LOKKT == SKA1.SAKNR
  • FGL_BCF_HIST_ALLB.RCLNT == SKA1.MANDT
Material Number
  • Material Number
  • Client
  • FGL_BCF_HIST_ALLB.MATNR == MARA.MATNR
  • FGL_BCF_HIST_ALLB.RCLNT == MARA.MANDT
Funded Program
  • Funded Program
  • Financial Management Area
  • Client
  • FGL_BCF_HIST_ALLB.MEASURE == FMMEASURE.MEASURE
  • FGL_BCF_HIST_ALLB.FIKRS == FMMEASURE.FMAREA
  • FGL_BCF_HIST_ALLB.RCLNT == FMMEASURE.CLIENT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FGL_BCF_HIST_ALLB.PERIV == T009.PERIV
  • FGL_BCF_HIST_ALLB.RCLNT == T009.MANDT
Partner Profit Center
  • Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • FGL_BCF_HIST_ALLB.PPRCTR == CEPC.PRCTR
  • FGL_BCF_HIST_ALLB.[column in domain "DATBI"] == CEPC.DATBI
  • FGL_BCF_HIST_ALLB.KOKRS == CEPC.KOKRS
  • FGL_BCF_HIST_ALLB.RCLNT == CEPC.MANDT
Partner Project (internal ID)
  • Partner Project (internal ID)
  • Client
  • FGL_BCF_HIST_ALLB.PPS_PRJ_PNR == PROJ.PSPNR
  • FGL_BCF_HIST_ALLB.RCLNT == PROJ.MANDT
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • FGL_BCF_HIST_ALLB.PRCTR == CEPC.PRCTR
  • FGL_BCF_HIST_ALLB.[column in domain "DATBI"] == CEPC.DATBI
  • FGL_BCF_HIST_ALLB.KOKRS == CEPC.KOKRS
  • FGL_BCF_HIST_ALLB.RCLNT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • FGL_BCF_HIST_ALLB.PSEGMENT == FAGL_SEGM.SEGMENT
  • FGL_BCF_HIST_ALLB.RCLNT == FAGL_SEGM.MANDT
Additional Unit of Measure 1
  • Additional Unit of Measure 1
  • Client
  • FGL_BCF_HIST_ALLB.QUNIT1 == T006.MSEHI
  • FGL_BCF_HIST_ALLB.RCLNT == T006.MANDT
Additional Unit of Measure 2
  • Additional Unit of Measure 2
  • Client
  • FGL_BCF_HIST_ALLB.QUNIT2 == T006.MSEHI
  • FGL_BCF_HIST_ALLB.RCLNT == T006.MANDT
Additional Unit of Measure 3
  • Additional Unit of Measure 3
  • Client
  • FGL_BCF_HIST_ALLB.QUNIT3 == T006.MSEHI
  • FGL_BCF_HIST_ALLB.RCLNT == T006.MANDT
Account Number
  • Company Code
  • Account Number
  • Client
  • FGL_BCF_HIST_ALLB.RBUKRS == SKB1.BUKRS
  • FGL_BCF_HIST_ALLB.RACCT == SKB1.SAKNR
  • FGL_BCF_HIST_ALLB.RCLNT == SKB1.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • FGL_BCF_HIST_ALLB.RASSC == T880.RCOMP
  • FGL_BCF_HIST_ALLB.RCLNT == T880.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • FGL_BCF_HIST_ALLB.RBCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
Budget Period
  • Budget Period
  • Financial Management Area
  • Client
  • Fund
  • FGL_BCF_HIST_ALLB.RBUDGET_PD == FMFUNDBPD.BUDGET_PD
  • FGL_BCF_HIST_ALLB.FIKRS == FMFUNDBPD.FIKRS
  • FGL_BCF_HIST_ALLB.RCLNT == FMFUNDBPD.MANDT
  • FGL_BCF_HIST_ALLB.RFUND == FMFUNDBPD.FINCODE
Company Code
  • Company Code
  • Client
  • FGL_BCF_HIST_ALLB.RBUKRS == T001.BUKRS
  • FGL_BCF_HIST_ALLB.RCLNT == T001.MANDT
Business Area
  • Business Area
  • Client
  • FGL_BCF_HIST_ALLB.RBUSA == TGSB.GSBER
  • FGL_BCF_HIST_ALLB.RCLNT == TGSB.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • FGL_BCF_HIST_ALLB.RCCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
Client FGL_BCF_HIST_ALLB.RCLNT == T000.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • FGL_BCF_HIST_ALLB.RCNTR == CSKS.KOSTL
  • FGL_BCF_HIST_ALLB.[column in domain "DATBI"] == CSKS.DATBI
  • FGL_BCF_HIST_ALLB.KOKRS == CSKS.KOKRS
  • FGL_BCF_HIST_ALLB.RCLNT == CSKS.MANDT
CO Object Currency
  • CO Object Currency
  • Client
  • FGL_BCF_HIST_ALLB.RCO_OCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • FGL_BCF_HIST_ALLB.RDCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
Recovery Indicator
  • ?
  • Recovery Indicator
  • Client
  • FGL_BCF_HIST_ALLB.[column in domain "BUKRS"] == T8JJ.BUKRS
  • FGL_BCF_HIST_ALLB.RECID == T8JJ.RECID
  • FGL_BCF_HIST_ALLB.RCLNT == T8JJ.MANDT
Freely Defined Currency 6
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_ALLB.RECUR == TCURC.WAERS
Cash Origin Account
  • Chart of Accounts
  • Cash Origin Account
  • Client
  • FGL_BCF_HIST_ALLB.KTOPL == SKA1.KTOPL
  • FGL_BCF_HIST_ALLB.RE_ACCOUNT == SKA1.SAKNR
  • FGL_BCF_HIST_ALLB.RCLNT == SKA1.MANDT
Cash Origin Company Code
  • FGL_BCF_HIST_ALLB.RCLNT == T001.MANDT
  • FGL_BCF_HIST_ALLB.RE_BUKRS == T001.BUKRS
Functional Area
  • Functional Area
  • Client
  • FGL_BCF_HIST_ALLB.RFAREA == TFKB.FKBER
  • FGL_BCF_HIST_ALLB.RCLNT == TFKB.MANDT
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • FGL_BCF_HIST_ALLB.RFCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
Fund
  • Financial Management Area
  • Client
  • Fund
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • FGL_BCF_HIST_ALLB.RGCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
Company Code Currency
  • Company Code Currency
  • Company Code Currency
  • Client
  • FGL_BCF_HIST_ALLB.RWCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RHCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
Global Currency
  • Global Currency
  • Client
  • FGL_BCF_HIST_ALLB.RKCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • FGL_BCF_HIST_ALLB.ROCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • FGL_BCF_HIST_ALLB.RTCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • FGL_BCF_HIST_ALLB.RUNIT == T006.MSEHI
  • FGL_BCF_HIST_ALLB.RCLNT == T006.MANDT
Freely Defined Currency 2
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
  • FGL_BCF_HIST_ALLB.RVCUR == TCURC.WAERS
Unit of Measure for Valuation Quantity
  • Unit of Measure for Valuation Quantity
  • Client
  • FGL_BCF_HIST_ALLB.RVUNIT == T006.MSEHI
  • FGL_BCF_HIST_ALLB.RCLNT == T006.MANDT
Company Code Currency
  • Company Code Currency
  • Company Code Currency
  • Client
  • FGL_BCF_HIST_ALLB.RWCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RHCUR == TCURC.WAERS
  • FGL_BCF_HIST_ALLB.RCLNT == TCURC.MANDT
FM: Partner Budget Period
  • FM: Partner Budget Period
  • Partner Fund
  • Financial Management Area
  • Client
  • FGL_BCF_HIST_ALLB.SBUDGET_PD == FMFUNDBPD.BUDGET_PD
  • FGL_BCF_HIST_ALLB.SFUND == FMFUNDBPD.FINCODE
  • FGL_BCF_HIST_ALLB.FIKRS == FMFUNDBPD.FIKRS
  • FGL_BCF_HIST_ALLB.RCLNT == FMFUNDBPD.MANDT
Trading partner's business area
  • Trading partner's business area
  • Client
  • FGL_BCF_HIST_ALLB.SBUSA == TGSB.GSBER
  • FGL_BCF_HIST_ALLB.RCLNT == TGSB.MANDT
Sender cost center
  • Sender cost center
  • ?
  • Controlling Area
  • Client
  • FGL_BCF_HIST_ALLB.SCNTR == CSKS.KOSTL
  • FGL_BCF_HIST_ALLB.[column in domain "DATBI"] == CSKS.DATBI
  • FGL_BCF_HIST_ALLB.KOKRS == CSKS.KOKRS
  • FGL_BCF_HIST_ALLB.RCLNT == CSKS.MANDT
Segment for Segmental Reporting
  • FGL_BCF_HIST_ALLB.RCLNT == FAGL_SEGM.MANDT
  • FGL_BCF_HIST_ALLB.SEGMENT == FAGL_SEGM.SEGMENT
Partner Functional Area
  • Partner Functional Area
  • Client
  • FGL_BCF_HIST_ALLB.SFAREA == TFKB.FKBER
  • FGL_BCF_HIST_ALLB.RCLNT == TFKB.MANDT
Partner Fund
  • Partner Fund
  • Financial Management Area
  • Client
Type of the Financial Valuation Object
  • Type of the Financial Valuation Object
  • Client
Joint venture
  • ?
  • Joint venture
  • Client
  • FGL_BCF_HIST_ALLB.[column in domain "BUKRS"] == T8JV.BUKRS
  • FGL_BCF_HIST_ALLB.VNAME == T8JV.VNAME
  • FGL_BCF_HIST_ALLB.RCLNT == T8JV.MANDT
Partner account number
  • Partner account number
  • Client
  • FGL_BCF_HIST_ALLB.VPTNR == KNA1.KUNNR
  • FGL_BCF_HIST_ALLB.RCLNT == KNA1.MANDT
Plant
  • Plant
  • Client
  • FGL_BCF_HIST_ALLB.WERKS == T001W.WERKS
  • FGL_BCF_HIST_ALLB.RCLNT == T001W.MANDT