TXW_VENDOR SAP (Vendor master) Structure details

Dictionary Type: Structure
Description: Vendor master




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




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

TXW_VENDOR 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 "Vendor master" 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_VENDOR TYPE TXW_VENDOR.

The TXW_VENDOR table consists of various fields, each holding specific information or linking keys about Vendor master data available in SAP. These include BUKRS (Company Code), LIFNR (Account Number of Vendor or Creditor), NAME1 (Name 1), NAME2 (Name 2).. 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: Can be enhanced (character-type)


SAP TXW_VENDOR 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
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
NAME1Name 1 TXW_NAME1CHAR40TEXT40
NAME2Name 2 TXW_NAME2CHAR40TEXT40
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
STRASStreet TXW_STRASCHAR60TEXT60
ORT01City TXW_ORT01CHAR40TEXT40
ORT02District TXW_ORT02CHAR40TEXT40
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
LAND1Country Key LAND1_GPCHAR3Assigned to domainLAND1C_LAND1
PSTLZPostal Code PSTLZCHAR10PSTLZ
PFACHPO Box PFACHCHAR10PFACH
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
XZEMPIndicator: Alternative payee in document allowed ? XZEMPCHAR1XFELD
LNRZBAccount number of the alternative payee LNRZBCHAR10Assigned to domainALPHALIFNR
AKONTReconciliation Account in General Ledger AKONTCHAR10Assigned to domainALPHASAKNR
XVERRIndicator: Clearing between customer and vendor? XVERR_LFB1CHAR1XFELD
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
QSZDTValidity Date for Withholding Tax Exemption Certificate QSZDTDATS8DATUM
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
QSRECVendor Recipient Type QSRECCHAR2Assigned to domainQSREC
QSBGRAuthority for Exemption from Withholding Tax QSBGRCHAR1QSBGR
QLANDWithholding Tax Country Key QLANDCHAR3Assigned to domainQLAND
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
LNRZEHead office account number LNRZECHAR10Assigned to domainALPHALIFNR
ADRNRAddress ADRNRCHAR10Assigned to domainALPHAADRNR
BRSCHIndustry key BRSCHCHAR4Assigned to domainBRSCH
KTOKKVendor account group KTOKKCHAR4Assigned to domainKTOKKKGK
MINDKMinority Indicators MINDKCHAR3Assigned to domainMINDK
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
FISKUTax Authority TXW_FISKUCHAR10Assigned to domainALPHALIFNR
STENRTax code TXW_STENRCHAR18CHAR18
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
HOUSE_NUM1House Number TXW_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement TXW_HSNM2CHAR10TEXT10
NAME3Name 3 TXW_NAME3CHAR40TEXT40
NAME4Name 4 TXW_NAME4CHAR40TEXT40

Key field Non-key field



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

As TXW_VENDOR 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_VENDOR as there is no data to select.

How to access SAP table TXW_VENDOR

Within an ECC or HANA version of SAP you can also view further information about TXW_VENDOR 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!