fac_cds_bseg

Entry view for financial document | view: FACV_BSEG | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BKPF, BSEG, VBAK, VBPA, FAGL_SEGMT, KNA1, MAKT, SKAT, T001, T005T, T005U, T016T, T880, TFKBT, TVKOT, TVTWT
Column Name Description
bukrs FK Company Code
belnr Document Number of an Accounting Document
gjahr Fiscal Year
smode Identification of the Line Item
rldnr FK Tax on sales/purchases code
sadl_buzei Task List Number for Operations in Order
bseg_buzei Number of Line Item Within Accounting Document
Column Name Description
dmbtr Amount in local currency
wrbtr Amount in document currency
dmbe2 Amount in Second Local Currency or Global Currency
dmbe3 Amount in Third Local Currency or First Freely-Def. Currency
txbfw Original Tax Base Amount in Document Currency
hwbas Tax Base Amount in Local Currency
fwbas Tax Base Amount in Document Currency
qsfbt Withholding Tax-Exempt Amount (in Document Currency)
qsshb Withholding Tax Base Amount
wskto Cash Discount Amount in Document Currency
sknto Cash Discount Amount in Local Currency
skfbt Amount Eligible for Cash Discount in Document Currency
dmsol Amount in local currency
dmhab Amount in local currency
wrsol Amount in document currency
wrhab Amount in document currency
dmso2 Amount in Second Local Currency or Global Currency
dmha2 Amount in Second Local Currency or Global Currency
dmso3 Amount in Third Local Currency or First Freely-Def. Currency
dmha3 Amount in Third Local Currency or First Freely-Def. Currency
💲 Currency for Automatic Payment (pycur):
pyamt Amount in Payment Currency
Column Name Description
📏 Base Unit of Measure (meins):
menge Quantity
Column Name Description
dabrz Reference date for settlement
prodper Production Month (Date to find period and year)
zfbdt Baseline Date for Due Date Calculation
madat Date of Last Dunning Notice
vrsdt Insurance Date
zolld Customs Date
valut Value date
budat Posting Date in the Document
Column Name Description
koart Account type Show values
shkzg Debit/Credit Indicator Show values
xnegp Indicator: Negative Posting Show values
xskrl Indicator: Line Item Not Liable to Cash Discount? Show values
hwmet Method with Which the Local Currency Amount Was Determined Show values
xegdr Indicator: Triangular Deal Within the EU Show values
gmvkz Item is in Execution Show values
srtype Type of Additional Receivable Show values
zbfix Fixed Payment Terms Show values
xcpdd Indicator: Address and Bank Data Set Individually Show values
vertt Contract Type Show values
zinkz Exempted from Interest Calculation Show values
xinve Indicator: Capital Goods Affected? Show values
bstat Document Status Show values
Column Name Description Domain name
bseg_add_buzei null
sgtxt Item Text TEXT50
zuonr Assignment number ZUONR
kursr Hedged Exchange Rate KURSP
stceg VAT Registration Number STCEG
ccbtc Payment cards: Settlement run CCBTC
kidno Payment Reference CHAR30
xref1 Business Partner Reference Key CHAR12
xref2 Business Partner Reference Key CHAR12
xref3 Reference key for line item CHAR20
prctr Profit Center PRCTR
segment Segment for Segmental Reporting FB_SEGMENT
psegment Partner Segment for Segmental Reporting FB_SEGMENT
KDAUF Sales Document VBELN
KDPOS Sales Document Item POSNR
zekkn Sequential Number of Account Assignment NUM02
pernr Personnel Number PERNR
abper Settlement Period BUPER
paobjnr Profitability Segment Number (CO-PA) RKEOBJNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
nplnr Network Number for Account Assignment AUFNR
aufpl Task List Number for Operations in Order AUFPL
aplzl General Counter for Order CO_APLZL
kostl Cost Center KOSTL
kstrg Cost Object KSTRG
lstar Activity Type LSTAR
prznr Business Process CO_PRZNR
imkey Internal Key for Real Estate Object IMKEY
fipos Commitment Item FIPOS
fistl Funds Center FISTL
geber Fund BP_GEBER
grant_nbr Grant GM_GRANT_NBR
pgrant_nbr Partner Grant GM_GRANT_NBR
FKBER Functional Area FKBER
pfkber Partner Functional Area FKBER
budget_pd Budget Period FM_BUDGET_PERIOD
pbudget_pd FM: Partner Budget Period FM_BUDGET_PERIOD
filkd Account Number of the Branch MAXKK
umsks Special G/L Transaction Type UMSKS
hzuon Assignment Number for Special G/L Accounts ZUONR
zterm Terms of payment key ZTERM
zbd1p Cash discount percentage 1 PRZ23
zbd1t Cash discount days 1 ZBDXT
zbd2p Cash Discount Percentage 2 PRZ23
zbd2t Cash discount days 2 ZBDXT
zbd3t Net Payment Terms Period ZBDXT
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
rebzt Follow-On Document Type REBZT
empfb Payee/Payer MAXKK
bvtyp Partner bank type BVTYP
diekz Service Indicator (Foreign Payment) DIEKZ
samnr Invoice List Number SAMNR
vertn Contract Number RANL
vbewa Flow Type SBEWART
dtws1 Instruction Key 1 DTWSX
dtws2 Instruction Key 2 DTWSX
dtws3 Instruction key 3 DTWSX
dtws4 Instruction key 4 DTWSX
mndid Unique Reference to Mandate for each Payee ID035
manst Dunning Level MAHNS
vrskz Insurance Indicator CHAR1
anfbn Document Number of the Bill of Exchange Payment Request BELNR
anfbj Fiscal Year of the Bill of Exchange Payment Request Document GJAHR
zollt Customs Tariff Number ZOLLT
vbeln Billing Document VBELN
bvorg Number of Cross-Company Code Posting Transaction BVORG
hkont_txt G/L Account Short Text TEXT20
bukrs_txt Name of Company Code or Company TEXT25
segment_txt Text Field TEXT50
psegment_txt Text Field TEXT50
fkber_txt Name of the functional area TEXT25
kunnr_txt Name 1 NAME
vbund_txt Company name TEXT30
matnr_txt Material Description TEXT40
vkorg_txt Name TEXT20
vtweg_txt Name TEXT20
regio_txt Description TEXT20
brsch_txt Description of the Industry Key TEXT20
hwmet_txt Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Company Code in Which Bill of Exch.Payment Request Is Posted
  • Company Code in Which Bill of Exch.Payment Request Is Posted
  • Client
  • FAC_CDS_BSEG.ANFBU == T001.BUKRS
  • FAC_CDS_BSEG.MANDT == T001.MANDT
Order Number
  • Order Number
  • Client
  • FAC_CDS_BSEG.AUFNR == AUFK.AUFNR
  • FAC_CDS_BSEG.MANDT == AUFK.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • FAC_CDS_BSEG.SHTO_LAND1_TXT == T005.LAND1
  • FAC_CDS_BSEG.SHTO_LAND1 == T005.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1_TXT == T005.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1 == T005.LAND1
  • FAC_CDS_BSEG.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • FAC_CDS_BSEG.SHTO_LAND1_TXT == T005.LAND1
  • FAC_CDS_BSEG.SHTO_LAND1 == T005.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1_TXT == T005.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1 == T005.LAND1
  • FAC_CDS_BSEG.MANDT == T005.MANDT
Industry key
  • Industry key
  • Client
  • FAC_CDS_BSEG.BRSCH == T016.BRSCH
  • FAC_CDS_BSEG.MANDT == T016.MANDT
Posting Key
  • Posting Key
  • Client
  • FAC_CDS_BSEG.BSCHL == TBSL.BSCHL
  • FAC_CDS_BSEG.MANDT == TBSL.MANDT
Billing Indicator
  • Billing Indicator
  • Client
  • FAC_CDS_BSEG.BTYPE == T8JA.BILIND
  • FAC_CDS_BSEG.MANDT == T8JA.MANDT
Company Code
  • Company Code
  • Client
  • FAC_CDS_BSEG.BUKRS == T001.BUKRS
  • FAC_CDS_BSEG.MANDT == T001.MANDT
Accounts Receivable Pledging Indicator
  • Company Code
  • Accounts Receivable Pledging Indicator
  • Client
  • FAC_CDS_BSEG.BUKRS == TCESSION.COMPANY
  • FAC_CDS_BSEG.CESSION_KZ == TCESSION.CESSION_KZ
  • FAC_CDS_BSEG.MANDT == TCESSION.CLIENT
Equity group
  • Joint venture
  • Equity group
  • Company Code
  • Client
  • FAC_CDS_BSEG.VNAME == T8JF.VNAME
  • FAC_CDS_BSEG.EGRUP == T8JF.EGRUP
  • FAC_CDS_BSEG.BUKRS == T8JF.BUKRS
  • FAC_CDS_BSEG.MANDT == T8JF.MANDT
Planning Group
  • Planning Group
  • Client
  • FAC_CDS_BSEG.FDGRP == T035.GRUPP
  • FAC_CDS_BSEG.MANDT == T035.MANDT
Planning Level
  • Planning Level
  • Client
  • FAC_CDS_BSEG.FDLEV == T036.EBENE
  • FAC_CDS_BSEG.MANDT == T036.MANDT
Distribution Type for Employment Tax
  • Distribution Type for Employment Tax
  • Company Code
  • Client
Activity Code for Gross Income Tax
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Activity Code for Gross Income Tax
  • Client
  • FAC_CDS_BSEG.SHTO_LAND1_TXT == J_1AGICD.LAND1
  • FAC_CDS_BSEG.SHTO_LAND1 == J_1AGICD.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1_TXT == J_1AGICD.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1 == J_1AGICD.LAND1
  • FAC_CDS_BSEG.GRICD == J_1AGICD.J_1AGICD
  • FAC_CDS_BSEG.MANDT == J_1AGICD.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • FAC_CDS_BSEG.SHTO_LAND1_TXT == T005S.LAND1
  • FAC_CDS_BSEG.SHTO_LAND1 == T005S.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1_TXT == T005S.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1 == T005S.LAND1
  • FAC_CDS_BSEG.GRIRG == T005S.BLAND
  • FAC_CDS_BSEG.MANDT == T005S.MANDT
Business Area
  • Business Area
  • Client
  • FAC_CDS_BSEG.GSBER == TGSB.GSBER
  • FAC_CDS_BSEG.MANDT == TGSB.MANDT
Short Key for a House Bank
  • ?
  • Short Key for a House Bank
  • Client
  • FAC_CDS_BSEG.[column in domain "BUKRS"] == T012.BUKRS
  • FAC_CDS_BSEG.HBKID == T012.HBKID
  • FAC_CDS_BSEG.MANDT == T012.MANDT
General Ledger Account
  • Company Code
  • General Ledger Account
  • Client
  • FAC_CDS_BSEG.BUKRS == SKB1.BUKRS
  • FAC_CDS_BSEG.HKONT == SKB1.SAKNR
  • FAC_CDS_BSEG.MANDT == SKB1.MANDT
ID for Account Details
  • ?
  • Short Key for a House Bank
  • ID for Account Details
  • Client
  • FAC_CDS_BSEG.[column in domain "BUKRS"] == T012K.BUKRS
  • FAC_CDS_BSEG.HBKID == T012K.HBKID
  • FAC_CDS_BSEG.HKTID == T012K.HKTID
  • FAC_CDS_BSEG.MANDT == T012K.MANDT
Inflation Index
  • Inflation Index
  • Client
Credit control area
  • Credit control area
  • Client
  • FAC_CDS_BSEG.KKBER == T014.KKBER
  • FAC_CDS_BSEG.MANDT == T014.MANDT
Customer Number
  • Customer Number
  • Client
  • FAC_CDS_BSEG.KUNNR == KNA1.KUNNR
  • FAC_CDS_BSEG.MANDT == KNA1.MANDT
Currency Key for the Group Currency
  • Currency Key for the Group Currency
  • Client
  • FAC_CDS_BSEG.KZWRS == TCURC.WAERS
  • FAC_CDS_BSEG.MANDT == TCURC.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • FAC_CDS_BSEG.LANDL == T005.LAND1
  • FAC_CDS_BSEG.MANDT == T005.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • FAC_CDS_BSEG.LIFNR == LFA1.LIFNR
  • FAC_CDS_BSEG.MANDT == LFA1.MANDT
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • FAC_CDS_BSEG.LZBKZ == T015L.LZBKZ
  • FAC_CDS_BSEG.MANDT == T015L.MANDT
Dunning Area
  • Company Code
  • Dunning Area
  • Client
  • FAC_CDS_BSEG.BUKRS == T047M.BUKRS
  • FAC_CDS_BSEG.MABER == T047M.MABER
  • FAC_CDS_BSEG.MANDT == T047M.MANDT
Dunning Block
  • Dunning Block
  • Client
  • FAC_CDS_BSEG.MANSP == T040S.MANSP
  • FAC_CDS_BSEG.MANDT == T040S.MANDT
Material Number
  • Material Number
  • Client
  • FAC_CDS_BSEG.MATNR == MARA.MATNR
  • FAC_CDS_BSEG.MANDT == MARA.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • FAC_CDS_BSEG.MEINS == T006.MSEHI
  • FAC_CDS_BSEG.MANDT == T006.MANDT
Dunning Key
  • Dunning Key
  • Client
  • FAC_CDS_BSEG.MSCHL == T040.MSCHL
  • FAC_CDS_BSEG.MANDT == T040.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • FAC_CDS_BSEG.MWSKZ == T007A.MWSKZ
  • FAC_CDS_BSEG.RLDNR == T007A.MWSKZ
  • FAC_CDS_BSEG.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_CDS_BSEG.MANDT == T007A.MANDT
Trading partner's business area
  • Trading partner's business area
  • Client
  • FAC_CDS_BSEG.PARGB == TGSB.GSBER
  • FAC_CDS_BSEG.MANDT == TGSB.MANDT
Partner Profit Center
  • Posting Date in the Document
  • ?
  • Client
  • Partner Profit Center
  • FAC_CDS_BSEG.BUDAT == CEPC.DATBI
  • FAC_CDS_BSEG.[column in domain "KOKRS"] == CEPC.KOKRS
  • FAC_CDS_BSEG.MANDT == CEPC.MANDT
  • FAC_CDS_BSEG.PPRCTR == CEPC.PRCTR
Currency for Automatic Payment
  • Client
  • Currency for Automatic Payment
  • FAC_CDS_BSEG.MANDT == TCURC.MANDT
  • FAC_CDS_BSEG.PYCUR == TCURC.WAERS
Withholding Tax Code
  • Withholding Tax Code
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • FAC_CDS_BSEG.QSSKZ == T059Q.QSSKZ
  • FAC_CDS_BSEG.SHTO_LAND1_TXT == T059Q.LAND1
  • FAC_CDS_BSEG.SHTO_LAND1 == T059Q.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1_TXT == T059Q.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1 == T059Q.LAND1
  • FAC_CDS_BSEG.MANDT == T059Q.MANDT
Recovery Indicator
  • Recovery Indicator
  • Company Code
  • Client
  • FAC_CDS_BSEG.RECID == T8JJ.RECID
  • FAC_CDS_BSEG.BUKRS == T8JJ.BUKRS
  • FAC_CDS_BSEG.MANDT == T8JJ.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • FAC_CDS_BSEG.SHTO_LAND1_TXT == T005S.LAND1
  • FAC_CDS_BSEG.SHTO_LAND1 == T005S.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1_TXT == T005S.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1 == T005S.LAND1
  • FAC_CDS_BSEG.REGIO == T005S.BLAND
  • FAC_CDS_BSEG.MANDT == T005S.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • FAC_CDS_BSEG.MWSKZ == T007A.MWSKZ
  • FAC_CDS_BSEG.RLDNR == T007A.MWSKZ
  • FAC_CDS_BSEG.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_CDS_BSEG.MANDT == T007A.MANDT
Transaction type
  • Transaction type
  • Client
  • FAC_CDS_BSEG.RMVCT == T856.TRTYP
  • FAC_CDS_BSEG.MANDT == T856.MANDT
Reason Code for Payments
  • Company Code
  • Reason Code for Payments
  • Client
  • FAC_CDS_BSEG.BUKRS == T053R.BUKRS
  • FAC_CDS_BSEG.RSTGR == T053R.RSTGR
  • FAC_CDS_BSEG.MANDT == T053R.MANDT
G/L Account Number
  • G/L Account Number
  • Company Code
  • Client
  • FAC_CDS_BSEG.SAKNR == SKB1.SAKNR
  • FAC_CDS_BSEG.BUKRS == SKB1.BUKRS
  • FAC_CDS_BSEG.MANDT == SKB1.MANDT
Section Code
  • Section Code
  • Company Code
  • Client
  • FAC_CDS_BSEG.SECCO == SECCODE.SECCODE
  • FAC_CDS_BSEG.BUKRS == SECCODE.BUKRS
  • FAC_CDS_BSEG.MANDT == SECCODE.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • FAC_CDS_BSEG.SHTO_LAND1_TXT == T005.LAND1
  • FAC_CDS_BSEG.SHTO_LAND1 == T005.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1_TXT == T005.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1 == T005.LAND1
  • FAC_CDS_BSEG.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • FAC_CDS_BSEG.SHTO_LAND1_TXT == T005.LAND1
  • FAC_CDS_BSEG.SHTO_LAND1 == T005.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1_TXT == T005.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1 == T005.LAND1
  • FAC_CDS_BSEG.MANDT == T005.MANDT
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • FAC_CDS_BSEG.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • FAC_CDS_BSEG.MANDT == TTXJ.MANDT
  • FAC_CDS_BSEG.TXJCD == TTXJ.TXJCD
Special G/L Indicator
  • Special G/L Indicator
  • ?
  • Client
  • FAC_CDS_BSEG.UMSKZ == T074U.UMSKZ
  • FAC_CDS_BSEG.[column in domain "KOART"] == T074U.KOART
  • FAC_CDS_BSEG.MANDT == T074U.MANDT
Payment method supplement
  • Client
  • Payment method supplement
  • FAC_CDS_BSEG.MANDT == T042F.MANDT
  • FAC_CDS_BSEG.UZAWE == T042F.UZAWE
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FAC_CDS_BSEG.MANDT == T880.MANDT
  • FAC_CDS_BSEG.VBUND == T880.RCOMP
Sales organization in order header
  • Sales Organization
  • Client
  • FAC_CDS_BSEG.VKORG == TVKO.VKORG
  • FAC_CDS_BSEG.MANDT == TVKO.MANDT
Joint venture
  • Joint venture
  • Company Code
  • Client
  • FAC_CDS_BSEG.VNAME == T8JV.VNAME
  • FAC_CDS_BSEG.BUKRS == T8JV.BUKRS
  • FAC_CDS_BSEG.MANDT == T8JV.MANDT
Partner account number
  • Client
  • Partner account number
  • FAC_CDS_BSEG.MANDT == KNA1.MANDT
  • FAC_CDS_BSEG.VPTNR == KNA1.KUNNR
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • FAC_CDS_BSEG.VKORG == TVKOV.VKORG
  • FAC_CDS_BSEG.VTWEG == TVKOV.VTWEG
  • FAC_CDS_BSEG.MANDT == TVKOV.MANDT
Currency Key
  • Client
  • Currency Key
  • FAC_CDS_BSEG.MANDT == TCURC.MANDT
  • FAC_CDS_BSEG.WAERS == TCURC.WAERS
Plant
  • Plant
  • Client
  • FAC_CDS_BSEG.WERKS == T001W.WERKS
  • FAC_CDS_BSEG.MANDT == T001W.MANDT
Payment Method
  • Payment Method
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • FAC_CDS_BSEG.ZLSCH == T042Z.ZLSCH
  • FAC_CDS_BSEG.SHTO_LAND1_TXT == T042Z.LAND1
  • FAC_CDS_BSEG.SHTO_LAND1 == T042Z.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1_TXT == T042Z.LAND1
  • FAC_CDS_BSEG.BLTO_LAND1 == T042Z.LAND1
  • FAC_CDS_BSEG.MANDT == T042Z.MANDT
Payment Block Key
  • Client
  • Payment Block Key
  • FAC_CDS_BSEG.MANDT == T008.MANDT
  • FAC_CDS_BSEG.ZLSPR == T008.ZAHLS
Target Special G/L Indicator
  • Account type
  • Target Special G/L Indicator
  • Client
  • FAC_CDS_BSEG.KOART == T074U.KOART
  • FAC_CDS_BSEG.ZUMSK == T074U.UMSKZ
  • FAC_CDS_BSEG.MANDT == T074U.MANDT