TXW_BWPOS SAP (Valuations for Open Items) Structure details

Dictionary Type: Structure
Description: Valuations for Open Items




ABAP Code to SELECT data from TXW_BWPOS
Related tables to TXW_BWPOS
Access table TXW_BWPOS




Structure field list including key, data, relationships and ABAP select examples

TXW_BWPOS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Valuations for Open Items" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TXW_BWPOS TYPE TXW_BWPOS.

The TXW_BWPOS table consists of various fields, each holding specific information or linking keys about Valuations for Open Items data available in SAP. These include 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).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP TXW_BWPOS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
LAUFDDate on Which the Program Is to Be Run LAUFDDATS8DATUM
LAUFIAdditional Identification LAUFICHAR6LAUFI
UMBWMValuation Methods in Financial Accounting UMBWMCHAR3UMBWM
ZBUKRTarget Company Code for Evaluation ALLGZBUKRCHAR4Assigned to domainBUKRS
GRUPPEValuation Group BEWGRPCHAR40CHAR40
KOARTAccount Type KOARTCHAR1KOART
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
BWBERValuation Area for FI Year-End Closing BWBERCHAR2Assigned to domainBWBERBWB
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
VBUNDCompany ID VBUNDCHAR6Assigned to domainALPHARCOMP
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
ZUONRAssignment Number DZUONRCHAR18ZUONR
BUDATPosting Date in the Document BUDATDATS8DATUM
BLDATDocument Date in Document BLDATDATS8DATUM
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
FAEDTDue Date for Net Payment NETDTDATS8DATUM
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
BSCHLPosting Key BSCHLCHAR2Assigned to domainBSCHL
MSCHLDunning key MSCHLCHAR1Assigned to domainMSCHL
MANSPDunning block MANSPCHAR1Assigned to domainMANSP
MABERDunning Area MABERCHAR2Assigned to domainMABER
MADATLast dunned on MADATDATS8DATUM
UMSKSSpecial G/L Transaction Type UMSKSCHAR1UMSKS
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
DMSHBAmount in Local Currency with +/- Signs TXW_DMSHBCHAR16CHAR16
WRSHBForeign Currency Amount with Signs (+/-) TXW_WRSHBCHAR16CHAR16
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
DMSHB_BASBase Amount in Local Currency TXW_DMSHBBASCHAR16CHAR16
X_BSBMValuation Difference was Entered Separately BSBM_XCHAR1XFELD
WBRSLValue Adjustment Key WBRSLCHAR2Assigned to domainWBRSL
OVDUEDays Overdue OVDUENUMC3NUMC3
ZINSODebit interest rate TXW_DZINSOCHAR10CHAR10
XMANUValuate items manually XMANU_F107CHAR1XFELD
XEXTRIndicator for External Valuation EXTERN_F107CHAR1CHAR1
PWBTRFlat-Rate Value for Value Adjustment TXW_PWBTRCHAR20CHAR20
BWSHB_GROSGross Valuation Difference TXW_BWSHBBCHAR20CHAR20
BWSHB_OLDOld Valuation Difference TXW_BWSHBOCHAR20CHAR20
BWSHB_NETValuation Difference TXW_BWSHBCHAR16CHAR16
XCLEARCredit Memo(s) Offset (Cleared) Against Invoice XCLEAR_F107CHAR1XFELD
FUTUREFuture FFUTURECHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure TXW_BWPOS using ABAP code?

As TXW_BWPOS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TXW_BWPOS as there is no data to select.

How to access SAP table TXW_BWPOS

Within an ECC or HANA version of SAP you can also view further information about TXW_BWPOS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!