V_SONU SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

V_SONU 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 V_SONU table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include LOCNR (Customer Numbers), EROED (Opening date), SCHLD (Closing date), SPDAB (Block from).. 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 V_SONU 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
LOCNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
EROEDOpening date EROEDDATS8DATUM
SCHLDClosing date SCHLDDATS8DATUM
SPDABBlock from SPDABDATS8DATUM
SPDBIBlock to SPDBIDATS8DATUM
AUTOBAutomatic purchase order AUTOBCHAR1CHAR001
KOPROPOS outbound profile POSKOPROCHAR4TWPFIPOSKOPRO
LAYVRLayout LAYVARCHAR10TWGVLAYVAR
FLVARArea schema FLVARCHAR4TWGFFLVAR
STFAKCalendar STKALCHAR2TFACDWFCID
VERFLSales area (floor space) VERFL_WWSQUAN6VERFL_WWS
VERFESales area (floor space) unit VERFE_WWSUNIT3T006CUNITMEINS
SPGR1Blocking reason SPGR1CHAR2TWRF11SPGR1
INPROPOS inbound profile POSINTPROFCHAR4TWPISPOSINTPROF
EKOARPOS outbound: condition type group POSEKOARCHAR4TWPPKPOSEKOAR
BETRPPlant profile BETRPCHAR4TWRF2BETRPKGP
BWWRKPlant for retail price determination BWWRKCHAR4T001WWERKS
BWVKOSales organization for retail price determination BWVKOCHAR4TVKOVKORG
BWVTWDistribution channel for retail price determination BWVTWCHAR2TVTWVTWEG
BBPROAssortment list profile BBPROCHAR4TWBPBBPRO
VKBUR_WRKSales office VKBUR_WRKCHAR4VKBURVKB
VLFKZPlant category VLFKZCHAR1VLFKZ
LIGRDBasic listing rule for assortments WLIGRDCHAR1WLIGRD
VKORGSales organization for intercompany billing VKOIVCHAR4TVKOVKORGVKO
VTWEGDistribution channel for intercompany billing VTWIVCHAR2TVTWVTWEGVTW
KNAZKWorking Time Calendar KNAZKCHAR2TFACDWFCID
KTOKDCustomer Account Group KTOKDCHAR4T077DKTOKDKGD
KUKLACustomer classification KUKLACHAR2TKUKLKUKLA
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
NAME1Name 1 NAME1_GPCHAR35NAME
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
KATR1Attribute 1 KATR1CHAR2TVK1ATTR1
KATR2Attribute - 2 KATR2CHAR2TVK2ATTR2
KATR3Attribute 3 KATR3CHAR2TVK3ATTR3
KATR4Attribute 4 KATR4CHAR2TVK4ATTR4
KATR5Attribute 5 KATR5CHAR2TVK5ATTR5
KATR6Attribute 6 KATR6CHAR3TVK6ATTR6
KATR7Attribute 7 KATR7CHAR3TVK7ATTR7
KATR8Attribute 8 KATR8CHAR3TVK8ATTR8
KATR9Attribute 9 KATR9CHAR3TVK9ATTR9
KATR10Attribute 10 KATR10CHAR3TVK0ATTR10
TXJCDTax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
HZUORAssignment to Hierarchy HZUORNUMC2HZUOR
ETIKGIS-R Labeling: customer/plant group ETIKGCHAR10TWEKETIKG

Key field Non-key field



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

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

SELECT SINGLE *
FROM V_SONU
INTO CORRESPONDING FIELDS OF WA_V_SONU
WHERE...

How to access SAP table V_SONU

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