The BWPOSI table in SAP ERP or S/4HANA stores Valuations for Open Items data. There are total 30 fields in BWPOSI 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 BWPOSI table. It is in Financial Accounting “Basis” (FBAS) ABAP package and is part of the Financial Accounting (FI) module.
SAP BWPOSI Table Fields
Following is the list of fields that are available in SAP BWPOSI 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), ITEM (Sequence Number).
| 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) | |
| ITEM | Sequence Number | LFDNR | CHAR (3) | |
| PROV_ID | Provision Content | F107_PROV_ID | CHAR (30) | |
| METHD_P | Calculation Method | F107_METHD_P | CHAR (4) | |
| START_DATE | Start of Maturity | F107_START_DATE | DATS (8) | |
| END_DATE | End of Maturity | F107_END_DATE | DATS (8) | |
| ACTION_ID | Assignment of Transaction Type to Action for Manual Postings | F107_ACTION_MT2A | CHAR (2) | |
| TRANSACTION_TYPE | Transaction Type Follow-On Action | F107_ACTION_RMVCT | * | CHAR (3) |
| ID | Follow-Up Action After Manual Action | F107_ACTION_A2MT | CHAR (2) | |
| AMOUNT | Amount for Calculation | F107_ACTION_AMOUNT | CURR (23) | |
| AMOUNT_CALC | Partial Amount Calculated for Valuation | F107_ACTION_AMOUNT_CALC | CURR (23) | |
| CURRENCY | Currency Key | WAERS | * | CUKY (5) |
| ACC_ID_DEBIT | Transaction Key: Debit | F107_ACC_ID_DEBIT | CHAR (3) | |
| ACC_ID_CREDIT | Transaction Key: Credit | F107_ACC_ID_CREDIT | CHAR (3) | |
| EFFECTIVE_DATE | Effective Date | F107_ACTION_EFFECTIVE_DATE | DATS (8) | |
| CALCULATED_FROM | Calculation of Discounting – From Date | F107_ACTION_CALC_FROM | DATS (8) | |
| ZINSO | Debit Interest Rate | DZINSO | DEC (7) | |
| INDICATOR | Interest Indicator | VZSKZ | * | CHAR (2) |
