BSEG SAP table Accounting Document Segment Cluster data
In this post, I will try and describe everything you need to know about the SAP BSEG table which stores its data in a cluster format.
What it is, including what type of data it stores.
The global attributes that define the table.
A list of fields which make up the table structure.
And what relationships it has with other SAP tables.
Right let’s get started!
What is SAP BSEG Table?
BSEG is a standard SAP Cluster table which is used to store Accounting Document Segment data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Cluster table. You can view further information about SAP BSEG Cluster table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also, check out the Comments section below to view or add related contributions and example screenshots.
SAP BSEG Attributes
Table type: Cluster table
Delivery Class: A ( Application table containing master and transaction data )
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
==>View Table relationships
List of BSEG table fields within SAP data Dictionary
| Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
| MANDT | MANDT | CLNT | 3 | T000 | Client | |
| BUKRS | BUKRS | CHAR | 4 | T001 | Company Code | |
| BELNR | BELNR_D | CHAR | 10 | Accounting Document Number | ALPHA | |
| GJAHR | GJAHR | NUMC | 4 | Fiscal Year | GJAHR | |
| BUZEI | BUZEI | NUMC | 3 | Number of Line Item Within Accounting Document | ||
| BUZID | BUZID | CHAR | 1 | Identification of the Line Item | ||
| AUGDT | AUGDT | DATS | 8 | Clearing Date | ||
| AUGCP | AUGCP | DATS | 8 | Clearing Entry Date | ||
| AUGBL | AUGBL | CHAR | 10 | Document Number of the Clearing Document | ALPHA | |
| BSCHL | BSCHL | CHAR | 2 | TBSL | Posting Key | |
| KOART | KOART | CHAR | 1 | Account Type | ||
| UMSKZ | UMSKZ | CHAR | 1 | T074U | Special G/L Indicator | |
| UMSKS | UMSKS | CHAR | 1 | Special G/L Transaction Type | ||
| ZFIELD14 | DZUMSK | CHAR | 1 | T074U | Target Special G/L Indicator | |
| SHKZG | SHKZG | CHAR | 1 | Debit/Credit Indicator | ||
| GSBER | GSBER | CHAR | 4 | TGSB | Business Area | |
| PARGB | PARGB | CHAR | 4 | TGSB | Trading partner's business area | |
| MWSKZ | MWSKZ | CHAR | 2 | T007A | Tax on sales/purchases code | |
| QSSKZ | QSSKZ | CHAR | 2 | T059Q | Withholding Tax Code | |
| DMBTR | DMBTR | CURR | 13(2) | Amount in Local Currency | ||
| WRBTR | WRBTR | CURR | 13(2) | Amount in document currency | ||
| KZBTR | KZBTR_FI | CURR | 13(2) | Original Reduction Amount in Local Currency | ||
| PSWBT | PSWBT | CURR | 13(2) | Amount for Updating in General Ledger | ||
| PSWSL | PSWSL | CUKY | 5 | TCURC | Update Currency for General Ledger Transaction Figures | |
| TXBHW | TXBHW | CURR | 13(2) | Original Tax Base Amount in Local Currency | ||
| TXBFW | TXBFW | CURR | 13(2) | Original Tax Base Amount in Document Currency | ||
| MWSTS | MWSTS | CURR | 13(2) | Tax Amount in Local Currency | ||
| WMWST | WMWST | CURR | 13(2) | Tax amount in document currency | ||
| HWBAS | HWBAS | CURR | 13(2) | Tax Base Amount in Local Currency | ||
| FWBAS | FWBAS | CURR | 13(2) | Tax Base Amount in Document Currency | ||
| HWZUZ | HWZUZ | CURR | 13(2) | Provision Amount in Local Currency | ||
| FWZUZ | FWZUZ | CURR | 13(2) | Additional Tax in Document Currency | ||
| SHZUZ | SHZUZ | CHAR | 1 | Debit/Credit Addition for Cash Discount | ||
| STEKZ | CHAR2 | CHAR | 2 | Version Number Component | ||
| MWART | MWART | CHAR | 1 | Tax Type | ||
| TXGRP | TXGRP | NUMC | 3 | Group Indicator for Tax Line Items | ||
| KTOSL | KTOSL | CHAR | 3 | Transaction Key | ||
| QSSHB | QSSHB | CURR | 13(2) | Withholding Tax Base Amount | ||
| KURSR | KURSR | DEC | 9(5) | Hedged Exchange Rate | EXCRT | |
| GBETR | GBETR | CURR | 13(2) | Hedged Amount in Foreign Currency | ||
| BDIFF | BDIFF | CURR | 13(2) | Valuation Difference | ||
| BDIF2 | BDIF2 | CURR | 13(2) | Valuation Difference for the Second Local Currency | ||
| VALUT | VALUT | DATS | 8 | Value date | ||
| ZFIELD44 | DZUONR | CHAR | 18 | Assignment Number | ||
| SGTXT | SGTXT | CHAR | 50 | Item Text | ||
| ZFIELD46 | DZINKZ | CHAR | 2 | Exempted from interest calculation | ||
| VBUND | RASSC | CHAR | 6 | T880 | Company ID of trading partner | ALPHA |
| BEWAR | RMVCT | CHAR | 3 | T856 | Transaction Type | |
| ALTKT | BILKT_SKA1 | CHAR | 10 |
* | Group account number | ALPHA |
| VORGN | VORGN | CHAR | 4 | Transaction Type for General Ledger | ||
| FDLEV | FDLEV | CHAR | 2 | T036 | Planning level | |
| FDGRP | FDGRP | CHAR | 10 | T035 | Planning Group | ALPHA |
| FDWBT | FDWBT | CURR | 13(2) | Planning amount in document currency | ||
| FDTAG | FDTAG | DATS | 8 | Planning date | ||
| FKONT | FIPLS | NUMC | 3 | Financial Budget Item | ||
| KOKRS | KOKRS | CHAR | 4 | TKA01 | Controlling Area | |
| KOSTL | KOSTL | CHAR | 10 |
* | Cost Center | ALPHA |
| PROJN | PROJN | CHAR | 16 | Old: Project number : No longer used --> PS_POSNR | ||
| AUFNR | AUFNR | CHAR | 12 | AUFK | Order Number | ALPHA |
| VBELN | VBELN_VF | CHAR | 10 | VBUK | Billing Document | ALPHA |
| VBEL2 | VBELN_VA | CHAR | 10 | VBUK | Sales Document | ALPHA |
| POSN2 | POSNR_VA | NUMC | 6 | VBUP | Sales Document Item | |
| ETEN2 | ETENR | NUMC | 4 | VBEP | Delivery Schedule Line Number | |
| ANLN1 | ANLN1 | CHAR | 12 | ANLH | Main Asset Number | ALPHA |
| ANLN2 | ANLN2 | CHAR | 4 | ANLA | Asset Subnumber | ALPHA |
| ANBWA | ANBWA | CHAR | 3 | TABW | Asset Transaction Type | |
| BZDAT | BZDAT | DATS | 8 | Asset value date | ||
| PERNR | PERNR_D | NUMC | 8 | Personnel Number | ||
| XUMSW | XUMSW | CHAR | 1 | Indicator: Sales-related item ? | ||
| XHRES | XHRES | CHAR | 1 | Indicator: Resident G/L account? | ||
| XKRES | XKRES | CHAR | 1 | Indicator: Can Line Items Be Displayed by Account? | ||
| XOPVW | XOPVW | CHAR | 1 | Indicator: Open item management? | ||
| XCPDD | XCPDD | CHAR | 1 | Indicator: Address and bank data set individually | ||
| XSKST | XSKST | CHAR | 1 | Indicator: Statistical posting to cost center | ||
| XSAUF | XSAUF | CHAR | 1 | Indicator: Posting to order is statistical | ||
| XSPRO | XSPRO | CHAR | 1 | Indicator: Posting to project is statistical | ||
| XSERG | XSERG | CHAR | 1 | Indicator: Posting to prof.analysis is statistical | ||
| XFAKT | XFAKT | CHAR | 1 | Indicator: Billing document update successful ? | ||
| XUMAN | XUMAN | CHAR | 1 | Indicator: Transfer posting from down payment ? | ||
| XANET | XANET | CHAR | 1 | Indicator: Down payment in net procedure ? | ||
| XSKRL | XSKRL | CHAR | 1 | Indicator: Line item not liable to cash discount? | ||
| XINVE | XINVE | CHAR | 1 | Indicator: Capital Goods Affected? | ||
| XPANZ | XPANZ | CHAR | 1 | Display item | ||
| XAUTO | XAUTO | CHAR | 1 | Indicator: Line item automatically created | ||
| XNCOP | XNCOP | CHAR | 1 | Indicator: Items cannot be copied? | ||
| XZAHL | XZAHL | CHAR | 1 | Indicator: Is the posting key used in a payment transaction? | ||
| SAKNR | SAKNR | CHAR | 10 | SKB1 | G/L Account Number | ALPHA |
| HKONT | HKONT | CHAR | 10 | SKB1 | General Ledger Account | ALPHA |
| KUNNR | KUNNR | CHAR | 10 | KNA1 | Customer Number | ALPHA |
| LIFNR | LIFNR | CHAR | 10 | LFA1 | Account Number of Vendor or Creditor | ALPHA |
| FILKD | FILKD | CHAR | 10 | Account Number of the Branch | ALPHA | |
| XBILK | XBILK | CHAR | 1 | Indicator: Account is a balance sheet account? | ||
| GVTYP | GVTYP | CHAR | 2 | P&L statement account type | ||
| HZUON | HZUON | CHAR | 18 | Assignment Number for Special G/L Accounts | ||
| ZFIELD95 | DZFBDT | DATS | 8 | Baseline Date for Due Date Calculation | ||
| ZFIELD96 | DZTERM | CHAR | 4 | Terms of Payment Key | ||
| ZFIELD97 | DZBD1T | DEC | 3 | Cash discount days 1 | ||
| ZFIELD98 | DZBD2T | DEC | 3 | Cash discount days 2 | ||
| ZFIELD99 | DZBD3T | DEC | 3 | Net Payment Terms Period | ||
| ZFIELD100 | DZBD1P | DEC | 5(3) | Cash Discount Percentage 1 | ||
| ZFIELD101 | DZBD2P | DEC | 5(3) | Cash Discount Percentage 2 | ||
| SKFBT | SKFBT | CURR | 13(2) | Amount Eligible for Cash Discount in Document Currency | ||
| SKNTO | SKNTO | CURR | 13(2) | Cash discount amount in local currency | ||
| WSKTO | WSKTO | CURR | 13(2) | Cash discount amount in document currency | ||
| ZFIELD105 | SCHZW_BSEG | CHAR | 1 | T042Z | Payment Method | |
| ZFIELD106 | DZLSPR | CHAR | 1 | T008 | Payment Block Key | |
| ZFIELD107 | DZBFIX | CHAR | 1 | Fixed Payment Terms | ||
| HBKID | HBKID | CHAR | 5 | T012 | Short Key for a House Bank | |
| BVTYP | BVTYP | CHAR | 4 | Partner Bank Type | ||
| NEBTR | NEBTR | CURR | 13(2) | Net Payment Amount | ||
| MWSK1 | MWSKX | CHAR | 2 | T007A | Tax Code for Distribution | |
| DMBT1 | DMBTX | CURR | 13(2) | Amount in Local Currency for Tax Distribution | ||
| WRBT1 | WRBTX | CURR | 13(2) | Amount in foreign currency for tax breakdown | ||
| MWSK2 | MWSKX | CHAR | 2 | T007A | Tax Code for Distribution | |
| DMBT2 | DMBTX | CURR | 13(2) | Amount in Local Currency for Tax Distribution | ||
| WRBT2 | WRBTX | CURR | 13(2) | Amount in foreign currency for tax breakdown | ||
| MWSK3 | MWSKX | CHAR | 2 | T007A | Tax Code for Distribution | |
| DMBT3 | DMBTX | CURR | 13(2) | Amount in Local Currency for Tax Distribution | ||
| WRBT3 | WRBTX | CURR | 13(2) | Amount in foreign currency for tax breakdown | ||
| REBZG | REBZG | CHAR | 10 | Number of the Invoice the Transaction Belongs to | ALPHA | |
| REBZJ | REBZJ | NUMC | 4 | Fiscal Year of the Relevant Invoice (for Credit Memo) | GJAHR | |
| REBZZ | REBZZ | NUMC | 3 | Line Item in the Relevant Invoice | ||
| REBZT | REBZT | CHAR | 1 | Follow-On Document Type | ||
| ZFIELD124 | DZOLLT | CHAR | 8 | Customs Tariff Number | ||
| ZFIELD125 | DZOLLD | DATS | 8 | Customs Date | ||
| LZBKZ | LZBKZ | CHAR | 3 | T015L | State Central Bank Indicator | |
| LANDL | LANDL | CHAR | 3 | T005 | Supplying Country | |
| DIEKZ | DIEKZ | CHAR | 1 | Service Indicator (Foreign Payment) | ||
| SAMNR | SAMNR | NUMC | 8 | Invoice List Number | ||
| ABPER | ABPER_RF | ACCP | 6 | Settlement period | ||
| VRSKZ | VRSKZ | CHAR | 1 | Insurance indicator | ||
| VRSDT | VRSDT | DATS | 8 | Insurance date | ||
| DISBN | DISBN | CHAR | 10 | Number of Bill of Exchange Usage Document (Discount Doc.) | ALPHA | |
| DISBJ | DISBJ | NUMC | 4 | Fiscal Year of Bill of Exchange Usage Document | GJAHR | |
| DISBZ | DISBZ | NUMC | 3 | Line Item within the Bill of Exchange Usage Document | ||
| WVERW | WVERW | CHAR | 1 | Bill of exchange usage type | ||
| ANFBN | ANFBN | CHAR | 10 | Document Number of the Bill of Exchange Payment Request | ALPHA | |
| ANFBJ | ANFBJ | NUMC | 4 | Fiscal Year of the Bill of Exchange Payment Request Document | GJAHR | |
| ANFBU | ANFBU | CHAR | 4 | T001 | Company Code in Which Bill of Exch.Payment Request Is Posted | |
| ANFAE | ANFAE | DATS | 8 | Bill of Exchange Payment Request Due Date | ||
| BLNBT | BLNBT | CURR | 13(2) | Base Amount for Determining the Preference Amount | ||
| BLNKZ | BLNKZ | CHAR | 2 |
* | Subsidy indicator for determining the reduction rates | |
| BLNPZ | BLNPZ | DEC | 7(2) | Preference Percentage Rate | ||
| MSCHL | MSCHL | CHAR | 1 | T040 | Dunning key | |
| MANSP | MANSP | CHAR | 1 | T040S | Dunning block | |
| MADAT | MADAT | DATS | 8 | Last dunned on | ||
| MANST | MAHNS_D | NUMC | 1 | Dunning level | ||
| MABER | MABER | CHAR | 2 | T047M | Dunning Area | |
| ESRNR | ESRNR | CHAR | 11 | ISR Subscriber Number | ||
| ESRRE | ESRRE | CHAR | 27 | ISR Reference Number | ALPHA | |
| ESRPZ | ESRPZ | CHAR | 2 | ISR Check Digit | ||
| KLIBT | KLIBT | CURR | 13(2) | Credit Control Amount | ||
| QSZNR | QSZNR | CHAR | 10 | Certificate Number of the Withholding Tax Exemption | ||
| QBSHB | QBSHB | CURR | 13(2) | Withholding Tax Amount (in Document Currency) | ||
| QSFBT | QSFBT | CURR | 13(2) | Withholding Tax-Exempt Amount (in Document Currency) | ||
| NAVHW | NAVHW | CURR | 13(2) | Non-Deductible Input Tax (in Local Currency) | ||
| NAVFW | NAVFW | CURR | 13(2) | Non-Deductible Input Tax (in Document Currency) | ||
| MATNR | MATNR | CHAR | 18 | MARA | Material Number | MATN1 |
| WERKS | WERKS_D | CHAR | 4 | T001W | Plant | |
| MENGE | MENGE_D | QUAN | 13(3) | Quantity | ||
| MEINS | MEINS | UNIT | 3 | T006 | Base Unit of Measure | CUNIT |
| ERFMG | ERFMG | QUAN | 13(3) | Quantity in Unit of Entry | ||
| ERFME | ERFME | UNIT | 3 | T006 | Unit of Entry | CUNIT |
| BPMNG | BPMNG | QUAN | 13(3) | Quantity in Purchase Order Price Unit | ||
| BPRME | BPRME | UNIT | 3 | T006 | Order Price Unit (Purchasing) | CUNIT |
| EBELN | EBELN | CHAR | 10 | EKKO | Purchasing Document Number | ALPHA |
| EBELP | EBELP | NUMC | 5 | EKPO | Item Number of Purchasing Document | |
| ZFIELD168 | DZEKKN | NUMC | 2 | Sequential Number of Account Assignment | ||
| ELIKZ | ELIKZ | CHAR | 1 | "Delivery Completed" Indicator | ||
| VPRSV | VPRSV | CHAR | 1 | Price control indicator | ||
| PEINH | PEINH | DEC | 5 | Price Unit | ||
| BWKEY | BWKEY | CHAR | 4 | T001K | Valuation Area | |
| BWTAR | BWTAR_D | CHAR | 10 | T149D | Valuation Type | |
| BUSTW | BUSTW | CHAR | 4 | Posting string for values | ||
| REWRT | REEWR | CURR | 13(2) | Invoice Value Entered (in Local Currency) | ||
| REWWR | REFWR | CURR | 13(2) | Invoice value in foreign currency | ||
| BONFB | BONFB | CURR | 13(2) | Amount Qualifying for Bonus in Local Currency | ||
| BUALT | BUALT | CURR | 13(2) | Amount posted in alternative price control | ||
| PSALT | PSALT | CHAR | 1 | Alternative Price Control | ||
| NPREI | NPREI | CURR | 11(2) | New price | ||
| TBTKZ | TBTKZ | CHAR | 1 | Indicator: subsequent debit/credit | ||
| SPGRP | SPGRP | CHAR | 1 | Blocking reason: price | ||
| SPGRM | SPGRM | CHAR | 1 | Blocking reason: quantity | ||
| SPGRT | SPGRT | CHAR | 1 | Blocking Reason: Date | ||
| SPGRG | SPGRG | CHAR | 1 | Blocking reason: order price quantity | ||
| SPGRV | SPGRV | CHAR | 1 | Blocking reason: project budget | ||
| SPGRQ | SPGRQ | CHAR | 1 | Manual Blocking Reason | ||
| STCEG | STCEG | CHAR | 20 | VAT Registration Number | ||
| EGBLD | EGBLD | CHAR | 3 | T005 | Country of Destination for Delivery of Goods | |
| EGLLD | EGLLD | CHAR | 3 | T005 | Supplying Country for Delivery of Goods | |
| RSTGR | RSTGR | CHAR | 3 | T053R | Reason Code for Payments | |
| RYACQ | RYACQ | CHAR | 4 | Year of acquisition | GJAHR | |
| RPACQ | RPACQ | NUMC | 3 | Period of Acquisition | ||
| RDIFF | RDIFF | CURR | 13(2) | Exchange Rate Gain/Loss Realized | ||
| RDIF2 | RDIF2 | CURR | 13(2) | Exchange Rate Difference Realized for Second Local Currency | ||
| PRCTR | PRCTR | CHAR | 10 |
* | Profit Center | ALPHA |
| XHKOM | XHKOM | CHAR | 1 | Indicator: G/L account assigned manually ? | ||
| VNAME | JV_NAME | CHAR | 6 | T8JV | Joint Venture | ALPHA |
| RECID | JV_RECIND | CHAR | 2 | T8JJ | Recovery Indicator | ALPHA |
| EGRUP | JV_EGROUP | CHAR | 3 | T8JF | Equity group | ALPHA |
| VPTNR | JV_PART | CHAR | 10 | KNA1 | Partner account number | ALPHA |
| VERTT | RANTYP | CHAR | 1 | Contract Type | ||
| VERTN | RANL | CHAR | 13 | Contract Number | ALPHA | |
| VBEWA | SBEWART | CHAR | 4 |
* | Flow Type | |
| DEPOT | RLDEPO | CHAR | 10 |
* | Securities Account | |
| TXJCD | TXJCD | CHAR | 15 | TTXJ | Tax Jurisdiction | |
| IMKEY | IMKEY | CHAR | 8 | Internal Key for Real Estate Object | IMKEY | |
| DABRZ | DABRBEZ | DATS | 8 | Reference Date for Settlement | ||
| POPTS | POPTSATZ | DEC | 9(6) | Real estate option rate | ||
| FIPOS | FIPOS | CHAR | 14 |
* | Commitment Item | FMCIS |
| KSTRG | KSTRG | CHAR | 12 |
* | Cost Object | |
| NPLNR | NPLNR | CHAR | 12 |
* | Network Number for Account Assignment | ALPHA |
| AUFPL | AUFPL_CH | NUMC | 10 | Task list number for operations in order | ||
| APLZL | APLZL_CH | NUMC | 8 |
* | General counter for order | |
| PROJK | PS_PSP_PNR | NUMC | 8 |
* | Work Breakdown Structure Element (WBS Element) | ABPSP |
| PAOBJNR | RKEOBJNR | NUMC | 10 | Profitability Segment Number (CO-PA) | ||
| PASUBNR | RKESUBNR | NUMC | 4 | Profitability segment changes (CO-PA) | ||
| SPGRS | SPGRS | CHAR | 1 | Blocking Reason: Item Amount | ||
| SPGRC | SPGRC | CHAR | 1 | Block.reason: quality | ||
| BTYPE | JV_BILIND | CHAR | 2 | T8JA | Payroll Type | ALPHA |
| ETYPE | JV_ETYPE | CHAR | 3 | T8JE | Equity type | ALPHA |
| XEGDR | XEGDR | CHAR | 1 | Indicator: Triangular deal within the EU ? | ||
| LNRAN | LNRAN | NUMC | 5 |
* | Sequence number of asset line items in fiscal year | |
| HRKFT | HRKFT | CHAR | 4 |
* | Origin Group as Subdivision of Cost Element | |
| DMBE2 | DMBE2 | CURR | 13(2) | Amount in Second Local Currency | ||
| DMBE3 | DMBE3 | CURR | 13(2) | Amount in Third Local Currency | ||
| DMB21 | DMB2X | CURR | 13(2) | Amount in Second Local Currency for Tax Breakdown | ||
| DMB22 | DMB2X | CURR | 13(2) | Amount in Second Local Currency for Tax Breakdown | ||
| DMB23 | DMB2X | CURR | 13(2) | Amount in Second Local Currency for Tax Breakdown | ||
| DMB31 | DMB3X | CURR | 13(2) | Amount in Third Local Currency for Tax Breakdown | ||
| DMB32 | DMB3X | CURR | 13(2) | Amount in Third Local Currency for Tax Breakdown | ||
| DMB33 | DMB3X | CURR | 13(2) | Amount in Third Local Currency for Tax Breakdown | ||
| MWST2 | MWST2 | CURR | 13(2) | Tax Amount in Second Local Currency | ||
| MWST3 | MWST3 | CURR | 13(2) | Tax Amount in Third Local Currency | ||
| NAVH2 | NAVH2 | CURR | 13(2) | Non-Deductible Input Tax in Second Local Currency | ||
| NAVH3 | NAVH3 | CURR | 13(2) | Non-Deductible Input Tax in Third Local Currency | ||
| SKNT2 | SKNT2 | CURR | 13(2) | Cash Discount Amount in Second Local Currency | ||
| SKNT3 | SKNT3 | CURR | 13(2) | Cash Discount Amount in Third Local Currency | ||
| BDIF3 | BDIF3 | CURR | 13(2) | Valuation Difference for the Third Local Currency | ||
| RDIF3 | RDIF3 | CURR | 13(2) | Exchange Rate Difference Realized for Third Local Currency | ||
| HWMET | HWMET | CHAR | 1 | Method with Which the Local Currency Amount Was Determined | ||
| GLUPM | GLUPM | CHAR | 1 | Update Method for FM - FI-CA Integration | ||
| XRAGL | XRAGL | CHAR | 1 | Indicator: Clearing was Reversed | ||
| UZAWE | UZAWE | CHAR | 2 | T042F | Payment Method Supplement | |
| LOKKT | ALTKT_SKB1 | CHAR | 10 |
* | Alternative account number in company code | ALPHA |
| FISTL | FISTL | CHAR | 16 |
* | Funds Center | |
| GEBER | BP_GEBER | CHAR | 10 |
* | Fund | |
| STBUK | STBUK | CHAR | 4 |
* | Tax Company Code | |
| TXBH2 | TXBH2 | CURR | 13(2) | Tax Base/Original Tax Base in Second Local Currency | ||
| TXBH3 | TXBH3 | CURR | 13(2) | Tax Base/Original Tax Base in Third Local Currency | ||
| PPRCT | PPRCTR | CHAR | 10 | CEPC | Partner Profit Center | ALPHA |
| XREF1 | XREF1 | CHAR | 12 | Business partner reference key | ||
| XREF2 | XREF2 | CHAR | 12 | Business partner reference key | ||
| KBLNR | KBLNR_FI | CHAR | 10 | KBLK | Document Number for Earmarked Funds | ALPHA |
| KBLPOS | KBLPOS | NUMC | 3 | KBLP | Earmarked Funds: Document Item | |
| STTAX | STTAX | CURR | 13(2) | Tax amount as statistical information in document currency | ||
| FKBER | FKBER_SHORT | CHAR | 4 | Functional Area | ||
| OBZEI | OBZEI | NUMC | 3 | Number of Line Item in Original Document | ||
| XNEGP | XNEGP | CHAR | 1 | Indicator: Negative posting | ||
| RFZEI | RFZEI_CC | NUMC | 3 | Payment Card Item | ||
| CCBTC | CCBTC | CHAR | 10 | Payment cards: Settlement run | ALPHA | |
| KKBER | KKBER | CHAR | 4 | T014 | Credit control area | |
| EMPFB | EMPFB | CHAR | 10 | Payee/Payer | ALPHA | |
| XREF3 | XREF3 | CHAR | 20 | Reference key for line item | ||
| DTWS1 | DTAT16 | NUMC | 2 |
* | Instruction key 1 | |
| DTWS2 | DTAT17 | NUMC | 2 |
* | Instruction key 2 | |
| DTWS3 | DTAT18 | NUMC | 2 |
* | Instruction key 3 | |
| DTWS4 | DTAT19 | NUMC | 2 |
* | Instruction key 4 | |
| GRICD | J_1AGICD_D | CHAR | 2 | J_1AGICD | Activity Code for Gross Income Tax | |
| GITYP | J_1ADTYP_D | CHAR | 2 | J_1ADTYP | Distribution Type for Employment Tax | |
| XPYPR | XPYPR | CHAR | 1 | Indicator: Items from Payment Program Blocked | ||
| KIDNO | KIDNO | CHAR | 30 | Payment Reference | ||
| ABSBT | ABSBT | CURR | 13(2) | Credit management: Hedged amount | ||
| IDXSP | J_1AINDXSP | CHAR | 5 | J_1AINFT20 | Inflation Index | |
| LINFV | J_1ALINFVL | DATS | 8 | Last Adjustment Date | ||
| KONTT | KONTT_FI | CHAR | 2 | Account Assignment Category for Industry Solution | ||
| KONTL | KONTL_FI | CHAR | 50 | Acct assignment string for industry-specific acct assignmnts | ||
| TXDAT | TXDAT | DATS | 8 | Date for defining tax rates | ||
| AGZEI | AGZEI | DEC | 5 | Clearing Item | ||
| PYCUR | PYCUR | CUKY | 5 | TCURC | Currency for Automatic Payment | |
| PYAMT | PYAMT | CURR | 13(2) | Amount in Payment Currency | ||
| BUPLA | BUPLA | CHAR | 4 | J_1BBRANCH | Business Place | |
| SECCO | SECCO | CHAR | 4 | SECCODE | Section Code | |
| LSTAR | LSTAR | CHAR | 6 |
* | Activity Type | |
| CESSION_KZ | CESSION_KZ | CHAR | 2 | TCESSION | Accounts Receivable Pledging Indicator | |
| PRZNR | CO_PRZNR | CHAR | 12 |
* | Business Process | ALPHA |
| PPDIFF | PPDIFF | CURR | 13(2) | Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) | ||
| PPDIF2 | PPDIF2 | CURR | 13(2) | Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) | ||
| PPDIF3 | PPDIF3 | CURR | 13(2) | Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) | ||
| PENLC1 | PENALTY1 | CURR | 13(2) | Penalty charge amount in first local currency | ||
| PENLC2 | PENALTY2 | CURR | 13(2) | Penalty charge amount in second local currency | ||
| PENLC3 | PENALTY3 | CURR | 13(2) | Penalty Charge Amount in Third Local Currency | ||
| PENFC | PENALTY | CURR | 13(2) | Penalty charge amount in document currency | ||
| PENDAYS | PDAYS | INT4 | 10 | Number of days for penalty charge calculation | ||
| PENRC | PENRC | CHAR | 2 | Reason for late payment | ||
| GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | Grant | ALPHA | |
| SCTAX | SCTAX | CURR | 13(2) | Tax portion FI-CA local currency | ||
| FKBER_LONG | FKBER | CHAR | 16 |
* | Functional Area | |
| GMVKZ | FM_GMVKZ | CHAR | 1 | Item is in Execution | ||
| SRTYPE | FM_SRTYPE | CHAR | 2 | Type of Additional Receivable | ||
| INTRENO | VVINTRENO | CHAR | 13 | Internal Real Estate Master Data Code | ||
| MEASURE | FM_MEASURE | CHAR | 24 |
* | Funded Program | |
| AUGGJ | AUGGJ | NUMC | 4 | Fiscal Year of Clearing Document | GJAHR | |
| PPA_EX_IND | EXCLUDE_FLG | CHAR | 1 | PPA Exclude Indicator | ||
| DOCLN | DOCLN6 | CHAR | 6 | Six-Character Posting Item for Ledger | ||
| SEGMENT | FB_SEGMENT | CHAR | 10 |
* | Segment for Segmental Reporting | ALPHA |
| PSEGMENT | FB_PSEGMENT | CHAR | 10 |
* | Partner Segment for Segmental Reporting | ALPHA |
| PFKBER | SFKBER | CHAR | 16 |
* | Partner Functional Area | |
| HKTID | HKTID | CHAR | 5 | T012K | ID for account details | |
| KSTAR | KSTAR | CHAR | 10 |
* | Cost Element | ALPHA |
| XLGCLR | XLGCLR | CHAR | 1 | Clearing Specific to Ledger Groups | ||
| TAXPS | TAX_POSNR | NUMC | 6 | Tax document item number | ||
| PAYS_PROV | COM_WEC_PAYMENT_SRV_PROVIDER | CHAR | 4 |
* | Payment Service Provider | |
| PAYS_TRAN | FPS_TRANSACTION | CHAR | 35 | Payment Reference of Payment Service Provider | ||
| MNDID | SEPA_MNDID | CHAR | 35 | Unique Referene to Mandate per Payment Recipient | ||
| XFRGE_BSEG | XFRGE_BSEG | CHAR | 1 | Payment Is Released | ||
| .APPEND | ACL_BSEG | Cash Ledger: Additional Account Assignments | ||||
| RE_BUKRS | FAGL_RE_BUKRS | CHAR | 4 |
* | Cash Ledger: Company Code for Expense/Revenue | |
| RE_ACCOUNT | FAGL_RE_ACCOUNT | CHAR | 10 |
* | Cash Ledger: Expense or Revenue Account | ALPHA |
| .APPEND | EHP4_FM | Funds Management EHP4 | ||||
| PGEBER | FM_PFUND | CHAR | 10 |
* | Partner Fund | |
| PGRANT_NBR | GM_GRANT_PARTNER | CHAR | 20 | Partner Grant | ALPHA | |
| .APPEND | EHP4_FMBP | FM: Budget Period | ||||
| BUDGET_PD | FM_BUDGET_PERIOD | CHAR | 10 |
* | FM: Budget Period | |
| PBUDGET_PD | FM_PBUDGET_PERIOD | CHAR | 10 |
* | FM: Partner Budget Period | |
| .APPEND | FMFG_BSEG | FMFG: US Federal Specific Fields | ||||
| PEROP_BEG | FM_PEROP_FI_LOW | DATS | 8 | Billing Period of Performance Start Date | ||
| PEROP_END | FM_PEROP_FI_HIGH | DATS | 8 | Billing Period of Performance End Date | ||
| FASTPAY | FMFG_FASTPAY_FLG | CHAR | 1 | PPA Fast Pay Indicator | ||
| IGNR_IVREF | FMFG_IGNORE_INV_REF | CHAR | 1 | FMFG: Ignore the invoice reference during FI doc splitting | ||
| .APPEND | FMFS_REFERENCE | Funds Management Actual Data Reference Document | ||||
| .INCLUDE | FMIXREF | Funds Management Actual Data Reference Document | ||||
| FMXDOCNR | FM_XDOCNR | CHAR | 10 | FM Reference Document Number | ALPHA | |
| FMXYEAR | FM_XYEAR | NUMC | 4 | FM Reference Year | GJAHR | |
| FMXDOCLN | FM_XDOCLN | NUMC | 6 | FM Reference Line Item | ||
| FMXZEKKN | FM_XZEKKN | NUMC | 5 | FM Reference Sequence Account Assignment | ||
| .APPEND | JVA_BSEG | Joint Venture addtional doucment fields | ||||
| PRODPER | JV_PRODPER | DATS | 8 | Production Month (Date to find period and year) | ||
| Key field | |
| Non-key field |
BSEG relationships with other tables
PAKET_RRLREC-Remuneration List Recipient
DOCUMENTS-Documents for Remuneration List Recipient
DYNSEL-Selektionsdaten
FOREIGNKEY_SEL-Selection on foreign key
V_RRLE_REL-Relevant Documents
V_RRLEE_REL-Relevant External Docs
VBRK-Relevant SD Billing Docs
BKPF-Relevant AC Document Headers
BSEG-Relevant AC Document Lines
MARA-Material Master: General Data
MBEW-Material Valuation
MKPF-Header: Material Document
MSEG-Document Segment: Material
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
BOSG-Uppermost Hierarchy Segment for BRF
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
BSET-Tax Data Document Segment
FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
KNA1-General Data in Customer Master
KNBK-Customer Master (Bank Details)
KNB1-Customer Master (Company Code)
KNB4-Customer Payment History
KNB5-Customer Master (Dunning Data)
KNKK-Credit Management Cust. Mstr: Control Area Data
KNC1-Customer Master (Transaction Figures)
KNC3-Customer Master (Special G/L Transaction Figures)
LFA1-Vendor Master (General Section)
LFBK-Vendor Master (Bank Details)
LFB1-Vendor Master (Company Code)
LFB5-Vendor Master (Dunning Data)
LFC1-Vendor Master (Transaction Figures)
LFC3-Vendor Master (Transaction Figures) Special Ledger
SKA1-G/L Account Master Record (Chart of Accounts)
SKB1-G/L Account Master Record (Company Code)
SKC1A-G/L Sales Segment Derived from GLDB - Internal
SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-
BKPF-Accounting Document Header
BSET-Tax Data Document Segment
BSEG-Accounting Document Segment
BSEC-One-Time Account Data Document Segment
EKKO-Purchasing Document Header
EKPO-Purchasing Document Item
EKBE-Purchasing Document History
KNA1-General Data in Customer Master
ADDR1_VAL-Address Data
KNAS-Customer Master (VAT Registration Nos Gen. Sel.)
KNKA-Customer Master Credit Management: Central Data
KNKK-Credit Management Cust. Mstr: Control Area Data
KNBK-Customer Master (Bank Details)
KNB1-Customer Master (Company Code)
KNB4-Customer Payment History
KNB5-Customer Master (Dunning Data)
KNC1-Customer Master (Transaction Figures)
KNC3-Customer Master (Special G/L Transaction Figures)
BSID-Accounting: Secondary Index for Customers
ADMI_FILES-Archive Files
BSIDEXT-Secondary Index & Additions Section (bsega)
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
GSEG-Offsetting Items for B-Segment in Reporting
LFA1-Vendor Master (General Section)
ADDR1_VAL-Address Data
LFAS-Vendor Master (General Part EU Tax Number)
LFBK-Vendor Master (Bank Details)
LFB1-Vendor Master (Company Code)
LFB5-Vendor Master (Dunning Data)
LFC1-Vendor Master (Transaction Figures)
LFC3-Vendor Master (Transaction Figures) Special Ledger
BSIK-Accounting: Secondary Index for Vendors
ADMI_FILES-Archive Files
BSIKEXT-Secondary Index & Additions Section (BSEGA)
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
GSEG-Offsetting Items for B-Segment in Reporting
SKA1-G/L Account Master Record (Chart of Accounts)
SKB1-G/L Account Master Record (Company Code)
SKC1A-G/L Sales Segment Derived from GLDB - Internal
SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-
FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
BSIS-Accounting: Secondary Index for G/L Accounts
ADMI_FILES-Archive Files
BSISEXT-Secondary Index & Additions Section (BSEGA)
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
GSEG-Offsetting Items for B-Segment in Reporting
