fis_cds_bseg

CDS View for Accounting Document Item | view: FISV_CDS_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, TKA02, TVKOT, TVTWT
Column Name Description
Column Name Description
transaction_currency_amount Amount in document currency
local_currency_amount Amount in local currency
local_currency_amount_debit Amount in local currency
local_currency_amount_credit Amount in local currency
group_currency_amount Amount in Second Local Currency or Global Currency
Column Name Description
📏 Base Unit of Measure (unit_of_measure):
quantity Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
document_number Document Number of an Accounting Document BELNR
fiscal_year Fiscal Year GJAHR
line_item_number Number of Line Item Within Accounting Document BUZEI
cost_center Cost Center KOSTL
profit_center Profit Center PRCTR
segment Segment for Segmental Reporting FB_SEGMENT
functional_area Functional Area FKBER_SHORT
item_text Item Text TEXT50
billing_document Billing Document VBELN
sales_document Sales Document VBELN
sales_document_item Sales Document Item POSNR
wbs_element Work Breakdown Structure Element (WBS Element) PS_POSNR
account_description_short G/L Account Short Text TEXT20
account_description_long G/L Account Long Text TEXT50
company_name Name of Company Code or Company TEXT25
segment_name Text Field TEXT50
functional_area_name Name of the functional area TEXT25
customer_name Name 1 NAME
cost_center_name null
profit_center_name null
trading_partner_name Company name TEXT30
article_name Material Description TEXT40
sales_organization_name Name TEXT20
distribution_channel_name Name TEXT20
region_name Description TEXT20
industry_name Description of the Industry Key TEXT20
ux_fc_general_ledger_account null
ux_fc_cost_center null
ux_fc_profit_center null
ux_fc_item_text null
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • FIS_CDS_BSEG.MANDT == MARA.MANDT
  • FIS_CDS_BSEG.ARTICLE == MARA.MATNR
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • FIS_CDS_BSEG.MANDT == T005.MANDT
  • FIS_CDS_BSEG.BILLED_TO_COUNTRY_NAME == T005.LAND1
  • FIS_CDS_BSEG.SHIPPED_TO_COUNTRY == T005.LAND1
  • FIS_CDS_BSEG.SHIPPED_TO_COUNTRY_NAME == T005.LAND1
  • FIS_CDS_BSEG.BILLED_TO_COUNTRY == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • FIS_CDS_BSEG.MANDT == T005.MANDT
  • FIS_CDS_BSEG.BILLED_TO_COUNTRY_NAME == T005.LAND1
  • FIS_CDS_BSEG.SHIPPED_TO_COUNTRY == T005.LAND1
  • FIS_CDS_BSEG.SHIPPED_TO_COUNTRY_NAME == T005.LAND1
  • FIS_CDS_BSEG.BILLED_TO_COUNTRY == T005.LAND1
Company Code
  • Client
  • Company Code
  • FIS_CDS_BSEG.MANDT == T001.MANDT
  • FIS_CDS_BSEG.COMPANY_CODE == T001.BUKRS
Customer Number
  • Client
  • Customer Number
  • FIS_CDS_BSEG.MANDT == KNA1.MANDT
  • FIS_CDS_BSEG.CUSTOMER == KNA1.KUNNR
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • FIS_CDS_BSEG.MANDT == TVKOV.MANDT
  • FIS_CDS_BSEG.SALES_ORGANIZATION == TVKOV.VKORG
  • FIS_CDS_BSEG.DISTRIBUTION_CHANNEL == TVKOV.VTWEG
General Ledger Account
  • General Ledger Account
  • Client
  • Company Code
  • FIS_CDS_BSEG.GENERAL_LEDGER_ACCOUNT == SKB1.SAKNR
  • FIS_CDS_BSEG.MANDT == SKB1.MANDT
  • FIS_CDS_BSEG.COMPANY_CODE == SKB1.BUKRS
Currency Key for the Group Currency
  • Client
  • Currency Key for the Group Currency
  • FIS_CDS_BSEG.MANDT == TCURC.MANDT
  • FIS_CDS_BSEG.GROUP_CURRENCY == TCURC.WAERS
Industry key
  • Industry key
  • Client
  • FIS_CDS_BSEG.INDUSTRY == T016.BRSCH
  • FIS_CDS_BSEG.MANDT == T016.MANDT
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • FIS_CDS_BSEG.MANDT == T005S.MANDT
  • FIS_CDS_BSEG.REGION == T005S.BLAND
  • FIS_CDS_BSEG.BILLED_TO_COUNTRY_NAME == T005S.LAND1
  • FIS_CDS_BSEG.SHIPPED_TO_COUNTRY == T005S.LAND1
  • FIS_CDS_BSEG.SHIPPED_TO_COUNTRY_NAME == T005S.LAND1
  • FIS_CDS_BSEG.BILLED_TO_COUNTRY == T005S.LAND1
Sales organization in order header
  • Client
  • Sales Organization
  • FIS_CDS_BSEG.MANDT == TVKO.MANDT
  • FIS_CDS_BSEG.SALES_ORGANIZATION == TVKO.VKORG
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • FIS_CDS_BSEG.MANDT == T005.MANDT
  • FIS_CDS_BSEG.BILLED_TO_COUNTRY_NAME == T005.LAND1
  • FIS_CDS_BSEG.SHIPPED_TO_COUNTRY == T005.LAND1
  • FIS_CDS_BSEG.SHIPPED_TO_COUNTRY_NAME == T005.LAND1
  • FIS_CDS_BSEG.BILLED_TO_COUNTRY == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • FIS_CDS_BSEG.MANDT == T005.MANDT
  • FIS_CDS_BSEG.BILLED_TO_COUNTRY_NAME == T005.LAND1
  • FIS_CDS_BSEG.SHIPPED_TO_COUNTRY == T005.LAND1
  • FIS_CDS_BSEG.SHIPPED_TO_COUNTRY_NAME == T005.LAND1
  • FIS_CDS_BSEG.BILLED_TO_COUNTRY == T005.LAND1
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FIS_CDS_BSEG.MANDT == T880.MANDT
  • FIS_CDS_BSEG.TRADING_PARTNER == T880.RCOMP
Currency Key
  • Client
  • Currency Key
  • FIS_CDS_BSEG.MANDT == TCURC.MANDT
  • FIS_CDS_BSEG.TRANSACTION_CURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • FIS_CDS_BSEG.MANDT == T006.MANDT
  • FIS_CDS_BSEG.UNIT_OF_MEASURE == T006.MSEHI