S004BIWS SAP (S004BIWS * SIS: Product/Sales organization/Dist. Channel) Structure details

Dictionary Type: Structure
Description: S004BIWS * SIS: Product/Sales organization/Dist. Channel




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




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

S004BIWS 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 "S004BIWS * SIS: Product/Sales organization/Dist. Channel" 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_S004BIWS TYPE S004BIWS.

The S004BIWS table consists of various fields, each holding specific information or linking keys about S004BIWS * SIS: Product/Sales organization/Dist. Channel data available in SAP. These include WRTTP (Value type for Reporting), VRSIO (Version number in the information structure), SPMON (Calendar year / month), SPTAG (Calendar day).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP S004BIWS 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
STORNOIndicator: Data to Be Canceled STORNOCHAR1CHAR1_X
WRTTPValue type for Reporting RSVTYPENUMC3Assigned to domainRSVTYPE
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONCalendar year / month RSCALMONTHNUMC6PERI6RSCALMONTH
SPTAGCalendar day RSCALDAYDATS8DATUM
SPWOCCalendar year / week RSCALWEEKNUMC6PERI6RSCALWEEK
SPBUPFiscal year / period RSFISCPERNUMC7PERI7RSFISCPER
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
STWAEStatistics currency WAERS_VCUKY5Assigned to domainWAERS
BASMEBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
AENETWRNet value of incoming orders MC_AENETWRCURR19(2) WERTV10
RENETWRNet value of incoming returns MC_RENETWRCURR19(2) WERTV10
OAUWEOpen net value of orders MC_OAUWECURR19(2) WERTV10
UMNETWRNet value of invoiced sales MC_UMNETWRCURR19(2) WERTV10
GUNETWRNet value of credit memos MC_GUNETWRCURR19(2) WERTV10
AEKZWI1Incoming orders: gross MC_AEKZWI1CURR17(2) WERTV9
AEKZWI2Incoming orders: net 1 MC_AEKZWI2CURR17(2) WERTV9
AEKZWI3Incoming orders: net 2 MC_AEKZWI3CURR17(2) WERTV9
AEKZWI4Incoming orders: freight MC_AEKZWI4CURR17(2) WERTV9
AEKZWI5Incoming orders: pricing subtotal 5 MC_AEKZWI5CURR17(2) WERTV9
AEKZWI6Incoming orders: pricing subtotal 6 MC_AEKZWI6CURR17(2) WERTV9
REKZWI1Incoming returns: gross MC_REKZWI1CURR17(2) WERTV9
REKZWI2Incoming returns: net 1 MC_REKZWI2CURR17(2) WERTV9
REKZWI3Incoming returns: net 2 MC_REKZWI3CURR17(2) WERTV9
REKZWI4Incoming returns: freight MC_REKZWI4CURR17(2) WERTV9
REKZWI5Incoming returns: pricing subtotal 5 MC_REKZWI5CURR17(2) WERTV9
REKZWI6Incoming returns: pricing subtotal 6 MC_REKZWI6CURR17(2) WERTV9
UMKZWI1Invoiced sales: gross MC_UMKZWI1CURR17(2) WERTV9
UMKZWI2Invoiced sales: net 1 MC_UMKZWI2CURR17(2) WERTV9
UMKZWI3Invoiced sales: net 2 MC_UMKZWI3CURR17(2) WERTV9
UMKZWI4Invoice freight charges MC_UMKZWI4CURR17(2) WERTV9
UMKZWI5Billing document: pricing subtotal 5 MC_UMKZWI5CURR17(2) WERTV9
UMKZWI6Billing document: pricing subtotal 6 MC_UMKZWI6CURR17(2) WERTV9
GUKZWI1Credit memos: gross MC_GUKZWI1CURR17(2) WERTV9
GUKZWI2Credit memos: net 1 MC_GUKZWI2CURR17(2) WERTV9
GUKZWI3Credit memos: net 2 MC_GUKZWI3CURR17(2) WERTV9
GUKZWI4Credit memos: freight MC_GUKZWI4CURR17(2) WERTV9
GUKZWI5Credit memos: pricing subtotal 5 MC_GUKZWI5CURR17(2) WERTV9
GUKZWI6Credit memos: pricing subtotal 6 MC_GUKZWI6CURR17(2) WERTV9
ANZAUPOSNumber of order items MC_ANZAUPODEC9MCZAEHLER
ANZREPOSNo.of returns items MC_ANZREPODEC9MCZAEHLER
AEMENGEIncoming orders quantity MC_AEMENGEQUAN15(3) MENGV15_3
REMENGEReturns Quantity MC_REMENGEQUAN15(3) MENGV15_3
OAUMEOpen orders quantity in base unit of measure MC_OAUMEQUAN15(3) MENGV15_3
UMMENGESales quantity MC_UMMENGEQUAN15(3) MENGV15_3
GUMENGECredit memos quantity MC_GUMENGEQUAN15(3) MENGV15_3
AEWAVWRCost of incoming orders MC_AEWAVWRCURR19(2) WERTV10
REWAVWRIncoming returns: cost MC_REWAVWRCURR19(2) WERTV10
UMWAVWRCost of invoiced sales MC_UMWAVWRCURR19(2) WERTV10
GUWAVWRCredit memos: cost MC_GUWAVWRCURR19(2) WERTV10

Key field Non-key field



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

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

How to access SAP table S004BIWS

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