The BWPOS table in SAP ERP or S/4HANA stores Valuations for Open Items data. There are total 66 fields in BWPOS table. The Valuations for Open Items table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BWPOS table. It is in RF reporting (FREP) ABAP package and is part of the Information System (FI-GL-IS) module.
SAP BWPOS Table Fields
Following is the list of fields that are available in SAP BWPOS table. The primary key fields of the table are MANDT (Client), LAUFD (Date on Which the Program Is to Be Run), LAUFI (Additional Identification), UMBWM (Valuation Methods in Financial Accounting), ZBUKR (Target Company Code for Evaluation), GRUPPE (Valuation Group), KOART (Account type), KUNNR (Customer Number), LIFNR (Account Number of Vendor or Creditor), BUKRS (Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUZEI (Number of Line Item Within Accounting Document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| LAUFD | Date on Which the Program Is to Be Run | LAUFD | DATS (8) | |
| LAUFI | Additional Identification | LAUFI | CHAR (6) | |
| UMBWM | Valuation Methods in Financial Accounting | UMBWM | CHAR (3) | |
| ZBUKR | Target Company Code for Evaluation | ALLGZBUKR | CHAR (4) | |
| GRUPPE | Valuation Group | BEWGRP | CHAR (40) | |
| KOART | Account type | KOART | CHAR (1) | |
| KUNNR | Customer Number | KUNNR | CHAR (10) | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| BUKRS | Company Code | BUKRS | CHAR (4) | |
| BELNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) | |
| HKONT | General Ledger Account | HKONT | CHAR (10) | |
| BWBER | Valuation Area for FI Year-End Closing | BWBER | CHAR (2) | |
| GSBER | Business Area | GSBER | CHAR (4) | |
| VBUND | Company ID | VBUND | CHAR (6) | |
| XBLNR | Reference Document Number | XBLNR1 | CHAR (16) | |
| ZUONR | Assignment number | DZUONR | CHAR (18) | |
| BUDAT | Posting Date in the Document | BUDAT | DATS (8) | |
| BLDAT | Document Date in Document | BLDAT | DATS (8) | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS (8) | |
| FAEDT | Net Due Date | NETDT | DATS (8) | |
| BLART | Document Type | BLART | CHAR (2) | |
| BSCHL | Posting Key | BSCHL | CHAR (2) | |
| MSCHL | Dunning Key | MSCHL | CHAR (1) | |
| MANSP | Dunning Block | MANSP | CHAR (1) | |
| MABER | Dunning Area | MABER | CHAR (2) | |
| MADAT | Date of Last Dunning Notice | MADAT | DATS (8) | |
| UMSKS | Special G/L Transaction Type | UMSKS | CHAR (1) | |
| UMSKZ | Special G/L Indicator | UMSKZ | CHAR (1) | |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR (1) | |
| WAERS | Currency Key | WAERS | CUKY (5) | |
| DMSHB | Amount in Local Currency with +/- Signs | DMSHB | CURR (23) | |
| WRSHB | Foreign Currency Amount with Signs (+/-) | WRSHB | CURR (23) | |
| REBZG | Document No. of the Invoice to Which the Transaction Belongs | REBZG | CHAR (10) | |
| REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC (4) | |
| REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC (3) | |
| LAND1 | Country/Region Key | LAND1 | CHAR (3) | |
| TAX_COUNTRY | Tax Reporting Country | FOT_TAX_COUNTRY | CHAR (3) | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR (2) | |
| DMSHB_BAS | Base Amount in Local Currency | DMSHB_BAS | CURR (23) | |
| X_BSBM | Valuation Difference Was Entered Separately | BSBM_X | CHAR (1) | |
| WBRSL | Value Adjustment Key | WBRSL | CHAR (2) | |
| OVDUE | Days Overdue | OVDUE | NUMC (3) | |
| ZINSO | Debit Interest Rate | DZINSO | DEC (7) | |
| XMANU | Valuate Items Manually | XMANU_F107 | CHAR (1) | |
| XEXTR | Indicator for External Valuation | EXTERN_F107 | CHAR (1) | |
| PWBTR | Flat-Rate Value for Value Adjustment | PWBTR | CURR (23) | |
| BWSHB_GROS | Gross Valuation Difference | BWSHB_B | CURR (23) | |
| BWSHB_OLD | Old Valuation Difference | BWSHB_O | CURR (23) | |
| BWSHB_NET | Valuation Difference | BWSHB | CURR (23) | |
| XCLEAR | Credit Memo(s) Offset (Cleared) Against Invoice | XCLEAR_F107 | CHAR (1) | |
| FUTURE | Future | FFUTURE | CHAR (1) | |
| RMVCT | Transaction type | RMVCT | CHAR (3) | |
| BWSHB_NET_REM2 | Valuation Difference | BWSHB | CURR (23) | |
| BWSHB_GROS_REM2 | Gross Valuation Difference | BWSHB_B | CURR (23) | |
| BWSHB_OLD_REM2 | Old Valuation Difference | BWSHB_O | CURR (23) | |
| BWSHB_NET_REM3 | Valuation Difference | BWSHB | CURR (23) | |
| BWSHB_GROS_REM3 | Gross Valuation Difference | BWSHB_B | CURR (23) | |
| BWSHB_OLD_REM3 | Old Valuation Difference | BWSHB_O | CURR (23) | |
| FILKD | Account Number of the Branch | FILKD | CHAR (10) | |
| XCUST_VERR | Single-Character Flag | CHAR1 | CHAR (1) | |
| CUST_VERR_TXT | Comment | CHAR50 | CHAR (50) | |
| TXT | Comment | CHAR50 | CHAR (50) |
