Fclm_Bseg_Prjk

BSEG Projection | view: VFCLMBSEGPRJK | TRAN | Extraction: Not supported | Component: SAP Cash Management
Tables used: BSEGVBKPFVBSEGKVBSEGSFLQACC_INFO_APP
Column Name Description
Column Name Description
wrbtr Amount in document currency
dmbtr Amount in local currency
Column Name Description
Column Name Description
h_budat Posting Date in the Document
h_bldat Document Date in Document
fdtag Planning Date
valut Value date
sk1dt Due Date for Cash Discount 1
sk2dt Due Date for Cash Discount 2
netdt Net Due Date
augdt Clearing Date
Column Name Description
shkzg Debit/Credit Indicator Show values
vertt Contract Type Show values
Column Name Description Domain name
gjahr Fiscal Year GJAHR
belnr Document Number of an Accounting Document BELNR
buzei Number of Line Item Within Accounting Document BUZEI
buzid Identification of the Line Item CHAR1
fqftype Flow Type FQM_FLOW_TYPE
ktosl Transaction Key CHAR3
zekkn Sequential Number of Account Assignment NUM02
zuonr Assignment number ZUONR
h_monat Fiscal period MONAT
zbd1p Cash discount percentage 1 PRZ23
zbd2p Cash Discount Percentage 2 PRZ23
augbl Document Number of the Clearing Document BELNR
agzei Clearing Item AGZEI
rebzt Follow-On Document Type REBZT
rebzg Document No. of the Invoice to Which the Transaction Belongs BELNR
rebzj Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
rebzz Line Item in the Relevant Invoice BUZEI
lqitem Liquidity Item FLQPOS
segment Segment for Segmental Reporting FB_SEGMENT
prctr Profit Center PRCTR
kostl Cost Center KOSTL
projk Work Breakdown Structure Element (WBS Element) PS_POSNR
vertn Contract Number RANL
x_parked null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • FCLM_BSEG_PRJK.MANDT == T001.MANDT
  • FCLM_BSEG_PRJK.BUKRS == T001.BUKRS
Planning Group
  • Client
  • Planning Group
  • FCLM_BSEG_PRJK.MANDT == T035.MANDT
  • FCLM_BSEG_PRJK.FDGRP == T035.GRUPP
Planning Level
  • Client
  • Planning Level
  • FCLM_BSEG_PRJK.MANDT == T036.MANDT
  • FCLM_BSEG_PRJK.FDLEV == T036.EBENE
Business Area
  • Client
  • Business Area
  • FCLM_BSEG_PRJK.MANDT == TGSB.MANDT
  • FCLM_BSEG_PRJK.GSBER == TGSB.GSBER
Short Key for a House Bank
  • Client
  • ?
  • Short Key for a House Bank
  • FCLM_BSEG_PRJK.MANDT == T012.MANDT
  • FCLM_BSEG_PRJK.[column in domain "BUKRS"] == T012.BUKRS
  • FCLM_BSEG_PRJK.HBKID == T012.HBKID
General Ledger Account
  • General Ledger Account
  • Client
  • Company Code
  • FCLM_BSEG_PRJK.HKONT == SKB1.SAKNR
  • FCLM_BSEG_PRJK.MANDT == SKB1.MANDT
  • FCLM_BSEG_PRJK.BUKRS == SKB1.BUKRS
ID for Account Details
  • Client
  • ?
  • Short Key for a House Bank
  • ID for Account Details
  • FCLM_BSEG_PRJK.MANDT == T012K.MANDT
  • FCLM_BSEG_PRJK.[column in domain "BUKRS"] == T012K.BUKRS
  • FCLM_BSEG_PRJK.HBKID == T012K.HBKID
  • FCLM_BSEG_PRJK.HKTID == T012K.HKTID
Currency Key
  • Client
  • Currency Key
  • FCLM_BSEG_PRJK.MANDT == TCURC.MANDT
  • FCLM_BSEG_PRJK.H_WAERS == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • FCLM_BSEG_PRJK.MANDT == KNA1.MANDT
  • FCLM_BSEG_PRJK.KUNNR == KNA1.KUNNR
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • FCLM_BSEG_PRJK.MANDT == LFA1.MANDT
  • FCLM_BSEG_PRJK.LIFNR == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • FCLM_BSEG_PRJK.MANDT == MARA.MANDT
  • FCLM_BSEG_PRJK.MATNR == MARA.MATNR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FCLM_BSEG_PRJK.MANDT == T880.MANDT
  • FCLM_BSEG_PRJK.VBUND == T880.RCOMP