fac_cds_bseg_bkpf

Entry view BSEG/ BSEG_ADD with association to Header | view: FACV_BSEG_BKPF | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BSEC, BSEG, BSEG_ADD, VBAK, TIBAN, KNA1, LFA1, SKB1, T001, T001W, T005, T880
Column Name Description
bukrs FK Company Code
belnr Document Number of an Accounting Document
gjahr Fiscal Year
rldnr null
buzei Six-figure number of line item
Column Name Description
dmbtr Amount in local currency
wrbtr Amount in transaction currency
dmbe2 Amount in Second Local Currency
dmbe3 Amount in Third Local Currency
dmsol Amount in local currency
dmhab Amount in local currency
wrsol Amount in transaction currency
wrhab Amount in transaction currency
dmso2 Amount in Second Local Currency
dmha2 Amount in Second Local Currency
dmso3 Amount in Third Local Currency
dmha3 Amount in Third Local Currency
Column Name Description
menge Quantity
Column Name Description
augdt Clearing Date
dabrz Reference date for settlement
prodper Production Month (Date to find period and year)
zfbdt Baseline Date for Due Date Calculation
valut Value date
bsec_dataaging Data Filter Value for Data Aging
bsec_iban_valid_from Validity Start of IBAN
Column Name Description
koart Account type Show values
shkzg Debit/Credit Indicator Show values
xnegp Indicator: Negative Posting Show values
xauto Indicator: Line item automatically created Show values
bsec_stkzu Liable for VAT Show values
bsec_stkza Indicator: Business Partner Subject to Equalization Tax? Show values
bsec_dtams Report key for data medium exchange Show values
bsec_xcpdk Indicator: Is the account a one-time account? Show values
bsec_stkzn Natural Person Show values
bsec_xrguh Indicator: Bank Details from REGUH Show values
bsec_po_box_num Flag: PO Box Without Number Show values
Column Name Description Domain name
sgtxt Item Text TEXT50
zuonr Assignment number ZUONR
txbfw null
xskrl null
hwmet null
hwbas null
fwbas null
kursr null
augbl Document Number of the Clearing Document BELNR
landl Supplying Country/Region LAND1
lzbkz null
xegdr null
stceg null
egbld null
hbkid null
hktid null
ccbtc Payment cards: Settlement run CCBTC
uzawe Payment method supplement UZAWE
kidno null
rstgr null
xref1 Business Partner Reference Key CHAR12
xref2 Business Partner Reference Key CHAR12
xref3 Reference key for line item CHAR20
segment Segment for Segmental Reporting FB_SEGMENT
psegment Partner Segment for Segmental Reporting FB_SEGMENT
gsber Business Area GSBER
pargb Trading partner's business area GSBER
KDAUF null
KDPOS null
KDEIN null
ebeln null
ebelp null
zekkn null
pernr null
abper null
paobjnr Profitability Segment Number (CO-PA) RKEOBJNR
projk 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
gmvkz null
srtype null
fkber Functional Area FKBER
pfkber Partner Functional Area FKBER
qsskz Withholding Tax Code QSSKZ
mwart null
pays_prov null
qsfbt null
qsshb null
gityp null
gricd null
grirg null
idxsp null
lifnr null
kunnr null
filkd null
umskz null
umsks null
zumsk null
hzuon null
wskto null
sknto null
skfbt null
zterm null
zbd1p null
zbd1t null
zbd2p null
zbd2t null
zbd3t null
zbfix null
zlspr null
zlsch null
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
fdlev null
fdgrp null
empfb null
bvtyp null
saknr null
xcpdd null
diekz null
samnr null
vertn null
vertt null
vbewa null
dtws1 null
dtws2 null
dtws3 null
dtws4 null
pycur null
pyamt null
mndid null
maber null
madat null
manst null
mansp null
mschl null
kkber null
cession_kz null
zinkz null
btype null
vrskz null
vrsdt null
anfbn null
anfbu null
anfbj null
xinve null
zollt null
zolld null
vbeln null
nebtr null
qsznr null
qbshb null
bsec_name1 Name 1 NAME
bsec_name2 Name 2 NAME
bsec_name3 Name 3 NAME
bsec_name4 Name 4 NAME
bsec_pstlz Postal Code PSTLZ
bsec_ort01 City TEXT35
bsec_stras Street and House Number TEXT35
bsec_pfach PO Box PFACH
bsec_pstl2 P.O. Box Postal Code PSTLZ
bsec_pskto PO Bank Current Acct No. or Building Society Ref. No. PSKTO
bsec_bankn Bank account number BANKN
bsec_bankl Bank Keys BANKK
bsec_stcd1 Tax Number 1 STCD1
bsec_stcd2 Tax Number 2 STCD2
bsec_bkont Bank Control Key BKONT
bsec_dtaws Instruction Key for Data Medium Exchange DTAWS
bsec_empfg Payment Recipient Code EMPFG
bsec_stcd3 Tax Number 3 CHAR18
bsec_stcd4 Tax Number 4 CHAR18
bsec_bkref Reference Details for Bank Details CHAR20
bsec_j_1kfrepre Name of Representative REPRES
bsec_anred Title TEXT15
bsec_adrnr Address ADRNR
bsec_begru Authorization Group BEGRU
bsec_iban IBAN (International Bank Account Number) IBAN
vkorg null
vtweg null
kna1_land1 Customer Country/Region LAND1
kna1_stceg null
kna1_begru null
kna1_xcpdk null
regio null
brsch null
kunnr_txt null
lifnr_txt null
lfa1_stceg null
lfa1_land1 Supplier Country/Region LAND1
lfa1_begru null
lfa1_xcpdk null
skb1_begru Authorization Group BRGRU
land1 Country/Region Key LAND1
bukrs_txt Name of Company Code or Company TEXT25
vbund_txt Company name TEXT30
werks_txt Name TEXT30
bzdat null
anbwa Asset Transaction Type BWASL
Master Data Relations | to Other Relations ↓ Join Conditions
Order Number
  • Client
  • Order Number
  • FAC_CDS_BSEG_BKPF.MANDT == AUFK.MANDT
  • FAC_CDS_BSEG_BKPF.AUFNR == AUFK.AUFNR
Posting Key
  • Client
  • Posting Key
  • FAC_CDS_BSEG_BKPF.MANDT == TBSL.MANDT
  • FAC_CDS_BSEG_BKPF.BSCHL == TBSL.BSCHL
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • FAC_CDS_BSEG_BKPF.MANDT == T005.MANDT
  • FAC_CDS_BSEG_BKPF.BSEC_BANKS == T005.LAND1
Tax type
  • Account type
  • Client
  • Tax type
  • FAC_CDS_BSEG_BKPF.KOART == J_1AFITP.KOART
  • FAC_CDS_BSEG_BKPF.MANDT == J_1AFITP.MANDT
  • FAC_CDS_BSEG_BKPF.BSEC_FITYP == J_1AFITP.J_1AFITP
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Company Code Country/Region
  • Client
  • FAC_CDS_BSEG_BKPF.BSEC_LAND1 == T005.LAND1
  • FAC_CDS_BSEG_BKPF.LAND1 == T005.LAND1
  • FAC_CDS_BSEG_BKPF.T001_LAND1 == T005.LAND1
  • FAC_CDS_BSEG_BKPF.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Country/Region Key
  • Company Code Country/Region
  • Client
  • Region (State, Province, County)
  • FAC_CDS_BSEG_BKPF.BSEC_LAND1 == T005S.LAND1
  • FAC_CDS_BSEG_BKPF.LAND1 == T005S.LAND1
  • FAC_CDS_BSEG_BKPF.T001_LAND1 == T005S.LAND1
  • FAC_CDS_BSEG_BKPF.MANDT == T005S.MANDT
  • FAC_CDS_BSEG_BKPF.BSEC_REGIO == T005S.BLAND
Language Key FAC_CDS_BSEG_BKPF.BSEC_SPRAS == T002.SPRAS
J_1ATODC
  • Client
  • Tax Number Type
  • FAC_CDS_BSEG_BKPF.MANDT == J_1ATODC.MANDT
  • FAC_CDS_BSEG_BKPF.BSEC_STCDT == J_1ATODC.J_1ATODC
Company Code
  • Company Code
  • Client
  • FAC_CDS_BSEG_BKPF.BUKRS == T001.BUKRS
  • FAC_CDS_BSEG_BKPF.MANDT == T001.MANDT
Business Place
  • Company Code
  • Client
  • Business Place
  • ?
  • FAC_CDS_BSEG_BKPF.BUKRS == J_1BBRANCH.BUKRS
  • FAC_CDS_BSEG_BKPF.MANDT == J_1BBRANCH.MANDT
  • FAC_CDS_BSEG_BKPF.BUPLA == J_1BBRANCH.BRANCH
  • FAC_CDS_BSEG_BKPF.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
Equity group
  • Company Code
  • Client
  • Joint venture
  • Equity group
  • FAC_CDS_BSEG_BKPF.BUKRS == T8JF.BUKRS
  • FAC_CDS_BSEG_BKPF.MANDT == T8JF.MANDT
  • FAC_CDS_BSEG_BKPF.VNAME == T8JF.VNAME
  • FAC_CDS_BSEG_BKPF.EGRUP == T8JF.EGRUP
General Ledger Account
  • Company Code
  • Client
  • General Ledger Account
  • FAC_CDS_BSEG_BKPF.BUKRS == SKA1.KTOPL
  • FAC_CDS_BSEG_BKPF.MANDT == SKA1.MANDT
  • FAC_CDS_BSEG_BKPF.HKONT == SKA1.SAKNR
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • FAC_CDS_BSEG_BKPF.MANDT == T683.MANDT
  • FAC_CDS_BSEG_BKPF.[column in domain "KVEWE"] == T683.KVEWE
  • FAC_CDS_BSEG_BKPF.[column in domain "KAPPL"] == T683.KAPPL
  • FAC_CDS_BSEG_BKPF.KALSM == T683.KALSM
Controlling Area
  • Client
  • Controlling Area
  • FAC_CDS_BSEG_BKPF.MANDT == TKA01.MANDT
  • FAC_CDS_BSEG_BKPF.KOKRS == TKA01.KOKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • FAC_CDS_BSEG_BKPF.MANDT == T004.MANDT
  • FAC_CDS_BSEG_BKPF.KTOPL == T004.KTOPL
Material Number
  • Client
  • Material Number
  • FAC_CDS_BSEG_BKPF.MANDT == MARA.MANDT
  • FAC_CDS_BSEG_BKPF.MATNR_EXT == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • FAC_CDS_BSEG_BKPF.MANDT == T006.MANDT
  • FAC_CDS_BSEG_BKPF.MEINS == T006.MSEHI
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • FAC_CDS_BSEG_BKPF.MANDT == T007A.MANDT
  • FAC_CDS_BSEG_BKPF.MWSKZ == T007A.MWSKZ
  • FAC_CDS_BSEG_BKPF.[column in domain "KALSM_D"] == T007A.KALSM
Partner Profit Center
  • Client
  • Partner Profit Center
  • Controlling Area
  • ?
  • FAC_CDS_BSEG_BKPF.MANDT == CEPC.MANDT
  • FAC_CDS_BSEG_BKPF.PPRCTR == CEPC.PRCTR
  • FAC_CDS_BSEG_BKPF.KOKRS == CEPC.KOKRS
  • FAC_CDS_BSEG_BKPF.[column in domain "DATBI"] == CEPC.DATBI
Profit Center
  • Client
  • Controlling Area
  • ?
  • Profit Center
  • FAC_CDS_BSEG_BKPF.MANDT == CEPC.MANDT
  • FAC_CDS_BSEG_BKPF.KOKRS == CEPC.KOKRS
  • FAC_CDS_BSEG_BKPF.[column in domain "DATBI"] == CEPC.DATBI
  • FAC_CDS_BSEG_BKPF.PRCTR == CEPC.PRCTR
Recovery Indicator
  • Company Code
  • Client
  • Recovery Indicator
  • FAC_CDS_BSEG_BKPF.BUKRS == T8JJ.BUKRS
  • FAC_CDS_BSEG_BKPF.MANDT == T8JJ.MANDT
  • FAC_CDS_BSEG_BKPF.RECID == T8JJ.RECID
Consolidation Transaction Type
  • Client
  • Consolidation Transaction Type
  • FAC_CDS_BSEG_BKPF.MANDT == T856.MANDT
  • FAC_CDS_BSEG_BKPF.RMVCT == T856.TRTYP
Section Code
  • Company Code
  • Client
  • Section Code
  • FAC_CDS_BSEG_BKPF.BUKRS == SECCODE.BUKRS
  • FAC_CDS_BSEG_BKPF.MANDT == SECCODE.MANDT
  • FAC_CDS_BSEG_BKPF.SECCO == SECCODE.SECCODE
Company Code Country/Region
  • Country/Region Key
  • Country/Region Key
  • Company Code Country/Region
  • Client
  • FAC_CDS_BSEG_BKPF.BSEC_LAND1 == T005.LAND1
  • FAC_CDS_BSEG_BKPF.LAND1 == T005.LAND1
  • FAC_CDS_BSEG_BKPF.T001_LAND1 == T005.LAND1
  • FAC_CDS_BSEG_BKPF.MANDT == T005.MANDT
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • FAC_CDS_BSEG_BKPF.MANDT == TTXJ.MANDT
  • FAC_CDS_BSEG_BKPF.TXJCD == TTXJ.TXJCD
  • FAC_CDS_BSEG_BKPF.KALSM == TTXJ.KALSM
Company ID
  • Client
  • Company ID
  • FAC_CDS_BSEG_BKPF.MANDT == T880.MANDT
  • FAC_CDS_BSEG_BKPF.VBUND == T880.RCOMP
Joint venture
  • Company Code
  • Client
  • Joint venture
  • FAC_CDS_BSEG_BKPF.BUKRS == T8JV.BUKRS
  • FAC_CDS_BSEG_BKPF.MANDT == T8JV.MANDT
  • FAC_CDS_BSEG_BKPF.VNAME == T8JV.VNAME
Partner account number
  • Client
  • Partner account number
  • FAC_CDS_BSEG_BKPF.MANDT == KNA1.MANDT
  • FAC_CDS_BSEG_BKPF.VPTNR == KNA1.KUNNR
Plant
  • Client
  • Plant
  • FAC_CDS_BSEG_BKPF.MANDT == T001W.MANDT
  • FAC_CDS_BSEG_BKPF.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Type of Business
  • Client
  • Type of Business
  • FAC_CDS_BSEG_BKPF.MANDT == BUSTYPE.MANDT
  • FAC_CDS_BSEG_BKPF.BSEC_J_1KFTBUS == BUSTYPE.GESTYP
Type of Industry
  • Type of Industry
  • Client
  • FAC_CDS_BSEG_BKPF.BSEC_J_1KFTIND == INDUSTYPE.INDTYPE
  • FAC_CDS_BSEG_BKPF.MANDT == INDUSTYPE.MANDT