FGL_BCF_PRE

Transparent Table Application Table
165 Fields 3 CDS Views

Balance Carry Forward Preview Data

FGL_BCF_PRE is an SAP database table in S/4HANA. Balance Carry Forward Preview Data. It contains 165 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_Fgl_Bcf_Prev view from EXTENSION Include View for BCF
FGL_BCF_PREV view from Balance Carry Forward Preview
I_Fgl_Bcf_Prev view from BASIC BCF PREVIEW TABLE DISPLAY

Fields (165)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt MANDT Client
KEY rbukrs BUKRS Company Code
KEY ryear GJAHR Fiscal Year
KEY rldnr FINS_LEDGER Ledger
KEY belnr BELNR_D Document Number
KEY docln DOCLN6 G/L Line Item
KEY xbilk XFELD Checkbox
awtyp AWTYP Ref. procedure
blart BLART Document Type
bttype FINS_BTTYPE Bus. Trans. Category
co_osl VCO_OCUR12 Value/Obj. Crcy
eprctr EPRCTR Elimination PrCtr
glaccount_type GLACCOUNT_TYPE G/L Account Type
hsl VLCUR12 Local Crcy Amt
koart KOART Account type
kokrs KOKRS CO Area
ksl VGCUR12 Amnt in GrpCrcy
ktop2 KTOP2 Alternative COA
ktopl KTOPL Chart of Accts
ktosl KTOSL Transaction
kunnr KUNNR Customer
lifnr LIFNR Supplier
lokkt ALTKT_SKB1 Altern. Account
matnr MATNR Material
msl QUAN1_12 Quantity
org_account G_BCF_ACC_ORG P&L account
text_org_account TXT50_SKAT Long Text
osl VOCUR12 Other Crcy Amnt
periv PERIV FY Variant
pfsl VPFCUR12 Price Var. Fxd
pprctr PPRCTR Partner PC
prctr PRCTR Profit Center
text_prctr KTEXT Name
ktext KTEXT Name
psegment FB_PSEGMENT Partner Segment
psl VPCUR12 Price Variance
quant1 FCO_QUAN1_L Add. Quantity 1
quant2 FCO_QUAN2_L Add. Quantity 2
quant3 FCO_QUAN3_L Add. Quantity 3
qunit1 FCO_QUNIT1 Add Unit Meas 1
qunit2 FCO_QUNIT2 Add Unit Meas 2
qunit3 FCO_QUNIT3 Add Unit Meas 3
racct RACCT Account Number
rassc RASSC Trading Partner
rbusa GSBER Business Area
rcntr KOSTL Cost Center
rco_ocur OWAER Object Currency
rfarea FKBER Functional Area
rhcur HWAER Local Currency
rhoart HOART Origin object
rkcur KWAER COarea currency
rmvct RMVCT Transact. Type
rocur FAGL_CURR3 Currency 3
rrcty RRCTY Record Type
rtcur RTCUR Currency
runit MEINS Base Unit
rvunit CO_MEINH Unit of Measure
rvcur FINS_CURR4 Free Defined Crcy 4
rwcur RWCUR Or.trans.currny
sbusa PARGB Trdg Part.BA
scntr SKOST Sender Cost Ctr
segment FB_SEGMENT Segment
name TEXT50 Explanation
sfarea SFKBER Partner FArea
slalittype SLALITTYPE SLALineItemType
text_racct TXT50_SKAT Long Text
tsl VTCUR12 Amount in TC
vmsl VQUAN1_12 Val. quantity
vorgn VORGN Transact. Type
vrgng CO_VORGANG Bus.Transaction
vsl FINS_VVCUR12 Amount in Currency 2
wsl VWCUR12 OrigTrnsCrcyAmt
xopvw XOPVW OI Management
bukrs BUKRS Company Code
lcurr HWAER Local Currency
gcurr GCURR Ledger curr.
ocurr OWAER Object Currency
werks WERKS_D Plant
hbkid HBKID House Bank
hktid HKTID Account ID
kalnr CK_KALNR Cost EstimateNo
kzbws KZBWS Valuation
xobew XOBEW Vendor stk val.
sobkz SOBKZ Special Stock
mat_kdauf MLMAT_KDAUF SD Doc of Inv.
mat_kdpos MLMAT_KDPOS SD Item of Inv.
mat_pspnr MLMAT_PSPNR WBSElem of Inv.
mat_lifnr MLMAT_LIFNR Vendor of Inv.
bwtar BWTAR_D Valuation Type
bwkey BWKEY Valuation Area
bukrs_sender BUKRS_SENDER Sender CoCode
racct_sender RACCT_SENDER Sender GL Account
afabe AFABE_D Deprec. area
anbwa ANBWA Ast Transaction Type
anln1 ANLN1 Asset
anln2 ANLN2 Sub-number
movcat FAA_MOVCAT Trans.Type Cat.
anlgr ANLGR Group Asset
anlgr2 ANLGR2 Subnumber
aufnr AUFNR Order
ps_posid PS_POSID WBS Element
pps_posid FCO_PAR_POSID Partner WBS Element
ps_pspid PS_PSPID Project def.
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
pkdauf PAR_KDAUF Partner SalOrd
pkdpos PAR_KDPOS Part. SlsOrd Item
pps_prj_pnr FCO_PAR_PRJ_PNR Partner Project Def.
pps_psp_pnr FCO_PAR_PSP_PNR Partner WBS Element
fikrs FIKRS FM Area
fistl FISTL Funds Center
measure FM_MEASURE Funded Program
rfund BP_GEBER Fund
rgrant_nbr GM_GRANT_NBR Grant
rbudget_pd FM_BUDGET_PERIOD Budget Period
sfund BP_P_GEBER Partner Fund
sgrant_nbr GM_GRANT_PARTNER Partner Grant
sbudget_pd FM_PBUDGET_PERIOD Par. BudPer
bdgt_account PSM_BDGT_ACCOUNT Budget Account
bdgt_account_cocode PSM_BDGT_ACCOUNT_COCODE Company Code for Budget Account
vname JV_NAME Joint venture
egrup JV_EGROUP Equity group
recid JV_RECIND Recovery Ind.
vptnr JV_PART Partner
btype JV_BILIND Billing ind.
prodper JV_PRODPER Prod.Month
cbrunid JV_CBRUNID Cutback Run ID (JVA)
jvacticity JV_ACTIVITY JVA Activity
pvname JV_PVNAME Partner Venture JVA
pegrup JV_PEGRUP Partner EG (JVA)
swenr REBDBENO Business Entity
sgenr REBDBUNO Building
sgrnr REBDPRNO Land
acrobjtype ACR_OBJ_TYPE Accrual Object Type
acrobj_id ACR_OBJ_ID Accrual Object
acrsobj_id ACR_SUBOBJ_ID Accrual Subobject
acritmtype ACR_ITEM_TYPE Accrual Item Type
valobjtype VAL_OBJ_TYPE Type of Fin.Val.Obj.
valobj_id VAL_OBJ_ID Fin Valuation Object
valsobj_id VAL_SUBOBJ_ID Fin.Val.Sub.Object
opecl OPECL Flag to Identify Closing Balance and Opening Balance
acdoc_eew_dummy CFD_DUMMY Dummy
dummy_incl_eew_cobl CFD_DUMMY Dummy
open_vsl FINS_VVCUR12 Amount in Currency 2
open_vmsl VQUAN1_12 Val. quantity
open_psl VPCUR12 Price Variance
open_pfsl VPFCUR12 Price Var. Fxd
open_co_osl VCO_OCUR12 Value/Obj. Crcy
open_wsl VWCUR12 OrigTrnsCrcyAmt
open_msl QUAN1_12 Quantity
open_osl VOCUR12 Other Crcy Amnt
open_ksl VGCUR12 Amnt in GrpCrcy
open_hsl VLCUR12 Local Crcy Amt
open_tsl VTCUR12 Amount in TC
ch_vsl FINS_VVCUR12 Amount in Currency 2
ch_vmsl VQUAN1_12 Val. quantity
ch_psl VPCUR12 Price Variance
ch_pfsl VPFCUR12 Price Var. Fxd
ch_co_osl VCO_OCUR12 Value/Obj. Crcy
ch_wsl VWCUR12 OrigTrnsCrcyAmt
ch_msl QUAN1_12 Quantity
ch_osl VOCUR12 Other Crcy Amnt
ch_ksl VGCUR12 Amnt in GrpCrcy
ch_hsl VLCUR12 Local Crcy Amt
ch_tsl VTCUR12 Amount in TC

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Balance Carry Forward Preview Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FGL_BCF_PRE (
    RCLNT,                -- Client [MANDT]
    RBUKRS,               -- Company Code [BUKRS]
    RYEAR,                -- Fiscal Year [GJAHR]
    RLDNR,                -- Ledger [FINS_LEDGER]
    BELNR,                -- Document Number [BELNR_D]
    DOCLN,                -- G/L Line Item [DOCLN6]
    XBILK,                -- Checkbox [XFELD]
    AWTYP,                -- Ref. procedure [AWTYP]
    BLART,                -- Document Type [BLART]
    BTTYPE,               -- Bus. Trans. Category [FINS_BTTYPE]
    CO_OSL,               -- Value/Obj. Crcy [VCO_OCUR12]
    EPRCTR,               -- Elimination PrCtr [EPRCTR]
    GLACCOUNT_TYPE,       -- G/L Account Type [GLACCOUNT_TYPE]
    HSL,                  -- Local Crcy Amt [VLCUR12]
    KOART,                -- Account type [KOART]
    KOKRS,                -- CO Area [KOKRS]
    KSL,                  -- Amnt in GrpCrcy [VGCUR12]
    KTOP2,                -- Alternative COA [KTOP2]
    KTOPL,                -- Chart of Accts [KTOPL]
    KTOSL,                -- Transaction [KTOSL]
    KUNNR,                -- Customer [KUNNR]
    LIFNR,                -- Supplier [LIFNR]
    LOKKT,                -- Altern. Account [ALTKT_SKB1]
    MATNR,                -- Material [MATNR]
    MSL,                  -- Quantity [QUAN1_12]
    ORG_ACCOUNT,          -- P&L account [G_BCF_ACC_ORG]
    TEXT_ORG_ACCOUNT,     -- Long Text [TXT50_SKAT]
    OSL,                  -- Other Crcy Amnt [VOCUR12]
    PERIV,                -- FY Variant [PERIV]
    PFSL,                 -- Price Var. Fxd [VPFCUR12]
    PPRCTR,               -- Partner PC [PPRCTR]
    PRCTR,                -- Profit Center [PRCTR]
    TEXT_PRCTR,           -- Name [KTEXT]
    KTEXT,                -- Name [KTEXT]
    PSEGMENT,             -- Partner Segment [FB_PSEGMENT]
    PSL,                  -- Price Variance [VPCUR12]
    QUANT1,               -- Add. Quantity 1 [FCO_QUAN1_L]
    QUANT2,               -- Add. Quantity 2 [FCO_QUAN2_L]
    QUANT3,               -- Add. Quantity 3 [FCO_QUAN3_L]
    QUNIT1,               -- Add Unit Meas 1 [FCO_QUNIT1]
    QUNIT2,               -- Add Unit Meas 2 [FCO_QUNIT2]
    QUNIT3,               -- Add Unit Meas 3 [FCO_QUNIT3]
    RACCT,                -- Account Number [RACCT]
    RASSC,                -- Trading Partner [RASSC]
    RBUSA,                -- Business Area [GSBER]
    RCNTR,                -- Cost Center [KOSTL]
    RCO_OCUR,             -- Object Currency [OWAER]
    RFAREA,               -- Functional Area [FKBER]
    RHCUR,                -- Local Currency [HWAER]
    RHOART,               -- Origin object [HOART]
    RKCUR,                -- COarea currency [KWAER]
    RMVCT,                -- Transact. Type [RMVCT]
    ROCUR,                -- Currency 3 [FAGL_CURR3]
    RRCTY,                -- Record Type [RRCTY]
    RTCUR,                -- Currency [RTCUR]
    RUNIT,                -- Base Unit [MEINS]
    RVUNIT,               -- Unit of Measure [CO_MEINH]
    RVCUR,                -- Free Defined Crcy 4 [FINS_CURR4]
    RWCUR,                -- Or.trans.currny [RWCUR]
    SBUSA,                -- Trdg Part.BA [PARGB]
    SCNTR,                -- Sender Cost Ctr [SKOST]
    SEGMENT,              -- Segment [FB_SEGMENT]
    NAME,                 -- Explanation [TEXT50]
    SFAREA,               -- Partner FArea [SFKBER]
    SLALITTYPE,           -- SLALineItemType [SLALITTYPE]
    TEXT_RACCT,           -- Long Text [TXT50_SKAT]
    TSL,                  -- Amount in TC [VTCUR12]
    VMSL,                 -- Val. quantity [VQUAN1_12]
    VORGN,                -- Transact. Type [VORGN]
    VRGNG,                -- Bus.Transaction [CO_VORGANG]
    VSL,                  -- Amount in Currency 2 [FINS_VVCUR12]
    WSL,                  -- OrigTrnsCrcyAmt [VWCUR12]
    XOPVW,                -- OI Management [XOPVW]
    BUKRS,                -- Company Code [BUKRS]
    LCURR,                -- Local Currency [HWAER]
    GCURR,                -- Ledger curr. [GCURR]
    OCURR,                -- Object Currency [OWAER]
    WERKS,                -- Plant [WERKS_D]
    HBKID,                -- House Bank [HBKID]
    HKTID,                -- Account ID [HKTID]
    KALNR,                -- Cost EstimateNo [CK_KALNR]
    KZBWS,                -- Valuation [KZBWS]
    XOBEW,                -- Vendor stk val. [XOBEW]
    SOBKZ,                -- Special Stock [SOBKZ]
    MAT_KDAUF,            -- SD Doc of Inv. [MLMAT_KDAUF]
    MAT_KDPOS,            -- SD Item of Inv. [MLMAT_KDPOS]
    MAT_PSPNR,            -- WBSElem of Inv. [MLMAT_PSPNR]
    MAT_LIFNR,            -- Vendor of Inv. [MLMAT_LIFNR]
    BWTAR,                -- Valuation Type [BWTAR_D]
    BWKEY,                -- Valuation Area [BWKEY]
    BUKRS_SENDER,         -- Sender CoCode [BUKRS_SENDER]
    RACCT_SENDER,         -- Sender GL Account [RACCT_SENDER]
    AFABE,                -- Deprec. area [AFABE_D]
    ANBWA,                -- Ast Transaction Type [ANBWA]
    ANLN1,                -- Asset [ANLN1]
    ANLN2,                -- Sub-number [ANLN2]
    MOVCAT,               -- Trans.Type Cat. [FAA_MOVCAT]
    ANLGR,                -- Group Asset [ANLGR]
    ANLGR2,               -- Subnumber [ANLGR2]
    AUFNR,                -- Order [AUFNR]
    PS_POSID,             -- WBS Element [PS_POSID]
    PPS_POSID,            -- Partner WBS Element [FCO_PAR_POSID]
    PS_PSPID,             -- Project def. [PS_PSPID]
    KDAUF,                -- Sales Order [KDAUF]
    KDPOS,                -- Sales Ord. Item [KDPOS]
    PKDAUF,               -- Partner SalOrd [PAR_KDAUF]
    PKDPOS,               -- Part. SlsOrd Item [PAR_KDPOS]
    PPS_PRJ_PNR,          -- Partner Project Def. [FCO_PAR_PRJ_PNR]
    PPS_PSP_PNR,          -- Partner WBS Element [FCO_PAR_PSP_PNR]
    FIKRS,                -- FM Area [FIKRS]
    FISTL,                -- Funds Center [FISTL]
    MEASURE,              -- Funded Program [FM_MEASURE]
    RFUND,                -- Fund [BP_GEBER]
    RGRANT_NBR,           -- Grant [GM_GRANT_NBR]
    RBUDGET_PD,           -- Budget Period [FM_BUDGET_PERIOD]
    SFUND,                -- Partner Fund [BP_P_GEBER]
    SGRANT_NBR,           -- Partner Grant [GM_GRANT_PARTNER]
    SBUDGET_PD,           -- Par. BudPer [FM_PBUDGET_PERIOD]
    BDGT_ACCOUNT,         -- Budget Account [PSM_BDGT_ACCOUNT]
    BDGT_ACCOUNT_COCODE,  -- Company Code for Budget Account [PSM_BDGT_ACCOUNT_COCODE]
    VNAME,                -- Joint venture [JV_NAME]
    EGRUP,                -- Equity group [JV_EGROUP]
    RECID,                -- Recovery Ind. [JV_RECIND]
    VPTNR,                -- Partner [JV_PART]
    BTYPE,                -- Billing ind. [JV_BILIND]
    PRODPER,              -- Prod.Month [JV_PRODPER]
    CBRUNID,              -- Cutback Run ID (JVA) [JV_CBRUNID]
    JVACTICITY,           -- JVA Activity [JV_ACTIVITY]
    PVNAME,               -- Partner Venture JVA [JV_PVNAME]
    PEGRUP,               -- Partner EG (JVA) [JV_PEGRUP]
    SWENR,                -- Business Entity [REBDBENO]
    SGENR,                -- Building [REBDBUNO]
    SGRNR,                -- Land [REBDPRNO]
    ACROBJTYPE,           -- Accrual Object Type [ACR_OBJ_TYPE]
    ACROBJ_ID,            -- Accrual Object [ACR_OBJ_ID]
    ACRSOBJ_ID,           -- Accrual Subobject [ACR_SUBOBJ_ID]
    ACRITMTYPE,           -- Accrual Item Type [ACR_ITEM_TYPE]
    VALOBJTYPE,           -- Type of Fin.Val.Obj. [VAL_OBJ_TYPE]
    VALOBJ_ID,            -- Fin Valuation Object [VAL_OBJ_ID]
    VALSOBJ_ID,           -- Fin.Val.Sub.Object [VAL_SUBOBJ_ID]
    OPECL,                -- Flag to Identify Closing Balance and Opening Balance [OPECL]
    ACDOC_EEW_DUMMY,      -- Dummy [CFD_DUMMY]
    DUMMY_INCL_EEW_COBL,  -- Dummy [CFD_DUMMY]
    OPEN_VSL,             -- Amount in Currency 2 [FINS_VVCUR12]
    OPEN_VMSL,            -- Val. quantity [VQUAN1_12]
    OPEN_PSL,             -- Price Variance [VPCUR12]
    OPEN_PFSL,            -- Price Var. Fxd [VPFCUR12]
    OPEN_CO_OSL,          -- Value/Obj. Crcy [VCO_OCUR12]
    OPEN_WSL,             -- OrigTrnsCrcyAmt [VWCUR12]
    OPEN_MSL,             -- Quantity [QUAN1_12]
    OPEN_OSL,             -- Other Crcy Amnt [VOCUR12]
    OPEN_KSL,             -- Amnt in GrpCrcy [VGCUR12]
    OPEN_HSL,             -- Local Crcy Amt [VLCUR12]
    OPEN_TSL,             -- Amount in TC [VTCUR12]
    CH_VSL,               -- Amount in Currency 2 [FINS_VVCUR12]
    CH_VMSL,              -- Val. quantity [VQUAN1_12]
    CH_PSL,               -- Price Variance [VPCUR12]
    CH_PFSL,              -- Price Var. Fxd [VPFCUR12]
    CH_CO_OSL,            -- Value/Obj. Crcy [VCO_OCUR12]
    CH_WSL,               -- OrigTrnsCrcyAmt [VWCUR12]
    CH_MSL,               -- Quantity [QUAN1_12]
    CH_OSL,               -- Other Crcy Amnt [VOCUR12]
    CH_KSL,               -- Amnt in GrpCrcy [VGCUR12]
    CH_HSL,               -- Local Crcy Amt [VLCUR12]
    CH_TSL,               -- Amount in TC [VTCUR12]
    PRIMARY KEY (RCLNT, RBUKRS, RYEAR, RLDNR, BELNR, DOCLN, XBILK)
);

Learn More