BWPOS - Valuations for Open Items

Valuations for Open Items information is stored in SAP table BWPOS.
It is part of development package FREP in software component FI-GL-IS. This development package consists of objects that can be grouped under "RF reporting".

Fields for table BWPOS

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
LAUFD	Date on Which the Program Is to Be Run	X	LAUFD	DATS	16
LAUFI	Additional Identification	X	LAUFI	CHAR	12
UMBWM	Valuation Methods in Financial Accounting	X	UMBWM	CHAR	6
GRUPPE	Valuation Group	X	BEWGRP	CHAR	80
KOART	Account type	X	KOART	CHAR	2
KUNNR	Customer Number	X	KUNNR	CHAR	20
LIFNR	Account Number of Supplier	X	LIFNR	CHAR	20
BUKRS	Company Code	X	BUKRS	CHAR	8
BELNR	Document Number of an Accounting Document	X	BELNR_D	CHAR	20
GJAHR	Fiscal Year	X	GJAHR	NUMC	8
BUZEI	Number of Line Item Within Accounting Document	X	BUZEI	NUMC	6
HKONT	General Ledger Account		HKONT	CHAR	20
BWBER	Valuation Area for FI Year-End Closing		BWBER	CHAR	4
GSBER	Business Area		GSBER	CHAR	8
VBUND	Company ID		VBUND	CHAR	12
XBLNR	Reference Document Number		XBLNR1	CHAR	32
BUDAT	Posting Date in the Document		BUDAT	DATS	16
BLDAT	Document Date in Document		BLDAT	DATS	16
CPUDT	Day On Which Accounting Document Was Entered		CPUDT	DATS	16
FAEDT	Net Due Date		NETDT	DATS	16
BLART	Document Type		BLART	CHAR	4
BSCHL	Posting Key		BSCHL	CHAR	4
MSCHL	Dunning Key		MSCHL	CHAR	2
MANSP	Dunning Block		MANSP	CHAR	2
MABER	Dunning Area		MABER	CHAR	4
MADAT	Date of Last Dunning Notice		MADAT	DATS	16
UMSKS	Special G/L Transaction Type		UMSKS	CHAR	2
UMSKZ	Special G/L Indicator		UMSKZ	CHAR	2
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
WAERS	Currency Key		WAERS	CUKY	10
DMSHB	Amount in Local Currency with +/- Signs		DMSHB	CURR	12
WRSHB	Foreign Currency Amount with Signs (+/-)		WRSHB	CURR	12
REBZG	Document No. of the Invoice to Which the Transaction Belongs		REBZG	CHAR	20
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)		REBZJ	NUMC	8
REBZZ	Line Item in the Relevant Invoice		REBZZ	NUMC	6
LAND1	Country/Region Key		LAND1	CHAR	6
TAX_COUNTRY	Tax Reporting Country/Region		FOT_TAX_COUNTRY	CHAR	6
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4
TXDAT_FROM	Valid-From Date of the Tax Rate		FOT_TXDAT_FROM	DATS	16
DMSHB_BAS	Base Amount in Local Currency		DMSHB_BAS	CURR	12
X_BSBM	Valuation Difference Was Entered Separately		BSBM_X	CHAR	2
WBRSL	Value Adjustment Key		WBRSL	CHAR	4
OVDUE	Days Overdue		OVDUE	NUMC	6
XMANU	Valuate Items Manually		XMANU_F107	CHAR	2
XEXTR	Indicator for External Valuation		EXTERN_F107	CHAR	2
PWBTR	Flat-Rate Value for Value Adjustment		PWBTR	CURR	12
BWSHB_GROS	Gross Valuation Difference		BWSHB_B	CURR	12
BWSHB_OLD	Old Valuation Difference		BWSHB_O	CURR	12
BWSHB_NET	Valuation Difference		BWSHB	CURR	12
XCLEAR	Credit Memo(s) Offset (Cleared) Against Invoice		XCLEAR_F107	CHAR	2
FUTURE	Future		FFUTURE	CHAR	2
RMVCT	Transaction type		RMVCT	CHAR	6
BWSHB_NET_REM2	Valuation Difference		BWSHB	CURR	12
BWSHB_GROS_REM2	Gross Valuation Difference		BWSHB_B	CURR	12
BWSHB_OLD_REM2	Old Valuation Difference		BWSHB_O	CURR	12
BWSHB_NET_REM3	Valuation Difference		BWSHB	CURR	12
BWSHB_GROS_REM3	Gross Valuation Difference		BWSHB_B	CURR	12
BWSHB_OLD_REM3	Old Valuation Difference		BWSHB_O	CURR	12
FILKD	Account Number of the Branch		FILKD	CHAR	20
XCUST_VERR	Single-Character Flag		CHAR1	CHAR	2
CUST_VERR_TXT	Comment		CHAR50	CHAR	100
TXT	Comment		CHAR50	CHAR	100