FGL_BCF_HIST_ALLB

DDL: FGL_BCF_HIST_ALLB SQL: BCFV_HIST_ALLB Type: view
144 Fields 1 Data Sources

All BS accounts and RE accounts

FGL_BCF_HIST_ALLB is a CDS View that provides data about "All BS accounts and RE accounts" in SAP S/4HANA. It reads from 1 data source (FGL_BCF_HIST_UNION_ALLB) and exposes 144 fields with key fields docln, belnr, rldnr.

Data Sources (1)

SourceAliasJoin Type
FGL_BCF_HIST_UNION_ALLB FGL_BCF_HIST_UNION_ALLB from

Parameters (5)

NameTypeDefault
P_company_code bukrs
P_ledger fins_ledger
P_from_year gjahr_pos
P_to_year gjahr_pos
P_timestamp timestamp

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName BCFV_HIST_ALLB view
AbapCatalog.compiler.compareFilter true view
EndUserText.label All BS accounts and RE accounts view
ClientHandling.type #CLIENT_DEPENDENT view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view

Fields (144)

KeyFieldSource TableSource FieldDescription
KEY docln docln Matching Document Line Item
KEY belnr belnr SD Document
KEY rldnr rldnr Ledger (Compat.)
timestamp
drcrk drcrk Debit/Credit
poper poper Posting periods
hsl_ending hsl_ending
hsl_opening hsl_opening
tsl_ending tsl_ending
tsl_opening tsl_opening
afabe afabe Deprec. Area
anbwa anbwa Trans. type
anlgr anlgr Group Asset
anlgr2 anlgr2 Subnumber
anln1 anln1 Asset
anln2 anln2 Sub-number
awsys awsys Logical System
awtyp awtyp Reference Document Type
blart blart Rep. rec. doc. type
bttype bttype Business Transaction Type
bwkey bwkey Valuation Area
bwtar bwtar Valuation Type
co_osl co_osl Value/Obj. Crcy
eprctr eprctr Elimination PrCtr
bsl bsl Exchange Key
csl csl Amount in Currency 4
dsl dsl Amount in Currency 5
esl esl Amount in Currency 6
fsl fsl Amount in Currency 7
gsl gsl Amount in Currency 8
kalnr kalnr ProdCostEst.No.
koart koart Account type
kokrs kokrs Org. Value
ksl ksl GrpCurr
ktop2 ktop2 Alternative COA
ktopl ktopl G/L Chart of Accounts
ktosl ktosl Transaction
forMLkunnr
kzbws kzbws Valuation
lifnr lifnr Vendor no.
lokkt lokkt Local Acct No.
matnr matnr Vehicle Model
mat_kdauf mat_kdauf SD Doc of Inv.
mat_kdpos mat_kdpos SD Item of Inv.
mat_lifnr mat_lifnr Vendor of Inv.
mat_pspnr mat_pspnr WBSElem of Inv.
movcat movcat Trans.Type Cat.
msl msl Stat. KeyFig. Qty
osl osl Other Crcy Amnt
periv periv FYear Variant
pfsl pfsl Price Var. Fxd
pprctr pprctr Partner PC
prctr prctr Profit Centers
psegment psegment Partner Segment
psl psl Price Variance
quant1 quant1 Add. Quantity 1
quant2 quant2 Add. Quantity 2
quant3 quant3 Add. Quantity 3
qunit1 qunit1 Add Unit Meas 1
qunit2 qunit2 Add Unit Meas 2
qunit3 qunit3 Add Unit Meas 3
racct racct GL Account From
rassc rassc Trading Partner
rbusa rbusa Business Area
rclnt rclnt Client
rcntr rcntr Cost Center
rco_ocur rco_ocur Object Currency
rfarea rfarea R FuncArea
rbcur rbcur Free Defined Crcy 3
rccur rccur Third Currency
rdcur rdcur Free Defined Crcy 5
recur recur Free Defined Crcy 6
rfcur rfcur Free Defined Crcy 7
rgcur rgcur Free Defined Crcy 8
rhcur rhcur Local Currency
rhoart rhoart Origin object
rkcur rkcur Ledger curr.
rmvct rmvct Transact. Type
rocur rocur Free Defined Crcy 1
rrcty rrcty Record Type
rtcur rtcur Currency
runit runit Unit/Area
rvunit rvunit Valuation UoM
rvcur rvcur Free Defined Crcy 4
rwcur rwcur Transaction Currency
sbusa sbusa Trdg Part.BA
scntr scntr Sender Cost Ctr
segment segment Segment number
sfarea sfarea Sender FnArea
slalittype slalittype SLALineItemType
sobkz sobkz Special Stock
vmsl vmsl Val. quantity
vorgn vorgn Transaction
vrgng vrgng Bus.Transaction
vsl vsl Amount in Currency 2
wsl wsl OrigTrnsCrcyAmt
xobew xobew Vendor stk val.
Publicsectorre_bukrs
re_account re_account Ex/Rv A/c in CL
fikrs fikrs FM Area
fistl fistl Funds Center
measure measure obsolete
rfund rfund Fund
rgrant_nbr rgrant_nbr Grant
rbudget_pd rbudget_pd Rec BudPer
sfund sfund Partner Fund
sgrant_nbr sgrant_nbr Partner Grant
sbudget_pd sbudget_pd Sender BudPer
bdgt_account bdgt_account Budget Account
JVAvname
egrup egrup Equity group
recid recid Statistical Key Figure Item
btype btype ProcurementType
prodper prodper Production Month
cbrunid cbrunid Cutback Run ID (JVA)
jvactivity jvactivity JVA Activity
pvname pvname Variant
pegrup pegrup Partner EG (JVA)
COaufnr
ps_posid ps_posid WBS Element
pps_posid pps_posid Partner WBS Element
ps_pspid ps_pspid Project def.
kdauf kdauf SD Document
kdpos kdpos Sales Ord. Item
pkdauf pkdauf Partner SalOrd
pkdpos pkdpos Part. SlsOrd Item
hbkid hbkid House Bank
hktid hktid House Bank Account
werks werks Receiving Plant
bukrs_sender bukrs_sender Sender CoCode
racct_sender racct_sender Sender GL Account
vptnr vptnr Partner
pps_prj_pnr pps_prj_pnr Partner Project Def.
pps_psp_pnr pps_psp_pnr Partner WBS Element
RealEstateswenr
sgenr sgenr Building
sgrnr sgrnr Land
Accrualacritmtype
acrobjtype acrobjtype Accrual Object Type
acrobj_id acrobj_id Accrual Object
acrsobj_id acrsobj_id Accrual Subobject
valobjtype valobjtype Type of Fin.Val.Obj.
valobj_id valobj_id Fin Valuation Object
valsobj_id valsobj_id Fin.Val.Sub.Object

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FGL_BCF_HIST_ALLB.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: BCFV_HIST_ALLB
-- Parameters: P_company_code : bukrs, P_ledger : fins_ledger, P_from_year : gjahr_pos, P_to_year : gjahr_pos, P_timestamp : timestamp

CREATE VIEW FGL_BCF_HIST_ALLB AS
SELECT
  docln,
  belnr,
  rldnr,
  $parameters.P_timestamp AS timestamp,
  drcrk,
  poper,
  hsl_ending,
  hsl_opening,
  tsl_ending,
  tsl_opening,
  afabe,
  anbwa,
  anlgr,
  anlgr2,
  anln1,
  anln2,
  awsys,
  awtyp,
  blart,
  bttype,
  bwkey,
  bwtar,
  co_osl,
  eprctr,
  bsl,
  csl,
  dsl,
  esl,
  fsl,
  gsl,
  kalnr,
  koart,
  kokrs,
  ksl,
  ktop2,
  ktopl,
  ktosl,
  kzbws,
  lifnr,
  lokkt,
  matnr,
  mat_kdauf,
  mat_kdpos,
  mat_lifnr,
  mat_pspnr,
  movcat,
  msl,
  osl,
  periv,
  pfsl,
  pprctr,
  prctr,
  psegment,
  psl,
  quant1,
  quant2,
  quant3,
  qunit1,
  qunit2,
  qunit3,
  racct,
  rassc,
  rbusa,
  rclnt,
  rcntr,
  rco_ocur,
  rfarea,
  rbcur,
  rccur,
  rdcur,
  recur,
  rfcur,
  rgcur,
  rhcur,
  rhoart,
  rkcur,
  rmvct,
  rocur,
  rrcty,
  rtcur,
  runit,
  rvunit,
  rvcur,
  rwcur,
  sbusa,
  scntr,
  segment,
  sfarea,
  slalittype,
  sobkz,
  vmsl,
  vorgn,
  vrgng,
  vsl,
  wsl,
  xobew,
  re_account,
  fikrs,
  fistl,
  measure,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  bdgt_account,
  egrup,
  recid,
  btype,
  prodper,
  cbrunid,
  jvactivity,
  pvname,
  pegrup,
  ps_posid,
  pps_posid,
  ps_pspid,
  kdauf,
  kdpos,
  pkdauf,
  pkdpos,
  hbkid,
  hktid,
  werks,
  bukrs_sender,
  racct_sender,
  vptnr,
  pps_prj_pnr,
  pps_psp_pnr,
  sgenr,
  sgrnr,
  acrobjtype,
  acrobj_id,
  acrsobj_id,
  valobjtype,
  valobj_id,
  valsobj_id
FROM FGL_BCF_HIST_UNION_ALLB
;

Learn More