DBWBHI_COM SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




Table View field list including key, data, relationships and ABAP select examples

DBWBHI_COM is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The DBWBHI_COM table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include TKONN (Trading Contract: Trading Contract Number), KUNNR (Sold-to party), VKORG (Sales Organization), VTWEG (Distribution Channel).. 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 DBWBHI_COM table view 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 MANDTCLNT3T000MANDT
TKONNTrading Contract: Trading Contract Number TKONNCHAR10ALPHATKONNWKNWBHK
KUNNRSold-to party KUNAGCHAR10KNA1ALPHAKUNNRVAG
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVKOVVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TVTASPARTSPAC_SPART
TCTYPTrading Contract: Trading Contract Type TCTYPCHAR4TB2BETCTYPWKA
BTBSTATrading Contract: Application Status BTBSTACHAR1TB2BABTBSTA
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
TKSACHBTrading Contract: Person Responsible TKSACHBCHAR12UNAME
BSTNKCustomer purchase order number BSTNKCHAR20BSTNK
SDWRSSD Document Currency WAERKCUKY5TCURCWAERSFWS
BUDATPosting Date in the Document BUDATDATS8DATUM
AUGRUOrder reason (reason for the business transaction) AUGRUCHAR3TVAUAUGRU
AUDATDocument Date (Date Received/Sent) AUDATDATS8DATUM
SUBMI_SDCollective number (SD) SUBMI_SDCHAR10CHAR10
LIFSK_SDDelivery block (document header) LIFSKCHAR2TVLSLIFSP
FAKSK_SDBilling block in SD document FAKSKCHAR2TVFSFAKSP
NETWR_SDNet Value of the Sales Order in Document Currency NETWR_AKCURR15(2) WERTV8
VKGRPSales Group VKGRPCHAR3TVBVKVKGRPVKG
VKBURSales Office VKBURCHAR4TVKBZVKBURVKB
VSBED_SDShipping Conditions VSBEDCHAR2TVSBVSBED
ELIFNVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
IHREZYour Reference IHREZCHAR12TEXT12
EBDATPurchasing Document Date EBDATDATS8DATUM
EINDTTrading Contract: Delivery Date for Item Purchasing WB2_DELDATE_MMDATS8DATUM
WAERS_PURCHCurrency Key WAERSCUKY5TCURCWAERSFWS
ZTERMTerms of Payment Key Purchasing WB2_DZTERM_MMCHAR4ZTERM
VALDTFixed value date VALDTDATS8DATUM
WERK_MMPlant WERKS_DCHAR4WERKSWRKH_T001W_C
ZTERM_SALESTerms Of Payment Key Sales WB2_DZTERM_SDCHAR4ZTERM
VALDTDFixed value date VALDTDATS8DATUM
ZLSCHPayment Method SCHZW_BSEGCHAR1T042ZZLSCH
COMPLETETrading Contract: Document is Complete HKCOMCHAR1FLAG
QUAN_COMPLETETrading Contract: Quantities In Document Are Complete HKCOM_QUANCHAR1FLAG
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
CHARGBatch Number CHARG_DCHAR10CHARGCHA
MATKLMaterial Group MATKLCHAR9MATKLMKLS_WBWG
TKWAERSTrading Contract: Currency of Trading Contract TKWAERSCUKY5TCURCWAERS
TKONN_EXTrading Contract: External Document Number TKONN_EXCHAR30TKONN_EXWKN_EX
TC_RELEASEDRelease Status for Follow-On Document Generation TC_RELEASEDCHAR1TC_RELEASED
TCCATTrading Contract: Contract Category TCCATCHAR1TCCATTCCAT
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
CONSOL_IT_EXISTConsolidated item exists WB2_CONSOL_ITEM_EXISTCHAR1WB2_CONSOL_ITEM_EXIST
CONSOLIDATEDItem is consolidated WB2_CONSOLIDATEDCHAR1BVALD
RESWKSupplying (Issuing) Plant in Stock Transport Order RESWKCHAR4T001WWERKS
CREATED_FROMSource document type WB2_CREATED_FROMCHAR2WB2_CREATED_FROM
LOEKZDeletion Indicator in Trading Contract WB2_DEL_INDCHAR1XFELD
TPOSNTrading Contract: Item Number TPOSNNUMC6TPOSNWKP
USE_CASEUse Case Type WB2_USE_CASE_TYPECHAR2WB2_USE_CASE_TYPE
DATE_FROMDate From WLF_DATE_FROMDATS8DATUM
DATE_TODate To WLF_DATE_TODATS8DATUM
FUTUREFuture WLF_FUTURECHAR20WLF_FUTURE
IT_CLOSEDItem Closed WLF_ITEM_CLOSEDCHAR1WLF_ITEM_CLOSED
COM_CATCommodity Item Category WLF_COM_ITEM_CATCHAR4WLF_COM_ITEM_CAT
ASSGMT_RELAssignment Relevant WLF_ASSGMT_RELCHAR1BVALD
EXT_REFExternal Identifier for Commodity Item WLF_EXT_IDENTIFIER_COMCHAR10CHAR10
PURPOSEPurpose of Trading Contract WB2_TC_PURPOSECHAR2WB2_TC_PURPOSE
HKPSTPTrading Contract: Item Category HKPSTPCHAR4TB2BKHKPSTP

Key field Non-key field



How do I retrieve data from SAP table DBWBHI_COM using ABAP code

The following ABAP code Example will allow you to do a basic selection on DBWBHI_COM to SELECT all data from the table
DATA: WA_DBWBHI_COM TYPE DBWBHI_COM.

SELECT SINGLE *
FROM DBWBHI_COM
INTO CORRESPONDING FIELDS OF WA_DBWBHI_COM
WHERE...

How to access SAP table DBWBHI_COM

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